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

[Jonathan Scott]

I run mine in a VM and as a means of troubleshooting the issue recently
increased the system RAM allocation. After doing so I re-ran pgtune as I
did during the initial install, but did not do any manual change to sort or
working memory configuration (I'm very new to postgresql).

- Jonathan

On Thu, Sep 20, 2012 at 1:08 PM, Paul Robert Marino <prmarino1 at gmail.com>wrote:

> 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
>>
>
> _______________________________________________
> 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/fdb12447/attachment.htm>