Francois Scheurer created CLOUDSTACK-9338:
---------------------------------------------
Summary: listAccount returns 0 for cputotal and memorytotal if VMs
are using a ComputeOffering with custom=enabled
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
Environment: CloudStack 4.5.1
MariaDB 10.0 and 10.1
Reporter: Francois Scheurer
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
(v6.3.4#6332)
