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

[Thomas Ristic]

Hi,

I see a lot of "<IDLE> in transaction" on my newly installed Spacewalk
Server (version: 1.6.66, velease: 1.el6).

One of this unfinished transaction seems to lock the table WEB_CONTACT.
When I try to schedule a package update for multiple systems, the query
"update WEB_CONTACT set login=$1, login_uc=$2, password=$3, org_id=$4
where id=$5" hangs forever with waiting status t according to
pg_stat_activity. When I kill the "<IDLE> in transaction" postgresql
processes, the action gets scheduled as expected.

I tried to disable osa-dispatcher (5.10.34-1.el6) but this doesn't
change anything.

postgresql-server is version 8.4.9-1.el6_1.1.x86_64.

Nothing in the logs.

Any suggestions how to fix this?

Thanks for any pointers!


Thomas