[Spacewalk-list] Upgrading to 1.2

[John Hodrien]

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