Log file Viewer
#mongodb logs for Friday the 19th of June, 2015
[06:34:45] <acidjazz> hey all.. oddest thing even though i know im applying a sort->skip->limit on my mongo query it for some reason returns all the rows no matter what.
[07:28:25] <MatToufoutaf> I'd like to set failIndexKeyTooLong=false in the config, but I don't find how to do this with the old config format, do I have to rewrite my config file to YAML for it to work? (if so, is there an easy way to convert a format to the other?)
[07:29:38] <Boomtime> MatToufoutaf: the old format is not being maintained, if the option you want is new then it won't exist there
[07:49:34] <MatToufoutaf> Boomtime, thanks, so, is there a way to convert easily the old format to the new one? or do I have to search through the documentation to find to which section every old config entry belongs?
[08:24:38] <luc4> Hello! I would like to set the key in a nested object of a document with an update query. Something like adding k3 to {keys: {k1: v1, k2: v2}} but where k3 is stored in a variable. Something like this: http://pastebin.com/r3DCHQBH. Any way to do it?
[08:39:09] <luc4> I found what I was looking for: http://stackoverflow.com/questions/6702450/variable-with-mongodb-dotnotation.
[09:05:59] <mitereiter> but the Index were created on some shards, because when I want to insert on those shards I get the error value to large for index
[10:26:33] <mitereiter> but the Index were created on some shards, because when I want to insert on those shards I get the error value to large for index
[11:11:10] <max2000> Hi, I'm having a small challenge with mongodb 3.0.4 and I was hoping some of you may have an idea what's going on. On this mongo I have the rest interface on and the http interface on. When I have authorization turned off I can access http://server/ just fine. When I turn authorization on it asks me for a username and password. Any username I can successfully log in with through 'mongo' on the cli is not accepted by the web interface
[11:11:16] <max2000> Should users get a special role or something in order to be able to access the http interface?
[11:15:26] <joannac> "If you must use the REST API, please control and limit access to the REST API. The REST API does not include any support for authentication, even when running with authorization enabled."
[11:19:49] <max2000> thanks for the details. I think I'll accept the situation and wait for this: https://jira.mongodb.org/browse/SERVER-17390
[12:10:16] <mitereiter> but the Index were created on some shards, because when I want to insert on those shards I get the error value to large for index
[14:06:24] <leandroa> I have a schema that includes an object of array of objects, what's the easy way to do an increment to a value in the deeper object?
[14:07:21] <leandroa> I need to increment `values.hourly.5.clicks` for object with tool == page-view, for example
[14:13:07] <leandroa> I think I got it.. db.coll.update({_id: {..}, 'values.hourly.5.tool': 'page-view'}, {$inc: {'values.hourly.5.clicks': 1}})
[14:18:45] <s2013> if i have dates liek this 06/01/2015 how do i query by that? like greater than for example
[14:25:47] <s2013> nvm.. but im using mongoose and i have a product those date is 06/17/2015 but it doesnt appear even though my query is query.lte
[14:28:01] <watmm> Hey, wondering what the best way of restricting inbound connections to a hostname is
[14:32:43] <fxmulder> so I have a 6 node cluster, 2 replica sets of 3 nodes each. I recently setup sharding so the first replica set migrated half its data to the second replica set
[14:33:16] <fxmulder> the first replica set didn't shrink in disk usage as expected but it is still growing and is about to run out of disk
[14:45:50] <fxmulder> if I stat() the collection in the two different replica sets, the first replica set has almost double the count of the second
[14:47:41] <no-thing_> Hello, could someone comment on my problem? if i execute on database db.printCollectionStats(); command i don't see any sharded collections (all are sharded:false) yet in sh.status() i see this ouput his output? http://codepaste.net/49euep . Why is that? What that "database." <-- dot means?
[15:10:07] <no-thing_> sometimes something happens unexpected and sharding does not work as it should etc. until then i think there should be such function >:3
[15:26:25] <deathanchor> I stop trusting myself after the 5th hour, hence I do some testing at the end of the day, and then check my tests again the next morning
[15:56:34] <fxmulder> after sharding is enabled and chunks are migrated, do you have to do something to remove the old migrated data on the original shard?
[16:00:13] <GothAlice> deathanchor: Speaking of testing… had production fail after a deployment push because of one unpinned package changing one line to "fix" the "feature" we were abusing. ^_^
[16:00:45] <GothAlice> deathanchor: The symptom was "can't look up 'modified' field of object None". Super, duper helpful.
[16:02:34] <GothAlice> fxmulder: AFIK MongoDB should automatically clean those up once it's confirmed migration off the initial host.
[16:09:41] <GothAlice> fxmulder: Ref: http://stackoverflow.com/questions/15430127/how-to-remove-chunks-from-mongodb-shard and http://docs.mongodb.org/manual/tutorial/remove-shards-from-cluster/
[16:09:54] <GothAlice> There might not actually be data in the shards you are seeing and wanting to move. ;)
[16:15:28] <fxmulder> its almost double that of the new replica set which makes me think it includes the old data
[16:16:30] <fxmulder> if it does indeed include the old data I suppose I could script something up to see if it finds duplicates between the two replica sets
[16:51:56] <fxmulder> so if I shard based on message_identifier and I have a specific message_identifier value, whats the best way to determine what shard it should belong to?
[17:18:25] <GothAlice> Huzzah, the biggest outstanding WiredTiger ticket impacting my dataset has been resolved.
[17:28:11] <fxmulder> whats wrong with this query? db.chunks.find({min: { $lte: '0001e07f9c55d06f3b7c989dcbd58e6e.01e87d8cee3ac229c4c64a1fd35fb667cd11a400.1399902906'}}) I'm trying to match against http://nsab.us/public/mongodb
[18:27:13] <acidjazz> whats hte proper query for when my document has an aray of text fields and i want to see if my value is in one of them
[18:34:41] <GothAlice> {myarray: 'somevalue'} will compare somevalue against each array element, and if one matches the document matches.
[18:36:49] <GothAlice> acidjazz: http://showterm.io/394316f3ae9fbafca86dc < then the structure you actually have is not the structure you think you have
[18:45:53] <acidjazz> if i stack that with an $and and do this again will it only filter categories that have BOTH?
[18:47:14] <acidjazz> so this newer API has a debug mode that exposes all my mongo things which has been a great help
[18:49:28] <acidjazz> sort of a combinatino of API layer -> Mongo Listing layer -> Mongo Model Management
[18:49:59] <acidjazz> like i have this dollection, i want these fields sortable, and these fields filterable
[18:50:34] <acidjazz> what i can filter, whats filtered, what page im on, how many pages, total amount, etc.
[18:52:01] <acidjazz> eventually your actual class to interact with the document kinda looks like this https://gist.github.com/anonymous/0e4b6224426e2e6e9f00
[19:28:02] <morenoh149> greyTEO: never using the java driver. usually the resultset includes the _id field
[21:56:39] <fxmulder> I currently have mongodb-10gen installed using the downloads-distro.mongodb.org ubuntu repo