Hi Guys I have a question regarding the rlm_sql module crashing the rest of FreeRadius. Below I have a selection from my logs. You can see that in the space of 12 seconds my server shot itself in the head simply because it didn't have enough DB handles. This has happened repeatedly over the last few nights (since I switches this server from mysql to postgres). The answer is obviously simple (increase the number of DB handles..) which I have been doing each day, but our traffic has been increasing at a rapid rate. My question is why is the rlm_sql module allowed to kill the server? shouldn't the server still keep logging to the detail files even if the DB is too busy? not just die messily? Luckily I have 2 more failover servers still running mysql to to take the accounting traffic when this one dies.
I would appreciate some comments from coders on why this happens, and if there are any plans on fixing this? I am not a c programmer although I am passable at perl so this is a bit beyond my skills to fix, but as I stated in several previous posts I am intending on releasing my complete FreeRadius based accounting system when it is complete, so please don't think I am just whinging here without any effort on my part. Mon Sep 16 19:22:18 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:18 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:18 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:18 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:18 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:18 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:18 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:19 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Mon Sep 16 19:22:20 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:20 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:20 2002 : Error: WARNING: Unresponsive child (id 163842) for request 25043 Mon Sep 16 19:22:20 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:20 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:20 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:20 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:20 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:20 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:21 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:21 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:21 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:21 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:21 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:21 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:21 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:21 2002 : Error: rlm_sql: Stop packet with zero session length. (user '240', nas '212.50.53.201') Mon Sep 16 19:22:22 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:22 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:22 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:23 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:23 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:23 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:23 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:23 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:23 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:23 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:23 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Mon Sep 16 19:22:24 2002 : Error: rlm_sql: All sockets are being used! Please increase the maximum number of sockets! Mon Sep 16 19:22:25 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:25 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:25 2002 : Error: rlm_sql: Stop packet with zero session length. (user '240', nas '212.50.53.201') Mon Sep 16 19:22:25 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:25 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:25 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:25 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:25 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:26 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:26 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:26 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:26 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:27 2002 : Error: rlm_sql: Stop packet with zero session length. (user '240', nas '212.50.53.201') Mon Sep 16 19:22:27 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:27 2002 : Error: WARNING: Unresponsive child (id 167947) for request 25087 Mon Sep 16 19:22:27 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:27 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:27 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:27 2002 : Error: rlm_sql: Stop packet with zero session length. (user '248', nas '212.50.53.201') Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:28 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:29 2002 : Error: rlm_sql: There are no DB handles to use! Mon Sep 16 19:22:29 2002 : Error: rlm_sql: Stop packet with zero session length. (user '240', nas '212.50.53.201') Mon Sep 16 19:22:30 2002 : Error: CHILD: exit on signal (11) Regards -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc "They that can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety." -Benjamin Franklin
msg09361/pgp00000.pgp
Description: PGP signature
