MongoDB数据填充时遇ValidationError: ObjectId转换失败求助

错误场景 #

填充MongoDB种子数据时触发ValidationError，提示_id字段无法将字符串值转换为ObjectId，错误栈如下：

ValidationError: food validation failed: _id: Cast to ObjectId failed for value "1" (type string) at path "_id" because of "BSONError"
    at model.Document.invalidate (/backend/node_modules/mongoose/lib/document.js:3157:32)
    at model.$set (/backend/node_modules/mongoose/lib/document.js:1453:12)
    at model.set (/backend/node_modules/mongoose/lib/helpers/document/compile.js:205:19)
    at model.idSetter (/backend/node_modules/mongoose/lib/helpers/schema/idGetter.js:41:12)
    at VirtualType.applySetters (/backend/node_modules/mongoose/lib/virtualtype.js:166:16)
    at model.$set (/backend/node_modules/mongoose/lib/document.js:1271:12)
    at model.$set (/backend/node_modules/mongoose/lib/document.js:1113:16)
    at model.Document (/backend/node_modules/mongoose/lib/document.js:164:12)
    at model.Model (/backend/node_modules/mongoose/lib/model.js:122:12)
    at new model (/backend/node_modules/mongoose/lib/model.js:4682:15)

相关代码 #

Food模型（TypeScript） #

export interface Food {
    id: string;
    name: string;
    price: number;
    tags: string[];
    favorite: boolean;
    stars: number;
    imageUrl: string;
    origins: string[];
    cookTime: string;
    url: string;
}

export const FoodSchema = new Schema<Food>(
    {
        name: {type: String, required: true},
        price: {type: Number, required: true},
        tags: {type: [String], required: true},
        favorite: {type: Boolean, default: false},
        stars: {type: Number, required: true},
        imageUrl: {type: String, required: true},
        origins: {type: [String], required: true},
        cookTime: {type: String, required: true},
        url: {type: String, required: true},
    }, {
        toJSON: {
            virtuals: true
        },
        toObject: {
            virtuals: true
        },
        timestamps: true
    }
);

export const FoodModel = model<Food>('Food', FoodSchema);

种子数据接口 #

router.get("/seed", asynceHandler(
    async (req,res)=>{
        const foodsCount = await FoodModel.countDocuments();
        if(foodsCount>0){
            res.send("Seed is already done");
            return;
        }
        await FoodModel.create(sample_foods);
        res.send("Seed is done")
    }
))

问题原因 #

Mongoose默认会创建名为id的虚拟属性，自动将MongoDB默认的ObjectId类型主键_id转换为字符串返回。当你的Food接口定义了id字段，且种子数据sample_foods中包含类似id: "1"的字符串值时，Mongoose会尝试将该值赋值给_id字段，而字符串"1"无法转换为合法的ObjectId，因此触发ValidationError。

解决方案 #

方案1：移除种子数据中的id字段 #

如果不需要自定义主键，直接删除sample_foods里的所有id字段，MongoDB会自动为每个文档生成合法的ObjectId类型_id，同时Mongoose的虚拟id会自动将_id转为字符串供业务使用。

方案2：自定义合法的_id值 #

如果需要手动指定_id，确保种子数据里的id值是合法的ObjectId字符串，可通过Mongoose生成：

import mongoose from 'mongoose';

const sample_foods = [
  {
    id: mongoose.Types.ObjectId().toString(),
    name: "示例美食",
    // 其他字段...
  }
];

方案3：将id作为独立业务字段 #

如果想保留id作为独立业务字段而非主键映射，需要在Schema中显式定义id，并关闭Mongoose默认的id虚拟属性：

export const FoodSchema = new Schema<Food>(
    {
        id: {type: String, required: true}, // 显式定义id为普通字符串字段
        // 其他原有字段...
    }, {
        toJSON: {
            virtuals: true
        },
        toObject: {
            virtuals: true
        },
        timestamps: true,
        id: false // 关闭默认的id虚拟属性，避免和业务字段冲突
    }
);

这种方式下，id会作为普通字符串字段存储，不再和_id关联，种子数据里的id: "1"可正常存入。

内容的提问来源于stack exchange，提问作者poshy23