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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
