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

[Pierre Casenove]

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?

Pierre


2012/2/24 John Hodrien <J.H.Hodrien at leeds.ac.uk>:
> On Thu, 23 Feb 2012, Wojtak, Greg (Superfly) wrote:
>
>> I see these all the time.  I am not running any monitoring.  I was
>> wondering if they are OSA related?
>
>
> In my case, osa-dispatcher is disabled.
>
> jh
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list