Skip site navigation (1) Skip section navigation (2)

Re: "Idle in Transaction" revisited.

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: John R Pierce <pierce(at)hogranch(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "Idle in Transaction" revisited.
Date: 2004-09-18 00:55:39
Message-ID: 414B878B.1060801@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Tom Lane wrote:
> "John R Pierce" <pierce(at)hogranch(dot)com> writes:
> 
>>We've been running into a *lot* of problems with "Idle in Transaction" 
>>threads causing long term blockage of VACUUM's ability to free up dead rows. 
> 
> 
> Yeah, that's from prematurely issuing BEGIN.  I believe there's a
> solution for this in the most recent JDBC driver versions --- but
> I dunno if it's in any official releases yet.

The "development driver" versions on jdbc.postgresql.org have this fixed 
as part of the V3 overhaul. I'm not sure about the driver that's in the 
7.4 tree.

-O

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-09-18 07:24:28
Subject: Re: "Idle in Transaction" revisited.
Previous:From: John R PierceDate: 2004-09-18 00:53:27
Subject: Re: "Idle in Transaction" revisited.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group