Log file Viewer
#mongodb logs for Tuesday the 10th of December, 2013
[00:08:28] <ericsaboia> cheeser: cause I want to bring all results, just ordered by the friends first
[05:54:55] <mark____> nohup python agent.py >> /YOUR_LOG_DIRECTORY/agent.log 2>&1 & Found the command in mongodb management service,but i am unable to understand the comand ?can u please explain me a bit???
[09:03:17] <dropindex> Warning This command obtains a write lock on the affected database and will block other operations until it has completed.
[09:17:12] <dnsdds> Is there really no way to suppress errors? I'm doing a bulk insert with continueOnError, but it still returns the error, so my framework thinks it's a problem rather than intentional and okay
[09:37:26] <gmg85> hi guys? mongodb doesn't seem to be deleting documents immediately....what could be the problem?
[09:44:45] <tiller> Can we ensure indexes like: "Make sure there is only one document having default: true"
[09:46:26] <tiller> yes but I just tried, and with a boolean you've only 3 values. true / false / null. I hoped that maybe the null's value wouldn't be part of the unique field
[09:48:55] <Derick> tiller: you can do that with a sparse index; (which doesn't include documents *without* the field)
[09:52:28] <ecornips> Need some info on replica sets. I'm looking into the feasibility of running various secondary non-voting/read-only members across various data centres. Each can only see the Primary Mongos in the main data centre, and not other secondaries. Docs state each instance should see each other instance, but will it cause problems if two non-voting/read-only secondaries can't see each other on a permanent basis?
[09:52:50] <ecornips> (More specifically, this question: https://groups.google.com/forum/#!topic/mongodb-user/bimN-drQ_CM )
[09:54:03] <ecornips> Derick: is there any particular reason why they need to talk to all members? Shouldn't reachability to the primary ones be the important factor?
[09:54:36] <ecornips> if you think about a simple DC1-DC2 replica set, if the link between the two goes down, won't the instances on both DCs still be queryable?
[09:54:50] <Derick> ecornips: that's not how a replicaset works or is designed. It's meant for failover, which requires communication between nodes. At least they need to know which other nodes exist, to figure out which one is the fastest to sync from
[09:55:31] <ecornips> Derick: ok, that's a shame. I was hoping to force them to sync from just a specific subset.
[09:55:33] <Derick> mark____: you didn't ask a question. You wrote a sentence with three question marks behind it really...
[09:56:54] <ecornips> it's a system that's caching data at the edges for faster access, with very low writes
[09:57:05] <bitinn> hi guys, appreciate some help on the user role required to run mongodump, details here: http://stackoverflow.com/questions/20490291/minimum-permission-for-using-mongodump-to-dump-a-specific-db
[09:57:12] <Derick> gmg85: mongodb supports not acknowledged writes (ie, wait until the operation succeeded) and unacknowledged write (where the operation immediately returns to the client)
[09:57:21] <mark____> @derick: http://www.severalnines.com/sites/default/files/docs/Severalnines_WP_Databases_Social_Gaming.pdf page 5 line no.4
[09:57:37] <Derick> in the latter case, the client (language driver really), can continue without all documents having been deleted already
[09:59:01] <mark____> i didnt able to get the mean of that line in that things whether it is synchronous or asycnchronous
[09:59:33] <dnsdds> http://stackoverflow.com/questions/20491115/suppress-mongodb-unique-errors-on-node-js
[09:59:36] <ecornips> in the DC1-DC2 example, if DC1 has 2 instances and DC2 has 1 instance, and a split happens. DC1 will have a primary and a secondary, while DC2 will just have a secondary. In this case won't the secondary on DC1 still receive updates from the primary, as it's reachable?
[10:00:29] <tiller> If we use ensureIndex({field: "hashed"}); and that field is an array (field: [id1, id2, id3]) does the index work for each id, or only for the block of ids? (I'm not sure I'm very clear on my point)
[10:01:02] <ecornips> Derick: I'm struggling to see the technical constraint here then. If all secondaries can see the primary, they'll be able to sync even if its perhaps not the most efficient path
[10:01:59] <Derick> ecornips: yes, but there is no fixed primary in the replicaset concept. It's perfectly possible that at some point in the future (perhaps with a different configuration), the node in DC2 becomes primary
[10:02:47] <ecornips> Derick: agreed. In this case, I'd nominate a couple DC to have primary-capable instances (say 3 instances as per the example), and then have additional DCs with links to both of these primary-capable DCs
[10:02:52] <gmg85> Derick, not much of a connection string...this is what i have var db = mongodb.db('localhost', 27017, 'database_name');
[10:03:51] <Derick> ecornips: have you tried it? I am not sure if you can add a node that can't be seen by the majority... can't see why it shouldn't work besides getting lots of "cannot connect" log messages
[10:04:34] <ecornips> Derick: haven't tried it yet, that's the next step. Appreciate it's a bit of an annoying question, just trying to figure out any gotchas before I start building up 5-10 VMs ;)
[10:05:18] <Derick> ecornips: it is not something we'll recommend - but I do suggest you look at master-slave replication too
[10:07:56] <gmg85> Derick, Sorry...am using the mongodb-wrapper npm module...it uses the driver i pasted above...
[10:10:56] <Derick> you should use what's on https://github.com/mongodb/node-mongodb-native/blob/master/docs/articles/MongoClient.md
[10:11:45] <Derick> gmg85: the reason why I point you to MongoCLient, is because that has the interface that does acknowledged writes by default
[10:31:45] <bitinn> Hi Derick, not sure if you got time to take a look at this question on stackoverflow http://stackoverflow.com/q/20490291/1677057 user role permission is kinda tricky.
[10:33:57] <Derick> movedx_: write concerns have little to do with integrity. And it depends on which ones you set too.
[10:45:08] <movedx_> Derick: I'm just interested in gauranteed writes and data safety. I know how-to replicate and then shard, which is cool, but still, data actually being written is important.
[10:50:56] <movedx_> SO can it be argued that the main use case for Mongo, besides its NoSQL roots and scalability, is for data that isn't mission critical?
[10:54:19] <movedx_> Interesting. I reckon it's perfactly fine for almost any job. I just wish querying the damn thing was easier. I find the query and filter syntax, MapReduce, etc, a right pain to understand.
[10:58:39] <kali> i think that is highly subjective... from my experience pure beginners with no SQL background tend to struggle less with mongodb than SQL
[11:36:48] <Nodex> [10:56:54] <kali> i think that is highly subjective... from my experience pure beginners with no SQL background tend to struggle less with mongodb than SQL
[11:45:21] <gmg85> Derick, so when i deleted stuff..it was gone in mongodb but my ajax request returned it in the list..
[13:32:36] <hanser> i have a collection that stores documents as like http://www.hastebin.com/xayujagiho.apache, how can i find document that contains given key ("DEF") and cpuid (3) for this structure ?
[13:37:27] <hanser> kali: tried , db.data.find( { key : "DEF", activator: { cpuid: 3 } } ) didn't work
[14:58:51] <ericsaboia1> hey guys, I need to sort users based on a list of ObjectIds, I'm trying to use aggregation with project to accomplish that
[15:02:00] <ericsaboia1> Derick: I wanna sort my activities based on users that are my friends first
[15:03:01] <ericsaboia1> aggregation comparison operators accept $eq :http://docs.mongodb.org/manual/reference/operator/aggregation/#comparison-operators
[15:04:51] <ericsaboia1> and I need to query a list of activities, bringing first activities from my friends
[15:07:07] <ericsaboia1> So, to do that inside de app, I need to bring all activities, sort and than slice
[15:07:42] <ericsaboia1> or I need to query twice, one just to found my friend's activities, and other to complete the data
[15:08:44] <ericsaboia1> So I'm trying to do the job inside mongodb, bringing only 4 activities, ordered by my friends first
[15:24:12] <ericsaboia1> Derick: see if u understand now please: https://gist.github.com/ericsaboia/d6d04109569ce3f19181#file-gistfile1-txt
[19:22:29] <includex> hy gius, any tip about this: TypeError: Cannot set property 'version' of undefined at src/mongo/shell/utils.js:1008 ? when loading this sample.js http://pastie.org/8542822
[20:01:13] <staben> A User has many Requests. Some of the Requests has PriceQuotes. # E.g: u.requests.first.price_quotes . How can I do a query that returns only requests that has price quotes?
[20:05:33] <staben> cheeser: I tried with "u.requests.where('price_quote_id').exists?" but that does not seem to work. Could you please help me out with the syntax? ( Just started using MongoDB a few days ago )
[20:09:59] <includex> joannac weird, just removed the port value from "host" : "hosname:port" and worked :/
[20:11:52] <staben> u.requests.where(:price_quotes.exists => true).all # Returnes nothing, but "u.requests.first.price_quotes.first == PriceQuote"
[20:12:07] <ericsaboia1> http://stackoverflow.com/questions/8963054/mongoid-how-to-query-for-all-objects-where-value-is-nil
[20:24:22] <staben> ericsaboia1: Thanks, but does that work when the relationship is like this? "PriceQuote belongs_to :request" and "Request has_many :price_quotes" u.requests.where(:price_quote_ids.exists => true).first # => nil u.requests.collect(&:price_quote_ids) # => [[BSON::ObjectId('52a770664d6172d820010000')], []]
[20:27:59] <staben> PriceQuote.last => #<PriceQuote _id: 52a77066XXX, user_id: BSON::ObjectId('52a770XXXX'), request_id: BSON::ObjectId('52XXX'), price: 1.5
[20:29:09] <staben> ericsaboia1: A Request can receive many PriceQuotes, but it´s not necessary that it has any.
[20:30:15] <ericsaboia1> http://stackoverflow.com/questions/14789684/find-mongodb-records-where-array-field-is-not-empty-using-mongoose
[20:32:26] <ericsaboia1> staben: where is what u are looking for: http://stackoverflow.com/questions/12167403/how-do-i-query-for-item-with-non-empty-array-with-mongoid
[20:35:52] <kali> yes, if you release both of them at the same time in vacuum, gridfs will hit the ground first
[21:27:15] <mikaeldice> I need to run addition or subtraction to a number value in a document, sometimes from multiple node threads simultaneously. I need to read the original value from this document prior to performing the operation. Is there a risk of a scenario where thread 1 reads the value, starts it's math, then thread 2 reads the value and starts it's math with a different add/subtract value, thread 1 writes its n
[21:27:15] <mikaeldice> ew value to the document, then thread 2 writes its computed value to the document, ignoring the change from the first thread? If that makes sense..
[21:28:29] <platzhirsch> Counting the number of associations for a document of mine takes too long. What's the strategy here? This is not indexable is it?
[21:30:30] <platzhirsch> although it seems there was a nice fix to better performance on indexes for count
[21:37:35] <platzhirsch> Okay, nevermind. I simply put an index on the association, it's not sufficiently fast
[21:51:35] <intellix> mmm, my connections to Mongo keep going up... something wrong? [initandlisten] connection accepted from ?:50632 #71 (71 connections now open)
[22:16:49] <cheeser> most drivers will. some drivers, like java's, can leak connections if you don't close cursors properly
[23:20:07] <intellix> yeah happens automatically supposedly. I've got about 1k connections, and hitting some limit. Is there any recommendation about the amount of connections that should be allowed?
[23:28:58] <intellix> ok so it's based on your system ulimit, which is currently set to unlimited. must be some other issue then. Saw 1k connections and anew one being connected on every page refresh so thought something was wrong. I think it all looks fine though, must be something else... was getting some pipe dropped errors
[23:36:55] <justin___> Anybody have any insight on why quiet = 1 does not work, still seeing lots of logged events with rsyslog
[23:51:44] <justin___> Dec 10 15:49:38 mongodb3 mongod.27017: Tue Dec 10 15:49:38.445 [conn128792] authenticate db: local { authenticate: 1, nonce: "XXXXXXXXXXXX", user: "__system", key: "XXXXXXXXXXXXXX" }