[Spacewalk-list] SQL errors after upgrade 1.2 -> 1.3
Nat N
phenisha at gmail.com
Wed Mar 23 04:31:33 UTC 2011
Hello.
After (successfully) upgrading from 1.2 to 1.3. I am now getting the
following alerts being sent to me
I am using centos 5.5 (with a postgres backend)
Any ideas? the SQL generated looks OK to me so I am not sure...
Thanks!!
Nathan
Exception reported from xenon.host.com
Time: Wed Mar 23 14:15:44 2011
Exception type spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError
Exception while handling function queue.submit
Request object information:
URI: /XMLRPC
Remote Host: ws001.host.com
Server Name: mrepo.host.com:0
Headers passed in:
Accept-Encoding: identity
Content-Length: 2575
Host: xenon.host.com
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:
packages.verifyAll(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,reboot.reboot(1)=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1,packages.verifyAll(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=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.3.12-1.el6
Extra information about this error:
SQL Error generated: ('syntax error at or near "with id" at character
143\n', 0, '\n select sa.action_id, sa.status\n from
rhnServerAction sa,\n (\n select id\n from
rhnAction\n start with id = %(action_id)s\n
connect by prior id = prerequisite\n ) a\n where
sa.server_id = %(server_id)s\n and sa.action_id = a.id\n')
Exception Handler Information
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py",
line 118, 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 149, in
_invalidate_child_actions
f_action_ids = rhnAction.invalidate_action(self.server_id, action_id)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnAction.py",
line 111, in invalidate_action
h.execute(server_id=server_id, action_id=action_id)
File "/usr/lib/python2.4/site-packages/spacewalk/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/spacewalk/server/rhnSQL/driver_postgresql.py",
line 268, in _execute_wrapper
raise rhnSQL.SQLStatementPrepareError(0, str(e), self.sql)
SQLStatementPrepareError: ('syntax error at or near "with id" at
character 143\n', 0, '\n select sa.action_id, sa.status\n from
rhnServerAction sa,\n (\n select id\n from
rhnAction\n start with id = %(action_id)s\n
connect by prior id = prerequisite\n ) a\n where
sa.server_id = %(server_id)s\n and sa.action_id = a.id\n')
Local variables by frame
Frame _execute_wrapper in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py
at line 268
function = <type 'instancemethod'> <bound method
Cursor._execute of <spacewalk.server.rhnSQL.driver_postgresql.Cursor
instance at 0x2abc1f488248>>
e = <type 'instance'> syntax error at or
near "with id" at character 143
self = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2abc1f488248>
value = <type 'int'> 11
p = <type 'tuple'> ()
kw = <type 'dict'> {'server_id': 1000010000,
'action_id': 11}
key = <type 'str'> action_id
params = <type 'str'> server_id: 1000010000,action_id: 11
Frame execute in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py
at line 163
p = <type 'tuple'> ()
self = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2abc1f488248>
kw = <type 'dict'> {'server_id': 1000010000,
'action_id': 11}
Frame invalidate_action in
/usr/lib/python2.4/site-packages/spacewalk/server/rhnAction.py at line
111
h = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2abc1f488248>
server_id = <type 'int'> 1000010000
action_id = <type 'int'> 11
Frame _invalidate_child_actions in
/usr/share/rhn/server/handlers/xmlrpc/queue.py at line 149
self = <type 'instance'>
<server.handlers.xmlrpc.queue.Queue instance at 0x2abc1edd09e0>
action_id = <type 'int'> 11
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'> Failed: Packages failed to
install properly: No package(s) available to install
h = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2abc1f49cbd8>
self = <type 'instance'>
<server.handlers.xmlrpc.queue.Queue instance at 0x2abc1edd09e0>
data = <type 'dict'> {'version': '1', 'name':
'package_install_failure'}
system_id = <type 'str'> <?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>sysadmin</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>redhat-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: redhat-release
Release: 6
CPU Arch: x86_64</string></value>
</member>
<member>
<name>checksum</name>
<value><string>e61b1e765db0a66152624b65d73dc7ba</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>ws001.host.com</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010000</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64</string></value>
</member>
<member>
<name>os_release</name>
<value><string>6</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 'int'> 32
action_type = <type 'str'> packages.update
message = <type 'str'> Failed: Packages failed to
install properly: No package(s) available to install
action_id = <type 'int'> 11
rcode = <type 'int'> 32
row = <type 'dict'> {'trigger_snapshot': 'Y',
'name': 'Package Install', 'action_type': 'packages.update'}
Frame call_function in
/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at
line 164
e = <type 'instance'> ('syntax error at or
near "with id" at character 143\n', 0, '\n select sa.action_id,
sa.status\n from rhnServerAction sa,\n (\n
select id\n from rhnAction\n start with id =
%(action_id)s\n connect by prior id = prerequisite\n
) a\n where sa.server_id = %(server_id)s\n and
sa.action_id = a.id\n')
self = <type 'instance'>
<spacewalk.server.apacheRequest.apachePOST instance at 0x2abc1e8b1290>
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>sysadmin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>redhat-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial
Registration Parameters:\nOS: redhat-release\nRelease: 6\nCPU Arch:
x86_64</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>e61b1e765db0a66152624b65d73dc7ba</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>ws001.host.com</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010000</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>6</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array><data>\n<value><string>syst
em_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',
11, 32, 'Failed: Packages failed to install properly: No package(s)
available to install', {'version': '1', 'name':
'package_install_failure'})
func = <type 'instancemethod'> <bound method
Queue.submit of <server.handlers.xmlrpc.queue.Queue instance at
0x2abc1edd09e0>>
method = <type 'unicode'> queue.submit
Frame process in
/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at
line 471
fd = <type 'instance'> <cStringIO.StringO
object at 0x2abc170cd4b8>
_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>sysadmin</string></value>
</member>
<member>
<name>operating_system</name>
<value><string>redhat-release</string></value>
</member>
<member>
<name>description</name>
<value><string>Initial Registration Parameters:
OS: redhat-release
Release: 6
CPU Arch: x86_64</string></value>
</member>
<member>
<name>checksum</name>
<value><string>e61b1e765db0a66152624b65d73dc7ba</string></value>
</member>
<member>
<name>profile_name</name>
<value><string>ws001.host.com</string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010000</string></value>
</member>
<member>
<name>architecture</name>
<value><string>x86_64</string></value>
</member>
<member>
<name>os_release</name>
<value><string>6</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>11</int></value>
</param>
<param>
<value><int>32</int></value>
</param>
<param>
<value><string>Failed: Packages failed to install properly: No
package(s) available to install</string></value>
</param>
<param>
<value><struct>
<member>
<name>version</name>
<value><string>1</string></value>
</member>
<member>
<name>name</name>
<value><string>package_install_failure</string></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>sysadmin</string></value>\n</member>\n<member>\n<name>operating_system</name>\n<value><string>redhat-release</string></value>\n</member>\n<member>\n<name>description</name>\n<value><string>Initial
Registration Parameters:\nOS: redhat-release\nRelease: 6\nCPU Arch:
x86_64</string></value>\n</member>\n<member>\n<name>checksum</name>\n<value><string>e61b1e765db0a66152624b65d73dc7ba</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string>ws001.host.com</string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010000</string></value>\n</member>\n<member>\n<name>architecture</name>\n<value><string>x86_64</string></value>\n</member>\n<member>\n<name>os_release</name>\n<value><string>6</string></value>\n</member>\n<member>\n<name>fields</name>\n<value><array><data>\n<value><string>syst
em_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',
11, 32, 'Failed: Packages failed to install properly: No package(s)
available to install', {'version': '1', 'name':
'package_install_failure'})
method = <type 'unicode'> queue.submit
self = <type 'instance'>
<spacewalk.server.apacheRequest.apachePOST instance at 0x2abc1e8b1290>
Frame handler in
/usr/lib/python2.4/site-packages/spacewalk/server/apacheHandler.py at
line 193
h = <type 'instance'>
<spacewalk.server.rhnSQL.driver_postgresql.Cursor instance at
0x2abc185b3950>
self = <type 'instance'>
<spacewalk.server.apacheHandler.apacheHandler instance at
0x2abc19ebd170>
req = <type 'mp_request'> <mp_request object
at 0x2abc185b1050>
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': 'xenon.host.com'}
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 0x2abc185b1050>
self = <type 'instance'>
<mod_python.apache.CallBack instance at 0x2abc185a9b48>
object = <type 'instancemethod'> <bound method
apacheHandler.handler of <spacewalk.server.apacheHandler.apacheHandler
instance at 0x2abc19ebd170>>
l = <type 'list'>
['spacewalk.server.apacheServer', 'Handler']
module = <type 'module'> <module
'spacewalk.server.apacheServer' from
'/usr/lib/python2.4/site-packages/spacewalk/server/apacheServer.pyc'>
hlist = <type 'mp_hlist'>
{'handler:'spacewalk.server.apacheServer::Handler','directory':'/XMLRPC/','silent':0}
object_str = <type 'str'> Handler
debug = <type 'int'> 0
module_name = <type 'str'> spacewalk.server.apacheServer
config = <type 'mp_table'> {'PythonInterpreter':
'rhn.server'}
dir = <type 'str'> /XMLRPC/
result = <type 'int'> 500
Environment for PID=14266 on exception:
LANG = C
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PWD = /
SHLVL = 2
TERM = xterm
_ = /usr/sbin/httpd
More information about the Spacewalk-list
mailing list