[Quota] Details by resource on consumption

[nvazquez]

Problem

Observing multiple rows for the same aggregation range time period for each individual resource, which do not sum up to the consumed quota displayed above.

As an example:

usage.stats.job.aggregation.range = 20

Tariffs:

• RUNNING_VM = 10
• ALLOCATED_VM = 5
• VOLUME = 10

For VM = cks-control-19fd8b4d3a1, the consumed quota for RUNNING_VM = 4.04

versions

CloudStack version 4.23 RC2

[winterhazel]

@nvazquez

multiple rows for the same aggregation range time period for each individual resource

This is probably happening due to duplicated usage records, caused by duplicated usage helper entries. Could you provide the output of the following query in your environment?

select * from cloud_usage.usage_vm_instance where vm_instance_id = <id_of_cks-control-19fd>;

and the consumed quota does not match the summary on the tables above.

The value for RUNNING_VM in the details by resource graph does match the value for cks-control-19fd in the resources by usage type, so the sum is correct. The multiple 0.00s in the Quota consumed column is a rounded value. You can hover over it to see that it is not actually zero.

[nvazquez]

Thanks @winterhazel, please find the output:

mysql> select * from cloud_usage.usage_vm_instance where vm_instance_id = 7;
+----+------------+---------+------------+----------------+-------------------------+---------------------+-------------+-----------------+---------------------+----------+-----------+-----------+--------+
| id | usage_type | zone_id | account_id | vm_instance_id | vm_name                 | service_offering_id | template_id | hypervisor_type | start_date          | end_date | cpu_speed | cpu_cores | memory |
+----+------------+---------+------------+----------------+-------------------------+---------------------+-------------+-----------------+---------------------+----------+-----------+-----------+--------+
|  7 |          2 |       1 |          2 |              7 | cks-control-19fd8b4d3a1 |                  13 |           3 | KVM             | 2026-08-06 20:12:37 | NULL     |      NULL |      NULL |   NULL |
|  8 |          1 |       1 |          2 |              7 | cks-control-19fd8b4d3a1 |                  13 |           3 | KVM             | 2026-08-06 20:12:50 | NULL     |      NULL |      NULL |   NULL |
+----+------------+---------+------------+----------------+-------------------------+---------------------+-------------+-----------------+---------------------+----------+-----------+-----------+--------+
2 rows in set (0.00 sec)

Ahh my bad, indeed the values are displayed on hover and also after downloading the details as CSV