[Spacewalk-list] Spacewalk Package Verify Fails 1.2

[Miroslav Suchý]

On 01/19/2011 12:39 AM, JDFire wrote:
> 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')
> 

Indeed. Malformed sql query.
I put this information in Bugzilla:
https://bugzilla.redhat.com/show_bug.cgi?id=670746

Thanks for reporting
-- 
Miroslav Suchy
Red Hat Satellite Engineering