Re: Unresponsive child for request

2010-03-19 Thread Mark Jones
for request Mark Jones wrote: I am getting this error in my logs and I understand it is do to likley an issue with sql but was wondering what the criteria for this error to be generrated is. Error: WARNING: Unresponsive child for request 271737, in module sqlzuul component accounting Basically I

Re: Unresponsive child for request

2010-03-19 Thread Alan DeKok
Mark Jones wrote: I agree.but I was currious as to how many seconds before it gives up? See max_request_time Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Unresponsive child for request

2010-03-18 Thread Mark Jones
I am getting this error in my logs and I understand it is do to likley an issue with sql but was wondering what the criteria for this error to be generrated is. Error: WARNING: Unresponsive child for request 271737, in module sqlzuul component accounting Basically I assume and sql query

RE: Unresponsive child for request

2010-03-18 Thread Gary Gatten
Of Mark Jones Sent: Thursday, March 18, 2010 3:03 PM To: FreeRadius users mailing list Subject: Unresponsive child for request I am getting this error in my logs and I understand it is do to likley an issue with sql but was wondering what the criteria for this error to be generrated is. Error

Re: Unresponsive child for request

2010-03-18 Thread Alan DeKok
Mark Jones wrote: I am getting this error in my logs and I understand it is do to likley an issue with sql but was wondering what the criteria for this error to be generrated is. Error: WARNING: Unresponsive child for request 271737, in module sqlzuul component accounting Basically I

Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting

2009-02-27 Thread magicboiz
Thx Alan I coded a very simple script to check the mysl server latency: #!/bin/sh ExecQuery () { echo select count(*) from radacct; | mysql -h mysqlserver -u radiususer --password=radiuspassword radaccoutingdb } while [ -n 1 ] do echo -n starting query. date

Re: Error: WARNING: Unresponsive child for request inmodule sqlcomponent accounting

2009-02-27 Thread tnt
Executing this script during last 24h (with nohup), from the radius machine, I got always latencies below 1 second Below 1 second or below 1/100th of a second? Near 1 second for such a simple query is *very* slow. Have in mind that insert into radacct is going to take some 100 times

Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting

2009-02-26 Thread magicboiz
HI again Ivan Do you know how can I modify the source code, in order to print in the error message the exact time when the child was created/forked? If I want to find errors in my sql backend server, I need to know the exact time when the requests are lost.. checking the code, It looks

Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting

2009-02-26 Thread Marinko Tarlac
First, optimize your database, add indexes and use storage engines which will give you the best performance... Increase interim-update interval After that, try to add more handlers and see what will happen. If you're using mysql, check tuning-primer.sh and mysqltuner.pl scripts. On Thu, Feb 26,

Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting

2009-02-26 Thread Alan DeKok
magicboiz wrote: Do you know how can I modify the source code, in order to print in the error message the exact time when the child was created/forked? If I want to find errors in my sql backend server, I need to know the exact time when the requests are lost.. checking the code, It

Error: WARNING: Unresponsive child for request in module sql component accounting

2009-02-25 Thread magicboiz
Hello all!! I facing this problem with my Freeradius 2.1.3, and I don't know how to solve it :( My NAS is sending only accounting registers to my freeradius server. My freeradius server, is configured to store these registers into a MySQL server. I have configured max_request_time = 120, in

Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting

2009-02-25 Thread tnt
I facing this problem with my Freeradius 2.1.3, and I don't know how to solve it :( My NAS is sending only accounting registers to my freeradius server. My freeradius server, is configured to store these registers into a MySQL server. I have configured max_request_time = 120, in the case of MySQL

Re: Error: WARNING: Unresponsive child for request in module sqlcomponent accounting

2009-02-25 Thread magicboiz
Thx Ivan, and do you know if the accouting registers is lost? or another child retries the insert into the database? thx Regards On MiƩrcoles 25 Febrero 2009 14:09:44 t...@kalik.net wrote: I facing this problem with my Freeradius 2.1.3, and I don't know how to solve it :( My NAS is

Re: Error: WARNING: Unresponsive child for request in modulesqlcomponent accounting

2009-02-25 Thread tnt
and do you know if the accouting registers is lost? or another child retries the insert into the database? They usually are - there are no handles to write to the database as the whole server gets blocked. I haven't seen tha case where single handle would dia and the rest of them would continue