[Spacewalk-list] Errata not updating

[Lichtinger, Bernhard]

Hi,

> 
> 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"

You can try this one:
https://www.redhat.com/archives/spacewalk-list/2017-March/msg00066.html

It will erase all errata info from the database and you will have to sync all your channels to get the erratas back.

It repaired my spacewalk installation when I got the same error.


Regards,
Bernhard
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5128 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20170907/4aa3b356/attachment.p7s>