[Spacewalk-list] Database Problems "<IDLE> in transaction"

[Miroslav Suchý]

On 02/29/2012 01:40 PM, Pierre Casenove wrote:
> Hi,
> I have the same behavior on my server, using SW 1.6 and pgsql on rhel 5.
> There seems to be 305 locks in the database:
> select count(*) from pg_locks;
>   count
> -------
>     305
> (1 row)
>
> And I have 38 postgres process stuck in "idle in transaction" state.
>
> I don't know if this is growing or not.
>
> How can we go further in the analysis to help?

This should be fixed in Spacewalk 1.7, which should will released soon.


-- 
Miroslav Suchy
Red Hat Satellite Engineering