[Spacewalk-list] Duplicate key during reposync

[Coffman, Anthony J]

This started on Saturday and seems to affect reposync for only one channel (CentOS 7 Updates)

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).

Is anybody else seeing this?

Regards,
--Tony Coffman



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)
2016-05-21 01:23:37,472 [Thread-13053] INFO  com.redhat.rhn.taskomatic.task.RepoSyncTask  - ======================================
| Channel: centos7-x86_64-updates
======================================

Repo URL: http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=updates
Packages in repo:              1676
Packages already synced:       1674
Packages to sync:                 2
1/2 : firefox-45.1.1-1.el7.centos-0.i686
2/2 : firefox-45.1.1-1.el7.centos-0.x86_64
Linking packages to channel.

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.')
Traceback (most recent call last):
  File "/usr/bin/spacewalk-repo-sync", line 218, in <module>
    sys.exit(abs(main() or 0))
  File "/usr/bin/spacewalk-repo-sync", line 211, in main
    sync.sync()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/reposync.py", line 224, in sync
    [self.channel_label], [], "server.app.yumreposync")
  File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py", line 69, in add_to_repodata_queue_for_channel_package_subscription
    add_to_repodata_queue(channel, caller, reason[:128])
  File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py", line 53, in add_to_repodata_queue
    queue.add(entry)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py", line 44, in add
    bypass_filters=self._boolean_as_char(entry.bypass_filters))
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute
    return self._execute_wrapper(self._execute, *p, **kw)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 296, in _execute_wrapper
    raise sql_base.SQLSchemaError(error_code, e.pgerror, e)
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',))

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
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
2016-05-21 01:23:37,536 [DefaultQuartzScheduler_Worker-6] ERROR com.redhat.rhn.taskomatic.task.RepoSyncTask  - Cause: null
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
        at com.redhat.rhn.taskomatic.task.RhnJavaJob.executeExtCmd(RhnJavaJob.java:112)
        at com.redhat.rhn.taskomatic.task.RepoSyncTask.execute(RepoSyncTask.java:74)
        at com.redhat.rhn.taskomatic.task.RhnJavaJob.execute(RhnJavaJob.java:89)
        at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:185)
        at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160524/2e78c1aa/attachment.htm>