[SERVER-13537] Large skip and and limit values can cause crash in blocking sort stage Created: 10/Apr/14 Updated: 11/Jul/16 Resolved: 14/Apr/14 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Querying |
| Affects Version/s: | 2.6.0 |
| Fix Version/s: | 2.6.1, 2.7.0 |
| Type: | Bug | Priority: | Major - P3 |
| Reporter: | Tianxiang Ma | Assignee: | David Storch |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||
| Operating System: | ALL | ||||||||||||
| Backport Completed: | |||||||||||||
| Participants: | |||||||||||||
| Description |
| Comments |
| Comment by Githook User [ 14/Apr/14 ] | ||
|
Author: {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'}Message: (cherry picked from commit 3e4b9474749fc3b4df182d813e09a26b0e02fcc6) | ||
| Comment by Githook User [ 14/Apr/14 ] | ||
|
Author: {u'username': u'dstorch', u'name': u'David Storch', u'email': u'david.storch@10gen.com'}Message: | ||
| Comment by hari.khalsa@10gen.com [ 11/Apr/14 ] | ||
|
tma995@gmail.com Thank you very much for finding the query! We'll fix this ASAP. Please do file further tickets for any other issues like this (though I hope there aren't any!). | ||
| Comment by Tianxiang Ma [ 11/Apr/14 ] | ||
|
Hi Thomas, It turns out not difficult to reproduce the crash, as it was caused by a scheduled daily task which leads to the same crash again today. After debugging, here comes the culprit query:
The "limit number" seems too large and makes no sense, however it works for a long time in previous mongodb versions. I tried for a few other db & collections and MongoDB crash at the same stage if query in similar format(find->sort->skip->limit with a large number as above). For info of our dev system, please refer to below: Anyway, by redefine the "limit" size to a small number we are able to get around the crash. Hope this helps. TMA | ||
| Comment by Thomas Rueckstiess [ 10/Apr/14 ] | ||
|
Hi Tianxiang, Thanks for reporting this issue. In order to investigate and reproduce the crash we would need some more information:
Thanks, | ||
| Comment by hari.khalsa@10gen.com [ 10/Apr/14 ] | ||
|
Hello! Are you able to reproduce the crash? If so, can you tell me exactly how to do so? |