Cause: Improper JOIN type in SQL was preventing the requested data from populating
Consequence: Namespaces missing when they had usage but no request in the utilization reports
Fix: Restructure query and aliases to include usage without prior requests on resources
Result: Namespaces no longer missing.
This fix went through backporting from 4.6 to customer version on 4.4
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 (OpenShift Container Platform 4.5.11 extras update), 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-2020:3721
verified with Server Version: 4.5.0-0.nightly-2020-09-14-030924 pruan@MacBook-Pro ~/workspace/testcases/bugs/1872425 $ sh ns_match.sh Found 43 namespaces with Pods out of 58 total namespaces pruan@MacBook-Pro ~/workspace/testcases/bugs/1872425 $ oc get reports NAME QUERY SCHEDULE RUNNING FAILED LAST REPORT TIME AGE cluster-cpu-capacity cluster-cpu-capacity Finished 2020-12-30T23:59:59Z 20m cluster-cpu-usage cluster-cpu-usage Finished 2020-12-30T23:59:59Z 20m cluster-cpu-utilization cluster-cpu-utilization Finished 2020-12-30T23:59:59Z 20m cluster-memory-capacity cluster-memory-capacity Finished 2020-12-30T23:59:59Z 20m cluster-memory-usage cluster-memory-usage Finished 2020-12-30T23:59:59Z 20m cluster-memory-utilization cluster-memory-utilization Finished 2020-12-30T23:59:59Z 20m cluster-persistentvolumeclaim-request cluster-persistentvolumeclaim-request Finished 2020-12-30T23:59:59Z 20m namespace-cpu-request namespace-cpu-request Finished 2020-12-30T23:59:59Z 20m namespace-cpu-usage namespace-cpu-usage Finished 2020-12-30T23:59:59Z 19m namespace-cpu-utilization namespace-cpu-utilization Finished 2020-12-30T23:59:59Z 19m namespace-memory-request namespace-memory-request Finished 2020-12-30T23:59:59Z 19m namespace-memory-usage namespace-memory-usage Finished 2020-12-30T23:59:59Z 19m namespace-memory-utilization namespace-memory-utilization Finished 2020-12-30T23:59:59Z 19m namespace-persistentvolumeclaim-request namespace-persistentvolumeclaim-request Finished 2020-12-30T23:59:59Z 19m namespace-persistentvolumeclaim-usage namespace-persistentvolumeclaim-usage Finished 2020-12-30T23:59:59Z 19m node-cpu-allocatable node-cpu-allocatable Finished 2020-12-30T23:59:59Z 19m node-cpu-capacity node-cpu-capacity Finished 2020-12-30T23:59:59Z 19m node-cpu-utilization node-cpu-utilization Finished 2020-12-30T23:59:59Z 18m node-memory-allocatable node-memory-allocatable Finished 2020-12-30T23:59:59Z 18m node-memory-capacity node-memory-capacity Finished 2020-12-30T23:59:59Z 18m node-memory-utilization node-memory-utilization Finished 2020-12-30T23:59:59Z 18m persistentvolumeclaim-capacity persistentvolumeclaim-capacity Finished 2020-12-30T23:59:59Z 18m persistentvolumeclaim-request persistentvolumeclaim-request Finished 2020-12-30T23:59:59Z 18m persistentvolumeclaim-usage persistentvolumeclaim-usage Finished 2020-12-30T23:59:59Z 18m pod-cpu-request pod-cpu-request Finished 2020-12-30T23:59:59Z 18m pod-cpu-usage pod-cpu-usage Finished 2020-12-30T23:59:59Z 18m pod-memory-request pod-memory-request Finished 2020-12-30T23:59:59Z 18m pod-memory-usage pod-memory-usage Finished 2020-12-30T23:59:59Z 17m pruan@MacBook-Pro ~/workspace/testcases/bugs/1872425 $ display_report_using_exposed_route namespace-cpu-utilization | wc % Total % Received % Xferd Average Speed Time Time Time Current Dload Upload Total Spent Left Speed 100 6500 0 6500 0 0 10015 0 --:--:-- --:--:-- --:--:-- 10000 43 592 6500