Satellite sync on Red Hat Satellite is failing with "ORA-00001: unique constraint (RHNSAT.RHN_PKG_CAP_NAME_VERSION_UQ) violated"
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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
