[Spacewalk-list] rhnpush uploading error

[Stepan Rogov]

On 03.08.2012 14:12, Jan Pazdziora wrote:
> 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.
>
Thank you all for your help!
I found the wrong package.