On Wed, Jun 8, 2011 at 9:32 AM, Tarabas <tara...@tarabas.de> wrote: > Hello, > > the problem just resurfaced and the Wiki page dows not really help > very much. > > When i look into the pg_stat_activity, i only see that the connections > all state "<IDLE> in transaction". > > Is there any way to find out what the transaction is doing exactly to > be able to debug the Problem?
The transactions aren't doing anything. Your applciation began transactions in your application but didn't commit them. Classic causes of this are: 1) straight up bugs (code branches that do not commit) 2) multi threaded code, especially when threads share connections (basically a factory for #1 above) 3) busted connection poolers (php_pconnect) merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
