Log file Viewer

[02:20:08] <timeturner> how do you splice a subdoc out of an array?

[02:59:52] <abstrusenick> does gridfs use memory like normal collections?

[03:00:19] <abstrusenick> for example if i have 2GB of files in gridfs, will it occupy 2GB of RAM?

[03:06:20] <timeturner> how do you splice a subdoc out of an array?

[04:39:56] <hdm> anyone familiar with mongod ssl usage? I keep getting "Can't read key file" for a valid pem, verifying with openssl and other tools shows the same, using 2.2.0 from source

[04:41:08] <hdm> pem contains private + crt, password reset to something lame ('test'), example cli is /opt/mongo-custom/bin/mongod --dbpath=/home/mongo/data/ --port=50123 --sslOnNormalPorts --sslPEMKeyFile=/home/mongo/mongod.pem --sslPEMKeyPassword=test

[04:41:08] <hdm> Error is Sat Oct 20 23:38:01 Can't read key file: /home/mongo/mongod.pem

[04:42:47] <toothrot> check all the obvious stuff like path exists, permissions, etc?

[04:44:52] <hdm> $ ls -la ssl.pem

[04:44:52] <hdm> -rw-rw-r-- 1 mongo mongo 3486 Oct 20 23:36 ssl.pem

[04:44:52] <hdm> mongo@threats:~$ openssl rsa -in ssl.pem -des3 -out testingpass.out

[04:44:52] <hdm> Enter pass phrase for ssl.pem:

[04:44:52] <hdm> writing RSA key

[04:44:52] <hdm> Enter PEM pass phrase:

[04:44:52] <hdm> Verifying - Enter PEM pass phrase

[04:44:58] <hdm> woops,sorry for the paste, but yes

[04:45:18] <hdm> openssl can read it as the same user account just fine, password matches argument (test in this case), etc

[04:45:37] <hdm> ltrace doesnt show anything fun, neither does strace, looks like a mongod issue

[04:46:18] <hdm> ignore the mismatch of ssl vs mongod, same file actually (just renamed since)

[04:46:37] <hdm> --sslPEMKeyFile /home/mongo/ssl.pem is the actual argument now

[04:47:58] <hdm> tempted to just stunnel at this point :/

[04:55:06] <hdm> aha, cause identified: SSL_CTX_use_PrivateKey_file: B080074: error:0B080074:x509 certificate routines:X509_check_private_key:key values mismatch

[04:55:14] <hdm> apparently the key doesnt match the crt, lovely

[07:57:33] <ron> reading is boring.

[10:57:05] <Null_Route> Hey guys - small question - db.locks by me has ~30 rows, all are in state: 0

[10:57:10] <Null_Route> is this anything to worry about?

[10:57:21] <Null_Route> are these supposed to be cleared by at some point?

[10:57:59] <Null_Route> I can see that some of these are from >6 months ago.

[14:32:27] <ron> hmm, okay, the aggregation framework seems interesting.

[14:34:25] <ron> but as of now it doesn't support saving the output to a new collection (or an existing one for that matter)?

[15:58:49] <Gargoyle> shh!

[15:58:51] <Gargoyle> ;)

[15:59:14] <ron> ;)

[16:53:36] <izhak> Hi, guys how do I get all docs where a field is an array and contains _any_ of the values specified, is there smth like $any (instead of $all) predicate emulation?

[18:32:04] <dross> lo' all

[19:57:30] <jtomasrl> why when using findAndModify the whole document get replaced? how can i change only some values?

[20:11:49] <hdm> jtomasrl: using an upsert

[20:12:19] <hdm> or simply an update if you dont need to create if its missing

[20:14:50] <jtomasrl> hdm: i dont think upsert is what i need

[20:16:23] <jtomasrl> i need to update something like this {"name": "foo", "surname": "bar"} into this {"name": "foo", "surname": "barz"}

[20:17:06] <hdm> thats just a plain old update() then

[20:17:40] <hdm> update({ name : "foo", surname : "bar"}, { surname : "barz" })

[20:17:44] <hdm> or something similar

[20:17:58] <hdm> make sure your update find() clause uses an index

[20:18:43] <jtomasrl> so i cant use findAndModify for that?

[20:19:07] <hdm> findAndModify replaces the entire document, update changes specific fields based on find() syntax

[20:19:26] <hdm> http://www.mongodb.org/display/DOCS/Updating

[20:20:12] <hdm> something like this: db.collection.update( ( name : "foo", surname : "bar"}, { $set : { surname : "barz" }})

[20:20:25] <jtomasrl> great, ty

[20:49:32] <cjhanks> In Mongo what is difference between a "Field" and an "Element"?

[21:29:59] <jtomasrl> how can i find an object inside an array with an specific valie

[21:30:03] <jtomasrl> value*

[21:40:53] <itatitat> guys, i dont know anything about mongodb. But im interested. My question is, I need to know doctrine?, or something adittional, I know only sql

[21:45:39] <krawek> hi guys, what is the format of oplogSize ?

[21:45:46] <krawek> mstearn: ^^

[22:01:15] <itatitat> Derick: i dont know anything about mongodb. But im interested. My question is, I need to know doctrine?, or something adittional, I know only sql

[22:03:32] <polipie> is there a way to reduce the amount of scanned object in this query? http://pastie.org/pastes/5095312/text?key=qlmy922arqvkag6gdon8g

[22:07:54] <itatitat> polipie: I want to learn mongodb, is possible knowing that I only know mysql?

[22:10:18] <ianblenke1> itatitat: is that a rhetorical question?

[22:10:25] <polipie> itatitat: http://www.mongodb.org/display/DOCS/Home start here

[22:11:13] <ianblenke1> why would it be impossible to learn mongodb if you only know mysql?

[22:12:15] <itatitat> I dont know about mongodb, so I was thinking...maybe mongodb need more knowledge about another stuff.....doctrine, pdo...only was thinking

[22:13:49] <ianblenke1> note, I just googled "doctrine pdo mongodb" and found this link: http://www.doctrine-project.org/projects/mongodb-odm.html

[22:16:06] <ianblenke1> perhaps what you are really asking here is "I know php and mysql with ORMs like doctrine and pdo, and need to know if I can use the same ORMs with mongodb without having to re-learn a new ORM". The answer there is likely "probably, but it helps to differentiate the capabilities of releational vs document object stores and know how to optimally interact with your data to prevent performance bottlenecks from doing things in

[22:21:40] <Vile> polipie: add relevant indexes?

[22:21:43] <itatitat> nono, in my case I dont know ORM, only mysql, and PDO,

[22:21:52] <polipie> Vile: it is using a relevant index :)

[22:22:04] <polipie> compound index on the 2 fields in the correct order

[22:22:36] <ianblenke1> no, as with most things, there is no prerequisite of knowledge before learning things, though having prior knowledge does often hasten the learning process.

[22:22:38] <polipie> I think i have too much data in the collection for the index to be fast enough

[22:24:55] <Vile> do you have more users or workflows?

[22:25:37] <polipie> more users than workflows

[22:25:39] <Vile> maybe it would be good idea to create a separate collection per workflow

[22:25:57] <Vile> (if there is limited number of tjose)

[22:26:10] <polipie> there is a limited amount of workflows

[22:26:25] <polipie> users can be entered in multiple workflows

[22:28:16] <Vile> simultaneously?

[22:28:52] <Vile> do you need to track user actions through all the workflows and be able to restore the timeline?

[22:33:20] <polipie> yes :)

[22:34:25] <Vile> do you have an option to do it post-factum? i.e. use something like timestamp to assemble data from multiple collections?

[22:35:40] <polipie> it's mainly asking mongodb, did user X do something in workflow Y

[22:36:30] <polipie> and returning 6-7 fields with the executed action

[22:37:01] <Vile> have you tried to revert the index?

[22:37:18] <polipie> hmm, not yet actually

[22:37:21] <Vile> i.e workflow first and user afterwards?

[22:37:43] <polipie> and do user descending maybe

[22:38:01] <polipie> since it's mainly the most recent users that are doing things

[22:38:07] <polipie> the older users are dormant

[23:12:12] <Kim^J> Yo peeps!

[23:13:46] <Kim^J> If you want to compare an array, IE, find a document where all elements in an array matches all elements in the query array. {1,2,3} will only match {1,2,3}, is it $eq I should use or something else?

[23:20:27] <Kim^J> Hm, I guess a:{$all:[2,3],$size:2} works.

[23:34:47] <SpNg> I have a node.js application leveraging mongodb. Currently i'm collecting stats on one of my apps, but mongo keeps locking the server with the processor hitting 100%. I migrated mongos to it's owner server and it's still having the same problem. I'm performing maybe 3-5 upserts a second. Should upsetting be taxing the server that much?

[23:36:57] <SpNg> also I'm creating a new connection to mongod for every upset. Maybe this concurrency would be causing the problem?