Cannot create index in MongoDB 2.4

Question

My friend's app was designed to use MongoDB indexes. Everything was fine while he was developing locally, but once he moved his code to the hosting provider, the code fails:

db.createIndex('collections', {title:"text", description:"text"}, function(err, indexName) {
    console.log("8. index name: " + indexName);
});

The error message is "index creation failed"

Provider says this is because they do not upgrade MongoDB to 2.6, their version is 2.4 and they have no plans to upgrade. I looked into MongoDB website, but the Indexes section does not mention that indexes are not available until 2.6. It only says that 2.6 has some extra features. So what's going on here, something wrong with this code or is really MongoDB not supporting indexes until 2.6, how could that be, or we are doing something wrong, what is the option to have a fast search with MongoDB 2.4?

Your friend should not be using this function. It has been deprecated since v1.8 - docs.mongodb.org/v2.4/reference/method/… — Lix
– Lix, Commented Nov 27, 2014 at 13:30

Jarema · Accepted Answer · 2014-11-27 13:48:36Z

2

as Lix said, createIndex is deprecated. You should use ensureIndex instead:

collection.ensureIndex({title:"text", description:"text"}, function(err, indexName) {
  //handle error and check index name
})

please remember, that this is compound index, not two seperate indexes created at once

more info here: link
info about indexes in nodejs (i assumue You use nodejs, as You used callback:) link2

EDIT

There is info in docs stating that " In MongoDB 2.4, you need to enable the text search feature manually to create text indexes and perform text search."
link and source: indexes

edited Nov 27, 2014 at 13:48

answered Nov 27, 2014 at 13:40

Jarema

3,6262 gold badges20 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alernerdev · Accepted Answer · 2014-11-27 13:40:16Z

0

There is a bit of confusion here. MongoDB 2.4.* does have indexes; indexing is not of feature of 2.6 -- so thats not the problem. I would try two things: first, try to create the index manually from the mongo shell -- perhaps the error message is more meaningful. If that doesnt help, ask the provider to see the mongod log file -- it will definitely show your index creation attempt operation and, hopefully, why it had failed. Finally, it might be failing because text search might not have been enabled? The MongoDB 2.4 documentation mentions "textSearchEnabled" command line parameter that needs to be set to true when launching mongod process

Hope this helps.

answered Nov 27, 2014 at 13:40

alernerdev

2,0643 gold badges20 silver badges37 bronze badges

Collectives™ on Stack Overflow

Cannot create index in MongoDB 2.4

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related