Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2->3]
2 *** MDEV-7668: Intermediate master groups CREATE with INSERT, causing parallel replication failure ***
3 connection server_1;
4 SET @old_updates= @@GLOBAL.binlog_direct_non_transactional_updates;
5 SET GLOBAL binlog_direct_non_transactional_updates=OFF;
6 SET SESSION binlog_direct_non_transactional_updates=OFF;
7 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
8 CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
9 connection server_2;
10 include/stop_slave.inc
11 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
12 SET GLOBAL slave_parallel_threads=10;
13 SET @old_commit_count=@@GLOBAL.binlog_commit_wait_count;
14 SET GLOBAL binlog_commit_wait_count=2;
15 SET @old_commit_usec=@@GLOBAL.binlog_commit_wait_usec;
16 SET GLOBAL binlog_commit_wait_usec=2000000;
17 SET @old_updates= @@GLOBAL.binlog_direct_non_transactional_updates;
18 SET GLOBAL binlog_direct_non_transactional_updates=OFF;
19 SET SESSION binlog_direct_non_transactional_updates=OFF;
20 connection server_3;
21 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
22 include/stop_slave.inc
23 SET GLOBAL slave_parallel_threads=10;
24 connection server_1;
25 BEGIN;
26 CREATE TEMPORARY TABLE t2 (a INT PRIMARY KEY) ENGINE=MEMORY;
27 COMMIT;
28 INSERT INTO t2 VALUES (1);
29 INSERT INTO t1 SELECT a, a*10 FROM t2;
30 DROP TABLE t2;
31 include/save_master_gtid.inc
32 connection server_2;
33 include/start_slave.inc
34 include/sync_with_master_gtid.inc
35 SELECT * FROM t1 ORDER BY a;
36 a b
37 1 10
38 connection server_3;
39 include/start_slave.inc
40 include/sync_with_master_gtid.inc
41 SELECT * FROM t1 ORDER BY a;
42 a b
43 1 10
44 connection server_2;
45 include/stop_slave.inc
46 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
47 SET GLOBAL binlog_commit_wait_count=@old_commit_count;
48 SET GLOBAL binlog_commit_wait_usec=@old_commit_usec;
49 SET GLOBAL binlog_direct_non_transactional_updates= @old_updates;
50 include/start_slave.inc
51 connection server_3;
52 include/stop_slave.inc
53 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
54 include/start_slave.inc
55 connection server_1;
56 SET GLOBAL binlog_direct_non_transactional_updates= @old_updates;
57 CALL mtr.add_suppression("Statement accesses nontransactional table as well as transactional or temporary table");
58 DROP TABLE t1;
59 include/rpl_end.inc