惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
博客园 - 聂微东
博客园 - 叶小钗
爱范儿
爱范儿
罗磊的独立博客
Hugging Face - Blog
Hugging Face - Blog
阮一峰的网络日志
阮一峰的网络日志
S
SegmentFault 最新的问题
Apple Machine Learning Research
Apple Machine Learning Research
美团技术团队
T
Tailwind CSS Blog
博客园 - 司徒正美
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
宝玉的分享
宝玉的分享
量子位
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
The Cloudflare Blog
人人都是产品经理
人人都是产品经理
小众软件
小众软件
博客园 - 【当耐特】
博客园 - 三生石上(FineUI控件)
V
Visual Studio Blog
雷峰网
雷峰网
酷 壳 – CoolShell
酷 壳 – CoolShell

博客园 - digdeep

javax.imageio.IIOException: Invalid icc profile: duplicate sequence numbers Tomcat配置支持软连接 记一例DNS解析导致的系统卡顿问题 nginx配置透传自定义文件头 访问RustFS中的图片时,浏览器报错 (failed)net::ERR_BLOCKED_BY_ORB mysql主从复制报错:Last_Errno: 1872 Last_Error: Slave failed to initialize relay log info structure from the repository 华为云平台的操作系统因为OOM而重启的解决方法 passwd 修改密码报错“passwd: 鉴定令牌操作错误” mysql主从复制报错:Last_SQL_Errno: 1114 Last_SQL_Error: Coordinator stopped because there were error(s) in the worker(s) 解决Linux下生成PDF中文乱码的问题 centos编译安装opencv mysql搭建主从复制时一直报错 Last_IO_Errno: 2026 kswapd0进程占用cpu非常高 ./configure: error: SSL modules require the OpenSSL library. maven mvn install 报错: unable to find valid certification path to requested target 错误 升级Nginx,--with-openssl踩坑记录 Name or service not known Kernel panic - not syncing: Out of memory: system-wide panic_on_oom is enabled ERROR 2059 (HY000): Plugin caching_sha2_password could not be loaded gh-ost 报错 ERROR 1236 (HY000): A slave with the same server_uuid/server_id as this slave
mysql主从复制从库报错:Last_Errno: 1594
digdeep · 2025-05-02 · via 博客园 - digdeep
mysql> show slave status\G
*************************** 1. row ***************************
               Slave_IO_State: Queueing master event to the relay log
                  Master_Host: xxxxx
                  Master_User: repli_canlian
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000007
          Read_Master_Log_Pos: 200180213
               Relay_Log_File: mysql-0001-relay-bin.000008
                Relay_Log_Pos: 202415757
        Relay_Master_Log_File: mysql-bin.000006
             Slave_IO_Running: Yes
            Slave_SQL_Running: No
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 1594
                   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 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 202415544
              Relay_Log_Space: 1274179963
              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: 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 log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SHOW SLAVE STATUS' on this slave.
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 1333306
                  Master_UUID: 101625c8-0aac-11f0-aa6f-b4055d9cf7d0
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: 
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 
     Last_SQL_Error_Timestamp: 250502 03:52:30
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
           Retrieved_Gtid_Set: 101625c8-0aac-11f0-aa6f-b4055d9cf7d0:1-513422
            Executed_Gtid_Set: 101625c8-0aac-11f0-aa6f-b4055d9cf7d0:1-308085,
9a903bf7-f7dc-11ea-b874-fa163ef132e7:1-20849050627
                Auto_Position: 1
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Master_TLS_Version: 
1 row in set (12.63 sec)

原因是从库磁盘不足了,导致中继日志损坏。解决办法:

stop slave;
reset slave;
change master to master_host='xxx',master_port=3306,master_user='xxxx',master_password='xxx',master_auto_position=1;

start slave;

重新拉取日志,搞定。