Lol
We just had this conversation
Vacuum and analyze the table
Also what's the process that's eating the CPU and what tool are you using for syncing your errata, and is it still running in the background?
-- Sent from my HP Pre3
On Apr 11, 2013 1:46 PM, Matthew Ceroni <[email protected]> wrote:
About a week ago I loaded all of the CentOS errata for version 5 and 6 (up until April 4), using the following tool
The errata loaded, however ever since (so almost a week) the CPU usage on my Spacewalk server hovers around 75% and I slowly get Spacewalk Errata Alert indicating that one ore more systems you have registered are impacted by said errata.
Looking at the pg Activity log for Postgres I see the following statement that is continually running:
SELECT DISTINCT snv.server_id AS server_id, S.name, S.release, SA.name as arch,
urn.user_id
FROM (
--
select rhnChannelErrata.errata_id, rhnChannelErrata.channel_id, rhnServerChannel.server_id, rhnErrataPackage.package_id
from rhnChannelErrata, rhnErrataPackage, rhnChannelNewestPackage, rhnPackageEVR,
rhnServerChannel, rhnServerPackage, rhnPackageUpgradeArchCompat
where rhnChannelErrata.errata_id = rhnErrataPackage.errata_id
--
and rhnChannelErrata.channel_id = rhnChannelNewestPackage.channel_id
and rhnErrataPackage.package_id = rhnChannelNewestPackage.package_id
--
and rhnChannelErrata.channel_id = rhnServerChannel.channel_id
and rhnChannelNewestPackage.name_id = rhnServerPackage.name_id
and rhnServerChannel.server_id = rhnServerPackage.server_id
--
and rhnChannelNewestPackage.evr_id = rhnPackageEVR.id
--
and rhnServerPackage.package_arch_id = rhnPackageUpgradeArchCompat.package_arch_id
and rhnPackageUpgradeArchCompat.pack
I have about 175 systems registered. Is there a way to optimize the DB so that the searching of systems + applicable errata runs quicker. Or a way to terminate the current (going on a week now) process that has been running since I loaded all the Errata? I tried restarting Spacewalk but that didn't resolve anything.
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
