[Spacewalk-list] Errata search by CVE fails

[Jan Pazdziora]

On Wed, Jan 23, 2013 at 09:02:57PM +0100, Pierre Casenove wrote:
> Hello list,
> I'm using spacewalk 1.8 on a rhel 5 server.
> I've been trying to search an errata by CVE.
> In the search field, I put the name of the CVE (for example CVE-2012-0611)
> and select "Search by CVE" but it fails with error "could not execute
> query".
> In the catalina.out file, I've got the following error:
> 2013-01-23 16:32:27,138 [TP-Processor8] WARN
>  com.redhat.rhn.frontend.action.errata.ErrataSearchAction - Performing
> errata search
> redstone.xmlrpc.XmlRpcFault: redstone.xmlrpc.XmlRpcFault:
> --- The error occurred in com/redhat/satellite/search/db/errata_handler.xml.
> --- The error occurred while applying a parameter map.
> --- Check the listErrataByCVE-InlineParameterMap.
> --- Check the statement (query failed).
> --- Cause: org.postgresql.util.PSQLException: ERROR: operator does not
> exist: numeric = character varying
> 
> Is this a known issue?

It's now been fixed in Spacewalk master via bug
	
	https://bugzilla.redhat.com/show_bug.cgi?id=905872

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat