How can I solve this problem `IntegrityError: duplicate key value violates unique constraint rhn_channel_family_name_uq` in Satellite server ?

Solution Unverified - Updated -

Issue

  • Satellite 5: satellite-sync fails with error "IntegrityError: duplicate key value violates unique constraint "rhn_channel_family_name_uq" when sync'ing "Oracle Java for RHEL (v. 6) Server EUS" channels

  • Running satellite-sync on "Oracle Java for RHEL (v. 6) Server EUS" and "Oracle Java for RHEL (v. 6) Server EUS Debuginfo" channels fails with following traceback:

Time: Wed Apr 23 02:00:55 2014
Exception type <class 'psycopg2.IntegrityError'>

Exception Handler Information
Traceback (most recent call last):
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/xmlSource.py", line 131, in process
    self.__parser.parse(self.__stream)
  File "/usr/lib64/python2.6/xml/sax/expatreader.py", line 107, in parse
    xmlreader.IncrementalParser.parse(self, source)
  File "/usr/lib64/python2.6/xml/sax/xmlreader.py", line 123, in parse
    self.feed(buffer)
  File "/usr/lib64/python2.6/xml/sax/expatreader.py", line 207, in feed
    self._parser.Parse(data, isFinal)
  File "/usr/lib64/python2.6/xml/sax/expatreader.py", line 304, in end_element
    self._cont_handler.endElement(name)
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/xmlSource.py", line 221, in endElement
    self.__container.endElement(element)
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/xmlSource.py", line 887, in endElement
    self.endContainerCallback()
  File "/usr/lib/python2.6/site-packages/spacewalk/satellite_tools/sync_handlers.py", line 526, in endContainerCallback
    importer.run()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", line 647, in run
    self.submit()
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/channelImport.py", line 249, in submit
    self.backend.processChannelFamilies(self.batch)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 980, in processChannelFamilies
    forceVerify=1)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 1508, in __processObjectCollection
    return self.__processObjectCollection__(objColl, parentTable, childDict, **kwargs)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 1678, in __processObjectCollection__
    return self.__doDML(dml)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 1785, in __doDML
    self.__doUpdate(dml.update, dml.tables)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 1833, in __doUpdate
    self.__doUpdateTable(tname, dict)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", line 1846, in __doUpdateTable
    updateObj.query(hash)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backendLib.py", line 326, in query
    executeStatement(statement, val, self.count)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backendLib.py", line 456, in executeStatement
    count += statement.executemany(**tempdict)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 172, in executemany
    return apply(self._execute_wrapper, (self._executemany, ) + p, kw)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 273, in _execute_wrapper
    retval = apply(function, p, kw)
  File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 310, in _executemany
    self._real_cursor.executemany(self.sql, all_kwargs)
IntegrityError: duplicate key value violates unique constraint "rhn_channel_family_name_uq"

Environment

  • Red Hat Satellite 5.6 running satellite-sync on the following 2 channels:
Oracle Java for RHEL (v. 6) Server EUS   
(rhel-server-6-oracle-java-debug-z)

Oracle Java for RHEL (v. 6) Server EUS Debuginfo 
(rhel-server-6-oracle-java-z)
  • In some case the same issue can also affect other channels besides rhel-server-6-oracle-java-z

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