Sort operation used more than the maximum 33554432 bytes of RAM

Working with Data
1

I’ve a Rails application that gets data from Mongo. It returns error when trying to export the data to csv -

error": “internal-server-error”,

“exception”: “Mongo::Error::OperationFailure : Executor error during find command :: caused by :: Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit. (96)”

Created few indexes on the collection but its still throwing this error.

Any suggestions how to fix it?

2

Please make sure index exists on the sort field

3

Adding the index on the sort field fixed the issue. Thanks

4

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.