Debian Codegraph @

mysql-test/suite/rpl/r/rpl_gtid_grouping.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 call mtr.add_suppression("Unexpected break of being relay-logged GTID 0-27697-1000");
5 call mtr.add_suppression("Relay log write failure: could not queue event from master");
6 call mtr.add_suppression("The current group of events starts with a non-GTID");
7 include/stop_slave.inc
8 CHANGE MASTER TO MASTER_USE_GTID=slave_pos;
9 include/start_slave.inc
10 connection master;
11 CREATE TABLE t (a INT) ENGINE=innodb;
12 INSERT INTO t VALUES(1);
13 ### A. Simulate an unnoticeable loss of Xid event
14 connection slave;
15 SET @@global.debug_dbug="+d,slave_discard_xid_for_gtid_0_x_1000";
16 connection master;
17 SET @@gtid_seq_no=1000;
18 set @@server_id=27697;
19 INSERT INTO t VALUES(1000);
20 set @@server_id=default;
21 INSERT INTO t VALUES(1001);
22 ## Prove the error occurs.
23 connection slave;
24 include/wait_for_slave_io_error.inc [errno=1595]
25 ## Prove the slave recovers after the simulation condtion is lifted.
26 SET @@global.debug_dbug=default;
27 include/start_slave.inc
28 ### B. Do the same to GTID event.
29 connection slave;
30 SET @@global.debug_dbug="+d,slave_discard_gtid_0_x_1002";
31 connection master;
32 SET @@gtid_seq_no=1002;
33 set @@server_id=27697;
34 INSERT INTO t VALUES(1002);
35 set @@server_id=default;
36 INSERT INTO t VALUES(1003);
37 ## Prove the error occurs.
38 connection slave;
39 include/wait_for_slave_io_error.inc [errno=1595]
40 ## Prove the slave recovers after the simulation condtion is lifted.
41 SET @@global.debug_dbug=default;
42 include/start_slave.inc
43 connection master;
44 connection slave;
45 include/diff_tables.inc [master:t,slave:t]
46 "===== Clean up ====="
47 connection slave;
48 include/stop_slave.inc
49 CHANGE MASTER TO MASTER_USE_GTID=no;
50 include/start_slave.inc
51 connection master;
52 DROP TABLE t;
53 include/rpl_end.inc