本文主要是介绍Plugin group_replication reported: 'Connecting socket to address 192.168.233.137 in port 33061 faile，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！
MySQL Group Replication START GROUP_REPLICATION启动时报错
2018-11-02T14:50:23.337291+08:00 8 [Note] Slave SQL thread for channel 'group_replication_applier' initialized, starting replication in log 'FIRST' at position 0, relay log './node1-relay-bin-group_replication_applier.000015' position: 4
2018-11-02T14:50:23.337339+08:00 3 [Note] Plugin group_replication reported: 'Group Replication applier module successfully initialized!'
2018-11-02T14:50:23.337854+08:00 3 [Note] Plugin group_replication reported: 'auto_increment_increment is set to 7'
2018-11-02T14:50:23.337880+08:00 3 [Note] Plugin group_replication reported: 'auto_increment_offset is set to 137'
2018-11-02T14:50:23.339542+08:00 0 [Note] Plugin group_replication reported: 'state 0 action xa_init'
2018-11-02T14:50:23.639334+08:00 0 [Note] Plugin group_replication reported: 'Successfully bound to 0.0.0.0:33061 (socket=51).'
2018-11-02T14:50:23.639451+08:00 0 [Note] Plugin group_replication reported: 'Successfully set listen backlog to 32 (socket=51)!'
2018-11-02T14:50:23.639510+08:00 0 [Note] Plugin group_replication reported: 'Successfully unblocked socket (socket=51)!'
2018-11-02T14:50:23.639586+08:00 0 [Note] Plugin group_replication reported: 'Ready to accept incoming connections on 0.0.0.0:33061 (socket=51)!'
2018-11-02T14:50:23.639692+08:00 0 [Note] Plugin group_replication reported: 'connecting to 192.168.233.137 33061'
2018-11-02T14:50:23.640343+08:00 0 [Warning] Plugin group_replication reported: 'connect - Error connecting (socket=52, error=13, error message='Permission denied').'
2018-11-02T14:50:23.640380+08:00 0 [Note] Plugin group_replication reported: 'Connecting socket to address 192.168.233.137 in port 33061 failed with error 13 - Permission denied.'
2018-11-02T14:50:24.640661+08:00 0 [Note] Plugin group_replication reported: 'connecting to 192.168.233.137 33061'
2018-11-02T14:50:24.641111+08:00 0 [Warning] Plugin group_replication reported: 'connect - Error connecting (socket=52, error=13, error message='Permission denied').'
2018-11-02T14:50:24.641159+08:00 0 [Note] Plugin group_replication reported: 'Connecting socket to address 192.168.233.137 in port 33061 failed with error 13 - Permission denied.'
2018-11-02T14:50:25.641936+08:00 0 [Note] Plugin group_replication reported: 'connecting to 192.168.233.137 33061'
2018-11-02T14:50:25.642054+08:00 0 [Warning] Plugin group_replication reported: 'connect - Error connecting (socket=52, error=13, error message='Permission denied').'
2018-11-02T14:50:27.645129+08:00 0 [Note] Plugin group_replication reported: 'connecting to 192.168.233.137 33061'
2018-11-02T14:50:27.645236+08:00 0 [Warning] Plugin group_replication reported: 'connect - Error connecting (socket=52, error=13, error message='Permission denied').'
2018-11-02T14:50:27.645251+08:00 0 [Note] Plugin group_replication reported: 'Connecting socket to address 192.168.233.137 in port 33061 failed with error 13 - Permission denied.'
2018-11-02T14:50:28.645825+08:00 0 [Note] Plugin group_replication reported: 'connecting to 192.168.233.137 33061'
2018-11-02T14:50:28.645912+08:00 0 [Warning] Plugin group_replication reported: 'connect - Error connecting (socket=52, error=13, error message='Permission denied').'
2018-11-02T14:50:28.645919+08:00 0 [Note] Plugin group_replication reported: 'Connecting socket to address 192.168.233.137 in port 33061 failed with error 13 - Permission denied.'
2018-11-02T14:50:29.646876+08:00 0 [Note] Plugin group_replication reported: 'connecting to 192.168.233.137 33061'
2018-11-02T14:50:33.651051+08:00 0 [Note] Plugin group_replication reported: 'connecting to 192.168.233.137 33061'
2018-11-02T14:50:33.651347+08:00 0 [Warning] Plugin group_replication reported: 'connect - Error connecting (socket=52, error=13, error message='Permission denied').'
2018-11-02T14:50:33.651385+08:00 0 [Note] Plugin group_replication reported: 'Connecting socket to address 192.168.233.137 in port 33061 failed with error 13 - Permission denied.'
2018-11-02T14:50:33.651533+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] Error connecting to the local group communication engine instance.'
2018-11-02T14:50:33.651582+08:00 0 [Note] Plugin group_replication reported: 'state 4337 action xa_exit'
2018-11-02T14:50:33.652643+08:00 0 [Note] Plugin group_replication reported: 'Exiting xcom thread'
2018-11-02T14:50:33.692120+08:00 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 33061'
2018-11-02T14:51:23.338509+08:00 3 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2018-11-02T14:51:23.338626+08:00 3 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2018-11-02T14:51:23.338665+08:00 3 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2018-11-02T14:51:23.339683+08:00 3 [Note] Plugin group_replication reported: 'auto_increment_increment is reset to 1'
2018-11-02T14:51:23.339885+08:00 3 [Note] Plugin group_replication reported: 'auto_increment_offset is reset to 1'
2018-11-02T14:51:23.341219+08:00 8 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2018-11-02T14:51:23.369092+08:00 5 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
在centos-7 MySQL5.7中按照官方推荐的端口配置为33061，当时在运行的时候报权限错误。在START GROUP_REPLICATION之前我已经关闭了防火墙，命令如下：
# 关闭防火墙
systemctl stop firewalld.service
# 禁用防火墙
systemctl disable firewalld.service
经过一番资源搜索，还需要禁用selinux，配置文件路径/etc/selinux/config修改如下变量值
SELINUX=disabled
然后重启centos即可。
这篇关于Plugin group_replication reported: 'Connecting socket to address 192.168.233.137 in port 33061 faile的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
