[Spacewalk-list] IntegrityError: new row for relation "rhnserveractionverifyresult" violates check constraint "rhn_sactionvr_attr_ck"

[Michael Mraka]

Daniel Dreier wrote:
% I'm experiencing a problem during rhn_check after requesting package
% verification via the spacewalk web interface. I'm running spacewalk
% 1.6 on Centos 6.2 on x86_64 platform with a postgresql database. All
% packages are current. I have searched the archives of this list and
% the spacewalk-devel list and found no prior references to this error.
% I am able to install packages and manage configuration as expected,
% but when I schedule package verification I get the following error on
% the client (hostname skylab):
...
% [daniel at skylab ~]$ sudo rhn_check
% [sudo] password for daniel:
% XMLRPC ProtocolError: <ProtocolError for juno /XMLRPC: 500 Internal
% Server Error>
...
% [Fri Feb 24 13:08:32 2012] [error]   File
% "/usr/lib/python2.6/site-packages/spacewalk/server/action_extra_data/packages.py",
% line 171, in verify
% [Fri Feb 24 13:08:32 2012] [error]     apply(h.executemany, (), verify_attribs)
% [Fri Feb 24 13:08:32 2012] [error]   File
% "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py",
% line 172, in executemany
% [Fri Feb 24 13:08:32 2012] [error]     return
% apply(self._execute_wrapper, (self._executemany, ) + p, kw)
% [Fri Feb 24 13:08:32 2012] [error]   File
% "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
% line 282, in _execute_wrapper
% [Fri Feb 24 13:08:32 2012] [error]     retval = apply(function, p, kw)
% [Fri Feb 24 13:08:32 2012] [error]   File
% "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py",
% line 318, in _executemany
% [Fri Feb 24 13:08:32 2012] [error]
% self._real_cursor.executemany(self.sql, all_kwargs)
% [Fri Feb 24 13:08:32 2012] [error] IntegrityError: new row for
% relation "rhnserveractionverifyresult" violates check constraint
% "rhn_sactionvr_attr_ck"
% [Fri Feb 24 13:08:32 2012] [error]
% [Fri Feb 24 13:08:32 2012] [error]
...

Hi Daniel,

You're right, it's a PostgreSQL issue. I've fixed it in spacewalk master
(commit 3c1fc16b48c87e2455470a20e5042dce6c8c0e8b). The fix is pretty
easy so you may apply it manually to your Spacewalk 1.6 if needed.

Thanks for the report.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat