cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Darren Tang <darrentang...@gmail.com>
Subject Available Primary Storage Capacity Displayed Incorrectly after Upgrade to ACS 4.5.1
Date Fri, 15 May 2015 01:56:31 GMT
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)

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message