Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2]
2 *** Test crashing master with InnoDB disabled, the binlog gtid state should still be correctly recovered. ***
3 connection server_1;
4 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=MyISAM;
5 connection server_2;
6 include/stop_slave.inc
7 CHANGE MASTER TO master_use_gtid=slave_pos;
8 include/start_slave.inc
9 connection server_1;
10 INSERT INTO t1 VALUES (1);
11 INSERT INTO t1 VALUES (2);
12 connection server_2;
13 SELECT * FROM t1 ORDER BY a;
14 a
15 1
16 2
17 connection server_1;
18 FLUSH TABLES;
19 SET SESSION debug_dbug="+d,crash_dispatch_command_before";
20 SELECT 1;
21 Got one of the listed errors
22 connection server_1;
23 INSERT INTO t1 VALUES (3);
24 connection server_2;
25 SELECT * FROM t1 ORDER BY a;
26 a
27 1
28 2
29 3
30 connection server_1;
31 DROP TABLE t1;
32 connection default;
33 include/rpl_end.inc