node.js - findAndModify mongodb 中的错误 - nodejs - 错误代码 17287

Question

我收到以下错误:

MongoError: exception: nextSafe(): { $err: "Can't canonicalize query: B adValue bad sort specification", code: 17287 }

functions.getNextIndex = function(callback){

    db.collection('counters').findAndModify(
            {_id:'productId'},
            {$inc: {sequence_value:1}},

            function(err,data){
                if(!err)
                    callback(data);
                else
                    callback(err);
    });

}

Answer 1

您的查询中似乎缺少“排序”参数。

尝试如下:

db.collection('counters').findAndModify(
    {_id:'productId'},
    {_id:'descending'},
    {$inc: {sequence_value:1}},

    function(err,data){
        if(!err)
            callback(data);
        else
            callback(err);
});

在这里查看更多内容: http://docs.mongodb.org/manual/reference/method/db.collection.findAndModify/