Re: [Spacewalk-list] Cannot install updates on spacewalk client

[Robert Paschedag]

Please go to

Channels -> manage software channels -> manage software packages

Select your channel with problematic packages

Can you find the packages in there?

If yes, remove the packages from the channel. If that works, go to the same view
and search for "packages in no channels". Your previously remove packages 
should show up.
Finally delete these packages from spacewalk and try to resync.

Robert


> Gesendet: Montag, 09. April 2018 um 15:17 Uhr
> Von: "Michael Watters" 
> An: spacewalk-list@redhat.com
> Betreff: [Spacewalk-list]  Cannot install updates on spacewalk client
>
> 
> On 04/04/2018 05:09 AM, Michael Mraka wrote:
> > Michael Watters:
> >>> 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
> >> No luck.  I deleted the package and reran spacewalk-repo-sync which
> >> claims to have downloaded the package but yum updates still fail.  The
> >> interesting part is spacewalk-repo-sync keeps trying to download the
> >> same 33 packages every time I download it.  For example, here's the output.
> > Hello Michael,
> >
> > How did you deleted the package? Just the file in /var/satellite?
> > Then the the wrong record in database is still there.
> >
> > You can try spacewalk-data-fsck to if there's any see mismatch between
> > db and filesystem (and there's also a limited functionality to "repair"
> > errors).
> 
> I removed the file in /var/satellite and then ran spacewalk-repo-sync
> which showed the package being downloaded again.  Here is what is shown
> when I sync the channel.
> 
> https://gist.github.com/blackknight36/0397f18b0167ae37759a96c1cd2728d1
> 
> Running the spacewalk-repo-sync again results in the same packages being
> imported, it's almost as if they're never making it into the database.
> 
> I've ran spacewalk-data-fsck to remove packages missing in the database
> and to fix missing files which also did not help.
> 
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Cannot install updates on spacewalk client

[Robert Paschedag]

> Gesendet: Montag, 09. April 2018 um 15:17 Uhr
> Von: "Michael Watters" 
> An: spacewalk-list@redhat.com
> Betreff: [Spacewalk-list]  Cannot install updates on spacewalk client
>
> 
> On 04/04/2018 05:09 AM, Michael Mraka wrote:
> > Michael Watters:
> >>> 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
> >> No luck.  I deleted the package and reran spacewalk-repo-sync which
> >> claims to have downloaded the package but yum updates still fail.  The
> >> interesting part is spacewalk-repo-sync keeps trying to download the
> >> same 33 packages every time I download it.  For example, here's the output.
> > Hello Michael,
> >
> > How did you deleted the package? Just the file in /var/satellite?
> > Then the the wrong record in database is still there.
> >
> > You can try spacewalk-data-fsck to if there's any see mismatch between
> > db and filesystem (and there's also a limited functionality to "repair"
> > errors).
> 
> I removed the file in /var/satellite and then ran spacewalk-repo-sync
> which showed the package being downloaded again.  Here is what is shown
> when I sync the channel.
> 
> https://gist.github.com/blackknight36/0397f18b0167ae37759a96c1cd2728d1
> 
> Running the spacewalk-repo-sync again results in the same packages being
> imported, it's almost as if they're never making it into the database.
> 
> I've ran spacewalk-data-fsck to remove packages missing in the database
> and to fix missing files which also did not help.

That is exactly the error. You did not also check to remove the packages
from the database, which are not on the filesystem.

As told, it looks like you have the error within your DB...so you need
to fix the DB, not the downloaded packages.

So run spacewalk-data-fsck again, but this time, remove packages from the
DB which are not found on disk

Robert


> 
> ___
> Spacewalk-list mailing list
> Spacewalk-list@redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [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.

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Cannot install updates on spacewalk client

[Michael Mraka]

Michael Watters:
> > 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
> 
> No luck.  I deleted the package and reran spacewalk-repo-sync which
> claims to have downloaded the package but yum updates still fail.  The
> interesting part is spacewalk-repo-sync keeps trying to download the
> same 33 packages every time I download it.  For example, here's the output.

Hello Michael,

How did you deleted the package? Just the file in /var/satellite?
Then the the wrong record in database is still there.

You can try spacewalk-data-fsck to if there's any see mismatch between
db and filesystem (and there's also a limited functionality to "repair"
errors).

> [root@spacewalk rhn]# spacewalk-repo-sync -v -c centos7-x86_64-updates
...
> 12:35:11 33/33 : xorg-x11-server-Xnest-1.19.3-11.el7_4.1.x86_64.rpm
> Importing packages: |##| 
> 100.0% 
> 12:35:32 Linking packages to channel.
> 12:35:32 Repo 
> http://mirrorlist.centos.org/?release=7=x86_64=updates has 0 errata.
> 12:35:33 Sync of channel completed in 0:00:43.
> 12:35:33 Total time: 0:00:43
> 
> Running spacewalk-repo-sync again results in the same 33 packages being 
> downloaded.

Regards,

--
Michael Mráka
System Management Engineering, Red Hat

___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [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

No luck.  I deleted the package and reran spacewalk-repo-sync which
claims to have downloaded the package but yum updates still fail.  The
interesting part is spacewalk-repo-sync keeps trying to download the
same 33 packages every time I download it.  For example, here's the output.

[root@spacewalk rhn]# spacewalk-repo-sync -v -c centos7-x86_64-updates  

  
12:34:49 ==
12:34:49 | Channel: centos7-x86_64-updates
12:34:49 ==
12:34:49 Sync of channel started.
12:34:50 Repo URL: 
http://mirrorlist.centos.org/?release=7=x86_64=updates
12:34:55 Packages in repo:  2416
12:35:05 Packages already synced:   2383
12:35:05 Packages to sync:33
12:35:05 New packages to download:33
12:35:05 Downloading total 33 files from 1 queues.
12:35:06 1/33 : NetworkManager-1.8.0-11.el7_4.x86_64.rpm
12:35:06 2/33 : git-email-1.8.3.1-12.el7_4.noarch.rpm
12:35:06 3/33 : debugmode-9.49.39-1.el7_4.1.x86_64.rpm
12:35:06 4/33 : bind-lite-devel-9.9.4-51.el7_4.2.i686.rpm
12:35:07 5/33 : NetworkManager-glib-devel-1.8.0-11.el7_4.i686.rpm
12:35:07 6/33 : kmod-devel-20-15.el7_4.7.x86_64.rpm
12:35:07 7/33 : java-1.8.0-openjdk-demo-1.8.0.161-0.b14.el7_4.i686.rpm
12:35:07 8/33 : kmod-libs-20-15.el7_4.4.i686.rpm
12:35:07 9/33 : libdb-cxx-devel-5.3.21-21.el7_4.x86_64.rpm
12:35:07 10/33 : libgudev1-219-42.el7_4.7.x86_64.rpm
12:35:08 11/33 : kernel-abi-whitelists-3.10.0-693.1.1.el7.noarch.rpm
12:35:08 12/33 : libgudev1-devel-219-42.el7_4.7.x86_64.rpm
12:35:08 13/33 : libguestfs-xfs-1.36.3-6.el7_4.3.x86_64.rpm
12:35:08 14/33 : java-1.8.0-openjdk-devel-debug-1.8.0.141-2.b16.el7_4.x86_64.rpm
12:35:08 15/33 : libquadmath-4.8.5-16.el7_4.1.i686.rpm
12:35:08 16/33 : libtsan-static-4.8.5-16.el7_4.1.x86_64.rpm
12:35:08 17/33 : nss-pkcs11-devel-3.28.4-12.el7_4.x86_64.rpm
12:35:08 18/33 : pacemaker-cluster-libs-1.1.16-12.el7_4.7.i686.rpm
12:35:09 19/33 : pacemaker-cluster-libs-1.1.16-12.el7_4.2.i686.rpm
12:35:09 20/33 : libdb-devel-static-5.3.21-21.el7_4.i686.rpm
12:35:09 21/33 : motif-2.3.4-12.el7_4.i686.rpm
12:35:10 22/33 : pki-kra-10.4.1-17.el7_4.noarch.rpm
12:35:10 23/33 : pacemaker-libs-devel-1.1.16-12.el7_4.2.x86_64.rpm
12:35:10 24/33 : 
java-1.8.0-openjdk-javadoc-zip-debug-1.8.0.161-0.b14.el7_4.noarch.rpm
12:35:10 25/33 : pacemaker-libs-devel-1.1.16-12.el7_4.4.i686.rpm
12:35:10 26/33 : pki-symkey-10.4.1-17.el7_4.x86_64.rpm
12:35:10 27/33 : python-rhsm-1.19.10-1.el7_4.x86_64.rpm
12:35:10 28/33 : pacemaker-libs-devel-1.1.16-12.el7_4.7.i686.rpm
12:35:10 29/33 : rubygem-rdoc-4.0.0-33.el7_4.noarch.rpm
12:35:10 30/33 : tuned-utils-2.8.0-5.el7_4.2.noarch.rpm
12:35:10 31/33 : sssd-1.15.2-50.el7_4.6.x86_64.rpm
12:35:11 32/33 : tzdata-2017c-1.el7.noarch.rpm
12:35:11 33/33 : xorg-x11-server-Xnest-1.19.3-11.el7_4.1.x86_64.rpm
Importing packages: |##| 
100.0% 
12:35:32 Linking packages to channel.
12:35:32 Repo http://mirrorlist.centos.org/?release=7=x86_64=updates 
has 0 errata.
12:35:33 Sync of channel completed in 0:00:43.
12:35:33 Total time: 0:00:43

Running spacewalk-repo-sync again results in the same 33 packages being 
downloaded.


___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list

Re: [Spacewalk-list] Cannot install updates on spacewalk client

[Paschedag, Robert]

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


-Ursprüngliche Nachricht-
Von: spacewalk-list-boun...@redhat.com  Im 
Auftrag von Michael Watters
Gesendet: Mittwoch, 28. März 2018 21:48
An: spacewalk-list@redhat.com
Betreff: [Spacewalk-list] Cannot install updates on spacewalk client

I have Spacewalk set up with channels for CentOS 7 and CentOS 7 updates however 
I am unable to install updates on client nodes.  Running yum update results in 
an error as follows.

Error downloading packages:
  rubygem-rdoc-4.0.0-33.el7_4.noarch: failed to retrieve 
getPackage/rubygem-rdoc-4.0.0-33.el7_4.noarch.rpm from centos7-x86_64-updates 
error was [Errno 14] HTTPS Error 404 - Not Found

I removed the cache data in /var/cache/rhn/repodata and resynced the channel 
using the spacewalk-repo-sync command however that did not help.  There is an 
rpm file located at 
/var/satellite/redhat/1/d36/rubygem-rdoc/4.0.0-33.el7_4/noarch/d36ba5af985c92e517e20869e08792617419e3cee95340d80059da3009bbda42/rubygem-rdoc-4.0.0-33.el7_4.noarch.rpm
as well.

rhn logs show errors similar to below.

2018/03/28 15:44:35 -04:00 17881 10.201.64.12: 
server/rhnPackage.check_package_file('ERROR', 'Package path null for package 
id', 11570)

Does anybody know how to resolve this? Is there a way to fill in the package 
path using postgresql?




___
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list