[Spacewalk-list] Postgres connection issues with Spacewalk 1.9

[Pierre Casenove]

Hello,
i've applied the patch on my development SW server (v1.9, RHEL 5, pgsql).
Before the patch, I received errors by email stating that postgresql
max_connections was reached.
After this patch, I don't have this issue anymore.
This dev server has only a couple of clients so I can't tell if this patch
corrects everything (according to Anthony's emailit doesn't), but I really
think it should be backported to 1.9 branch.

Pierre


2013/3/12 Coffman, Anthony J <Tony.Coffman at snapon.com>

> I applied the patch and rebooted to start things from a clean slate.
>
> The patch doesn't seem to fix the issue.
>
> The Postgres DB idle connections are still rising to more than 1000 very
> rapidly and staying high even after the Spacewalk client activity is
> halting.
>
> The one change I do notice is that they seem to decline very rapidly down
> to about 300 after the Spacewalk client activity ends.  Before the patch
> they would stay higher even after the activity had stopped.
>
> Thanks,
> --Tony
>
>
> -----Original Message-----
> From: spacewalk-list-bounces at redhat.com [mailto:
> spacewalk-list-bounces at redhat.com] On Behalf Of Coffman, Anthony J
> Sent: Tuesday, March 12, 2013 10:08 AM
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9
>
> Jan,
>
> Thanks for this.  I'll give it a try and report back.
>
> --Tony
>
>
> -----Original Message-----
> From: spacewalk-list-bounces at redhat.com [mailto:
> spacewalk-list-bounces at redhat.com] On Behalf Of Jan Pazdziora
> Sent: Tuesday, March 12, 2013 9:25 AM
> To: spacewalk-list at redhat.com
> Subject: Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9
>
> On Tue, Mar 12, 2013 at 02:24:11PM +0100, Jan Pazdziora wrote:
> >
> > Could you please apply patch from
> >
> >
> http://git.fedorahosted.org/cgit/spacewalk.git/commit/?id=00c5e9d460d71c7707393764563e228848bef17f
> >
> > to your driver_postgresql.py to see if it addresses the issue for you?
>
> Afterwards, httpd needs to be restarted for the change to take effect.
>
> --
> Jan Pazdziora
> Principal Software Engineer, Satellite Engineering, Red Hat
>
> _______________________________________________
> 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
>
> _______________________________________________
> 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/20130313/f8488f9e/attachment.htm>