[Spacewalk-list] Errata not updating

[Sean Roe]

This worked well.  I just completed the rebuild and have been able to patch a system.  I used the root postgres user to do the truncate function.

Sean


On September 7, 2017 08:58:18 "Lichtinger, Bernhard" <Bernhard.Lichtinger at lrz.de> wrote:

> 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