Overflow sort stage buffered data usage exceeds internal limit

by

You’re running into the 32MB limit on an in-memory sort:

https://docs.mongodb.com/manual/reference/limits/#Sort-Operations

Add an index to the sort field. That allows MongoDB to stream documents to you in sorted order, rather than attempting to load them all into memory on the server and sort them in memory before sending them to the client.

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. Update MongoDB field using value of another field
  3. Find objects between two dates MongoDB
  4. Does MongoDB’s $in clause guarantee order
  5. How to query nested objects?
  6. Update field in exact element array in MongoDB
  7. how to convert string to numerical values in mongodb
  8. How to find MongoDB field name at arbitrary depth
  9. Return only matched sub-document elements within a nested array
  10. Converting string to date in mongodb
  11. How to Model a “likes” voting system with MongoDB
  12. Querying internal array size in MongoDB
  13. MongoDB: How to query for records where field is null or not set?
  14. Mongo sort on a calculated condition
  15. MongoDB ‘unable to find index for $geoNear query’
  16. MongoDB: Calculate dwell time between every status value change
  17. MongoDB: how to parse date in 3.6 mongoDb version?
  18. How to ignore nulls while unmarshalling a MongoDB document?
  19. Using stored JavaScript functions in the Aggregation pipeline, MapReduce or runCommand
  20. MongoDB – The argument to $size must be an Array, but was of type: EOO / missing
  21. Mongodb query specific month|year not date
  22. convert iso date to timestamp in mongo query
  23. Remove Duplicates from MongoDB
  24. Using $slice operator to get last element of array
  25. How to access overall document count during arithmetic aggregation expression
  26. Push to two separate arrays in one update call in mongodb
  27. How to toggle a boolean field in one document with atomic operation?
  28. Update embedded object inside array inside array in MongoDB
  29. Mongodb concat int and string
  30. MongoDB $lookup on nested document

Leave a Comment