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

[Thomas Ristic]

> 
> 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