Radius not recording - The maximum number of threads (300) are active, cannot spawn new thread to handle request

[Marie Tambe]

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 at lists.freeradius.org [mailto:freeradius-users-bounces+mtambe=usatech.com at 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.