How can I solve this problem `IntegrityError: duplicate key value violates unique constraint rhn_channel_family_name_uq` in Satellite server ?
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 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.
