[SERVER-51725] Duplicate documents while using "Sort" with "Pagination" Created: 19/Oct/20 Updated: 15/Dec/20 Resolved: 04/Nov/20 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 4.4.0 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Ummer Irshad | Assignee: | Edwin Zhou |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Operating System: | ALL | ||||||||||||
| Steps To Reproduce: | Environment with Issue Server : Windows Server 2016
Step
Result
|
||||||||||||
| Participants: | |||||||||||||
| Description |
|
When we query MongoDB in below environment with SortByDescending and Pagination, MongoCSharp driver is always returning duplicate documents from the second page onwards. We are setting page size as 10. Issue is not observed when we remove SortByDescending. Environment with Issue Server : Windows Server 2016
Environment without Issue Server : Windows Server 2016 |
| Comments |
| Comment by Edwin Zhou [ 04/Nov/20 ] |
|
I'm happy to hear that! I'll be closing this ticket as a duplicate of Best, Edwin |
| Comment by Ummer Irshad [ 04/Nov/20 ] |
|
After sorting on unique field (ObjectId) the issue is not reproduced. Thanks a lot Edwin Zhou. |
| Comment by Edwin Zhou [ 03/Nov/20 ] |
|
We still need additional information to diagnose the problem. If this is still an issue for you, would you please let me know if Best, Edwin |
| Comment by Edwin Zhou [ 19/Oct/20 ] |
|
Thank you for reporting this behavior! Could you provide a code snippet where this issue is occurs, and your query result? Edwin |