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

[Romain Pelissier]

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

 

 

Hi all,

I have tried upgrading from 02 to 03 and have to issues:

after I have used

yum upgrade spacewalk

 

- # /usr/bin/spacewalk-schema-upgrade

give me

Schema upgrade: [spacewalk-schema-0.2.5-1.el5.sw] ->
[spacewalk-schema-0.2.5-1.el5.sw]

Your database schema already matches the schema package version
[spacewalk-schema-0.2.5-1].

 

- # for service in jabberd osa-dispatcher taskomatic tomcat5 satellite-httpd
Monitoring MonitoringScout rhn-search; do

    if [ -e "/etc/init.d/$service" ]; then

        /sbin/chkconfig --level 345 $service on

    fi

gives me:

service taskomatic does not support chkconfig

service satellite-httpd does not support chkconfig

service rhn-search does not support chkconfig

 

Seems that the schema upgrade does not work (I can see in the web interface
that the version is still 0.2)

 

Any ideas?

 

Romain

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20081107/e897e424/attachment.htm>