[ https://issues.apache.org/jira/browse/CLOUDSTACK-9597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15772734#comment-15772734 ]
ASF subversion and git services commented on CLOUDSTACK-9597: ------------------------------------------------------------- Commit 0a42f0127eae1f38e349c69d73a0430d94bae3e4 in cloudstack's branch refs/heads/4.9 from [~rohit.ya...@shapeblue.com] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=0a42f01 ] Merge pull request #1764 from exoscale/fix/CLOUDSTACK-9597 CLOUDSTACK-9597: Should not fetch resource count for removed entityFetch the number of resourceCount by domain and account excluding the removed ones. Signed-off-by: Marc-Aurle Brothier <m...@brothier.org> * pr/1764: CLOUDSTACK-9597: Should not fetch resource count for removed entity Signed-off-by: Rohit Yadav <rohit.ya...@shapeblue.com> > Incorrect updateResourceCount() > ------------------------------- > > Key: CLOUDSTACK-9597 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9597 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the > default.) > Components: Management Server > Reporter: Marc-Aurèle Brothier > Assignee: Marc-Aurèle Brothier > > h3. Currently > On management server startup, the {{ConfigurationServerImpl}} does a check on > the resource type * resource count versus number of accounts & domains to see > if all accounts and domains have a resource count set for each resource type. > The list of accounts and domains are fetched excluding the removed ones. But > the number of resourceCount by account and domain takes all of them, leading > to an incorrect math check. > The API command {{updateResourceCount}} can crash with an incorrect SQL query. > I discovered the problem while adding a new {{ResourceType}}. > h3. Changes > Fetch the number of resourceCount by domain and account excluding the removed > ones. -- This message was sent by Atlassian JIRA (v6.3.4#6332)