List,
I have been getting a lot of
There are no DB handles to use! skipped 0, tried to connect 0
errors on 1.0.0-pre1 even though I have 32 connections to the database. The database server is not having performance problems from what I can tell. I am only using simple insert queries from radius and I am not storing my radutmp information in the database :
accounting_update_query = "INSERT into ${acct_table1} (acctType, userName, ipAddress, timestamp, sessionID, nasIPAddress, inputOctets, outputOctets, sessionLength, termCause) values ('update', '%{SQL-User-Name}', '%{Framed-IP-Address}', '%S', '%{Acct-Unique-Session-Id}', '%{NAS-IP-Address}', %{Acct-Input-Octets:-0}, %{Acct-Output-Octets:-0}, %{Acct-Session-Time:-0}, '%{Acct-Terminate-Cause}')"
accounting_start_query = "INSERT into ${acct_table1} (acctType, userName, ipAddress, timestamp, sessionID, nasIPAddress) values ('start', '%{SQL-User-Name}', '%{Framed-IP-Address}', '%S', '%{Acct-Unique-Session-Id}', '%{NAS-IP-Address}')"
accounting_stop_query = "INSERT into ${acct_table1} (acctType, userName, ipAddress, timestamp, sessionID, nasIPAddress, inputOctets, outputOctets, sessionLength, termCause) values ('stop', '%{SQL-User-Name}', '%{Framed-IP-Address}', '%S', '%{Acct-Unique-Session-Id}', '%{NAS-IP-Address}', %{Acct-Input-Octets:-0}, %{Acct-Output-Octets:-0}, %{Acct-Session-Time:-0}, '%{Acct-Terminate-Cause}')"
I did some testing with these queries and the database only takes 0.47-0.68 msec to do the insert which leads me to believe this may be a bug.
My radius traffic is very slow in the mornings, yet I still see the error messages.
How can I go about finding the problem when I am reasonably sure it's not a database performance issue?
Also, what does the server do when it runs into this problem? Does it retry to insert the data or does it drop it in the bit bucket?
schu
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
