Re: Hibernating: Major impact on authentication!

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

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