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

[Milan Zazrivec]

On Tuesday 17 August 2010 12:54:40 Jura Berg wrote:
> Hi,
> 
> Is is possible to rerun spacewalk-schema-upgrade?
> 
> I get error "Unknown schema name [no rows selected] found."

You need to restore spacewalk 1.0 schema from backup and then
run spacewalk-schema-upgrade.

-MZ

> -----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
> 
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list