<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style></style></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1>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<o:p></o:p><o:p> </o:p>Any input as to what is causing Oracle to have a problem would be most appreciated.<o:p></o:p><o:p> </o:p>Thanks,<o:p></o:p><o:p> </o:p>Matt<o:p></o:p><o:p> </o:p><o:p> </o:p><o:p> </o:p><o:p> </o:p>Exception reported from <CENSORED!>01.sccis.net<o:p></o:p>Time: Mon Jun 6 16:32:55 2011<o:p></o:p>Exception type <CENSORED!>.server.rhnSQL.sql_base.SQLError<o:p></o:p>Exception while handling function queue.submit Request object information:<o:p></o:p>URI: /XMLRPC<o:p></o:p>Remote Host: 80.86.39.120<o:p></o:p>Server Name: <CENSORED!>01.sccis.net:443 Headers passed in:<o:p></o:p> Accept-Encoding: identity<o:p></o:p> Content-Length: 2446<o:p></o:p> Host: <CENSORED!>01.sccis.net:443<o:p></o:p> content-type: text/xml<o:p></o:p> user-agent: rhn.rpclib.py/$Revision$<o:p></o:p> x-client-version: 1<o:p></o:p> x-info: RPC Processor (C) Red Hat, Inc (version $Revision$)<o:p></o:p> 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<o:p></o:p> x-rhn-transport-capability: follow-redirects=3<o:p></o:p> x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc (version $Revision$)<o:p></o:p> x-up2date-version: 1.4.16-1.el5<o:p></o:p>Extra information about this error:<o:p></o:p>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')<o:p></o:p><o:p> </o:p>Exception Handler Information<o:p></o:p>Traceback (most recent call last):<o:p></o:p> File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheRequest.py", line 119, in call_function<o:p></o:p> response = apply(func, params)<o:p></o:p> File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 454, in submit<o:p></o:p> self._invalidate_child_actions(action_id)<o:p></o:p> File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 154, in _invalidate_child_actions<o:p></o:p> next_action_type=None)<o:p></o:p> File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnServer/server_kickstart.py", line 27, in update_kickstart_session<o:p></o:p> ks_session_id = get_kickstart_session_id(server_id, action_id)<o:p></o:p> File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnServer/server_kickstart.py", line 147, in get_kickstart_session_id<o:p></o:p> h.execute(server_id=server_id, action_id=action_id)<o:p></o:p> File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnSQL/sql_base.py", line 163, in execute<o:p></o:p> return apply(self._execute_wrapper, (self._execute, ) + p, kw)<o:p></o:p> File "/usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnSQL/driver_cx_Oracle.py", line 127, in _execute_wrapper<o:p></o:p> raise apply(sql_base.SQLError, ret)<o:p></o:p>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')<o:p></o:p><o:p> </o:p>Local variables by frame<o:p></o:p>Frame _execute_wrapper in /usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnSQL/driver_cx_Oracle.py at line 127<o:p></o:p> function = <type 'instancemethod'> <bound method Cursor._execute of <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost/XE>>><o:p></o:p> e = <type 'instance'> ORA-01484: arrays can only be bound to PL/SQL statements<o:p></o:p><o:p> </o:p> errno = <type 'int'> 1484<o:p></o:p> self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost/XE>><o:p></o:p> modified_params = <type 'list'> []<o:p></o:p> value = <type 'list'> [150]<o:p></o:p> p = <type 'tuple'> ()<o:p></o:p> params = <type 'str'> 'server_id': 1000010080,'action_id': [150]<o:p></o:p> 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')<o:p></o:p> key = <type 'str'> action_id<o:p></o:p> kw = <type 'dict'> {'server_id': 1000010080, 'action_id': [150]}<o:p></o:p> errmsg = <type 'str'> ORA-01484: arrays can only be bound to PL/SQL statements<o:p></o:p><o:p> </o:p><o:p> </o:p>Frame execute in /usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnSQL/sql_base.py at line 163<o:p></o:p> p = <type 'tuple'> ()<o:p></o:p> self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost/XE>><o:p></o:p> kw = <type 'dict'> {'server_id': 1000010080, 'action_id': [150]}<o:p></o:p><o:p> </o:p>Frame get_kickstart_session_id in /usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnServer/server_kickstart.py at line 147<o:p></o:p> h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost/XE>><o:p></o:p> server_id = <type 'int'> 1000010080<o:p></o:p> action_id = <type 'list'> [150]<o:p></o:p><o:p> </o:p>Frame update_kickstart_session in /usr/lib/python2.4/site-packages/<CENSORED!>/server/rhnServer/server_kickstart.py at line 27<o:p></o:p> server_id = <type 'int'> 1000010080<o:p></o:p> kickstart_state = <type 'str'> failed<o:p></o:p> action_id = <type 'list'> [150]<o:p></o:p> action_status = <type 'int'> 3<o:p></o:p> next_action_type = <type 'NoneType'> None<o:p></o:p><o:p> </o:p>Frame _invalidate_child_actions in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 154<o:p></o:p> f_action_id = <type 'list'> [150]<o:p></o:p> f_action_ids = <type 'list'> [[150], 149]<o:p></o:p> self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2b4cba561518><o:p></o:p> action_id = <type 'int'> 149<o:p></o:p><o:p> </o:p>Frame submit in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 454<o:p></o:p> status = <type 'int'> 3<o:p></o:p> trigger_snapshot = <type 'bool'> True<o:p></o:p> rmsg = <type 'str'> Error while executing packages action: empty transaction [[6]]<o:p></o:p> h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost/XE>><o:p></o:p> self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2b4cba561518><o:p></o:p> data = <type 'dict'> {}<o:p></o:p> system_id = <type 'str'> <?xml version="1.0"?> <params> <param> <value><struct> <member> <name>username</name> <value><string>admin</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>operating_system</name><o:p></o:p><value><string>centos-release</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>description</name><o:p></o:p><value><string>Initial Registration Parameters:<o:p></o:p>OS: centos-release<o:p></o:p>Release: 5<o:p></o:p>CPU Arch: x86_64-redhat-linux</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>checksum</name><o:p></o:p><value><string>2ca3efaafa8bae6d62fee59abd127834</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>profile_name</name><o:p></o:p><value><string>vmbuild01</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>system_id</name><o:p></o:p><value><string>ID-1000010080</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>architecture</name><o:p></o:p><value><string>x86_64-redhat-linux</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>os_release</name><o:p></o:p><value><string>5</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>fields</name><o:p></o:p><value><array><data><o:p></o:p><value><string>system_id</string></value><o:p></o:p><value><string>os_release</string></value><o:p></o:p><value><string>operating_system</string></value><o:p></o:p><value><string>architecture</string></value><o:p></o:p><value><string>username</string></value><o:p></o:p><value><string>type</string></value><o:p></o:p></data></array></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>type</name><o:p></o:p><value><string>REAL</string></value><o:p></o:p></member><o:p></o:p></struct></value><o:p></o:p></param><o:p></o:p></params><o:p></o:p><o:p> </o:p> result = <type 'list'> [6]<o:p></o:p> action_type = <type 'str'> packages.update<o:p></o:p> message = <type 'str'> Error while executing packages action: empty transaction<o:p></o:p> action_id = <type 'int'> 149<o:p></o:p> rcode = <type 'int'> -1<o:p></o:p> row = <type 'dict'> {'trigger_snapshot': 'Y', 'name': 'Package Install', 'action_type': 'packages.update'}<o:p></o:p><o:p> </o:p>Frame call_function in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheRequest.py at line 165<o:p></o:p> 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')<o:p></o:p> self = <type 'instance'> <<CENSORED!>.server.apacheRequest.apachePOST instance at 0x2b4cba687cf8><o:p></o:p> force_rollback = <type 'int'> 1<o:p></o:p> 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', {})<o:p></o:p> func = <type 'instancemethod'> <bound method Queue.submit of <server.handlers.xmlrpc.queue.Queue instance at 0x2b4cba561518>><o:p></o:p> method = <type 'str'> queue.submit<o:p></o:p><o:p> </o:p>Frame process in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheRequest.py at line 472<o:p></o:p> fd = <type 'instance'> <cStringIO.StringO object at 0x2b4caec59828><o:p></o:p> _body = <type 'str'> <?xml version='1.0'?> <methodCall> <methodName>queue.submit</methodName><o:p></o:p><params><o:p></o:p><param><o:p></o:p><value><string><?xml version="1.0"?> <params> <param> <value><struct> <member> <name>username</name> <value><string>admin</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>operating_system</name><o:p></o:p><value><string>centos-release</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>description</name><o:p></o:p><value><string>Initial Registration Parameters:<o:p></o:p>OS: centos-release<o:p></o:p>Release: 5<o:p></o:p>CPU Arch: x86_64-redhat-linux</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>checksum</name><o:p></o:p><value><string>2ca3efaafa8bae6d62fee59abd127834</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>profile_name</name><o:p></o:p><value><string>vmbuild01</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>system_id</name><o:p></o:p><value><string>ID-1000010080</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>architecture</name><o:p></o:p><value><string>x86_64-redhat-linux</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>os_release</name><o:p></o:p><value><string>5</string></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>fields</name><o:p></o:p><value><array><data><o:p></o:p><value><string>system_id</string></value><o:p></o:p><value><string>os_release</string></value><o:p></o:p><value><string>operating_system</string></value><o:p></o:p><value><string>architecture</string></value><o:p></o:p><value><string>username</string></value><o:p></o:p><value><string>type</string></value><o:p></o:p></data></array></value><o:p></o:p></member><o:p></o:p><member><o:p></o:p><name>type</name><o:p></o:p><value><string>REAL</string></value><o:p></o:p></member><o:p></o:p></struct></value><o:p></o:p></param><o:p></o:p></params><o:p></o:p></string></value><o:p></o:p></param><o:p></o:p><param><o:p></o:p><value><int>149</int></value><o:p></o:p></param><o:p></o:p><param><o:p></o:p><value><array><data><o:p></o:p><value><int>6</int></value><o:p></o:p></data></array></value><o:p></o:p></param><o:p></o:p><param><o:p></o:p><value><string>Error while executing packages action: empty transaction</string></value> </param> <param> <value><struct> </struct></value> </param> </params> </methodCall><o:p></o:p><o:p> </o:p> 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', {})<o:p></o:p> method = <type 'str'> queue.submit<o:p></o:p> self = <type 'instance'> <<CENSORED!>.server.apacheRequest.apachePOST instance at 0x2b4cba687cf8><o:p></o:p><o:p> </o:p>Frame handler in /usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheHandler.py at line 193<o:p></o:p> h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to <CENSORED!>@//localhost/XE>><o:p></o:p> self = <type 'instance'> <<CENSORED!>.server.apacheHandler.apacheHandler instance at 0x2b4cba22ff80><o:p></o:p> req = <type 'mp_request'> <mp_request object at 0x2b4ca1df0050><o:p></o:p> ret = <type 'int'> 0<o:p></o:p> 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'}<o:p></o:p> row = <type 'NoneType'> None<o:p></o:p><o:p> </o:p>Frame HandlerDispatch in /usr/lib64/python2.4/site-packages/mod_python/apache.py at line 299<o:p></o:p> req = <type 'mp_request'> <mp_request object at 0x2b4ca1df0050><o:p></o:p> self = <type 'instance'> <mod_python.apache.CallBack instance at 0x2b4ca1de8b90><o:p></o:p> object = <type 'instancemethod'> <bound method apacheHandler.handler of <<CENSORED!>.server.apacheHandler.apacheHandler instance at 0x2b4cba22ff80>><o:p></o:p> l = <type 'list'> ['<CENSORED!>.server.apacheServer', 'Handler']<o:p></o:p> module = <type 'module'> <module '<CENSORED!>.server.apacheServer' from '/usr/lib/python2.4/site-packages/<CENSORED!>/server/apacheServer.pyc'><o:p></o:p> hlist = <type 'mp_hlist'> {'handler:'<CENSORED!>.server.apacheServer::Handler','directory':'/XMLRPC/','silent':0}<o:p></o:p> object_str = <type 'str'> Handler<o:p></o:p> debug = <type 'int'> 0<o:p></o:p> module_name = <type 'str'> <CENSORED!>.server.apacheServer<o:p></o:p> config = <type 'mp_table'> {'PythonInterpreter': 'rhn.server'}<o:p></o:p> dir = <type 'str'> /XMLRPC/<o:p></o:p> result = <type 'int'> 500<o:p></o:p><o:p> </o:p><o:p> </o:p>Environment for PID=3320 on exception:<o:p></o:p>CONSOLE = /dev/console<o:p></o:p>HOME = /<o:p></o:p>INIT_VERSION = sysvinit-2.86<o:p></o:p>LANG = C<o:p></o:p>NLS_LANG = english.AL32UTF8<o:p></o:p>PATH = /sbin:/usr/sbin:/bin:/usr/bin<o:p></o:p>PREVLEVEL = N<o:p></o:p>PWD = /<o:p></o:p>RUNLEVEL = 3<o:p></o:p>SELINUX_INIT = YES<o:p></o:p>SHLVL = 3<o:p></o:p>TERM = linux<o:p></o:p>_ = /usr/sbin/httpd<o:p></o:p>previous = N<o:p></o:p>runlevel = 3<o:p></o:p><o:p> </o:p></div> ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ </body></html>