[Spacewalk-list] Unique constraint violation

[Mark Watts]

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?
One side effect is that its stopping me from doing any CentOS 6 updates
since the repos are never rebuilt.

Mark.


-- 
Mark Watts, BSc RHCE
http://www.linux-corner.info/