[08:50:16] <SeySayux> Hi, does anyone have experience with a good admin UI? I've found this page: http://www.mongodb.org/display/DOCS/Admin+UIs and it seems there's quite a lot of choice. Any recommendations in particular?
[09:53:01] <FrenkyNet> SeySayux: I think those will pop up more and more as webhosts will include it more, I haven't found one that is really pleasing
[09:54:30] <SeySayux> I'm just toying around with MongoDB (I don't have any experience at all, besides installing it through homebrew), just installed RockMongo, looks good to me.
[09:55:02] <ron> RockMongo is fair, but it has a few.. hmm.. less than perfect things in it.
[09:59:38] <SeySayux> Well, besides that whoever made it has absolutely no taste in fonts (Courier? Seriously?) nothing so far that a few lines of CSS couldn't resolve :P
[10:54:45] <timroes> Somehow the java driver fails to save an ArrayList<DBRef>, Howcan I save an array of references to other documents with the java driver? Thanks for your help :)
[11:02:43] <timroes> so beautiful, never seen something so beautiful :') an json array of reference id's to another json document, thanks ron for the kick in the right direction :)
[11:03:03] <ron> whenever you need some kicking, you can always ask.
[11:03:12] <timroes> why do so many ppl offer that to me?
[12:02:00] <remonvv> Alright. Well if you're interested; I'm in the proces of open sourcing a subset of our MongoDB toolset. Looking for a few people to review/contribute.
[12:02:26] <ron> remonvv: we talked about it in the past, let's chat about it a bit later.. going into a meeting.
[13:09:54] <remonvv> it's a subset of our propriety libraries. I'm planning to add MongoDB based MQ and scheduling as well.
[13:10:25] <remonvv> it's a subset in that we have functionality that replaces the current AF and other features that are in the MongoDB roadmap so I've removed those.
[13:10:38] <remonvv> Currently working on code structure
[13:11:32] <remonvv> it's a refreshed version of the persistence layer of our game server and second screen server tech basically.
[13:39:18] <remonvv> I'll make it public when i'm done with the current refactor
[13:39:28] <remonvv> After that i'd much appreciate reviewers and contributors
[13:39:53] <remonvv> Especially review of usability is nice. That's the area where most Java mapping solutions struggle.
[13:40:50] <algernon> if it turns out to be something I can make use of, I'll probably start with throwing some clojure-sugar on it - that should hopefully pick up any bad usability shortcomings
[13:42:37] <remonvv> Alright, I'm looking into scala myself atm for much the same reasons
[13:55:47] <aster1sk> Hey mongoers, have a big problem with the latest PHP driver where all $cmd's are being sent to primary, though the docs state "all of the official drivers support full read preference mode semantics for the following commands".
[13:57:12] <aster1sk> See line 631 https://github.com/mongodb/mongo-php-driver/blob/master/db.c
[14:01:39] <aster1sk> Seems all $cmd go to "php_mongo_connection_force_primary()"
[14:19:55] <Bartzy> yeah but if it needs to do that for 20 million documents - I guess that would be very time consuming ?
[14:20:13] <Bartzy> Instead of just using the index if it had a designated field for that ?
[14:22:02] <kali> Bartzy: well, if you use group, you're running a javascript function. this is terribly slow
[14:22:26] <kali> Bartzy: and you can still use the index to filter what goes through the aggregation
[14:22:41] <Bartzy> I'm coming from MySQL - where if you have only a timestamp field and need to group by the date alone, you will do GROUP BY DATE(timestamp) - which is very slow.
[14:22:55] <Bartzy> and if you have a date field, you can just do GROUP BY date, and if you have an index on date that would be very fast.
[14:23:02] <Bartzy> The same concept goes for MongoDB ?
[14:23:58] <kali> Bartzy: mysql will be fast on select count(*), g group by g where g is indexed. but mongo does not have yet the right optimisation in indexes to run fast counts
[14:33:40] <Bartzy> in the PHP driver, for example in MongoCollection::insert, the docs describe that you can get a status array as a return value, with the 'ok' key.
[14:34:11] <Bartzy> Yeah - bad query, duplicate value on unique index.. all kinds of stuff - when it will not raise an exception, and instead just flag 'ok' as 0 ?
[14:34:42] <Bartzy> It would be easier to assume that if an exception was not raised, the action went through fine...
[14:34:47] <NodeX> because it's not an exception to raise, use getLastError
[14:35:00] <NodeX> or lastError, ... i forget which
[14:35:21] <_m> Or turn 'safe mode' on for those queries
[14:35:26] <aster1sk> Aggregate read preference is broken.... You cann not RP_SECONDARY with the aggregation framework. https://github.com/mongodb/mongo-php-driver/blob/master/mongo.c
[14:35:30] <_m> (Not sure if that's possible with the PHP driver.)
[14:36:04] <Bartzy> _m: It is possible, and I'm using safe mode.
[14:36:11] <NodeX> safe mode will wait for a write to happen but it still wont raise an exception
[14:37:14] <Bartzy> You need to read what I wrote again
[14:49:20] <Bartzy> NodeX: I think I understood...
[14:49:50] <Bartzy> NodeX: http://www.php.net/manual/en/mongocollection.insert.php , the return 'status' array described there - it's relevant only if you have PHP configured to not raise a FATAL error if an exception was not catched ?
[14:50:26] <Bartzy> and then you can continue after the exception was thrown (and not catched), and check the status array - instead of using exceptions and try-catch blocks ?
[15:03:14] <NodeX> if you try{}/catch everything then you can log anythign that goes wrong
[15:03:25] <NodeX> and an error will not be raised in your app for your users to see
[15:36:39] <wzlwzl> for ttl collections, when i do a fineOne in the console… i can use any field that is ISODate, right?
[16:01:36] <dizzy57> Hi, guys. I'm using the python driver and want to create a connection pool without actually connecting (let's say the network is down at the moment). Is pymongo.Connection(_connect=False) safe to use? Is this option supported?
[16:23:28] <cybertoast> is there a way to get password prompt when running a mongo command-line script? for example, `mongo dbname -u username mongoscript.js` does not prompt for password. i've also tried with --username. if i provide the -p option it thinks i'm passing it on the command-line (ie `mongo dbname -u username -p scriptname.js` thinks scriptname.js is the password)
[16:23:47] <cybertoast> this is on OSX with shell version 2.2.0
[16:28:26] <finalspy> hi, anyone knows if there's a way to create a replicaset without restarting a mongo instance ?
[16:39:34] <kali> finalspy: to move from standalone to replica, you need to restart
[16:42:01] <keras> cybertoast: no idea about mongo, but maybe you could create a sh wrapper for that?
[16:43:14] <kenyabob> new to mongodb — whats the function I want to get all the categories from a set of documents?
[16:44:29] <cybertoast> keras, the mongo client allows me to prompt for password if i have the -p option though. i'm just curious about why this doc seems wrong: http://docs.mongodb.org/manual/reference/mongo/
[16:44:50] <cybertoast> kras, specifically this "If you specify a --username without the mongo --password option, mongo will prompt for a password interactively". that's what's not happening for me
[16:44:58] <cybertoast> the "will prompt for a password" part
[16:59:18] <jawr> can anyone help me to understand this error: field not found, expected type 2
[16:59:45] <jawr> i get it when trying to acess a BSONObj
[17:52:13] <kenyabob> lets say I have a hundred songs in a db, and I want to compile all the unique genres for the songs, what would be the quickest way to accomplish that
[18:50:25] <ismarc> Hey folks, I'm having a heck of a time with 2.2.0 trying to run a mapreduce into a sharded collection
[18:51:41] <ismarc> there are 8 shards, on 3 of the shards it runs through all 3 phases and looks like it completes fine. On 5 of the shards, it runs through 2 of the phases and then on the 3rd, there aren't any messages about it at all, it's no longer listed in the currentOp() output and it seems the data from those shards is just gone
[18:52:18] <ismarc> Anyone have any idea where I can look to get more info? mongos and mongod logs don't show anything different except the lack of the 3rd phase running
[18:56:24] <ismarc> Has anyone here successfully done a mapreduce into a sharded collection?
[19:13:55] <aster1sk> Created : https://jira.mongodb.org/browse/PHP-535
[19:14:05] <[raymond]> I'm trying to export a collection using: "mongoexport --db website --collection users --csv --out /tmp/users.csv" but I'm getting the error "assertion: 9998 you need to specify fields"
[19:14:40] <[raymond]> From the documentation it looks like I shouldsn't need to provide a field list, am I reading it incorrectly?
[19:17:16] <syskk> let's say i have a collection posts that have this kind of documents: {body: 'some text', comment: [ {_user: '324', text: 'some comment'} ]}
[19:17:37] <syskk> how can i remove every object in the comment array where _user = 324 ?
[20:03:39] <pmoraes> how can I have a EmbedMany with more than one possible document?
[20:12:46] <jgornick> hey guys, in 2.2, can you now query other collections in a map/reduce job?
[20:25:36] <Alexandro> Good Afternoon I am facing a big problem with my mongo system, this seemed to happen all of the sudden, when I access any of my mongos app servers and try to execute a query I would get an error message like this: error: { "$err" : "can't find shard for: mongoshard1:27017", "code" : 13129 } can any of you help me solve this?
[20:29:20] <Alexandro> Please, I would really appreciate your help.
[20:39:01] <Alexandro> Good Afternoon I am facing a big problem with my mongo system, this seemed to happen all of the sudden, when I access any of my mongos app servers and try to execute a query I would get an error message like this: error: { "$err" : "can't find shard for: mongoshard1:27017", "code" : 13129 } can any of you help me solve this?
[20:58:32] <amontalenti> what's the easiest way to find outlier large documents in a MongoDB collection?
[21:17:23] <Alexandro> I have a mongo configuration like this:
[21:17:23] <Alexandro> The problem I am facing is that not so long ago something happened and the mongos (app servers) were not able any more to get results from queries, when doing this commands an error message appears:
[21:25:18] <mmercer> trying to enable sharding on a db... and it returns a reference error: db is not dfined (shell):1
[21:25:23] <mmercer> why cant i enable sharding :|
[21:25:24] <Gargoyle> I guess the best option is to check that you can connect to it via the name:port in the config. However, shards are not fault tolerant unless each shard is a replica set.
[21:25:46] <mmercer> ( command used is sh.enableSharding(db)
[21:27:26] <Gargoyle> Alexandro: Please do not PM without asking.
[21:28:04] <Gargoyle> Alexandro: If one of your shard nodes fails, you lose that chunk of data!
[21:28:56] <Alexandro> Sorry about that didn't want to confuse, agree but I am able to connect to the actual shards, the problem is with the mongos they return that error of not seeing the shards
[21:29:55] <Gargoyle> Alexandro: Have you tested the connection from the actual machine that mongos is running on?
[21:31:28] <Alexandro> yes I did, "mongo —host mongoshard1" works fine
[21:32:19] <Alexandro> but running "mongo" will open mongos and in there Ill get the error
[21:41:33] <mmercer> hey guys... i just did a db.runcommand("listCommands") on a 2.07 machine... and its missing enablesharding...
[21:41:46] <mmercer> is this a known bug or something ? i cant find any references to why i cant do sharding on it
[22:16:40] <mmercer> wth... where the hell is the enablesharding command
[22:21:59] <bhosie> i think i may have found a bug in the php driver, but wanted to confirm i'm doing this right. trying to do a bulk insert and utilize the continueOnError flag in php. shouldn't this example insert docs 0 and 2? it's throwing an exception and not inserting anything http://pastebin.com/iDz5GM5G
[22:23:03] <Gargoyle> bhosie: What versions of PHP, Driver and Mongo ?
[22:24:54] <bhosie> Gargoyle: this is mongo 2.2 and php driver 1.2.12, php 5.3.10
[22:26:00] <Gargoyle> You might want to double check your results using the 1.3.0beta2 driver from github. There's been a lot of improvements.
[22:26:56] <bhosie> Gargoyle: ok i'll fire up an instance and try that. i was trying to use the 1.3.x driver but it's definitely not production ready so i need 1.2 for now
[22:27:32] <Gargoyle> bhosie: Been using the 1.3.x code in production for about 6 weeks I think! :)
[22:28:47] <bhosie> Gargoyle: how about with a replica set? any issues, i seem to remember it not connecting properly a couple of weeks ago. may have had updates since then though...
[22:29:23] <Gargoyle> bhosie: Using the 1.3.0beta2 tag, and not HEAD.
[22:30:31] <bhosie> hmm... ok. yeah, let me try this bulk insert with that driver and i'll report back
[22:33:20] <bhosie> Gargoyle: k so i did pecl install mongo-beta restarted apache and i'm still having the same issue. exception thrown and no docs inserted
[22:34:14] <Gargoyle> What version does that show?
[22:34:52] <Gargoyle> I clone from github and compile the module manually, not using pecl.
[23:34:48] <Notionwork> I had a question for you folks if anyone is willing to help.
[23:35:38] <Notionwork> I just installed mongodb and I'm loving it! I've been playing around in the command line through terminal, but I can't seem to get mongo to work through PHP.
[23:37:08] <BurtyB> Notionwork, have you got the PECL module compiled/installed ok?
[23:37:24] <Notionwork> I keep getting Class 'Mongo' not found errors when I try to connect to it
[23:39:37] <BurtyB> a simple php file with "<?php phpinfo();" in should show it
[23:40:29] <Notionwork> Lemme check the phpinfo and I'll get right back to you
[23:42:32] <Notionwork> Alright so I fired up the phpinfo() command but where would I look to find the loaded extensions?
[23:43:16] <BurtyB> Notionwork, you should see a heading "mongo"
[23:44:12] <Notionwork> Would that be under the loaded modules section of the apache2handler?
[23:44:44] <Notionwork> Because if it is, it's not there. I tried searching the page for mongo as well to no avail.
[23:46:40] <BurtyB> Notionwork, if it's not in there then you need to check your php.ini and any error logs to see why it didn't load - not sure where these are on osx tho
[23:47:33] <Notionwork> Yup it's not there. I double checked that the correct php.ini (according to the loaded php.ini field in the phpinfo command output) and I have extension=mongo.so in there...
[23:49:08] <Notionwork> Alright so I stopped and started my apache server and this was the output: [17-Oct-2012 23:46:29 UTC] PHP Warning: PHP Startup: mongo: Unable to initialize module
[23:49:09] <Notionwork> Module compiled with module API=20090626
[23:49:10] <Notionwork> PHP compiled with module API=20100525
[23:49:11] <Notionwork> These options need to match