----- Original Message ----- > From: "Jonathan Hoser" <[email protected]> > To: [email protected] > Sent: Wednesday, 5 March, 2014 8:11:14 AM > Subject: Re: [Spacewalk-list] Failed schema upgrade from 2.0 to 2.1, ERROR: > duplicate key value violates unique > constraint "rhn_pkey_keyid_uq" > > Hi, > > I had the same issue, > (this is schema-update script #047) > where I already had the to-be-inserted key in my table (no clue where > I > got it), > and I manually updated it with the values the insert-statement wanted > to > place there. > > Afterwards the 2 (or 3?) remaining sqls I manually applied using the > \i > [filename] syntax, > and everything was fine... > (ooh... I just remembered, that a last transaction somewhere changes > the > database-version field... I have to go check on that one...) >
Could you please add more detail to that procedure? I have no backup of the database :) (I have it installed for testing purposes, so it's not important, but I don't want to reinstall it :D) Thanks! > Best > -Jonathan > > On 03/04/2014 03:28 PM, Eduardo Minguez wrote: > > Hi, > > > > CentOS 6.5 x86_64 yum updated to the latest version, and following > > the spacewalk upgrade guide in > > https://fedorahosted.org/spacewalk/wiki/HowToUpgrade, it fails in > > the schema-upgrade procedure like: > > > > (snip) > > ... > > ------------------------------------------------------------------------------------------------ > > > > spacewalk-schema-2.0-to-spacewalk-schema-2.1/046-rhnUserExtGroupMapping-trigger.sql.postgresql > > (1 row) > > > > CREATE FUNCTION > > CREATE TRIGGER > > COMMIT > > ?column? > > ----------------------------------------------------------------------------------- > > > > spacewalk-schema-2.0-to-spacewalk-schema-2.1/047-rhnPackageKey-f20.sql.postgresql > > (1 row) > > > > psql:/var/log/spacewalk/schema-upgrade/20140304-125445-script.sql:4308: > > ERROR: duplicate key value violates unique constraint > > "rhn_pkey_keyid_uq" > > > > > > If I try to do it again it says: > > > > spacewalk-schema-upgrade > > Unknown schema name [(0 rows)] found. > > > > Is there anything I can do to fix it? > > > > Thanks > > > > _______________________________________________ > > Spacewalk-list mailing list > > [email protected] > > https://www.redhat.com/mailman/listinfo/spacewalk-list > > > > > -- > Jonathan Hoser, M.Sc. > Institute of Bioinformatics and System Biology > Phone: +49-89-3187-4556 > Fax: +49-89-3187-3585 > Email: [email protected] > WWW: http://mips.helmholtz-muenchen.de > > > Helmholtz Zentrum München > Deutsches Forschungszentrum für Gesundheit und Umwelt (GmbH) > Ingolstädter Landstr. 1 > 85764 Neuherberg > www.helmholtz-muenchen.de > Aufsichtsratsvorsitzende: MinDir´in Bärbel Brumme-Bothe > Geschäftsführer: Prof. Dr. Günther Wess, Dr. Nikolaus Blum, Dr. > Alfons Enhsen > Registergericht: Amtsgericht München HRB 6466 > USt-IdNr: DE 129521671 > > _______________________________________________ > Spacewalk-list mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-list > -- Eduardo Mínguez Pérez Infrastructure Consultant (RHCE, RHCSA) Red Hat - Spain Mobile: +34 629803049 (CET/CEST) E-mail: [email protected] _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
