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

admin

、进数据查看数据库表
( X* Q: f% @5 @4 U* `mysql> use nova_api;
mysql[nova_api] >  select * from resource_providers;
- Y( ~' H4 p& l% }+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
; J6 x. L7 D  U4 y| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
) s" G0 ^! R) e; J1 h6 x1 row in set (0.00 sec)
" C$ P0 J! @6 `
发现有数据。重新创建虚拟机，依然会发生报错，

+ O4 N( h9 [* \1 z( ~、尝试将compute节点从nova service-list中删除，并重新加入到集群中
" Y+ l8 Z, d) y% a, C$ b# 停掉compute节点的nova-compute 服务
nova 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. 。提示矛盾。

4 Q  [9 |7 m+ q& q! d8 P; d、再次进入数据库，执行 select * from resource_providers;
* d9 m1 x8 a. H# h2 W% @5 o; Jmysql> use nova_api;
; i; i$ x. N$ e! z/ q6 Umysql[nova_api] >  select * from resource_providers;
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
3 o' }% W4 _7 T+ C! `| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
2 R" i) f5 v' O. a* L& y+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
1 E. ?# Q" k4 {& U/ |- }+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
' S) H. {5 t, o1 `1 row in set (0.00 sec)
9 Z, p; p7 N$ E发现新注册的计算节点，但是resource_providers的uuid 没有发生变化，怀疑是注册compute节点的时候，并没有更新resource_providers，尝试删除resource_providers;
* c4 ?) {  H3 e( f# f3 J0 X8 \+ e

( j) C" i3 ]- n9 t3 g最主要时因为注册出了问题。解决注册的问题即可。
4 L) T' u; M  _% r+ l- E
" {- K( C# |2 ^: K1 s5 @# N# x