在本地端口33061上打开到slave1:33061的连接时出错该怎么办，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。

单主模式，主启动start replication报错，error log信息如下。

2020-02-16T09:09:33.116741+08:002[Note]Plugingroup_replicationreported:'GroupcommunicationSSLconfiguration:group_replication_ssl_mode:"DISABLED"'2020-02-16T09:09:33.116927+08:002[Note]Plugingroup_replicationreported:'[GCS]AddedautomaticallyIPranges127.0.0.1/8,192.168.199.128/24,192.168.6.10/24tothewhitelist'2020-02-16T09:09:33.117221+08:002[Note]Plugingroup_replicationreported:'[GCS]Translated'master'to192.168.6.10'2020-02-16T09:09:33.117423+08:002[Warning]Plugingroup_replicationreported:'[GCS]AutomaticallyaddingIPv4localhostaddresstothewhitelist.Itismandatorythatitisadded.'2020-02-16T09:09:33.117481+08:002[Note]Plugingroup_replicationreported:'[GCS]SSLwasnotenabled'2020-02-16T09:09:33.117509+08:002[Note]Plugingroup_replicationreported:'Initializedgroupcommunicationwithconfiguration:group_replication_group_name:"dabbfd02-4e51-11ea-918c-080027b4aaaa";group_replication_local_address:"master:33061";group_replication_group_seeds:"master:33061,slave1:33061,slave2:33061";group_replication_bootstrap_group:false;group_replication_poll_spin_loops:0;group_replication_compression_threshold:1000000;group_replication_ip_whitelist:"AUTOMATIC"'2020-02-16T09:09:33.117539+08:002[Note]Plugingroup_replicationreported:'[GCS]Configurednumberofattemptstojoin:0'2020-02-16T09:09:33.117547+08:002[Note]Plugingroup_replicationreported:'[GCS]Configuredtimebetweenattemptstojoin:5seconds'2020-02-16T09:09:33.117569+08:002[Note]Plugingroup_replicationreported:'Memberconfiguration:member_id:103306;member_uuid:"dabbfd02-4e51-11ea-918c-080027b499bb";single-primarymode:"true";group_replication_auto_increment_increment:7;'2020-02-16T09:09:33.119535+08:0046[Note]'CHANGEMASTERTOFORCHANNEL'group_replication_applier'executed'.Previousstatemaster_host='<NULL>',master_port=0,master_log_file='',master_log_pos=4,master_bind=''.Newstatemaster_host='<NULL>',master_port=0,master_log_file='',master_log_pos=4,master_bind=''.2020-02-16T09:09:33.281383+08:0049[Note]SlaveSQLthreadforchannel'group_replication_applier'initialized,startingreplicationinlog'FIRST'atposition0,relaylog'./relay-group_replication_applier.000001'position:42020-02-16T09:09:33.281390+08:002[Note]Plugingroup_replicationreported:'GroupReplicationappliermodulesuccessfullyinitialized!'2020-02-16T09:09:33.281531+08:002[Note]Plugingroup_replicationreported:'auto_increment_incrementissetto7'2020-02-16T09:09:33.281540+08:002[Note]Plugingroup_replicationreported:'auto_increment_offsetissetto103306'2020-02-16T09:09:33.282016+08:000[Note]Plugingroup_replicationreported:'XComprotocolversion:3'2020-02-16T09:09:33.282421+08:000[Note]Plugingroup_replicationreported:'XCominitializedandreadytoacceptincomingconnectionsonport33061'2020-02-16T09:09:33.284679+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.285265+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.286212+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.286750+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.287545+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.288241+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.288742+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.289415+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.290746+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.291361+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.294982+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.298791+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.301144+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.301934+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.303234+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.303757+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.305372+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.305926+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.307075+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:09:33.308316+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:09:33.308394+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Errorconnectingtoallpeers.Memberjoinfailed.Localport:33061'2020-02-16T09:09:33.309449+08:000[Warning]Plugingroup_replicationreported:'readfailed'2020-02-16T09:09:33.340149+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Thememberwasunabletojointhegroup.Localport:33061'2020-02-16T09:10:33.282660+08:002[ERROR]Plugingroup_replicationreported:'Timeoutonwaitforviewafterjoininggroup'2020-02-16T09:10:33.282766+08:002[Note]Plugingroup_replicationreported:'Requestingtoleavethegroupdespiteofnotbeingamember'2020-02-16T09:10:33.282857+08:002[ERROR]Plugingroup_replicationreported:'[GCS]Thememberisleavingagroupwithoutbeingonone.'2020-02-16T09:10:33.283116+08:002[Note]Plugingroup_replicationreported:'auto_increment_incrementisresetto1'2020-02-16T09:10:33.283189+08:002[Note]Plugingroup_replicationreported:'auto_increment_offsetisresetto1'2020-02-16T09:10:33.283435+08:0049[Note]Errorreadingrelaylogeventforchannel'group_replication_applier':slaveSQLthreadwaskilled2020-02-16T09:10:33.285442+08:0049[Note]SlaveSQLthreadforchannel'group_replication_applier'exiting,replicationstoppedinlog'FIRST'atposition02020-02-16T09:10:33.289619+08:0046[Note]Plugingroup_replicationreported:'Thegroupreplicationapplierthreadwaskilled'2020-02-16T09:10:55.742615+08:002[Note]Plugingroup_replicationreported:'GroupcommunicationSSLconfiguration:group_replication_ssl_mode:"DISABLED"'2020-02-16T09:10:55.756577+08:002[Note]Plugingroup_replicationreported:'[GCS]AddedautomaticallyIPranges127.0.0.1/8,192.168.199.128/24,192.168.6.10/24tothewhitelist'2020-02-16T09:10:55.757165+08:002[Note]Plugingroup_replicationreported:'[GCS]Translated'master'to192.168.6.10'2020-02-16T09:10:55.757534+08:002[Warning]Plugingroup_replicationreported:'[GCS]AutomaticallyaddingIPv4localhostaddresstothewhitelist.Itismandatorythatitisadded.'2020-02-16T09:10:55.757663+08:002[Note]Plugingroup_replicationreported:'[GCS]SSLwasnotenabled'2020-02-16T09:10:55.757709+08:002[Note]Plugingroup_replicationreported:'Initializedgroupcommunicationwithconfiguration:group_replication_group_name:"dabbfd02-4e51-11ea-918c-080027b4aaaa";group_replication_local_address:"master:33061";group_replication_group_seeds:"master:33061,slave1:33061,slave2:33061";group_replication_bootstrap_group:false;group_replication_poll_spin_loops:0;group_replication_compression_threshold:1000000;group_replication_ip_whitelist:"AUTOMATIC"'2020-02-16T09:10:55.757820+08:002[Note]Plugingroup_replicationreported:'[GCS]Configurednumberofattemptstojoin:0'2020-02-16T09:10:55.757865+08:002[Note]Plugingroup_replicationreported:'[GCS]Configuredtimebetweenattemptstojoin:5seconds'2020-02-16T09:10:55.757923+08:002[Note]Plugingroup_replicationreported:'Memberconfiguration:member_id:103306;member_uuid:"dabbfd02-4e51-11ea-918c-080027b499bb";single-primarymode:"true";group_replication_auto_increment_increment:7;'2020-02-16T09:10:55.758605+08:0067[Note]'CHANGEMASTERTOFORCHANNEL'group_replication_applier'executed'.Previousstatemaster_host='<NULL>',master_port=0,master_log_file='',master_log_pos=4,master_bind=''.Newstatemaster_host='<NULL>',master_port=0,master_log_file='',master_log_pos=4,master_bind=''.2020-02-16T09:10:55.920189+08:002[Note]Plugingroup_replicationreported:'GroupReplicationappliermodulesuccessfullyinitialized!'2020-02-16T09:10:55.920231+08:002[Note]Plugingroup_replicationreported:'auto_increment_incrementissetto7'2020-02-16T09:10:55.920238+08:002[Note]Plugingroup_replicationreported:'auto_increment_offsetissetto103306'2020-02-16T09:10:55.920209+08:0070[Note]SlaveSQLthreadforchannel'group_replication_applier'initialized,startingreplicationinlog'FIRST'atposition0,relaylog'./relay-group_replication_applier.000001'position:42020-02-16T09:10:55.920573+08:000[Note]Plugingroup_replicationreported:'XComprotocolversion:3'2020-02-16T09:10:55.920619+08:000[Note]Plugingroup_replicationreported:'XCominitializedandreadytoacceptincomingconnectionsonport33061'2020-02-16T09:10:55.922466+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.922982+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.923726+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.924263+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.925630+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.926269+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.928161+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.928693+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.929229+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.929756+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.930493+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.931816+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.933292+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.933901+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.935244+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.935834+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.936974+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.938195+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.940129+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave1:33061onlocalport:33061.'2020-02-16T09:10:55.940770+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Erroronopeningaconnectiontoslave2:33061onlocalport:33061.'2020-02-16T09:10:55.940847+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Errorconnectingtoallpeers.Memberjoinfailed.Localport:33061'2020-02-16T09:10:55.944309+08:000[Warning]Plugingroup_replicationreported:'readfailed'2020-02-16T09:10:55.973522+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Thememberwasunabletojointhegroup.Localport:33061'2020-02-16T09:11:55.922733+08:002[ERROR]Plugingroup_replicationreported:'Timeoutonwaitforviewafterjoininggroup'2020-02-16T09:11:55.922848+08:002[Note]Plugingroup_replicationreported:'Requestingtoleavethegroupdespiteofnotbeingamember'2020-02-16T09:11:55.922907+08:002[ERROR]Plugingroup_replicationreported:'[GCS]Thememberisleavingagroupwithoutbeingonone.'2020-02-16T09:11:55.923147+08:002[Note]Plugingroup_replicationreported:'auto_increment_incrementisresetto1'2020-02-16T09:11:55.923175+08:002[Note]Plugingroup_replicationreported:'auto_increment_offsetisresetto1'2020-02-16T09:11:55.923352+08:0070[Note]Errorreadingrelaylogeventforchannel'group_replication_applier':slaveSQLthreadwaskilled2020-02-16T09:11:55.924343+08:0070[Note]SlaveSQLthreadforchannel'group_replication_applier'exiting,replicationstoppedinlog'FIRST'atposition02020-02-16T09:11:55.929722+08:0067[Note]Plugingroup_replicationreported:'Thegroupreplicationapplierthreadwaskilled'^Cchkconfigiptablesoff[root@mastermysql_data]#chkconfigiptablesoff[root@mastermysql_data]#[root@mastermysql_data]#tail-ferror.log2020-02-16T09:10:55.944309+08:000[Warning]Plugingroup_replicationreported:'readfailed'2020-02-16T09:10:55.973522+08:000[ERROR]Plugingroup_replicationreported:'[GCS]Thememberwasunabletojointhegroup.Localport:33061'2020-02-16T09:11:55.922733+08:002[ERROR]Plugingroup_replicationreported:'Timeoutonwaitforviewafterjoininggroup'2020-02-16T09:11:55.922848+08:002[Note]Plugingroup_replicationreported:'Requestingtoleavethegroupdespiteofnotbeingamember'2020-02-16T09:11:55.922907+08:002[ERROR]Plugingroup_replicationreported:'[GCS]Thememberisleavingagroupwithoutbeingonone.'2020-02-16T09:11:55.923147+08:002[Note]Plugingroup_replicationreported:'auto_increment_incrementisresetto1'2020-02-16T09:11:55.923175+08:002[Note]Plugingroup_replicationreported:'auto_increment_offsetisresetto1'2020-02-16T09:11:55.923352+08:0070[Note]Errorreadingrelaylogeventforchannel'group_replication_applier':slaveSQLthreadwaskilled2020-02-16T09:11:55.924343+08:0070[Note]SlaveSQLthreadforchannel'group_replication_applier'exiting,replicationstoppedinlog'FIRST'atposition02020-02-16T09:11:55.929722+08:0067[Note]Plugingroup_replicationreported:'Thegroupreplicationapplierthreadwaskilled'

防火墙状态都是关闭的

show master status;

mysql(root@(none)09:49:42)>showmasterstatus;+------------+----------+--------------+------------------+-------------------+|File|Position|Binlog_Do_DB|Binlog_Ignore_DB|Executed_Gtid_Set|+------------+----------+--------------+------------------+-------------------+|bin.000002|150||||+------------+----------+--------------+------------------+-------------------+1rowinset(0.00sec)

因为之前执行了reset master；

随便执行一个事务就好了

mysql(root@mysql09:50:08)>showmasterstatus;+------------+----------+--------------+------------------+----------------------------------------+|File|Position|Binlog_Do_DB|Binlog_Ignore_DB|Executed_Gtid_Set|+------------+----------+--------------+------------------+----------------------------------------+|bin.000002|330|||dabbfd02-4e51-11ea-918c-080027b499bb:1|+------------+----------+--------------+------------------+----------------------------------------+1rowinset(0.00sec)

看完上述内容，你们掌握在本地端口33061上打开到slave1:33061的连接时出错该怎么办的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注亿速云行业资讯频道，感谢各位的阅读！