[Spacewalk-list] Unique constraint violation

[Michael Mraka]

Mark Watts wrote:
% 
% I've been mirroring the CentOS 6 x86_64 CR repo since it came out.
% Recently I've noticed that its failing to sync with the following errors:
% 
% # /usr/bin/spacewalk-repo-sync --channel centos-6.0-x86_64-cr --type yum
% Repo http://mirror.centos.org/centos/6.0/cr/x86_64/ has 2192 packages.
% 1/157 : slapi-nis-0.23-1.el6-0.x86_64
% (23, 'ORA-00001: unique constraint (SPACEWALK.RHN_CNP_CID_NID_UQ)
% violated\nORA-06512: at "SPACEWALK.RHN_CHANNEL", line 1087\nORA-06512: at
% line 1\n', 'Could not update database entry.')
% 2/157 : pam_ssh_agent_auth-0.9-52.el6-0.x86_64
% (23, 'ORA-00001: unique constraint (SPACEWALK.RHN_CNP_CID_NID_UQ)
% violated\nORA-06512: at "SPACEWALK.RHN_CHANNEL", line 1087\nORA-06512: at
% line 1\n', 'Could not update database entry.')
% Traceback (most recent call last):
%   File "/usr/bin/spacewalk-repo-sync", line 69, in ?
%     sys.exit(abs(main() or 0))
%   File "/usr/bin/spacewalk-repo-sync", line 63, in main
%     sync.main()
%   File
% "/usr/lib/python2.4/site-packages/spacewalk/satellite_tools/reposync.py",
% line 103, in main
%     self.import_packages(plugin, url)
%   File
% "/usr/lib/python2.4/site-packages/spacewalk/satellite_tools/reposync.py",
% line 192, in import_packages
%     finally_remove(localpath)
%   File
% "/usr/lib/python2.4/site-packages/spacewalk/satellite_tools/reposync.py",
% line 172, in finally_remove
%     os.remove(path)
% OSError: [Errno 2] No such file or directory:
% '/var/cache/rhn/reposync/centos-6.0-x86_64-cr/packages/pam_ssh_agent_auth-0.9-52.el6.x86_64.rpm'
% 
% 
% Any ideas on what the issue is, and how I fix it?

Do you have slapi-nis-0.23-1.el6 and pam_ssh_agent_auth-0.9-52.el6
already in database? What are their checksums? Are they equal to
checksums of corresponding packages on
http://mirror.centos.org/centos/6.0/cr/x86_64/?

% One side effect is that its stopping me from doing any CentOS 6 updates
% since the repos are never rebuilt.

You might try to delete the above packages from the channel (in webUI)
and let them resync.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat