satellite-sync fails with "ORA-01502: index 'RHNSAT.RHN_PKG_CL_PID_N_TXT_TIME_UQ' or partition of such index is in unusable state"

Solution Verified - Updated -

Issue

  • satellite-sync fails with error :
Exception type common.rhnException.rhnFault

Exception Handler Information
Traceback (most recent call last):
  File "/usr/bin/satellite-sync", line 143, in main
    return satsync.Runner().main()
  File "/usr/share/rhn/satellite_tools/satsync.py", line 226, in main
    ret = method()
  File "/usr/share/rhn/satellite_tools/satsync.py", line 343, in _step_packages
    self._affected_channels = self.syncer.import_packages()
  File "/usr/share/rhn/satellite_tools/satsync.py", line 1785, in import_packages
    sync_handlers.import_packages(batch, sources)
  File "/usr/share/rhn/satellite_tools/sync_handlers.py", line 433, in import_packages
    importer.run()
  File "/usr/share/rhn/server/importlib/importLib.py", line 651, in run
    self.submit()
  File "/usr/share/rhn/server/importlib/packageImport.py", line 322, in submit
    transactional=self.transactional)
  File "/usr/share/rhn/server/importlib/backend.py", line 744, in processPackages
    transactional=transactional)
  File "/usr/share/rhn/server/importlib/backend.py", line 1603, in __processObjectCollection__
    return self.__doDML(dml)
  File "/usr/share/rhn/server/importlib/backend.py", line 1711, in __doDML
    self.__doInsert(dml.insert, dml.tables)
  File "/usr/share/rhn/server/importlib/backend.py", line 1720, in __doInsert
    raise rhnFault(54, str(e[1]), explain=0)
rhnFault: (54, "ORA-01502: index 'RHNSAT.RHN_PKG_CL_PID_N_TXT_TIME_UQ' or partition of such index is in unusable state\n", '\n     Package Upload Failed due to uniqueness constraint violation.\n     Make sure the package does not have any duplicate dependencies or\n     does not already exists on the server\n     ')

Environment

  • Red Hat Satellite v5.4

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