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