Re: Very long time to commit or close connections - Mailing list pgsql-general

From Erwan Arzur
Subject Re: Very long time to commit or close connections
Date
Msg-id 400B9CF3.3040504@free.fr
Whole thread Raw
In response to Very long time to commit or close connections  ("Chris Smith" <cdsmith@twu.net>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Chris Smith wrote:
| Hi everyone,
|
| I'm running into a rather serious problem in a production application
using
| PostgreSQL.
|
| We've got about a connection every 4 seconds being created to the
database.
| Most of the time, this causes no problems at all.  Occasionally,
though, with
| no apparent reason, the database will act up for some time (as little
as 10
| minutes, or as long as 45 minutes).  During that time, it accepts
connections
| and runs queries and statements with no problems, but hangs when
closing the
| connections.  After the time period expires, the database will wake up
and all
| connections that have been waiting will simultaneously return from the
JDBC
| Connection.close() method.
|
| Unfortunately, the problem is only occurring at a remote customer site to
| which we have limited access, and sometimes requires multiple days of
running
| time to reproduce.  As a result, it's hard to see what's happening at the
| instant this happens.  I'm trying to gather more information, but
don't have
| it right now.

Could this be related to a network problem ?

Like RST not received by the client, making it believe the server did
not acknowledge the connection.close(), eating up the server's resources
? No firewall/VPN gateways between you and your customer ?

I've seen this kind of behaviour in the past (with oracle), and tweaking
our firewall rules solved the case - just imagine how much time we've
spent before finding out :-(
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFAC5zztchshDF9KNYRAvkSAJ9ndSV55XopKZ3fr6MHfnia2J0erACeIc1X
NKc59romT8NqbtHQ6mxrppo=
=LVUR
-----END PGP SIGNATURE-----


pgsql-general by date:

Previous
From: "Dieter Fischer"
Date:
Subject: Re: Pass data of database Oracle to PostgreSQL
Next
From: David Helgason
Date:
Subject: Re: newbie question on database structure