nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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.

Find more posts tagged with

Comments

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,

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

Victor_Sánchez

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

Santosh_Yadav

Hi,

Kevin_Leturc

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