Log file Viewer
#mongodb logs for Monday the 15th of June, 2015
[00:30:32] <BadHorsie> I have a collections ipNets with entries like: {"cidrs":{"10_0_0_1/24":{"ip":{"10_0_0_2":{name:"mygw"}}}}}, I'm curious about how to search for {"name":"mygw"}, I usually do like "cidrs.<range>.ip.<ip>.name", but in this case I don't know the <range> or <ip> from the query...
[02:24:04] <OnePrettyCoolGuy> I'm trying to use a variable as an object key, and instead of getting the value of that variable its just setting it to that name.
[03:49:28] <OnePrettyCoolGuy> I'm trying to use a variable as an object key, and instead of getting the value of that variable its just setting it to that name.
[04:28:24] <joannac> OnePrettyCoolGuy: using a value of a variable as a keyname already sounds a bit dicey. what are you actually trying to do?
[04:28:49] <OnePrettyCoolGuy> #joannac: https://gist.github.com/InternetExplorer7/854b2efec075dbfef945
[04:29:43] <OnePrettyCoolGuy> My issue here is that I have the name of the array I want to push new items to, but when I use name: 'hello' it actually uses 'name' as an object key, not the value of var name.
[04:32:22] <OnePrettyCoolGuy> Before this function, another is ran where it initializes that array, and then this function is called once the user inputs some text (this function is where their unique array is populated)
[04:35:51] <OnePrettyCoolGuy> @joannac: Any idea how to do this? I've literally asked everywhere, Stack Overflow, other IRC channels.
[04:38:30] <OnePrettyCoolGuy> An empty array of their name is created everytime a new user registers.
[04:40:13] <OnePrettyCoolGuy> The problem with that is that the new value just replaces what was previously there
[04:42:19] <joannac> and now I have { "_id" : ObjectId("557e571bf2064e4e99a52ad7"), "x" : [ "hello", "hello" ] }
[04:47:16] <OnePrettyCoolGuy> @joannac: This is what my flow looks like right now: https://gist.github.com/InternetExplorer7/4105420adaaee31a5df3
[04:53:34] <OnePrettyCoolGuy> @joannac: https://gist.github.com/InternetExplorer7/ee6aff2705b9ed17a7c0
[04:58:27] <OnePrettyCoolGuy> I kept relaunching my nodeJS app to see if it would add more items to my array.
[08:18:03] <Dakutta> Hey everyone. Been a while since I used irc ... anyway! I hope that you can give me a little advice on something.
[08:21:12] <Dakutta> We inherited a mongodb shard here when a coleague left and I got the task to apply the newest linux patches to the machines. Is there maybe a writeup somewhere on what I have to ... well ... do to make sure I don't break the shards/config-servers in the process? ( ;
[08:35:07] <KekSi> hi - i have a question concerning the $external db (to use with X509 certificate login) - why it it not partitioned and located on a replica-set rather than the config db? { "_id" : "$external", "partitioned" : false, "primary" : "rs0" }
[11:21:33] <m3t4lukas> that may if I want an abstract interface I have to add a property "negated" for every operation the not can be applied to
[12:15:44] <m3t4lukas> no a list of those operators http://docs.mongodb.org/manual/reference/operator/query/ you can actually use $not on
[12:17:37] <m3t4lukas> like you can't use $not with $eq although $not $eq and $ne would deliver two different result sets
[12:21:12] <m3t4lukas> as I understood $not $eq would also deliver those documents that don't have that field I test the condition on while $ne only delivers those documents that do have the field AND do not match the value
[12:22:46] <deathanchor> http://docs.mongodb.org/manual/reference/operator/query/ne/#op._S_ne says: This includes documents that do not contain the field.
[12:26:32] <m3t4lukas> deathanchor: I do an Interface, that you only communicate with an abstract model layer. The model then gets translated to whatever database you give it. It can be SQL, it can be google nosql, it can be mongo, it can be that doc storage from openstack etc
[12:26:40] <deathanchor> HA! I have run into issues with drivers, for instance I'm using some old java driver and it won't obey the "use secondary" for counts/distinct searches
[12:27:29] <deathanchor> I would test it in mongo shell, then if it works there but not via driver, then there is obviously something funky with the driver
[12:28:24] <m3t4lukas> and a month ago 1.1.5 driver was the latest and greatest, but it is always two weeks of work to port the C includes into D imports
[13:09:13] <m3t4lukas> that's why I wonder why companies like Autodesk don't compile their stuff for linux...
[13:13:07] <StephenLynx> but as any other profit-driven decision, you cannot justify the whole world based on that.
[13:13:21] <m3t4lukas> yeah, well, I know many companies who only have windows machines where they have to use Autodesk products
[13:17:22] <jecran> Good morning guys. I am trying to do a query, however my result is always printing my id instead of the field I am looking for. https://gist.github.com/anonymous/8dacaea7dfee4e05ea35 can someone please let me know what I am doing wrong?
[13:52:27] <benjick> Hi. When I'm updating a doc with a new field all the old fields are removed, what can I do to debug?
[13:57:06] <joannac> mrmccrac: updates, it should. inserts, no - how would index filters work there?
[13:57:48] <mrmccrac> seeing a strange issue where occasionally it will hit an update query and just hang
[13:58:45] <mrmccrac> saw the same behavior on a find() query earlier that i seemed to fix by specifying a hint() for
[14:15:43] <deathanchor> I've run queries that used a "stupid" index the first time, but used the "right" indexes after that for a time.
[16:25:16] <shlant> morning all. Anyone know why the 'boss' user is trying to authenticate against the 'admin' db with this url? 'mongodb://boss:pass@mongo-1.node.consul,boss:pass@mongo-2.node.consul,boss:pass@mongo-3.node.consul/inventory?readPreference=secondaryPreferred&replicaSet=rp0'
[16:25:59] <shlant> and yet the logs show 'I ACCESS [conn12401] SCRAM-SHA-1 authentication failed for boss on admin from client 172.17.0.14 ; UserNotFound Could not find user boss@admin'
[16:27:15] <shlant> do I need to specify http://docs.mongodb.org/manual/reference/connection-string/#uri.authSource for some reason?
[17:42:02] <kopasetik> MONGO DB QUESTION: i want to nuke (aka delete) my mongodb database because it says that i have circular references. i would just drop it right?
[17:42:55] <cheeser> (and since you're in #mongodb you don't need to preface that you have mongodb questions...)
[17:43:18] <kopasetik> @cheeser: this is what i keep getting for my empty database: "TypeError: Converting circular structure to JSON"
[17:44:34] <StephenLynx> that its because you are probably using JSON.stringify on something that doesn't support it.
[17:46:31] <StephenLynx> if you are not running everything in a try-catch, it should crash and give you the line where it failed.
[18:11:48] <sbhawsin> Hey all, I have a question. I am using mongodb v2.4.13 and I want to get the number of documents which got updated in a particular update call. I am doing this in python
[18:14:03] <sbhawsin> _ari: I am not sure but by putting timestamp, how can I get the exact number of updated documents.
[18:15:59] <sbhawsin> Can you please check the code? http://fpaste.org/232278/34391695/ . Here the result is giving correct information but the update is not executing. I am not getting an updated timestamp
[18:39:09] <carlgotting> im coming from sqlite3 on a project, and im running into limitations with it
[18:41:16] <mrmccrac> if you have to do multiple reads/writes on the same doc and want all your operations to be atomic you're boned and have to roll out your own locking/transaction solution externally
[19:33:13] <gabrielsch> I have this following schema : https://gist.github.com/gabrielsch/d8ee8b11fa9002ecfac9 and I want to find "supplies" by "sku", can I do that? or my schema is too bad? :(
[19:49:06] <gabrielsch> StephenLynx: when I designed that, I thought that would help to dont iterate the whole collection
[19:49:43] <StephenLynx> if the size of that array is a concern, you could look into putting it in a separate collection.
[19:51:30] <StephenLynx> I don't consider them to be actual references because mongo doesn't implement relations.
[19:53:20] <GothAlice> That's unfortunate. ODMs automate repetitive tasks on your data, since any task worth doing right is worth doing twice, and any task worth doing twice is worth writing a tool to do it for you…
[19:54:13] <StephenLynx> the problem with tools that abstract EVERYTHING is that it will perform these abstractions all the times.
[19:54:36] <StephenLynx> when you don't use them, you abstract said repetitive tasks as much as needed.
[19:54:40] <GothAlice> Most ODMs pale in comparison to Python's MongoEngine, as an example, and MongoEngine lets you very easily drop down to pymongo, then back up to MongoEngine rich document objects as needed.
[19:56:04] <GothAlice> StephenLynx: For example: https://github.com/bravecollective/forums/blob/develop/brave/forums/component/thread/model.py#L120-L133 — this runs a custom query (since MongoEngine's support for $ is weak at the moment) then wraps the result in an embedded document class from MongoEngine.
[19:56:28] <jacksnipe> Is there any support for sets or some other sort of unsorted list within a document?
[19:56:47] <GothAlice> jacksnipe: Indeed. $addToSet is what you need for that. MongoDB will then handle uniqueness checking server-side.
[19:58:02] <gabrielsch> Can't I use $elementMatch to find my supplies by SKU? like that: http://stackoverflow.com/questions/10043965/how-to-get-a-specific-embedded-document-inside-a-mongodb-collection
[19:58:19] <gabrielsch> I've tried db.Supplier.find({'supplies.sku': { "$elemMatch" : {'sku': 'DDD123'}}}).pretty(); but no success :(
[20:01:46] <GothAlice> Yeah, my initial gut instinct when looking at that is to douse my monitor with lighter fluid and ignite. The lack of indexes is going to really, really hurt. And no, you can't use $elemMatch on that.
[20:02:50] <GothAlice> Let me fork your gist to demonstrate the "right way" to do exactly this. Nesting them is quite possible, and even quite effective.
[20:03:27] <GothAlice> You can see from the revision history what I changed: https://gist.github.com/amcgregor/0afd451d23e068d0eb7d/revisions
[20:03:45] <gabrielsch> GothAlice, http://doctrine-mongodb-odm.readthedocs.org/en/latest/reference/reference-mapping.html#reference-many
[20:04:48] <GothAlice> That documentation page references a static asset (JS, CSS, image) that isn't loading for me, preventing the entire page from loading. \o/
[20:09:22] <gabrielsch> and referenceMany will create other collection, and references using ObjectId
[20:09:26] <GothAlice> By virtue of this being PHP, it's bad and should feel bad by encouraging you to do something _terrible_.
[20:09:46] <GothAlice> PHP treats associative arrays (mappings, dictionaries, hash tables) and arrays (lists, sets) as the same thing.
[20:10:14] <GothAlice> The documentation here is omitting a usage example which would need to clearly indicate you are _not_ supposed to use it as an associative mapping.
[20:10:38] <GothAlice> While Mongoose will be first against the wall when the revolution comes, Doctrine will be a close second.
[20:12:31] <gabrielsch> GothAlice: yes, Doctrine ODM is still beta, and it's missing a lot of feature
[20:20:11] <GothAlice> gabrielsch: Well, it's the combination of PHP's laissez-faire data types and poor Doctrine documentation that got you where you are. https://gist.github.com/amcgregor/0afd451d23e068d0eb7d#file-migration-js is the fix for your data, BTW, or something very similar.
[20:22:21] <GothAlice> This is also safe, though will require extra storage space. (I.e. running it the first time makes a copy of the data. You'd then need to drop the old field and rename the new one in place. Or you could change that update to set the value using the real and add some "is it actually an array, or an object" checking at the top if you have backups elsewhere.)
[22:41:50] <fllr> I'm trying to setup a replica set with mongo using Salt. Everything goes well until I have to actually add the machines onto the set (rs.add()), and initiate the set (rs.initiate()). Is there anyway Mongo can add the machines onto the replica set according to a text file of some sort, or at least the command line, instead of requiring me to go into the mongo shell, and typing commands there?
[23:05:34] <fllr> joannac: Yeah, I guess that'll work. Ideally, though, mongo could just read a file that listed out the machines, and do everything based on that...
[23:08:52] <cornfeedhobo> hello. i would just like to confirm something regarding replication. i am confused about the relationship between needing "an odd number of voting members" vs "need at least 3". which is it? because i have tested a few scenarios, and it would seem as if as long as i have 3 or more, voting works out properly ...
[23:22:17] <devSeb> Hey folks! Have a rookie question for MongoDB. Been trying different stuff, but no win. How do I easily get the number of items of an array inside a document?
[23:23:44] <StephenLynx> i think you will have to get the document and use your language way to see how long it is.
[23:36:14] <cornfeedhobo> joannac: well, i tested with 5 members. 4 servers, 1 arbiter. killing the primary didn't result in a conflict, but there were 4 voting members left ....