共計 1107 個字符，預計需要花費 3 分鐘才能閱讀完成。

行業資訊    
數據庫    
MySQL 數據庫    
MySQL 5.7 復制報錯 Client requested master to start replication from impossible 怎么辦

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

錯誤日志中的信息
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

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

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

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