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

[Eduardo Minguez]

----- Original Message -----
> From: "Tomáš Kašpárek" <tkasparek at redhat.com>
> To: spacewalk-list at redhat.com
> 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

> 
> 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
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
> 

-- 
Eduardo Mínguez Pérez
Infrastructure Consultant (RHCE, RHCSA)
Red Hat - Spain
Mobile: +34 629803049 (CET/CEST)
E-mail: eminguez at redhat.com