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

[Wojtak, Greg (Superfly)]

I see these all the time.  I am not running any monitoring.  I was
wondering if they are OSA related?

On 2012-02-23 11:10 AM, "Thomas Ristic" <tr at 35x.de> wrote:

>> 
>> I've had very similar problems and haven't had time to fully get to the
>> bottom
>> of it.
>> 
>> I have a botch of a cron job that keeps things ticking along:
>> 
>> *  *  *  *  * root /usr/bin/test `/usr/bin/pgrep -f 'idle in
>> transaction' | /usr/bin/wc \-l ` \-gt 20 && /usr/bin/pkill \-o \-f 'idle
>> in transaction'
>> 
>> It's not pretty, and it's a big pile of wrong, but it's better than not
>> having
>> it on my setup.
>
>Do you have monitoring enabled in your setup? Since I've set
>web.is_monitoring_backend = 0 on the affected system yesterday I havn't
>seen any "hangs" and i am not killing the "<IDLE> in transaction"
>processes at the moment.
>
>
>Thomas
>
>_______________________________________________
>Spacewalk-list mailing list
>Spacewalk-list at redhat.com
>https://www.redhat.com/mailman/listinfo/spacewalk-list