On Fri, 7 Jan 2011, Michael Mraka wrote:
Speagle, Andy wrote:
% > > % 210-rhnPackage-indexes.sql
% > > % 221-rhn_sat_node_probe-indexes.sql
% > > % 223-web_contact-indexes.sql
% > > % 237-rhnErrataFileChannelTmp-indexes.sql
...
% > 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.
OK, I've updated those four scripts [1]. Applying them manually could
bring your schema to the stock 1.2 schema.
The first script will probably yell about rhn_package_id_nid_paid_idx
index does not exist because it was already droped. The fourth one about
rhn_efilectmp_cid_idx already created. You can safely ignore both of
them.
I'll appreciate you feedback.
I applied these interactively using sqlplus:
#1:
SQL> alter table RHNPACKAGECHANGELOG disable constraint
RHN_PKG_CHANGELOG_PID_FK
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> SQL> alter table rhnpackage disable constraint RHN_PACKAGE_ID_PK
*
ERROR at line 1:
ORA-02297: cannot disable constraint (SPACEWALK.RHN_PACKAGE_ID_PK) -
dependencies exist
SQL> drop index rhn_package_id_nid_paid_idx
*
ERROR at line 1:
ORA-01418: specified index does not exist
SQL> drop index rhn_package_path_idx
*
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key
SQL> alter table RHNPACKAGECHANGELOG enable novalidate constraint
RHN_PKG_CHANGELOG_PID_FK
*
ERROR at line 1:
ORA-00942: table or view does not exist
#2: All good
#3:
SQL> alter table RHNSAVEDSEARCH enable novalidate constraint
RHN_SAVEDSEARCH_WCID_FK
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> alter table RHNGRAILCOMPONENTCHOICES enable novalidate constraint
RHN_GRAIL_COMP_CH_USER_FK
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> alter table RHNEMAILADDRESSLOG enable novalidate constraint
RHN_EADDRESSLOG_UID_FK
*
ERROR at line 1:
ORA-00942: table or view does not exist
#4:
ERROR at line 3:
ORA-02216: tablespace name expected
jh
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
