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

admin

、进数据查看数据库表
1 ^7 `, g% |7 U0 B; A7 Omysql> use nova_api;
  s( M1 P4 I& E: ymysql[nova_api] >  select * from resource_providers;
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
5 l* ^8 H& a+ J' Z| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
! Y' k. P1 W% X- 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)
5 W" x+ i5 b  V; e4 B
发现有数据。重新创建虚拟机，依然会发生报错，
9 R4 v5 e2 M, K
、尝试将compute节点从nova service-list中删除，并重新加入到集群中
# 停掉compute节点的nova-compute 服务
nova service-delete <计算节点的uuid>
! Q/ Q* T- @: O$ d. F
" G$ c4 `0 I& y' l# 开启计算节点的nova-compute服务，让计算节点重新注册
) W! M+ @2 Y! c! N+ q1 C尝试创建虚拟机，发现还是报错。返回去，查看nova-compute的日志发现 There was a conflict when trying to complete your request.\n\n Conflicting resource provider name: compute1 already exists. 。提示矛盾。
6 t4 X  P/ A1 j! r$ V( U# v7 O
- M( d& _4 _0 t、再次进入数据库，执行 select * from resource_providers;
mysql> use nova_api;
mysql[nova_api] >  select * from resource_providers;
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
: ~/ x9 v4 t% f1 W| created_at          | updated_at          | id | uuid                                 | name     | generation | can_host | root_provider_id | parent_provider_id |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
| 2019-11-21 06:17:39 | 2019-11-21 06:17:41 |  3 | 16d1bd53-7919-4fef-9a11-a0e98c149823 | compute1 |          1 |     NULL |                3 |               NULL |
+---------------------+---------------------+----+--------------------------------------+----------+------------+----------+------------------+--------------------+
; B  ~1 O8 `8 i3 H. {% \1 row in set (0.00 sec)
0 U& Y' B9 f- j/ E6 y* _发现新注册的计算节点，但是resource_providers的uuid 没有发生变化，怀疑是注册compute节点的时候，并没有更新resource_providers，尝试删除resource_providers;


最主要时因为注册出了问题。解决注册的问题即可。

( {- z0 Z; Y- R! g5 Y6 I