Node.js/Express/Mongoose项目MongoDB数据填充连接报错

问题描述 #

我在Node.js+Express+Mongoose项目中尝试给MongoDB填充数据，MongoDB已经启动，但运行$ node product-seeder.js时出现如下报错：

(node:2810) UnhandledPromiseRejectionWarning: Error: Invalid schema, expected mongodb or mongodb+srv

错误栈信息：

at module.exports (/Users/MXD/Sites/adx/hosted/ShoppingCartwithNodeJSExpressAuthentic/shopping-cart/node_modules/mongodb/lib/url_parser.js:15:21)
at Promise (/Users/MXD/Sites/adx/hosted/ShoppingCartwithNodeJSExpressAuthentic/shopping-cart/node_modules/mongoose/lib/connection.js:330:5)
at new Promise ()
at NativeConnection.Connection.openUri (/Users/MXD/Sites/adx/hosted/ShoppingCartwithNodeJSExpressAuthentic/shopping-cart/node_modules/mongoose/lib/connection.js:329:17)
at Mongoose.connect (/Users/MXD/Sites/adx/hosted/ShoppingCartwithNodeJSExpressAuthentic/shopping-cart/node_modules/mongoose/lib/index.js:206:15)
at Object. (/Users/MXD/Sites/adx/hosted/ShoppingCartwithNodeJSExpressAuthentic/shopping-cart/seed/product-seeder.js:5:10)
at Module._compile (module.js:660:30)
at Object.Module._extensions..js (module.js:671:10)
at Module.load (module.js:573:32)
at tryModuleLoad (module.js:513:12)
at Function.Module._load (module.js:505:3)
at Function.Module.runMain (module.js:701:10)
at startup (bootstrap_node.js:193:16)
at bootstrap_node.js:617:3

我的product-seeder.js代码如下：

var Product = require('../models/product');
var mongoose = require('mongoose');
mongoose.connect('localhost:27017/shopping');
var products = [
  new Product({
    imagePath: 'images/black_tee_flagship_p_symbol_right_340x380.png',
    title: 'Black Tee White P',
    description: 'P on chest [white], symbols on sleeve',
    price: 28
  }),
  new Product({
    imagePath: 'images/white_tee_purple_eye_pocket_340x380.png',
    title: 'White Tee Purple Eye',
    description: 'Embroidered Purple Eye',
    price: 28
  }),
  new Product({
    imagePath: 'images/black_tee_gold_dual_p_center_340x380.png',
    title: 'Black Tee Gold 2Ps',
    description: 'Black Tee 2Ps on Chest [gold]',
    price: 28
  }),
  new Product({
    imagePath: 'images/white_tee_p_symbol_popular_text_340x380.png',
    title: 'White Tee Purple P',
    description: 'P Logo + POPULAR underneath',
    price: 28
  }),
  new Product({
    imagePath: 'images/black_tee_blue_dual_p_symbol_right_dual_p_left_340x380.png',
    title: 'Black Tee Blue 2Ps',
    description: '2Ps on chest, symbols + 2ps on sleeve',
    price: 28
  }),
  new Product({
    imagePath: 'images/white_tee_popular_blackboxed_center_340x380.png',
    title: 'White Tee POPULAR',
    description: 'POPULAR on chest [white on black]',
    price: 28
  })
];
var done = 0;
for (var i = 0; i < products.length; i++) {
  products[i].save(function(err, result) {
    done++;
    if (done === products.length) {
      exit();
    }
  });
}
function exit() {
  mongoose.disconnect();
}

解决方案 #

这个错误的根源非常直接：Mongoose的连接URL缺少了必填的协议前缀。Mongoose要求连接字符串必须以mongodb://（本地/常规MongoDB服务）或mongodb+srv://（MongoDB Atlas等托管服务）开头，你直接写localhost:27017/shopping会导致URL解析器无法识别正确的协议，从而抛出这个错误。

1. 修正连接字符串 #

把代码里的连接语句：

mongoose.connect('localhost:27017/shopping');

修改为：

// 本地MongoDB服务使用mongodb://前缀
mongoose.connect('mongodb://localhost:27017/shopping');

如果你的MongoDB是托管在云端（比如MongoDB Atlas），则需要使用srv格式的URL，类似：

mongoose.connect('mongodb+srv://<username>:<password>@cluster0.mongodb.net/shopping?retryWrites=true&w=majority');

2. 增加连接错误处理（推荐） #

为了更直观地排查后续可能出现的连接问题（比如服务未启动、端口占用、权限问题等），建议给mongoose.connect添加promise的then/catch回调：

mongoose.connect('mongodb://localhost:27017/shopping')
  .then(() => console.log('✅ MongoDB连接成功，开始填充数据...'))
  .catch(err => {
    console.error('❌ MongoDB连接失败:', err);
    process.exit(1); // 连接失败时退出脚本
  });

3. 可选：优化数据填充逻辑 #

原代码里的循环+计数器方式虽然能工作，但可以用Promise.all来简化，让代码更简洁易读：

// 替换原有的for循环和done计数器
Promise.all(products.map(product => product.save()))
  .then(results => {
    console.log(`✅ 成功填充${results.length}条产品数据`);
    exit();
  })
  .catch(err => {
    console.error('❌ 数据填充失败:', err);
    exit();
  });

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