Bug 1000034 - [Admin Portal] Cannot update VM properties - Field timeZone can not be updated when status is Up
Summary: [Admin Portal] Cannot update VM properties - Field timeZone can not be update...
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: Red Hat Enterprise Virtualization Manager
Classification: Red Hat
Component: ovirt-engine-webadmin-portal
Version: 3.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
urgent
Target Milestone: ---
: 3.2.4
Assignee: Martin Betak
QA Contact: Pavel Novotny
URL:
Whiteboard: virt
Depends On: 988259
Blocks: 974985 987906
TreeView+ depends on / blocked
 
Reported: 2013-08-22 14:23 UTC by Chris Pelland
Modified: 2018-12-03 19:44 UTC (History)
10 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Older versions of the Manager set the virtual machine's default time zone to an empty string, but this field is now set to a null value. This update adds a database migration script to handle this change, so users can update the time zone on running virtual machines.
Clone Of: 988259
Environment:
Last Closed: 2013-10-25 18:43:10 UTC
oVirt Team: ---
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1002616 0 high CLOSED Can not change any properties in running Linux VMs imported from RHEV 2.2 2021-02-22 00:41:40 UTC
Red Hat Knowledge Base (Solution) 465813 0 None None None Never
Red Hat Product Errata RHBA-2013:1468 0 normal SHIPPED_LIVE rhevm bug fix update 2013-10-25 22:42:24 UTC
oVirt gerrit 17524 0 None MERGED engine: Incorrect VM TimeZone handling 2020-09-28 10:05:01 UTC
oVirt gerrit 17672 0 None MERGED core: Normalize default VM time zone representation 2020-09-28 10:05:01 UTC

Internal Links: 1002616

Comment 4 Pavel Novotny 2013-10-16 15:26:05 UTC
Verified in rhevm-3.2.4-0.44.el6ev.noarch (sf21).

Verification steps:
1) In older RHEVM 3.2 (3.2.0 aka sf17.5 in this case) create new VM with Windows OS type.
2) In DB, simulate the old behavior via seting the time_zone to empty string :
{{{
# psql -U engine engine
engine=> \pset null <NULL>
engine=> UPDATE vm_static SET time_zone = '' where vm_name = 'my-win7-sf17_5';
UPDATE 1
engine=> SELECT vm_guid, vm_name, time_zone from vm_static;
               vm_guid                |    vm_name     | time_zone 
--------------------------------------+----------------+-----------
 00000000-0000-0000-0000-000000000000 | Blank          | <NULL>
 993f9143-1a45-4f69-a739-34be9f62f049 | my-win7        | 
}}}
3) Run the VM in webadmin and try to edit for example the description -> you should get an error pop-up. Stop the VM.
4) Upgrade to RHEVM 3.2.4 (sf21)
5) Repeat step 3 -> now it should be possible to change the description.
6) Check the time_zone value in DB:
{{{
# psql -U engine engine
engine=> \pset null <NULL>
engine=> SELECT vm_guid, vm_name, time_zone from vm_static;
               vm_guid                |    vm_name     | time_zone 
--------------------------------------+----------------+-----------
 00000000-0000-0000-0000-000000000000 | Blank          | <NULL>
 993f9143-1a45-4f69-a739-34be9f62f049 | my-win7        | <NULL>
}}}

Comment 6 errata-xmlrpc 2013-10-25 18:43:10 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.

http://rhn.redhat.com/errata/RHBA-2013-1468.html


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