Request has been waiting in the processing queue for 30 seconds
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 ? how can i solve this problem ?
On Mon, Apr 22, 2013 at 12:59 PM, Mehdi Ravanbakhsh <babakco@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
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@fajar.net> wrote:
On Mon, Apr 22, 2013 at 12:59 PM, Mehdi Ravanbakhsh <babakco@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
On Tue, Apr 23, 2013 at 1:27 PM, Mehdi Ravanbakhsh <babakco@gmail.com> wrote:
Dear Fajar A. Nugraha
thanks for your reply. and your guide
i reduce the database connection and it solved :)
Wow. Though I'm glad to hear it solves your problem, personally I don't see how it could work. Or to be more accurate, while it reduces load to db from radius server, if the load problem was on the db server then simply reducing the number of connection would mean FR would complain about something else (e.g. "no DB handles to use"). Good luck though, hope it solves your problem permanently. -- Fajar
thanksssss On Tue, Apr 23, 2013 at 11:12 AM, Fajar A. Nugraha <list@fajar.net> wrote:
On Tue, Apr 23, 2013 at 1:27 PM, Mehdi Ravanbakhsh <babakco@gmail.com> wrote:
Dear Fajar A. Nugraha
thanks for your reply. and your guide
i reduce the database connection and it solved :)
Wow.
Though I'm glad to hear it solves your problem, personally I don't see how it could work.
Or to be more accurate, while it reduces load to db from radius server, if the load problem was on the db server then simply reducing the number of connection would mean FR would complain about something else (e.g. "no DB handles to use").
Good luck though, hope it solves your problem permanently.
-- Fajar - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Fajar A. Nugraha -
Mehdi Ravanbakhsh