Spacewalk 1.5 (PostgreSQL) on Cent 6
I've been seeing a process keep popping up that uses as much cpu as it can get.
It appears to be a delete transaction. I've run the following query in psql:
select current_query from pg_stat_activity where current_query <> '<IDLE>' and
current_query not like '%pg_stat_activity%';
It appears that the query that is hanging is:
DELETE FROM rhnPackageChangeLogData
WHERE id NOT IN ( SELECT changelog_data_id FROM rhnPackageChangeLogRec
)
Any insight into this?
Thanks,
Greg
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
