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

[Paul Robert Marino]

I think I may have some idea on what may be causing this but I haven't had
time to look. At it yet. Did eitherof you tune the sort memory or working
memory in your postgres.conf
On Sep 20, 2012 10:20 AM, "Patrick Hurrelmann" <
patrick.hurrelmann at lobster.de> wrote:

> 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
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120920/0ce71010/attachment.htm>