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 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
