[Spacewalk-list] Upgrading to 1.2

[Speagle, Andy]

> 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