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, tools, and much more.