mongoose attempting to create index every time I start the server | Index with pattern: already exists with different options

manpreet Best Answer 2 years ago

my schema:

var courseSchema = mongoose.Schema({
    title: {
        type: String
    },
    instructors: {
        type: String
    },
    .
    .    
  fields: {type: [String], text: true},
  created_at: Date,
  updated_at: Date
});

courseSchema.index({title: 'text', subject: 'text', summary: 'text', syllabus: 'text'});

var Course = mongoose.model('Course', courseSchema);
module.exports = {Course};

searching text:

Course.find(
            { $text: { $search: req.query.title } },
            { score: { $meta: "textScore" } }
        ).sort( { score: { $meta: "textScore" } } 

    )

when I start the server it gives the error:

MongoError: Index with pattern: { _fts: "text", _ftsx: 1 } already exists with different options

I have tried to drop the index by using

db.courses.dropIndex('title_text_subject_text_summary_text_syllabus_text');

but when I restart the server, it again gives the same error and I can find that index with key _fts and _ftsx are already there.

Which step am I doing wrong? Thanks in advance.

edit: there was this field that I didn't add in the question which was creating the index. I removed it, its working fine.

fields: {type: [String], text: true},

manpreet 2 years ago