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) Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/db79dd1e Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/db79dd1e Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/db79dd1e Branch: refs/heads/4.5 Commit: db79dd1ef52e7e6b1a5629c21d0d7e205a0f9761 Parents: dd335aa Author: Kishan Kavala <[email protected]> Authored: Thu Oct 9 10:27:35 2014 +0530 Committer: David Nalley <[email protected]> Committed: Mon Oct 13 00:36:30 2014 -0400 ---------------------------------------------------------------------- server/src/com/cloud/usage/UsageServiceImpl.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/db79dd1e/server/src/com/cloud/usage/UsageServiceImpl.java ---------------------------------------------------------------------- diff --git a/server/src/com/cloud/usage/UsageServiceImpl.java b/server/src/com/cloud/usage/UsageServiceImpl.java index db0d047..f81415b 100755 --- a/server/src/com/cloud/usage/UsageServiceImpl.java +++ b/server/src/com/cloud/usage/UsageServiceImpl.java @@ -232,7 +232,7 @@ public class UsageServiceImpl extends ManagerBase implements UsageService, Manag ", using pageSize: " + cmd.getPageSizeVal() + " and startIndex: " + cmd.getStartIndex()); } - Filter usageFilter = new Filter(UsageVO.class, "startDate", false, cmd.getStartIndex(), cmd.getPageSizeVal()); + Filter usageFilter = new Filter(UsageVO.class, "id", true, cmd.getStartIndex(), cmd.getPageSizeVal()); SearchCriteria<UsageVO> sc = _usageDao.createSearchCriteria();
