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"
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.