Log file Viewer

[02:50:28] <Nyterax> Hi, can anyone look at my problem? https://stackoverflow.com/questions/33359135/find-a-document-that-contains-a-specific-value-in-an-array-but-not-if-its-the-l

[06:05:15] <sabrehagen> if i have an single index on field a, and an single index on field b, and i query .find({ a : 'a', b : 'b' }) will this use the indexes, or do i need a compound index?

[07:39:19] <aps> Hi all. I see that "Package python-pymongo-2.5.2-3.el6.x86_64 already installed and latest version" on my instance running Amazon Linux, but I'm unable to import it in python.

[07:39:19] <aps> Any ideas?

[09:39:20] <Etchira> Hello, I'll like to know if I can convert a BSONObject to a BsonDocument?

[10:01:10] <Etchira> Hello, I'll like to know if I can convert a BSONObject to a BsonDocument/Value/Element?

[11:44:12] <sabrehagen> where's StephenLynx when you need him...

[11:44:20] <StephenLynx> wot

[11:44:41] <sabrehagen> if i have an single index on field a, and an single index on field b, and i query .find({ a : 'a', b : 'b' }) will this use the indexes, or do i need a compound index?

[11:45:21] <StephenLynx> no idea

[11:46:03] <sabrehagen> well that's a surprise

[11:46:52] <StephenLynx> v:

[13:02:17] <deathanchor> hoy folks, so anyway to use CLI mongo with a js file to run on secondaryOnly through a mongos connection?

[13:33:28] <episage> How to get an array element from a findOne result? Query is: db.getCollection('contest_a').findOne({ 'files': { $elemMatch: {'filename': 'a440ca8f0638458fdcb7c6c70184ae9c' } } })

[13:33:49] <episage> It contains an array of elements but I just want the element im querying filename for

[13:43:24] <deathanchor> episage: loop through the array on the application side

[13:43:43] <episage> deathanchor: isn't there any db way of doing it?

[13:44:09] <deathanchor> db returns documents, not process sub-docs

[13:44:32] <deathanchor> any processing would happen on the application side

[13:45:22] <episage> hmm.. so actually i should save the fileinfo data in separate document and link it via a key?

[14:51:28] <dbclk> hey guys

[14:51:30] <dbclk> i have a question

[14:51:36] <dbclk> i just tried doing rs.status()

[14:51:44] <dbclk> seeing one of my replica set marked as "REMOVED"

[14:51:46] <dbclk> any ideas?

[14:52:03] <dbclk> stateStr: REMOVED

[14:52:06] <dbclk> not sure why

[14:57:07] <dbclk> anyone can help me?

[14:57:10] <dbclk> this was removed

[14:57:14] <dbclk> then i readded it back

[14:57:22] <dbclk> it's still marked as "removed"

[15:01:03] <kinlo> can someone confirm that db.upgradeCheckAllDBs() is a 100% readonly operation?

[18:00:05] <frecel> hello

[18:47:33] <Pritchard> ObjectIds work with $in matches on aggregate queries, right?

[18:48:37] <Pritchard> I am using .aggregate( { $match: { user: { $in: userIds } } }, ... where I literally included every ObjectId of userIds that we have, and the aggregate query is returning 0 results when I added that filter. It was previously returning over 100.

[18:49:38] <Pritchard> (I'm using Mongoose in Node.js to clarify on any slight syntactical differences there may be, and the Model.aggregate function)

[19:15:43] <Torkable> after several aggregate functions I end up with documents that look like

[19:15:45] <Torkable> { _id: 561bed08f8f068cd237a3dc1,

[19:15:46] <Torkable> updateDate: Mon Oct 12 2015 11:25:28 GMT-0600 (MDT),

[19:15:47] <Torkable> manager: 561bdd37f8f068cd237a3da2,

[19:15:47] <Torkable> viewDate: Mon Oct 26 2015 09:02:57 GMT-0600 (MDT) }

[19:16:09] <Torkable> I'm trying to compare those two dates

[19:16:33] <Torkable> viewDate: { "$gte": "$updateDate" }

[19:16:47] <Torkable> $match: { viewDate: { "$gte": "$updateDate" }}

[19:16:54] <Torkable> but I get 0 results

[19:17:25] <Torkable> tried adding ISODate("$updateDate")

[19:17:32] <Torkable> but it bombs the query

[19:21:39] <frecel> does anyone know a good tutorial for the initial setup of mongo?

[19:22:35] <frecel> I'm trying to learn how to work with mongodb and I'm constantly running into little issues, I would rather have a tutorial walk me through it rather than me trying to constantly look in the docs for how to solve the next problem I ran into

[19:23:16] <Torkable> what kind of issues

[19:23:21] <Torkable> you just stick documents in it

[19:24:48] <jingalala> I have a set of user records where each record has something like friends[] which is an array. I'm trying to export this into csv and I need something like user_id,friend1; user_id,friend2 etc etc How do I do this?

[19:25:05] <frecel> Torkable: mostly administration issues, I'm developing on Ubuntu 15.10 and I can't even get mongo to run on it. I installed it on one of my 14.04 servers and it fails to start

[19:25:28] <Torkable> weird, defaults have always worked fine for me

[19:25:54] <Torkable> are you installing with an apt package or from source

[19:26:02] <Torkable> would be surprised if install from source failed to run

[19:26:25] <frecel> apt on the 14.04 and I'm getting this: 2015-10-27T15:20:21.531-0400 F CONTROL Failed global initialization: FileNotOpen Failed to open "/var/log/mongodb/mongod.log"

[19:26:40] <Torkable> weird

[19:26:46] <Torkable> could be permission

[19:27:08] <Torkable> im hardly and expert on setting it up though, like I said I usually just install and run it lol

[19:27:30] <Torkable> try running with sudo mebe

[19:27:35] <Torkable> sudo mongod

[19:28:37] <frecel> it returns nothing and doesn't show up in the list of processes

[19:34:38] <Torkable> :(

[19:40:57] <jingalala> Is it possible to create a new collection based on a query?

[19:41:14] <jingalala> My query is something like db.getCollection('user').aggregate( [ { $unwind : "$friends" } ] )

[19:42:44] <jingalala> I need to create a new collection because I'm getting this error db.getCollection('user').aggregate( [ { $unwind : "$friends" } ] )

[19:42:57] <jingalala> **"errmsg" : "exception: aggregation result exceeds maximum document size (16MB)",

[19:49:16] <obiwahn> hi i have a bit trouble with a mongodb 2.4

[19:49:24] <obiwahn> i try to use ssl and passwords

[19:49:52] <obiwahn> i am flollowing: https://docs.mongodb.org/v2.4/administration/security-access-control/

[19:50:06] <obiwahn> but i do not get it straight

[19:50:49] <obiwahn> when i pass --authenticationDatabase empty or with admin i get a connetion

[19:51:06] <obiwahn> but i am not able to show collections or do anything else

[19:51:31] <obiwahn> > show dbs

[19:51:33] <obiwahn> Tue Oct 27 20:34:27.798 listDatabases failed:{ "ok" : 0, "errmsg" : "unauthorized" } at src/mongo/shell/mongo.js:46

[19:53:06] <obiwahn> { "_id" : ObjectId("562fc4ea63ef12c685ceaa75"), "user" : "wurst", "pwd" : "3899a929f94a2brote16c59bbc9df613", "roles" : [ "userAdminAnyDatabase" ]

[19:56:39] <jingalala> How do I create a new collection based on a query?

[20:10:51] <obiwahn> do i really have to pass the authdb?

[20:36:55] <Porpado> How do I gracefully remove a member from a repl set? In the past, I have done this for maintenance and seen a spike of application errors, presumably because a connection to mongo had already been established when I changed the repl set configuration

[20:38:39] <Torkable> this is killing me

[20:39:01] <Torkable> went ahead and made a SO post, but I'll link here

[20:39:02] <Torkable> http://stackoverflow.com/questions/33377773/mongodb-aggregate-match-on-dates

[20:39:12] <Torkable> can't get these dates to compare correctly

[20:45:10] <PVDM> I'm trying to determine if reducing the size of our documents will reduce our working set? We are storing redundant data in an array in each of our documents (can be thousands of elements), which I am now limiting to 40. That should reduce the size of the collection at fault to 10% of what it was (this is where our bulk is), but in my understanding of the documentation, storage size will not change. After reading up on mongo, I'm not sure i

[20:45:10] <PVDM> reducing documents to 10% of what they were originally will impact the working set? Can someone please help/explain?

[22:44:44] <gdoubleu> any suggestions for a good way to serve files out of gridfs? from what I can tell the gridfs plugins for nginx and fuse are both unmaintained

[23:36:03] <StephenLynx> gdoubleu

[23:36:06] <StephenLynx> I do that with node