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ä: [email protected] > [mailto:[email protected]] Puolesta Milan Zazrivec > Lähetetty: 17. elokuuta 2010 13:19 > Vastaanottaja: [email protected] > 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 > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list > > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
