Log file Viewer
#mongodb logs for Tuesday the 22nd of September, 2015
[03:44:54] <csalvato> Oh, I forgot - I have a question. If one wanted to learn MongoDB from the ground up, what do you guys think is the #1 best way to do that? Best book/tutorial, for example?
[03:58:48] <Boomtime> it's surprisingly good, watch videos, do stuff with the db, run it locally, and take little quizzes from time to time
[03:59:19] <Boomtime> there are also some courses for specific languages if you'd prefer to learn it via C#, Java etc
[04:02:17] <csalvato> I wanna learn MongoDB, ElasticSearch, RethinkDB, Redis and PostgreSQL end to end
[04:15:09] <nofxx> csalvato, hehe you named every DB we use. Only we're not using so much anymore is PG, and rething starting a project concept
[04:16:28] <nofxx> usually all stuff is on mongo, redis is used a lot, background jobs to queues and caches and whatnot
[04:16:46] <nofxx> ES.. well... full text,.... How I wish there was a non-java alternative.. but anyways
[04:18:57] <nofxx> guess they were waiting for the new engine thing settles? Plugin same as wiretiger I believe.
[05:56:00] <nerd> hello guys :) i am new to DB thing, just starting up, so should i start with learning mondodb or mysql ?
[06:01:05] <Boomtime> not sure about that - but the next course starts in like 2 weeks or something..
[06:01:27] <nerd> i am quite impatient to wait 2 weeks, in a mood to start learning straight away :)
[06:08:11] <nerd> how about getting this one http://www.amazon.com/MongoDB-Definitive-Guide-Kristina-Chodorow/dp/1449344682/ref=sr_1_1?s=books&ie=UTF8&qid=1442901733&sr=1-1&keywords=mongodb
[06:09:23] <Boomtime> it will still give you an excellent introduction, and most things are still relevant
[06:09:46] <Boomtime> it's merely that some things have gone beyond what the book covers, and some things a little different
[09:44:41] <auzty> i'm using mongodb 2.9 , how long string will be possible stored? i want store 1000 words
[10:24:00] <es-kb09222015> <es-kb09222015> hi [15:43] <es-kb09222015> i am using mongodb with codeignitor and the select query is very slow [15:43] <es-kb09222015> please help
[10:25:21] <es-kb09222015> i am using mongodb with codeignitor and the select query is very slow please help
[10:27:37] <es-kb09222015> i am using mongodb with codeignitor and the select query is very slow tryed with limit and where please help
[13:11:35] <antiPoP> Hi, is this syntax correct for finding a subdoc? db.ads.find({type: {_id: '1'}}).pretty() ?
[13:16:19] <antiPoP> deathanchor, the issue is that i'm passing an object to node mongosee , and i was trying to pass the object directly to mongo
[13:19:54] <antiPoP> seems I have to use dot notation as passing an object searches for that exact object, right?
[13:23:28] <deathanchor> find({ "type._id" : { $exists :1 } }) would find doc: { type : { _id : { more : stuff } } }
[13:29:55] <StephenLynx> I suggest you don't use mongoose antiPoP, the syntax it uses is different and confusing.
[13:30:45] <deathanchor> StephenLynx is the anti-mongoose advocate. I never used it. Choose your own evils :)
[13:33:26] <antiPoP> thanks, I'll check it , although at this project is almost completed so I may keep mongosee....
[13:34:57] <antiPoP> btw shoudl I take any security when using mongo? I mean in mysql you need to escape parameters, etc...
[13:36:24] <StephenLynx> if you query using {a:something.X} but something DOESNT have a property X, it will be {a:undefined}, which translates to {}
[13:37:14] <cheeser> if you query against a field that doesn't exist, the find won't return anything.
[13:39:36] <StephenLynx> because on my older ones I would validate the authentication tokens as any other mandatory parameters
[13:40:09] <StephenLynx> but in my last one I changed how I did things and that detail slipped, which allowed users using the json api to use the first account in the database freely
[13:41:02] <cheeser> StephenLynx: interesting. i hadn't thought of that attack vector but i do very little javascript.
[13:42:29] <StephenLynx> and I noticed it allowed me keep using the system, which shouldn't be possible because the account hashed changed
[13:43:34] <StephenLynx> usually when I finish doing something messy I just drop the db and start it over.
[14:04:58] <m3t4lukas> cheeser: I use gradle with 'org.mongodb:mongodb-driver:3.0.2'. com.mongodb.client.MongoCollection<TDocument> seems to not implement findOne(). Is that correct?
[14:06:10] <m3t4lukas> Derick, GothAlice, joannac: also goes to you, I just saw that cheeser wrote something, so I thought it might be a good time to poke it in there
[14:14:33] <cheeser> just bug fixes. 3.1.0-rc0 is out, though, if you're an upgrade junkie like myself.
[14:23:52] <m3t4lukas> macabre: there will be courses starting next month on mongodb academy. Might be worth a shot ;)
[15:17:44] <kedare> I have a little question, when I run sh.status(), I don't get a standard JSON output but a kind of humanized json with sections and title, how can I get pure json ?
[16:30:36] <deathanchor> kedare: https://docs.mongodb.org/manual/reference/method/db.printShardingStatus/#db.printShardingStatus
[19:37:46] <lindenle> HI all. I created a sharded cluster using two replica sets as the shards. Now when i try to insert into a collection that I have sharded it gives me an error about: "no progress was made executing batch write op in test_db.test_collection after 5 rounds". What did I miss?
[19:56:59] <steeze> hey all, trying to do a text search with a phrase that is being programmatically passed in. i tried building a string with the req to match mongodb's documentation but it doesnt seem to be working
[20:00:50] <StephenLynx> this function will have to take its own callback as one of the parameters and execute this callback inside the toArray's callback passing the array of values.
[20:11:17] <steeze> hey all, trying to do a text search with a phrase that is being programmatically passed in. i tried building a string with the req to match mongodb's documentation but it doesnt seem to be working
[20:12:05] <StephenLynx> StephenLynx> you are trying to return the value on an asynchronous function
[20:12:06] <StephenLynx> <StephenLynx> this function will have to take its own callback as one of the parameters and execute this callback inside the toArray's callback passing the array of values.
[20:12:06] <StephenLynx> <StephenLynx> or even better, pass the callback received by it directly to toArray
[20:14:21] <steeze> well, everything is working properly, it jsut doesnt match substrings in text search
[20:15:53] <steeze> i didn't write the returnSearchJson, i'm just trying to get it to match substrings
[20:16:34] <steeze> so yeah i tried building out the query string with double escape and single escape
[20:16:54] <steeze> hardcoding "\"sta\"" in my query works, but not when i pass that exact string in programmatically
[20:23:16] <steeze> im just wanting to quickly return records that have that substring contained anywhere in their text fields
[20:24:23] <steeze> can you elaborate? not sure what regex i would build to match a completely arbitrary search term
[20:25:27] <steeze> maybe i can programmatically build a regex that just matches anything with the substring i pass in
[20:50:13] <mick27> hey folks, should I specify a db for my backup user if I want it to be able to mongodump everything ?
[22:12:56] <MacWinner> is there a bug with the Perl MongoDB package? It seems to use a minimum of 100MB resident ram
[22:23:45] <pasichnyk> I currently am running a cluster of 3 replicasets across a set of servers (each running multiple mongod instances, one per replicaset). I needed to do this to logically partition things, and the sets should fit fine given the server specs. However i'm seeing the mongod processes on one of my sets getting killed of once in a while, due to OOM. This set has a lot of data, and is wiredtiger,
[22:23:46] <pasichnyk> but is basically insert only. It looks like i can tune down my cache size on this set, as i rarely query it. Is that my only option to limit memory on these instances so they don't get killed off randomly?
[22:54:12] <bigstacks_> Got a question about arrays. I have a collection that contains documents which have arrays within them. In this particular case, each document has an array of two integers representing time values. I want to sort the documents based on one of the array values, initially the first.
[22:55:02] <bigstacks_> In other words, each document has a start and an end time, and I want to sort the documents by their start times.