well then stop spacewalk and restart postgresql
On Thu, Apr 11, 2013 at 3:17 PM, Matthew Ceroni <[email protected]>wrote: > Paul: > > The errata import script itself isn't still running. That completed in a > few hours. I think in total it imported 800 errata. Spot checking them it > appears to have loaded correctly (in the correct channel, with the correct > packages linked). > > What is currently using all the CPU is postgres itself. > > > On Thu, Apr 11, 2013 at 11:30 AM, Paul Robert Marino > <[email protected]>wrote: > >> please look at the email string that started yesterday on this list >> entitled "API calls for new hosts" for the discussion we just had about >> PostgreSQL maintenance. >> >> >> On Thu, Apr 11, 2013 at 2:21 PM, Paul Robert Marino >> <[email protected]>wrote: >> >>> never mind I know the script >>> its a very different approach to the script I wrote >>> https://github.com/prmarino1/Extravehicular-Activity-Admin/blob/master/errata-tools/eva-direct-errata-sync.pl >>> and there is an other script which started as somewhat of hybrid of the >>> two which was written by Franky Van Liedekerke. >>> >>> I unfortunately don't have much experience with it but you should check >>> if its still running in the background because that could explain the >>> behavior you are describing. >>> >>> >>> >>> >>> On Thu, Apr 11, 2013 at 2:10 PM, Paul Robert Marino <[email protected] >>> > wrote: >>> >>>> Ceroni >>>> 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 >>>> >>>> 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 >> > > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
