[CLOUDSTACK-3401] Small page sizes return duplicate results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.1.0
• Fix Version/s: 4.5.0
• Component/s: API
• Security Level: Public (Anyone can view this level - this is the default.)
• Assignee: Kishan
• Reporter: Michael
• Created: 08/Jul/13 21:14
• Updated: 09/Oct/14 05:28
• Resolved: 09/Oct/14 05:00

Description

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.

Issue Links

• duplicates: CLOUDSTACK-2625 Duplicate usage records when listing large number of records