> 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.
I can confirm that I saw these exact errors during my upgrade from 1.1 -> 1.2 ... I fall into the same category also as having upgraded this instance of spacewalk from 0.6 through each version to 1.2. Since there aren't a plethora of bug reports, perhaps this is something that only folks, who have upgraded over so many versions, will have seen. Andy Speagle _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
