On Wed, Jun 8, 2011 at 9:32 AM, Tarabas <tarabas@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