[Spacewalk-list] Traceback after 0.2 upgrade?

[Clifford Perry]

Jason Frisvold wrote:
> Greetings,
>
> Apparently, since my transition to 0.2, I've been receiving these
> errors in email.  They appear to coincide with clients checking in...
> It looks like an Oracle problem, but I'm not sure where to begin with
> this.  Any advice?
>
> Thanks!
>
> Exception reported from dev.example.com
> Time: Mon Sep 22 10:17:33 2008
> Exception type cx_Oracle.DatabaseError
> Exception while handling function handler
> Request object information:
> URI: /XMLRPC
> Remote Host: 192.168.1.1
> Server Name: dev.example.com:0
> Headers passed in:
> 	Accept-Encoding: identity
> 	Content-Length: 2627
> 	Host: dev.example.com
> 	content-type: text/xml
> 	user-agent: rhn.rpclib.py/$Revision: 102540 $
> 	x-client-version: 1
> 	x-info: RPC Processor (C) Red Hat, Inc (version 102540)
> 	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 102540)
> 	x-up2date-version: 0.4.17-10.fc9
> Extra information about this error:
> Unhandled exception type
>
> Exception Handler Information
> Traceback (most recent call last):
>  File "/usr/share/rhn/server/apacheServer.py", line 57, 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 150, in rollback
>    return db.rollback(name)
>  File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 402, 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/int_oracle.py at line 402
> 	                self = <type 'instance'>
> <server.rhnSQL.driver_cx_Oracle.Database instance at 0xb7bd34cc>
> 	                name = <type 'NoneType'> None
>
> Frame rollback in /usr/share/rhn/server/rhnSQL/__init__.py at line 150
> 	                  db = <type 'instance'>
> <server.rhnSQL.driver_cx_Oracle.Database instance at 0xb7bd34cc>
> 	                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 spacewalk at xe>>
> 	                self = <type 'instance'>
> <server.apacheHandler.apacheHandler instance at 0xb7ca61ac>
> 	                 req = <type 'mp_request'> <mp_request object at 0xb7f51d2c>
> 	                 ret = <type 'int'> 0
> 	     templateStrings = <type 'dict'> {'email_account_info':
> '\nAccount Information:\n  Your Spacewalk login:         <login />\n
> Your Spacewalk email address: <email-address />', 'email_footer':
> '--the Spacewalk Team', 'hostname': 'dev.example.com'}
> 	                 row = <type 'NoneType'> None
>
> Frame __call__ in /usr/share/rhn/server/apacheServer.py at line 62
> 	                self = <type 'instance'>
> <server.apacheServer.HandlerWrap instance at 0xb7d6774c>
> 	                 req = <type 'mp_request'> <mp_request object at 0xb7f51d2c>
> 	                   f = <type 'instancemethod'> <bound method
> apacheHandler.handler of <server.apacheHandler.apacheHandler instance
> at 0xb7ca61ac>>
>
> Frame HandlerDispatch in
> /usr/lib/python2.4/site-packages/mod_python/apache.py at line 299
> 	                 req = <type 'mp_request'> <mp_request object at 0xb7f51d2c>
> 	              config = <type 'mp_table'> {'PythonInterpreter':
> 'rhn.server', 'PythonPath': 'sys.path+['/usr/share/rhn']'}
> 	                self = <type 'instance'> <mod_python.apache.CallBack
> instance at 0xb7f5f74c>
> 	              object = <type 'instance'>
> <server.apacheServer.HandlerWrap instance at 0xb7d6774c>
> 	                   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=28664 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 = xterm-color
> _ = /usr/sbin/httpd
>
>
>   

/etc/tnsnames.ora and rhn.conf configurations setup correctly? If Oracle 
was down then webUI would also be failing - WebUI is working? Oracle 
running?. Just checking for the most obvious first :)


Cliff



-- 
Clifford Perry
Team Lead, Satellite Engineering
Red Hat, Inc. 
http://www.redhat.com/
+1 919 754 4403
RHCA / RHCE# 805007680128201