Comment 5 for bug 1757207

Shouldn't the upgrade check simply discount deleted compute_nodes ?

+-----------------------------------------------------------------------+
| Check: Resource Providers |
| Result: Warning |
| Details: There are 34 compute resource providers and 40 compute nodes |
| in the deployment. Ideally the number of compute resource |
| providers should equal the number of enabled compute nodes |
| otherwise the cloud may be underutilized. See |
| https://docs.openstack.org/nova/latest/user/placement.html |
| for more details. |
+-----------------------------------------------------------------------+

mysql> select count(*) from compute_nodes;
+----------+
| count(*) |
+----------+
| 40 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from compute_nodes where deleted=0;
+----------+
| count(*) |
+----------+
| 34 |
+----------+
1 row in set (0.00 sec)