Description of problem: I tried to upgrade satellite 5.3 to satellite 5.7 with external oracle and I received following error during upgrade. >> spacewalk-schema-upgrade Schema upgrade: [satellite-schema-5.3.0.23-1.el5sat] -> [satellite-schema-5.7.0.11-1.el6sat] Searching for upgrade path: [satellite-schema-5.3.0.23-1] -> [satellite-schema-5.7.0.11-1] Searching for upgrade path: [satellite-schema-5.3.0.23] -> [satellite-schema-5.7.0.11] Searching for upgrade path: [satellite-schema-5.3.0] -> [satellite-schema-5.7.0] Searching for upgrade path: [satellite-schema-5.3] -> [satellite-schema-5.7] The path: [satellite-schema-5.3] -> [satellite-schema-5.4] -> [satellite-schema-5.5] -> [satellite-schema-5.6] -> [satellite-schema-5.7] Planning to run spacewalk-sql with [/var/log/spacewalk/schema-upgrade/20160301-074824-script.sql] Plase make sure you have a valid backup of your database before continuing. Hit Enter to continue or Ctrl+C to interrupt: Executing spacewalk-sql, the log is in [/var/log/spacewalk/schema-upgrade/20160301-074824-to-satellite-schema-5.7.log]. Upgrade failed, please see log [/var/log/spacewalk/schema-upgrade/20160301-074824-to-satellite-schema-5.7.log]. [root@test08-64 ~]# tail /var/log/spacewalk/schema-upgrade/20160301-074824-to-satellite-schema-5.7.log Version-Release number of selected component (if applicable): rhn-upgrade-5.7.0.27-1.el6sat.noarch How reproducible: always on oracle Steps to Reproduce: 1. Install satellite 5.3 with oracle 2. try to migrate to new system with oracle 3. spacewalk-schema-upgrade Actual results: 'SATELLITE-SCHEMA-5.5-TO-SATELLITE-SCHEMA-5.6/037-SUPPORT-FOR-ARMV5-CHANNEL.SQL.ORACL ------------------------------------------------------------------------------------- satellite-schema-5.5-to-satellite-schema-5.6/037-support-for-armv5-channel.sql.oracle insert into rhnChannelArch (id, label, name, arch_type_id) values * ERROR at line 1: ORA-00001: unique constraint (RHNSAT.RHN_CARCH_LABEL_UQ) violated
Verified Schema upgrade: [satellite-schema-5.3.0.23-1.el5sat] -> [satellite-schema-5.7.0.23-1.el6sat] Searching for upgrade path: [satellite-schema-5.3.0.23-1] -> [satellite-schema-5.7.0.23-1] Searching for upgrade path: [satellite-schema-5.3.0.23] -> [satellite-schema-5.7.0.23] Searching for upgrade path: [satellite-schema-5.3.0] -> [satellite-schema-5.7.0] Searching for upgrade path: [satellite-schema-5.3] -> [satellite-schema-5.7] The path: [satellite-schema-5.3] -> [satellite-schema-5.4] -> [satellite-schema-5.5] -> [satellite-schema-5.6] -> [satellite-schema-5.7] Planning to run spacewalk-sql with [/var/log/spacewalk/schema-upgrade/20160419-133646-script.sql] Plase make sure you have a valid backup of your database before continuing. Hit Enter to continue or Ctrl+C to interrupt: Executing spacewalk-sql, the log is in [/var/log/spacewalk/schema-upgrade/20160419-133646-to-satellite-schema-5.7.log]. The database schema was upgraded to version [satellite-schema-5.7.0.23-1.el6sat].
Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://rhn.redhat.com/errata/RHBA-2016-0698.html