[Spacewalk-list] Anybody syncing SLES repositories with SW 2.7?

[Lichtinger, Bernhard]

Hello,

> 2017/10/09 16:03:03 +02:00 Repo https://user:pass@nu.novell.com/repo/$RCE/SLES11-SP4-Updates/sle-11-x86_64/ has 610 errata.
> -->2017/10/09 16:03:17 +02:00 Syncing 610 new errata to channel.
> 2017/10/09 16:03:50 +02:00 ERROR: FEHLER:  doppelter Schlüsselwert verletzt Unique-Constraint »rhn_errata_adv_org_uq«
>  
> 2017/10/09 16:03:50 +02:00 ERROR: FEHLER:  doppelter Schlüsselwert verletzt Unique-Constraint »rhn_errata_adv_org_uq«

I got this error already after upgrading to 2.6 and in english the error message is:
"ERROR: duplicate key value violates unique constraint "rhn_errata_advisory_uq""

To get rid of the error you can wipe all erratas from the database with:
rhnschema=# truncate rhnErrata CASCADE;;

With the next repo-sync all errata will be back.

This solution was already posted in march:
https://www.redhat.com/archives/spacewalk-list/2017-March/msg00066.html


I got the same error with sles-11.4 repos.
My spacewalk-2.7 syncs all sles-11.4 and sles-12.x repos from our SMT server without any problems.


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/20171011/3dcfbd60/attachment.p7s>