Major impact on authentication!

--===============0002710103==
Content-Type: multipart/alternative;
boundary="----=_Part_19517_2544719.1170666402078"

------=_Part_19517_2544719.1170666402078
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

Freeradius 1.1.4 is randomly losing connection to both databases and it's
causing total loss in the authentication process:

Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to
connect 0
Info: rlm_sql (sql_postgresql): There are no DB handles to use! skipped 0,
tried to connect 0
Info: The maximum number of threads (32) are active, cannot spawn new thread
to handle request

Running either in multi or single threaded mode, that messages appeared
47.099,00 times since Jan 27! Freeradius is configured with 32 max_servers
and 32 connections to each DB. There's no starving since no accounting is
being used and the server have to handle just 3 auths per second.

Every time this happens, no one can authenticate and doing a restart in
Freeradius solves the problem. To circumvent the problem, I've added a
cron.hourly job so each hour a "service radiusd restart" is issued.

As this is random, it's hard to debug, but at the same time freeradius loses
the connection, several other applications can successfully connect/
maintain previous established connections to the databases. I've enabled all
sorts of debug in the databases trying to better understand why freeradius
is doing this, but there was no luck.

I've installed the latest CVS and the same problem appeared, please help!

------=_Part_19517_2544719.1170666402078
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi,</div>
<div>&nbsp;</div>
<div>Freeradius 1.1.4 is randomly losing connection to both databases and it's causing total loss in the authentication process:</div>
<div>&nbsp;</div>
<div>Info: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0<br>Info: rlm_sql (sql_postgresql): There are no DB handles to use! skipped 0, tried to connect 0</div>
<div>Info: The maximum number of threads (32) are active, cannot spawn new thread to handle request</div>
<div>&nbsp;</div>
<div>Running either in multi or single threaded mode, that messages appeared 47.099,00 times since Jan 27! Freeradius is configured with 32 max_servers and 32 connections to each DB. There's no starving since no accounting is being used and the server have to handle just 3&nbsp;auths per second.
</div>
<div>&nbsp;</div>
<div>Every time this happens, no one can authenticate and doing a restart in Freeradius solves the problem. To&nbsp;circumvent the problem, I've added a cron.hourly job so each hour a &quot;service radiusd restart&quot; is issued.
</div>
<div>&nbsp;</div>
<div>As this is random, it's hard to debug, but at the same time freeradius loses the connection, several other applications can successfully connect/ maintain previous established connections to the databases. I've enabled all sorts of debug in the databases trying to better understand why freeradius is doing&nbsp;this, but there was no luck.
</div>
<div>&nbsp;</div>
<div>I've installed the latest CVS and the same problem appeared, please help!</div>

------=_Part_19517_2544719.1170666402078--

--===============0002710103==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
--===============0002710103==--