Hi,
About 10 days ago, all servers stopped checking in with the Spacewalk
server.
On the server side, I have the following error
in /var/log/rhn/rhn_server_xmlrpc.log:
rhnSQL/driver_postgresql.check_connection('ERROR', "DATABASE CONNECTION TO
'rhnschema' LOST", "Exception information: Database instance has no
attribute 'dbh'")
I've stumbled upon quite a few posts with users reporting a similar error,
but mostly as part of osa running and people restarting PG from under it.
To be sure I have restarted services locally as well as bounce the box.
>From the client, running rhn_check, returns the following:
XMLRPC ProtocolError: <ProtocolError for spacewalk /XMLRPC: 500 Internal
Server Error>
No errors in the PostgreSQL log.
I've checked config and even upgraded to SW 2.5, including running the
schema-update and spacewalk --update scripts, no problems reported.
I've enabled duration logging in PG, and there is multiple connections
being executed etc, but no entry is created when I run rhn_check from a
client.
I tried using clients running 2.3 and 2.5 (not that it should matter)
>From the client, running
curl http://spacewalk/pub/RHN-ORG-TRUSTED-SSL-CERT
No extra info can be gleaned from the http error log:
> [Wed Nov 09 16:41:43.668275 2016] [:error] [pid 5590] Spacewalk 5590
> 2016/11/09 16:41:43 +13:00: ("DATABASE CONNECTION TO 'rhnschema' LOST",
> "Exception information: Database instance has no attribute 'dbh'")
> [Wed Nov 09 16:41:43.668481 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] mod_wsgi (pid=5590): Exception occurred processing
> WSGI script '/usr/share/rhn/wsgi/xmlrpc.py'.
> [Wed Nov 09 16:41:43.668508 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] Traceback (most recent call last):
> [Wed Nov 09 16:41:43.668520 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] File "/usr/share/rhn/wsgi/xmlrpc.py", line 22, in
> application
> [Wed Nov 09 16:41:43.668538 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] return wsgiHandler.handle(environ,
> start_response, "xmlrpc", "server.xmlrpc")
> [Wed Nov 09 16:41:43.668553 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] File "/usr/share/rhn/wsgi/wsgiHandler.py", line
> 36, in handle
> [Wed Nov 09 16:41:43.668671 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] ret = parseServ(req)
> [Wed Nov 09 16:41:43.668685 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] File
> "/usr/lib/python2.7/site-packages/spacewalk/server/apacheHandler.py", line
> 87, in headerParserHandler
> [Wed Nov 09 16:41:43.668697 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] rhnSQL.initDB()
> [Wed Nov 09 16:41:43.668719 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] File
> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py",
> line 145, in initDB
> [Wed Nov 09 16:41:43.668758 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] __init__DB(backend, host, port, username,
> password, database, sslmode, sslrootcert)
> [Wed Nov 09 16:41:43.668783 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] File
> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/__init__.py",
> line 64, in __init__DB
> [Wed Nov 09 16:41:43.668810 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] __DB.check_connection()
> [Wed Nov 09 16:41:43.668832 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] File
> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
> line 219, in check_connection
> [Wed Nov 09 16:41:43.668859 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] self.connect() # only allow one try
> [Wed Nov 09 16:41:43.668881 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] File
> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
> line 193, in connect
> [Wed Nov 09 16:41:43.668908 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] return self.connect(reconnect=reconnect - 1)
> [Wed Nov 09 16:41:43.668929 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] File
> "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
> line 198, in connect
> [Wed Nov 09 16:41:43.668955 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] "Attempting Re-Connect to the database
> failed").with_traceback(sys.exc_info()[2])
> [Wed Nov 09 16:41:43.668988 2016] [:error] [pid 5590] [client
> xxx.xxx.xxx.xxx:50452] AttributeError: 'SQLConnectError' object has no
> attribute 'with_traceback'
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
