<div dir="ltr">Hello,<div style>i've applied the patch on my development SW server (v1.9, RHEL 5, pgsql).</div><div style>Before the patch, I received errors by email stating that postgresql max_connections was reached.</div>
<div style>After this patch, I don't have this issue anymore.</div><div style>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.</div>
<div style><br></div><div style>Pierre</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/3/12 Coffman, Anthony J <span dir="ltr"><<a href="mailto:Tony.Coffman@snapon.com" target="_blank">Tony.Coffman@snapon.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I applied the patch and rebooted to start things from a clean slate.<br>
<br>
The patch doesn't seem to fix the issue.<br>
<br>
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.<br>
<br>
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.<br>
<br>
Thanks,<br>
--Tony<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
-----Original Message-----<br>
From: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [mailto:<a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a>] On Behalf Of Coffman, Anthony J<br>

Sent: Tuesday, March 12, 2013 10:08 AM<br>
To: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a><br>
Subject: Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9<br>
<br>
Jan,<br>
<br>
Thanks for this.  I'll give it a try and report back.<br>
<br>
--Tony<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a> [mailto:<a href="mailto:spacewalk-list-bounces@redhat.com">spacewalk-list-bounces@redhat.com</a>] On Behalf Of Jan Pazdziora<br>

Sent: Tuesday, March 12, 2013 9:25 AM<br>
To: <a href="mailto:spacewalk-list@redhat.com">spacewalk-list@redhat.com</a><br>
Subject: Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9<br>
<br>
On Tue, Mar 12, 2013 at 02:24:11PM +0100, Jan Pazdziora wrote:<br>
><br>
> Could you please apply patch from<br>
><br>
>       <a href="http://git.fedorahosted.org/cgit/spacewalk.git/commit/?id=00c5e9d460d71c7707393764563e228848bef17f" target="_blank">http://git.fedorahosted.org/cgit/spacewalk.git/commit/?id=00c5e9d460d71c7707393764563e228848bef17f</a><br>

><br>
> to your driver_postgresql.py to see if it addresses the issue for you?<br>
<br>
Afterwards, httpd needs to be restarted for the change to take effect.<br>
<br>
--<br>
Jan Pazdziora<br>
Principal Software Engineer, Satellite Engineering, Red Hat<br>
<br>
_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br>
<br>
_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br>
<br>
_______________________________________________<br>
Spacewalk-list mailing list<br>
<a href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a><br>
<a href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank">https://www.redhat.com/mailman/listinfo/spacewalk-list</a><br>
</div></div></blockquote></div><br></div>