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

[Michiel van Es]

Hi,

I have the same bug.
How can I work around this bug?

Kind regards,

Michiel van Es
Managed Hosting | systeembeheerder


On 10-11-2008 20:10, romain.pelissier at bell.ca wrote:
> 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
> 
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 258 bytes
Desc: OpenPGP digital signature
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20081114/21bec7e9/attachment.sig>