All pastes #2067435 Raw Edit

Untitled

public text v1 · immutable
#2067435 ·published 2011-05-23 09:30 UTC
rendered paste body
Exception reported from <CENSORED!>
Time: Mon May 23 11:25:58 2011
Exception type <CENSORED!>.server.rhnSQL.sql_base.SQLError
Exception while handling function queue.get
Request object information:
URI: /XMLRPC
Remote Host: static.88-198-21-197.clients.your-server.de
Server Name: <CENSORED!>
Headers passed in:
	Accept-Encoding: identity
	Content-Length: 2739
	Host: <CENSORED!>
	content-type: text/xml
	user-agent: rhn.rpclib.py/$Revision$
	x-client-version: 1
	x-info: RPC Processor (C) Red Hat, Inc (version $Revision$)
	x-rhn-client-capability: osad.ping(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1,osad.ping(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1
	x-rhn-transport-capability: follow-redirects=3
	x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc (version $Revision$)
	x-up2date-version: 1.4.16-1.el5
Extra information about this error:
SQL Error generated: (1484, 'ORA-01484: arrays can only be bound to PL/SQL statements\n', 'select ks.id from rhnKickstartSession ks where ( (ks.old_server_id = :server_id and ks.new_server_id is NULL) or ks.new_server_id = :server_id or ks.host_server_id = :server_id ) and ks.action_id = :action_id')

Exception Handler Information
Traceback (most recent call last):
 File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheRequest.py", line 119, in call_function
   response = apply(func, params)
 File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 312, in get
   self._invalidate_child_actions(action_id)
 File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 154, in _invalidate_child_actions
   next_action_type=None)
 File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnServer/server_kickstart.py", line 27, in update_kickstart_session
   ks_session_id = get_kickstart_session_id(server_id, action_id)
 File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnServer/server_kickstart.py", line 147, in get_kickstart_session_id
   h.execute(server_id=server_id, action_id=action_id)
 File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnSQL/sql_base.py", line 163, in execute
   return apply(self._execute_wrapper, (self._execute, ) + p, kw)
 File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnSQL/driver_cx_Oracle.py", line 127, in _execute_wrapper
   raise apply(sql_base.SQLError, ret)
SQLError: (1484, 'ORA-01484: arrays can only be bound to PL/SQL statements\n', 'select ks.id from rhnKickstartSession ks where ( (ks.old_server_id = :server_id and ks.new_server_id is NULL) or ks.new_server_id = :server_id or ks.host_server_id = :server_id ) and ks.action_id = :action_id')

Local variables by frame
Frame _execute_wrapper in /usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnSQL/driver_cx_Oracle.py at line 127
	            function = <type 'instancemethod'> <bound method Cursor._execute of <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost:1521/xe>>>
	                   e = <type 'instance'> ORA-01484: arrays can only be bound to PL/SQL statements

	               errno = <type 'int'> 1484
	                self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost:1521/xe>>
	     modified_params = <type 'list'> []
	               value = <type 'list'> [614]
	                   p = <type 'tuple'> ()
	              params = <type 'str'> 'server_id': 1000010080,'action_id': [614]
	                 ret = <type 'tuple'> (1484, 'ORA-01484: arrays can only be bound to PL/SQL statements\n', 'select ks.id from rhnKickstartSession ks where ( (ks.old_server_id = :server_id and ks.new_server_id is NULL) or ks.new_server_id = :server_id or ks.host_server_id = :server_id ) and ks.action_id = :action_id')
	                 key = <type 'str'> action_id
	                  kw = <type 'dict'> {'server_id': 1000010080, 'action_id': [614]}
	              errmsg = <type 'str'> ORA-01484: arrays can only be bound to PL/SQL statements


Frame execute in /usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnSQL/sql_base.py at line 163
	                   p = <type 'tuple'> ()
	                self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost:1521/xe>>
	                  kw = <type 'dict'> {'server_id': 1000010080, 'action_id': [614]}

Frame get_kickstart_session_id in /usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnServer/server_kickstart.py at line 147
	                   h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost:1521/xe>>
	           server_id = <type 'int'> 1000010080
	           action_id = <type 'list'> [614]

Frame update_kickstart_session in /usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnServer/server_kickstart.py at line 27
	           server_id = <type 'int'> 1000010080
	     kickstart_state = <type 'str'> failed
	           action_id = <type 'list'> [614]
	       action_status = <type 'int'> 3
	    next_action_type = <type 'NoneType'> None

Frame _invalidate_child_actions in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 154
	         f_action_id = <type 'list'> [614]
	        f_action_ids = <type 'list'> [[614]]
	                self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2acdbc0a1170>
	           action_id = <type 'int'> 613

Frame get in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 312
	              status = <type 'dict'> {'uname': ['Linux', 'CentOS-56-64-minimal', '2.6.18-238.9.1.el5', '#1 SMP Tue Apr 12 18:10:13 EDT 2011', 'x86_64'], 'uptime': [847671, 846835]}
	                   h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost:1521/xe>>
	                self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2acdbc0a1170>
	                 ret = <type 'dict'> {}
	             version = <type 'int'> 2
	           system_id = <type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>master</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>centos-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: centos-release
Release: 5
CPU Arch: x86_64-redhat-linux</string></value>
</member>
<member>
<name>checksum</name>
<value><string>e3a1d8108f43eefbc703e70a57822368</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>CentOS-56-64-minimal</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010080</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64-redhat-linux</string></value>
</member>
<member>
<name>os_release</name>
<value><string>5</string></value>
</member>
<member>
<name>fields</name>
<value><array><data>
<value><string>system_id</string></value>
<value><string>os_release</string></value>
<value><string>operating_system</string></value>
<value><string>architecture</string></value>
<value><string>username</string></value>
<value><string>type</string></value>
</data></array></value>
</member>
<member>
<name>type</name>
<value><string>REAL</string></value>
</member>
</struct></value>
</param>
</params>

	      should_execute = <type 'int'> 0
	              action = <type 'dict'> {'id': 613, 'method': 'packages.update', 'version': 0, 'remaining_tries': 0, 'unlocked_only': 'Y', 'prerequisite': None}
	       server_locked = <type 'int'> 0
	           action_id = <type 'int'> 613

Frame call_function in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheRequest.py at line 165
	                   e = <type 'instance'> (1484, 'ORA-01484: arrays can only be bound to PL/SQL statements\n', 'select ks.id from rhnKickstartSession ks where ( (ks.old_server_id = :server_id and ks.new_server_id is NULL) or ks.new_server_id = :server_id or ks.host_server_id = :server_id ) and ks.action_id = :action_id')
	                self = <type 'instance'> <<CENSORED!>.server.apacheRequest.apachePOST instance at 0x2acdbc08df38>
	      force_rollback = <type 'int'> 1
	              params = <type 'tuple'> ('<?xml version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>master</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: centos-release\nRelease: 5\nCPU Arch: x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>e3a1d8108f43eefbc703e70a57822368</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>CentOS-56-64-minimal</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010080</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>5</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array
<data>\n<value><string>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n', 2, {'uname': ['Linux', 'CentOS-56-64-minimal', '2.6.18-238.9.1.el5', '#1 SMP Tue Apr 12 18:10:13 EDT 2011', 'x86_64'], 'uptime': [847671, 846835]})
	                func = <type 'instancemethod'> <bound method Queue.get of <server.handlers.xmlrpc.queue.Queue instance at 0x2acdbc0a1170>>
	              method = <type 'str'> queue.get

Frame process in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheRequest.py at line 472
	                  fd = <type 'instance'> <cStringIO.StringO object at 0x2acda9f5e760>
	               _body = <type 'str'> <?xml version='1.0'?>
<methodCall>
<methodName>queue.get</methodName>
<params>
<param>
<value><string>&lt;?xml version="1.0"?&gt;
&lt;params&gt;
&lt;param&gt;
&lt;value&gt;&lt;struct&gt;
&lt;member&gt;
&lt;name&gt;username&lt;/name&gt;
&lt;value&gt;&lt;string&gt;master&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;operating_system&lt;/name&gt;
&lt;value&gt;&lt;string&gt;centos-release&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;description&lt;/name&gt;
&lt;value&gt;&lt;string&gt;Initial Registration Parameters:
OS: centos-release
Release: 5
CPU Arch: x86_64-redhat-linux&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;checksum&lt;/name&gt;
&lt;value&gt;&lt;string&gt;e3a1d8108f43eefbc703e70a57822368&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;profile_name&lt;/name&gt;
&lt;value&gt;&lt;string&gt;CentOS-56-64-minimal&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;system_id&lt;/name&gt;
&lt;value&gt;&lt;string&gt;ID-1000010080&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;architecture&lt;/name&gt;
&lt;value&gt;&lt;string&gt;x86_64-redhat-linux&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;os_release&lt;/name&gt;
&lt;value&gt;&lt;string&gt;5&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;fields&lt;/name&gt;
&lt;value&gt;&lt;array&gt;&lt;data&gt;
&lt;value&gt;&lt;string&gt;system_id&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;os_release&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;operating_system&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;architecture&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;username&lt;/string&gt;&lt;/value&gt;
&lt;value&gt;&lt;string&gt;type&lt;/string&gt;&lt;/value&gt;
&lt;/data&gt;&lt;/array&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;member&gt;
&lt;name&gt;type&lt;/name&gt;
&lt;value&gt;&lt;string&gt;REAL&lt;/string&gt;&lt;/value&gt;
&lt;/member&gt;
&lt;/struct&gt;&lt;/value&gt;
&lt;/param&gt;
&lt;/params&gt;
</string></value>
</param>
<param>
<value><int>2</int></value>
</param>
<param>
<value><struct>
<member>
<name>uname</name>
<value><array><data>
<value><string>Linux</string></value>
<value><string>CentOS-56-64-minimal</string></value>
<value><string>2.6.18-238.9.1.el5</string></value>
<value><string>#1 SMP Tue Apr 12 18:10:13 EDT 2011</string></value>
<value><string>x86_64</string></value>
</data></array></value>
</member>
<member>
<name>uptime</name>
<value><array><data>
<value><int>847671</int></value>
<value><int>846835</int></value>
</data></array></value>
</member>
</struct></value>
</param>
</params>
</methodCall>

	              params = <type 'tuple'> ('<?xml version="1.0"?>\n<params>\n<param>\n<value><struct>\n<member>\n<name>username</name>\n<value><string>master</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>centos-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial Registration Parameters:\nOS: centos-release\nRelease: 5\nCPU Arch: x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>e3a1d8108f43eefbc703e70a57822368</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>CentOS-56-64-minimal</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010080</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64-redhat-linux</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>5</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array
<data>\n<value><string>system_id</string></value>\n<value><string>os_release</string></value>\n<value><string>operating_system</string></value>\n<value><string>architecture</string></value>\n<value><string>username</string></value>\n<value><string>type</string></value>\n</data></array></value>\n</member>\n<member>\n<name>type</name>\n<value><string>REAL</string></value>\n</member>\n</struct></value>\n</param>\n</params>\n', 2, {'uname': ['Linux', 'CentOS-56-64-minimal', '2.6.18-238.9.1.el5', '#1 SMP Tue Apr 12 18:10:13 EDT 2011', 'x86_64'], 'uptime': [847671, 846835]})
	              method = <type 'str'> queue.get
	                self = <type 'instance'> <<CENSORED!>.server.apacheRequest.apachePOST instance at 0x2acdbc08df38>

Frame handler in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheHandler.py at line 193
	                   h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost:1521/xe>>
	                self = <type 'instance'> <<CENSORED!>.server.apacheHandler.apacheHandler instance at 0x2acdadbd6ef0>
	                 req = <type 'mp_request'> <mp_request object at 0x2acdaabc4050>
	                 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': '<CENSORED!>'}
	                 row = <type 'NoneType'> None

Frame HandlerDispatch in /usr/lib64/python2.4/site-packages/mod_python/apache.py at line 299
	                 req = <type 'mp_request'> <mp_request object at 0x2acdaabc4050>
	                self = <type 'instance'> <mod_python.apache.CallBack instance at 0x2acdaabc3128>
	              object = <type 'instancemethod'> <bound method apacheHandler.handler of <<CENSORED!>.server.apacheHandler.apacheHandler instance at 0x2acdadbd6ef0>>
	                   l = <type 'list'> ['<CENSORED!>.server.apacheServer', 'Handler']
	              module = <type 'module'> <module '<CENSORED!>.server.apacheServer' from '/usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheServer.pyc'>
	               hlist = <type 'mp_hlist'> {'handler:'<CENSORED!>.server.apacheServer::Handler','directory':'/XMLRPC/','silent':0}
	          object_str = <type 'str'> Handler
	               debug = <type 'int'> 0
	         module_name = <type 'str'> <CENSORED!>.server.apacheServer
	              config = <type 'mp_table'> {'PythonInterpreter': 'rhn.server'}
	                 dir = <type 'str'> /XMLRPC/
	              result = <type 'int'> 500


Environment for PID=10841 on exception:
CONSOLE = /dev/console
HOME = /
INIT_VERSION = sysvinit-2.86
LANG = C
NLS_LANG = english.AL32UTF8
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PREVLEVEL = N
PWD = /
RUNLEVEL = 3
SELINUX_INIT = YES
SHLVL = 3
TERM = linux
_ = /usr/sbin/httpd
previous = N
runlevel = 3