Scheduling multiple erratas from Satellite throws tracebacks with error 'duplicate key value violates unique constraint "rhn_sp_snep_uq"'

Solution Verified - Updated -

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

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.