topic Re: 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." in Nuxeo Forum

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 — Mon, 13 Nov 2017 13:13:22 GMT

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.

Re: 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."

Victor_Sánchez — Thu, 30 Nov 2017 16:48:12 GMT

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.

Re: 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 — Fri, 01 Dec 2017 05:55:25 GMT

Hi,

Re: 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."

Kevin_Leturc — Fri, 01 Dec 2017 10:18:38 GMT

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>

Re: 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 — Fri, 01 Dec 2017 11:21:24 GMT

I already debug the query it is as follows

Re: 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."

Victor_Sánchez — Fri, 01 Dec 2017 11:57:33 GMT

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

Re: 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 — Mon, 04 Dec 2017 12:36:06 GMT

Hi,

Re: 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."

Kevin_Leturc — Mon, 04 Dec 2017 14:01:14 GMT

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