[Spacewalk-list] Spacewalk schema upgrade 1.0 -> 1.1 fails

[Michael Mraka]

Christoph Sievers wrote:
% Hi,
% 
% spacewalk-schema-upgrade fails with the following error:
% 
% SQL> CREATE UNIQUE INDEX rhn_sp_snep_uq
%     ON rhnServerPackage (server_id, name_id, evr_id, package_arch_id)
%     TABLESPACE USERS
%     NOLOGGING;
%   2    3    4      ON rhnServerPackage (server_id, name_id, evr_id,
% package_arch_id)
%        *
% ERROR at line 2:
% 
% ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

Hi Christoph,

I've fixed upgrade script. It should land in spacewalk 1.1 repo soon (look for
spacewalk-schema-1.1.31-1).

Thanks for the report.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat