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

[Peter Nixon]

On Wed 18 Apr 2007, Rick Macdougall wrote:
> On 4/17/07, Alan DeKok <aland at deployingradius.com> wrote:
> > Rick Macdougall wrote:
> > > 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.
> >
> >   Upgrade to 1.1.6.  It has a whole host of fixes.
>
> Hi,
>
> Upgraded to 1.1.6 and the problem persists.
>
> The maximum number of threads (32) are active, cannot spawn new thread to
> handle request
> rad_recv: Access-Request packet from host 206.123.6.28:1645, id=239,
> length=208
> Discarding duplicate request from client aeiusr05:1645 - ID: 239 due to
> unfinished request 56
>
>   $ ./configure --with-gnu-ld --with-threads --with-thread-pool
> --disable-ltdl-install --with-rlm-sql_mysql-include-dir=/usr/include/mysql
> --with-mysql-lib-dir=/usr/lib/mysql --with-unixodbc-lib-dir=/usr/lib
> --with-rlm-dbm-lib-dir=/usr/lib
> --with-rlm-krb5-include-dir=/usr/kerberos/include --sysconfdir=/etc
> --prefix=/usr --exec_prefix=/usr --localstatedir=/var --sbindir=/usr/sbin
>
> Any other ideas ?
>
> Only seems to happen with accounting, no apparent problems with
> authentication.

Yep. Your backend is too slow to keep up. Accounting is inserts and 
updates... Auth is selects.. BIG difference in speed...

Cheers

-- 

Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc