cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <>
Subject [jira] [Commented] (CLOUDSTACK-3401) Small page sizes return duplicate results
Date Thu, 09 Oct 2014 05:28:34 GMT


ASF subversion and git services commented on CLOUDSTACK-3401:

Commit 7a86dc516dc1184a6394d40bb01d84bdc497095c in cloudstack's branch refs/heads/4.3 from
[;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 <>


> Small page sizes return duplicate results
> -----------------------------------------
>                 Key: CLOUDSTACK-3401
>                 URL:
>             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

This message was sent by Atlassian JIRA

View raw message