Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MongoDB: Error executing stored JavaScript function

When I run below stored JavaScript function I get errors:

> db.system.js.save({_id:"last_n_users", value: function(n){return db.users.find().sort({created_at:-1}).limit(n)}})
> db.eval("last_n_users(10)")

Here is the errors:

{ "value" : "DBQuery: store.users -> undefined" }

Why? Please help me?

like image 279
Zeck Avatar asked Oct 09 '11 01:10

Zeck


1 Answers

The find() function returns a cursor, which can't be returned from JavaScript. The suggested workaround is to use toArray() to get an array return value.

Example ... before :

> use admin
switched to db admin
> db.system.js.save( { _id : "foo", value: function(n){return db.system.indexes.find().limit(n)} } )         
> db.eval( "foo(3)" )                                                                               
{ "value" : "DBQuery: admin.system.indexes -> undefined" }

just as you describe.
And after:

> db.system.js.save( { _id : "foo", value: function(n){return db.system.indexes.find().limit(n).toArray()} } )
> db.eval( "foo(3)" )                                                                                         
[
        {
                "name" : "_id_",
                "ns" : "admin.system.users",
                "key" : {
                        "_id" : 1
                }
        },
        {
                "name" : "user_1",
                "ns" : "admin.system.users",
                "key" : {
                        "user" : 1
                },
                "unique" : false
        },
        {
                "name" : "_id_",
                "ns" : "admin.whee",
                "key" : {
                        "_id" : 1
                },
                "v" : 0
        }
]
like image 93
dampier Avatar answered Nov 15 '22 07:11

dampier