On Fri, 7 Jan 2011, Michael Mraka wrote:
John Hodrien wrote:
Posting inline the matching log entries:
% In total this was four cases:
%
% 210-rhnPackage-indexes.sql
spacewalk-schema-1.1-to-spacewalk-schema-1.2/210-rhnPackage-indexes.sql
SQL>
SQL> drop index rhn_package_id_nid_paid_idx;
Index dropped.
SQL> drop index rhn_package_path_idx;
drop index rhn_package_path_idx
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key
% 221-rhn_sat_node_probe-indexes.sql
SQL> select
'spacewalk-schema-1.1-to-spacewalk-schema-1.2/221-rhn_sat_node_probe-indexes.sql'
from dual;
'SPACEWALK-SCHEMA-1.1-TO-SPACEWALK-SCHEMA-1.2/221-RHN_SAT_NODE_PROBE-INDEXES.SQ
-------------------------------------------------------------------------------
spacewalk-schema-1.1-to-spacewalk-schema-1.2/221-rhn_sat_node_probe-indexes.sql
SQL>
SQL> drop index rhn_sndpb_pid_ptype_idx;
drop index rhn_sndpb_pid_ptype_idx
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key
% 223-web_contact-indexes.sql
SQL> select
'spacewalk-schema-1.1-to-spacewalk-schema-1.2/223-web_contact-indexes.sql' from
dual;
'SPACEWALK-SCHEMA-1.1-TO-SPACEWALK-SCHEMA-1.2/223-WEB_CONTACT-INDEXES.SQ
------------------------------------------------------------------------
spacewalk-schema-1.1-to-spacewalk-schema-1.2/223-web_contact-indexes.sql
SQL>
SQL> drop index web_contact_id_oid_cust_luc;
drop index web_contact_id_oid_cust_luc
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key
% 237-rhnErrataFileChannelTmp-indexes.sql
SQL> select
'spacewalk-schema-1.1-to-spacewalk-schema-1.2/237-rhnErrataFileChannelTmp-indexes.sql'
from dual;
'SPACEWALK-SCHEMA-1.1-TO-SPACEWALK-SCHEMA-1.2/237-RHNERRATAFILECHANNELTMP-INDEXE
--------------------------------------------------------------------------------
spacewalk-schema-1.1-to-spacewalk-schema-1.2/237-rhnErrataFileChannelTmp-indexes
.sql
SQL> CREATE INDEX rhn_efilectmp_cid_idx
2 ON rhnErrataFileChannelTmp (channel_id)
3 TABLESPACE USERS;
Index created.
SQL>
SQL> DROP INDEX rhn_efilectmp_cid_efid_idx;
DROP INDEX rhn_efilectmp_cid_efid_idx
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key
do you still have logs with exact errors produced during upgrade?
These errors are split across log files, as I reverted the database, changed
the upgrade sql, and reran the schema-upgrade, so by the end the schema upgrade
completed successfully, but without these index drops.
Thanks,
jh
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
