首页 > 其他 > 详细

Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position'

时间:2015-05-12 13:22:12      阅读:370      评论:0      收藏:0      [点我收藏+]
[root@localhost bin]# mysqlbinlog logbin.000002
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
DELIMITER /*!*/;
# at 4
#150511 20:57:36 server id 1  end_log_pos 106 	Start: binlog v 4, server v 5.1.73-log created 150511 20:57:36
# Warning: this binlog is either in use or was not closed properly.
BINLOG ‘
MHpRVQ8BAAAAZgAAAGoAAAABAAQANS4xLjczLWxvZwAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
‘/*!*/;
DELIMITER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;

  

重新同步下:

change master to master_host= ‘192.168.91.128‘,master_user=‘{}‘,master_port=3306 ,master_log_file=‘logbin.000002‘,master_log_pos=106;

Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position'

原文:http://www.cnblogs.com/xiaoit/p/4496956.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!