<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=us-ascii"> <meta name=Generator content="Microsoft Word 11 (filtered medium)"> <style>  </style> </head> <body lang=EN-US link=blue vlink="#606420"> <div class=Section1> Ok, I have some news.<o:p></o:p> 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.<o:p></o:p> I have done:<o:p></o:p> Yum upgrade<o:p></o:p> Then, when I run:<o:p></o:p> [root@spacew up2date]# /usr/bin/spacewalk-schema-upgrade<o:p></o:p> Schema upgrade: [spacewalk-schema-0.2.5-1.el5.sw] -> [spacewalk-schema-0.3.6-1.el5.sw]<o:p></o:p> Searching for upgrade path: [spacewalk-schema-0.2.5-1] -> [spacewalk-schema-0.3.6-1]<o:p></o:p> Searching for upgrade path: [spacewalk-schema-0.2.5] -> [spacewalk-schema-0.3.6]<o:p></o:p> Searching for upgrade path: [spacewalk-schema-0.2] -> [spacewalk-schema-0.3]<o:p></o:p> The path: [spacewalk-schema-0.2] -> [spacewalk-schema-0.3]<o:p></o:p> Planing to run sqlplus with [/var/log/spacewalk/schema-upgrade/20081107-150935-script.sql]<o:p></o:p> Hit Enter to continue or Ctrl+C to interrupt:<o:p></o:p> Executing sqlplus, the logs are in /var/log/spacewalk/schema-upgrade/20081107-150935-*.<o:p></o:p> Upgrade failed, please see log in [/var/log/spacewalk/schema-upgrade/].<o:p></o:p> <o:p> </o:p> Here is the content of /var/log/spacewalk/schema-upgrade/20081107-150401-begin.log<o:p></o:p> SQL> whenever sqlerror exit sql.sqlcode<o:p></o:p> SQL><o:p></o:p> SQL> update rhnVersionInfo<o:p></o:p> 2 set label = 'schema-from', modified = sysdate<o:p></o:p> 3 where label = 'schema';<o:p></o:p> update rhnVersionInfo<o:p></o:p> *<o:p></o:p> ERROR at line 1:<o:p></o:p> ORA-00001: unique constraint (SPACEWALK.RHN_VERSIONINFO_LABEL_UQ) violated<o:p></o:p> <o:p> </o:p> <o:p> </o:p> Hi all,<o:p></o:p> I have tried upgrading from 02 to 03 and have to issues:<o:p></o:p> after I have used<o:p></o:p> yum upgrade spacewalk<o:p></o:p> <o:p> </o:p> - # /usr/bin/spacewalk-schema-upgrade<o:p></o:p> give me<o:p></o:p> Schema upgrade: [spacewalk-schema-0.2.5-1.el5.sw] -> [spacewalk-schema-0.2.5-1.el5.sw]<o:p></o:p> Your database schema already matches the schema package version [spacewalk-schema-0.2.5-1].<o:p></o:p> <o:p> </o:p> - # for service in jabberd osa-dispatcher taskomatic tomcat5 satellite-httpd Monitoring MonitoringScout rhn-search; do<o:p></o:p> if [ -e "/etc/init.d/$service" ]; then<o:p></o:p> /sbin/chkconfig --level 345 $service on<o:p></o:p> fi<o:p></o:p> gives me:<o:p></o:p> service taskomatic does not support chkconfig<o:p></o:p> service satellite-httpd does not support chkconfig<o:p></o:p> service rhn-search does not support chkconfig<o:p></o:p> <o:p> </o:p> Seems that the schema upgrade does not work (I can see in the web interface that the version is still 0.2)<o:p></o:p> <o:p> </o:p> Any ideas?<o:p></o:p> <o:p> </o:p> Romain<o:p></o:p> </div> </body> </html>