[Spacewalk-list] reposync error

[Michael Mraka]

Thomas Bendler wrote:
% Hi @all,
% 
% I got a strange reposync error when I try to update a FC channel:
% 
% 8/385 : wine-common-1.1.38-1.fc12-0.noarch
% ERRORException reported from sw.xxxx.de
% Time: Fri Feb 19 17:45:26 2010
% Exception type server.rhnSQL.sql_base.SQLError
...
% SQLError: (1422, 'ORA-01422: exact fetch returns more than requested number
% of rows\nORA-06512: at "SPACEWALK.LOOKUP_CHECKSUM", line 12\n', 'select
% lookup_checksum(:ctype, :csum) id from dual')
% 
% I got this error multiple times but only with this one FC channel. Somebody
% know how to fix? Look like, this is a SQL statement that return more than
% one value but expect only one.

Is it freshly installed spacewalk 0.8 or upgraded from 0.7?

What returns this query?
        select count(*) from (select checksum, count(*) from rhnchecksum
        group by checksum having count(*) < 1);

% Kind regards, Thomas

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat