Open Stack

Hi, experts,

XenServer CI failed frequently with an error "No valid host was found. " for more than a week. I think it is cause by placement update.
It looks ` _get_provider_ids_matching ` return empty when allocate candidates, but filter statements looks good(vcpu/memory/disk):

coalesce(usage_vcpu.used, :coalesce_1) + :coalesce_2 <= (inv_vcpu.total - inv_vcpu.reserved) * inv_vcpu.allocation_ratio AND inv_vcpu.min_unit <= :min_unit_1 AND inv_vcpu.max_unit >= :max_unit_1 AND :step_size_1 % inv_vcpu.step_size = :param_1, coalesce(usage_memory_mb.used, :coalesce_1) + :coalesce_2 <= (inv_memory_mb.total - inv_memory_mb.reserved) * inv_memory_mb.allocation_ratio AND inv_memory_mb.min_unit <= :min_unit_1 AND inv_memory_mb.max_unit >= :max_unit_1 AND :step_size_1 % inv_memory_mb.step_size = :param_1, coalesce(usage_disk_gb.used, :coalesce_1) + :coalesce_2 <= (inv_disk_gb.total - inv_disk_gb.reserved) * inv_disk_gb.allocation_ratio AND inv_disk_gb.min_unit <= :min_unit_1 AND inv_disk_gb.max_unit >= :max_unit_1 AND :step_size_1 % inv_disk_gb.step_size = :param_1

Also, database looks good:
mysql> select * from inventories;
+---------------------+---------------------+----+----------------------+-------------------+-------+----------+----------+----------+-----------+------------------+
| created_at          | updated_at          | id | resource_provider_id | resource_class_id | total | reserved | min_unit | max_unit | step_size | allocation_ratio |
+---------------------+---------------------+----+----------------------+-------------------+-------+----------+----------+----------+-----------+------------------+
| 2018-08-27 10:14:12 | 2018-08-27 10:16:11 |  1 |                    1 |                 0 |    24 |        0 |        1 |       24 |         1 |                0 |
| 2018-08-27 10:14:12 | 2018-08-27 10:16:11 |  2 |                    1 |                 1 | 98293 |      512 |        1 |    98293 |         1 |                0 |
| 2018-08-27 10:14:12 | 2018-08-27 10:16:11 |  3 |                    1 |                 2 |   450 |        0 |        1 |      450 |         1 |                2 |
+---------------------+---------------------+----+----------------------+-------------------+-------+----------+----------+----------+-----------+------------------+
3 rows in set (0.00 sec)

mysql> select * from resource_providers;
+---------------------+---------------------+----+--------------------------------------+--------------+------------+----------+------------------+--------------------+
| created_at          | updated_at          | id | uuid                                 | name         | generation | can_host | root_provider_id | parent_provider_id |
+---------------------+---------------------+----+--------------------------------------+--------------+------------+----------+------------------+--------------------+
| 2018-08-27 10:14:11 | 2018-08-27 10:16:11 |  1 | cb831119-c68f-47ac-92ba-0f19c1a56b31 | xrtmia-03-11 |          2 |     NULL |                1 |               NULL |
+---------------------+---------------------+----+--------------------------------------+--------------+------------+----------+------------------+--------------------+
1 row in set (0.00 sec)
It is a alo environment deployed by devstack.
Anyone has some suggestions about that?
Thank you very much.

BR.
Naichuan Sun

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20180828/1d0c2324/attachment.html>