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
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.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
