Postgres Pro
Downloads
Home   >   mailing lists

Re: how can i bugfix "idle in transaction" lockups ? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: how can i bugfix "idle in transaction" lockups ?
Date
Msg-id 38C4C998-5A67-4D0A-9207-33A9C95E6360@thebuild.com
Whole thread Raw
In response to how can i bugfix "idle in transaction" lockups ?  (Jonathan Vanasco <postgres@2xlp.com>)
List pgsql-general
Tree view 
On Nov 30, 2010, at 7:21 AM, Jonathan Vanasco wrote:

> i couldn't find anything in the docs, and the project has decent traffic, so its going to be an issue to log all
statementsso I can sift through the data by PID 

With machine-readable logs, it shouldn't be *that* serious an issue.

1. Are you using connection pooling?
2. What's the application server environment?

--
-- Christophe Pettus
   xof@thebuild.com

pgsql-general by date:

Previous
From: Jonathan Vanasco
Date:
Subject: Re: how can i bugfix "idle in transaction" lockups ?
Next
From: Konstantin Izmailov
Date:
Subject: Re: number of rows returned by a query