[Spacewalk-list] RE: Upgrading issues from 02 to 03

[Clifford Perry]

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:
>
> [root at spacew 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 at 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