Re: Second Instance in group replication failing

[Edward Allen]

I am experiencing the same problem. This configuration works fine when all three nodes are running on the same machine. When I split the three nodes across three machines (all on the same network) I get the following from mysql-b attempting to join mysql-a (which first bootstrapped) the group replication:


2017-07-19T19:55:20.179780Z 0 [Note] Plugin group_replication reported: 'client connected to mercury.rtp.raleigh.ibm.com 33061 fd 78'
2017-07-19T19:55:50.180607Z 0 [ERROR] Plugin group_replication reported: '[GCS] Timeout while waiting for the group communication engine to be ready!'
2017-07-19T19:55:50.180709Z 0 [ERROR] Plugin group_replication reported: '[GCS] The group communication engine is not ready for the member to join. Local port: 33062'
2017-07-19T19:55:50.180846Z 0 [Note] Plugin group_replication reported: 'state 4257 action xa_terminate'
2017-07-19T19:55:50.180887Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2017-07-19T19:55:50.180896Z 0 [Note] Plugin group_replication reported: 'state 4257 action xa_exit'
2017-07-19T19:55:50.181031Z 0 [Note] Plugin group_replication reported: 'Exiting xcom thread'
2017-07-19T19:55:50.181046Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2017-07-19T19:55:50.181142Z 0 [Warning] Plugin group_replication reported: 'read failed'
2017-07-19T19:55:50.190033Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33062'
2017-07-19T19:56:20.150612Z 8 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2017-07-19T19:56:20.150747Z 8 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2017-07-19T19:56:20.150780Z 8 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2017-07-19T19:56:20.150966Z 8 [Note] Plugin group_replication reported: 'auto_increment_increment is reset to 1'
2017-07-19T19:56:20.150985Z 8 [Note] Plugin group_replication reported: 'auto_increment_offset is reset to 1'
2017-07-19T19:56:20.151286Z 13 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2017-07-19T19:56:20.155693Z 10 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'