Potgres query error
From time to time a im getting this kind of error ( after for example serving 2-3k requests), and after tha freeradius just hangs and takes 90% of CPU. I am using freeradius 1.1.6 with threads. I tried to make it happen again and log it but i could not meet such data, that causes the error. Maybe you have idea what is happening that error, and moreover why freeradius hangs. Tue Apr 24 13:22:40 2007 : Error: rlm_sql_postgresql: PostgreSQL Query failed Error: ERROR: invalid message format -- Dariusz Dwornikowski tdi@vercom.pl
I am getting more of that... What is happening. thread pool isbig enough, also the pg connection pool. Tue Apr 24 15:30:13 2007 : Error: rlm_sql_postgresql: PostgreSQL Query failed Error: Tue Apr 24 15:30:13 2007 : Auth: Login OK: [CMD chemx001 0126850030 chemx001@sip.itc.energis.pl/<no User-Password attribute>] (from client openser port 0) Tue Apr 24 15:30:13 2007 : Auth: Login OK: [CMD lloyd001 00442082067000 lloyd001@213.218.117.66/<no User-Password attribute>] (from client openser port 0) Tue Apr 24 15:30:13 2007 : Error: Discarding duplicate request from client openser:33770 - ID: 182 due to unfinished request 525 Tue Apr 24 15:30:14 2007 : Error: Discarding duplicate request from client openser:33771 - ID: 183 due to unfinished request 526 Tue Apr 24 15:30:14 2007 : Auth: Login OK: [CMD andrzejr001 0612810807 andrzejr001@sip.inotel.pl/<no User-Password attribute>] (from client openser port 0) Tue Apr 24 15:30:14 2007 : Error: Discarding duplicate request from client openser:33772 - ID: 184 due to unfinished request 527 Tue Apr 24 15:30:14 2007 : Auth: Login OK: [CMD promesa012 0413445101 promesa012@sip.inotel.pl/<no User-Password attribute>] (from client openser port 0) Tue Apr 24 15:30:14 2007 : Auth: Login OK: [CMD poligrafiap002 0618221153 poligrafiap002@sip.inotel.pl/<no User-Password attribute>] (from client openser port 0) Tue Apr 24 15:30:14 2007 : Auth: Login OK: [CMD komptom001 0426373848 komptom001@sip.ipfon.pl/<no User-Password attribute>] (from client openser port 0) Tue Apr 24 15:30:14 2007 : Error: Discarding duplicate request from client openser:33776 - ID: 187 due to unfinished request 530 On 2007-04-24, at 13:34, Dariusz Dwornikowski wrote:
From time to time a im getting this kind of error ( after for example serving 2-3k requests), and after tha freeradius just hangs and takes 90% of CPU. I am using freeradius 1.1.6 with threads. I tried to make it happen again and log it but i could not meet such data, that causes the error. Maybe you have idea what is happening that error, and moreover why freeradius hangs.
Tue Apr 24 13:22:40 2007 : Error: rlm_sql_postgresql: PostgreSQL Query failed Error: ERROR: invalid message format
-- Dariusz Dwornikowski tdi@vercom.pl
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/ users.html
-- Dariusz Dwornikowski tdi@vercom.pl
On Tue 24 Apr 2007, Dariusz Dwornikowski wrote:
I am getting more of that... What is happening. thread pool isbig enough, also the pg connection pool.
This is probably because your backend is getting too slow to keep up. Check that your indexes are correct, and that you have autovacuum enabled. Alternatively there could be a memory leak or something else nasty. Please check your memory stats... -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
On 2007-04-24, at 21:55, Peter Nixon wrote:
On Tue 24 Apr 2007, Dariusz Dwornikowski wrote:
I am getting more of that... What is happening. thread pool isbig enough, also the pg connection pool.
This is probably because your backend is getting too slow to keep up. Check that your indexes are correct, and that you have autovacuum enabled.
Alternatively there could be a memory leak or something else nasty. Please check your memory stats...
nope It is not database, It works very fast. There are indexes.
--
Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/ users.html
-- Dariusz Dwornikowski tdi@vercom.pl
participants (2)
-
Dariusz Dwornikowski -
Peter Nixon