您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息
三六零分类信息网 > 张家口分类信息网,免费分类信息发布

实战:mysql5.6跳过指定事务GTID_MySQL

2025/8/14 22:47:18发布4次查看

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;
张家口分类信息网,免费分类信息发布

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product