From mailing 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') Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info:
Fixed in commit 6aa980ce46e59e4a7de40bcfe6a5c2dfa87b92d7
Moving ON_QA ...
This bug has been fixed in Spacewalk 1.3.