[Spacewalk-list] rhnpush uploading error

[Jan Pazdziora]

On Fri, Aug 03, 2012 at 11:51:56AM +0400, Stepan Rogov wrote:
> Hi all!
> 
> When I try to load the packages:
> 
> rhnpush --channel=centos-6-kmsearch-x86_64  --username=admin
> --password=admin --dir=/var/rpms/sys/ --server=spacewalk_server/APP
> 
> 
> there is an error:
> 
> Error Message:
>     ERROR:  duplicate key value violates unique constraint
> "rhn_cnp_cid_nid_uq"
> DETAIL:  Key (channel_id, name_id, package_arch_id)=(103, 15293,
> 119) already exists.
> CONTEXT:  SQL statement "insert into rhnChannelNewestPackage
>                 (channel_id, name_id, evr_id, package_id, package_arch_id)
>                 (select channel_id,
>                         name_id, evr_id,
>                         package_id, package_arch_id
>                    from rhnChannelNewestPackageView
>                   where channel_id = channel_id_in
>                     and (package_name_id_in is null
>                          or name_id = package_name_id_in)
>                 )"
> PL/pgSQL function "refresh_newest_package" line 8 at SQL statement
> Error Class Code: 23
> Error Class Info: Could not update database entry.
> 
> What is wrong?

This means that the channel already contains one of the packages that
you are attempting to rhnpush, with different checksum.

Can you investigate which package is the culprit?

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat