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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.