cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rohit Yadav <rohit.ya...@shapeblue.com>
Subject Re: Available Primary Storage Capacity Displayed Incorrectly after Upgrade to ACS 4.5.1
Date Tue, 19 May 2015 08:00:16 GMT
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.dt@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.yadav@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.
Mime
View raw message