Bug 1673299
| Summary: | Windows VM(s) with incorrect timezone section is reporting health VMs | ||
|---|---|---|---|
| Product: | Red Hat Enterprise Virtualization Manager | Reporter: | Jaroslav Spanko <jspanko> |
| Component: | rhv-log-collector-analyzer | Assignee: | Douglas Schilling Landgraf <dougsland> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Ivana Saranova <isaranov> |
| Severity: | medium | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 4.2.8 | CC: | dougsland, gdeolive, lleistne, lsvaty, michal.skrivanek, mkalinin |
| Target Milestone: | ovirt-4.3.6 | Keywords: | FieldEngineering |
| Target Release: | 4.3.0 | Flags: | lsvaty:
testing_plan_complete-
|
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | No Doc Update | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2019-10-25 13:52:56 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | External | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | 1658509 | ||
| Bug Blocks: | |||
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
Can't verify due to this bz 1658509, please retarget milestone and remove from errata, thanks. 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 sync2jira sync2jira Can this be closed current release for 4.3.6? 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 |
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'), ------------