Log file Viewer
#mongodb logs for Saturday the 26th of April, 2014
[00:27:07] <dgray> Hello! I'm working on implementing bulk writes(2.6) in a driver. I'm running into a problem where I'm sending the db command "update" with the field "updates" as an array of object, and getting back "wrong type for 'updates' field contents, expected object, found 4" and I am very confused
[05:51:53] <yvemath> How can i make use of redis and mongodb both, as in I want to have redis running forever, and mongodb to update its documents every 1 hour or 2 from w/e is in redis memory? Is it feasible to implement?
[05:59:52] <Cache_Money> I'm creating a Mongoose schema for a Game object but can't quite figure out the stats object.. https://gist.github.com/anonymous/11312806
[11:21:03] <arussel> I'm reading mongod documentation, it says: If your mongod instance has journaling enabled, then you can use any kind of file system or volume/block level snapshot tool to create backups.
[11:24:44] <thearchitectnlog> r the current user (Apple), as it has no running NotificationCenter instance.
[13:36:34] <k_sze> If I want to reclaim space of a replicaSet member using db.repairDatabase(), do I have to take it out of the replica set temporarily first?
[13:52:17] <k_sze> And can *all* databases be repaired using repairDatabase? I mean, for instance, the `local` and `admin` databases.
[16:10:45] <airportyh> hello all. I am using full text search on mongo version 2.4.9. I've found that if you don't supply a limit, it still returns at most 100 documents. And it takes a long time to return them.
[20:23:40] <Cache_Money> I need some guidance in structuring my Mongo DB. I'm building an app that tracks stats for sports games at an individual player level. I want an API endpoint such as '/spots/[:id]/games' so that I can get all of the basketball games. Would the collections simply be titled 'basketball_games', 'baseball_games', etc.? Or would I have just one collection, 'games' and each document has a field sport with a corresponding sport_id?
[20:27:09] <Cache_Money> A player will play 1 or more sports, and a have many games associated with each sport
[20:29:08] <Cache_Money> Mark_: mongo might not be the best fit but I'm even having trouble determining how to do this in a RDB -- I can't have a game table because stats for a basketball game are quite different than a golf game..
[20:29:43] <kali> Cache_Money: it always boils down to what queries your application will do the most, and how to get them to be fast
[20:29:52] <Mark_> well mongo is great for free structure, but it might not be the best tool if you want to be able to pull up like, all the players in a golf game
[20:31:09] <Cache_Money> Mark_: true. I probably won't be doing that much. I'm assuming the most common would be finding a Player, then determing which Sports they play, then returning games based on which sport they want to look at
[20:33:23] <Cache_Money> So, you're saying I create 1 document (Players), which will have an array of player objects. Inside each will be an array of Sport objects. Inside each Sport will be an array of Game objects?
[20:33:24] <Mark_> players { player stats, sports { sport1: { games: { 1..n: { game_stats } }, sport2: { games: { 1..n: { game_stats } } }
[20:34:42] <Cache_Money> that makes sense. (I'm new to mongo). I was trying to create a Players doc, a Sports doc, and a Games doc
[20:37:01] <kali> france. in soccer, rugby, handbal,... there is much less work done on players individual statistics
[20:37:38] <Mark_> if i was doing it in an rdbms id probably have a table for each game, then a table of stats for each game id/player id, then a table of players baseline information
[20:40:32] <Cache_Money> Mark_: So, are you saying I create a Players table, a Games table, and a Stats table?
[20:41:05] <Mark_> its just when you start getting into player specifics theres more of a relational component
[20:41:09] <Cache_Money> instead of Stats table, I'd create a BasketballStats table, SoccerStats table, etc.?
[20:43:11] <Mark_> then maybe you do a more relational system for players and their individual game stats and what game it was a part of (perhaps even referencing a mongo document id)
[20:44:53] <hit> I'm trying to do a $group operation on a big database but some of the resulting documents exceed the 16Mb limit
[21:02:08] <kali> hit: the result you're trying to build is too big for a mongo document. the problem goes deeper than the aggregation framework
[21:03:44] <hit> kali: ok, I was afraid of that. I'll try to remove that $k and other common ones and try again
[22:44:53] <thearchitectnlog> hey m getting this error when i group into out "errmsg" : "exception: Unrecognized pipeline stage name: '$out'",
[23:04:28] <Auckla> Typically, I would break up into a bunchof 6GB files or so, load them into a flat table on mysql. And run queries for the specific groups of data I want and create much more smaller manageable tables.
[23:11:37] <cheeser> Auckla: you're likely going to want to change your data model. maybe you won't, but keep that in mind.
[23:37:13] <thearchitectnlog> i want to aggregate group by id i am getting redundant values here is the script
[23:37:22] <thearchitectnlog> var a=db.autdet.aggregate([{ $group : { _id : "$author_id", language_id: { $push: "$language_id" }, name: { $push: "$name" }, nationality: { $push: "$nationality"},bio:{ $push: "$bio" } }}]);db.auts.insert(a);
[23:48:48] <metasansana> does mongodb support limits on the number of documents created in a collection?
[23:53:23] <thearchitectnlog> guys i need to group documents having same id into one document anyone can help ?
[23:54:07] <thearchitectnlog> i tried this var a=db.autdet.aggregate([{ $group : { _id : "$author_id", language_id: { $push: "$language_id" }, name: { $push: "$name" }, nationality: { $push: "$nationality"},bio:{ $push: "$bio" } }}]) it s giving redundant data