Scheduling multiple erratas from Satellite throws tracebacks with error 'duplicate key value violates unique constraint "rhn_sp_snep_uq"'
Issue
- Scheduling Errata from Satellite throws tracebacks as below,
File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", line 123, in call_function
response = apply(func, params)
File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 925, in update_packages
server.save_packages()
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_wrapper.py", line 75, in save_packages
ret = self.save_packages_byid(self.server["id"], schedule=schedule)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_packages.py", line 228, in save_packages_byid
h.execute_bulk(package_data)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 197, in execute_bulk
ret = ret + apply(self.executemany, (), subdict)
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_sp_snep_uq"
- Activating satellite certificate after upgrading satellite using command
rhn-satellite-activatethrows following tracebacks
Exception Handler Information
Traceback (most recent call last):
File "/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py", line 123, in call_function
response = apply(func, params)
File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 925, in update_packages
server.save_packages()
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnServer/server_wrapper.py", line 75, in save_packages
ret = self.save_packages_byid(self.server["id"], schedule=schedule)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnServer/server_packages.py", line 228, in save_packages_byid
h.execute_bulk(package_data)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 197, in execute_bulk
ret = ret + apply(self.executemany, (), subdict)
File "/usr/lib/python2.4/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.4/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 273, in _execute_wrapper
retval = apply(function, p, kw)
File "/usr/lib/python2.4/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_sp_snep_uq"
Environment
- Red Hat Satellite 5.6
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.