]> git.ipfire.org Git - thirdparty/ulogd2.git/commit
This patch fixes a problem in SQL reconnection algorithm which is managed in
author/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org </C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org>
Sat, 5 Apr 2008 14:02:56 +0000 (14:02 +0000)
committer/C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org </C=EU/ST=EU/CN=Pablo Neira Ayuso/emailAddress=pablo@netfilter.org>
Sat, 5 Apr 2008 14:02:56 +0000 (14:02 +0000)
commit19e26b39ba4b571b36883cb4fc08a16d4b7b1c38
tree8b60b0e6570d10af67e0eda53d361a46d5f40a2e
parent627afbf16b96d23dc0eb7b8e87575c3b9b54e72b
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.

Signed-off-by: Eric Leblond <eric@inl.fr>
include/ulogd/db.h
util/db.c