[
https://issues.apache.org/jira/browse/CLOUDSTACK-3401?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164753#comment-14164753
]
ASF subversion and git services commented on CLOUDSTACK-3401:
-------------------------------------------------------------
Commit 63109a97b1119cd306858cd4068e46859acc8e83 in cloudstack's branch
refs/heads/master from [~kishan]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=63109a9 ]
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
> 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
>
> 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)
