Did you skip the one with the duplicate key constraint error, or did you remove the existing record with the matching key and re-insert?
On Thu, Mar 19, 2020 at 3:56 AM Ree, Jan-Albert van <j.a.v....@marin.nl> wrote: > I followed these steps : > > > cat > /etc/sysconfig/rhn/schema-upgrade/spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql > > su - postgres > > psql -d rhnschema > > > Then just copy all the queries , one at a time , from the cat above in the > postgresql session and then quit postgresql and continued the upgrade as if > the database upgrade was successful. > > > Regards, > > -- > > Jan-Albert > > > > Jan-Albert van Ree | HPC Specialist | Digital Services > MARIN | T +31 317 49 35 48 | j.a.v....@marin.nl | www.marin.nl > > [image: LinkedIn] <https://www.linkedin.com/company/marin> [image: > YouTube] <http://www.youtube.com/marinmultimedia> [image: Twitter] > <https://twitter.com/MARIN_nieuws> [image: Facebook] > <https://www.facebook.com/marin.wageningen> > MARIN news: Courses Hydrodynamics Floating Offshore Structures & Ship > design > <https://www.marin.nl/courses-hydrodynamics-floating-offshore-structures-and-ship-design> > > ------------------------------ > *From:* spacewalk-list-boun...@redhat.com < > spacewalk-list-boun...@redhat.com> on behalf of Elsever Sadigov < > e.sadi...@millikart.az> > *Sent:* Thursday, March 19, 2020 08:08 > *To:* spacewalk-list@redhat.com > *Subject:* Re: [Spacewalk-list] Spacewalk 2.10 Released! > > > Hi Jan-Albert, > > Can you share what exactly you did? > > I'm facing same issue: > > > -- > *Best Regards,* > *Sadigov Elsevar* > On 3/19/2020 00:45, Ree, Jan-Albert van wrote: > > Congrats to the devel team. > > Just performed an upgrade and am back up and running with 2.10 > > Ran in to one minor issue , > > > spacewalk-schema-2.9-to-spacewalk-schema-2.10/006-distribution-keys.sql.postgresql > (1 row) > > INSERT 0 1 > INSERT 0 1 > psql:/var/log/spacewalk/schema-upgrade/20200318-170518-script.sql:289: ERROR: > duplicate key value violates unique constraint "rhn_pkey_keyid_uq" > DETAIL: Key (key_id)=(05b555b38483c65d) already exists. > > Solved it by running all the queries in that (last) upgrade script manually > > Thanks for all the hard work! > -- > Jan-Albert van Ree > > > Jan-Albert van Ree | HPC Specialist | Digital Services > MARIN | T +31 317 49 35 48 | mailto:j.a.v....@marin.nl <j.a.v....@marin.nl> | > http://www.marin.nl > > ________________________________________ > From: spacewalk-list-boun...@redhat.com <spacewalk-list-boun...@redhat.com> > <spacewalk-list-boun...@redhat.com> on behalf of Michael Mraka > <michael.mr...@redhat.com> <michael.mr...@redhat.com> > Sent: Wednesday, March 18, 2020 16:10 > To: spacewalk-announce-l...@redhat.com; spacewalk-list@redhat.com; > spacewalk-de...@redhat.com > Subject: [Spacewalk-list] Spacewalk 2.10 Released! > > Hello everyone, > > We are proudly announcing release of Spacewalk 2.10, a systems management > solution. > > _______________________________________________ > Spacewalk-list mailing > listSpacewalk-list@redhat.comhttps://www.redhat.com/mailman/listinfo/spacewalk-list > > > > > *Help us improve the spam filter. If this message contains SPAM, click > here > <https://www.mailcontrol.com/sr/BHYZOjXwzSPGX2PQPOmvUmQbZlJUA6MY-6selOctPjlczNG52tIWkM23y1bo3ioD_VsvySeweOuNc_rJiVGaJg==> > to report. Thank you, MARIN Support Group* > > _______________________________________________ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list -- Doug Eckert LEAD ENGINEER, COMPUTE [image: NewsTech] <http://www.newscorp.com/> M: +1.732.666.3681 <+1+555+555+5555> O: +1.609.520.4993 <+1+555+555+5555> E: doug.eck...@dowjones.com <cbergstres...@newscorp.com> A: PO Box 300, Princeton, NJ 08543
_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list