Bug 1673299 - Windows VM(s) with incorrect timezone section is reporting health VMs
Summary: Windows VM(s) with incorrect timezone section is reporting health VMs
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: rhv-log-collector-analyzer
Version: 4.2.8
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: ovirt-4.3.6
: 4.3.0
Assignee: Douglas Schilling Landgraf
QA Contact: Ivana Saranova
URL:
Whiteboard:
Depends On: 1658509
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-02-07 09:57 UTC by Jaroslav Spanko
Modified: 2021-08-30 12:47 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: No Doc Update
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-10-25 13:52:56 UTC
oVirt Team: External
Target Upstream Version:
Embargoed:
lsvaty: testing_plan_complete-


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Knowledge Base (Solution) 3911191 0 None None None 2019-09-11 13:55:21 UTC

Description Jaroslav Spanko 2019-02-07 09:57:36 UTC
Description of problem:
rhv-log-collector-analyzer reports wrong VMs in Windows VM(s) with incorrect timezone section because of different time zones format in vms_query_windows_vms_with_incorrect_timezone.sql vs sp_table_linux_aux_timezone_query.sql

Version-Release number of selected component (if applicable):
rhv-log-collector-analyzer-0.2.3-0.el7ev.noarch

How reproducible:
100%

Steps to Reproduce:
1. setup correct time zone - guest agent does not complain about time zone problem
2. run analyzer
3. VMs are reported as wrongly configured

Actual results:
VMs are reported as wrongly configured

Expected results:
Correct VMs list

Additional info:
Wrong report is due to 
------------
WHERE
time_zone NOT IN
(
   SELECT zone FROM timezone_temp
);
------------
where vm_static contains
------------
      VM Name      |     Time Zone     
-------------------+-------------------
   test            | FLE Standard Time
   test1           | FLE Standard Time

but timezone_temp contains
------------
INSERT INTO timezone_temp VALUES
    ('Etc/GMT', '(GMT+00:00) GMT Standard Time'),
    ('Europe/Kiev', '(GMT+02:00) FLE Standard Time'),
------------

Comment 1 Douglas Schilling Landgraf 2019-02-13 20:21:10 UTC
Users can work around editing /usr/share/rhv-log-collector-analyzer/analyzer/produceReport/sqls/vms_query_windows_vms_with_incorrect_timezone.sql

Replace:
        SELECT zone FROM timezone_temp
With:
        SELECT zone FROM timezone_windows_temp

Comment 4 Ivana Saranova 2019-03-28 16:27:31 UTC
Can't verify due to this bz 1658509, please retarget milestone and remove from errata, thanks.

Comment 7 Ivana Saranova 2019-08-19 14:13:27 UTC
Steps:
1. Setup correct timezone
2. Run analyzer

Result:
No error messages in the analyzer report about wrongly configured VMs.

Verified in:
rhv-log-collector-analyzer-0.2.9-0.el7ev.noarch
ovirt-engine-4.3.6.2-0.1.el7.noarch

Comment 8 Daniel Gur 2019-08-28 13:14:27 UTC
sync2jira

Comment 9 Daniel Gur 2019-08-28 13:19:29 UTC
sync2jira

Comment 10 Marina Kalinin 2019-10-25 12:23:34 UTC
Can this be closed current release for 4.3.6?

Comment 11 Sandro Bonazzola 2019-10-25 13:52:56 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of CURRENT RELEASE.

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-2019:3012


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