Satellite upgrade from 5.3 to 5.4 is stopping due to 'ORA-00001: unique constraint (RHNSAT.RHN_SC_AC_SAID_UQ) violated' during schema upgrade

Solution Verified - Updated -

Issue

  • Encountering the following error during the schema upgrade step when upgrading from Red Hat Network Satellite 5.3 to 5.4:
# /usr/bin/spacewalk-schema-upgrade  
SQL> spool /var/log/spacewalk/schema-upgrade/20110430-135034-to-satellite-schema-5.4.log append  
SQL> whenever sqlerror exit sql.sqlcode  
SQL> select 'satellite-schema-5.3-to-satellite-schema-5.4/001-rhnServerChannelArchCompat.sql' from dual;  

'SATELLITE-SCHEMA-5.3-TO-SATELLITE-SCHEMA-5.4/001-RHNSERVERCHANNELARCHCOMPAT.SQ  
\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\---\----  
satellite-schema-5.3-to-satellite-schema-5.4/001-rhnServerChannelArchCompat.sql  

SQL> insert into rhnServerChannelArchCompat (server\_arch\_id, channel\_arch\_id) values  
 2 (LOOKUP\_SERVER\_ARCH('ppc64-redhat-linux'), LOOKUP\_CHANNEL\_ARCH('channel-ppc'));  
 insert into rhnServerChannelArchCompat (server\_arch\_id, channel\_arch\_id) values  
*  
ERROR at line 1:  
ORA-00001: unique constraint (RHNSAT.RHN\_SC\_AC\_SAID\_UQ) violated

Environment

  • Red Hat Network Satellite upgrade from 5.3 to 5.4
  • Updating the schema

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In