I'm doing sorting in mongo db in Robo 3T as:
db.getCollection('notifications').find({}).sort({created:-1})
Also tried with aggregate query:
db.getCollection('notifications').aggregate([{$sort: {created:-1}}])
But getting following error message:
Error: error: {
"operationTime" : Timestamp(1670930556, 3),
"ok" : 0,
"errmsg" : "Executor error during find command :: caused by :: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting.",
"code" : 292,
"codeName" : "QueryExceededMemoryLimitNoDiskUseAllowed",
"$clusterTime" : {
"clusterTime" : Timestamp(1670930556, 3),
"signature" : {
"hash" : BinData(0,"s4UXruiYZcUr3F6BqG+3lgIoUPk="),
"keyId" : NumberLong("7122164698669121538")
}
}
}
Views:
323
Total Answered:
1
Total Marked As Answer:
0
Posted On:
13-Dec-2022 04:24