Learning and Sharing
  • Home
  • Blog
  • Linux
  • macOS
  • Virtualization
    • VMware
    • VirtualBox
  • Windows
    • Windows 11
    • Windows 10
    • Windows Server
  • Series
    • Symantec
    • Intune
    • Microsoft Azure
    • Powershell
    • VirtualBox
    • VMware
    • PowerShell Learning
    • Microsoft Graph
  • More
    • Auto Installation
    • AEC Installation
  • Contact
No Result
View All Result
  • Home
  • Blog
  • Linux
  • macOS
  • Virtualization
    • VMware
    • VirtualBox
  • Windows
    • Windows 11
    • Windows 10
    • Windows Server
  • Series
    • Symantec
    • Intune
    • Microsoft Azure
    • Powershell
    • VirtualBox
    • VMware
    • PowerShell Learning
    • Microsoft Graph
  • More
    • Auto Installation
    • AEC Installation
  • Contact
No Result
View All Result
No Result
View All Result

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

September 16, 2022
in Blog
0
ADVERTISEMENT
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 }
5/5 - (1 vote)
Previous Post

How to Show the Tables or Collections in a Mongo Database

Next Post

Fixed Error Connect EADDRNOTAVAIL ::1:3001 – Local

Related Posts

Running Hyper-V and VMware Workstation on The Same Machine

August 15, 2024

How to Uninstall All Autodesk Products At Once Silently

July 29, 2024
Ftr5

How to Uninstall the Autodesk Genuine Service on Windows

July 29, 2024
Ftr19

How to Fix Windows Cannot Read the ProductKey From the Unattend Answer File in VirtualBox

July 26, 2024
Ftr25

How to Update Windows Terminal in Windows 10/11

July 26, 2024

How to Disable The Beep Sound in WSL Terminal on Windows

July 26, 2024

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • How To Turn On uBlock Origin Extension in Chrome (2025)
  • Images Hidden Due To Mature Content Settings In CivitAI
  • Azure OpenAI vs Azure AI Hub, How to Choose the Right One for Your Needs

Categories

Stay in Touch

Discord Server

Join the Discord server with the site members for all questions and discussions.

Telegram Community

Jump in Telegram server. Ask questions and discuss everything with the site members.

Youtube Channel

Watch more videos, learning and sharing with Leo ❤❤❤. Sharing to be better.

Newsletter

Join the movement and receive our weekly Tech related newsletter. It’s Free.

General

Microsoft Windows

Microsoft Office

VMware

VirtualBox

Technology

PowerShell

Microsoft 365

Microsoft Teams

Email Servers

Copyright 2025 © All rights Reserved. Design by Leo with ❤

No Result
View All Result
  • Home
  • Linux
  • Intune
  • macOS
  • VMware
  • VirtualBox
  • Powershell
  • Windows 10
  • Windows 11
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Office
  • Active Directory

No Result
View All Result
  • Home
  • Linux
  • Intune
  • macOS
  • VMware
  • VirtualBox
  • Powershell
  • Windows 10
  • Windows 11
  • Microsoft 365
  • Microsoft Azure
  • Microsoft Office
  • Active Directory