mgr安装 加入第二个节点报错-[ERROR] [MY-011526] [Repl] Plugin group_replication reported: 'This member has more executed transactions than those present in the grou

mysql> start group_replication;

ERROR 3092 (HY000): The server is not configured properly to be an active member of the group. Please see more details on error log.

 

查看日志:

2019-10-24T09:12:37.151750Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] This server adjusted its communication protocol to 8.0.16 in order to join the group.'

2019-10-24T09:12:37.151834Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Group is able to support up to communication protocol version 8.0.16'

2019-10-24T09:12:37.151981Z 0 [ERROR] [MY-011526] [Repl] Plugin group_replication reported: 'This member has more executed transactions than those present in the group. Local transactions: e0c97c95-f571-11e9-933b-001b785baebb:1 > Group transactions: c2840554-f56b-11e9-8d9b-6cb3113192fc:1,

cc13c1f4-f631-11e9-83fe-6cb3113192fc:1'

2019-10-24T09:12:37.152022Z 0 [ERROR] [MY-011522] [Repl] Plugin group_replication reported: 'The member contains transactions not present in the group. The member will now exit the group.'

2019-10-24T09:12:37.152075Z 0 [Note] [MY-011503] [Repl] Plugin group_replication reported: 'Group membership changed to dsmgr1:3316, dsmgr2:3316 on view 15719073195146984:2.'

2019-10-24T09:12:37.152113Z 7 [Note] [MY-011647] [Repl] Plugin group_replication reported: 'Going to wait for view modification'

2019-10-24T09:12:37.153469Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Re-using server node 0 host xxx.xxx.xxx.xxx'

2019-10-24T09:12:37.153516Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Installed site start={77654092 551 0} boot_key={77654092 540 1} event_horizon=10 node 4294967295'

2019-10-24T09:12:40.517382Z 0 [Note] [MY-011504] [Repl] Plugin group_replication reported: 'Group membership changed: This member has left the group.'

2019-10-24T09:12:40.518266Z 7 [Note] [MY-011544] [Repl] Plugin group_replication reported: 'auto_increment_increment is reset to 1'

2019-10-24T09:12:40.518303Z 7 [Note] [MY-011545] [Repl] Plugin group_replication reported: 'auto_increment_offset is reset to 1'

2019-10-24T09:12:40.518718Z 12 [Note] [MY-010596] [Repl] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed

2019-10-24T09:12:40.518761Z 12 [Note] [MY-010587] [Repl] Slave SQL thread for channel 'group_replication_applier' exiting, replication stopped in log 'FIRST' at position 0

2019-10-24T09:12:40.519888Z 9 [Note] [MY-011444] [Repl] Plugin group_replication reported: 'The group replication applier thread was killed.'

 

 

解决办法 reset master;
原因是在这个节点有操作了之前创建了用户因为是初始化安装所以可以 reset master  清空Executed_Gtid_Set