I applied the patch (thanks for the speedy fix) and re-ran the sync. This time I receive: === #> spacewalk-repo-sync --channel channel-oel6-latest-64 Repo URL: http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ Packages in repo: 18319 No new packages to sync. Repo http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ has comps file comps.xml. Repo http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ has 1006 errata. ERROR: null value in column "product" violates not-null constraint Sync completed. Total time: 0:14:48 === echo $? after this returned 0. I think that the web UI error is directly related to the "main" problem with sync. Even when I try to yum upgrade from the Oracle Linux clients manually, it appears that the client does not see any updated packages, although there are some visible in the web UI. Looks like the sync happens only partially. <blockquote style="border-left: 1px solid #CCC; padding-left: 5px; margin-left: 5px; margin-bottom: 0px; margin-top: 0px; margin-right: 0px;" type="cite"> ----- Original Message ----- From: Milan Zazrivec Sent: 12/13/12 11:55 AM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Problems with Spacewalk and Oracle Linux repo sync/updates <div> <div> <pre style="white-space: pre-wrap; word-wrap: break-word; font-size:11;pre"> > Hi. > I've been running a centralized update infrastructure for some CentOS 5/6 > and Oracle Linux 5/6 boxes - there is a central Spacewalk server, which > periodically synchronizes with official update mirrors and I then push > updates onto systems registered with Spacewalk. The CentOS synchronization > and update process has been flawless thus far, however recently I've run > into a problem with Oracle Linux mirror sync and update process. Every > time a mirror sync is performed, I get this in > /var/log/rhn/rhn_taskomatic_daemon.log: > > INFO | jvm 1 | 2012/12/13 05:43:24 | 2012-12-13 05:43:24,515 > [DefaultQuartzScheduler_Worker-9] ERROR > com.redhat.rhn.manager.satellite.SystemCommandExecutor - Error encountered > executing (args=[/usr/bin/spacewalk-repo-sync, --channel, > channel-oel6-latest-64, --type, yum]) INFO | jvm 1 | 2012/12/13 05:43:24 | > 2012-12-13 05:43:24,515 [DefaultQuartzScheduler_Worker-9] ERROR > com.redhat.rhn.manager.satellite.SystemCommandExecutor - Error message > from process: Traceback (most recent call last): INFO | jvm 1 | 2012/12/13 > 05:43:24 | File "/usr/bin/spacewalk-repo-sync", line 103, in <module> INFO > | jvm 1 | 2012/12/13 05:43:24 | sys.exit(abs(main() or 0)) > INFO | jvm 1 | 2012/12/13 05:43:24 | File "/usr/bin/spacewalk-repo-sync", > line 96, in main INFO | jvm 1 | 2012/12/13 05:43:24 | sync.sync() > INFO | jvm 1 | 2012/12/13 05:43:24 | File > "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/reposync.py", > line 112, in sync INFO | jvm 1 | 2012/12/13 05:43:24 | > self.error_msg("ERROR: %s" % e.value) INFO | jvm 1 | 2012/12/13 05:43:24 | > AttributeError: 'IntegrityError' object has no attribute 'value' INFO | > jvm 1 | 2012/12/13 05:43:24 | > INFO | jvm 1 | 2012/12/13 05:43:24 | 2012-12-13 05:43:24,517 > [DefaultQuartzScheduler_Worker-9] INFO > com.redhat.rhn.taskomatic.task.RepoSyncTask - Repo URL: > http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ INFO | > jvm 1 | 2012/12/13 05:43:24 | Packages in repo: 18319 > INFO | jvm 1 | 2012/12/13 05:43:24 | Packages already synced: 14457 > INFO | jvm 1 | 2012/12/13 05:43:24 | Packages to sync: 5 > INFO | jvm 1 | 2012/12/13 05:43:24 | 1/5 : > java-1.7.0-openjdk-1.7.0.9-2.3.3.2.0.1.el6_3-1.x86_64 INFO | jvm 1 | > 2012/12/13 05:43:24 | 2/5 : > java-1.7.0-openjdk-demo-1.7.0.9-2.3.3.2.0.1.el6_3-1.x86_64 INFO | jvm 1 | > 2012/12/13 05:43:24 | 3/5 : > java-1.7.0-openjdk-src-1.7.0.9-2.3.3.2.0.1.el6_3-1.x86_64 INFO | jvm 1 | > 2012/12/13 05:43:24 | 4/5 : > java-1.7.0-openjdk-devel-1.7.0.9-2.3.3.2.0.1.el6_3-1.x86_64 INFO | jvm 1 | > 2012/12/13 05:43:24 | 5/5 : > java-1.7.0-openjdk-javadoc-1.7.0.9-2.3.3.2.0.1.el6_3-1.noarch INFO | jvm 1 > | 2012/12/13 05:43:24 | Repo > http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ has comps > file comps.xml. INFO | jvm 1 | 2012/12/13 05:43:24 | Repo > http://public-yum.oracle.com/repo/OracleLinux/OL6/latest/x86_64/ has 1006 > errata. INFO | jvm 1 | 2012/12/13 05:43:24 | > INFO | jvm 1 | 2012/12/13 05:43:24 | 2012-12-13 05:43:24,522 > [DefaultQuartzScheduler_Worker-9] ERROR > com.redhat.rhn.taskomatic.task.RepoSyncTask - Traceback (most recent call > last): INFO | jvm 1 | 2012/12/13 05:43:24 | File > "/usr/bin/spacewalk-repo-sync", line 103, in <module> INFO | jvm 1 | > 2012/12/13 05:43:24 | sys.exit(abs(main() or 0)) > INFO | jvm 1 | 2012/12/13 05:43:24 | File "/usr/bin/spacewalk-repo-sync", > line 96, in main INFO | jvm 1 | 2012/12/13 05:43:24 | sync.sync() > INFO | jvm 1 | 2012/12/13 05:43:24 | File > "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/reposync.py", > line 112, in sync INFO | jvm 1 | 2012/12/13 05:43:24 | > self.error_msg("ERROR: %s" % e.value) INFO | jvm 1 | 2012/12/13 05:43:24 | > AttributeError: 'IntegrityError' object has no attribute 'value' INFO | > jvm 1 | 2012/12/13 05:43:24 | I fixed the traceback you're showing in http://git.fedorahosted.org/cgit/spacewalk.git/commit/?id=39088b67a5f28d5f0ecb8a2a2fc959db815f2098 although I'm not sure where this IntegrityError comes from. > Furthermore, in Spacewalk web UI I can see that Oracle Linux systems have > updates available, however, when I try to update them I get an error > message: "Client execution returned "Error while executing packages > action: empty transaction [[6]]" (code -1)" And I can see, that no updates > have been applied. Do you use the latest Spacewalk 1.8 client packages on the clients showing this problem? -MZ _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list</pre> </div> </div> </blockquote>