<div dir="ltr"><div>In my OpenStack Rocky cloud I have some instances that were created (before updating to Rocky) using images with the property hypervisor_type='qemu'.</div><div><br></div><div>Since in my compute nodes  [libvirt]/virt_type is "kvm", after having updated to Rocky I had to change these images removing that property of changing its value (qemu --> kvm): this is discussed in the thread: <a href="http://lists.openstack.org/pipermail/openstack-discuss/2019-July/thread.html#7842">http://lists.openstack.org/pipermail/openstack-discuss/2019-July/thread.html#7842</a></div><div><br></div><div>Now I am not able to migrate anymore the instances that were created using those images (ImagePropertiesFilter filters out all compute nodes) before fixing the property.</div><div><br></div><div>As suggested by Matt I tried to play with the  instance_system_metadata table of the nova database.</div><div><br></div><div>I first tried to change the value of that property (qemu --> kvm) [*]</div><div>I also tried to remove the property [**] but the nova migrate keeps failing. In the request I keep seeing that </div><div><br></div><div>Instance contains properties ImageMetaProps...img_hv_type='qemu'</div><div><br></div><div>What else needs to be modified?</div><div><br></div><div>Thanks, Massimo</div><div><br></div><div>[*]</div><div>mysql> select * from instance_system_metadata where instance_uuid='57dcdc2f-ef30-4512-beff-128c1621c5c6';<br>+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+<br>| created_at          | updated_at | deleted_at | id      | instance_uuid                        | key                    | value                                | deleted |<br>+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868217 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_hypervisor_type  | kvm                                  |       0 |<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868220 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_disk_format      | qcow2                                |       0 |<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868223 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_container_format | bare                                 |       0 |<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868226 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_min_ram          | 512                                  |       0 |<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868229 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_min_disk         | 20                                   |       0 |<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868232 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_base_image_ref   | c2d3e37c-b14f-4472-9bc2-d75f26ab900d |       0 |<br>+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+<br></div><div><br></div><div><br></div><div>[**]</div><div>mysql> delete from instance_system_metadata where id='9868217';<br>Query OK, 1 row affected (0.01 sec)<br><br>mysql> select * from instance_system_metadata where instance_uuid='57dcdc2f-ef30-4512-beff-128c1621c5c6';<br>+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+<br>| created_at          | updated_at | deleted_at | id      | instance_uuid                        | key                    | value                                | deleted |<br>+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868220 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_disk_format      | qcow2                                |       0 |<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868223 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_container_format | bare                                 |       0 |<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868226 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_min_ram          | 512                                  |       0 |<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868229 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_min_disk         | 20                                   |       0 |<br>| 2017-05-15 12:32:57 | NULL       | NULL       | 9868232 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_base_image_ref   | c2d3e37c-b14f-4472-9bc2-d75f26ab900d |       0 |<br>+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+<br>5 rows in set (0.00 sec)<br></div></div>