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

admin

、进数据查看数据库表
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 |
/ l( ?1 h4 |$ W0 p! E! L: B+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
' [: b$ i7 q4 c+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
1 row in set (0.00 sec)

发现有数据。重新创建虚拟机，依然会发生报错，

、尝试将compute节点从nova service-list中删除，并重新加入到集群中
# 停掉compute节点的nova-compute 服务
% f/ ~/ _+ n; V' Tnova service-delete <计算节点的uuid>

# 开启计算节点的nova-compute服务，让计算节点重新注册
1 {) Y1 z3 e5 H+ R/ x尝试创建虚拟机，发现还是报错。返回去，查看nova-compute的日志发现 There was a conflict when trying to complete your request.\n\n Conflicting resource provider name: compute1 already exists. 。提示矛盾。
) J" R! A( g) J4 V, r
; p' f/ i( M0 |、再次进入数据库，执行 select * from resource_providers;
, T6 k0 P" f) _5 m1 F$ Amysql> use nova_api;
mysql[nova_api] >  select * from resource_providers;
8 U* T  t2 R; D+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
1 t7 K% e* E2 g; x+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
4 t/ ]% A' b" b- X3 O8 E% v1 row in set (0.00 sec)
/ N: r. D0 o  S1 z# `; B发现新注册的计算节点，但是resource_providers的uuid 没有发生变化，怀疑是注册compute节点的时候，并没有更新resource_providers，尝试删除resource_providers;

6 U3 J7 V" l% Z1 _; L  G" z
最主要时因为注册出了问题。解决注册的问题即可。
, ]/ G5 r% M' ?1 }5 B