You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Rafael Weingärtner (JIRA)" <ji...@apache.org> on 2018/02/01 12:59:00 UTC
[jira] [Updated] (CLOUDSTACK-9338) updateResourceCount not
accounting resources of VMs with custom service offering
[ https://issues.apache.org/jira/browse/CLOUDSTACK-9338?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rafael Weingärtner updated CLOUDSTACK-9338:
-------------------------------------------
Summary: updateResourceCount not accounting resources of VMs with custom service offering (was: listAccount returns 0 for cputotal and memorytotal if VMs are using a ComputeOffering with custom=enabled)
> updateResourceCount not accounting resources of VMs with custom service offering
> --------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-9338
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9338
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the default.)
> Components: API, Cloudmonkey, UI
> Affects Versions: 4.5.2, 4.8.0
> Environment: CloudStack 4.5.1
> MariaDB 10.0 and 10.1
> Reporter: Francois Scheurer
> Assignee: Rafael Weingärtner
> Priority: Major
>
> listAccount on a domain returns 0 for cputotal and memorytotal if the domain accounts own VMs using a ComputeOffering with custom=enabled.
> Basically, looking into the vm_instance table you get the service_offering_id and in the service_offering table you find normally the amount of CPU/RAM allocated for the VM.
> But if your VM's ComputeOffering has custom=enabled, then you need to get the specific CPU/RAM values from the user_vm_details table:
> mysql> select * from user_vm_details WHERE vm_id=957;
> Apparently the listAccount code is not doing that and it just returns zero, because the service_offering table has cpu=0 and ram_size=0 for ComputeOfferings with custom=enabled.
> solution: the SQL query of listAccount should also look in the user_vm_details table for matching rows. (instead of just querying in the service_offering table)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)