計(jì)算節(jié)點(diǎn)實(shí)際資源還有阶捆，但是創(chuàng)建虛擬機(jī)失敗報(bào)錯(cuò)沒(méi)有資源
**項(xiàng)目用的 Q版本双肤，由于 O杉适、P、Q 版本的 OpenStack 有BUG
nova_api.allocations 表的記錄信息和 nova.instances 表關(guān)于記錄資源的信息不同步造成的
- 查找計(jì)算節(jié)點(diǎn)的 對(duì)應(yīng)的 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.通過(guò) resource_provider_id 查找每個(gè)計(jì)算節(jié)點(diǎn)分配的資源
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)
- 查找現(xiàn)在 openstack nova.instances 運(yùn)行的的實(shí)際虛擬機(jī) （暫不考慮 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 表為準(zhǔn)鸟辅，刪除 nova_api.allocations 表中多余的記錄
delete from nova_api.allocations where consumer_id='$consumer_id' and resource_provider_id=$resource_provider_id;
