"name":"MongoError","ok":0,"errmsg":"can't find ns"

[xiaojunl]

Upgrade from version v3.8.8 to v3.8.16,invoke getNear.

[vkarpov15]

Hi @xiaojunl , can you provide me some standalone code that reproduces this?

[xiaojunl]

ShopModel.geoNear([121.600590,31.198366], {geoNear: 'name', spherical: true, distanceMultiplier: 6371, num: 100, maxDistance: 20 / 6371, query: {'traffic.status': 'on', name: {$regex: word}}}, function (err, shops, stats) { ... }

[vkarpov15]

Thanks for that. This will go faster if you provide one standalone file that reproduces this that includes schema definitions though :)

[xiaojunl]

Of course :)
var shopSchema = new Schema({
name: String,
imgUrl: String, // icon
traffic: {
status: String,
beginTime: String,
endTime: String
},
delivery: {
status: String,
beginTime: String,
endTime: String,
basePrice: Number,
maxRadius: Number,
isCity: String
},
address: {
loc: {type: [Number], index: '2dsphere', sparse: true},
full: String
},
_shopCate: {type: Number, ref: 'ShopCate'},
_parentId: { type: Number, ref: 'Shop' },
vet: {
status: Number, // ∈{0,1,2}
reason: String
},
area: Number,
type: Number,
deleteFlg:Number,
level: Number,
createTime: Number,
modifyTime: Number
});

[327]

@vkarpov15
hello,
do you have any solution for the "can't find ns"?

[vkarpov15]

@327 this is caused by you putting that geoNear option. That's for some reason overwriting the namespace used for the underlying geoNear command (that's a bug).

Replace:

ShopModel.geoNear(
  [121.600590,31.198366],
  {
    geoNear: 'name', // <--- This is the bad option
    spherical: true,
    distanceMultiplier: 6371,
    num: 100,
    maxDistance: 20 / 6371,
    query: {'traffic.status': 'on', name: {$regex: word}}},
    function (err, shops, stats) { ... });

With:

ShopModel.geoNear(
  [121.600590,31.198366],
  {
    spherical: true,
    distanceMultiplier: 6371,
    num: 100,
    maxDistance: 20 / 6371,
    query: {'traffic.status': 'on', name: {$regex: word}}},
    function (err, shops, stats) { ... });

And you should stop getting that error.

[vkarpov15]

Further clarification: specifying 'name' is not necessary there - since there can only be one 2d index on an object, there's no need to tell geoNear which field to use

[327]

@vkarpov15 thank you very much !
These code in my project is worked well:

$mongo = new MongoClient("mongodb://admin:123456@127.0.0.1");
$d = $mongo->selectDB('Ituji');
$d->selectCollection('UserInfo')->ensureIndex(array('loc' => '2dsphere'));
$query = array(
    'geoNear' => "UserInfo",
    "distanceField" => "dist.calculated",
    "near" => array("type" => "Point", "coordinates" => [$lng, $lat]),
    "spherical" => true,
    "num" => $num);
$result = $d->command($query);

hope it's useful for other people

[xiaojunl]

right，resolved.