[Spacewalk-list] Failed schema upgrade from 2.0 to 2.1, ERROR: duplicate key value violates unique constraint "rhn_pkey_keyid_uq"

[Jonathan Hoser]

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
> Spacewalk-list at redhat.com
> 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: jonathan.hoser at helmholtz-muenchen.de
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