Hi All, I have a freeradius server which has some slow mysql queries and some errors like the below happen now and again(daily).
We have actually just upgraded to this server and have imported all the MYsql data into the new server (it was working fine on the older quite similar server). One thing I have noticed; the server boots with around 280mb of ram used but after an hour or two is closer to 400mb used and stays around this point until rebooted again. My research says that the tables need to be indexed but it seems I would have to manually do this and I don't know which ones would need it anyway... and why would this be the case when it wasn't needed previously. The other thing that I have noticed is what appear to be doubled up entries in radius.log, (check the times) Anyone know what this could be? Fri Jun 3 19:40:30 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) Fri Jun 3 19:40:31 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) Fri Jun 3 19:40:31 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) Fri Jun 3 19:40:31 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) Fri Jun 3 19:40:32 2011 : Auth: Login incorrect: [E4-CE-8F-85-A5-E4/password] (from client localhost port 3 cli E4-CE-8F-85-A5-E4) --------------- Here are the server errors: Fri Jun 3 19:39:40 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 210 due to unfinished request 5001 Fri Jun 3 19:39:40 2011 : Error: WARNING: Unresponsive child (id 2995579792) for request 5008 (in component accounting module rlm_sql) Fri Jun 3 19:39:40 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 211 due to unfinished request 5009 Fri Jun 3 19:39:40 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:41 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:41 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:41 2011 : Error: Discarding duplicate request from client localhost:2048 - ID: 32 due to unfinished request 5008 Fri Jun 3 19:39:43 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 210 due to unfinished request 5001 Fri Jun 3 19:39:43 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 211 due to unfinished request 5009 Fri Jun 3 19:39:44 2011 : Error: Discarding duplicate request from client localhost:2048 - ID: 32 due to unfinished request 5008 Fri Jun 3 19:39:46 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 210 due to unfinished request 5001 Fri Jun 3 19:39:46 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 211 due to unfinished request 5009 Fri Jun 3 19:39:46 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:47 2011 : Error: Discarding duplicate request from client localhost:2048 - ID: 32 due to unfinished request 5008 Fri Jun 3 19:39:47 2011 : Error: WARNING: Unresponsive child (id 2985089936) for request 5009 (in component accounting module rlm_sql) Fri Jun 3 19:39:49 2011 : Error: Discarding duplicate request from client localhost:61924 - ID: 211 due to unfinished request 5009 Fri Jun 3 19:39:49 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Fri Jun 3 19:39:50 2011 : Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0 Regards Carl - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html