Hi Darren,
Do you think it’s a UI issue? If you use something like CloudMonkey and run
"list capacity fetchlatest=true” do you see correct percentages?
> On 15-May-2015, at 2:56 am, Darren Tang <darrentang...@gmail.com> wrote:
>
> 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)
Regards,
Rohit Yadav
Software Architect, ShapeBlue
M. +91 88 262 30892 | rohit.ya...@shapeblue.com
Blog: bhaisaab.org | Twitter: @_bhaisaab
Find out more about ShapeBlue and our range of CloudStack related services
IaaS Cloud Design & Build<http://shapeblue.com/iaas-cloud-design-and-build//>
CSForge – rapid IaaS deployment framework<http://shapeblue.com/csforge/>
CloudStack Consulting<http://shapeblue.com/cloudstack-consultancy/>
CloudStack Software
Engineering<http://shapeblue.com/cloudstack-software-engineering/>
CloudStack Infrastructure
Support<http://shapeblue.com/cloudstack-infrastructure-support/>
CloudStack Bootcamp Training Courses<http://shapeblue.com/cloudstack-training/>
This email and any attachments to it may be confidential and are intended
solely for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of Shape Blue Ltd or related companies. If you are not the
intended recipient of this email, you must neither take any action based upon
its contents, nor copy or show it to anyone. Please contact the sender if you
believe you have received this email in error. Shape Blue Ltd is a company
incorporated in England & Wales. ShapeBlue Services India LLP is a company
incorporated in India and is operated under license from Shape Blue Ltd. Shape
Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is
operated under license from Shape Blue Ltd. ShapeBlue SA Pty Ltd is a company
registered by The Republic of South Africa and is traded under license from
Shape Blue Ltd. ShapeBlue is a registered trademark.
