Mongoose: ensureIndex running after insertMany
I have set two compound indexes in my Schema
(...)
ModelSchema.index({"field1":1, "field2":1, "field3": 1, "field4": 1})
ModelSchema.index({"field1":1, "field2":1, "field3": -1, "field4": -1})
module.exports = mongoose.model('Model', ModelSchema)
Then I'm calling
Model.insertMany(itemsArray)
In mongo shell, I can see that both indexes were created. However, when I tried to query the collection with a hint for the second index, I got an error.
So what I did was to turn on mongoose debug
mongoose.set('debug', true)
And in the log I could see that the order of operations is happening like:
Mongoose: models.ensureIndex({"field1":1, "field2":1, "field3": 1, "field4": 1})
Mongoose: models.insertMany([....])
(...other operations of my code happening here)
Mongoose: models.ensureIndex({"field1":1, "field2":1, "field3": -1, "field4": -1})
Mongoose: models.indexInformation({ full: true })
So, it seems to me that the 2 things are happening:
- insertion is happening before the second index is ensured
- indexing is happening asynchronously while my code is already executing
How can I guarantee that both indexes are ensured before inserting the items in the collection?
mongodb indexing mongoose
asked Dec 31 '18 at 12:39
João OteroJoão Otero
188111
add a comment |
I have set two compound indexes in my Schema
(...)
ModelSchema.index({"field1":1, "field2":1, "field3": 1, "field4": 1})
ModelSchema.index({"field1":1, "field2":1, "field3": -1, "field4": -1})
module.exports = mongoose.model('Model', ModelSchema)
Then I'm calling
Model.insertMany(itemsArray)
In mongo shell, I can see that both indexes were created. However, when I tried to query the collection with a hint for the second index, I got an error.
So what I did was to turn on mongoose debug
mongoose.set('debug', true)
And in the log I could see that the order of operations is happening like:
Mongoose: models.ensureIndex({"field1":1, "field2":1, "field3": 1, "field4": 1})
Mongoose: models.insertMany([....])
(...other operations of my code happening here)
Mongoose: models.ensureIndex({"field1":1, "field2":1, "field3": -1, "field4": -1})
Mongoose: models.indexInformation({ full: true })
So, it seems to me that the 2 things are happening:
- insertion is happening before the second index is ensured
- indexing is happening asynchronously while my code is already executing
How can I guarantee that both indexes are ensured before inserting the items in the collection?
mongodb indexing mongoose
asked Dec 31 '18 at 12:39
João OteroJoão Otero
188111
add a comment |
I have set two compound indexes in my Schema
(...)
ModelSchema.index({"field1":1, "field2":1, "field3": 1, "field4": 1})
ModelSchema.index({"field1":1, "field2":1, "field3": -1, "field4": -1})
module.exports = mongoose.model('Model', ModelSchema)
Then I'm calling
Model.insertMany(itemsArray)
In mongo shell, I can see that both indexes were created. However, when I tried to query the collection with a hint for the second index, I got an error.
So what I did was to turn on mongoose debug
mongoose.set('debug', true)
And in the log I could see that the order of operations is happening like:
Mongoose: models.ensureIndex({"field1":1, "field2":1, "field3": 1, "field4": 1})
Mongoose: models.insertMany([....])
(...other operations of my code happening here)
Mongoose: models.ensureIndex({"field1":1, "field2":1, "field3": -1, "field4": -1})
Mongoose: models.indexInformation({ full: true })
So, it seems to me that the 2 things are happening:
- insertion is happening before the second index is ensured
- indexing is happening asynchronously while my code is already executing
How can I guarantee that both indexes are ensured before inserting the items in the collection?
mongodb indexing mongoose
asked Dec 31 '18 at 12:39
João OteroJoão Otero
188111
I have set two compound indexes in my Schema
(...)
ModelSchema.index({"field1":1, "field2":1, "field3": 1, "field4": 1})
ModelSchema.index({"field1":1, "field2":1, "field3": -1, "field4": -1})
module.exports = mongoose.model('Model', ModelSchema)
Then I'm calling
Model.insertMany(itemsArray)
In mongo shell, I can see that both indexes were created. However, when I tried to query the collection with a hint for the second index, I got an error.
So what I did was to turn on mongoose debug
mongoose.set('debug', true)
And in the log I could see that the order of operations is happening like:
Mongoose: models.ensureIndex({"field1":1, "field2":1, "field3": 1, "field4": 1})
Mongoose: models.insertMany([....])
(...other operations of my code happening here)
Mongoose: models.ensureIndex({"field1":1, "field2":1, "field3": -1, "field4": -1})
Mongoose: models.indexInformation({ full: true })
So, it seems to me that the 2 things are happening:
- insertion is happening before the second index is ensured
- indexing is happening asynchronously while my code is already executing
How can I guarantee that both indexes are ensured before inserting the items in the collection?
mongodb indexing mongoose
mongodb indexing mongoose
asked Dec 31 '18 at 12:39
João OteroJoão Otero
188111
asked Dec 31 '18 at 12:39
João OteroJoão Otero
188111
asked Dec 31 '18 at 12:39
João OteroJoão Otero
188111
asked Dec 31 '18 at 12:39
João OteroJoão Otero
188111
asked Dec 31 '18 at 12:39
João OteroJoão Otero
188111
188111
add a comment |
add a 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
});
}
});
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%2f53987644%2fmongoose-ensureindex-running-after-insertmany%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
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.
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%2f53987644%2fmongoose-ensureindex-running-after-insertmany%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
