Very long time to commit or close connections

From: "Chris Smith" <cdsmith(at)twu(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Very long time to commit or close connections
Date: 2004-01-19 00:10:12
Message-ID: 04ff01c3de20$9bc5b110$6f00000a@KYA
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

So right now, my question is this: does this sound familiar to anyone, and
what information would you look for in troubleshooting this?

--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.

Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2004-01-19 00:22:17 Re: Introduced PostgreSQL for Windows
Previous Message Jeff Bowden 2004-01-19 00:01:32 Re: serverless postgresql