[Spacewalk-list] Upgrading to 1.2

[Michael Mraka]

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.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat

[1]
http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/210-rhnPackage-indexes.sql;h=2f1f1cd625831acd0a77e61b0bf8b4744ec27fcc;hb=76ea1d5ae412252d446b53c03ebab4601793168d
http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/221-rhn_sat_node_probe-indexes.sql;h=ee9500d5a503e56b1fd33ebe3deda900fec18fbf;hb=339c842924037eff31b50ec8ea490e4ed59ea3fe
http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/223-web_contact-indexes.sql;h=028000bfb10b5520fa5a4ae4fb47345c656087ac;hb=db6631a53c328238d2189cabbf2221fbc70dfe79
http://git.fedorahosted.org/git/?p=spacewalk.git;a=blob_plain;f=schema/spacewalk/upgrade/spacewalk-schema-1.1-to-spacewalk-schema-1.2/237-rhnErrataFileChannelTmp-indexes.sql;h=ce2311c6852272646cc31471bb0960f17a54b444;hb=676f5dbf2cae684a0a2a819a3c563cb8c1282603