[Spacewalk-list] Unique constraint violation

[Mark Watts]

On Mon, 31 Oct 2011 17:07:11 +0100, Michael Mraka
<michael.mraka at redhat.com> wrote:
> 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.


I don't have RPM's of exactly the same package name in Spacewalk, as far
as a package search shows.

The closest I have are:

In Spacewalk (CR Repo):  slapi-nis-0.23-1.el6.x86_64.rpm
On Repo (CR Repo):       slapi-nis-0.23-1.el6-0.x86_64

In Spacewalk (Updates repo):  pam_ssh_agent_auth-0.9-20.el6_0.3.x86_64
On Repo (CR Repo):            pam_ssh_agent_auth-0.9-52.el6-0.x86_64

As a result, theres nothing conflicting for me to remove/resync.

Mark.

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