MySQL 5.7復(fù)制報錯Client requested master to start replication from impossible怎么辦

這篇文章將為大家詳細(xì)講解有關(guān)MySQL 5.7復(fù)制報錯Client requested master to start replication from impossible怎么辦，小編覺得挺實用的，因此分享給大家做個參考，希望大家閱讀完這篇文章后可以有所收獲。

錯誤日志中的信息
2017-12-12T07:41:47.070228Z 57896 [ERROR] Error reading packet from server for channel 'master_4': Client requested master to start replication from impossible position; the first event 'mysql-bin.000003' at 31342251, the last event read from '/data/db_log/mysql-bin.000003' at 4, the last byte read from '/data/db_log/mysql-bin.000003' at 4. (server_errno=1236)

2017-12-12T07:41:47.077618Z 57896 [ERROR] Slave I/O for channel 'master_4': Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the first event 'mysql-bin.000003' at 31342251, the last event read from '/data/db_log/mysql-bin.000003' at 4, the last byte read from '/data/db_log/mysql-bin.000003' at 4.', Error_code: 1236

報錯原因
執(zhí)行 change master 語句時，里面的 master_log_file 寫的不正確

解決方法
在 change master 語句里，寫上正確的 master_log_file

關(guān)于“MySQL 5.7復(fù)制報錯Client requested master to start replication from impossible怎么辦”這篇文章就分享到這里了，希望以上內(nèi)容可以對大家有一定的幫助，使各位可以學(xué)到更多知識，如果覺得文章不錯，請把它分享出去讓更多的人看到。