Got fatal error 1236 from master when reading data from binary log: ‘Slave has more GTIDs than the m

报错内容:

Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: ‘Slave has more GTIDs than the master
has, using the master’s SERVER_UUID. This may indicate that the end of
the binary log was truncated or that the last binary log file was
lost, e.g., after a power or disk failure when sync_binlog != 1. The
master may or may not have rolled back transactions that were already
replica’
Last_SQL_Errno: 0
Last_SQL_Error: Replicate_Ignore_Server_Ids:
Master_Server_Id: 35
Master_UUID: ea586309-458d-11ee-93ef-000c29ec39e3
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: 230829 19:42:58
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set: 71945dff-463e-11ee-8ed0-000c296ce7ca:1-2,
ea586309-458d-11ee-93ef-000c29ec39e3:1:4:7-11
Auto_Position: 1
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version: 1 row in set (0.00 sec)

意思就是说 你在做gtid主从时,从库的事务id比主库还多 怎么解?

1,在从库上执行 reset master;reset slave all;
2,再在从库上执行 change master to .... 命令就好了

  • 1
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值