[ https://issues.apache.org/jira/browse/CLOUDSTACK-9653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15728367#comment-15728367 ]
ASF GitHub Bot commented on CLOUDSTACK-9653: -------------------------------------------- GitHub user rashmidixit opened a pull request: https://github.com/apache/cloudstack/pull/1819 CLOUDSTACK-9653 The system capacity was not getting calculated correctly When listCapacity is used with the sortBy=usage option, the capacity was not getting calculated correctly. Root Cause: The group by options for pod and zone was incorrectly specified. Results were additionally added up. Result was incorrect. Once the correct group by clause is specified, only the results of the query need to be returned. You can merge this pull request into a Git repository by running: $ git pull https://github.com/Accelerite/cloudstack ListCapacityIssue Alternatively you can review and apply these changes as the patch at: https://github.com/apache/cloudstack/pull/1819.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #1819 ---- commit 97b6b117e1448115613318aef1679ac00c93375e Author: rashmidixit <rashmi_di...@persistent.co.in> Date: 2016-12-05T08:55:27Z The system capacity was not getting calculated correctly ---- > listCapacity API shows incorrect output when sortBy=usage option is added > ------------------------------------------------------------------------- > > Key: CLOUDSTACK-9653 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9653 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Components: API > Affects Versions: 4.6.0, 4.7.0, 4.8.0, 4.9.0 > Reporter: Rashmi Dixit > Assignee: Rashmi Dixit > Fix For: 4.9.1.0 > > > listCapacity API does not sum up values correctly when used with sortBy=usage > option. -- This message was sent by Atlassian JIRA (v6.3.4#6332)