[Spacewalk-list] Unique constraint violation

[Mark Watts]

As a follow-up to this, I've resolved the issue by deleteing all packages
in the CR Channel and resyncing it.

I'd started seeing odd issues where packages that failed accoring to the
CLI were uploaded, but listed as orphaned packages belonging to no channel.

Mark.


On Mon, 31 Oct 2011 16:47:58 +0000, Mark Watts <m.watts at linux-corner.info>
wrote:
> 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/