bitscn.com
last_io_errno: 1236 last_io_error: got fatal error 1236 from master when reading data from binary lo
mysql> show slave status/g*************************** 1. row *************************** slave_io_state: master_host: 10.122.41.208 master_user: replication master_port: 3306 connect_retry: 60 master_log_file: mysql-bin.000173 read_master_log_pos: 90376278 relay_log_file: mysql-relay-bin.001980 relay_log_pos: 90376424 relay_master_log_file: mysql-bin.000173 slave_io_running: no slave_sql_running: yes replicate_do_db: replicate_ignore_db: replicate_do_table: replicate_ignore_table: replicate_wild_do_table: replicate_wild_ignore_table: last_errno: 0 last_error: skip_counter: 0 exec_master_log_pos: 90376278 relay_log_space: 90376726 until_condition: none until_log_file: until_log_pos: 0 master_ssl_allowed: no master_ssl_ca_file: master_ssl_ca_path: master_ssl_cert: master_ssl_cipher: master_ssl_key: seconds_behind_master: nullmaster_ssl_verify_server_cert: no last_io_errno: 1236 last_io_error: 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.000173' at 90376278, the last event read from '/mysql/binlog/mysql-bin.000173' at 4, the last byte read from '/mysql/binlog/mysql-bin.000173' at 4.' last_sql_errno: 0 last_sql_error: replicate_ignore_server_ids: master_server_id: 111 row in set (0.00 sec)mysql>
比较一个笨的处理办法：
重新change position点，然后碰到重复insert的报错，就直接看position点，如果在90376278之前的，就skip掉，执行：
stop slave;set global sql_slave_skip_counter=1;start slave;show slave status/g;
bitscn.com