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, [email protected] wrote:
Send Spacewalk-list mailing list submissions to
        [email protected]

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
        [email protected]

You can reach the person managing the list at
        [email protected]

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" <[email protected]>
To: "[email protected]" <[email protected]>
Subject: Re: [Spacewalk-list] Spacewalk 1.7 CPU Maxed out by
        postgresql (8.4)
Message-ID:
        
<0d5f32bb8c49d6438af012955d0cbef29e5d4f7...@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. [email protected]
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:[email protected]]<http://www.peoplefluent.com/>
[cid:[email protected]]<http://www.peoplefluent.com/mobile-talent-management>

From: Boyd, Robert
Sent: Tuesday, January 08, 2013 11:44 AM
To: [email protected]
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. [email protected]
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:[email protected]]<http://www.peoplefluent.com/>
[cid:[email protected]]<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
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

End of Spacewalk-list Digest, Vol 56, Issue 12
**********************************************


_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to