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

Wed Oct 11 09:21:29 UTC 2017

Just further information....what I just yet notices is....why does SW 2.7 try to sync *all* erratas new?

Last Wednesday (and before upgrade to 2.7), sync of SLES11-SP4-Updates worked and hat 609 errata

Linking packages to channel.
Repo https://user:pass@nu.novell.com/repo/$RCE/SLES11-SP4-Updates/sle-11-x86_64/ has 609 errata.
Sync completed.
Total time: 0:06:37

Then on Monday, I upgraded SW to 2.7. Now the sync of SLES11-SP4 looks like this

2017/10/09 15:59:09 +02:00 Command: ['/usr/bin/spacewalk-repo-sync', '--channel', 'sles11-sp4-updates-x86_64', '--type', 'yum']
2017/10/09 15:59:09 +02:00 Sync of channel started.
2017/10/09 15:59:09 +02:00 Repo URL: https://user:pass@nu.novell.com/repo/$RCE/SLES11-SP4-Updates/sle-11-x86_64/
2017/10/09 15:59:14 +02:00 Packages in repo:              3655
2017/10/09 16:02:49 +02:00 Packages already synced:       2846
2017/10/09 16:02:49 +02:00 Packages to sync:                 5
2017/10/09 16:02:49 +02:00 New packages to download:         5
2017/10/09 16:02:50 +02:00 1/5 : libvirt-1.2.5-23.3.1.x86_64.rpm
2017/10/09 16:02:51 +02:00 2/5 : libvirt-lock-sanlock-1.2.5-23.3.1.x86_64.rpm
2017/10/09 16:02:51 +02:00 3/5 : libvirt-client-32bit-1.2.5-23.3.1.x86_64.rpm
2017/10/09 16:02:51 +02:00 4/5 : libvirt-doc-1.2.5-23.3.1.x86_64.rpm
2017/10/09 16:02:51 +02:00 5/5 : libvirt-client-1.2.5-23.3.1.x86_64.rpm
2017/10/09 16:02:51 +02:00 Importing packages started.
2017/10/09 16:03:01 +02:00 Importing packages finished.
2017/10/09 16:03:01 +02:00 Linking packages to channel.
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«

2017/10/09 16:03:50 +02:00 Sync of channel completed in 0:04:41.

Why is it trying to create 610 *new* errata? It should only create *one*

Von: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] Im Auftrag von Paschedag, Robert
Gesendet: Mittwoch, 11. Oktober 2017 08:44
An: spacewalk-list at redhat.com
Betreff: [Spacewalk-list] Anybody syncing SLES repositories with SW 2.7?

Hi all,

is anybody here that is also syncing SLES repositories and has updated to SW 2.7?

While I was testing 2.7 (also nightly) on my test system, I was so focused primary on "deployment" of SLES and Debian systems, that I did not have an eye on the repo synchronization.

Now, when I try to sync a SLES respository, on older repos (< SLES12), I get the following error

2017/10/11 06:00:00 +02:00 Command: ['/usr/bin/spacewalk-repo-sync', '--channel', 'sle11-sdk-sp3-updates-x86_64', '--type', 'yum']
2017/10/11 06:00:00 +02:00 Sync of channel started.
2017/10/11 06:00:00 +02:00 Repo URL: https://user:pass@nu.novell.com/repo/$RCE/SLE11-SDK-SP3-Updates/sle-11-x86_64/
2017/10/11 06:00:10 +02:00 Packages in repo:              2404
2017/10/11 06:02:17 +02:00 No new packages to sync.
2017/10/11 06:02:17 +02:00 Repo https://user:pass@nu.novell.com/repo/$RCE/SLE11-SDK-SP3-Updates/sle-11-x86_64/ has 559 errata.
2017/10/11 06:02:23 +02:00 Syncing 559 new errata to channel.
2017/10/11 06:02:34 +02:00 ERROR: 'list' object has no attribute 'keys'
2017/10/11 06:02:34 +02:00 ERROR: 'list' object has no attribute 'keys'
2017/10/11 06:02:34 +02:00 Sync of channel completed in 0:02:33.

This on repos which seem to be "smaller" than SLES11-SP4. I therefore created PR

https://github.com/spacewalkproject/spacewalk/pull/581

which should fix the

"ERROR: 'list' object has no attribute 'keys'"

But even if this patch is not yet put in place (here on my production server) and trying to sync a SLES11-SP4 (or SLES12-SP1) or newr repo,
(where the above mentioned error is *not* hit), I get the following db "constraint" error

2017/10/11 08:32:23 +02:00 Repo URL: https://user:pass@nu.novell.com/repo/$RCE/SLES11-SP4-Updates/sle-11-x86_64/
2017/10/11 08:32:27 +02:00 Packages in repo:              3661
2017/10/11 08:33:23 +02:00 Packages already synced:       2852
2017/10/11 08:33:23 +02:00 Packages to sync:                 2
2017/10/11 08:33:23 +02:00 New packages to download:         2
2017/10/11 08:33:24 +02:00 1/2 : tcpdump-3.9.8-1.30.5.1.x86_64.rpm
2017/10/11 08:33:25 +02:00 2/2 : xinetd-2.3.14-130.133.7.1.x86_64.rpm
2017/10/11 08:33:25 +02:00 Importing packages started.
2017/10/11 08:33:27 +02:00 Importing packages finished.
2017/10/11 08:33:27 +02:00 Linking packages to channel.
2017/10/11 08:33:29 +02:00 Repo https://user:pass@nu.novell.com/repo/$RCE/SLES11-SP4-Updates/sle-11-x86_64/ has 613 errata.
2017/10/11 08:33:48 +02:00 Syncing 613 new errata to channel.
2017/10/11 08:33:59 +02:00 ERROR: FEHLER:  doppelter Schlüsselwert verletzt Unique-Constraint »rhn_errata_adv_org_uq«

2017/10/11 08:33:59 +02:00 ERROR: FEHLER:  doppelter Schlüsselwert verletzt Unique-Constraint »rhn_errata_adv_org_uq«

2017/10/11 08:33:59 +02:00 Sync of channel completed in 0:01:36.

I was able to successfully sync the EPEL 7 repository without any problems, so I think, this is caused by "not very unique" "update_id" s in SLES.

So if anybody also syncs SLES and has updated to SW 2.7, please report, if you also see this error or if it works in your setup.

Thanks.
Robert

Mit freundlichen Grüßen

Robert Paschedag
Netlution GmbH
Landteilstr. 33
68163 Mannheim

im Auftrag des
SWR
Südwestrundfunk
HA IT, Medientechnik und Programmverbreitung
Neckarstraße 230
70190 Stuttgart
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20171011/85d9ffb8/attachment.htm>