Log file Viewer

[00:16:30] <Derick> Bodenhaltung: what was it in the end?

[08:00:06] <Bodenhaltung> Derick: I had "explain=true" in my aggregate code, since April 2017. But this feature wasnt implemented, so it breaks nothing, after my update(s) there is now a explain function " PHPLIB-172: Support explain option for aggregate command ". No more words please. :( :D

[08:00:28] <Bodenhaltung> Sorry for the noise. :(

[09:45:14] <Derick> ah, haha

[09:45:31] <Derick> I saw the explain=true in both branches yesterday, but thought you put it there for debugging this issue :D

[09:45:35] <Derick> should have asked, I suppose.

[22:12:28] <kempo> hi togheter. i have some strange behaviour here. when i set the app secret_key, the flask builtin webserver justs exists

[22:12:36] <kempo> oops. wrong chan sorry.

[22:21:49] <RxMcDonald> Hello, anyone knows why a balancer might not be balancing after adding shards?

[22:22:05] <Derick> depends on whether you have multiple chunks at all

[22:22:09] <RxMcDonald> I had 2 shards at 60% capacity each

[22:22:27] <RxMcDonald> Then added another shard, but it's not moving the chunks

[22:23:41] <RxMcDonald> db.coll.getShardDistribution() shows only 2 shards, one with 2162 chunks, the other with 4324 chunks

[22:24:06] <RxMcDonald> Wait that's wrong, both shards have 2162 chunks

[22:24:26] <RxMcDonald> Total is 4324 chunks for both

[22:24:58] <RxMcDonald> Total data 231GB avg obj size on shard: 2KiB

[22:25:15] <RxMcDonald> Derick: Am I forgetting something?

[22:25:20] <Derick> and the third shard is correctly configured?

[22:25:38] <Derick> your output of getShardDistribution suggests not

[22:26:25] <RxMcDonald> Do I need to add the new shard to each other node hosts file?

[22:26:45] <Derick> is your new shard not a replica set?

[22:26:46] <RxMcDonald> I only added it to Mongos, Conf server, and the shard I added

[22:26:50] <RxMcDonald> Yes it is

[22:26:59] <RxMcDonald> sh.status() shows the shard

[22:27:18] <RxMcDonald> sh.status() shows 3 shards (correctly added the third one)

[22:27:39] <RxMcDonald> All databases have sharding and balancing enabled

[22:28:17] <Derick> can you show sh.status() output in a pastebin?

[22:28:41] <RxMcDonald> ure

[22:28:45] <RxMcDonald> Sure

[22:30:46] <RxMcDonald> https://pastebin.com/yWVjZxrC

[22:32:06] <Derick> can mongos talk to the shards?

[22:32:55] <RxMcDonald> db.coll.findOne() works, so I gues yes, for the newly added shard I don't know

[22:33:20] <Derick> I'd have a look in the logs

[22:33:55] <RxMcDonald> You mean show log global in Mongos?

[22:34:11] <RxMcDonald> because that shows nothing

[22:36:49] <RxMcDonald> I really see nothing in show log global in Mongos, it only shows connections, no errors

[22:38:48] <RxMcDonald> It says "Successfully connected to shardsvr4:27017" 38 minutes ago

[22:39:12] <RxMcDonald> Derick: Any other logs I could check?

[22:39:57] <RxMcDonald> db.stats() shows the new shard with 0 in everything

[22:40:31] <RxMcDonald> What I'm not sure is if the shards can talk to each other because I didn't add the new shard to their hosts file

[22:44:34] <RxMcDonald> Wow looks like that fixed it

[22:44:49] <RxMcDonald> Derick: It's fixed

[22:44:55] <Derick> :)

[22:44:59] <Derick> sorry. How? :-)

[22:45:14] <Derick> they do need to talk to each other, but I wouldn't recommend you use hosts files for that

[22:45:21] <RxMcDonald> I had to add the new shard to the other shards hosts files

[22:45:52] <RxMcDonald> then ran a sh.setBalancerState(true) just in case

[22:46:04] <RxMcDonald> Well, not sure why I had to do that either

[22:46:22] <Derick> from your pastebin that looked unnecessary

[22:46:30] <RxMcDonald> Indeed

[22:48:32] <RxMcDonald> 41: Success, 1: Failed with error 'aborted' from shrs1 to sh2rs2

[22:49:20] <RxMcDonald> Another one failed from sh0rs0 to sh2rs2, no idea why, it 'aborted'

[22:53:58] <Derick> recently? There can be reasons, you should check all the logs of the involved servers

[22:54:06] <Derick> but it's bed time for me

[22:55:43] <RxMcDonald> Derick: Same here, thanks for helping me out

[22:55:50] <Derick> no prob!