Just a quick question, how many DB connections do you have in your config? alan
On 2011/09/15 06:35 PM, Alan Buxey wrote:
Just a quick question, how many DB connections do you have in your config?
5 Server was a VM with too little RAM. And therefore a simple SQL query could take seconds instead of milliseconds. (Suspect "swap" meltdown if such a thing exists) Had to wait for the middle of the night to reboot (so more ram could be allocated). Server is now perfectly fine. It was just the first time that I didn't see FR "recover" after the DB eventually finished with slow queries. Cheers, -- Johan Meiring Cape PC Services CC Tel: (021) 883-8271 Fax: (021) 886-7782 -------------------- Before acting on this email or opening any attachments you should read Cape PC Service's email disclaimer at: http://www.pcservices.co.za/disclaimer.html
Johan Meiring wrote:
It was just the first time that I didn't see FR "recover" after the DB eventually finished with slow queries.
I made a minor change for 2.1.12 which will clear out the pending queue a lot more quickly. old: for each new request clear out one "dead" request from queue If the dead requests originally arrived at a higher rate than the new requests, it can take a long time to clean them out. new: for each new request clear out all "dead" requests from queue Much better. Alan DeKok.
On Fri, Sep 16, 2011 at 1:22 PM, Alan DeKok <aland@deployingradius.com> wrote:
old: for each new request clear out one "dead" request from queue
If the dead requests originally arrived at a higher rate than the new requests, it can take a long time to clean them out.
new: for each new request clear out all "dead" requests from queue
Thanks, one more reason to update to 2.1.12 when it comes out :D -- Fajar
Alan please do not forget to add this "fix" to changelog so it will be easier for a new FR users... Best regards On 9/16/2011 8:45 AM, Fajar A. Nugraha wrote:
On Fri, Sep 16, 2011 at 1:22 PM, Alan DeKok<aland@deployingradius.com> wrote:
old: for each new request clear out one "dead" request from queue
If the dead requests originally arrived at a higher rate than the new requests, it can take a long time to clean them out.
new: for each new request clear out all "dead" requests from queue
Thanks, one more reason to update to 2.1.12 when it comes out :D
Marinko Tarlać wrote:
Alan please do not forget to add this "fix" to changelog so it will be easier for a new FR users...
to do...? It doesn't require anyone to do anything. There are no configuration changes. It's just code internal to the server. Alan DeKok.
Of course we don't need to do anything but if this small change inside code is announced in changelog, more people will upgrade to 2.1.12 and they will stop bothering us on this list with the same questions, over and over again :) On 9/16/2011 9:59 AM, Alan DeKok wrote:
Marinko Tarlać wrote:
Alan please do not forget to add this "fix" to changelog so it will be easier for a new FR users... to do...? It doesn't require anyone to do anything. There are no configuration changes. It's just code internal to the server.
Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Marinko Tarlać wrote:
Of course we don't need to do anything but if this small change inside code is announced in changelog, more people will upgrade to 2.1.12 and they will stop bothering us on this list with the same questions, over and over again :)
Good point. Alan DeKok.
participants (5)
-
Alan Buxey -
Alan DeKok -
Fajar A. Nugraha -
Johan Meiring -
Marinko Tarlać