In my OpenStack Rocky cloud I have some instances that were created (before updating to Rocky) using images with the property hypervisor_type='qemu'.

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: http://lists.openstack.org/pipermail/openstack-discuss/2019-July/thread.html#7842

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.

As suggested by Matt I tried to play with the  instance_system_metadata table of the nova database.

I first tried to change the value of that property (qemu --> kvm) [*]

I also tried to remove the property [**] but the nova migrate keeps failing. In the request I keep seeing that 

Instance contains properties ImageMetaProps...img_hv_type='qemu'

What else needs to be modified?

Thanks, Massimo

[*]

mysql> select * from instance_system_metadata where instance_uuid='57dcdc2f-ef30-4512-beff-128c1621c5c6';
+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+
| created_at          | updated_at | deleted_at | id      | instance_uuid                        | key                    | value                                | deleted |
+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868217 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_hypervisor_type  | kvm                                  |       0 |
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868220 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_disk_format      | qcow2                                |       0 |
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868223 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_container_format | bare                                 |       0 |
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868226 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_min_ram          | 512                                  |       0 |
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868229 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_min_disk         | 20                                   |       0 |
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868232 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_base_image_ref   | c2d3e37c-b14f-4472-9bc2-d75f26ab900d |       0 |
+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+

[**]

mysql> delete from instance_system_metadata where id='9868217';
Query OK, 1 row affected (0.01 sec)

mysql> select * from instance_system_metadata where instance_uuid='57dcdc2f-ef30-4512-beff-128c1621c5c6';
+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+
| created_at          | updated_at | deleted_at | id      | instance_uuid                        | key                    | value                                | deleted |
+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868220 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_disk_format      | qcow2                                |       0 |
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868223 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_container_format | bare                                 |       0 |
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868226 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_min_ram          | 512                                  |       0 |
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868229 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_min_disk         | 20                                   |       0 |
| 2017-05-15 12:32:57 | NULL       | NULL       | 9868232 | 57dcdc2f-ef30-4512-beff-128c1621c5c6 | image_base_image_ref   | c2d3e37c-b14f-4472-9bc2-d75f26ab900d |       0 |
+---------------------+------------+------------+---------+--------------------------------------+------------------------+--------------------------------------+---------+
5 rows in set (0.00 sec)