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 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.
