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:
Then, when I run:
[root 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> update rhnVersionInfo
2 set label = 'schema-from', modified = sysdate
3 where label = 'schema';
ERROR at line 1:
ORA-00001: unique constraint (SPACEWALK.RHN_VERSIONINFO_LABEL_UQ) violated
I have tried upgrading from 02 to 03 and have to issues:
after I have used
yum upgrade spacewalk
- # /usr/bin/spacewalk-schema-upgrade
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
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)