[Spacewalk-list] Postgres connection issues with Spacewalk 1.9

[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 before things completely fell apart.

Max client for Postgres is currently set to 1200 (was 500 in 1.8).

Symptom is 500 errors that look something like this.

Exception Handler Information
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheHandler.py", line 80, in headerParserHandler
    rhnSQL.initDB()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 102, in initDB
    __init__DB(backend, host, port, username, password, database)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 55, in __init__DB
    __DB.connect()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 174, in connect
    return self.connect(reconnect=0)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 163, in connect
    password=self.password)
SQLConnectError: (None, None, 'spaceschema', 'Attempting Re-Connect to the database failed')

Local variables by frame
Frame connect in /usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py at line 179
                        self = <type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Database instance at 0x7f75ea5617e8>
                           e = <class 'psycopg2.OperationalError'> server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
could not send startup packet: Broken pipe

                   reconnect = <type 'int'> 0

Frame connect in /usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py at line 174
                        self = <type 'instance'> <spacewalk.server.rhnSQL.driver_postgresql.Database instance at 0x7f75ea5617e8>
                           e = <class 'psycopg2.OperationalError'> server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
could not send startup packet: Broken pipe

Thanks and regards,
--Tony