Request has been waiting in the processing queue for 30 seconds

[Mehdi Ravanbakhsh]

Dear Fajar A. Nugraha

thanks for your reply. and your guide

i reduce the database connection and it solved :)


Best regards.



On Mon, Apr 22, 2013 at 11:43 AM, Fajar A. Nugraha <list at fajar.net> wrote:

> On Mon, Apr 22, 2013 at 12:59 PM, Mehdi Ravanbakhsh <babakco at gmail.com>wrote:
>
>> i get this error in log file when server load is increase .
>>
>> Request 55318 has been waiting in the processing queue for 30 seconds.
>>  Check that all databases are running properly!
>>
>>
>> it means that database not respond to request or freeradius engine ?
>>
>>
> If you use db backend, then most likely yes.
>
>
>> how can i solve this problem ?
>>
>
> If you had to ask then you're not capable to solve it :)
>
> As cruel as that might sound, unfortunately in my experience it's usually
> true. You need a dba, or someone with dba capability, to fiind out WHY the
> db backend is not responding. Search the list archive for common causes,
> which can include:
> - acct db too big
> - non-optimum indices
> - not enough resources (e.g. disk IOPS) in db server
> - etc.
>
> On freeradius side, there are things to make it "more friendly" with
> database, like decoupled accounting. However I still recommend you find a
> dba first before attempting to change anything on FR side.
>
> --
> Fajar
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130423/ac144811/attachment-0001.html>