[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]

Re: [Spacewalk-list] Duplicate key during reposync

I think centos messed up and named their rpm : “firefox-45.1-1el7” instead of “forefox45-1.1.el7” (see the missing dot)

They corrected their mistake, but you now have to remove the badly named RPM from your RPM mirror and spacewalk channels.

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.


Maxime Veroone


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


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?



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


  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


  File "/usr/lib/python2.6/site-packages/spacewalk/server/taskomatic.py", line 44, in add


  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)

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]