[Spacewalk-list] Massive problems with slow updates on rhnServerAction

[Patrick Hurrelmann]

On 20.09.2012 16:04, Jonathan Scott wrote:
> Paul,
> 
> This is reading like the exact same issue you and I discussed on-list a
> few weeks ago. I had closed out that thread as resolved, but the issue
> has since creeped its way back up. Patrick breaks it down well, I too
> just get a pile up of "idle in transaction" db connections which do not
> clear with any configuration change I have made (tcp timeout, idle
> timeout and connection limit adjustments in postgresql.conf); a restart
> of all associated services gives me about 3-5 days before the app
> becomes unresponsive.
> 
> Patrick, may I ask how are you loading your errata?
> 
> - Jonathan

As a short update: I missed one node that had osad still running. Osad
was disabled there as well. I no longer have any update queries waiting.
There are still some idle transactions, but the number is way lower now.
I have the strong feeling that this is all connected osad and push to
clients. Anyone else?

But back to your question. I'm running David Nutter's centos-errata.py
on a nightly basis directly after a spacewalk restart.

Regards
Patrick

-- 
Lobster LOGsuite GmbH, Münchner Straße 15a, D-82319 Starnberg

HRB 178831, Amtsgericht München
Geschäftsführer: Dr. Martin Fischer, Rolf Henrich