No valid host was found. There are not enough hosts available---openstack建虚拟机报错

admin

、进数据查看数据库表
mysql> use nova_api;
2 _4 H3 [; u) Q. d8 ]8 V7 ?mysql[nova_api] >  select * from resource_providers;
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
* ~) {) ]" d7 f7 i9 [| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
& D7 {8 Y  E/ K3 ]& q! ]+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
1 row in set (0.00 sec)

+ f; g" x, v: B发现有数据。重新创建虚拟机，依然会发生报错，

0 L2 t5 q9 G& X、尝试将compute节点从nova service-list中删除，并重新加入到集群中
2 ?* \. n5 m7 S. m$ Q; i( E# 停掉compute节点的nova-compute 服务
0 z# E$ Z" ~5 R! v: P$ `: j- wnova service-delete <计算节点的uuid>

# 开启计算节点的nova-compute服务，让计算节点重新注册
尝试创建虚拟机，发现还是报错。返回去，查看nova-compute的日志发现 There was a conflict when trying to complete your request.\n\n Conflicting resource provider name: compute1 already exists. 。提示矛盾。
% ~% z+ W' f4 s1 u+ n) c
、再次进入数据库，执行 select * from resource_providers;
mysql> use nova_api;
( {" C0 Y+ T- ^2 L6 c1 q5 Mmysql[nova_api] >  select * from resource_providers;
9 x; a) R0 Y3 s( q1 t  D: I+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
7 t1 M" k7 G7 I7 e3 y2 \5 M| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
# z$ r# w& x. [0 _& I; U. e2 a+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
* B1 J8 |# E  Y$ S5 U0 B& D2 U| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
7 [; z4 m$ {; I1 Z* f. q# h' y0 A+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
1 row in set (0.00 sec)
发现新注册的计算节点，但是resource_providers的uuid 没有发生变化，怀疑是注册compute节点的时候，并没有更新resource_providers，尝试删除resource_providers;

7 r% x+ `1 x! ^. v
最主要时因为注册出了问题。解决注册的问题即可。