Tomas Jelinek has uploaded a new change for review.

Change subject: core: medium Instance Type mismatch feature page
......................................................................

core: medium Instance Type mismatch feature page

According to feature page, in medium instance type, total virtual CPUs should
be 2, but it is 1.

Fixed by updating this property in the DB. The update statement tries to be as
specific about the instance type as possible, but since it is not possible to
use it's ID which was generated, it relyes on the name/description + some
configuration.

Change-Id: I03407f86c272578cec671f49e89d2ffbeb93ae4d
Bug-Url: https://bugzilla.redhat.com/1142924
Signed-off-by: Tomas Jelinek <tjeli...@redhat.com>
---
A packaging/dbscripts/upgrade/03_05_1120_medium_instance_type_has_two_cpus.sql
1 file changed, 20 insertions(+), 0 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/95/34495/1

diff --git 
a/packaging/dbscripts/upgrade/03_05_1120_medium_instance_type_has_two_cpus.sql 
b/packaging/dbscripts/upgrade/03_05_1120_medium_instance_type_has_two_cpus.sql
new file mode 100644
index 0000000..f58d6cb
--- /dev/null
+++ 
b/packaging/dbscripts/upgrade/03_05_1120_medium_instance_type_has_two_cpus.sql
@@ -0,0 +1,20 @@
+-- update the VMs based on that instance type
+update vm_static set num_of_sockets = 2 where
+    instance_type_id in (
+        select vm_guid from vm_static where entity_type = 'INSTANCE_TYPE' and
+            vm_name = 'Medium' and
+            description = 'Medium instance type' and
+            mem_size_mb = 4096 and
+            num_of_sockets = 1 and
+            cpu_per_socket = 1
+    )
+    or
+    vm_guid in (
+        select vm_guid from vm_static
+            where entity_type = 'INSTANCE_TYPE' and
+            vm_name = 'Medium' and
+            description = 'Medium instance type' and
+            mem_size_mb = 4096 and
+            num_of_sockets = 1 and
+            cpu_per_socket = 1
+    );


-- 
To view, visit http://gerrit.ovirt.org/34495
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I03407f86c272578cec671f49e89d2ffbeb93ae4d
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: ovirt-engine-3.5
Gerrit-Owner: Tomas Jelinek <tjeli...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to