[Spacewalk-list] Spacewalk Package Verify Fails 1.2

[JDFire]

Thank you Miroslav!

Do you by chance know if this will get fixed in 1.2?

On Jan 19, 2011, at 1:29 AM, Miroslav Suchý <msuchy at redhat.com> wrote:

> 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
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list