Bug 1471120
| Summary: | Advanced search for systems with installed packages is not working correctly for java packages | ||
|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Kenny Tordeurs <ktordeur> |
| Component: | Other | Assignee: | Jiří Dostál <jdostal> |
| Status: | CLOSED ERRATA | QA Contact: | Ales Dujicek <adujicek> |
| Severity: | low | Docs Contact: | |
| Priority: | low | ||
| Version: | 570 | CC: | adujicek, jdostal, ktordeur, tlestach |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | x86_64 | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | spacewalk-java-2.5.14-108-sat | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2018-02-05 13:56:41 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 1450111 | ||
|
Description
Kenny Tordeurs
2017-07-14 13:02:31 UTC
I've tried to reproduce the issue without any success. I've followed above steps and end up with found systems, which is correct. Could you please check whether all packages were marked for indexing? for example with following query: 'SELECT last_id AS last_indexed, MAX(id) from rhnPackage, rhnIndexerWork WHERE rhnIndexerWork.object_type = 'package' GROUP BY last_id;' Output from SQL:
rhnschema=# SELECT last_id AS last_indexed, MAX(id) from rhnPackage, rhnIndexerWork WHERE rhnIndexerWork.object_type = 'package' GROUP BY last_id;
last_indexed | max
--------------+--------
101471 | 105953
Also as FYI all packages installed on client are from Satellite: # yum repolist -v Loading "rhnplugin" plugin Loading "package_upload" plugin Loading "product-id" plugin Loading "search-disabled-repos" plugin Not loading "subscription-manager" plugin, as it is disabled Config time: 0.081 This system is receiving updates from RHN Classic or Red Hat Satellite. Looking for repo options for [main] Looking for repo options for [rhel-x86_64-server-7] Repo 'rhel-x86_64-server-7' setting option 'enabled' = '1' Repo 'rhel-x86_64-server-7' setting option 'gpgcheck' = '1' Repo 'rhel-x86_64-server-7' setting option 'timeout' = '120' Looking for repo options for [rhel-x86_64-server-7-thirdparty-oracle-java] Repo 'rhel-x86_64-server-7-thirdparty-oracle-java' setting option 'enabled' = '1' Repo 'rhel-x86_64-server-7-thirdparty-oracle-java' setting option 'gpgcheck' = '1' Repo 'rhel-x86_64-server-7-thirdparty-oracle-java' setting option 'timeout' = '120' Yum version: 3.4.3 Setting up Package Sacks pkgsack time: 0.006 Repo-id : rhel-x86_64-server-7 Repo-name : Red Hat Enterprise Linux Server (v. 7 for 64-bit x86_64) Repo-updated : Tue Aug 15 16:38:45 2017 Repo-pkgs : 16,925 Repo-size : 22 G Repo-baseurl : https://ktordeur-sat57.usersys.redhat.com/XMLRPC/GET-REQ/rhel-x86_64-server-7 Repo-expire : 21,600 second(s) (last: Wed Oct 11 18:06:38 2017) Filter : read-only:present Repo-id : rhel-x86_64-server-7-thirdparty-oracle-java Repo-name : Oracle Java for RHEL Server (v. 7 64-bit x86_64) Repo-updated : Tue Aug 15 15:41:12 2017 Repo-pkgs : 306 Repo-size : 6.4 G Repo-baseurl : https://ktordeur-sat57.usersys.redhat.com/XMLRPC/GET-REQ/rhel-x86_64-server-7-thirdparty-oracle-java Repo-expire : 21,600 second(s) (last: Wed Oct 11 18:07:01 2017) Filter : read-only:present repolist: 17,231 spacewalk bf0fcff8fbe4bb1bfb795f1cdd111d3dd1572821 Since the problem described in this bug report should be resolved in a recent advisory, it has been closed with a resolution of ERRATA. For information on the advisory, and where to find the updated files, follow the link below. If the solution does not work for you, open a new bug report. https://access.redhat.com/errata/RHBA-2018:0274 |