[jira] [Commented] (CLOUDSTACK-3401) Small page sizes return duplicate results

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ 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)