[Spacewalk-list] Issue with syncing CentOS 7 Updates repository to Spacewalk

[Max Mitschke]

Hello,

Spacewalk keeps failing when trying to sync packages from the CentOS 7 updates repository. What are some methods to resolve this issue?

Things that I have tried:

*        Clearing the cache and resyncing

*        Deleted all the packages in channel repo and resyncing

Error Message:
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.7/site-packages/spacewalk/satellite_tools/reposync.py", line 224, in sync
    [self.channel_label], [], "server.app.yumreposync")
  File "/usr/lib/python2.7/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.7/site-packages/spacewalk/server/taskomatic.py", line 53, in add_to_repodata_queue
    queue.add(entry)
  File "/usr/lib/python2.7/site-packages/spacewalk/server/taskomatic.py", line 44, in add
    bypass_filters=self._boolean_as_char(entry.bypass_filters))
  File "/usr/lib/python2.7/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 151, in execute
    return self._execute_wrapper(self._execute, *p, **kw)
  File "/usr/lib/python2.7/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',))

Thanks,

Max Mitschke


________________________________
This electronic transmission and any information that it contains is the property of MSU Federal Credit Union and is intended for the use of the intended recipient. If you are not the intended recipient, any disclosure, copying or other use of this information is strictly prohibited. If you acquired this transmission in error or feel that any of the information contained within it is offensive or inappropriate, please contact internalaudit at msufcu.org<mailto:internalaudit at msufcu.org>.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20160601/2cdc15f2/attachment.htm>