Cannot create index - bad index key pattern

Question

After some activities with my database, I lost my index. I had these indexes:

{
    "v" : 1,
    "key" : {
        "_id" : 1
    },
    "name" : "_id_",
    "ns" : "collection.statement"
},
{
    "v" : 1,
    "unique" : true,
    "key" : {
        "name" : 1
    },
    "name" : "name_1",
    "ns" : "collection.statement"
}

and now I have only first one. I've entered this command

db.collection.createIndex({
    "v" : 1, 
    "unique" : true, 
    "key" :{ "name" : 1 }, 
    "name" : "name_1", 
    "ns" : "collection.statement"
})

and I only get and error message that i have a bad index key pattern. Please, help me, how to return this index? What I do wrong?

glytching · Accepted Answer · 2017-09-22 14:15:08Z

2

Use this:

db.collection.createIndex( { "name": 1 }, { unique: true } )

You attempt includes internal aspects of the index ("v" : 1), you just need to supply the field(s) and an order for each and the unique instruction.

More details in the docs.

answered Sep 22, 2017 at 14:15

glytching

48.5k11 gold badges127 silver badges129 bronze badges

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

Collectives™ on Stack Overflow

Cannot create index - bad index key pattern

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related