[Spacewalk-list] reposync error
Michael Mraka
michael.mraka at redhat.com
Mon Feb 22 11:19:51 UTC 2010
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
More information about the Spacewalk-list
mailing list