satellite-sync fails with ORA-00001: unique constraint (RHNSAT.RHN_ERRATA_ADVISORY_UQ) violated
Issue
satellite-sync fails with ORA-00001: unique constraint (RHNSAT.RHN_ERRATA_ADVISORY_UQ) violated
Complete error :
Exception Handler Information
Traceback (most recent call last):
File "/usr/bin/satellite-sync", line 136, in main
return satsync.Runner().main()
File "/usr/share/rhn/satellite_tools/satsync.py", line 199, in main
ret = method()
File "/usr/share/rhn/satellite_tools/satsync.py", line 313, in _step_errata
self.syncer.import_errata()
File "/usr/share/rhn/satellite_tools/satsync.py", line 1704, in import_errata
sync_handlers.import_errata(chunk)
File "/usr/share/rhn/satellite_tools/sync_handlers.py", line 417, in import_errata
importer.run()
File "/usr/share/rhn/server/importlib/importLib.py", line 617, in run
self.submit()
File "/usr/share/rhn/server/importlib/errataImport.py", line 177, in submit
dml = self.backend.processErrata(self.batch)
File "/usr/share/rhn/server/importlib/backend.py", line 700, in processErrata
transactional=1)
File "/usr/share/rhn/server/importlib/backend.py", line 1325, in __processObjectCollection
return self.__processObjectCollection__(objColl, parentTable, childDict, **kwargs)
File "/usr/share/rhn/server/importlib/backend.py", line 1495, in __processObjectCollection__
return self.__doDML(dml)
File "/usr/share/rhn/server/importlib/backend.py", line 1603, in __doDML
self.__doInsert(dml.insert, dml.tables)
File "/usr/share/rhn/server/importlib/backend.py", line 1609, in __doInsert
self.__doInsertTable(tname, dict)
File "/usr/share/rhn/server/importlib/backend.py", line 1621, in __doInsertTable
insertObj.query(hash)
File "/usr/share/rhn/server/importlib/backendLib.py", line 419, in query
executeStatement(statement, values, self.count)
File "/usr/share/rhn/server/importlib/backendLib.py", line 449, in executeStatement
count = count + apply(statement.executemany, (), tempdict)
File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 103, in executemany
return apply(self._execute_wrapper, (self._executemany, ) + p, kw)
File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 159, in _execute_wrapper
raise apply(sql_base.SQLError, ret)
SQLError: (1, 'ORA-00001: unique constraint (RHNSAT.RHN_ERRATA_ADVISORY_UQ) violated\n', 'insert into rhnErrata (advisory_name, advisory, product, description, advisory_type, severity_id, notes, org_id, solution, id, topic, synopsis, last_modified, issue_date, update_date, locally_modified, advisory_rel, refers_to) values (:advisory_name, :advisory, :product, :description, :advisory_type, :severity_id, :notes, :org_id, :solution, :id, :topic, :synopsis, :last_modified, :issue_date, :update_date, :locally_modified, :advisory_rel, :refers_to)')
Environment
Red Hat Network Satellite v5.3
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.
