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...) 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
