[Spacewalk-list] Spacewalk 2.10 Released!

[Eckert, Doug]

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.Ree at 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.Ree at 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-bounces at redhat.com <
> spacewalk-list-bounces at redhat.com> on behalf of Elsever Sadigov <
> e.sadigov at millikart.az>
> *Sent:* Thursday, March 19, 2020 08:08
> *To:* spacewalk-list at 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.Ree at marin.nl <J.A.v.Ree at marin.nl> | http://www.marin.nl
>
> ________________________________________
> From: spacewalk-list-bounces at redhat.com <spacewalk-list-bounces at redhat.com> <spacewalk-list-bounces at redhat.com> on behalf of Michael Mraka <michael.mraka at redhat.com> <michael.mraka at redhat.com>
> Sent: Wednesday, March 18, 2020 16:10
> To: spacewalk-announce-list at redhat.com; spacewalk-list at redhat.com; spacewalk-devel at 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 at 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 at 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.Eckert at DowJones.com <Cbergstresser at newscorp.com>
A: PO Box 300, Princeton, NJ 08543
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/9c13e116/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: hpnmlpgldpmlmbnh.png
Type: image/png
Size: 10955 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/9c13e116/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagefba82b.PNG
Type: image/png
Size: 293 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/9c13e116/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagea76f5c.PNG
Type: image/png
Size: 331 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/9c13e116/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image614940.PNG
Type: image/png
Size: 333 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/9c13e116/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imagee0a720.PNG
Type: image/png
Size: 253 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20200319/9c13e116/attachment-0004.png>