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

[Rick Macdougall]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070417/a5de7a2d/attachment.html>