Debian Codegraph @

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

raw
1 *** MDEV-8725: Assertion on ROLLBACK statement in the binary log ***
2 include/master-slave.inc
3 [connection master]
4 connection server_2;
5 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
6 include/stop_slave.inc
7 SET GLOBAL slave_parallel_threads=10;
8 CHANGE MASTER TO master_use_gtid=slave_pos;
9 include/start_slave.inc
10 connection server_1;
11 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
12 CREATE TABLE t1 (a int PRIMARY KEY) ENGINE=MyISAM;
13 CREATE TABLE t2 (a int PRIMARY KEY) ENGINE=InnoDB;
14 connection server_2;
15 connection server_1;
16 BEGIN;
17 INSERT INTO t2 VALUES (2000);
18 INSERT INTO t1 VALUES (2000);
19 INSERT INTO t2 VALUES (2001);
20 ROLLBACK;
21 SELECT * FROM t1 WHERE a>=2000 ORDER BY a;
22 a
23 2000
24 SELECT * FROM t2 WHERE a>=2000 ORDER BY a;
25 a
26 include/save_master_gtid.inc
27 connection server_2;
28 include/sync_with_master_gtid.inc
29 connection server_1;
30 INSERT INTO t2 VALUES (2020);
31 include/save_master_gtid.inc
32 connection server_2;
33 include/sync_with_master_gtid.inc
34 SELECT * FROM t2 WHERE a>=2000 ORDER BY a;
35 a
36 2020
37 SELECT * FROM t1 WHERE a>=2000 ORDER BY a;
38 a
39 2000
40 include/stop_slave.inc
41 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
42 include/start_slave.inc
43 connection server_1;
44 DROP TABLE t1,t2;
45 include/rpl_end.inc