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
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
