Re: [ULOGD PATCH 01/14] Fix SQL reconnection algorithm.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Eric Leblond wrote:
> This patch fixes a problem in SQL reconnection algorithm which is managed in
> the db.c file for PgSQL and MySQL. In case of problem during request execution
> a new connection to the database was immediatly started without closing the
> previous one. The consequence was to block the database by having too much
> simultaneous open connections.
> 
> This patch fixes the problem by disconnectinng from the database after a
> request failure and trying to reconnect after a delay which is by default
> of 2 secondes. This delay can be customized via the reconnect configuration
> variable in the database configuration section.

Applied. Thanks Eric. BTW, an early impression, would it be possible to
handle db reconnections using the timer infrastructure?

-- 
"Los honestos son inadaptados sociales" -- Les Luthiers
--
To unsubscribe from this list: send the line "unsubscribe netfilter-devel" in
the body of a message to majordomo@xxxxxxxxxxxxxxx
More majordomo info at  http://vger.kernel.org/majordomo-info.html

[Index of Archives]     [Netfitler Users]     [LARTC]     [Bugtraq]     [Yosemite Forum]

  Powered by Linux