Bug 470887

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):


How reproducible:


Steps to Reproduce:
1.Install 0.1

2.Upgrade to 0.2

3.Upgrade to 0.3
  
Actual results:
Cannot upgrade to 0.3 from 0.2

Expected results:
No issue during versioninfo update with the upgrade script.


Additional info:
I have asked for help in he IRC channel and cperry-afk was kind enought to help me with this.

Workaround:
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>	Please?
	<romainpelissier>	still nobody?
	<cperry-afk>	reading
	<romainpelissier>	thanks!
	<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>	ooo...
	<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>	commit;
	<cperry-afk>	EOF
	<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!