Error_code: 1594(mysql 5617)主从同步报错
报错信息
2017-09-05 09:37:22 7425 [ERROR] Slave SQL: 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 ru
nning '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 M
ySQL 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. Error_code: 1594
2017-09-05 09:37:22 7425 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'xxxx-bin.004158' position 101773087
遇到这样的报错首先我想到的是不应该跳过,因为这问题如果跳过,一般都是跳过的正常的update的数据,从库肯定会丢数据,并不是逻辑的问题。这个问题的原因应该是两种,1. 网络问题导致从读取主库binlog,在传输过程中,产生了坏的page。
2. 磁盘IO问题(产生了坏page)
解决方法:
使用上面报错信息中的报错信息 重新change master 。。。。We stopped at log 'xxxx-bin.004158' position 101773087。。。。。
浙公网安备 33010602011771号