实战:mysql5.6跳过指定事务GTID_MySQL
show slave status \g;
last_sql_error: worker 3 failed executing transaction '6c9da32f-0513-11e4-a949-00e04c8a7573:1' at master log mysqldb01-bin.000001, end_log_pos 4541041; could not execute delete_rows event on table wind.t1; query execution was interrupted, error_code: 1317; got error -1 from storage engine, error_code: 1030; handler error no error!; the event's master log first, end_log_pos 4541041
replicate_ignore_server_ids:
master_server_id: 1001
master_uuid: 6c9da32f-0513-11e4-a949-00e04c8a7573
master_info_file: mysql.slave_master_info
sql_delay: 1
sql_remaining_delay: null
slave_sql_running_state:
master_retry_count: 86400
master_bind:
last_io_error_timestamp:
last_sql_error_timestamp: 140911 09:32:37
master_ssl_crl:
master_ssl_crlpath:
retrieved_gtid_set: 6c9da32f-0513-11e4-a949-00e04c8a7573:1 --跳过此事务
executed_gtid_set: 510e47c2-0669-11e4-b1ff-000c293812ad:1
auto_position: 1
stop slave;
set gtid_next=6c9da32f-0513-11e4-a949-00e04c8a7573:1;
begin;commit;
set gtid_next=automatic;
start slave;
其它类似信息