-----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-----
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
