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ý <[email protected]> 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 > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
