[Spacewalk-list] rhnpush uploading error

[Jan Pazdziora]

On Fri, Aug 03, 2012 at 11:53:37AM +0200, Jan Pazdziora wrote:
> 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?

Query like

	select name from rhnpackagename where id = 15293

should show the name.

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