[
https://issues.apache.org/jira/browse/CLOUDSTACK-2625?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164780#comment-14164780
]
ASF subversion and git services commented on CLOUDSTACK-2625:
-------------------------------------------------------------
Commit 7a86dc516dc1184a6394d40bb01d84bdc497095c in cloudstack's branch
refs/heads/4.3 from [~kishan]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=7a86dc5 ]
CLOUDSTACK-2625, CLOUDSTACK-3401: Usage records are ordered by start_date which
is not unique. While listing large datasets or when page size is small this
will result in duplicates. Order records by id instead
(cherry picked from commit 63109a97b1119cd306858cd4068e46859acc8e83)
Signed-off-by: Rohit Yadav <rohit.ya...@shapeblue.com>
Conflicts:
server/src/com/cloud/usage/UsageServiceImpl.java
> Duplicate usage records when listing large number of records
> ------------------------------------------------------------
>
> Key: CLOUDSTACK-2625
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2625
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Usage
> Affects Versions: 4.2.0
> Reporter: Kishan Kavala
> Assignee: Kishan Kavala
> Fix For: 4.5.0
>
>
> listUsageRecords sorts results by start_date. Using pagination, sample mysql
> query is as follows.
> SELECT cloud_usage.id, 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 data.
> 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 was sent by Atlassian JIRA
(v6.3.4#6332)
