[Spacewalk-list] Spacewalk Package Verify Fails 1.2

Tue Jan 18 23:39:50 UTC 2011

Hello List,

I have a spacewalk implementation that is currently working except the Package Verify option. When I set a system to verify a package I get the follow traceback errors. Also the rhn_Check stops working. Please let me know what I need to do in order to resolve this issue. Thank you for your time and have a great day!

Exception reported from <hostname removed>
Time: Tue Jan 18 10:38:10 2011
Exception type spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError
Exception while handling function queue.get
Request object information:
URI: /XMLRPC
Remote Host: <hostname removed>
Server Name: <hostname removed>:0
Headers passed in:
Accept-Encoding: identity
Content-Length: 2744
Host: <hostname removed>
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.verifyAll(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.verifyAll(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.2.15-1.el5
Extra information about this error:
SQL Error generated: ('ORA-00923: FROM keyword not found where expected\n', 923, 'select distinct pn.name as name, pe.version as version, pe.release as release, pe.epoch as epoch, pa.label as arch left join rhnPackageArch pa on ap.package_arch_id = pa.id, rhnPackageName pn, rhnPackageEVR pe where ap.action_id = :actionid and ap.evr_id = pe.id and ap.name_id = pn.id')

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 326, in get
ret = self.__getV2(action)
File "/usr/share/rhn/server/handlers/xmlrpc/queue.py", line 84, in __getV2
result = method(self.server_id, action['id'], dry_run)
File "/usr/lib/python2.4/site-packages/spacewalk/server/action/packages.py", line 50, in verify
h.execute(actionid=actionId)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 166, in execute
return apply(self._execute_wrapper, (self._execute, ) + p, kw)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 107, in _execute_wrapper
raise apply(sql_base.SQLStatementPrepareError, args)
SQLStatementPrepareError: ('ORA-00923: FROM keyword not found where expected\n', 923, 'select distinct pn.name as name, pe.version as version, pe.release as release, pe.epoch as epoch, pa.label as arch left join rhnPackageArch pa on ap.package_arch_id = pa.id, rhnPackageName pn, rhnPackageEVR pe where ap.action_id = :actionid and ap.evr_id = pe.id and ap.name_id = pn.id')

Local variables by frame
Frame _execute_wrapper in /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py at line 107
function = <type 'instancemethod'> <bound method Cursor._execute of <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk at swdb00>>>
e = <type 'instance'> ORA-00923: FROM keyword not found where expected

errno = <type 'int'> 923
self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk at swdb00>>
args = <type 'tuple'> (923, 'ORA-00923: FROM keyword not found where expected\n', 'select distinct pn.name as name, pe.version as version, pe.release as release, pe.epoch as epoch, pa.label as arch left join rhnPackageArch pa on ap.package_arch_id = pa.id, rhnPackageName pn, rhnPackageEVR pe where ap.action_id = :actionid and ap.evr_id = pe.id and ap.name_id = pn.id')
modified_params = <type 'list'> []
value = <type 'int'> 218
p = <type 'tuple'> ()
params = <type 'str'> 'actionid': 218
ret = <type 'tuple'> (923, 'ORA-00923: FROM keyword not found where expected\n', 'select distinct pn.name as name, pe.version as version, pe.release as release, pe.epoch as epoch, pa.label as arch left join rhnPackageArch pa on ap.package_arch_id = pa.id, rhnPackageName pn, rhnPackageEVR pe where ap.action_id = :actionid and ap.evr_id = pe.id and ap.name_id = pn.id')
key = <type 'str'> actionid
kw = <type 'dict'> {'actionid': 218}
errmsg = <type 'str'> ORA-00923: FROM keyword not found where expected

Frame execute in /usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py at line 166
p = <type 'tuple'> ()
self = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk at swdb00>>
kw = <type 'dict'> {'actionid': 218}

Frame verify in /usr/lib/python2.4/site-packages/spacewalk/server/action/packages.py at line 50
h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk at swdb00>>
serverId = <type 'int'> 1000010002
actionId = <type 'int'> 218
dry_run = <type 'int'> 0

Frame __getV2 in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 84
action = <type 'dict'> {'id': 218, 'method': 'packages.verify', 'version': 2, 'remaining_tries': 10, 'unlocked_only': 'N', 'prerequisite': None}
self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2b37a6e00710>
method = <type 'function'> <function verify at 0x2b37a6e568c0>
dry_run = <type 'int'> 0

Frame get in /usr/share/rhn/server/handlers/xmlrpc/queue.py at line 347
status = <type 'dict'> {'uname': ['Linux', '<hostname removed>', '2.6.18-194.26.1.el5', '#1 SMP Tue Nov 9 12:54:20 EST 2010', 'x86_64'], 'uptime': [315, 309]}
h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk at swdb00>>
self = <type 'instance'> <server.handlers.xmlrpc.queue.Queue instance at 0x2b37a6e00710>
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>swadmin</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>cbc6fd80ebfd1c0a8f9c212f834e9dbc</string></value>
</member>
<member>
<name>profile_name</name>
<value><string><hostname removed></string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010002</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': 218, 'method': 'packages.verify', 'version': 2, 'remaining_tries': 10, 'unlocked_only': 'N', 'prerequisite': None}
server_locked = <type 'int'> 0
action_id = <type 'int'> 218

Frame call_function in /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 164
e = <type 'instance'> ('ORA-00923: FROM keyword not found where expected\n', 923, 'select distinct pn.name as name, pe.version as version, pe.release as release, pe.epoch as epoch, pa.label as arch left join rhnPackageArch pa on ap.package_arch_id = pa.id, rhnPackageName pn, rhnPackageEVR pe where ap.action_id = :actionid and ap.evr_id = pe.id and ap.name_id = pn.id')
self = <type 'instance'> <spacewalk.server.apacheRequest.apachePOST instance at 0x2b37a6e004d0>
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>swadmin</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>cbc6fd80ebfd1c0a8f9c212f834e9dbc</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string><hostname removed></string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010002</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', '<hostname removed>', '2.6.18-194.26.1.el5', '#1 SMP Tue Nov 9 12:54:20 EST 2010', 'x86_64'], 'uptime': [315, 309]})
func = <type 'instancemethod'> <bound method Queue.get of <server.handlers.xmlrpc.queue.Queue instance at 0x2b37a6e00710>>
method = <type 'unicode'> queue.get

Frame process in /usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py at line 471
fd = <type 'instance'> <cStringIO.StringO object at 0x2b378ffac6e8>
_body = <type 'str'> <?xml version='1.0'?>
<methodCall>
<methodName>queue.get</methodName>
<params>
<param>
<value><string><?xml version="1.0"?>
<params>
<param>
<value><struct>
<member>
<name>username</name>
<value><string>swadmin</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>cbc6fd80ebfd1c0a8f9c212f834e9dbc</string></value>
</member>
<member>
<name>profile_name</name>
<value><string><hostname removed></string></value>
</member>
<member>
<name>system_id</name>
<value><string>ID-1000010002</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>2</int></value>
</param>
<param>
<value><struct>
<member>
<name>uname</name>
<value><array><data>
<value><string>Linux</string></value>
<value><string><hostname removed></string></value>
<value><string>2.6.18-194.26.1.el5</string></value>
<value><string>#1 SMP Tue Nov 9 12:54:20 EST 2010</string></value>
<value><string>x86_64</string></value>
</data></array></value>
</member>
<member>
<name>uptime</name>
<value><array><data>
<value><int>315</int></value>
<value><int>309</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>swadmin</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>cbc6fd80ebfd1c0a8f9c212f834e9dbc</string></value>\n</member>\n<member>\n<name>profile_name</name>\n<value><string><hostname removed></string></value>\n</member>\n<member>\n<name>system_id</name>\n<value><string>ID-1000010002</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', '<hostname removed>', '2.6.18-194.26.1.el5', '#1 SMP Tue Nov 9 12:54:20 EST 2010', 'x86_64'], 'uptime': [315, 309]})
method = <type 'unicode'> queue.get
self = <type 'instance'> <spacewalk.server.apacheRequest.apachePOST instance at 0x2b37a6e004d0>

Frame handler in /usr/lib/python2.4/site-packages/spacewalk/server/apacheHandler.py at line 203
h = <type 'instance'> <__builtin__.OracleCursor on <cx_Oracle.Connection to spacewalk at swdb00>>
self = <type 'instance'> <spacewalk.server.apacheHandler.apacheHandler instance at 0x2b379885d2d8>
req = <type 'mp_request'> <mp_request object at 0x2b37a3093050>
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': '<hostname removed>'}
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 0x2b37a3093050>
self = <type 'instance'> <mod_python.apache.CallBack instance at 0x2b37a308bb48>
object = <type 'instancemethod'> <bound method apacheHandler.handler of <spacewalk.server.apacheHandler.apacheHandler instance at 0x2b379885d2d8>>
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=17365 on exception:
LANG = C
NLS_LANG = english.AL32UTF8
PATH = /sbin:/usr/sbin:/bin:/usr/bin
PWD = /
SHLVL = 2
TERM = xterm
_ = /usr/sbin/httpd
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20110118/6f81418a/attachment.htm>