Hi, I have open the Bug 470887 about this issue. Romain -----Message d'origine----- De : Clifford Perry [mailto:[EMAIL PROTECTED] Envoyé : 7 novembre 2008 16:39 À : spacewalk-list@redhat.com Cc : Pelissier, Romain (521333) Objet : Re: [Spacewalk-list] RE: Upgrading issues from 02 to 03
Romain Pelissier wrote: > > Ok, I have some news. > > I have check what are the rpm package version are installed vs what > are available on the new repository for 0.3 and found that I was not > up to date. > > I have done: > > Yum upgrade > > Then, when I run: > > [EMAIL PROTECTED] up2date]# /usr/bin/spacewalk-schema-upgrade > > Schema upgrade: [spacewalk-schema-0.2.5-1.el5.sw] -> > [spacewalk-schema-0.3.6-1.el5.sw] > > Searching for upgrade path: [spacewalk-schema-0.2.5-1] -> > [spacewalk-schema-0.3.6-1] > > Searching for upgrade path: [spacewalk-schema-0.2.5] -> > [spacewalk-schema-0.3.6] > > Searching for upgrade path: [spacewalk-schema-0.2] -> > [spacewalk-schema-0.3] > > The path: [spacewalk-schema-0.2] -> [spacewalk-schema-0.3] > > Planing to run sqlplus with > [/var/log/spacewalk/schema-upgrade/20081107-150935-script.sql] > > Hit Enter to continue or Ctrl+C to interrupt: > > Executing sqlplus, the logs are in > /var/log/spacewalk/schema-upgrade/20081107-150935-*. > > Upgrade failed, please see log in [/var/log/spacewalk/schema-upgrade/]. > > > > Here is the content of > /var/log/spacewalk/schema-upgrade/20081107-150401-begin.log > > SQL> whenever sqlerror exit sql.sqlcode > > SQL> > > SQL> update rhnVersionInfo > > 2 set label = 'schema-from', modified = sysdate > > 3 where label = 'schema'; > > update rhnVersionInfo > > * > > ERROR at line 1: > > ORA-00001: unique constraint (SPACEWALK.RHN_VERSIONINFO_LABEL_UQ) > violated > > > Just to follow up quickly - issue was because of previous upgrade from 0.1 -> 0.2 - we attempt to create a duplicate entry. Gave a short term work around solution on IRC. We need to address/fix code for the /usr/bin/spacewalk-schema-upgrade command to not attempt to create duplicate 'schema-from' entries in the DB, but maybe delete the old upgrade entry or sequentially bump them up. Cliff > > > Romain > > ------------------------------------------------------------------------ > > _______________________________________________ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list -- Clifford Perry Team Lead, Satellite Engineering Red Hat, Inc. http://www.redhat.com/ +1 919 754 4403 RHCA / RHCE# 805007680128201 _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
