[Spacewalk-list] Errata Notification Mailer and Queue constantly running

[Justin Edmands]

Hey,
My errata notification queue and mailer have been running for days without
stopping. Regardless of reboots or a recent spacewalk update, the thrashing
continues. This has been creating 100% load on my postgres database. Any
ideas or ways to stop this?

top shows:
     load average: 7.23, 4.56, 4.18
     Cpu(s):  1.6%us,  0.7%sy,  0.0%ni, 33.1%id, 64.3%wa,  0.0%hi,
0.3%si,  0.0%st
sar / systat shows:

                 CPU     %user     %nice   %system   %iowait    %steal
%idle
09:00:06 AM     all     11.52      0.00      1.81     28.80      0.00
57.87
09:10:05 AM     all     11.07      0.00      1.81     30.59      0.00
56.53
09:20:01 AM     all     12.12      0.00      1.80     26.09      0.00
59.98
09:30:12 AM     all     11.91      0.00      1.44     24.08      0.00
62.57
09:40:09 AM     all      8.51      0.00      1.72     28.45      0.00
61.32
09:50:04 AM     all      9.93      0.00      1.78     23.59      0.00
64.70
10:00:05 AM     all      9.89      0.00      1.46     27.60      0.00
61.04
10:10:03 AM     all     11.73      0.00      1.48     24.10      0.00
62.69
10:20:03 AM     all      9.09      0.00      1.59     26.15      0.00
63.17
10:30:04 AM     all     14.67      0.00      1.14     23.43      0.00
60.76
10:40:02 AM     all     14.37      0.00      1.10     18.70      0.00
65.83
10:50:05 AM     all     13.48      0.00      1.38     19.82      0.00
65.32
11:00:01 AM     all     15.42      0.00      1.32     17.43      0.00
65.84
11:10:01 AM     all     11.87      0.00      1.35     21.06      0.00
65.72
11:20:02 AM     all     10.65      0.00      2.19     31.27      0.00
55.89
11:30:01 AM     all      9.26      0.00      2.01     29.04      0.00
59.69
11:40:01 AM     all      9.95      0.00      1.37     26.67      0.00
62.01
11:50:01 AM     all     10.04      0.00      1.79     26.64      0.00
61.52

atop shows:

LVM | _varlibpgsql | busy    106%  | read       0 |              | write
29751  |
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130711/0b79e297/attachment.htm>