[Spacewalk-list] Cannot install updates on spacewalk client

[Michael Watters]

On 03/29/2018 06:48 AM, Paschedag, Robert wrote:
> You can check the path with
>
> select * from rhnpackage where id = 11570;
>
> But the message indicates some sort of error while you were synchronizing your repos. I would try to locate this problem "package" within SW in the "Channels" -> "Manage Software Channels" -> "Manage software packages" and try to *fully* delete this package and try to re-sync.
>
> Robert

Something is definitely wrong with the database, the path is not defined
in the rhnpackage table.

spacewalk=# select path from rhnpackage where id = 11570;
 path 
------
 
(1 row)

I manually updated the path using the following query and and updates
are being served properly again.

spacewalk=# update rhnpackage set path = 'redhat/1/d36/rubygem-rdoc/4.0.0-33.el7_4/noarch/d36ba5af985c92e517e20869e08792617419e3cee95340d80059da3009bbda42/rubygem-rdoc-4.0.0-33.el7_4.noarch.rpm' where id = 11570 ;
UPDATE 1


Not sure how the db got into this state in the first place but it may
help to add a feature to spacewalk-data-fsck to correct the file paths.