Log file Viewer
#mongodb logs for Monday the 28th of October, 2013
[00:20:42] <defunctzombie> is there a way to force disconnect unauthorized users after a specific time?
[04:08:47] <safani> I want to sort products based on each category..this means a product may have a different sort order for each of the categories it is in
[10:21:32] <quattr8> I have a shared collection with a hashed _id shardkey does this mean I can't add datacenter aware sharding iwth a shardkey?
[11:44:57] <sQVe> I would love some advice on how to handle search in this case: I have a very large database with movies. The titles of the movies need to be searchable. My question is if this should be done with regex, full text search or another method that I do not know of?
[12:26:21] <sQVe> Yeah, I've looked at those options. It just seems a bit overkill when I only need the title to be searchable, and nothing else.
[12:27:16] <Nodex> Mongo can and will do it, it's just not the best tool for it and won't be as relevant as somehting dedicated
[12:29:21] <Nodex> personaly I would recommend solr due to it's longevity, I found ES to be a little green when I last looked at it
[12:30:41] <lineux_007> hey! quick qn. if i delete a capped collection and create a new capped collection (of the same size), will a new data file be created or will the space be reused?
[12:35:25] <cym3try> I have configured my first replica set on a testing environment. If the primary goes down (localhost:27017), and one of the secondary takes over (localhost:27018), how can i make sure that the failover is transparent to the app? can I use haproxy?
[12:49:23] <lineux_007> any thoughts? if i delete a capped collection and create a new capped collection (of the same size), will a new data file be created or will the space be reused? do i have to keep doing repair db?
[12:54:38] <poff> Hi, i wanted to do something like this: db.PlayerRelation.aggregate( { $group: { _id: { $concat: [ "$who.getId().toString()"," ","$user.getId().toString()" ] } } } ); where $who and $user are both a DbRef, but it isn't properlly converting the DbRef to a String
[12:57:58] <poff> and if i do the $concat of $who and $user i get a warning saying that it must be a string
[13:01:34] <Nodex> dbRef's are a convention, they have no special meaning in anything except some ORM/ODM's
[13:03:23] <poff> but if a do something like this on the comand line it works: DBRef("Player", ObjectId("51a5e867d80041e429000000")).getId().toString();
[13:59:48] <hyperboreean> hey, I have the following structure: 'key1': {'key2': []} ... I want to know if key2 exists and doing {'key1.key2': {'$exists': True}} doesn't seem enough (using pymongo here)
[14:00:16] <elux> on http://docs.mongodb.org/manual/core/index-text/ .. it says to now use text search in production...? lol.. is that a joke?
[14:14:50] <kurtis> Hey guys, when doing large read/write operations, I notice the database gets heavily grid-locked. Is there a way to "de-prioritize" certain operations? Especially in the context of using an external (or even internal) map-reduce operation?
[14:22:23] <eldub> I don't think it's a dirty shutdown... I'll chkconfig off reboot and then just start mongod I guess... see if that does it
[14:43:06] <eldub> I just installed mongodb and started it... as soon as I status the service... it's already in a mongod dead but pid file exists....
[14:43:57] <cheeser> ok. stop it just so 'service' doesn't have it listed as running and remove that pid.
[14:45:44] <eldub> mongod: symbol lookup error: mongod: undefined symbol: _ZN7pcrecpp2RE4InitEPKcPKNS_10RE_OptionsE
[15:02:31] <whattata> I've got a question: If I have a document that contains and array, and I want to be able to reference any given object within that array directly, is there a way to have mongo assign an id to each member of the array?
[16:50:46] <Nodex> t0th_- : if you;re system really needs good text search then you should use the right tool for that
[16:52:14] <eydaimon> What's the better architecture if my application is the host of multiple other applications: a) use a separate database for each application I'm hosting, or b) use one database and use collection prefix to keep the collections separate for each app.
[16:55:09] <cheeser> at my previous job, we'd just tag each entity with a customer specific ID and include that in all our queries
[16:56:06] <eydaimon> We need to have some separation in order to be able to bill for diskspace used etc
[16:57:25] <cheeser> then your application code needn't be aware of the customer. you'd just have to connect to the correct database and then everything is simple.
[16:58:15] <eydaimon> Is there any concern with having thousands of databases then? We may host a lot of apps
[16:58:55] <eydaimon> I also figured that if we do per database, there may be some internal sharding logic that is actually in favor of using 'a' as opposed to 'b'
[17:12:31] <kali> smw_: replica set is the way to go except for a handful highly specific scenario (if you need more than ~10 read slaves for instance)
[17:14:48] <kali> cheeser: i'm not sure it's "officialy deprecated", as it helps a few of these very borderline setups
[17:15:38] <kali> cheeser: http://docs.mongodb.org/manual/core/master-slave/ it does not say "deprecated" :)
[17:19:25] <eydaimon> Nodex: So do you think I should add a c) to my question and c is the correct answer?
[17:44:52] <Nodex> eydaimon : in our setup we have a database per client (for their own stuff) and a master database that holds all data (multi tenant system) if that makes sense
[17:45:47] <smw_> I want to give my user readWriteAnyDatabase, userAdminAnyDatabase, dbAdminAnyDatabase and clusterAdmin which should make me all powerful
[17:48:52] <eydaimon> Nodex: yeah, so it sounds like you're doing a) then. How many databases do you have?
[17:51:09] <Nodex> per machine we limit it to 50 per box but that;s purely for managability and redundancy
[18:20:47] <Sodu> I'm trying to add an index to a collection {tags: [ {name:'php', id:100}, {name:'java', id:101} ]}
[19:12:21] <eldub> Is there a guide anywhere that describes setting up a 3 node replica set from scratch?
[19:12:32] <eldub> I'm currently following http://docs.mongodb.org/manual/tutorial/deploy-replica-set/
[19:12:54] <eldub> but when I type 'mongo' in... keeps erroring out about 'couldn't connect to server 127.0.0.1
[19:13:49] <eldub> I think there's confusion. in my mongodb.conf I specified an IP address, and when I type mongo it appears to be looking for 127.0.0.1
[19:22:27] <eldub> tystr when I put the IP bind back to 127.0.0.1 it starts... but when I put the IP of that machine 10.x.x.x it doesnt.
[19:23:53] <JakePee> If a mongocursortimeoutexception is encountered in the php libs, does the connection survive?
[20:46:52] <eydaimon> Nodex: hey, when you said you have 50 clients per box, do you mean just that you add new hosts if you get more clients, or what exactly?
[21:37:10] <eldub> I'll try that again. When I made my config file that, it wouldnt allow me to start mongo. Had some sort of dead locks
[21:52:36] <JakePee> Is there a specific reason in PHP driver, if a find() doesn't have any results, trying to iterate over the cursor throws an exception instead of acting like a 0 element iterator (and just breaking iteration)
[21:58:15] <JakePee> Warning: Invalid argument supplied for foreach() in /home/jake/sandbox/app/bin/scrm/test.php on line 5
[22:07:56] <eldub> I found out why I was getting subsys locks on my mongodb every so often (mainly on reboots)
[22:08:10] <eldub> It's because the log file is owned by root:root and mongodb can't write to the log file...
[23:56:31] <livinded> When setting up a replica set do I need to run rs.initiate() on any other nodes/arbiters I'm going to add from the primary?
[23:57:49] <livinded> I added an arbiter and a second node and the arbiter has stateStr of "UNKNOWN" and the second node "(not reachable/healthy)"
[23:59:38] <livinded> the docs didn't mention anything about authentication. Is there somewhere I need to configure that?