[Spacewalk-list] Spacewalk 1.7 CPU Maxed out by postgresql (8.4)

[Jan Pazdziora]

On Tue, Jan 08, 2013 at 11:44:04AM -0500, Boyd, Robert wrote:
> 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)?

Try

	select * from pg_stat_activity;

to see what select is causing the trouble and whether it's one select
which is taking many minutes or a stream of selects..

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat