satellite-sync fails with ORA-00001: unique constraint (RHNSAT.RHN_ERRATA_ADVISORY_UQ) violated

Solution Verified - Updated -

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

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content