[
https://issues.apache.org/jira/browse/CLOUDSTACK-3401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164781#comment-14164781
]
ASF subversion and git services commented on CLOUDSTACK-3401:
-------------------------------------------------------------
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 <[email protected]>
Conflicts:
server/src/com/cloud/usage/UsageServiceImpl.java
> Small page sizes return duplicate results
> -----------------------------------------
>
> Key: CLOUDSTACK-3401
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3401
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: API
> Affects Versions: 4.1.0
> Reporter: Michael
> Assignee: Kishan Kavala
> Fix For: 4.5.0
>
>
> When performing a listUsageRecords query and small page sizes are used (eg
> 10) then the same records gets returned on different pages and some records
> aren't reported at all. When larger page sizes such as 100 are used we don't
> see any duplication although the concern is that duplication will occur.
> Example call:
> listUsageRecords( ['startdate' => '2013-06-07', 'enddate' => '2013-07-07',
> 'accountid' => 'xxxx', 'page' => $p, 'pagesize' => 10])
> The same call with a larger number returns the same number of overall results
> but those results differ.
> The expected result is that the calls to the same function with the same
> criteria but different page sizes should return the exact same results once
> all pages have been iterated through.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
