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