[Spacewalk-list] Duplicate key during reposync

[Maxime VEROONE]

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 at redhat.com
[mailto:spacewalk-list-bounces at redhat.com] De la part de Coffman, Anthony J
Envoyé : mardi 24 mai 2016 14:46
À : spacewalk-list at 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?

 

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
<http://mirrorlist.centos.org/?release=7&arch=x86_64&repo=updates>
&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/fdf85938/attachment.htm>