MongoError:E11000重复密钥错误集合：myFirstDatabase。tours索引：rating_1 dup键：{rating:null}

Question

MongoError:E11000重复密钥错误集合：myFirstDatabase。tours索引：rating_1 dup键：{rating:null}

当我使用postman创建数据时，我不理解这个错误，说dup key:{rating:null}，在shcema中没有任何评级键，这是从哪里来的？为什么我只能创作一次。

这是我的代码（tourSchema）

const mongoose = require('mongoose');

const tourSchema = new mongoose.Schema({
 name:{
    type:String, 
    required:[true, 'tour must have name'], 
    unique:true,
    trim: true
},
ratingAverage: Number,
ratingQty:Number,
discount:Number,
price:{
    type:String, 
    required:[true, 'tour must have price']
},
summary:{
    type:String, 
    required:[true, 'tour must have summary'],
    trim:true
},
description:{
    type:String, 
    trim:true
},
imageCover:{
    type:String, 
    required:[true, 'tour must have imageCover'],
    trim:true
},
images: [String],
createdAt:{
    type:Date,
    default:Date.now()
},
startDate:[Date]
})
const Tour = mongoose.model('Tour', tourSchema);

 module.exports = Tour;

这是我试图添加的数据

{
"name":"the mountain explorer",
"ratingAverage":4,
"ratingQty":1,
"price":400,
"summary":"this is mountain explorer near to solua, best known for the river around it",
"description":"this mountain is located at the top of siraha mountain, has so many rivers around it",
"imageCover":"nepal_tour_cover-1.jpg",
"images":["nepal_tour-1.jpg", "nepal_tour-2.jpg", "nepal_tour-3.jpg"],
"startDate":["2020-03-12,12:44", "2020-04-12,12:54"]

}

Answer 1

您在该集合中有一个唯一的评级索引。由于添加时未指定评级，因此评级为空，因此在第一次添加后出现此错误。由于您尝试添加的后续数据也没有评级，因此它们的评级为空，这与索引冲突。

首先，前往您的mongo控制台。

运行此命令

db.<collection>.getIndexes()

你应该有这样的记录

{
    "v" : 2,
    "unique" : true,
    "key" : {
        "rating" : 1
    },
    "name" : "rating"
}

接下来，运行此命令删除索引

db.<collection>.dropIndex("<index name>")