MySQL 的一次错误处理 Got fatal error 1236 from master when reading data from binary log

2018-01-11 12:48:23来源:oschina作者:linjin200人点击

分享
MySQL 的一次错误处理 Got fatal error 1236 from master when reading data from binary log

原创2013年12月09日 18:00:05

24286

本地MySQL环境,是两台MySQL做M-M复制。今天发现错误信息:


mysql 5.5.28-log> show slave status/G *************************** 1. row ***************************Slave_IO_State:Master_Host: 88.88.88.88Master_User: replicateMaster_Port: 3306Connect_Retry: 60Master_Log_File: testdbbinlog.000005Read_Master_Log_Pos: 98359687Relay_Log_File: mysql-relay-bin.000020Relay_Log_Pos: 4Relay_Master_Log_File: testdbbinlog.000005Slave_IO_Running: NoSlave_SQL_Running: YesReplicate_Do_DB:Replicate_Ignore_DB:Replicate_Do_Table:Replicate_Ignore_Table:Replicate_Wild_Do_Table:Replicate_Wild_Ignore_Table:Last_Errno: 0Last_Error:Skip_Counter: 0Exec_Master_Log_Pos: 98359687Relay_Log_Space: 107Until_Condition: NoneUntil_Log_File:Until_Log_Pos: 0Master_SSL_Allowed: NoMaster_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: NoLast_IO_Errno: 1236Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file'Last_SQL_Errno: 0Last_SQL_Error:Replicate_Ignore_Server_Ids:Master_Server_Id: 1 1 row in set (0.00 sec)


mysql 5.5.28-log>

参考网上文档:http://blog.csdn.net/billfanggs/article/details/8905991


在source那边,执行:


flush logs; show master status;


记下File, Position。


在target端,执行:


CHANGE MASTER TO MASTER_LOG_FILE='testdbbinlog.000008',MASTER_LOG_POS=107; slave start; show slave status /G


一切正常。

最新文章

123

最新摄影

闪念基因

微信扫一扫

第七城市微信公众平台