[Spacewalk-list] Postgres connection issues with Spacewalk 1.9

[Coffman, Anthony J]

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