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

Eduardo Minguez eminguez at redhat.com
Tue Mar 4 14:28:56 UTC 2014


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




More information about the Spacewalk-list mailing list