Mixing
Mongodb: allowDiskUse: true is not working in mongoose
0
I have a mongo query which have multiple lookup but it returns me a error
Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in
I already add allow disk size true in my aggregation query
await Service.aggregate(pipeline)
.allowDiskUse(true)
.exec();
mongodb mongoose
|
show 1 more comment
0
I have a mongo query which have multiple lookup but it returns me a error
Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in
I already add allow disk size true in my aggregation query
await Service.aggregate(pipeline)
.allowDiskUse(true)
.exec();
mongodb mongoose
What version of MongoDB are you using, and what sort of an aggregate operation are you performing? I don't thinkallowDiskUseworks with all of them.
– caffeinated.tech
Jan 2 at 11:11
Are you connecting to a MongoDB deployment that you have installed, or a cloud service? If you are using a cloud service (particularly a free tier) theallowDiskUseoption may not be supported.
– Stennie
Jan 2 at 11:27
@Caffeinated.tech version 5.2.7,services.aggregate([ { '$addFields': { name_lc: { '$toLower': '$name.value_en' } } }, { '$match': { isDeleted: false } }, { '$lookup': { from: 'servicecategories', localField: 'serviceCategory', foreignField: '_id', as: 'category' } }, { '$sort': { name_lc: 1 } }, { '$skip': 0 }, { '$limit': 10 }, { '$project': { 'category.defaultQuantities': 0 } } ], { allowDiskUse: true })
– user8590996
Jan 2 at 11:34
@Stennie i am using mongo atlas paid
– user8590996
Jan 2 at 11:38
Possible duplicate of TypeError: callback.apply is not a function after allowDiskUse
– Anthony Winzlet
Jan 2 at 12:28
|
show 1 more comment
0
0
0
I have a mongo query which have multiple lookup but it returns me a error
Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in
I already add allow disk size true in my aggregation query
await Service.aggregate(pipeline)
.allowDiskUse(true)
.exec();
mongodb mongoose
I have a mongo query which have multiple lookup but it returns me a error
Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in
I already add allow disk size true in my aggregation query
await Service.aggregate(pipeline)
.allowDiskUse(true)
.exec();
mongodb mongoose
mongodb mongoose
asked Jan 2 at 10:57
user8590996
What version of MongoDB are you using, and what sort of an aggregate operation are you performing? I don't thinkallowDiskUseworks with all of them.
– caffeinated.tech
Jan 2 at 11:11
Are you connecting to a MongoDB deployment that you have installed, or a cloud service? If you are using a cloud service (particularly a free tier) theallowDiskUseoption may not be supported.
– Stennie
Jan 2 at 11:27
@Caffeinated.tech version 5.2.7,services.aggregate([ { '$addFields': { name_lc: { '$toLower': '$name.value_en' } } }, { '$match': { isDeleted: false } }, { '$lookup': { from: 'servicecategories', localField: 'serviceCategory', foreignField: '_id', as: 'category' } }, { '$sort': { name_lc: 1 } }, { '$skip': 0 }, { '$limit': 10 }, { '$project': { 'category.defaultQuantities': 0 } } ], { allowDiskUse: true })
– user8590996
Jan 2 at 11:34
@Stennie i am using mongo atlas paid
– user8590996
Jan 2 at 11:38
Possible duplicate of TypeError: callback.apply is not a function after allowDiskUse
– Anthony Winzlet
Jan 2 at 12:28
|
show 1 more comment
What version of MongoDB are you using, and what sort of an aggregate operation are you performing? I don't thinkallowDiskUseworks with all of them.
– caffeinated.tech
Jan 2 at 11:11
Are you connecting to a MongoDB deployment that you have installed, or a cloud service? If you are using a cloud service (particularly a free tier) theallowDiskUseoption may not be supported.
– Stennie
Jan 2 at 11:27
@Caffeinated.tech version 5.2.7,services.aggregate([ { '$addFields': { name_lc: { '$toLower': '$name.value_en' } } }, { '$match': { isDeleted: false } }, { '$lookup': { from: 'servicecategories', localField: 'serviceCategory', foreignField: '_id', as: 'category' } }, { '$sort': { name_lc: 1 } }, { '$skip': 0 }, { '$limit': 10 }, { '$project': { 'category.defaultQuantities': 0 } } ], { allowDiskUse: true })
– user8590996
Jan 2 at 11:34
@Stennie i am using mongo atlas paid
– user8590996
Jan 2 at 11:38
Possible duplicate of TypeError: callback.apply is not a function after allowDiskUse
– Anthony Winzlet
Jan 2 at 12:28
What version of MongoDB are you using, and what sort of an aggregate operation are you performing? I don't think
allowDiskUse works with all of them.– caffeinated.tech
Jan 2 at 11:11
What version of MongoDB are you using, and what sort of an aggregate operation are you performing? I don't think
allowDiskUse works with all of them.– caffeinated.tech
Jan 2 at 11:11
Are you connecting to a MongoDB deployment that you have installed, or a cloud service? If you are using a cloud service (particularly a free tier) the
allowDiskUse option may not be supported.– Stennie
Jan 2 at 11:27
Are you connecting to a MongoDB deployment that you have installed, or a cloud service? If you are using a cloud service (particularly a free tier) the
allowDiskUse option may not be supported.– Stennie
Jan 2 at 11:27
@Caffeinated.tech version 5.2.7,
services.aggregate([ { '$addFields': { name_lc: { '$toLower': '$name.value_en' } } }, { '$match': { isDeleted: false } }, { '$lookup': { from: 'servicecategories', localField: 'serviceCategory', foreignField: '_id', as: 'category' } }, { '$sort': { name_lc: 1 } }, { '$skip': 0 }, { '$limit': 10 }, { '$project': { 'category.defaultQuantities': 0 } } ], { allowDiskUse: true })– user8590996
Jan 2 at 11:34
@Caffeinated.tech version 5.2.7,
services.aggregate([ { '$addFields': { name_lc: { '$toLower': '$name.value_en' } } }, { '$match': { isDeleted: false } }, { '$lookup': { from: 'servicecategories', localField: 'serviceCategory', foreignField: '_id', as: 'category' } }, { '$sort': { name_lc: 1 } }, { '$skip': 0 }, { '$limit': 10 }, { '$project': { 'category.defaultQuantities': 0 } } ], { allowDiskUse: true })– user8590996
Jan 2 at 11:34
@Stennie i am using mongo atlas paid
– user8590996
Jan 2 at 11:38
@Stennie i am using mongo atlas paid
– user8590996
Jan 2 at 11:38
Possible duplicate of TypeError: callback.apply is not a function after allowDiskUse
– Anthony Winzlet
Jan 2 at 12:28
Possible duplicate of TypeError: callback.apply is not a function after allowDiskUse
– Anthony Winzlet
Jan 2 at 12:28
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54005089%2fmongodb-allowdiskuse-true-is-not-working-in-mongoose%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54005089%2fmongodb-allowdiskuse-true-is-not-working-in-mongoose%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
What version of MongoDB are you using, and what sort of an aggregate operation are you performing? I don't think
allowDiskUseworks with all of them.– caffeinated.tech
Jan 2 at 11:11
Are you connecting to a MongoDB deployment that you have installed, or a cloud service? If you are using a cloud service (particularly a free tier) the
allowDiskUseoption may not be supported.– Stennie
Jan 2 at 11:27
@Caffeinated.tech version 5.2.7,
services.aggregate([ { '$addFields': { name_lc: { '$toLower': '$name.value_en' } } }, { '$match': { isDeleted: false } }, { '$lookup': { from: 'servicecategories', localField: 'serviceCategory', foreignField: '_id', as: 'category' } }, { '$sort': { name_lc: 1 } }, { '$skip': 0 }, { '$limit': 10 }, { '$project': { 'category.defaultQuantities': 0 } } ], { allowDiskUse: true })– user8590996
Jan 2 at 11:34
@Stennie i am using mongo atlas paid
– user8590996
Jan 2 at 11:38
Possible duplicate of TypeError: callback.apply is not a function after allowDiskUse
– Anthony Winzlet
Jan 2 at 12:28