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

[Paschedag, Robert]

Hi Bernhard,

thanks for that info. I have to try that after the Debian synchronization is over.


-----Ursprüngliche Nachricht-----
Von: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von Lichtinger, Bernhard
Gesendet: Mittwoch, 11. Oktober 2017 12:29
An: spacewalk-list at redhat.com
Betreff: Re: [Spacewalk-list] Anybody syncing SLES repositories with SW 2.7?

Hello,

> 2017/10/09 16:03:03 +02:00 Repo https://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fuser%3Apass%40nu.novell.com%2Frepo%2F%24RCE%2FSLES11-SP4-Updates%2Fsle-11-x86_64%2F&data=02%7C01%7CPaschedag.Netlution%40swr.de%7Cfdaa22f852884a29343308d51096bc96%7Cbcca095d88d442f88260cc216b81f62d%7C0%7C0%7C636433161962571373&sdata=CURDdhNFfP%2Frnyw%2Bfqv6dNQZCho4ncX%2F4nEkIgHuOcg%3D&reserved=0 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://emea01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.redhat.com%2Farchives%2Fspacewalk-list%2F2017-March%2Fmsg00066.html&data=02%7C01%7CPaschedag.Netlution%40swr.de%7Cfdaa22f852884a29343308d51096bc96%7Cbcca095d88d442f88260cc216b81f62d%7C0%7C0%7C636433161962571373&sdata=saB%2Bmv%2FTosSfh7TPtA9%2BftyDERXYwfnZQAhHcpem3e8%3D&reserved=0


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