MongoDB, using Mongoose duplicate key error index?

Question

I have a MEN (MongoDB, Express, Node) application, and when i'm inserting the first item everything is fine, but when i want to add a second one I get this error:

E11000 duplicate key error index: local.movies.$title_1 dup key: { : null }

If I then delete the first row, and then insert one item again it works, but again when I want to add a second item I keep getting the error.

I am really pulling my hair on this one, and can't seem to find the problem :(

Hopefully someone can help me :)

Btw how can I access my table from command line? I tried db.movies.find(), movies.find() and other options, but nothing happens, and when i type show collestions I only get system.indexes. And how can i delete the table from command line and try to make a new one?

This is my model:

var mongoose = require('mongoose');
var MovieSchema = require('../schemas/movie');
var Movies = mongoose.model('Movie', MovieSchema);
module.exports = Movies;

This is my schema:

var mongoose = require('mongoose');
var MovieSchema = new mongoose.Schema(
        {
            movieTitle: { type: String, required: true, index: { unique: true } },
            movieYear: { type: String, required: true },
            movieDirector: { type: String, required: true },
            movieImdbLink: { type: String, required: true }
        }
    );
    module.exports = MovieSchema;

I've also tried without index, movieTitle: { type: String, required: true }

This is my insert/update function:

// insert/update movie
exports.save = function(req, res){
    var _id = (req.body._id !== 'undefined') ? req.body._id : null;
    var movieTitle = req.body.movieTitle;
    var movieYear = req.body.movieYear;
    var movieDirector = req.body.movieDirector;
    var movieImdbLink = req.body.movieImdbLink;
    var movie = null;
    if(_id){
        var query = {_id: _id};
        Movies.update(
            query,
            {
                $set:{
                    movieTitle: movieTitle,
                    movieYear: movieYear,
                    movieDirector: movieDirector,
                    movieImdbLink: movieImdbLink
                }
            },
            {safe:true},
            function(err, result, raw){
                if(err){
                    console.log(err);
                    res.send(500);
                }
                else{
                    res.send(200);
                }
            }
        );
    }
    else{
        movie = new Movie(
            {
                movieTitle: movieTitle,
                movieYear: movieYear,
                movieDirector: movieDirector,
                movieImdbLink: movieImdbLink
            }
        );
        movie.save(function(err){
            if(err){
                res.redirect('/movies/?msg=' + err.message);
            }
            else{
                res.redirect('/movies');
            }
        });
    }
};

Whoa there! Please just show us what you did that resulted in the error. Too much noise. Please edit. — Neil Lunn
– Neil Lunn, Commented Mar 12, 2014 at 15:58
@user1906437 don't edit anything - this exactly enough noise to help me out although I can't solve your problem I did learn something from your post - what did you end up doing? — headwinds
– headwinds, Commented Jul 10, 2014 at 12:37

gtsouk · Accepted Answer · 2014-03-12 15:59:42Z

3

movieTitle has an index with unique:true. This index is created when the app is started for the first time. The rest of the times, mongoose checks to see if the index exists. If it doesn't it will create it.

When you remove the unique declaration, mongoose doesn't recreate the index as you would excpect. Maybe in feature versions it will.

You have to manually drop the index (see mongo docs), or the whole db.

After restarting your app the new index will be created.

I hope that helps

answered Mar 12, 2014 at 15:59

gtsouk

5,2631 gold badge30 silver badges35 bronze badges

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

4 Comments

user1906437 Over a year ago

Thx for your reply, but I'm not sure what to do, and can't seem to get access to my collections by commandline, t drop indexes or the whole db.

gtsouk Over a year ago

Do you have a local mongodb installation?

gtsouk Over a year ago

From the command line you can try "mongo <thenameofmydb>" and then db.dropDatabase()

namhnz Over a year ago

In MongoDB Compass on Windows, you can go to the collection, and then remove the field removed from unique declaration

Ravi Joshi · Accepted Answer · 2017-05-15 17:10:33Z

0

Mongoose doesn't recreate index

So, if you had created a index with unique equal to true it cant be changed until either index is dropped or db is dropped.

So simply drop either your database or tittle index and recreate it with unique=false

answered May 15, 2017 at 17:10

Ravi Joshi

6717 silver badges6 bronze badges

Collectives™ on Stack Overflow

MongoDB, using Mongoose duplicate key error index?

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related