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

admin

、进数据查看数据库表
8 p7 {% ^: P# N* y: L3 wmysql> use nova_api;
& G5 g! c# B9 e& a- pmysql[nova_api] >  select * from resource_providers;
: V$ A# O" ^) c  r' M! l& w+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
  q, G6 W" O9 K8 D5 I2 x| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
( ^: G2 d, A$ c2 w- ?| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
1 row in set (0.00 sec)
7 A3 P0 O$ e; J! B
4 u! a9 ^2 D; W0 t6 v发现有数据。重新创建虚拟机，依然会发生报错，

% p' h5 w$ `" o、尝试将compute节点从nova service-list中删除，并重新加入到集群中
# 停掉compute节点的nova-compute 服务
* ~" I( G1 P+ W; c9 {/ g% w+ snova service-delete <计算节点的uuid>
' J/ Z! {7 `9 w, ^) \
, w2 h# h' z9 g; j3 q# 开启计算节点的nova-compute服务，让计算节点重新注册
尝试创建虚拟机，发现还是报错。返回去，查看nova-compute的日志发现 There was a conflict when trying to complete your request.\n\n Conflicting resource provider name: compute1 already exists. 。提示矛盾。
0 ], ?2 x! {/ H' N" ^. n  f# z
8 U: p: j1 ~; f# W、再次进入数据库，执行 select * from resource_providers;
mysql> use nova_api;
mysql[nova_api] >  select * from resource_providers;
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
3 d' [" f& A' o5 T& c  U| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
, V5 c! g1 e* [5 V+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
5 W4 o; X& E% }( N9 _, X) t( O" P1 row in set (0.00 sec)
: n$ t& {" v2 l6 p' M- t' b. f发现新注册的计算节点，但是resource_providers的uuid 没有发生变化，怀疑是注册compute节点的时候，并没有更新resource_providers，尝试删除resource_providers;
0 g9 y4 [. b3 f2 l$ B

! Y& O9 x9 m7 g% J5 R! C( B最主要时因为注册出了问题。解决注册的问题即可。
2 ~7 J& ^/ g0 ?% ]0 F
( ?8 M( J/ N2 k! @" g  k( p