search

ClusterLabs / anvil

The Anvil! Intelligent Availability™ Platform, mark 3
5 stars 6 forks source link

Sum of the free space on subnodes shows as total space in node tile #508

Closed digimer closed 9 months ago

digimer commented 10 months ago

In this case, the 'an-anvil-02' node has 250GiB disks, but 500 GiB is shown.

image

digimer commented 10 months ago 
anvil=# SELECT a.host_name, b.scan_lvm_vg_name, pg_size_pretty(b.scan_lvm_vg_size) AS size, pg_size_pretty(b.scan_lvm_vg_free) AS free FROM hosts a, scan_lvm_vgs b WHERE b.scan_lvm_vg_host_uuid = a.host_uuid AND a.host_name LIKE 'an-a02%' ORDER BY a.host_name ASC, b.scan_lvm_vg_name ASC;
       host_name       | scan_lvm_vg_name |  size  |  free  
-----------------------+------------------+--------+--------
 an-a02n01.alteeve.com | rhel_vm-a02n01   | 249 GB | 171 GB
 an-a02n02.alteeve.com | rhel_vm-a02n02   | 249 GB | 171 GB
(2 rows)