[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

[Spacewalk-list] Random Oracle Error Spacewalk 1.4 centos 5.6 x86_64



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 = "" '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>&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;admin&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;2ca3efaafa8bae6d62fee59abd127834&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;vmbuild01&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>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
______________________________________________________________________

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]