Idle in transaction connection - Mailing list pgsql-general

From Norberto Delle
Subject Idle in transaction connection
Date
Msg-id 48EF4ED0.3070800@gmail.com
Whole thread Raw
List 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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: flood in logs
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: flood in logs