<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style></style></head><body lang=FR link="#0563C1" vlink="#954F72"><div class=WordSection1>I think centos messed up and named their rpm : “firefox-45.1-1el7” instead of “forefox45-1.1.el7” (see the missing dot)<o:p></o:p>They corrected their mistake, but you now have to remove the badly named RPM from your RPM mirror and spacewalk channels.<o:p></o:p>The error is due to the fact that when inserted into the spacewalk database, dots are ignored, and thus both rpms appear to have the same name, which is used as a primary key.<o:p></o:p><o:p> </o:p>Maxime Veroone<o:p></o:p><o:p> </o:p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>De : spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] De la part de Coffman, Anthony J Envoyé : mardi 24 mai 2016 14:46 À : spacewalk-list@redhat.com Objet : [Spacewalk-list] Duplicate key during reposync<o:p></o:p></div></div><o:p> </o:p>This started on Saturday and seems to affect reposync for only one channel (CentOS 7 Updates)<o:p></o:p><o:p> </o:p>It’s happened every night since. I’m guessing the firefox updates have something to do with this since those seem to be the packages that are “stuck” (refuse to sync).<o:p></o:p><o:p> </o:p>Is anybody else seeing this?<o:p></o:p><o:p> </o:p>Regards,<o:p></o:p>--Tony Coffman<o:p></o:p><o:p> </o:p><o:p> </o:p><o:p> </o:p>2016-05-21 01:17:55,007 [DefaultQuartzScheduler_Worker-6] INFO com.redhat.rhn.taskomatic.task.RepoSyncTask - Syncing repos for channel: CentOS 7 Updates (x86_64)<o:p></o:p>2016-05-21 01:23:37,472 [Thread-13053] INFO com.redhat.rhn.taskomatic.task.RepoSyncTask - ======================================<o:p></o:p>| Channel: centos7-x86_64-updates<o:p></o:p>======================================<o:p></o:p><o:p> </o:p>Repo URL: <a href="http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=updates">http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=updates</a><o:p></o:p>Packages in repo: 1676<o:p></o:p>Packages already synced: 1674<o:p></o:p>Packages to sync: 2<o:p></o:p>1/2 : firefox-45.1.1-1.el7.centos-0.i686<o:p></o:p>2/2 : firefox-45.1.1-1.el7.centos-0.x86_64<o:p></o:p>Linking packages to channel.<o:p></o:p><o:p> </o:p>2016-05-21 01:23:37,472 [Thread-13054] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask - ERROR: (23, 'ERROR: duplicate key value violates unique constraint "rhn_cnp_cid_nid_uq"', 'Could not update database entry.')<o:p></o:p>Traceback (most recent call last):<o:p></o:p> File "/usr/bin/spacewalk-repo-sync", line 218, in <module><o:p></o:p> sys.exit(abs(main() or 0))<o:p></o:p> File "/usr/bin/spacewalk-repo-sync", line 211, in main<o:p></o:p> sync.sync()<o:p></o:p> File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/reposync.py", line 224, in sync<o:p></o:p> [self.channel_label], [], "server.app.yumreposync")<o:p></o:p> File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py", line 69, in add_to_repodata_queue_for_channel_package_subscription<o:p></o:p> add_to_repodata_queue(channel, caller, reason[:128])<o:p></o:p> File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py", line 53, in add_to_repodata_queue<o:p></o:p> queue.add(entry)<o:p></o:p> File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py", line 44, in add<o:p></o:p> bypass_filters=self._boolean_as_char(entry.bypass_filters))<o:p></o:p> File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute<o:p></o:p> return self._execute_wrapper(self._execute, *p, **kw)<o:p></o:p> File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 296, in _execute_wrapper<o:p></o:p> raise sql_base.SQLSchemaError(error_code, e.pgerror, e)<o:p></o:p>spacewalk.server.rhnSQL.sql_base.SQLSchemaError: (99999, 'ERROR: current transaction is aborted, commands ignored until end of transaction block', '', InternalError('current transaction is aborted, commands ignored until end of transaction block\n',))<o:p></o:p><o:p> </o:p>2016-05-21 01:23:37,525 [DefaultQuartzScheduler_Worker-6] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask - Executing a task threw an exception: org.quartz.JobExecutionException<o:p></o:p>2016-05-21 01:23:37,526 [DefaultQuartzScheduler_Worker-6] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask - Message: Command '[/usr/bin/spacewalk-repo-sync, --channel, centos7-x86_64-updates, --type, yum]' exited with error code 1<o:p></o:p>2016-05-21 01:23:37,536 [DefaultQuartzScheduler_Worker-6] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask - Cause: null<o:p></o:p>2016-05-21 01:23:37,552 [DefaultQuartzScheduler_Worker-6] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask - Stack trace:org.quartz.JobExecutionException: Command '[/usr/bin/spacewalk-repo-sync, --channel, centos7-x86_64-updates, --type, yum]' exited with error code 1<o:p></o:p> at com.redhat.rhn.taskomatic.task.RhnJavaJob.executeExtCmd(RhnJavaJob.java:112)<o:p></o:p> at com.redhat.rhn.taskomatic.task.RepoSyncTask.execute(RepoSyncTask.java:74)<o:p></o:p> at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:89)<o:p></o:p> at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:185)<o:p></o:p> at org.quartz.core.JobRunShell.run(JobRunShell.java:216)<o:p></o:p> at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549) <o:p></o:p></div></body></html>