Mongo DB sort operation gives error "Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit."

[Santosh_Yadav]

Hi, I am having complex hierarchy of document up to 20 levels. And more than 1lakh of document. While I am accessing inner most level of document getting error.

** com.mongodb.MongoQueryException: Query failed with error code 96 and error message 'errmsg: "Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit."' on server hydprdmsdb4:27020**

Can any one solve this.

[Victor_Sánchez]

Hi,

You can do, for example for 50MB blocking sort:

> mongo <your-server-and-port>
> use admin
> db.adminCommand({setParameter: 1, internalQueryExecMaxBlockingSortBytes:50151432})

Regards, VS.

[Santosh_Yadav]

Hi,

[Victor_Sánchez]

Please, check your mongodb parameters after changes and verify about internalQueryExecMaxBlockingSortBytes param.

[Santosh_Yadav]

Hi,

[Kevin_Leturc]

Hi Santosh,

You need to enable logs on MongoDBRepository in order to tackle the culprit query. Add the following lines to the log4j.xml file to trace the queries sent to MongoDB:

<category name="org.nuxeo.ecm.core.storage.mongodb.MongoDBRepository">
  <priority value="TRACE" />
</category>

[Santosh_Yadav]

I already debug the query it is as follows

[Kevin_Leturc]

What is the context of this query ? Is it a query done by Nuxeo itself as a system/admin tasks ?