Bug 1618739 - Virtual Machine(s) pinned with Unknown Host section is bogus
Summary: Virtual Machine(s) pinned with Unknown Host section is bogus
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: rhv-log-collector-analyzer
Version: 4.2.6
Hardware: Unspecified
OS: Unspecified
unspecified
high
Target Milestone: ovirt-4.2.7
: ---
Assignee: Douglas Schilling Landgraf
QA Contact: Lucie Leistnerova
URL:
Whiteboard:
Depends On:
Blocks: 1634717
TreeView+ depends on / blocked
 
Reported: 2018-08-17 13:09 UTC by Jiri Belka
Modified: 2018-11-05 15:04 UTC (History)
2 users (show)

Fixed In Version: rhv-log-collector-analyzer-0.1.6-0.el7ev.noarch
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-11-05 15:04:23 UTC
oVirt Team: Integration
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1642318 0 unspecified CLOSED wrong sections for pinned VMs when the VM is pinned to more hosts 2022-03-22 13:36:06 UTC
Red Hat Product Errata RHBA-2018:3487 0 None None None 2018-11-05 15:04:27 UTC

Internal Links: 1642318

Description Jiri Belka 2018-08-17 13:09:35 UTC
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:

Comment 3 Yaniv Lavi 2018-09-03 07:25:10 UTC
What patch addresses this?

Comment 8 Lucie Leistnerova 2018-10-24 07:48:46 UTC
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

Comment 10 errata-xmlrpc 2018-11-05 15:04:23 UTC
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


Note You need to log in before you can comment on or make changes to this bug.