mgr安装-启动主节点报错-[ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Unable to ...

2019/10/28 14:58
阅读数 475

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.

mysql>

 

查看日志:

2019-10-24T08:33:41.605526Z 7 [Note] [MY-011546] [Repl] Plugin group_replication reported: 'auto_increment_increment is set to 7'

2019-10-24T08:33:41.605545Z 7 [Note] [MY-011547] [Repl] Plugin group_replication reported: 'auto_increment_offset is set to 1'

2019-10-24T08:33:41.605631Z 12 [Note] [MY-010581] [Repl] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log '/mysqldata/mysql_3316/logs/relaylog/relay-bin-group_replication_applier.000001' position: 4

2019-10-24T08:33:41.755038Z 0 [Note] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Unable to bind to INADDR_ANY:3316 (socket=44, errno=98)!'

2019-10-24T08:33:41.755102Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Unable to announce tcp port 3316. Port already in use?'

2019-10-24T08:33:41.755223Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] Error joining the group while waiting for the network layer to become ready.'

2019-10-24T08:33:41.755323Z 0 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 3316'

2019-10-24T08:34:41.605882Z 7 [ERROR] [MY-011640] [Repl] Plugin group_replication reported: 'Timeout on wait for view after joining group'

2019-10-24T08:34:41.605945Z 7 [Note] [MY-011649] [Repl] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'

2019-10-24T08:34:41.605981Z 7 [ERROR] [MY-011735] [Repl] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'

2019-10-24T08:34:41.606803Z 7 [Note] [MY-011544] [Repl] Plugin group_replication reported: 'auto_increment_increment is reset to 1'

2019-10-24T08:34:41.606833Z 7 [Note] [MY-011545] [Repl] Plugin group_replication reported: 'auto_increment_offset is reset to 1'

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

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

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

 

解决:

修改前:
loose-group_replication_local_address= "192.168.xxx.xxx:3316"
loose-group_replication_group_seeds= "192.168.xxx.xxx:3316,192.168.x.x:3316,192.168.x.x:3316"

修改后:
loose-group_replication_local_address= "192.168.xxx.xxx:3316"
loose-group_replication_group_seeds= "192.168.xxx.xxx:23316,192.168.x.x:23316,192.168.x.x:23316"

 

重要

组复制使用此地址进行使用XCom的内部成员到成员连接。此地址必须与用于SQL的主机名和端口不同,并且不得用于客户端应用程序。

在运行组复制时,必须为组成员之间的内部通信保留它。

展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部