Description of problem: Exception type cx_Oracle.DatabaseError, Exception while handling function handler 3/23 build embedded db on x86 not sure how I got this, but I've seen this traceback several times in the last two weeks. Opening so dev can take a look. Exception reported from riverraid.rhndev.redhat.com Time: Fri Mar 27 12:09:13 2009 Exception type cx_Oracle.DatabaseError Exception while handling function handler Request object information: URI: /XMLRPC Remote Host: fjs-0-12.rhndev.redhat.com Server Name: riverraid.rhndev.redhat.com:0 Headers passed in: Accept-Encoding: identity Content-Length: 881 Host: riverraid.rhndev.redhat.com content-type: text/xml user-agent: rhn.rpclib.py/$Revision: 92982 $ x-client-version: 1 x-info: RPC Processor (C) Red Hat, Inc (version 118741) x-rhn-client-capability: packages.verifyAll(1)=1,packages.verify(1)=1,packages.extended_profile(1)=1,configfiles.base64_enc(1)=1,reboot.reboot(1)=1,configfiles.deploy(1)=1,caneatCheese(1)=1,packages.rollBack(1)=1,configfiles.mtime_upload(1)=1,configfiles.diff(1)=1,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1 x-rhn-transport-capability: follow-redirects=2 x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc (version 92982) x-up2date-version: 4.7.1-17.el4 Extra information about this error: Unhandled exception type Exception Handler Information Traceback (most recent call last): File "/usr/share/rhn/server/apacheServer.py", line 58, in __call__ ret = f(req) File "/usr/share/rhn/server/apacheHandler.py", line 201, in handler rhnSQL.rollback() File "/usr/share/rhn/server/rhnSQL/__init__.py", line 179, in rollback return db.rollback(name) File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 433, in rollback return self.dbh.rollback() DatabaseError: ORA-03114: not connected to ORACLE Local variables by frame Frame rollback in /usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py at line 433 self = <type 'instance'> <server.rhnSQL.driver_cx_Oracle.Database instance at 0xb7ba438c> name = <type 'NoneType'> None Frame rollback in /usr/share/rhn/server/rhnSQL/__init__.py at line 179 db = <type 'instance'> <server.rhnSQL.driver_cx_Oracle.Database instance at 0xb7ba438c> name = <type 'NoneType'> None Frame handler in /usr/share/rhn/server/apacheHandler.py at line 201 h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to rhnsat@rhnsat>> self = <type 'instance'> <server.apacheHandler.apacheHandler instance at 0xb7c7e74c> req = <type 'mp_request'> <mp_request object at 0xb35a3c5c> ret = <type 'int'> 0 templateStrings = <type 'dict'> {'email_account_info': '\nAccount Information:\n Your RHN login: <login />\n Your RHN email address: <email-address />', 'email_footer': '--the Red Hat Network Team', 'hostname': 'riverraid.rhndev.redhat.com'} row = <type 'NoneType'> None Frame __call__ in /usr/share/rhn/server/apacheServer.py at line 63 self = <type 'instance'> <server.apacheServer.HandlerWrap instance at 0xb7d21e0c> req = <type 'mp_request'> <mp_request object at 0xb35a3c5c> f = <type 'instancemethod'> <bound method apacheHandler.handler of <server.apacheHandler.apacheHandler instance at 0xb7c7e74c>> Frame HandlerDispatch in /usr/lib/python2.4/site-packages/mod_python/apache.py at line 299 req = <type 'mp_request'> <mp_request object at 0xb35a3c5c> config = <type 'mp_table'> {'PythonInterpreter': 'rhn.server', 'PythonPath': 'sys.path+['/usr/share/rhn']'} self = <type 'instance'> <mod_python.apache.CallBack instance at 0xb7f3176c> object = <type 'instance'> <server.apacheServer.HandlerWrap instance at 0xb7d21e0c> l = <type 'list'> ['server.apacheServer', 'Handler'] module = <type 'module'> <module 'server.apacheServer' from '/usr/share/rhn/server/apacheServer.pyc'> hlist = <type 'mp_hlist'> {'handler:'server.apacheServer::Handler','directory':'/XMLRPC/','silent':0} object_str = <type 'str'> Handler debug = <type 'int'> 0 module_name = <type 'str'> server.apacheServer pathstring = <type 'str'> sys.path+['/usr/share/rhn'] result = <type 'int'> 500 Environment for PID=19595 on exception: LANG = C NLS_LANG = english.AL32UTF8 ORACLE_HOME = /opt/oracle PATH = /sbin:/usr/sbin:/bin:/usr/bin PERL_BADFREE = 0 PWD = / SHLVL = 2 TERM = dumb _ = /usr/sbin/httpd
Created attachment 337050 [details] spacewalk-debug
Jan, can you take a glance at this and see if anything pops-out other than the: DatabaseError: ORA-03114: not connected to ORACLE There doesn't appear to be enough info here to go on, but if you find something, please let us know.
Could we get alert.log from that Satellite server to see why the connection was closed?
Needinfo for Wes for ------- Comment #3 From Jan
Let's use bug 491673 for Oracle server core dumping issues. *** This bug has been marked as a duplicate of bug 491673 ***