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

admin

、进数据查看数据库表
( a+ T3 P* K# `5 F7 J* k5 \mysql> use nova_api;
# t8 Y( D. r, |# K! T7 b! rmysql[nova_api] >  select * from resource_providers;
; c' W' A: k6 ?8 o9 Q5 a+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
; K2 R" Y2 u0 Y  \' H| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
6 t& u6 U7 [, b  W0 H8 M6 C+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
1 row in set (0.00 sec)

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

、尝试将compute节点从nova service-list中删除，并重新加入到集群中
# 停掉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. 。提示矛盾。
& l, m+ e' V8 X+ N5 ?
) T9 \" _% v  u  S  `1 G、再次进入数据库，执行 select * from resource_providers;
mysql> use nova_api;
mysql[nova_api] >  select * from resource_providers;
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
+ A6 G( d- b1 ~- O  N. ]  t| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
2 M& |8 W/ E5 O, D0 v  C9 s/ N+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
2 N5 k, C% B3 r+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
1 row in set (0.00 sec)
发现新注册的计算节点，但是resource_providers的uuid 没有发生变化，怀疑是注册compute节点的时候，并没有更新resource_providers，尝试删除resource_providers;


* t' r3 m  G3 u( \, R  a+ x2 L3 b最主要时因为注册出了问题。解决注册的问题即可。
" V2 G" u) m, v  p