特定NodeJS应用Mongoose聚合报'cursor'选项必填错误的解决方法

Hey there! Let's break down why you're hitting this error and how to fix it quickly.

What's Causing This? #

This error typically pops up due to version compatibility issues between Mongoose and your MongoDB server:

• MongoDB 3.6+ requires that aggregate operations explicitly specify a cursor option (unless you're using explain).
• Older versions of Mongoose (pre-5.x, for example) might not automatically add this cursor option when talking to newer MongoDB servers.
• Since your app works elsewhere and other apps in the same system are fine, it's likely that either:
  1. The current environment runs a newer MongoDB server than where your app works normally, or
  2. The other apps in the system use a newer Mongoose version that handles this requirement automatically.

Fix 1: Explicitly Add the Cursor Option #

The simplest fix is to manually attach a cursor call to your aggregate chain. Here's how to update your code:

function getTestParams(testconductedid, mark) {
  return new Promise(function (resolve, reject) {
    Mark.aggregate([
      { $match: { testconductedid: testconductedid } },
      { $group: { _id: '$testconductedid', max: { $max: '$total' } } }
    ])
    // Add this line to use default cursor settings
    .cursor({})
    .exec(function(err, result) {
      if (err) reject(err);
      else resolve(result);
    });
  });
}

If you prefer leveraging Mongoose's built-in Promise support (to avoid wrapping in a new Promise), you can rewrite it like this:

async function getTestParams(testconductedid, mark) {
  try {
    const result = await Mark.aggregate([
      { $match: { testconductedid: testconductedid } },
      { $group: { _id: '$testconductedid', max: { $max: '$total' } } }
    ]).cursor({}).exec();
    return result;
  } catch (err) {
    throw err;
  }
}

Fix 2: Upgrade Mongoose to a Compatible Version #

If you're running an older Mongoose version, upgrading it will resolve this issue permanently (newer versions automatically handle the cursor requirement for MongoDB 3.6+). Run this command to install the latest stable version:

npm install mongoose@latest --save

If your Node.js version is older (e.g., Node 12 or below), install a compatible legacy version instead:

npm install mongoose@5.x --save

Fix 3: Verify MongoDB Server Version (Optional) #

If you have access to the problematic environment's MongoDB server, check its version with:

mongod --version

If it's 3.6 or newer, either of the above fixes will work. If it's older, there might be another underlying issue—but since your app works elsewhere, this is less likely.

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