Satellite sync on Red Hat Satellite is failing with "ORA-00001: unique constraint (RHNSAT.RHN_PKG_CAP_NAME_VERSION_UQ) violated"

Solution Verified - Updated -

Issue

  • Satellite sync on Red Hat Satellite is failing with below mentioned traceback:
2013/10/29 12:09:38 +11:00 7624 0.0.0.0: common/rhnTB.exitWithTraceback('ERROR', -1, "ERROR: SQLError Exception caught during import: (1, 'ORA-00001: unique constraint (RHNSAT.RHN_PKG_CAP_NAME_VERSION_UQ) violated\\n', 'insert into rhnPackageCapability (id, name, version) values (:id, :name, :version)')")
2013/10/29 12:09:38 +11:00 7624 0.0.0.0: common/rhnTB.exitWithTraceback('ERROR', -1, 'TRACEBACK: Exception reported from cbr50app04p.casa.local\nTime: Tue Oct 29 12:09:37 2013\nException type <class \'spacewalk.server.rhnSQL.sql_base.SQLError\'>\n\nException Handler Information\nTraceback (most recent call last):\n  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/satsync.py", line 1579, in _import_packages_process\n    sync_handlers.import_packages(batch, sources)\n  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/sync_handlers.py", line 376, in import_packages\n    importer.run()\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", line 626, in run\n    self.fix()\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", line 289, in fix\n    self.backend.processCapabilities(self.capabilities)\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 125, in processCapabilities\n    h.executemany(id=toinsert[0], name=toinsert[1], version=toinsert[2])\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 172, in executemany\n    return apply(self._execute_wrapper, (self._executemany, ) + p, kw)\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 108, in _execute_wrapper\n    retval = apply(function, p, kw)\n  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 208, in _executemany\n    self._real_cursor.executemany(None, arr)\nSQLError: (1, \'ORA-00001: unique constraint (RHNSAT.RHN_PKG_CAP_NAME_VERSION_UQ) violated\\n\', \'insert into rhnPackageCapability (id, name, version) values (:id, :name, :version)\')\n\n')

Environment

  • Red Hat Network Satellite 5.4.1
  • Red Hat Satellite 5.5

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content