OPERATIONAL DEFECT DATABASE
...
...
We have discovered an issue that we think related to the $sort + $limit optimizer. We have attached dump of a sample collection. Second query with a limit of 25 has as first element the last element of the first page (25th) instead of the 26th correct one. Same queries performed without limit works properly.
thomas.schubert commented on Thu, 21 Sep 2017 06:04:17 +0000: Hi ivan.fioravanti@4ward.it, This is likely just the result of your particular system. For example, when I ran the same operations as you described in the ticket, I saw a different sort order than the one you are describing. To ensure a consistent ordering, please include a unique field in your sort order. For MongoDB-related support discussion please post on the mongodb-user group or Stack Overflow with the mongodb tag. A question like this involving more discussion would be best posted on the mongodb-users group. Kind regards, Kelsey ivan.fioravanti@4ward.it commented on Thu, 27 Jul 2017 09:17:55 +0000: But why without $limits it works properly an moreover with $limits results is always the same? It this is by design I expect to see different sorted elements in result, while here order is always wrong in the same way and always on first element of the second page. thomas.schubert commented on Wed, 26 Jul 2017 16:32:11 +0000: Hi ivan.fioravanti@4ward.it, Thank for the very clear reproduction steps in your report. The behavior you're describing is expected, please review my comment on SERVER-28195 for additional details. Kind regards, Thomas
Import SortLimitBug dump in a new database. Run following aggregation and check Id of last record return (67) db.SortLimitBug.aggregate(( [ { "$project" : { "TM30" : 1, "OM30":1} }, { "$sort" : { "TM30" : NumberInt(-1) } }, { "$match" : { "OM30" : { "$lt" : 5.0 } } }, { "$skip" : NumberInt(0) }, { "$limit" : NumberInt(25) } ])) Run second page: Check Id of first record: is 67 instead of 72 db.SortLimitBug.aggregate(( [ { "$project" : { "TM30" : 1, "OM30":1} }, { "$sort" : { "TM30" : NumberInt(-1) } }, { "$match" : { "OM30" : { "$lt" : 5.0 } } }, { "$skip" : NumberInt(25) }, { "$limit" : NumberInt(25) } ])) Run same queries without $limit and records will be correct
Click on a version to see all relevant bugs
MongoDB Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.
