MongoError: insertDocument :: caused by :: 11000 E11000 duplicate key error index

Question

When ever i try to insert a new record i am getting the forrlowing error and actually username is itself not part of my model but i am not sure why i am getting this error,can anyone guess the error please.

My error,

MongoError: insertDocument :: caused by :: 11000 E11000 duplicate key error index: project1.students.$username_1  dup key: { : null }

My collection,

 var StudentSchema = new Schema({
  title: { type: String, default: '' },
  first_name: { type: String, default: '' },
  last_name: { type: String, default: '' },
  email: { type: String, default: '' },
  display_name: {
    type: String,
    trim: true
  },
  username: {
    type: String,
    validate: [validateUsername, 'Please enter a valid username: 3+ characters long, non restricted word, characters "_-.", no consecutive dots, does not begin or end with dots, letters a-z and numbers 0-9.'],
    lowercase: true,
    trim: true
  },
 });

My indexes,

 [
    {
        "v" : 1,
        "key" : {
            "_id" : 1
        },
        "name" : "_id_",
        "ns" : "project1.students"
    },
    {
        "v" : 1,
        "unique" : true,
        "key" : {
            "username" : 1
        },
        "name" : "username_1",
        "ns" : "project1.students",
        "background" : true
    }
]

score 1 · Accepted Answer · answered Jan 11 '17 at 06:46

1

I think your username is indexed and hence whenever you try to insert a doc with the same username this error comes. Indexes should be unique.And if username is not a part of your model can you please tell your models schema.

answered Jan 11 '17 at 06:46

Riya Saxena

99
8

in my model i dont have any username field – MMR Jan 11 '17 at 06:48
can you tell me what exactly is your collection and what are you sending? – Riya Saxena Jan 11 '17 at 06:50
edited my code. – MMR Jan 11 '17 at 06:53
2

Pls check which fileds are indexed using this-> db.getCollection('students').getIndexes(); – Riya Saxena Jan 11 '17 at 06:59
Riya,can you see my edited code. – MMR Jan 11 '17 at 07:13
1

yeah your username is also indexed so pls drop that using-> db.students.dropIndex( "username_1") – Riya Saxena Jan 11 '17 at 07:15
Funtastic......mindblowing............unbelievable....:) Thanks – MMR Jan 11 '17 at 07:17
But one doubht.....i removed it in my db@RoboMOngo is there any scope for removing it from my folder...so that i can commit code and the rest cannot face the same issue. – MMR Jan 11 '17 at 07:21
now there will be no issues as robomongo is just a client for mongodb. So, if you have dropped the index there won't be any issue. – Riya Saxena Jan 11 '17 at 07:23
In production also if i do the same ...its clear? – MMR Jan 11 '17 at 07:38
yeah drop the index from the server where mongodb is hosted. – Riya Saxena Jan 11 '17 at 07:41

MongoError: insertDocument :: caused by :: 11000 E11000 duplicate key error index

1 Answers1