Satellite is sending traceback containing error 'duplicate key value violates unique constraint "rhn_serverpath_sid_pos_uq"'

Solution Verified - Updated -

Issue

  • Satellite sends traceback containing error as below,
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/up2date.py", line 141, in login
    server_route.store_client_route(self.server_id)
  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnServer/server_route.py", line 106, in store_client_route
    position=positions, hostname=proxy_hostnames)
  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_serverpath_sid_pos_uq"

Environment

  • Red Hat Proxy 5.6
  • RHN Satellite 5.6

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content