PMXBOT Log file Viewer

Help | Karma | Search:

#mongodb logs for Sunday the 28th of October, 2012

(Back to #mongodb overview) (Back to channel listing) (Animate logs)
[01:24:09] <kevBook> Does anyone have experience w/ mongodb Aggregation?
[01:35:48] <preinhei_> Derick: I don't suppose you're awake?
[01:44:15] <preinhei_> I'm having trouble with the newest beta PHP driver. I'm trying to tell it that it's okay to read from a slave, but it refuses and errors out: http://pastie.org/private/qv1jh9rorqp0x88zrylza
[01:55:00] <preinhei_> Poking further, explicitly setting setSlaveOkay to true, or setting a read preference seems to error out. If I leave them blank it's willing to read from the master and not error out
[01:55:59] <preinhei_> Maybe: https://github.com/mongodb/mongo-php-driver/commit/da737dae8a033f3c15a7d9cb3e5a2ad7b80f9073
[01:58:14] <preinhei_> Presumably it's that issue, I'd like to vote for another release of the driver with that fix :)
[02:35:42] <earlz> Any ideas why my journal files for a relatively small database are huge? I probably have a couple megs of actual data in my database, yet it's using up 3.7G.. Also, I've tried repairing and smallfiles
[02:39:28] <earlz> To put the amount of actual data I have in perspective, gzipping the database directory compresses it down to just 3.8M
[04:11:14] <thenley> Hi, new to mongodb, reading the docs and attempting to update an existing document but get the following error uncaught exception: can't save a DBQuery object... heres what im doing
[04:11:52] <thenley> db.cars.save({brand:"bmw"});
[04:12:11] <thenley> var bmw = db.cars.find({brand:"bmw"});
[04:12:22] <thenley> bmw.foo = "bar";
[04:12:30] <thenley> db.cars.save(bmw);
[04:12:43] <thenley> and thats where the error is thrown, any ideas?
[04:25:36] <thenley> ok, got it working, seems to work only when getting the object using findOne, if I use find to get the object it causes the error =/
[04:34:44] <glaksmono> Hi, anyone is around?
[04:34:55] <glaksmono> I'm wondering on how does the query against Mongodb is directed to?
[04:35:14] <glaksmono> i.e. how does Mongodb know which shard to access to?
[05:42:04] <Determinist> hey guys. I have a document that contains two arrays. i'd like to move an item from array 1 to array 2. is there a way to do that in one command instead of having to read the document into my app, modify and update?
[09:05:19] <ron> ElGoorf: what time is it... where?
[09:05:27] <ElGoorf> gb
[09:05:48] <ElGoorf> it's k i figured which of my clocks hadn't updated
[09:14:10] <wereHamster> ElGoorf: google 'what time is it'
[09:14:53] <wereHamster> or 'Time in United Kingdom'
[09:14:55] <ElGoorf> nope
[09:15:08] <ElGoorf> google has no sense of humour
[11:27:45] <ElGoorf> joining #jquery caused my client to crash :S
[11:27:48] <ElGoorf> bizarre
[12:11:30] <Bilge> gayquery
[14:48:07] <SNow> hi guys, what's with the disk allocation in sharding?
[14:48:18] <SNow> http://p.defau.lt/?69UEdS9UnDSWYMiqApx8Ng
[16:24:37] <TheFuzzball> If I have a key in a schema that's an array, how do I do a query for documents that have a given item in that array?
[16:24:46] <TheFuzzball> Kind of the inverse of $in
[16:27:34] <kali> { "outer_key.inner_key" : the_value }
[16:28:05] <kali> TheFuzzball: http://www.mongodb.org/display/DOCS/Dot+Notation+%28Reaching+into+Objects%29
[16:29:22] <TheFuzzball> It's not an object it's an array, but the db.persons.find({ likes : "math" }) query covers it.
[16:29:33] <TheFuzzball> Apparently if it's in an array you just query normally.
[16:30:02] <ron> well, you don't have a key that's an array. you may have a value that's an array.
[16:34:38] <glaksmono> test
[16:34:39] <glaksmono> hi
[16:35:00] <ron> failed.
[16:58:52] <glaksmono> anyone is around?
[17:00:25] <ron> no. don't wake up the ghosts.
[17:00:46] <glaksmono> lol
[17:00:55] <glaksmono> wondering how does mongodb direct queries to shards?
[17:00:57] <glaksmono> ideas?
[17:01:16] <glaksmono> i.e. how does it know which shard to pick
[17:01:50] <ron> read the docs :)
[17:02:14] <glaksmono> lol
[17:02:18] <glaksmono> i'm suspecting it's from the 3 config servers
[17:02:20] <glaksmono> but i'm not sure
[17:02:34] <glaksmono> i'm even wondering how does it do the mapping
[17:02:48] <glaksmono> and if the 3 servers went down, it wouldn't be able to operate wouldn't it?
[17:03:24] <ron> you have the mongos server that does the routing, and it does that based on what you declare the shard key to be.
[17:07:09] <glaksmono> soo for example if i'm looking for user id 5000
[17:07:15] <glaksmono> how does it know which shard to pick?
[18:03:17] <glaksmono> anyone is around?
[18:03:37] <Gargoyle> glaksmono: o/
[19:39:03] <glaksmono> Gargoyle: hi
[19:39:07] <glaksmono> u still there?
[19:41:20] <Gargoyle> yup
[19:42:39] <Gargoyle> glaksmono: Yup!
[20:27:25] <mrpro> Sun Oct 28 16:18:26 [conn1835010] info DFM::findAll(): extent 0:25f2000 was empty, skipping ahead. ns:api2.endpoints
[20:27:26] <mrpro> whats this
[20:29:14] <ron> it's an info message.
[20:29:56] <mrpro> what does that mean?
[20:30:10] <mrpro> also, sometimes i see query contents in log, and the time it took. does itlog that out when query was too slow?
[21:23:02] <jtomasrl> why does my node server dont accept ajax data with this format: data: { song: id, date: +new Date(), user: "test", help: false, partners: [], likes: 0 }
[21:23:16] <jtomasrl> wrong channel :)
[21:24:52] <TheFuzzball> Is there a way to select custom fields after selecting distinct?
[21:47:55] <mrpro> <mrpro> also, sometimes i see query contents in log, and the time it took. does itlog that out when query was too slow?
[21:48:29] <skot> if a op/query is more than the slowms threshold then it gets logged.
[21:48:42] <skot> default is 100ms
[21:49:16] <skot> TheFuzzball: distinct just returns the field values, that is all you get. maybe you want something like group?
[21:51:07] <TheFuzzball> skot distinct returns an array of distinct values for a specified field
[21:51:54] <TheFuzzball> I want all the distinct values, but I also want their id's, but I have no idea how to do that.
[21:52:17] <TheFuzzball> I tried db.albums.distinct("name _id"), but that just returns an empty array.
[22:28:04] <mrpro> hi
[22:28:06] <mrpro> in mongostat
[22:28:07] <mrpro> whats lock%
[22:28:13] <mrpro> skot
[22:28:22] <mrpro> i am maxing out at 70 updates/s
[22:28:23] <mrpro> wtf
[22:28:52] <mrpro> insert query update delete getmore command flushes mapped vsize res non-mapped faults locked % idx miss % qr|qw ar|aw netIn netOut conn time
[22:28:52] <mrpro> 17 1 74 0 0 20 0 5.89g 14.1g 1.83g 8.18g 0 96.6 0 0|0 0|3 182k 4k 25 18:26:05
[22:28:52] <mrpro> 15 2 68 0 0 20 0 5.89g 14.1g 1.83g 8.18g 0 96.8 0 0|0 0|1 196k 4k 25 18:26:06