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

idle in transaction

From: "Sriram Dandapani" <sdandapani(at)counterpane(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: idle in transaction
Date: 2006-09-15 18:47:11
Message-ID: 6992E470F12A444BB787B5C937B9D4DF05DF1974@ca-mail1.cis.local (view raw or flat)
Thread:
Lists: pgsql-jdbc
I use postgres 8.1.2 database and postgres 8.1.404 jdbc driver .

 

I keep seeing "idle in transaction" connections on the postgres box all
the time. The application logic closes all connections , so it makes me
wonder if the driver is issuing a begin statement after every commit to
leave a floating transaction open.

 

This is causing autovacuum to not finish (and hence I have to frequently
issue database-wide vacuums to prevent the transaction id wraparound
problem)

 

Any help here is appreciated

 

Thanks

 

Sriram

Responses

pgsql-jdbc by date

Next:From: Markus SchaberDate: 2006-09-16 08:26:48
Subject: Re: idle in transaction
Previous:From: Marc HerbertDate: 2006-09-15 10:17:46
Subject: Re: about monitoring the input stream

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