Log file Viewer
#mongodb logs for Thursday the 19th of March, 2015
[00:07:16] <MLM> None of these really jump out at me: http://docs.mongodb.org/ecosystem/tools/administration-interfaces/
[00:22:10] <acidjazz> > db.customer.update( {"_id": "54efa10e86c28789098b4567"}, { $set {"customer.name": "Demo Customer"}});
[00:22:25] <acidjazz> how is this a syntax error.. whats the easiest way to just change a field value??
[00:45:31] <MLM> To follow-up on my question about a good web interface to browse a local MongoDB database. I downloaded MongoVUE: http://www.mongovue.com/ - which seems like it will work well
[00:59:13] <MLM> For reference: http://mongoosejs.com/docs/api.html#document_Document-isModified (not answer)
[01:03:15] <MLM> It could help others get acquainted more quickly with the method you have a question about
[01:24:22] <shlant> can anyone explain why -d isn't working for mongorestore? mongorestore --file /tmp/mongodumps/tv -d db_name
[01:54:50] <kakashiAL> there is a method in mongoose called isModified(), it returns true or false and you can pass a key of your model as an argument for that function, but what I dont understand is does it queries the database to check if the value changed or not?
[02:08:43] <joannac> luaboy: based on what i know of the python driver, it creates a connection to the mongod running at 127.0.0.1:27017, and then sets the "active database" (for lack of a better word) to "stocks"
[02:20:25] <Hoyt> Hi, what's the common solution for this? http://stackoverflow.com/questions/29135598
[03:35:13] <shlant> anyone doing mongorestor with docker? I'm hitting an error and don't know what to do. Not even sure if this is the best way to do it: https://gist.github.com/MrMMorris/ac74af2188483c69eb41
[07:05:34] <joannac> anuvrat: yes, I'm here. I suspect there's probably already something that'll do that for you
[07:17:30] <KekSi> can anyone explain to me what that red paragraph up there means: http://docs.mongodb.org/manual/tutorial/deploy-shard-cluster/ ?
[07:19:38] <KekSi> all my parts do but when i try to add the first shard from a query router (running on the same machine as the shard which should eventually become a replicaset) it connects to the shard
[07:20:12] <KekSi> but shows "couldn't connect to new shard socked exception [CONNECT_ERROR] for ...
[07:37:01] <KekSi> in other words: where do i bind_ip when i'm running all my cluster parts in docker containers? :S
[08:59:44] <robopuff> Hey, can you guys help me with this http://stackoverflow.com/questions/28740593/mongodb-conditional-aggregate
[10:00:25] <robopuff> Is it possible to use $ projection within aggregation framework (especially with $project)?
[10:05:16] <hmsimha> robopuff: $project *is* an aggregation pipeline operator (http://docs.mongodb.org/manual/reference/operator/aggregation/project/) Not sure if that's what you were asking
[10:07:27] <robopuff> hmsimha: I need to get a specific array element to create a proper calculation ($project: { $add: [ ... ] }), and i thought that I could use $(projection) (http://docs.mongodb.org/v2.6/reference/operator/projection/positional/)
[10:15:26] <hmsimha> robopuff: I think you'll find here that the biggest problem (as is often the case) is how you've structured your data. That being said, it may be possible to do what you're trying to do
[10:19:57] <robopuff> I need to calculate price based on calendar entry and if not exist (calendar entry or pricing in it) then add basic price
[10:22:19] <robopuff> Or maybe there is a better way to store that kind of data - at this point there is no problem with redefining this
[10:22:53] <hmsimha> robopuff: are you only intending to match one of the objects in the calendar array?
[10:24:26] <robopuff> hmsimha: all that match dates specified by user, so if user chose a 2015-01-18 to 2015-01-22 I have to calc all entries between those dates
[10:27:21] <hmsimha> if you need to find and project, you can do db.collection.find(... <something with the <array>.$ operator>).project(...)
[10:28:04] <hmsimha> Oh, I'm sorry, I've been using mongoose and it occurs to me this might be a mongoose feature
[10:29:55] <robopuff> Hmmm, mongo tells me that after db.collection.find(...).project() is not a function :(
[10:34:42] <robopuff> But as I said, maybe there is a problem with document structure, but since I'm a complete novice in mongo it's hard for me to find it
[10:35:54] <hmsimha> it's ok. I am also. My first thought would be to take an approach where each of the objects you're putting in the calendar array into their own collection, with each having a reference to the _id from the relevant document in the calendars collection
[10:36:32] <hmsimha> I also believe there are issues with indexing things in mongoDB arrays, so this makes it easier to index these
[10:40:59] <robopuff> hmsimha: It's gonna be hard to split into different documents since I've got to find every entry that status: 1 and between dates provided form user there are no calendar entries with status: false
[10:42:47] <robopuff> Maybe it's gonna be better if I write additional filters not on database side, so everything will be possible, but then I have to filter it & create a pagination on those results (additional database or different document maybe?)
[10:42:54] <hmsimha> I don't understand that robopuff. You're saying you need to search these by date and status
[10:43:32] <hmsimha> lets say each of those things in the calendar array goes into a callendarobject collection
[10:43:58] <robopuff> Yup, searching through them is not a problem - I've done it already, but as an addition I need to calculate overall price and filter by it
[10:43:58] <hmsimha> except each of those has an additional field. "calendar: ObjectId("5473572cf1a76349020041c6")" (in this case)
[10:45:13] <hmsimha> so you have one document that {"date" : ISODate("2015-01-20T12:41:20.000Z"), "status" : true, calendar: ObjectId("5473572cf1a76349020041c6}
[10:46:01] <hmsimha> and another document might be { "date" : ISODate("2015-01-22T12:41:20.000Z"), "status" : true, calendar: ("5473572cf1a76349020041c6) }
[10:47:47] <hmsimha> then when you're computing all of the price sums for a specific calendar, you just put {$match: {calendar: ObjectId("5473572cf1a76349020041c6), date: {$gt: <something>, $lt: <something>}, status: true} into the aggregation pipeline
[10:52:19] <hmsimha> robopuff: there's probably a way to do it the way you have it. I just don't know it :P Separating this out into two collections seems like an easier way to work with the data in general to me, if you don't have concerns about operations that need to be done atomically
[12:45:56] <NoReflex> hello! where can I find sample configuration files for mongodb with wired tiger? there are some options I'm having difficulties understanding
[12:46:44] <NoReflex> for example: wiredTigerCacheSizeGB from here: http://docs.mongodb.org/manual/reference/program/mongod/#cmdoption--wiredTigerCacheSizeGB
[12:49:36] <StephenLynx> you just select the db and it will be crated on the first write if it doesn't exist.
[13:01:15] <cheeser> luaboy: 08:49 < StephenLynx> you just select the db and it will be crated on the first write if it doesn't exist.
[13:02:38] <Derick> luaboy: can you please follow the tutorial that I posted a link to - it answers this question, the why, and many more
[18:01:53] <girb1> Hi all .. I have a sharded cluster .. if i wont use keyfile for authentication is that ok ?
[18:08:31] <StephenLynx> I did some experiments with authenticated servers these days, I managed to create an user account and use it with auth=true only.
[18:16:12] <cr0wrx> does anyone have any suggestions on why auth is failing for me? I spun up a new replica set, I can auth from any of the nodes within replica set using mongo command line client, but if I go to any other machine, I cannot auth successfully
[19:33:18] <bashusr> what would be the best datastore for 5 star ranking data where I would be needing to aggregate the mean of the rankings per object and display it as an ordered list?
[19:44:29] <GothAlice> cheeser: If someone's coding up a bot that's behaving badly, banning it likely threw a large wrench into the mix. (I doubt it would gracefully handle error conditions, like when attempting to re-join. ;)
[19:57:32] <GothAlice> cheeser: *nods* I tell my IRC client to dump all of the metadata chatter into the connection tab instead of littering each channel tab. A little grep goes a long way at that point. ;)
[20:03:36] <bashusr> if someone is coding a bot, they should do it in ##test or something like that so you don't flood a mainstream channel
[20:08:49] <cheeser> i don't think latestbot actually is a bot. i saw her talking with other users earlier.
[20:34:22] <latestbot> How can I insert from _id from another document into another document at the time of inserting?
[20:36:59] <StephenLynx> if you are using the node.js driver, it will return the id in the second parameter of the callback.
[20:47:14] <GothAlice> When inserting, one could also just explicitly generate an _id yourself if you want. ;)
[21:19:16] <c3l> Hello, the native node.js driver defaults to installing version 1.4.34, is this intended? Is 2.0 not ready for use?
[21:41:04] <NoOutlet> I know it's off-topic, but does anybody know if there is a way to page back some arbitrary number of commands in the python shell?
[22:14:20] <hahuang62> hmm what should I check if I get this error: "$err" : "could not initialize sharding on connection rs1/rs1-1:27017,rs1-2:27017 :: caused by :: specified a different configdb!",
[22:36:00] <devster31> ok, so it's part of the CAP thing, you can't have everything, you have to prioritize something
[22:36:13] <GothAlice> devster31: You may find the following resources useful for understanding MongoDB's ACID behaviours: http://css.dzone.com/articles/how-acid-mongodb http://blog.mongodirector.com/atomicity-isolation-concurrency-in-mongodb/ https://groups.google.com/forum/#!topic/mongodb-user/y9YJeZ452lw
[22:36:45] <GothAlice> There's also a 158-slide deck: http://www.slideshare.net/kchodorow/dropping-acid-with-mongodb (has link to the talk, not sure if there's a video, transcript, or audio recording)
[22:38:14] <GothAlice> devster31: Lastly, there *is* an implementation of MongoDB with full transaction support, amongst other goodies: http://www.tokutek.com/2013/04/mongodb-transactions-yes/
[22:53:45] <hahuang62> I keep getting "$err" : "could not initialize sharding on connection rs1/rs1-1:27017,rs1-2:27017 :: caused by :: specified a different configdb!"
[23:40:43] <joannac> GothAlice: yes. and it's very strange because support contracts come with an SLA