MongoDB Sort Operation Used More Than the Maximum 33554432 Bytes of RAM

12:39:37.351 [INFO] Logger initialized
12:39:37.544 [INFO] Correctly using NodeJS v16.17.0
12:39:37.563 [INFO] Connected to mongodb://localhost:27017/avalon
12:39:37.570 [INFO] Opening blockchain database at /var/blocks...
12:39:37.571 [INFO] Opened blockchain with latest block #19009204
/home/mpnroot/avalon/node_modules/mongodb/lib/utils.js:365
                    throw error;
                    ^

MongoServerError: 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.
    at Connection.onMessage (/home/mpnroot/avalon/node_modules/mongodb/lib/cmap/connection.js:207:30)
    at MessageStream.<anonymous> (/home/mpnroot/avalon/node_modules/mongodb/lib/cmap/connection.js:60:60)
    at MessageStream.emit (node:events:513:28)
    at processIncomingData (/home/mpnroot/avalon/node_modules/mongodb/lib/cmap/message_stream.js:132:20)
    at MessageStream._write (/home/mpnroot/avalon/node_modules/mongodb/lib/cmap/message_stream.js:33:9)
    at writeOrBuffer (node:internal/streams/writable:391:12)
    at _write (node:internal/streams/writable:332:10)
    at MessageStream.Writable.write (node:internal/streams/writable:336:10)
    at Socket.ondata (node:internal/streams/readable:754:22)
    at Socket.emit (node:events:513:28) {
  ok: 0,
  code: 96,
  codeName: 'OperationFailed',
  [Symbol(errorLabels)]: Set(0) {}
}
root@avalon:~# mongo
MongoDB server version: 4.2.22
---

> show dbs
admin   0.000GB
avalon  0.268GB
config  0.000GB
local   0.000GB
> use avalon
switched to db avalon
>                   

Increase limit to 64M

> db.adminCommand({setParameter: 1, internalQueryExecMaxBlockingSortBytes:67108864})
{ "was" : 33554432, "ok" : 1 }

Increase limit to 256M

> db.adminCommand({setParameter: 1, internalQueryExecMaxBlockingSortBytes:268435456})
{ "was" : 67108864, "ok" : 1 }

Leave a Comment

Required fields are marked *