[Spacewalk-list] Failed schema upgrade from 2.2 to 2.3/4, ERROR: duplicate key value violates unique constraint "rhn_pkey_keyid_uq"

[Ted Crilley]

Hi


working with my colleague we have now found the issue with the schema-upgrade.


In the 2.1 -> 2.2 schema-upgrade support for aarch64-redhat-linux was introduced to the db table rhnServerPackageArchCompat


Now in 2.2. -> 2.3/4 when I run the schema-upgrade package it is trying to add the same functionality to the above table:

2.2 upgrade from 2.1

schema-upgrade contains the following sql script: /etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-2.1-to-spacewalk-schema-2.2


005-support-for-aarch64.sql.postgresql

2.3/4 upgrade from 2.2
schema-upgrade contains this script: /etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-2.2-to-spacewalk-schema-2.3

012-rhnServerPackageArchCompat.sql.postgresql

This causes the duplicate key value violates unique constraint "rhn_pkey_keyid_uq" error because support for the arch is already in the db from the previous upgrade.

rgds
Darren Glynn
________________________________
From: father ted <fted.crilley at hotmail.com>
Sent: 09 February 2016 11:31
To: spacewalk-list at redhat.com
Subject: Failed schema upgrade from 2.2 to 2.3/4, ERROR: duplicate key value violates unique constraint "rhn_pkey_keyid_uq"


Hi,

I am seeing this issue when trying to upgrade our current spacewalk server 2.2 release using either 2.3 or 2.4 repos.


(snip)

-----------------------------------------------------------------------------------------

 spacewalk-schema-2.2-to-spacewalk-schema-2.3/010-rhnDistChannelMap_index.sql.postgresql
(1 row)

ALTER TABLE
CREATE INDEX
CREATE INDEX
COMMIT
                                       ?column?
--------------------------------------------------------------------------------------
 spacewalk-schema-2.2-to-spacewalk-schema-2.3/011-rhnWebContactEnabled.sql.postgresql
(1 row)

CREATE VIEW
COMMIT
                                          ?column?
--------------------------------------------------------------------------------------------
 spacewalk-schema-2.2-to-spacewalk-schema-2.3/012-rhnServerPackageArchCompat.sql.postgresql
(1 row)

psql:/var/log/spacewalk/schema-upgrade/20160209-104250-script.sql:1620: ERROR:  duplicate key value violates unique constraint "rhn_sp_ac_said_paid_uq"


I have tried one option about manually running the commands but get an error below following this message http://www.redhat.com/archives/spacewalk-list/2014-March/msg00040.html:


su - postgres
psql spaceschema
psql: FATAL:  no pg_hba.conf entry for host "[local]", user "postgres", database "spaceschema", SSL off

If i re-run the schema upgrade I now see this.


/usr/bin/spacewalk-schema-upgrade
Unknown schema name [(0 rows)] found.

Any help would be great thanks, there is mention in one for the previous list to manually run the sql statements in the dd but I cant login to even do this.

regards
Darren

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160216/dc997c52/attachment.htm>