Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request
Can someone help with this Please. I always have restart server before radius can record again on Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are active, cannot spawn new thread to handle request Mon Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are active, cannot spawn new thread to handle request Mon Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are active, cannot spawn new thread to handle request Mon Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are active, cannot spawn new thread to handle request Mon Sep 20 18:45:19 2010 : Error: WARNING: Unresponsive child (id 180550544) for request 6431961 Mon Sep 20 18:45:19 2010 : Error: WARNING: Unresponsive child (id 2446359440) for request 6431965 Mon Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are active, cannot spawn new thread to handle request Mon Sep 20 18:45:19 2010 : Error: Dropping conflicting packet from client att:1646 - ID: 63 due to unfinished request 6434567 Mon Sep 20 18:45:19 2010 : Error: Dropping conflicting packet from client att:1646 - ID: 65 due to unfinished request 6433323 Mon Sep 20 18:45:19 2010 : Error: WARNING: Unresponsive child (id 2939382672) for request 6431951 Mon Sep 20 18:45:19 2010 : Error: WARNING: Unresponsive child (id 3086240656) for request 6431963 Mon Sep 20 18:45:19 2010 : Error: Dropping conflicting packet from client att:1646 - ID: 155 due to unfinished request 6433435 Mon Sep 20 18:45:19 2010 : Error: WARNING: Unresponsive child (id 3044281232) for request 6431966 Mon Sep 20 18:45:19 2010 : Error: WARNING: Unresponsive child (id 1869417360) for request 6432076 Mon Sep 20 Thanks and Regards Marie ________________________________ The information contained in this email and any attachments is strictly confidential and is for the use of the intended recipient. Any use, dissemination, distribution, or reproduction of any part of this email or any attachment is prohibited. If you are not the intended recipient, please notify the sender by return email and delete all copies including attachments.
Marie Tambe wrote:
Can someone help with this Please.
I always have restart server before radius can record again
It's not a RADIUS problem.
on Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are active, cannot spawn new thread to handle request ... Mon Sep 20 18:45:19 2010 : Error: WARNING: Unresponsive child (id 180550544) for request 6431961
Your database is blocked. It is slow, unresponse, or otherwise useless. As a result, the RADIUS server cannot read or write to the DB. Fix the database so that it returns answers quickly. Right now, it is taking 30-60 seconds to respond to SELECTs or INSERTs. Alan DeKok.
I am not a mysql expert but need to support it. How can I fix the database? Is it related to the server resources as well? Thanks and Regards Marie -----Original Message----- From: freeradius-users-bounces+mtambe=usatech.com@lists.freeradius.org [mailto:freeradius-users-bounces+mtambe=usatech.com@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Tuesday, September 28, 2010 9:36 AM To: FreeRadius users mailing list Subject: Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request Marie Tambe wrote:
Can someone help with this Please.
I always have restart server before radius can record again
It's not a RADIUS problem.
on Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are active, cannot spawn new thread to handle request ... Mon Sep 20 18:45:19 2010 : Error: WARNING: Unresponsive child (id 180550544) for request 6431961
Your database is blocked. It is slow, unresponse, or otherwise useless. As a result, the RADIUS server cannot read or write to the DB. Fix the database so that it returns answers quickly. Right now, it is taking 30-60 seconds to respond to SELECTs or INSERTs. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html The information contained in this email and any attachments is strictly confidential and is for the use of the intended recipient. Any use, dissemination, distribution, or reproduction of any part of this email or any attachment is prohibited. If you are not the intended recipient, please notify the sender by return email and delete all copies including attachments. The information contained in this email and any attachments is strictly confidential and is for the use of the intended recipient. Any use, dissemination, distribution, or reproduction of any part of this email or any attachment is prohibited. If you are not the intended recipient, please notify the sender by return email and delete all copies including attachments.
Marie Tambe wrote:
I am not a mysql expert but need to support it. How can I fix the database?
Ask the MySQL people how to make the database responsive. In short, you've put too many rows in the DB without indexes.
Is it related to the server resources as well?
See my previous message. Alan DeKok.
Hi,
I am not a mysql expert but need to support it. How can I fix the database? Is it related to the server resources as well?
server resources as in memory and CPU and disk speed? most likely. this is a FreeRADIUS mailing list - which DB are you using - I'd suggest going to the relevent mailing list or support channel for your DB - and/or invest ina good book for it. most of the optimisation can be done in eg configuration files - allocate more memory, change the engine etc. others need more DB skills and foo - eg creation of correct indexes etc personally, I'd look at what you are using and see if you can change to a better one (eg move to postgresql instead of mysql ) alan
We are using mysql database for Radius Thanks and Regards Marie -----Original Message----- From: freeradius-users-bounces+mtambe=usatech.com@lists.freeradius.org [mailto:freeradius-users-bounces+mtambe=usatech.com@lists.freeradius.org] On Behalf Of Alan Buxey Sent: Tuesday, September 28, 2010 10:08 AM To: FreeRadius users mailing list Subject: Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request Hi,
I am not a mysql expert but need to support it. How can I fix the database? Is it related to the server resources as well?
server resources as in memory and CPU and disk speed? most likely. this is a FreeRADIUS mailing list - which DB are you using - I'd suggest going to the relevent mailing list or support channel for your DB - and/or invest ina good book for it. most of the optimisation can be done in eg configuration files - allocate more memory, change the engine etc. others need more DB skills and foo - eg creation of correct indexes etc personally, I'd look at what you are using and see if you can change to a better one (eg move to postgresql instead of mysql ) alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html The information contained in this email and any attachments is strictly confidential and is for the use of the intended recipient. Any use, dissemination, distribution, or reproduction of any part of this email or any attachment is prohibited. If you are not the intended recipient, please notify the sender by return email and delete all copies including attachments. The information contained in this email and any attachments is strictly confidential and is for the use of the intended recipient. Any use, dissemination, distribution, or reproduction of any part of this email or any attachment is prohibited. If you are not the intended recipient, please notify the sender by return email and delete all copies including attachments.
If anybody is using mysql for Radius. Could you tell me columns that you have created index for? Thanks and Regards Marie -----Original Message----- From: freeradius-users-bounces+mtambe=usatech.com@lists.freeradius.org [mailto:freeradius-users-bounces+mtambe=usatech.com@lists.freeradius.org] On Behalf Of Alan DeKok Sent: Tuesday, September 28, 2010 9:36 AM To: FreeRadius users mailing list Subject: Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request Marie Tambe wrote:
Can someone help with this Please.
I always have restart server before radius can record again
It's not a RADIUS problem.
on Sep 20 18:45:19 2010 : Info: The maximum number of threads (300) are active, cannot spawn new thread to handle request ... Mon Sep 20 18:45:19 2010 : Error: WARNING: Unresponsive child (id 180550544) for request 6431961
Your database is blocked. It is slow, unresponse, or otherwise useless. As a result, the RADIUS server cannot read or write to the DB. Fix the database so that it returns answers quickly. Right now, it is taking 30-60 seconds to respond to SELECTs or INSERTs. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html The information contained in this email and any attachments is strictly confidential and is for the use of the intended recipient. Any use, dissemination, distribution, or reproduction of any part of this email or any attachment is prohibited. If you are not the intended recipient, please notify the sender by return email and delete all copies including attachments. The information contained in this email and any attachments is strictly confidential and is for the use of the intended recipient. Any use, dissemination, distribution, or reproduction of any part of this email or any attachment is prohibited. If you are not the intended recipient, please notify the sender by return email and delete all copies including attachments.
Marie Tambe wrote:
If anybody is using mysql for Radius. Could you tell me columns that you have created index for?
The default schema creates the right indexes. I've seen people have issues with MySQL when they're *not* using the default schema, or when they have more data than the machine can handle. You were also told this was a MySQL problem. Alan DeKok.
On 2010/09/29 06:58 PM, Marie Tambe wrote:
If anybody is using mysql for Radius. Could you tell me columns that you have created index for?
Your question is invalid. Go buy a sql book. PS: It's already been suggested that this is the Freeradius list, not the mysql list. PPS: Buy a book has also been suggested. -- Johan Meiring Cape PC Services CC Tel: (021) 883-8271 Fax: (021) 886-7782
Mysql is the backend database of radius and therefore any help in this regard is appreciated as this is affecting the stability of the radius Apps Thanks and Regards Marie -----Original Message----- From: freeradius-users-bounces+mtambe=usatech.com@lists.freeradius.org [mailto:freeradius-users-bounces+mtambe=usatech.com@lists.freeradius.org] On Behalf Of Johan Meiring Sent: Wednesday, September 29, 2010 1:16 PM To: freeradius-users@lists.freeradius.org Subject: Re: Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request On 2010/09/29 06:58 PM, Marie Tambe wrote:
If anybody is using mysql for Radius. Could you tell me columns that you have created index for?
Your question is invalid. Go buy a sql book. PS: It's already been suggested that this is the Freeradius list, not the mysql list. PPS: Buy a book has also been suggested. -- Johan Meiring Cape PC Services CC Tel: (021) 883-8271 Fax: (021) 886-7782 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html The information contained in this email and any attachments is strictly confidential and is for the use of the intended recipient. Any use, dissemination, distribution, or reproduction of any part of this email or any attachment is prohibited. If you are not the intended recipient, please notify the sender by return email and delete all copies including attachments. The information contained in this email and any attachments is strictly confidential and is for the use of the intended recipient. Any use, dissemination, distribution, or reproduction of any part of this email or any attachment is prohibited. If you are not the intended recipient, please notify the sender by return email and delete all copies including attachments.
Hi,
Mysql is the backend database of radius and therefore any help in this regard is appreciated as this is affecting the stability of the radius Apps
MySQL is a database system. This is a FreeRADIUS mailing list for the dissemination of hints, methods, tips and configs for the FreeRADIUS daemon. I have already given you pointers regarding MySQL - there are many free resources out there http://lists.mysql.com/ those lists can give you the tuning, debugging help you need for dealing with MySQL I also mentioned postgresQL - this is more robust (and faster) - and comes by default with an engine that doesnt block on insert/update commands finally, there are books. If you are going to be using a database for your system, then get a DBA - then your system should also be secure - the last thing you want to do is slap up a MySQL server with no idea of security requirements and how it operates... next you'll be saying you have myphpadmin installed... :-( alan
participants (4)
-
Alan Buxey -
Alan DeKok -
Johan Meiring -
Marie Tambe