[Spacewalk-list] Random Oracle Error Spacewalk 1.4 centos 5.6 x86_64
Matthew Darcy
MDarcy at sch-group.net
Mon Jun 6 16:30:47 UTC 2011
Looking at the problems I've been having recently, this appears to be one of the core factors in it, and appears to tie into the error message I see in my apache error_log on a clean boot
Any input as to what is causing Oracle to have a problem would be most appreciated.
Thanks,
Matt
Exception reported from <CENSORED!>01.sccis.net
Time: Mon Jun 6 16:32:55 2011
Exception type <CENSORED!>.server.rhnSQL.sql_base.SQLError
Exception while handling function queue.submit Request object information:
URI: /XMLRPC
Remote Host: 80.86.39.120
Server Name: <CENSORED!>01.sccis.net:443 Headers passed in:
Accept-Encoding: identity
Content-Length: 2446
Host: <CENSORED!>01.sccis.net:443
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,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(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,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(1)=1,osad.ping(1)=1,packages.verify(1)=1,packages.extended_profile(2)=1,osad.rhn_check(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,packages.update(2)=2,script.run(1)=1,configfiles.upload(1)=1,packages.runTransaction(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 454, in submit
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/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/XE>>
modified_params = <type 'list'> []
value = <type 'list'> [150]
p = <type 'tuple'> ()
params = <type 'str'> 'server_id': 1000010080,'action_id': [150]
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': [150]}
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/XE>>
kw = <type 'dict'> {'server_id': 1000010080, 'action_id': [150]}
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/XE>>
server_id = <type 'int'> 1000010080
action_id = <type 'list'> [150]
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'> [150]
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'> [150]
f_action_ids = <type 'list'> [[150], 149]
self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2b4cba561518>
action_id = <type 'int'> 149
Frame submit in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 454
status = <type 'int'> 3
trigger_snapshot = <type 'bool'> True
rmsg = <type 'str'> Error while executing packages action: empty transaction [[6]]
h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost/XE>>
self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2b4cba561518>
data = <type 'dict'> {}
system_id = <type 'str'> <?xml version="1.0"?> <params> <param> <value><struct> <member> <name>username</name> <value><string>admin</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>2ca3efaafa8bae6d62fee59abd127834</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>vmbuild01</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>
result = <type 'list'> [6]
action_type = <type 'str'> packages.update
message = <type 'str'> Error while executing packages action: empty transaction
action_id = <type 'int'> 149
rcode = <type 'int'> -1
row = <type 'dict'> {'trigger_snapshot': 'Y', 'name': 'Package Install', 'action_type': 'packages.update'}
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 0x2b4cba687cf8>
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>admin</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>2ca3efaafa8bae6d62fee59abd127834</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>vmbuild01</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', 149, [6], 'Error while executing packages action: empty transaction', {})
func = <type 'instancemethod'> <bound method Queue.submit of <server.handlers.xmlrpc.queue.Queue instance at 0x2b4cba561518>>
method = <type 'str'> queue.submit
Frame process in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheRequest.py at line 472
fd = <type 'instance'> <cStringIO.StringO object at 0x2b4caec59828>
_body = <type 'str'> <?xml version='1.0'?> <methodCall> <methodName>queue.submit</methodName>
<params>
<param>
<value><string><?xml version="1.0"?> <params> <param> <value><struct> <member> <name>username</name> <value><string>admin</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>2ca3efaafa8bae6d62fee59abd127834</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>vmbuild01</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>
</string></value>
</param>
<param>
<value><int>149</int></value>
</param>
<param>
<value><array><data>
<value><int>6</int></value>
</data></array></value>
</param>
<param>
<value><string>Error while executing packages action: empty transaction</string></value> </param> <param> <value><struct> </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>admin</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>2ca3efaafa8bae6d62fee59abd127834</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>vmbuild01</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', 149, [6], 'Error while executing packages action: empty transaction', {})
method = <type 'str'> queue.submit
self = <type 'instance'> <<CENSORED!>.server.apacheRequest.apachePOST instance at 0x2b4cba687cf8>
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/XE>>
self = <type 'instance'> <<CENSORED!>.server.apacheHandler.apacheHandler instance at 0x2b4cba22ff80>
req = <type 'mp_request'> <mp_request object at 0x2b4ca1df0050>
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!>01.sccis.net'}
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 0x2b4ca1df0050>
self = <type 'instance'> <mod_python.apache.CallBack instance at 0x2b4ca1de8b90>
object = <type 'instancemethod'> <bound method apacheHandler.handler of <<CENSORED!>.server.apacheHandler.apacheHandler instance at 0x2b4cba22ff80>>
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=3320 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
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110606/559adb76/attachment.htm>
More information about the Spacewalk-list
mailing list