Log file Viewer
#mongodb logs for Tuesday the 29th of April, 2014
[00:32:09] <the8thbit> I want to sort a collection by a field inside of a subdocument inside of an array. Is this possible?
[00:34:56] <the8thbit> I have a collection called 'badges' and each badge has an array of 'owners', and each owner has a 'username' and a 'date'.
[00:38:39] <joannac> I think no, this is what I was thinking of http://docs.mongodb.org/manual/reference/operator/projection/positional/#sorts-and-the-positional-operator
[00:44:59] <the8thbit> Can I get the M102 lectures online anywhere, or do I have to sign up for the course?
[03:44:37] <tpayne> Hello. how can i return just a single specified value in an array? Like ["1","2","3"]
[12:24:14] <eskatrem> hey, noob question here: I have mongodb running on machine A, and typing on machine B: mongo --host myIp --post myPort gets me a "connection refused"
[12:34:46] <thanasisk> how can i install 2.6.1-rc0 on ubuntu 12.04? apt-get install mongodb will install 2.6.0 (which owing to a bug we cannot use)
[12:40:07] <thanasisk> i dont understand what you are trying to say, is this not the mongodb channel?
[12:41:54] <thanasisk> mongodb-org is already the newest version. <— im sure that in another box configured by someone else i could get the 2.6.1-rc0 by apt-get install
[12:47:30] <Nodex> else from source https://fastdl.mongodb.org/linux/mongodb-linux-x86_64-2.6.1-rc0.tgz
[12:58:39] <thanasisk> Nodex: i found out what the issue was https://jira.mongodb.org/browse/SERVER-13691
[13:39:45] <miqui> newb question: i realize that the OS will manage mem for mongodb's cache mem, etc..etc.. but just wondering i have a small collection to deal with with(< 40 objects)
[13:43:27] <Nodex> but seeing as there is a 16mb limit on documents currently then you should be fine :)
[13:44:44] <miqui> Nodex: if true that mongo will release its cached ram because the OS asked it to for another process...and then i can live with that..
[13:45:49] <miqui> Nodex: want to replace mysql (very small db, one table 20 records, key/val pairs)
[13:49:34] <Nodex> and yes it applies to all *nix based OS's as far as I know. I couldn't comment on winblows or freebsd though as I don't use them
[14:19:36] <pure> So, I'm using the C# driver. If I do something like 'collection.FindOneById<Entity>().Name = "foo";' do I need to explicitly call collection.Save() or collection.Update()?
[14:47:57] <pure> So it might be a good idea to put a collection.Update() call in my property setter?
[15:57:09] <ninja_p_> when creating an index using the php client is order important? - we create the index on the server with ensureIndex({a,1,b:1,c:1}) but adding via PHP leaves no way to ensure the attribute order (its just an assoc array)
[16:30:17] <gsd> is there a mongo call that will show me the connection pool stats, like the number of avail connections in the pool
[16:54:37] <hydrajump> if you use pymongo and save a query in the var cursor. when you loop through the docs in the cursor how can you skip every other result. It's probably more a python question but I thought I'd try here
[18:04:20] <moleWork> whenever i restart the mms monitoring agent... it won't reconnect to my server, it says "Either not primary agent, or no hosts configured. Sleeping...
[18:35:04] <NaN> how can I update an inside doc if the inside doc is in an array? { foo: [ bar: { baz: true }, baar: { baz: false } ] } <<< update foo.baar.baz ?
[18:38:23] <Edravis> Hi! I think I found a small error in the web mongodb manula, how can I report it?
[18:57:53] <NaN> I don't get it... why find({_id: ..., foo.baar: { $exists: true }) works but find({_id: ...}) doesn't?
[19:16:17] <skot> NaN: because the the positional operator ($) is just a specific array element which is replaced during the update, if your query doesn't query an array, then it can't match anything.
[19:23:46] <frodo_baggins> I keep getting: planner returned error: need exactly one text index for $text query, at the beginning of my code I call db.<collection>.ensureIndex({"text": 1}, callback);
[19:24:44] <moleWork> how do you set "client name" in node.js native driver with a description... like instead of conn1-10 i can set it to myapp1-10
[19:25:20] <moleWork> i can see like TTLMonitor and other processes can do it, i was wonder if it was possible to prefix the client in the node.js connection pool options
[19:34:14] <NaN> skot: but find with _id and find with _id and array element gives me the same results
[19:42:15] <skot> NaN, they give you the same document but not the same context in that document for the update.
[19:59:22] <ThePrimeMedian> anyone had this issue? MongoError: exception: nextSafe(): { $err: "Can't canonicalize query: BadValue unknown top level operator: $inc", code: 17287 }
[20:03:11] <ThePrimeMedian> hell_razer: it's a mongoosejs schema call, http://hastebin.com/ifodafofeh.coffee
[20:03:58] <NaN> ranman: thanks man, but what if I need to update another arrays? should I need to include them in the query too?
[20:04:55] <hell_razer> ranman, i am not familiar with mongoose, but your query looks really starnge, what exactly you want to do?
[20:04:55] <ranman> NaN: I'm not super smart and it's hard for me to talk about these things in abstract terms especially when vim is open in another window :P
[20:05:12] <hell_razer> ThePrimeMedian i am not familiar with mongoose, but your query looks really starnge, what exactly you want to do?
[20:06:22] <ThePrimeMedian> hell_razer: i just want to update the doc, increment the counter, and if not exist create the document with a count of one.
[20:13:09] <hell_razer> ThePrimeMedian http://docs.mongodb.org/manual/reference/method/db.collection.findAndModify/#upsert
[21:16:45] <frodo_baggins> I've managed to create a text index, but when I do a search, I get null for the results. Code here: https://gist.github.com/blafreniere/e6cc730e6b00330af0d2
[23:38:40] <xissburg> thatcher: http://www.raywenderlich.com/61078/write-simple-node-jsmongodb-web-service-ios-app
[23:38:43] <xissburg> TheFinal: http://www.raywenderlich.com/61078/write-simple-node-jsmongodb-web-service-ios-app
[23:42:55] <mfen> i'm using mongoengine in python but i sudently have need to learn how to do raw mongo queries
[23:43:08] <mfen> however, none of the examples i've found for doing a query through a dbref seem to work
[23:45:54] <mfen> i can query that object directly through db.user.find. i can query the interview directly with db.interview.find({_id: ObjectId('yyyyy')}
[23:46:34] <mfen> but i can't query the interview by matching through the user object. i don't understand why there's no simple example of this. in any other database it would be a trivial foreign key join. (and mongoengine seems to have no problems doing it.)