[Spacewalk-list] Cannot install updates on spacewalk client

[Robert Paschedag]

Oh..just saw, that the spacewalk-data-fsck tool does not clean the DB.

Hmm...



> Gesendet: Montag, 09. April 2018 um 15:26 Uhr
> Von: "Michael Watters" <wattersm at watters.ws>
> An: spacewalk-list at redhat.com
> Betreff: Re: [Spacewalk-list] Cannot install updates on spacewalk client
>
> 
> 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.
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>