主从报错信息
Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position'
120611 20:39:38 [ERROR] Error reading packet from server: Client requested master to start replication from impossible position ( server_errno=1236)
120611 20:39:38 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position', Error_code: 1236
120611 20:39:38 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.000143', position 664526789
主从报错原因
由于异常断电导致启动主库服务后，从库读取主库binlog位置信息错误，主机异常掉电导致binlog 未及时同步到磁盘。从库读取了主库binlog file中的不存在的binlog position ，一般比binlogfile 的end position 的值还要大。
解决方法
在从库重新指向到主库下一个可用的binlog file 并且从binlog file初始化的位置开始
stop slave;
change master to master_log_file='mysql-bin.000144', master_log_pos=4;
start slave;