[
https://issues.apache.org/jira/browse/CLOUDSTACK-8470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14543220#comment-14543220
]
darrentang commented on CLOUDSTACK-8470:
----------------------------------------
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)
> Available Primary Storage Capacity Displayed Incorrectly after Upgrade to ACS
> 4.5.1
> -----------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-8470
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8470
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: UI
> Affects Versions: 4.5.1
> Reporter: haijiao
>
> 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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
