node.js - $接近错误 - 规划器返回错误 : unable to find index for $geoNear query

Question

我在这方面遇到了很大的麻烦。我正在构建一个小 API 来获取给定特定坐标的最接近的存储元素(在 mlab MongoDB 中)。

我想使用 Mongo 自定义查询工具(例如 $near)从数据库中获取最接近的元素。

您可以找到原始存储库 here !

数据

原始数据是一个小的.csv，我将其转换为geojson格式。

这是该 .csv 的简短版本:

这是它的 geojson 版本:

{
  "type": "FeatureCollection",
  "features": [
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [2.4049238868200975, 48.82094216189432]
      },
      "properties": {
        "event_type": "imp"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [2.3645320381923534, 48.816341825787724]
      },
      "properties": {
        "event_type": "imp"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [2.3274838513968072, 48.86982967859056]
      },
      "properties": {
        "event_type": "imp"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [2.23284629237154, 48.89111120713999]
      },
      "properties": {
        "event_type": "imp"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [2.23284629237154, 48.89111120713999]
      },
      "properties": {
        "event_type": "click"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [2.4204737962258305, 48.85038737901075]
      },
      "properties": {
        "event_type": "imp"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [2.4214870126092594, 48.86339618816508]
      },
      "properties": {
        "event_type": "imp"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [2.4144620076022436, 48.876530301936576]
      },
      "properties": {
        "event_type": "imp"
      }
    },
    {
      "type": "Feature",
      "geometry": {
        "type": "Point",
        "coordinates": [2.2470618097659285, 48.88845096504584]
      },
      "properties": {
        "event_type": "imp"
      }
    }
  ]
}

<小时/>

模型

这是使用 mongoose 的架构(如您所见，我确实添加了 2dsphere 索引):

const mongoose = require("mongoose");

const FeatureSchema = new mongoose.Schema({
  type: String,
  geometry: {
    type: { type: String, default: "Point" },
    coordinates: { type: [Number] }
  },
  properties: { event_type: String }
});

FeatureSchema.index({ geometry: "2dsphere" });
const MapEventSchema = new mongoose.Schema({
  type: String,
  features: [FeatureSchema]
});

const MapEvent = mongoose.model("mapEvent", MapEventSchema);

module.exports = MapEvent;

<小时/>

测试

现在这是我正在努力进行的测试(使用 Mocha):

const assert = require("assert");
const MapEvent = require("../src/models/mapEvents");
const fs = require("fs");

describe("Read test", () => {
  // create new room collection because collection is drop between each file
  beforeEach(done => {
    rawJSON = fs.readFileSync("./src/assets/test_assets/read_test.json");
    const parsedContent = JSON.parse(rawJSON);
    const mapEvent = new MapEvent(parsedContent);
    mapEvent
      .save()
      .then(() => {
        done();
      })
      .catch(error => {
        console.error(error);
      });
  });

  it("Find nearest event by coordonates", done => {
    const distance = 1000;
    const lat = 48.86;
    const lon = 2.35;

    function waitForIndex() {
      return new Promise((resolve, reject) => {
        MapEvent.on("index", error => (error ? reject(error) : resolve()));
      });
    }

    MapEvent.findOne({
      geometry: {
        $near: [lat, lon],
        $maxDistance: distance
      }
    })
      //.then(waitForIndex)
      .then(MapEvent.init())
      .then(nearestResult => {
        console.log("------------");
        console.log(nearestResult);
        console.log("------E-----");
        assert(nearestResult);
        done();
      })
      .catch(error => {
        console.error("************");
        console.error(error);
        console.error("******E*****");
      });
  });
}); 

<小时/>

输出

正如您可能注意到的，我注释掉了 waitForIndex()(在相关的 Stackoverflow 问题上查找)以使用 MapEvent.init() 代替(在 github 上查找)。不幸的是，这两种解决方案都给了我相同的错误输出。

Connection is established
  Create test
(node:12483) DeprecationWarning: collection.ensureIndex is deprecated. Use createIndexes instead.
    ✓ MapEvent saving

  Read test
************
{ MongoError: error processing query: ns=babylon_ad_db.mapevents batchSize=1 limit=1Tree: GEONEAR  field=geometry maxdist=1000 isNearSphere=0
Sort: {}
Proj: {}
 planner returned error: unable to find index for $geoNear query
    at queryCallback (/home/geoffrey/babylon-ad/node_modules/mongodb-core/lib/cursor.js:248:25)
    at /home/geoffrey/babylon-ad/node_modules/mongodb-core/lib/connection/pool.js:532:18
    at process._tickCallback (internal/process/next_tick.js:61:11)
  ok: 0,
  errmsg:
   'error processing query: ns=babylon_ad_db.mapevents batchSize=1 limit=1Tree: GEONEAR  field=geometry maxdist=1000 isNearSphere=0\nSort: {}\nProj: {}\n planner returned error: unable to find index for $geoNear query',
  code: 2,
  codeName: 'BadValue',
  operationTime:
   Timestamp { _bsontype: 'Timestamp', low_: 7, high_: 1536667477 },
  '$clusterTime':
   { clusterTime:
      Timestamp { _bsontype: 'Timestamp', low_: 7, high_: 1536667477 },
     signature: { hash: [Binary], keyId: [Long] } },
  name: 'MongoError',
  [Symbol(mongoErrorContextSymbol)]: {} }
******E*****
    1) Find nearest event by coordonates


  1 passing (3s)
  1 failing

  1) Read test
       Find nearest event by coordonates:
     Error: Timeout of 2000ms exceeded. For async tests and hooks, ensure "done()" is called; if returning a Promise, ensure it resolves. (/home/geoffrey/babylon-ad/test/read_test.js)

<小时/>

我已经做了一些谷歌搜索，这就是我听说 $near 和 2dsphere 索引的方式。但我仍然不明白为什么它说找不到索引。即使我用 waitForIndex() 或 MapEvent.init() 等待它。

这个社区创造了一些很酷的奇迹，我希望你能帮助我。

谢谢

Answer 1

此类错误表明索引未创建。通常这是由于坐标数据无效造成的。也许加载您的 mongo shell 并确保您的索引存在:

mongo
use yourdatabasename
db.yourcollection.getIndexes()

你最终应该得到类似的结果:

{
    "v" : 2,
    "key" : {
      "geometry" : "2dsphere"
    },
    "name" : "geometry_2dsphere",
    "ns" : "databasename.yourcollection",
    "2dsphereIndexVersion" : 3
  }

如果不存在，请尝试在 shell 中创建索引 - 如果无法创建索引，则会抛出错误。:

db.yourcollection.createIndex( { geometry : "2dsphere" } )