SQL Accounting problem with 1.0.3 - The maximum number of threads (32) are active

["Rick Macdougall" <jibbermac@gmail.com>]

Hi,

We seem to be having the "The maximum number of threads (32) are active" with Freeradius 1.0.3.  Version 1.0.1 works just fine.

I tried to do a valgrind with -xxxx but when radiusd displays that message, you can no longer kill it.

I have the debug output from the -xxxx and it shows the accounting processes running, adding info and completing but the thread doesn't seem to release.

Example

Tue Apr 17 09:49:57 2007 : Debug: rlm_sql (sql1): Reserving sql socket id: 6
Tue Apr 17 09:49:57 2007 : Debug: rlm_sql (sql1): Released sql socket id: 6
Tue Apr 17 09:49:57 2007 : Debug:   modsingle[accounting]: returned from sql1 (rlm_sql) for request 48
Tue Apr 17 09:49:57 2007 : Debug:   modcall[accounting]: module "sql1" returns ok for request 48

So it appears to be a problem with the mysql driver rather than a problem with a slow database query.

Anything else I can provide ?

Centos 4.3
Linux version 2.6.9-42.0.10.ELsmp
512 meg of ram
Conntecting to a remote DB server over a dedicated gig network running MySQL 5.x
Intel(R) Pentium(R) 4 CPU 3.20GHz with hyperthreading enabled.

Regards,

Rick