Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-05-01 Thread john miller
that was a bad idea. I'll wait to get upgraded to 1.9 before jumping in again. everything was fast but i was getting lots of SQLConnectError FATAL: sorry, too many clients already On Wed, May 1, 2013 at 8:58 AM, john miller wrote: > I have been having a similar issue with 1.7. I applied these p

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-05-01 Thread john miller
I have been having a similar issue with 1.7. I applied these patches (against my better judgement) and the system has went from barely staying alive to performing better then it has in quite a while. I have about 3k systems across 9 channels. On Thu, Mar 14, 2013 at 5:38 AM, Jan Pazdziora wrote:

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-14 Thread Jan Pazdziora
On Wed, Mar 13, 2013 at 01:08:38PM +, Coffman, Anthony J wrote: > > Thanks! This additional patch makes a huge difference. Thank you for testing and reporting back. The respun packages were pushed to Spacewalk 1.9 yum repositories yeterday so yum upgrade (followed by spacewalk-service resta

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-13 Thread Coffman, Anthony J
-list-boun...@redhat.com] On Behalf Of Jan Pazdziora Sent: Wednesday, March 13, 2013 4:27 AM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9 On Tue, Mar 12, 2013 at 05:52:46PM +, Coffman, Anthony J wrote: > I applied the patch and reb

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-13 Thread Jan Pazdziora
On Tue, Mar 12, 2013 at 05:52:46PM +, Coffman, Anthony J wrote: > 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 aft

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-13 Thread Pierre Casenove
alf Of Coffman, Anthony J > Sent: Tuesday, March 12, 2013 10:08 AM > To: spacewalk-list@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 > > > ---

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-12 Thread Coffman, Anthony J
-boun...@redhat.com] On Behalf Of Coffman, Anthony J Sent: Tuesday, March 12, 2013 10:08 AM To: spacewalk-list@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: spac

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-12 Thread Coffman, Anthony J
t: 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=00c5e9d460d71c7707393764563e22884

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-12 Thread Jan Pazdziora
On Mon, Mar 11, 2013 at 03:21:08PM +, Coffman, Anthony J wrote: > Is anybody else seeing 500 errors on 1.9? > > We've had ridiculous numbers (300-400) of Postgres IDLE connections since the > 1.7 release but it seems they've reach new heights in Spacewalk 1.9. I just > ran a package refresh

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-12 Thread Jan Pazdziora
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? Afterwa

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-12 Thread Coffman, Anthony J
-list-boun...@redhat.com [mailto:spacewalk-list-boun...@redhat.com] On Behalf Of Coffman, Anthony J Sent: Monday, March 11, 2013 1:16 PM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9 Yes - we’ve done several restarts and reboots. Spacewalk _is_

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-11 Thread Coffman, Anthony J
Subject: Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9 Have you restarted all the spacewalk services since the update was installed? -- Sent from my HP Pre3 On Mar 11, 2013 12:48 PM, Coffman, Anthony J wrote: Sorry for top posting

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-11 Thread Paul Robert Marino
] Postgres connection issues with Spacewalk 1.9 On 11.03.2013 16:21, Coffman, Anthony J wrote: > Is anybody else seeing 500 errors on 1.9? > > We've had ridiculous numbers (300-400) of Postgres IDLE connections since the 1.7 release but it seems they've reach new heights in Spacewa

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-11 Thread Coffman, Anthony J
-list-boun...@redhat.com] On Behalf Of Patrick Hurrelmann Sent: Monday, March 11, 2013 11:39 AM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9 On 11.03.2013 16:21, Coffman, Anthony J wrote: > Is anybody else seeing 500 errors on 1.9? > > W

Re: [Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-11 Thread Patrick Hurrelmann
On 11.03.2013 16:21, Coffman, Anthony J wrote: > Is anybody else seeing 500 errors on 1.9? > > We've had ridiculous numbers (300-400) of Postgres IDLE connections since the > 1.7 release but it seems they've reach new heights in Spacewalk 1.9. I just > ran a package refresh on 30 DEV systems an

[Spacewalk-list] Postgres connection issues with Spacewalk 1.9

2013-03-11 Thread Coffman, Anthony J
Is anybody else seeing 500 errors on 1.9? We've had ridiculous numbers (300-400) of Postgres IDLE connections since the 1.7 release but it seems they've reach new heights in Spacewalk 1.9. I just ran a package refresh on 30 DEV systems and the Postgres connection count got up to around 1000 be