Bug 1618739
| Summary: | Virtual Machine(s) pinned with Unknown Host section is bogus | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Jiri Belka <jbelka> |
| Component: | rhv-log-collector-analyzer | Assignee: | Douglas Schilling Landgraf <dougsland> |
| Status: | CLOSED ERRATA | QA Contact: | Lucie Leistnerova <lleistne> |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 4.2.6 | CC: | dougsland, ylavi |
| Target Milestone: | ovirt-4.2.7 | Keywords: | FieldEngineering, ZStream |
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | rhv-log-collector-analyzer-0.1.6-0.el7ev.noarch | Doc Type: | If docs needed, set a value |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2018-11-05 15:04:23 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | Integration | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 1634717 | ||
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 |
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: