This is probably a stupid question....but why "upgrade" spacewalk as apposed to "re-deploying" a fresh install?
I've always avoided upgrades finding they're more head ache then they're worth. On the client side, my build is so automated it's quicker to "re-image" then to upgrade. On the Satellite/Spacewalk side, I export all my channels (rhn-satellite-exporter) , rebuild and import the channels, configure keys and run a script that registers my clients to the new server. ...although I don't use cobbler/puppet etc, not sure how you would export/import their configs. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Marcus Moeller Sent: 02 February 2010 11:27 To: [email protected] Subject: Re: [Spacewalk-list] 0.7 upgrade to nightly Dear Michael. > nightly is latest development and experimental stuff and although we > do our best regarding upgrades we frankly don't support them (to > nightly), installation should always work. > > Of course we do support upgrades from one released version to another > so the main upgrade polishing comes regularly just before release :). I am aware of it. It is my testing env and this is more an informational note. > % CREATE TABLE rhnChecksumType > % * > % ERROR at line 1: > % ORA-00955: name is already used by an existing object % % which > leads to the following error during spacewalk-repo-sync: > % > % SQLStatementPrepareError: ('ORA-00942: table or view does not % > exist\n', 942, 'select p.id from rhnPackage p, rhnChecksumView c where > % p.org_id = :org_id and p.checksum_id = c.id and c.checksum = > :checksum % and c.checksum_type = :checksumtype') > > So you probably ended up with partialy upgraded schema :(. > > If you have a backup of your 0.7 schema: > - restore it > - rename sql sql.bak > /etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-0.7-to-spacewalk-sc > hema-0.8/004-* > - and try to rerun schema upgrade again > otherwise: > - rename sql sql.bak > /etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-0.7-to-spacewalk-sc > hema-0.8/00[0-4]-* > - and try to rerun schema upgrade again Still does not work. Had to rebuild the complete db. schema upgrade fails during the following step: CREATE TABLE rhnChecksumType ( id NUMBER NOT NULL CONSTRAINT rhn_checksumtype_id_pk PRIMARY KEY USING INDEX TABLESPACE USERS, label VARCHAR2(32) NOT NULL, description VARCHAR2(64) NOT NULL, created DATE DEFAULT (sysdate) NOT NULL, modified DATE DEFAULT (sysdate) NOT NULL ) ENABLE ROW MOVEMENT ; Best Regards Marcus _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list ********************************************************************** Please consider the environment before printing this email or its attachments. The contents of this email are for the named addressees only. It contains information which may be confidential and privileged. If you are not the intended recipient, please notify the sender immediately, destroy this email and any attachments and do not otherwise disclose or use them. Email transmission is not a secure method of communication and Man Investments cannot accept responsibility for the completeness or accuracy of this email or any attachments. Whilst Man Investments makes every effort to keep its network free from viruses, it does not accept responsibility for any computer virus which might be transferred by way of this email or any attachments. This email does not constitute a request, offer, recommendation or solicitation of any kind to buy, subscribe, sell or redeem any investment instruments or to perform other such transactions of any kind. Man Investments reserves the right to monitor, record and retain all electronic communications through its network to ensure the integrity of its systems, for record keeping and regulatory purposes. Visit us at: www.maninvestments.com TG0908 ********************************************************************** _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
