Log file Viewer
#mongodb logs for Thursday the 22nd of October, 2015
[02:14:10] <bkbonner> hi quick question about mongoclient.connect. if I'm using nodejs 12.6, docs say it should return a promise, but it seems to return undefined.
[02:14:48] <bkbonner> am I misunderstanding the docs? http://mongodb.github.io/node-mongodb-native/2.0/api/MongoClient.html
[07:01:53] <dualbus> Hey, I'm getting 404 for several current tutorials from the manual, for example: https://docs.mongodb.org/manual//tutorial/force-member-to-be-primary/
[07:02:30] <dualbus> I'm not sure if you're aware. BTW, I didn't report an issue because it requested login and it's a bother to register just to report that :-)
[08:10:30] <tamil> hi folks, is there any tool to convert old mongodb configuration file to new yaml format?
[12:10:29] <terabyte> hey. For a site that stores a wish list (assume each item has an id) for a person (who also has an id) is it better to store a single document for a user listing every item on the wishlist, or is it better to store a series of item documents which all have the userid associated with them?
[12:20:05] <symbol> Do you want to retrieve users and wishlists together all the time? (Granted, you can use projections to not retrieve the wishlst) Do wishlists ever need to be accessed independtly from users?
[12:20:51] <terabyte> a wishlist does not make sense cutting across users. So you always retrieve a wishlist for a single user, or edit an item on a wishlist for a single user.
[12:22:33] <terabyte> so i guess {user:id, items:[{item1, item2}]} makes sense over a series of {item1, user1}, {item2,user1} etc then
[12:25:35] <symbol> Although, I think some people will argue that arrays without "bounds" aren't a good idea but I don't think rule applies to small arrays
[12:26:53] <terabyte> most entries are quite small (read empty), but up to 2000 of them could have 5 'subitems' of information, a subitem of info would be about 5 fields itself
[12:29:11] <symbol> I like to think of 100 as a soft limit for arrays when you push past that, performance hits may happen.
[12:29:51] <symbol> If a user goes from 3 items to 300 then that document may need to be moved locations.
[12:32:04] <symbol> Then again - there's this article https://www.percona.com/blog/2014/02/17/dont-worry-about-embedding-large-arrays-in-your-mongodb-documents/
[12:40:59] <Pacane> Hi, I'm trying to update the mongo driver for Dart, and I'm facing a weird problem. Once I'm authenticated, I try to insert/remove records from any collection and get error messages like this one: "err: not authorized to remove from dbname.collectionName"
[12:41:05] <Pacane> My mongo instance is a free tier mongolab, and my user has the role "DbOwner" (and I tried adding read/write too but it does the same thing)
[12:48:45] <sousvide> probably a quick question: i have edited mongodb.conf to listen on the actual IP of the server, but "mongo" by itself still tries to connect to 127.0.0.1
[12:48:59] <sousvide> netstat -tlpn | grep mongo shows that it is indeed listening on the real ip and default port
[13:08:52] <symbol> Oh snap. With the power of 2 allocation in 3.0 - does this mean that, if a document has to be moved, that another document can slide into the now free space?
[13:18:06] <symbol> I've been doing a bit of reading on embedding documents within arrays. Wouldn't a major downside be the reader-writer locks that happen? E.g. A blog post and comments. If comments are embedded in each post and a site has REALLY active commenters, wouldn't the read performance get hit pretty bad?
[13:19:03] <symbol> I'm thinking of the index page for all posts. While it doesn't require the comments, it'd be slowed down unless there you cached it.
[13:20:10] <Derick> symbol: yes, you're probably right. But also not really until you've benchmarked it :)
[13:23:51] <symbol> You're right though, it's probably negliable until benchmarked. I was at a meetup where a fellow was making a fuss about the locking in versions <=2.6 and the performance hit but the speaker had used it for logging and had great write performance.
[13:39:44] <Moz_> Hi All. I'm new to mongoDB but it seems great so far. I have a question - if I modify the output of the find command using a projection can I sort the objects based on a field which was excluded in the projeciton?
[13:45:40] <Derick> we only provide packages for LTS, but that doesn't mean it doesn't work on later versions
[13:47:51] <the_german> How can i iterate over a whole collection with find().forEeach(...) . It is my understanding that the cursor doesn't return all results....
[13:51:13] <the_german> Derick: Ok... what could be the reason for "killcursors: found 0 of 1" in my logs?
[13:52:41] <the_german> Derick: That is so strange. My foreach iteration always stops between 70000 and 80000 documents. And that is the only thing I can find in the logs remotely related
[14:00:04] <the_german> symbol: This is happening on 2 machines. One has only 4GB RAM. The other 64GB. Was my first thought too
[14:00:56] <symbol> This thread has useful information - https://groups.google.com/forum/#!topic/mongodb-user/Xas1n7opXKM
[14:04:59] <the_german> I found that thread too. I just don't know how on of my queries would stop for 10 minutes
[14:05:52] <the_german> How is that even possible when iterating over a whole collection. Some background tasks? but for 10 !! minutes?
[14:08:50] <the_german> no. i important a lot of jsons with mongoimport. After that I "parse" all the data and put it into another collection (this is why I use find().forEach())
[14:09:19] <the_german> I just started the process again with timeouts disabled...maybe it helps but it really messes with my head
[14:13:04] <hamid> Hi guys, We happen to have this problem which sometimes our embedded documents thriplicate randomly without any will, and you can see lots of repeated IDs mostly. Has anyone ever encountered this issue before (on MongoDB 2.4) and do you know if it's a known bug?
[14:23:57] <schu> hi. is there a way to "import" back mongodb's .0, .1 and .ns files? i have a broken server and only access to these files...
[14:29:43] <StephenLynx> specially debian now they are more concerned about politics rather than technology
[15:22:25] <terabyte> if you have a document as {someId:1, items:[{sublist:[{},{},{}]}]. You can always "get, update client side, post new document", is there a neat way to target the updating of elements in a that neatly?
[15:39:06] <sousvide> hi there. any ideas on why my brand new mongodb 3.0 install is completely ignoring the /etc/mongod.conf file?
[15:39:38] <sousvide> using ubuntu 14.04.3, base install, nothing else, made edits to conf file for dbpath and logpath but "sudo service mongod start" will not refer to, read, or respect the conf file
[15:40:41] <sousvide> to test, i also edited /etc/init/mongod.conf to point to my new db and log paths, same issue - running service start fails silently
[16:13:59] <morenoh149> it does not. After researching it looks like the only viable solution is to have a post import step.
[16:14:08] <morenoh149> http://stackoverflow.com/questions/31212691/how-to-import-specific-csv-values-as-array-in-mongodb
[16:19:38] <Steve-W> Hi all. I'm encountering a problem using the sample code for the ruby driver, failing with "NoMethodError: undefined method `convert_key'" in Mongo::Options::Redacted. Others seem to have this issue, but I can't find any solutions online. Might I get a little help please?
[16:29:35] <morenoh149> you use upserts to ensure you don't insert the same data more than once right?
[18:13:29] <terabyte> if you have a document as {someId:1, items:[{sublist:[{},{},{}]}]. You can always "get, update client side, post new document", is there a neat way to target the updating of individual sublist items? a sort of "update sublist where /json/path/to/sublist/id=1 set /path/to/sublist/field->1 for someId->1
[18:14:15] <terabyte> (see how it's not just an array, it's the array in an object which itself is part of an array)
[19:11:03] <morenoh149> does anyone know how to get mongo to use stringIDs like how meteor expects in a collection?
[19:11:25] <morenoh149> can I just set a setting on the collection and the database will choose the right ID type for new inserts?
[19:46:21] <fullstack> Hello, how do I do ... findOne({someDateColumn:{$ne : { $type : 9 }}}) -- give me all rows where someDateColumn isn't type 9 -- BSON type 9 is Date
[19:54:48] <fullstack> Where can I get https://docs.mongodb.org/manual/reference/operator/query/type/ Available Types as a structure
[20:24:42] <morenoh149> p.purveyors is an array, I need to push into only if it does not contain a certain string
[20:36:16] <morenoh149> if (p.Purveyor3 && !p.purveyors.some(function(e) { return e === p.Purveyor3 })) { p.purveyors.push(p.Purveyor3) };
[20:54:51] <dufabricio> ok.. nick registered lol. . So. .could any help me.. I have the follow document schema { _id : "23123123", name: "John" , monitoredUsers: [ { foo1: true } , { foo2: true } ] }