Idle in transaction connection

From: Norberto Delle <betodelle(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Idle in transaction connection
Date: 2008-10-10 12:47:12
Message-ID: 48EF4ED0.3070800@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I have a Postgresql 8.2.10 install running on w2k3, and recently, or
more precisely, after I upgraded from 8.2.5 to 8.2.10,
some connections keep in the 'idle in transaction' state. The real
problem is that even after I kill the connection subprocess,
the pg_stat_activity reports that the connection is still there, and the
locks too. The only thing that solves this is restarting Postgres.
Any clues of what might be happening?

Thanks for tha attention.

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2008-10-10 12:50:11 Re: flood in logs
Previous Message Tom Lane 2008-10-10 12:42:02 Re: flood in logs