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 <[email protected]> > 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: [email protected] [mailto: > [email protected]] On Behalf Of Coffman, Anthony J > Sent: Tuesday, March 12, 2013 10:08 AM > To: [email protected] > 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: [email protected] [mailto: > [email protected]] On Behalf Of Jan Pazdziora > Sent: Tuesday, March 12, 2013 9:25 AM > To: [email protected] > 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 > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
