1include/rpl_init.inc [topology=1->2]
2connection server_1;
3ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
4CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
5CREATE TABLE t2 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
6INSERT INTO t1 VALUES (1,0), (2,0), (3,0);
7INSERT INTO t2 VALUES (1,0), (2,0);
8connection server_2;
9SET @old_isolation= @@GLOBAL.tx_isolation;
10SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
11include/stop_slave.inc
12SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
13SET GLOBAL slave_parallel_threads=10;
14CHANGE MASTER TO master_use_gtid=slave_pos;
15SET @old_parallel_mode=@@GLOBAL.slave_parallel_mode;
16SET GLOBAL slave_parallel_mode='aggressive';
17*** Test that we replicate correctly when using READ COMMITTED and --log-slave-updates=0 on the slave ***
18connection server_1;
19INSERT INTO t1 SELECT 4, COUNT(*) FROM t2;
20INSERT INTO t2 SELECT 4, COUNT(*) FROM t1;
21INSERT INTO t1 SELECT 5, COUNT(*) FROM t2;
22INSERT INTO t2 SELECT 5, COUNT(*) FROM t1;
23INSERT INTO t2 SELECT 6, COUNT(*) FROM t1;
24INSERT INTO t1 SELECT 6, COUNT(*) FROM t2;
25INSERT INTO t1 SELECT 7, COUNT(*) FROM t2;
26INSERT INTO t2 SELECT 7, COUNT(*) FROM t1;
27INSERT INTO t2 SELECT 8, COUNT(*) FROM t1;
28INSERT INTO t1 SELECT 8, COUNT(*) FROM t2;
29INSERT INTO t2 SELECT 9, COUNT(*) FROM t1;
30INSERT INTO t1 SELECT 9, COUNT(*) FROM t2;
31INSERT INTO t1 SELECT 10, COUNT(*) FROM t2;
32INSERT INTO t2 SELECT 10, COUNT(*) FROM t1;
33SELECT * FROM t1 ORDER BY a;
34a	b
351	0
362	0
373	0
384	2
395	3
406	5
417	5
428	7
439	8
4410	8
45SELECT * FROM t2 ORDER BY a;
46a	b
471	0
482	0
494	4
505	5
516	5
527	7
538	7
549	8
5510	10
56include/save_master_gtid.inc
57connection server_2;
58include/start_slave.inc
59include/sync_with_master_gtid.inc
60SELECT * FROM t1 ORDER BY a;
61a	b
621	0
632	0
643	0
654	2
665	3
676	5
687	5
698	7
709	8
7110	8
72SELECT * FROM t2 ORDER BY a;
73a	b
741	0
752	0
764	4
775	5
786	5
797	7
808	7
819	8
8210	10
83connection server_2;
84include/stop_slave.inc
85SET GLOBAL tx_isolation= @old_isolation;
86SET GLOBAL slave_parallel_mode=@old_parallel_mode;
87SET GLOBAL slave_parallel_threads=@old_parallel_threads;
88include/start_slave.inc
89connection server_1;
90DROP TABLE t1, t2;
91connection server_2;
92call mtr.add_suppression("Deadlock found when trying to get lock.*");
93include/rpl_end.inc
94