[Spacewalk-list] Spacewalk-list Digest, Vol 56, Issue 12

Tue Jan 8 18:12:20 UTC 2013

Yeah I got the same issue and I only have 22 servers subscribed to 3 
channels on my Real Red Hat Satellite
I got 279 or so emails with a bunch of them about the same thing on a 
different channel.
That's with me updating the whole thing last Wednesday including the 
server itself !!
I'd hate to think that when I get about 200 more on the satellite that 
it will max out my one VCPU.

On 1/8/2013 11:23 AM, spacewalk-list-request at redhat.com wrote:
> Send Spacewalk-list mailing list submissions to
> 	spacewalk-list at redhat.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://www.redhat.com/mailman/listinfo/spacewalk-list
> or, via email, send a message with subject or body 'help' to
> 	spacewalk-list-request at redhat.com
>
> You can reach the person managing the list at
> 	spacewalk-list-owner at redhat.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Spacewalk-list digest..."
>
>
> Today's Topics:
>
>     1. Re: Spacewalk 1.7 CPU Maxed out by postgresql (8.4) (Boyd, Robert)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 8 Jan 2013 12:23:13 -0500
> From: "Boyd, Robert" <Robert.Boyd at peoplefluent.com>
> To: "spacewalk-list at redhat.com" <spacewalk-list at redhat.com>
> Subject: Re: [Spacewalk-list] Spacewalk 1.7 CPU Maxed out by
> 	postgresql (8.4)
> Message-ID:
> 	<0D5F32BB8C49D6438AF012955D0CBEF29E5D4F7D9A at CORP2K7MAIL.corp.peopleclick.com>
> 	
> Content-Type: text/plain; charset="us-ascii"
>
> There is probably nothing wrong (other than maybe some tuning needed?) with Spacewalk or PostgreSQL on this server.
>
> It would appear that Red Hat released approximately 100 updates in the RHEL5 x86_64 space yesterday. At least that's what it looks like from the errata-sync log.   The errata got loaded into the master I'm running around the time I can see the cpu maxing out.   My guess is that it's crunching through auditing all of the client servers against the errata list since I'm getting bombarded (slowly) with Spacewalk Alert emails.     I'm curious as to why this activity would be generating so much cpu load for so long though.   We only have about 250 servers registered in the system.  It seems crazy that it would take hours to check 250 servers against 100 errata unless there's a serious problem in the design of the data / algorithm for doing the checks.
>
> Is there any easy way to take a read on Spacewalk and see that it's busy?  Would be nice if there was a dashboard with meters giving a clue about whatever it's busy processing.  The way I finally figured out my situation this time was noticing the flood of emails and working back to the nightly errata sync logs to see the flood of updates imported this morning.
>
> Robert Boyd
> Sr System Engineer | Peoplefluent
> p. 919-645-2972 | c. 919-306-4681
> e. Robert.Boyd at peoplefluent.com
> Visit: www.peoplefluent.com<http://www.peoplefluent.com/> | Read: Peoplefluent Blog<http://peoplefluent.com/resources/peoplefluent-blog>
> Follow: @peoplefluent<http://twitter.com/peoplefluent> | Download: iPad App<http://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8>
> [cid:image007.jpg at 01CDED9A.EE073A50]<http://www.peoplefluent.com/>
> [cid:image008.jpg at 01CDED9A.EE073A50]<http://www.peoplefluent.com/mobile-talent-management>
>
> From: Boyd, Robert
> Sent: Tuesday, January 08, 2013 11:44 AM
> To: spacewalk-list at redhat.com
> Subject: Spacewalk 1.7 CPU Maxed out by postgresql (8.4)
>
> Sometime this morning my spacewalk server pegged 100% on cpu utilization and has been staying there ever since.   I tried a reboot, and just for grins updated errata/packages on the server.   After rebooting it's still pegging the cpu usage with this process:
>
> postgres  2888 77.7  1.3 470128 53708 ?        Rs   10:35  52:05 postgres: spaceuser spaceschema 127.0.0.1(46206) SELECT
>
> I am able to use  the Spacewalk admin website without any problem other than a bit of slow response.
> How can I discover what is causing this (and hopefully fix it)?
>
> Robert Boyd
> Sr System Engineer | Peoplefluent
> p. 919-645-2972 | c. 919-306-4681
>
> e. Robert.Boyd at peoplefluent.com
> Visit: www.peoplefluent.com<http://www.peoplefluent.com/> | Read: Peoplefluent Blog<http://peoplefluent.com/resources/peoplefluent-blog>
> Follow: @peoplefluent<http://twitter.com/peoplefluent> | Download: iPad App<http://itunes.apple.com/us/app/peoplefluent/id474251804?mt=8>
> [cid:image005.jpg at 01CDED9A.0E5C02F0]<http://www.peoplefluent.com/>
> [cid:image006.jpg at 01CDED9A.0E5C02F0]<http://www.peoplefluent.com/mobile-talent-management>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <https://www.redhat.com/archives/spacewalk-list/attachments/20130108/ee33a50c/attachment.html>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image005.jpg
> Type: image/jpeg
> Size: 2395 bytes
> Desc: image005.jpg
> URL: <https://www.redhat.com/archives/spacewalk-list/attachments/20130108/ee33a50c/attachment.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image006.jpg
> Type: image/jpeg
> Size: 3726 bytes
> Desc: image006.jpg
> URL: <https://www.redhat.com/archives/spacewalk-list/attachments/20130108/ee33a50c/attachment-0001.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image007.jpg
> Type: image/jpeg
> Size: 2395 bytes
> Desc: image007.jpg
> URL: <https://www.redhat.com/archives/spacewalk-list/attachments/20130108/ee33a50c/attachment-0002.jpg>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: image008.jpg
> Type: image/jpeg
> Size: 3726 bytes
> Desc: image008.jpg
> URL: <https://www.redhat.com/archives/spacewalk-list/attachments/20130108/ee33a50c/attachment-0003.jpg>
>
> ------------------------------
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
> End of Spacewalk-list Digest, Vol 56, Issue 12
> **********************************************
>