Hibernating: Major impact on authentication!

[Kenneth Marshall]

On Tue, Feb 06, 2007 at 09:14:47AM +0000, Phil Mayers wrote:
> Kenneth Marshall wrote:
> > Mr. Franco,
> > 
> > I have not looked at the DB connection code, but is there a connection
> > timer on the DB connection. That is, does the connection get dropped
> 
> No
> 
> > If the latter, the problem could be that the long running connections
> > are not allowing the indexes and table spaces to be maintained properly.
> > This could cause bloat and performance problems over time. After a
> 
> At least on Postgres, this is NOT correct.
> 
> Open *transactions* block such activity. However the base rlm_sql 
> doesn't use transactions because they're un-needed, and the 
> rlm_sql_ippool module executes very short running transactions indeed.
> 
> I believe the OP is running Postgres, but if anyone finds themselves 
> running a database where maintaining long-running connections blocks 
> maintenance jobs, I would recommend the un-install it immediately.
> - 

True. It is not freeradius' job to manage the DB. Are there any other
databases on the server that could have a long running transaction and
are preventing the clean-up of the ippool DB?

Ken