Log file Viewer
#mongodb logs for Thursday the 2nd of October, 2014
[00:10:25] <feathersanddown> Using morphia, is possible to add an ObjectId in an embedded document ? In documentation say: ( https://github.com/mongodb/morphia/wiki/EntityAnnotation#embedded ) that "For example, the Hotel class above might have an Address. The Address would be an inseparable part of the Hotel, would not have its own ID, and would not be stored in a separate collection." but I need to identify an object...
[00:13:17] <feathersanddown> and that array is inside root document: root{ _id:"234...fds" , myArray: [ {_id."f.....3", item: "a"}, {_id."df.....2", item: "b"}, {_id."32.....1", item: "c"}, .... ] need to modify item array that have _id:"32.....1" (item c)
[00:16:14] <feathersanddown> yes, mmm... don't understand your question,, english is not my native language xd
[00:16:14] <Boomtime> "nothing, won't write it into database" <- how do you try to write it to the database?
[00:24:35] <feathersanddown> @Entity public class Ficha { private ArrayList<Evento> eventos; .......
[00:25:19] <feathersanddown> "eventos" variable was with @Embedded tag and doesn't work too, here with no-tag neither
[00:26:17] <Boomtime> you probably don't need @Embedded either since it is in an array, but i'm not sure about that
[00:26:57] <feathersanddown> NoId complained about cl.medsolutions.modulos.ecg.Evento. : No field is annotated with @Id; but it is required <---- let me try without it
[00:29:31] <Boomtime> so, reading the docs i think you need @Embedded rather than @Entity on that class
[00:49:46] <feathersanddown> but is correct my answer? I mean.... is possible to add an _id inside an object that is inside an array of the document?
[08:23:51] <mrcloud> hello. Maybe you can help me with this. I'm new with mongodb but I must implement an app with crud operations over question objects. My problem is that I don't see how to structure all to be able to store every type of question. Here I have an small description http://pastie.org/9613226 Could you help me with this?
[08:55:32] <pierre1_> hi everyone. How do I find a document that doesn't have a certain element in certain an array attribute?
[11:39:43] <dazzled> http://pastebin.com/Rxqedc0P is something like this possible to do? this form gives me syntax errors
[12:34:05] <Snii> Hi, I have a collection with object such as {name:"a", revision:1}, {name:"b", revision:1},{name:"a", revision:2} - and I want to get only the latest revision for each name - What is the best way to so this?
[12:34:31] <Snii> I'm thinking of using a mapreduce each time add a new revision and have it create a new collection with only the latest revision listed for each name
[12:53:49] <Atomic> hey i was wondering if anyone could shed some light on this warning i'm getting while running a big update of every field in one of my largish (~30gb) collections
[12:54:48] <Atomic> i'm pretty sure my db.eval() is blocking so i can't run any queries to see if my update is working
[13:53:16] <salty-horse> hi. I added a new shard to my cluster, so a collection is busy rebalancing. could this explain this error I get on long counting queries? "shard version not ok in Client::Context: version mismatch detected"
[14:07:25] <richthegeek> i'm totally aware this is a nebulous question before I ask it, but hopefully I can get an answer at bit more in-depth than "it depends" so ...
[14:07:49] <richthegeek> is it better to cache frequently-read and infrequently-changed records in the application, or to just read them directly each time you need them
[14:08:14] <richthegeek> assuming frequently read is, say, 50 times a second, and infrequently-changed is like once a day
[14:09:15] <richthegeek> assuming that "keep it in the application memory" is better, I wrote this: https://github.com/richthegeek/mongo-cached-find
[14:13:56] <Atomic> here's a question: how much faster (if at all) is a query on the _id field over a query on an indexed, integer value field
[14:28:47] <spenguin> Hi everyone. How would I make it so that two documents in a collection couldn't have a field with the same value, but so that other documents in other collections could have the same field with the same value?
[14:32:04] <Atomic> another question: would a big update run faster with logging disabled (ie to save the time of logging each update * n)
[14:49:36] <freeone3000> Is it possible to return values from multiple stages of an aggregate pipeline? For instance, a match, a match, a group (take results from here), then a group (take results from here, too), with the return being the union of those two?
[15:04:38] <richthegeek> freeone3000: you can use $out after the first stage to store the first results, then aggregate those
[15:05:27] <richthegeek> znn: that's invalid javascript, try either for (var color in colors) db.colors.insert(color) or colors.forEach(db.insert.bind(db))
[15:05:28] <znn> actually, the colors variable looks like colors = [{_id: ObjectId(), color: "red"}...
[15:05:51] <freeone3000> richthegeek: http://docs.mongodb.org/manual/reference/operator/aggregation/out/ says it must be the last stage in the pipeline. So, in order to do a two-stage aggregate, I must run two pipelines and use a temporary table?
[15:07:19] <richthegeek> i'm not sure of the internals to be honest, but for this specific query you need to ensure you run them in order
[15:07:49] <richthegeek> possibly use a hash of the full pipeline to name the temp table to avoid conflicts
[15:13:06] <freeone3000> richthegeek: Okay, thanks. It looks like the best way to do it in one query would just be to handle the aggregation client-side.
[16:12:21] <ells> any reason why http://mms.mongodb.com/help/tutorial/install-backup-agent-on-osx/ cannot auto redirect to http://mms.mongodb.com/help-classic/tutorial/install-backup-agent-on-osx/
[16:41:05] <feathersanddown> in morphia, when using references (https://github.com/mongodb/morphia/wiki/ReferenceAnnotation) when load a document that have a reference to another, it load both in same call?
[16:59:10] <culthero> Quick question; I have 3 shards. My first shard is is running between 50-100% cpu utilization, shards 2 and 3 are running at 2-2.5%. Doing about 60-100 inserts a second. Why is this?
[17:07:25] <skot> culthero: Sharding spreads data not load; do you have some unsharded data on that one shard maybe?
[17:07:57] <culthero> skot: i literally just realized that one table I query is only on the first shard. Can I just sh.shardCollection("offending_collection"); ?
[17:08:39] <culthero> skot: ofc, actually I want to duplicate it across all 3 shards, cause it's a table that really never changes
[17:09:52] <skot> The way sharding works is that a collection is either shared or not; if not sharded it lives on only one shard.
[17:10:59] <skot> k, I'd suggest choosing a shard key used in all the queries, so it spreads the queries aprop.
[17:11:49] <skot> Cause if you don't choose a shard key like that then it will just query all shards which might not help, depending on your usage pattern.
[17:18:21] <skot> http://docs.mongodb.org/manual/core/sharding-shard-key/#sharding-shard-key-query-isolation
[17:24:15] <culthero> like, if I search for something that is contained in more then 10-20% then half the documents.. its.. well very slow
[17:34:29] <tjbiddle> Hey all - just curious. I decided to check mongostat on a system I've recently started working on. How many insertions per second is considered small/average/large for mongodb?
[18:07:04] <tjbiddle> culthero: Yeah I'm sitting at ~1000 inserts/second on one of the machines I'm working on. Just curious how that compares to other production instances. Whether that's considered a lot or little, or what
[18:30:55] <wayne> i'm using mgo and go's type system is not happy with nil as bson.ObjectId (inherently a string)
[18:47:18] <jrdn> just wondering what other's used as a solution before i go and rewrite the application to encrypt data and store it
[20:13:57] <dgarstang> mongo confuses me. I have a fresh install... What should I authenticate to localhost with?
[20:17:02] <dgarstang> How can I get "not authorized for query on local.system.replset" when the admin user hasn't even been created yet!??!?
[20:18:46] <dgarstang> How can I get "not authorized for query on local.system.replset" when the admin user hasn't even been created yet!??!?
[20:26:12] <dgarstang> feathersanddown: this just happened on 3 shard nodes I installed indepdnantly. happened on all 3
[21:24:11] <dgarstang> Why woudl I get this? "Database command 'listDatabases' failed: not authorized on admin to execute command { listDatabases: 1 }"
[21:50:42] <MongoNewb> quick question, when I do a find(), how do I see how many documents were returned from it (in PyMongo) if anyone knows?
[23:34:56] <joannac> dgarstang: because the user you're authenticated against doesn't have access to local.system.replset?