Here's our environment,
1. Primary Storage is 12TB
2. Actual allocated capacity of primary storage 14.17 TB
3. Storage.overprovisiong.factor is set '2'
The primary storage utilization ratio is supposed to be 59.6% ,
14.17/(12*2), which is correctly displayed in 4.4.3.
------------------------------------------------------------------------------------------------
The issue ONLY occurs while we upgrade ACS 4.4.3 to 4.5.1.
The primary storage utilization ratio at 'System Capacity' section of
dashboard shows 94%, even though ACS has fetched the actual used
storage/total storage(14.17TB / 23.76TB) correctly.
So far, this issue doesn't prevent us to create new VM, but annoying on UI.
Please keep you eyes on capacity display of primary storage allocated
(type=3) ,and we don't know what make it's difference.
Here's some debug information to help you guys find it out:
======= 'System Capacity' section of dashboard (primary storage allocated
is 96.01%)========
API：
listCapacity&response=json&sortBy=usage&page=0&pageSize=8
API-respones：
{"listcapacityresponse":{"count":9,"capacity":[
{"type":3,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":15637975924736,"capacitytotal":26129769431040,"percentused":"96.01"}
,
{"type":4,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":18,"capacitytotal":26,"percentused":"69.23"}
,
{"type":6,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":418504507392,"capacitytotal":1056889110528,"percentused":"39.6"}
,
{"type":0,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":185365336064,"capacitytotal":540684636160,"percentused":"34.28"}
,
{"type":5,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":16,"capacitytotal":50,"percentused":"32"}
,
{"type":1,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":257030,"capacitytotal":960240,"percentused":"26.77"}
,
{"type":9,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":1934966477312,"capacitytotal":32927719010304,"percentused":"5.88"}
,
{"type":8,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":13,"capacitytotal":233,"percentused":"5.58"}
,
{"type":19,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":0,"capacitytotal":0,"percentused":"0"}
]}}
SQL：
SELECT sum(capacity.used_capacity), sum(capacity.reserved_capacity), (case
capacity_type when 1 then (sum(total_capacity) * (select value from
`cloud`.`cluster_details` where cluster_details.name= 'cpuOvercommitRatio'
AND cluster_details.cluster_id=capacity.cluster_id))when '0' then
(sum(total_capacity) * (select value from `cloud`.`cluster_details` where
cluster_details.name= 'memoryOvercommitRatio' AND
cluster_details.cluster_id=capacity.cluster_id))else sum(total_capacity)
end),((sum(capacity.used_capacity) + sum(capacity.reserved_capacity)) / (
case capacity_type when 1 then (sum(total_capacity) * (select value from
`cloud`.`cluster_details` where cluster_details.name= 'cpuOvercommitRatio'
AND cluster_details.cluster_id=capacity.cluster_id))when '0' then
(sum(total_capacity) * (select value from `cloud`.`cluster_details` where
cluster_details.name='memoryOvercommitRatio' AND
cluster_details.cluster_id=capacity.cluster_id))else sum(total_capacity)
end)) percent,capacity.capacity_type, capacity.data_center_id, pod_id,
cluster_id FROM `cloud`.`op_host_capacity` capacity WHERE total_capacity >
0 AND data_center_id is not null AND capacity_state='Enabled' GROUP BY
cluster_id, capacity_type, pod_id order by percent desc limit 8；
SQL-response：
sum(capacity.used_capacity) sum(capacity.reserved_capacity) (case
capacity_type when 1 then (sum(total_capacity) * (select value from
`cloud`.`cluster_details` where cluster_details.name= 'cpuOvercommitRatio'
AND cluster_details.cluster_id=capacity.cluster_id))when '0' then
(sum(total_capacity) * (select value fro percent capacity_type
data_center_id pod_id cluster_id
-----------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------+
4058744094720 0 4227571122176 0.960065242528882 3 1 1 1 18 0
26 0.692307692307692 4 1 NULL NULL 11632919118848 0 21902198308864
0.531130206876999 3 1 NULL NULL 190197174272 0 540684636160
0.351770998382348 0 1 1 1 16 0 50 0.32 5 1 1 NULL 261528 0
960240 0.272356910772307 1 1 1 1 1988618737152 0 32927719010304
0.0603934556332221 9 1 1 1 13 0 233 0.055793991416309 8 1 NULL
NULL
-----------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------+
8 rows in set (0.01 sec)
System-wide capacity
======= 'System-wide capacity ' section of "zone"-"resource" (primary
storage allocated is 59.6%)========
API:
command=listCapacity&response=json
API-Response:
{"listcapacityresponse":{"count":11,"capacity":[
{"type":3,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":15637975924736,"capacitytotal":26129769431040,"percentused":"59.85"}
,
{"type":1,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":257030,"capacitytotal":960240,"percentused":"26.77"}
,
{"type":0,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":185365336064,"capacitytotal":540684636160,"percentused":"34.28"}
,
{"type":7,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":3,"capacitytotal":101,"percentused":"2.97"}
,
{"type":5,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":16,"capacitytotal":50,"percentused":"32"}
,
{"type":4,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":18,"capacitytotal":26,"percentused":"69.23"}
,
{"type":9,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":1934966477312,"capacitytotal":32927719010304,"percentused":"5.88"}
,
{"type":8,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":13,"capacitytotal":233,"percentused":"5.58"}
,
{"type":6,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":418504507392,"capacitytotal":1056889110528,"percentused":"39.6"}
,
{"type":2,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":649472307200,"capacitytotal":45992603725824,"percentused":"1.41"}
,
{"type":19,"zoneid":"1099dffa-cc25-42d1-9d34-78032ee0272f","zonename":"Cloud-Zone001","capacityused":0,"capacitytotal":0,"percentused":"0"}
]}}
SQL：
SELECT sum(capacity.used_capacity), sum(capacity.reserved_capacity), (case
capacity_type when 1 then (sum(total_capacity) * (select value from
`cloud`.`cluster_details` where cluster_details.name= 'cpuOvercommitRatio'
AND cluster_details.cluster_id=capacity.cluster_id)) when '0' then
(sum(total_capacity) * (select value from `cloud`.`cluster_details` where
cluster_details.name= 'memoryOvercommitRatio' AND
cluster_details.cluster_id=capacity.cluster_id))else sum(total_capacity)
end),((sum(capacity.used_capacity) + sum(capacity.reserved_capacity)) / (
case capacity_type when 1 then (sum(total_capacity) * (select value from
`cloud`.`cluster_details` where cluster_details.name= 'cpuOvercommitRatio'
AND cluster_details.cluster_id=capacity.cluster_id)) when '0' then
(sum(total_capacity) * (select value from `cloud`.`cluster_details` where
cluster_details.name= 'memoryOvercommitRatio' AND
cluster_details.cluster_id=capacity.cluster_id)) else sum(total_capacity)
end)) percent,capacity.capacity_type, capacity.data_center_id, pod_id,
cluster_id FROM `cloud`.`op_host_capacity` capacity WHERE total_capacity >
0 AND data_center_id is not null AND capacity_state='Enabled' AND
capacity.data_center_id = 1 GROUP BY data_center_id, pod_id, cluster_id,
capacity_type;
SQL-response：
sum(capacity.used_capacity) sum(capacity.reserved_capacity) (case
capacity_type when 1 then (sum(total_capacity) * (select value from
`cloud`.`cluster_details` where cluster_details.name= 'cpuOvercommitRatio'
AND cluster_details.cluster_id=capacity.cluster_id)) when '0' then
(sum(total_capacity) * (select value fr percent capacity_type
data_center_id pod_id cluster_id
-----------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------+
11632919118848 0 21902198308864 0.531130206876999 3 1 NULL NULL
18 0 26 0.692307692307692 4 1 NULL NULL 3 0 101
0.0297029702970297 7 1 NULL NULL 13 0 233 0.055793991416309 8 1
NULL NULL 16 0 50 0.32 5 1 1 NULL 190197174272 0 540684636160
0.351770998382348 0 1 1 1 261528 0 960240 0.272356910772307 1 1
1 1 4058744094720 0 4227571122176 0.960065242528882 3 1 1 1
1988618737152 0 32927719010304 0.0603934556332221 9 1 1 1
-----------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------+
9 rows in set (0.00 sec)
