Slave_IO_Running: Connecting and Last_IO_Errno: 2003

最新推荐文章于 2023-07-26 13:37:41 发布
最新推荐文章于 2023-07-26 13:37:41 发布 · 404 阅读 · 0

本文介绍了解决MySQL从库出现错误2003（连接到主库失败）的具体步骤。首先确认主库防火墙设置导致的问题，通过关闭主库的防火墙服务解决问题。接着，在从库上停止并重新启动复制进程来恢复正常的数据同步。


mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Connecting to master
Master_Host: 10.88.49.64
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000076
Read_Master_Log_Pos: 26032883
Relay_Log_File: mysql-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.000076
Slave_IO_Running: Connecting
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 26032883
Relay_Log_Space: 107
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 2003
Last_IO_Error: error connecting to master 'replication@10.88.49.64:3306' - retry-time: 60 retries: 86400
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 0
1 row in set (0.00 sec)

-- Last_IO_Errno: 2003 可能是主库防火墙没有关导致的
去主库 service iptables stop;

然后在从库stop slave; start slave; 就搞定了！

iteye_4185
关注
Mariadb: error Relay log read failure: Could not parse relay log event entry
mzhan017的博客
11-22 1009
当然为什么会出现这种文件损坏的情况，主要还是在于操作系统里，对文件缓存的处理，当系统稳定运行，突然的宕机，可能导致内存数据不能及时同步到磁盘，导致后续文件处理出现错误。这里是说读取Relay日志时失败，解析不了Relay日志里的时间记录。这个函数会尝试解Relay日志，如果最后没有解出来，就会有问题。
ubuntu 14.04 + mysql5.6.19：Slave_IO_Running: Connecting&&Last_IO_Errno: 2003 原因排查
土鳖&only29
12-06 1274
master：192.168.10.128 slave：192.168.10.129 在搭建mysql5.6主从复制过程中，show slave status\G;显示以下问题： 日记报以下错误： 说明是slave连不上master，网上搜索了以下，大部分都是说以下原因： 1. 网络不通(ping 192.168.10.128 是通的！) 2. 密码不对(正确)
Last_Error: Relay log read failure: Could not parse relay log event entry.
渔夫数据库笔记
03-06 7015
Last_Error: Relay log read failure: Could not parse relay log event entry. 错误处理详解。
mysql主从异常处理@1594：Relay log read failure: Could not parse relay log event entry.
listening_77的博客
05-06 442
服务器异常宕机后主从异常问题处理，错误编号：1594
【MySQL】Last_SQL_Errno: 1594Relay log read failure: Could not parse relay log event entry...问题总结处理
zclinux的博客
11-30 1067
备库报错： Last_SQL_Errno: 1594 Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay lo
Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons
雅冰石的专栏
08-20 1456
一 问题描述 机房搬迁后启动从库，数据库起来了，但是从库复制报错： mysql> show slave status \G; *************************** 1. row *************************** Slave_IO_State: Master_Host: 172.16.28.90 Master_User: rep_sa
mysql 主从同步排查和处理 Slave_IO、Slave_SQL
global_coding的博客
07-26 1402
mysql 主从同步排查和处理 Slave_IO、Slave_SQL
Slave_IO_State: Connecting to master Master_Host: mysql-master Master_User: slave Master_Port: 3306 Connect_Retry: 30 Master_Log_File: mysql-master-bin.000003 Read_Master_Log_Pos: 2412 Relay_Log_File: mysql-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: mysql-master-bin.000003 Slave_IO_Running: Connecting Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 2412 Relay_Log_Space: 156 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 0 Master_UUID: Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: Master_public_key_path: Get_master_public_key: 0 Network_Namespace:
最新发布
07-16
我们正在排查MySQL主从复制中Slave_IO_Running状态为Connecting的问题。这个状态表示从库的I/O线程正在尝试连接主库但尚未成功。以下是完整的排查步骤： ### 1. 检查主从基础配置 - **主库IP/域名**：确保从库配置...
mysql> show slave status \G *************************** 1. row *************************** Slave_IO_State: Connecting to source Master_Host: 192.168.79.26 Master_User: usersk Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql59.000001 Read_Master_Log_Pos: 693 Relay_Log_File: master1-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: mysql59.000001 Slave_IO_Running: Connecting Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 693 Relay_Log_Space: 157 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 2061 Last_IO_Error: error connecting to master 'usersk@192.168.79.26:3306' - retry-time: 60 retries: 1 message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection. Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 0 Master_UUID: Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_
06-21
### 解决 MySQL 主从复制连接问题（caching_sha2_password 插件） 在 MySQL 8.0 中，默认的身份验证插件为 `caching_sha2_password`，该插件要求安全连接（如...` 检查复制状态，确认 `Last_IO_Error` 是否为空。 ---
mysql> change master to master_host='192.168.0.31',master_user='root',master_password='123456',master_log_file='mysql-bin.000001',master_log_pos=154; ERROR 3021 (HY000): This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR CHANNEL '' first. mysql> show slave status\G\ *************************** 1. row *************************** Slave_IO_State: Connecting to master Master_Host: 192.168.0.31 Master_User: root Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysql-bin.000001 Read_Master_Log_Pos: 154 Relay_Log_File: nle-VirtualBox-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: mysql-bin.000001 Slave_IO_Running: Connecting Slave_SQL_Running: Yes Replicate_Do_DB: nle_test Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 154 Relay_Log_Space: 154 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 2003 Last_IO_Error: error connecting to master 'root@192.168.0.31:3306' - retry-time: 60 retries: 2 Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 0 Master_UUID: Master_Info_File: /var/lib/mysql/master.info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: 250628 22:51:39 Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: Auto_Position: 0 Replicate_Rewrite_DB: Channel_Name: Master_TLS_Version: 1 row in set (0.00 sec)
06-29
MySQL 报错 `ERROR 3021 (HY000): This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR CHANNEL '' first.` 通常出现在尝试修改主从复制配置时，而从节点的 I/O 线程...
mysql 1594_主从问题修复: 1594-Relay log read failure: Could not parse relay log event entry
weixin_39620535的博客
01-27 349
# 主从问题修复: 1594-Relay log read failure: Could not parse relay log event entry``` mysqlmysql> show slave status \G*************************** 1. row ***************************Slave_IO_State: Waiting...
解决Mysql replication error 1594 - Relay log read failure - Could not parse relay log event entry
叫我酋长好吧
07-27 1999
Mysql复制错误1594-中继日志读取失败-无法解析中继日志事件条目 错误信息： Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log i
mysql 数据同步Relay log read failure: Could not parse relay log event entry. The pos
衣旧
07-14 1257
错误 信息: mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: I...
sql error:Last_Error: Relay log read failure: Could not parse relay log event entry. The possible re
企鹅漫步
07-31 2322
show slave status\G: Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbin
mysql主主配置错误：Slave_IO_Running: Connecting and Last_IO_Errno: 2003
anzhen0429的博客
08-02 6404
MySQL> show slave status\G *************************** 1. row ***************************                Slave_IO_State: Connecting to master                   Master_Host: 10.88.49.64            
Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are
DBASun
05-30 1360
 mysql> SHOW SLAVE STATUS\G; *************************** 1. row ***************************                Slave_IO_State: Waiting for master to send event                   Master_Host: 10.10.1
linux搭建mysql主从数据库,Last_IO_Errno: 2003
XinS_D的博客
03-14 4917
所有都配置完之后，Slave_IO_Running显示为Connecting显示的错误为2003，无法连接到主数据库查阅了很多资料，很多都是从以下三个方面着手：1、网络不通  2、密码不对  3、pos不对我尝试了一下都没什么效果，最后发现，原来是主数据库中的my.conf中bind-address没有注释将bind-address注释之后，主从数据库就能连接了...
Slave SQL: Relay log read failure: Could not parse relay log event entry.
weixin_34050389的博客
02-21 222
中午监控报警,某从机ab复制中断,登陆上去show slave status\G看到Last_SQL_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you ...
Slave_IO_Running: Connecting Slave_SQL_Running: Yes
07-16
我们正在处理用户关于MySQL主从复制中Slave_IO_Running状态为"Connecting"的问题。根据引用内容，该问题通常与网络连接、配置错误或权限问题有关。下面将详细分析并给出解决方案。 问题分析： 当执行`SHOW SLAVE ...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值