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.lichtin...@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 _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
