Log file Viewer
#mongodb logs for Monday the 8th of February, 2016
[06:50:10] <dorkmafia> if my server is running with ssl how can I connect to it with my client? mongo --ssl --sslPEMKeyFile (does this pem file need to be on the server or do I generate one?) --sslCAFile (is this the path to the pem file on the server??) -u someuser -p somepass
[10:26:27] <djlee> Hi. I have a collection of objects with a location (geopoint) and radius (integer). Is there a way of doing a $near query where the $maxDistance is based on each doc's radius, or do i need to add like a geoCircle to each document first and use an intersect?
[10:30:32] <brokenCode> I am using the Java Driver to interact with mongo but I am getting an the wrong type. Mongo is seeing NumberLong when it should be NumberInt(). How do you force it to a NumberInt
[11:26:04] <yossarianuk> hi - I am setting up replication - I have 3 nodes (2 db servers and an arbiter)
[11:26:28] <yossarianuk> do I need to copy the keyfile to the arbiter also as well as the 2 databases servers ?
[11:55:49] <ams_> I'm running an arbiter with journalling switched off. I find it gets the mongod.lock file hanging around whenever it restarts. Is this expected?
[12:21:27] <yossarianuk> Derick: one last thing (if you are still about) - do I also need to add the same replication lines to mongod.conf ?
[12:40:20] <gzoo> Tell me if I'm sane: I want to copy a mongo db from one host to another directly. Will using tmux/screen and mongodump in it from the target machine to the master machine be fine?
[12:57:42] <Derick> http://pastebin.com/6QhyMHSt « why does "git add <filename>" add *all* changes to the index?!
[15:57:13] <dbackeus> I want to create a unique compound index for two fields, organization_id and slug, but only create the index if slug isn't null
[15:57:45] <dbackeus> can I use a partialFilterExpression for this, if so how would the expression look like?
[15:58:11] <dorkmafia> if my server is running with ssl how can I connect to it with my client? mongo --ssl --sslPEMKeyFile (does this pem file need to be on the server or doif my server is running with ssl how can I connect to it with my client? mongo --ssl --sslPEMKeyFile (does this pem file need to be on the server or doif my server is running with ssl how can I connect to it with my client? mongo --ssl --sslPEMKeyFile (does
[15:58:12] <dorkmafia> this pem file need to be on the server or do I generate one?) --sslCAFile (is this the path to the pem file on the server??) -u someuser -p somepass
[16:01:02] <mylord> How/can I do both $set and $push using 1 update with the official node driver? https://gist.github.com/adaptivedev/96ff5f36b26d4aff0e55
[16:03:05] <Ceunincksken> When moving from a standard Mongo to a Sharded Environment, using a hashed '_id' field as the shard key, the insert performance goes down drastic. How's that's possible? Isn't sharding there to allow better performance?
[16:54:27] <queretaro> there's a collection that grew a lot so I ran 'compact' on it - afterwards, if I do db.collection.stats() I see that the size has decreased a lot, but when running repairDatabase the size gets back to its original size
[16:55:40] <queretaro> the thing is that disk is getting fuller and fuller, and would like to decrease the size of that collection
[19:32:12] <uuanton> anyone knows how to setup route 53 point to replica set ? that if primary is down dns resolve to new primary. Thanks
[19:39:13] <GothAlice> Diggsey: If you examine how db.collection.insert works in the REPL (type: "db.collection.insert" without quotes and press enter) you'll see that it injects an ID if one isn't given, but doesn't, ah, record that fact anywhere.
[19:39:55] <GothAlice> Specifically http://s.webcore.io/1F0b2w0o3F1A < this bit. Now, a few lines later a private variable is updated to track that ID, but AFIK it's not accessible from the REPL itself.
[19:40:48] <uuanton> GothAlice I know mongodb has its own dns resolution but what if primary server is down
[19:40:49] <GothAlice> StephenLynx: Read, Evaluate, Print, Loop — the name for a typical "interactive shell".
[19:41:34] <dbackeus> I want to create a unique compound index for two fields, organization_id and slug, but only create the index if slug isn't null. Can I use a partialFilterExpression for this, if so how would the expression look like?
[19:52:19] <GothAlice> uuanton: MongoDB uses standard OS-level name resolution, AFIK. I.e. resolv() or natural resolution via socket construction. What happens if resolution fails is what you'd expect: things stop working. ;P This typically won't matter during runtime; it matters most during initial connection construction / startup, and any time there's a reconnection needed.
[19:52:45] <GothAlice> uuanton: This is why I have a little management script on all my nodes that automatically updates /etc/hosts with the DNS names of nodes as they come online / go offline. No external DNS dependencies.
[20:09:27] <energizer> How do I group by one field and then count the number of distinct values in another field?
[20:13:40] <deathanchor> energizer: aggregate or write a code snippet to write aggregated info another location.
[20:50:30] <Diggsey> GothAlice: fancy seeing you here :P thanks - I guess I'll just manually add the ID before calling insert