2014102 – Central European Standard Time timzeone sets UTC time in Windows VMs

Bug 2014102 - Central European Standard Time timzeone sets UTC time in Windows VMs

Summary: Central European Standard Time timzeone sets UTC time in Windows VMs

Keywords:
Status:	CLOSED ERRATA
Alias:	None
Product:	Red Hat Enterprise Virtualization Manager
Classification:	Red Hat
Component:	ovirt-engine
Sub Component:
Version:	4.4.8
Hardware:	Unspecified
OS:	Unspecified
Priority:	unspecified
Severity:	high
Target Milestone:	ovirt-4.4.9-1
Target Release:	---
Assignee:	Saif Abusaleh
QA Contact:	Tamir
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+	depends on / blocked

Reported:	2021-10-14 13:35 UTC by Arik
Modified:	2024-12-20 21:23 UTC (History)
CC List:	3 users (show)
Fixed In Version:	ovirt-engine-4.4.9.3
Doc Type:	Bug Fix
Doc Text:	Previously, a typo in the time zone configuration resulted in the incorrect time being defined on Windows virtual machines set with the time zone Central European Standard Time. The current release fixes this issue and virtual machines previously changed to the incorrect time zone are now automatically changed to the correct time zone setting for Central European Standard Time.
Clone Of:
Environment:
Last Closed:	2021-11-16 13:54:29 UTC
oVirt Team:	Virt
Target Upstream Version:
Embargoed:

Attachments	(Terms of Use)

Links
System	ID	Priority	Status	Summary	Last Updated
Red Hat Issue Tracker	RHV-43811	None	None	None	2021-10-14 13:36:59 UTC
Red Hat Product Errata	RHBA-2021:4699	None	None	None	2021-11-16 13:54:33 UTC
oVirt gerrit	116260	None	MERGED	engine: Fix typo in timezones defaults properties file	2021-10-14 17:40:27 UTC
oVirt gerrit	116272	None	MERGED	engine: Fix typo in timezones defaults properties file	2021-10-14 17:40:27 UTC
oVirt gerrit	117152	master	MERGED	engine: Fix timezone typo	2021-10-14 13:56:45 UTC
oVirt gerrit	117158	ovirt-engine-4.4	MERGED	engine: Fix timezone typo	2021-10-14 17:28:58 UTC
oVirt gerrit	117160	ovirt-engine-4.4.9.z	MERGED	engine: Fix timezone typo	2021-10-14 17:30:27 UTC

Description Arik 2021-10-14 13:35:42 UTC

In 4.4.8 we had the following typo (missing 'e' at the engine):
Central European Standard Tim

So Windows VMs that were created/edited in 4.4.8 would be set with this value in the database.

We fixed that typo in 4.4.9 so VMs that are created/edited in 4.4.9 will be fixed but the fix lacked an upgrade script for fixing this issue for VMs that were last edited (or created) in 4.4.8.

Comment 5 Saif Abusaleh 2021-10-18 12:02:58 UTC

Bug fix verification scenario

prerequisite: engine version 4.4.8

Steps:

- Create Windows VM with timezone and vm init time zone as Central European Standard Time and save it
- notice in vm_static table and vm_init table in the database that the time-zone column is saved as Central European Standard Tim (missing e)
- Upgrade the engine to 4.4.9.3 version
- verify in vm_static table and vm_init table in the database that the time-zone column is saved as Central European Standard Time (without the missing e)

Comment 6 Arik 2021-10-18 12:22:28 UTC

(In reply to Saif Abusaleh from comment #5)
> Bug fix verification scenario
> 
> prerequisite: engine version 4.4.8
> 
> Steps:
> 
> - Create Windows VM with timezone and vm init time zone as Central European
> Standard Time and save it
> - notice in vm_static table and vm_init table in the database that the
> time-zone column is saved as Central European Standard Tim (missing e)
> - Upgrade the engine to 4.4.9.3 version
> - verify in vm_static table and vm_init table in the database that the
> time-zone column is saved as Central European Standard Time (without the
> missing e)

+ start the VM and check that the time in the guest OS is set correctly

Comment 10 Tamir 2021-11-04 18:17:34 UTC

Verified on RHV 4.4.9-7. Looks good to me.

Env:

  Before engine upgrade:

  - Engine instance with RHV 4.4.9-7 (ovirt-engine-4.4.9.4-0.1.el8ev) and RHEL 8.5 installed.
  - 3 Hosts with RHV 4.4.9-7 and RHEL 8.5, vdsm-4.40.90.4-1.el8ev, ovirt-engine-4.4.9.4-0.1.el8ev.

  After engine upgrade:

  - Engine instance with RHV 4.4.8-7 (ovirt-engine-4.4.8.6-0.1.el8ev) and RHEL 8.4 installed.
  - 3 Hosts with RHV 4.4.8-7 and RHEL 8.4, vdsm-4.40.80.6-1.el8ev, ovirt-engine-4.4.8.6-0.1.el8ev.

Steps:

** Note - from the first step until the upgrade step, the RHV version is 4.4.8-7.

In Admin Portal:

1. Create a 4.6 data center and a 4.6 cluster.
2. Install the hosts.
3. Add NFS storage domain.
4. Create 2 Windows 2019 VMs, 2 Windows 10 VMs, 2 RHEL VMs (for regression purposes) with a disk, a NIC, and with "Central European Standard Tim" (missing e) time zone.
   where 1 VM from each OS is sealed (for template creation), the other isn't sealed, and another (third) Windows 10 VM with GMT zone instead.
5. Create a template from each of the sealed and non-sealed Windows VMs.
6. Create a VM pool with 1 VM from each of the sealed templates.
7. Run the VMs and check their time zones and times are correct (according to the time zones).
8. Run the following queries in the DB and check their result.

      select vm_guid,vm_name,time_zone from vm_static;
      select vm_id,host_name,time_zone from vm_init;

9. Upgrade the engine's OS to RHEL 8.5 and the engine itself to 4.4.9-7.

10. Run the following queries in the DB and check their result.

    select vm_guid,vm_name,time_zone from vm_static;
    select vm_id,host_name,time_zone from vm_init;

11. Run the VMs and check that the time is set correctly (according to the timezones).


Results (As Expected):
1. The 4.6 data center and cluster were created.
2. The hosts were installed.
3. The NFS storage domain was added.
4. The VMs were created.
5. The templates were created.
6. The VM pools were created, with their VMs.
7. The VMs ran and the times and times zones are set to the correct values.
8. The results of the SQL queries were: 

engine=# select vm_guid,vm_name,time_zone from vm_static;
               vm_guid                |              vm_name              |           time_zone           
--------------------------------------+-----------------------------------+-------------------------------
 00000003-0003-0003-0003-0000000000be | Tiny                              | Etc/GMT
 00000005-0005-0005-0005-0000000002e6 | Small                             | Etc/GMT
 00000009-0009-0009-0009-0000000000f1 | Large                             | Etc/GMT
 0000000b-000b-000b-000b-00000000021f | XLarge                            | Etc/GMT
 00000007-0007-0007-0007-00000000010a | Medium                            | Etc/GMT
 6f0fa205-f375-4d5b-88a9-3ab2dc964fbc | Windows10Tim                      | Central European Standard Tim
 0b140864-1abd-4068-8495-190618dbc01f | Windows2019Seal                   | Central European Standard Tim
 6ad1d768-1f55-45b3-9b05-b7992ba51672 | WinTim2019                        | Central European Standard Tim
 e303fa1b-eded-433c-9373-29d77c1c0f4d | latest-rhel-guest-image-8.5-infra | Etc/GMT
 57810c1e-45d2-4821-9e09-40c36e55c6d2 | Win10TimSeal                      | Central European Standard Tim
 00000000-0000-0000-0000-000000000000 | Blank                             | 
 a45ee82f-6710-4088-939b-800895ae1a6e | RHEL8TimSeal                      | Europe/Warsaw
 c480ff67-484f-481f-96d8-0de8960641ff | WinTimTemplate                    | Central European Standard Tim
 6f621d5e-cb65-4b91-a3e7-085e24f85f66 | Windows10Tim                      | Central European Standard Tim
 46e06159-6c37-44e8-b15c-bc6c840bb93c | PoolSealedWin2019Tim-1            | Central European Standard Tim
 dee78294-a602-4a29-afa9-e7df277ca7f6 | Win10TimSeal                      | Central European Standard Tim
 13b1ed41-1255-44f3-886c-5d420b12e816 | SealedRhel8Tim                    | Europe/Warsaw
 f6147bab-12d9-495f-a662-c9b5ef7336ac | SealedTemp2019Tim                 | Central European Standard Tim
 5e09646f-36ed-4928-bde8-b1466f1b02d1 | PoolSealedWin10Tim-1              | Central European Standard Tim
 cead5e70-bde4-436f-94d7-e47f2c252370 | NoTimWin10                        | GMT Standard Time
 a355f092-d0f4-4891-a0f1-f8d00244e8b7 | RHEL8Tim                          | Europe/London
(21 rows)

engine=# select vm_id,host_name,time_zone from vm_init;
                vm_id                 |    host_name    |           time_zone           
--------------------------------------+-----------------+-------------------------------
 0b140864-1abd-4068-8495-190618dbc01f | Windows2019     | Central European Standard Tim
 f6147bab-12d9-495f-a662-c9b5ef7336ac | Windows2019     | Central European Standard Tim
 dee78294-a602-4a29-afa9-e7df277ca7f6 | Win10TimInstall | Central European Standard Tim
 c480ff67-484f-481f-96d8-0de8960641ff | WinTim2019      | Central European Standard Tim
 6f621d5e-cb65-4b91-a3e7-085e24f85f66 | Win10TimInstall | Central European Standard Tim
 6ad1d768-1f55-45b3-9b05-b7992ba51672 | WinTim2019      | Central European Standard Tim
 6f0fa205-f375-4d5b-88a9-3ab2dc964fbc | Win10TimInstall | Central European Standard Tim
 57810c1e-45d2-4821-9e09-40c36e55c6d2 | Win10TimInstall | Central European Standard Tim
 13b1ed41-1255-44f3-886c-5d420b12e816 | RHEL8Tim        | Europe/Warsaw
 46e06159-6c37-44e8-b15c-bc6c840bb93c | Windows2019     | Central European Standard Tim
 5e09646f-36ed-4928-bde8-b1466f1b02d1 | Win10TimInstall | Central European Standard Tim
 cead5e70-bde4-436f-94d7-e47f2c252370 | Win10TimInstall | GMT Standard Time
 a355f092-d0f4-4891-a0f1-f8d00244e8b7 | RHEL8Tim        | Europe/Warsaw
 a45ee82f-6710-4088-939b-800895ae1a6e | RHEL8Tim        | Europe/Warsaw
(14 rows)

9. The upgrade to 4.4.9-7 was successful. 
10. The results of the SQL queries were (as expected): 


engine=# select vm_guid,vm_name,time_zone from vm_static;
               vm_guid                |              vm_name              |           time_zone            
--------------------------------------+-----------------------------------+--------------------------------
 00000003-0003-0003-0003-0000000000be | Tiny                              | Etc/GMT
 00000005-0005-0005-0005-0000000002e6 | Small                             | Etc/GMT
 00000009-0009-0009-0009-0000000000f1 | Large                             | Etc/GMT
 0000000b-000b-000b-000b-00000000021f | XLarge                            | Etc/GMT
 00000007-0007-0007-0007-00000000010a | Medium                            | Etc/GMT
 e303fa1b-eded-433c-9373-29d77c1c0f4d | latest-rhel-guest-image-8.5-infra | Etc/GMT
 6f0fa205-f375-4d5b-88a9-3ab2dc964fbc | Windows10Tim                      | Central European Standard Time
 00000000-0000-0000-0000-000000000000 | Blank                             | 
 a45ee82f-6710-4088-939b-800895ae1a6e | RHEL8TimSeal                      | Europe/Warsaw
 13b1ed41-1255-44f3-886c-5d420b12e816 | SealedRhel8Tim                    | Europe/Warsaw
 0b140864-1abd-4068-8495-190618dbc01f | Windows2019Seal                   | Central European Standard Time
 f6147bab-12d9-495f-a662-c9b5ef7336ac | SealedTemp2019Tim                 | Central European Standard Time
 5e09646f-36ed-4928-bde8-b1466f1b02d1 | PoolSealedWin10Tim-1              | Central European Standard Time
 cead5e70-bde4-436f-94d7-e47f2c252370 | NoTimWin10                        | GMT Standard Time
 a355f092-d0f4-4891-a0f1-f8d00244e8b7 | RHEL8Tim                          | Europe/London
 6ad1d768-1f55-45b3-9b05-b7992ba51672 | WinTim2019                        | Central European Standard Time
 57810c1e-45d2-4821-9e09-40c36e55c6d2 | Win10TimSeal                      | Central European Standard Time
 c480ff67-484f-481f-96d8-0de8960641ff | WinTimTemplate                    | Central European Standard Time
 6f621d5e-cb65-4b91-a3e7-085e24f85f66 | Windows10Tim                      | Central European Standard Time
 46e06159-6c37-44e8-b15c-bc6c840bb93c | PoolSealedWin2019Tim-1            | Central European Standard Time
 dee78294-a602-4a29-afa9-e7df277ca7f6 | Win10TimSeal                      | Central European Standard Time
(21 rows)

engine=# select vm_id,host_name,time_zone from vm_init;
                vm_id                 |    host_name    |           time_zone            
--------------------------------------+-----------------+--------------------------------
 13b1ed41-1255-44f3-886c-5d420b12e816 | RHEL8Tim        | Europe/Warsaw
 cead5e70-bde4-436f-94d7-e47f2c252370 | Win10TimInstall | GMT Standard Time
 a355f092-d0f4-4891-a0f1-f8d00244e8b7 | RHEL8Tim        | Europe/Warsaw
 a45ee82f-6710-4088-939b-800895ae1a6e | RHEL8Tim        | Europe/Warsaw
 0b140864-1abd-4068-8495-190618dbc01f | Windows2019     | Central European Standard Time
 f6147bab-12d9-495f-a662-c9b5ef7336ac | Windows2019     | Central European Standard Time
 dee78294-a602-4a29-afa9-e7df277ca7f6 | Win10TimInstall | Central European Standard Time
 c480ff67-484f-481f-96d8-0de8960641ff | WinTim2019      | Central European Standard Time
 6f621d5e-cb65-4b91-a3e7-085e24f85f66 | Win10TimInstall | Central European Standard Time
 6ad1d768-1f55-45b3-9b05-b7992ba51672 | WinTim2019      | Central European Standard Time
 6f0fa205-f375-4d5b-88a9-3ab2dc964fbc | Win10TimInstall | Central European Standard Time
 57810c1e-45d2-4821-9e09-40c36e55c6d2 | Win10TimInstall | Central European Standard Time
 46e06159-6c37-44e8-b15c-bc6c840bb93c | Windows2019     | Central European Standard Time
 5e09646f-36ed-4928-bde8-b1466f1b02d1 | Win10TimInstall | Central European Standard Time
(14 rows)

11. The VMs run, their time zones and time is set correctly (according to the timezones).

Comment 14 errata-xmlrpc 2021-11-16 13:54:29 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 (0-day RHV Manager (ovirt-engine) [ovirt-4.4.9]), 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-2021:4699

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