nova no valid host was found

计算节点实际资源还有，但是创建虚拟机失败报错没有资源

**项目用的 Q版本，由于 O、P、Q 版本的 OpenStack 有BUG

nova_api.allocations 表的记录信息和 nova.instances 表关于记录资源的信息不同步造成的

1. 查找计算节点的 对应的 parent_provider_id

MariaDB [nova_api]>  select * from resource_providers;
+---------------------+---------------------+----+--------------------------------------+--------------+------------+----------+------------------+--------------------+
| created_at          | updated_at          | id | uuid                                 | name         | generation | can_host | root_provider_id | parent_provider_id |
+---------------------+---------------------+----+--------------------------------------+--------------+------------+----------+------------------+--------------------+
| 2019-06-06 03:12:25 | 2019-11-20 11:47:59 |  4 | d083af9b-b807-40ce-9e4a-33e5c25297cd | jitstack0002 |        173 |     NULL |                4 |               NULL |
| 2019-06-06 03:12:26 | 2019-11-20 11:49:52 |  7 | 065ae8bf-8297-4df3-9361-34943f1fca4a | jitstack0003 |         71 |     NULL |                7 |               NULL |
| 2019-06-06 03:12:28 | 2019-08-02 08:17:35 | 10 | fd7f516f-4fb9-40c2-9634-94188456a7f9 | jitstack0001 |        201 |     NULL |               10 |               NULL |
+---------------------+---------------------+----+--------------------------------------+--------------+------------+----------+------------------+--------------------+
3 rows in set (0.00 sec)

2.通过 resource_provider_id 查找每个计算节点分配的资源

MariaDB [nova_api]>  select * from nova_api.allocations where resource_provider_id=7;;
+---------------------+------------+------+----------------------+--------------------------------------+-------------------+-------+
| created_at          | updated_at | id   | resource_provider_id | consumer_id                          | resource_class_id | used  |
+---------------------+------------+------+----------------------+--------------------------------------+-------------------+-------+
| 2019-08-19 05:15:00 | NULL       | 1426 |                    7 | aebbb013-21d1-4bf3-bd94-e91735db7125 |                 0 |     4 |
| 2019-08-23 09:10:59 | NULL       | 1436 |                    7 | 1a7f895b-15bd-4e59-868f-19f7a51becd0 |                 0 |     4 |
| 2019-08-23 09:11:02 | NULL       | 1438 |                    7 | de533a1d-e691-4c61-bd08-3b64d352e1d5 |                 0 |     4 |
| 2019-11-04 08:00:25 | NULL       | 1460 |                    7 | f216f940-a6d7-4f7a-8e8a-b37c7295d768 |                 0 |     4 |
| 2019-06-20 03:24:09 | NULL       |  581 |                    7 | ddd4a5b0-6432-4d57-af8f-8de1c350327e |                 0 |     8 |
| 2019-07-11 03:53:35 | NULL       |  713 |                    7 | 152ee0b0-4030-400f-82e1-20e3eef68e10 |                 0 |     8 |
| 2019-08-15 09:44:22 | NULL       | 1402 |                    7 | d73af926-c8fc-433c-8b00-445d29f43722 |                 0 |     8 |
| 2019-08-16 05:48:07 | NULL       | 1416 |                    7 | 3f6240fb-a022-453f-925c-71aabffbf36c |                 0 |     8 |
| 2019-08-16 05:48:15 | NULL       | 1420 |                    7 | 848b12d2-95b3-4a6f-b303-ea0549f38ff5 |                 0 |     8 |
| 2019-08-16 06:09:49 | NULL       | 1422 |                    7 | 8e1ec578-e690-486c-8ee3-4324a9ec8ec3 |                 0 |     8 |
| 2019-11-20 11:49:52 | NULL       | 1510 |                    7 | 5d5a4ce4-2e65-4783-b42d-65bc7f2cd9d5 |                 0 |     8 |
| 2019-08-19 05:15:00 | NULL       | 1427 |                    7 | aebbb013-21d1-4bf3-bd94-e91735db7125 |                 1 |  4096 |
| 2019-08-23 09:10:59 | NULL       | 1437 |                    7 | 1a7f895b-15bd-4e59-868f-19f7a51becd0 |                 1 |  4096 |
| 2019-08-23 09:11:02 | NULL       | 1439 |                    7 | de533a1d-e691-4c61-bd08-3b64d352e1d5 |                 1 |  4096 |
| 2019-11-20 11:49:52 | NULL       | 1511 |                    7 | 5d5a4ce4-2e65-4783-b42d-65bc7f2cd9d5 |                 1 |  4096 |
| 2019-11-04 08:00:25 | NULL       | 1461 |                    7 | f216f940-a6d7-4f7a-8e8a-b37c7295d768 |                 1 |  8192 |
| 2019-06-20 03:24:09 | NULL       |  583 |                    7 | ddd4a5b0-6432-4d57-af8f-8de1c350327e |                 1 | 16384 |
| 2019-08-15 09:44:22 | NULL       | 1403 |                    7 | d73af926-c8fc-433c-8b00-445d29f43722 |                 1 | 16384 |
| 2019-08-16 05:48:07 | NULL       | 1417 |                    7 | 3f6240fb-a022-453f-925c-71aabffbf36c |                 1 | 32768 |
| 2019-08-16 05:48:15 | NULL       | 1421 |                    7 | 848b12d2-95b3-4a6f-b303-ea0549f38ff5 |                 1 | 32768 |
| 2019-08-16 06:09:49 | NULL       | 1423 |                    7 | 8e1ec578-e690-486c-8ee3-4324a9ec8ec3 |                 1 | 32768 |
| 2019-07-11 03:53:35 | NULL       |  715 |                    7 | 152ee0b0-4030-400f-82e1-20e3eef68e10 |                 1 | 65536 |
+---------------------+------------+------+----------------------+--------------------------------------+-------------------+-------+
22 rows in set (0.00 sec)

3. 查找现在 openstack nova.instances 运行的的实际虚拟机 （暂不考虑 KVM 和 OpenStack 不同步情况）

MariaDB [nova_api]> select uuid from nova.instances where deleted=0 and node='compute0001';
+--------------------------------------+
| uuid                                 |
+--------------------------------------+
| 1625ce70-5745-4b3b-87bf-6d590144d824 |
| ea68349f-d00b-41bb-9573-9610ca8392ad |
| 2b3d6dfa-893b-47cc-a9f2-727b54827b40 |
| a1aa8ae2-dc1e-45c1-866b-5f250dfe6922 |
| 878fd818-f22f-488d-9a26-27c58fef9e04 |
| 08a0bc35-90ae-496b-889c-6d9261573fef |
| 446d9d2c-629e-40bc-a8b2-74f4d01643fc |
| f1d94dd7-7f25-43a4-b4e6-40f76a8ed3ec |
| caafea14-2388-463d-96fe-a55a7327a0ad |
+--------------------------------------+
9 rows in set (0.00 sec)

4.按照 nova.instances 表为准，删除 nova_api.allocations 表中多余的记录

delete from nova_api.allocations where consumer_id='$consumer_id' and resource_provider_id=$resource_provider_id;