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

[Jura Berg]

Hi, 

Is is possible to rerun spacewalk-schema-upgrade? 

I get error "Unknown schema name [no rows selected] found."


-J


-----Alkuperäinen viesti-----
Lähettäjä: spacewalk-list-bounces at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] Puolesta Milan Zazrivec
Lähetetty: 17. elokuuta 2010 13:19
Vastaanottaja: spacewalk-list at redhat.com
Aihe: Re: [Spacewalk-list] Spacewalk schema upgrade 1.0 -> 1.1 fails

On Monday 16 August 2010 14:35:40 Michael Mraka wrote:
> 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).

spacewalk-schema-1.1.31-1 is now available in Spacewalk 1.1 yum repo.

-MZ

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list