Red Hat Bugzilla – Bug 470887
Upgrade from 0.2 to 03 issue updatin versioninfo
Last modified: 2012-03-06 03:45:17 EST
Description of problem:
When upgrading from 02 to 03 using the /usr/bin/spacewalk-schema-upgrade script the error below appear:
'ORA-00001: unique constraint (SPACEWALK.RHN_VERSIONINFO_LABEL_UQ) violated'
Version-Release number of selected component (if applicable):
Steps to Reproduce:
2.Upgrade to 0.2
3.Upgrade to 0.3
Cannot upgrade to 0.3 from 0.2
No issue during versioninfo update with the upgrade script.
I have asked for help in he IRC channel and cperry-afk was kind enought to help me with this.
He gave me a workaround that actually solve the issue:
- Edit the /usr/bin/spacewalk-schema-upgrade script
- search the script for 'schema-from' and change it for 'schema-from2'
- save the script and run it, The upgrade process should works this time.
Here is the chat transcript that we had on IRC about the issue:
<romainpelissier> Hi, I have a big issue when upgrading from 02 to 03 is anybody can help?
<romainpelissier> I have logged my issue in the forum : https://www.redhat.com/archives/spacewalk-list/2008-November/msg00048.html
<romainpelissier> Anybody here?
<romainpelissier> still nobody?
<cperry-afk> kinda slow, helping someone else atm in another channel.. I assume you did follow the upgrade docs?
<cperry-afk> https://fedorahosted.org/spacewalk/wiki/HowToUpgrade romainpelissier ?
<romainpelissier> Yes, I fact the first try I have used only yum upgrade spacewalk since I only wanted to update spacewalk. Then I have follwed the reaming step. At the point of upgrading the schema is says that it is the same version
<romainpelissier> then I have check the rpm version on my system versus the one on the repo and see that the rpm schema was not the same
<romainpelissier> so I have used yum upgrade this time
<romainpelissier> All was utpdate of course
<romainpelissier> then tested the command /usr/bin/spacewalk-schema-upgrade
<romainpelissier> but it fail with the error : Upgrade failed
<romainpelissier> I have post the content of var/log/spacewalk/schema-upgrade/20081107-154334-begin.log
<romainpelissier> the error is : ORA-00001: unique constraint (SPACEWALK.RHN_VERSIONINFO_LABEL_UQ) violated
<romainpelissier> really don't know what to do...
<cperry-afk> *nod* k...
<cperry-afk> (done with other person... just reading now.. I did not test the upgrades... so not overly familiar with them as written:)
<romainpelissier> thank anyway ;-)
<cperry-afk> ok - so first email was indeed because "yum upgrade spacewalk" did not upgrade all packages needed, thus the schema and chkconfig steps failed.. you seem to notice that... (still reading/reviewing 2nd one now and docs/process) :)
<romainpelissier> yes, I am not very familiar with yum and I thought that only use yum upgrade spacewalk will update spacewalk which not seems to be the case...
<romainpelissier> but I did the upgrade after I saw my mistake
<cperry-afk> going to look at the upgrade package... see what SQL is was tryign to run to throw that error
<cperry-afk> romainpelissier, was the 0.2 a clean 0.2 install, or upgrade from 0.1?
<romainpelissier> an upgrade from 0.1
<romainpelissier> but the upgrade from 0.1 to 0.2 was fine
<cperry-afk> k ..
<cperry-afk> anyone got an 0.3 SW I can login to confirm an SQL query before asking romainpelissier to run it?
<cperry-afk> weshay? :)
<cperry-afk> we seem to be trying to insert a duplicate label entry to table, not sure why, where going wrong :)
<cperry-afk> my $start = $start_schema_norm;
<cperry-afk> my $in = <<EOF;
<cperry-afk> spool /var/log/spacewalk/schema-upgrade/$stamp-begin.log append
<cperry-afk> whenever sqlerror exit sql.sqlcode
<cperry-afk> update rhnVersionInfo
<cperry-afk> set label = 'schema-from', modified = sysdate
<cperry-afk> where label = 'schema';
<cperry-afk> you did an 0.1 -> 0.2 upgrade - we created an entry for 'schema-from' - your now trying to do an 0.2 -> 0.3 and create a second (duplicate entry)... our code does not remove/rename the old upgrade 'from' label
<cperry-afk> okay romainpelissier I think I see what is happening..
<romainpelissier> I see...
<romainpelissier> Is there a way to to the upgrade anyway withour removeing/upgrading the from label?
<cperry-afk> as a quick 'hack' edit the usr/bin/spacewalk-schema-upgrade script and change 'schema-from' to 'schema-from-2' and try again
<romainpelissier> I do this right now.
<cperry-afk> our code needs to take into consideration multiple upgraded systems, which it does not do right now - we only tested an 0.2 install upgrade to 0.3 - which is why we did not catch it :/
* cperry-afk waits though for feedback before doing the bug report
<romainpelissier> Yes ! The database schema was upgraded to version [spacewalk-schema-0.3.6-1.el5.sw]
<romainpelissier> starting spacewalk now
<romainpelissier> cperry-afk? Do you want me to fill the bug report?
<romainpelissier> Spacewalk release 0.3 is now display in the web interface
<romainpelissier> seems to be ok so far. but the login logout page is buggy....
<romainpelissier> AFK fro 5 mns, sorry
<cperry-afk> romainpelissier, back (I needed a drink myself) - yes, please file the bug report, copy this IRC session in it, reply to the email with Bugzilla # :)
<romainpelissier> perfect! I will (not today but very soon) Thanks again cperry-afk! have a nice we!
*** This bug has been marked as a duplicate of bug 470791 ***