Why Red Hat Satellite registeration fails with - IntegrityError: new row for relation "rhnpackageevr" violates check constraint "vn_rhnpackageevr_release"
Issue
- Red Hat Satellite registration fails with the below error:
[error] Exception Handler Information
[error] Traceback (most recent call last):
[error] File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheRequest.py", line 122, in call_function
[error] response = func(*params)
[error] File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 857, in add_packages
[error] server.save_packages()
[error] File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_wrapper.py", line 75, in save_packages
[error] ret = self.save_packages_byid(self.server["id"], schedule=schedule)
[error] File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnServer/server_packages.py", line 228, in save_packages_byid
[error] h.execute_bulk(package_data)
[error] File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 181, in execute_bulk
[error] ret = ret + self.executemany(**subdict)
[error] File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 156, in executemany
[error] return self._execute_wrapper(self._executemany, *p, **kw)
[error] File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 286, in _execute_wrapper
[error] retval = function(*p, **kw)
[error] File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 328, in _executemany
[error] self._real_cursor.executemany(self.sql, all_kwargs)
[error] IntegrityError: new row for relation "rhnpackageevr" violates check constraint "vn_rhnpackageevr_release"
[error] DETAIL: Failing row contains (17292, 0, 2.0.1, , (0,2.0.1,"")).
[error] CONTEXT: Error occurred on dblink connection named "at_conn": could not execute command.
[error] SQL statement "SELECT dblink_exec('at_conn', in_sql, true)"
[error] PL/pgSQL function pg_dblink_exec(character varying) line 8 at PERFORM
[error] SQL statement "SELECT pg_dblink_exec(
[error] 'insert into rhnPackageEVR(id, epoch, version, release, evr) values (' ||
[error] evr_id || ', ' || e_text || ', ' || v_text || ', ' || r_text
[error] \t\t|| ', evr_t(' || e_text || ', ' || v_text || ', ' || r_text || '))'
[error] )"
[error] PL/pgSQL function lookup_evr(character varying,character varying,character varying) line 19 at PERFORM
Environment
- Red Hat Satellite 5.x
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.
