cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kishan Kavala (JIRA)" <>
Subject [jira] [Created] (CLOUDSTACK-2625) Duplicate usage records when listing large number of records
Date Wed, 22 May 2013 13:01:20 GMT
Kishan Kavala created CLOUDSTACK-2625:

             Summary: Duplicate usage records when listing large number of records
                 Key: CLOUDSTACK-2625
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Usage
            Reporter: Kishan Kavala
             Fix For: 4.2.0

listUsageRecords sorts results by start_date. Using pagination, sa,ple mysql query is as follows.

SELECT, cloud_usage.zone_id, cloud_usage.account_id,
cloud_usage.domain_id, cloud_usage.description, cloud_usage.usage_display,
cloud_usage.usage_type, cloud_usage.raw_usage, cloud_usage.vm_instance_id,
cloud_usage.vm_name, cloud_usage.offering_id, cloud_usage.template_id,
cloud_usage.usage_id, cloud_usage.type, cloud_usage.size,
cloud_usage.virtual_size, cloud_usage.network_id, cloud_usage.start_date,
cloud_usage.end_date FROM cloud_usage WHERE cloud_usage.usage_type = 9  AND
cloud_usage.start_date BETWEEN '2012-01-01 00:00:00' AND '2013-01-31 23:59:59' 
AND cloud_usage.end_date BETWEEN '2012-01-01 00:00:00' AND '2013-01-31
23:59:59'  ORDER BY cloud_usage.start_date DESC  LIMIT 18000, 2000

start_date is not unique and when querying large datasets, multiple pages can return the same
ORDER BY cloud_usage.start_date doesn't create a stable sorted dataset.

Query should include id in ORDER BY to make it stable.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message