cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Francois Scheurer (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CLOUDSTACK-9338) listAccount returns 0 for cputotal and memorytotal if VMs are using a ComputeOffering with custom=enabled
Date Tue, 05 Apr 2016 13:17:25 GMT
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)

Mime
View raw message