Mongoose – caused by :: 11000 E11000 duplicate key error index?

by

You initially had a field called name in your schema, that was set to unique.

How do I know? Because of the error telling me so:

duplicate key error index: **iotdb.users.$name_1**

You renamed the field to username, but didn’t remove the old index. By default, MongoDB will set the value of a non-existent field to null in that case.

Relevant documentation here:

If a document does not have a value for the indexed field in a unique index, the index will store a null value for this document. Because of the unique constraint, MongoDB will only permit one document that lacks the indexed field.

To solve this, you need to remove the index for the renamed name field.

More Related Contents:

  1. Push items into mongo array via mongoose
  2. Avoid “current URL string parser is deprecated” warning by setting useNewUrlParser to true
  3. Cannot overwrite model once compiled Mongoose
  4. MongoDB/Mongoose querying at a specific date?
  5. add created_at and updated_at fields to mongoose schemas
  6. How to populate a sub-document in mongoose after creating it?
  7. mongoose custom validation using 2 fields
  8. How to protect the password field in Mongoose/MongoDB so it won’t return in a query when I populate collections?
  9. Mongoose update without callback
  10. How to fix ‘Error: querySrv EREFUSED’ when connecting to MongoDB Atlas?
  11. Model.find() returns empty in mongoose [duplicate]
  12. Unable to delete data from mongoDB
  13. collection is not defined in mongodb
  14. Stop Mongoose from creating _id property for sub-document array items
  15. Populate nested array in mongoose
  16. ERR_HTTP_HEADERS_SENT: Cannot set headers after they are sent to the client
  17. Mongoose Schema hasn’t been registered for model
  18. Mongoose findByIdAndUpdate not returning correct model
  19. TypeError: db.collection is not a function
  20. Mongoose duplicate key error with upsert
  21. How can I use a cursor.forEach() in MongoDB using Node.js?
  22. MongoNetworkError: failed to connect to server [localhost:27017] on first connect [MongoNetworkError: connect ECONNREFUSED 127.0.0.1:27017]
  23. Uploading images using Node.js, Express, and Mongoose
  24. Model.find().toArray() claiming to not have .toArray() method
  25. Mongoose optional search query parameters?
  26. Difference between MongoDB and Mongoose
  27. How can I save multiple documents concurrently in Mongoose/Node.js?
  28. set field as empty for mongo object using mongoose
  29. Mongoose overwrite the document rather that `$set` fields
  30. Create unique autoincrement field with mongoose [duplicate]

Leave a Comment