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

[romain.pelissier at bell.ca]

Hi,
I have open the Bug 470887 about this issue.
Romain

-----Message d'origine-----
De : Clifford Perry [mailto:cperry at redhat.com]
Envoyé : 7 novembre 2008 16:39
À : spacewalk-list at 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:
>
> [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