On 03/05/2014 08:40 AM, Eduardo Minguez wrote:
----- Original Message -----
From: "Tomáš Kašpárek" <[email protected]>
To: [email protected]
Sent: Wednesday, 5 March, 2014 8:24:05 AM
Subject: Re: [Spacewalk-list] Failed schema upgrade from 2.0 to 2.1, ERROR:
duplicate key value violates unique
constraint "rhn_pkey_keyid_uq"
Hello,
this issue will be fixed in package spacewalk-schema-2.1.51 which
will
be released today.
So, by updating the spacewalk-schema package and running a
"spacewalk-schema-upgrade" will be fixed or is there any other step needed?
Thanks
You will need to restore your database from the backup to the state
where it was prior to Spacewalk upgrade as the database is now in state
when it's in middle of upgrade process. Then you simply run
"spacewalk-schema-upgrade" with new spacewalk-schema package.
Regards Tomas
On 03/05/2014 08:11 AM, Jonathan Hoser wrote:
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
--
Tomáš Kašpárek
Red Hat Satellite 5, Red Hat
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
