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 <[email protected]> Sent: 09 February 2016 11:31 To: [email protected] 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
_______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
