[Spacewalk-list] Errata not updating

[Sean Roe]

The upgrade(s) went without a hitch.  The only issue was when we converted from Oracle to postgres and I had was as follows from an earlier email thead:

Sean Roe:
> I found a solution that I am sharing with you. Because the linux postgresql database would barf on the ALF32UTF8 input file generated by doing the spacewalk-dump-schema command I had to take the output from that command and I ran it through the following command:
> 
> iconv -c -t utf-8 migrate-to-postgres.sql > migrate-to-postgres2.sql
> 
> and then do the:
> 
> spacewalk-sql -verbose migrate-to-postgres2.sql
> 
> Just thought I would share my solution.

I've updated wiki page with this piece of information.
Thanks for sharing.

> Thanks,
> Sean


That was my only issue.

Sean


-----Original Message-----
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Michael Mraka
Sent: Thursday, September 07, 2017 1:58 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Errata not updating

Sean Roe:
> Hi All,
> 
> I just finished updating my spacewalk install to 2.6 and then we migrated to postgres.  I manually run the repo syncs and now I am getting this error "ERROR: duplicate key value violates unique constraint "rhn_errata_advisory_uq""  when I do one.  My research indicates that this will kill my erratas.  How do I repair this?
> 
> Output from the repo sync:
> 13:15:52 Linking packages to channel.
> 13:15:55 Repo http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/i386/ has comps file comps.xml.
> 13:15:56 Repo http://public-yum.oracle.com/repo/OracleLinux/OL5/latest/i386/ has 1285 errata.
> 13:17:26 ERROR: duplicate key value violates unique constraint "rhn_errata_advisory_uq"
> 
> Any suggestions would be helpful.

Did all upgrade steps described on https://github.com/spacewalkproject/spacewalk/wiki/HowToUpgrade passed succefully?
Especially schema upgrade step; were there any errors?
 
> Thanks,
> Sean

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list