"No DB handles" workaround

Brian Julin BJulin at clarku.edu
Tue Jan 14 22:25:04 CET 2014



> Pete Ashdown wrote:
 
> Our SQL server is a 24 core, 32GB, SSD backed server with very light
> loads.  A slowquery log showed nothing of interest, so we started
> looking in other directions.
> 
> What we found is that if the thread pool max_servers > sql num_sql_socks
> this error will occur.  I haven't looked at the code, but I am guessing
> that it is locking one SQL socket per thread, and if you have more
> threads than sockets, then you will start seeing this error.  We set
> max_servers and num_sql_socks both to 15 and we haven't seen the error
> since.

Well, your database was obviously not fast enough to outpace the rate
at which FR can put requests into threads :-)

IN 3.0 the num_sql_socks is replaced by the more generic "max" option
in the connection pool config.  In case this is still an issue there for anyone.




More information about the Freeradius-Users mailing list