Description of problem: # elinks -dump 1 /var/lib/pgsql/analyzer_report.html | sed -n '/^[ \t]\+2\.6\. Virtual Machine(s) pinned with Unknown Host/,/2.7/p' 2.6. Virtual Machine(s) pinned with Unknown Host The following Virtual Machine(s) are pinned to unknown hypervisor. It is recommended to unpin these VM(s) from the listed Hypervisors. Virtual Machine Hypervisor ID An error occurred when executing SQL, command you may not use was: Licensed under the Apache License, Version 2.0 (the this file except in "License"); compliance with the License. You may obtain a copy of the License at [42]http://www.apache.org/licenses/LICENSE-2.0 distributed under Unless required by applicable law or agreed to in the License is writing, software distributed on an "AS IS" BASIS, See the License WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either for the specific express or implied. language governing permissions and limitations under the License. SELECT vm_name AS "Virtual Machine", dedicated_vm_for_vds AS "Hypervisor ID" FROM vm_static WHERE dedicated_vm_for_vds::text <> '' AND Traceback (most dedicated_vm_for_vds::uuid NOT IN (SELECT vds_id from recent call last): vds_static) File "/usr/lib/python2.7/site-packages/engine_db_query/init.py", sys.stdout Version-Release number of selected component (if applicable): rhv-log-collector-analyzer-0.1.5-0.el7ev.noarch How reproducible: 100% Steps to Reproduce: 1. run tool 2. 3. Actual results: bogus data Expected results: valid data Additional info:
What patch addresses this?
No SQL error in pinned VMs. verified in rhv-log-collector-analyzer-0.1.6-0.el7ev.noarch But it still shows wrong data when VM is pinned to more hosts. I created new BZ 1642318
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:3487