About a week ago I loaded all of the CentOS errata for version 5 and 6 (up until April 4), using the following tool
http://cefs.steve-meier.de/ 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
