[SERVER-18212] Informative error messages Created: 26/Apr/15  Updated: 19/Sep/15  Resolved: 12/May/15

Status: Closed
Project: Core Server
Component/s: Index Maintenance
Affects Version/s: None
Fix Version/s: 3.1.3

Type: Improvement Priority: Major - P3
Reporter: Jeroen Ooms [X] Assignee: Sam Kleinman (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Backwards Compatibility: Fully Compatible
Sprint: BUILD 3 05/15/15
Participants:

 Description   

A relatively common mistake by new users is trying to sort a large collection without an index. Doing this on my Ubuntu server (mongodb 2.4.9) raises the following error message:

Error: too much data for sort() with no index. add an index or specify a smaller limit

This error is very helpful. However trying the same thing on OSX (both with 3.0.2 and 2.6.7) raises the following error:

Error: Executor error: Overflow sort stage buffered data usage of 33554467 bytes exceeds internal limit of 33554432 bytes

The latter error message is not very helpful. Is there something I have to configure to get the error message that I was seeing in 2.4.9?



 Comments   
Comment by Githook User [ 12/May/15 ]

Author:

{u'username': u'tychoish', u'name': u'Sam Kleinman', u'email': u'samk@10gen.com'}

Message: SERVER-18212: fix sort check in js test
Branch: master
https://github.com/mongodb/mongo/commit/b3b37ae5c708ae1876f189e6c685ab06026e86ee

Comment by Githook User [ 12/May/15 ]

Author:

{u'username': u'tychoish', u'name': u'Sam Kleinman', u'email': u'samk@10gen.com'}

Message: SERVER-18212: edits to sort out of memory error message
Branch: master
https://github.com/mongodb/mongo/commit/44c3bfa1e1412886ba48692d4555be87670ba747

Comment by Jeroen Ooms [X] [ 27/Apr/15 ]

I am using the standard homebrew builds of mongodb by the way: https://github.com/Homebrew/homebrew/blob/master/Library/Formula/mongodb.rb

Comment by Sam Kleinman (Inactive) [ 27/Apr/15 ]

There were some significant changes to the query and indexing systems between 2.4 and 2.6, which lead to a change in error messages. There is no configuration change the error message reported for 2.4 versions of MongoDB, but we can look into changing the message in a future version of MongoDB.

Cheers,
sam

Generated at Thu Feb 08 03:46:54 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.