Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2]
2 connection server_1;
3 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
4 CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
5 CREATE TABLE t2 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
6 INSERT INTO t1 VALUES (1,0), (2,0), (3,0);
7 INSERT INTO t2 VALUES (1,0), (2,0);
8 connection server_2;
9 SET @old_isolation= @@GLOBAL.transaction_isolation;
10 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
11 include/stop_slave.inc
12 SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
13 SET GLOBAL slave_parallel_threads=10;
14 CHANGE MASTER TO master_use_gtid=slave_pos;
15 SET @old_parallel_mode=@@GLOBAL.slave_parallel_mode;
16 SET GLOBAL slave_parallel_mode='aggressive';
17 *** Test that we replicate correctly when using READ COMMITTED and --log-slave-updates=0 on the slave ***
18 connection server_1;
19 INSERT INTO t1 SELECT 4, COUNT(*) FROM t2;
20 INSERT INTO t2 SELECT 4, COUNT(*) FROM t1;
21 INSERT INTO t1 SELECT 5, COUNT(*) FROM t2;
22 INSERT INTO t2 SELECT 5, COUNT(*) FROM t1;
23 INSERT INTO t2 SELECT 6, COUNT(*) FROM t1;
24 INSERT INTO t1 SELECT 6, COUNT(*) FROM t2;
25 INSERT INTO t1 SELECT 7, COUNT(*) FROM t2;
26 INSERT INTO t2 SELECT 7, COUNT(*) FROM t1;
27 INSERT INTO t2 SELECT 8, COUNT(*) FROM t1;
28 INSERT INTO t1 SELECT 8, COUNT(*) FROM t2;
29 INSERT INTO t2 SELECT 9, COUNT(*) FROM t1;
30 INSERT INTO t1 SELECT 9, COUNT(*) FROM t2;
31 INSERT INTO t1 SELECT 10, COUNT(*) FROM t2;
32 INSERT INTO t2 SELECT 10, COUNT(*) FROM t1;
33 SELECT * FROM t1 ORDER BY a;
34 a b
35 1 0
36 2 0
37 3 0
38 4 2
39 5 3
40 6 5
41 7 5
42 8 7
43 9 8
44 10 8
45 SELECT * FROM t2 ORDER BY a;
46 a b
47 1 0
48 2 0
49 4 4
50 5 5
51 6 5
52 7 7
53 8 7
54 9 8
55 10 10
56 include/save_master_gtid.inc
57 connection server_2;
58 include/start_slave.inc
59 include/sync_with_master_gtid.inc
60 SELECT * FROM t1 ORDER BY a;
61 a b
62 1 0
63 2 0
64 3 0
65 4 2
66 5 3
67 6 5
68 7 5
69 8 7
70 9 8
71 10 8
72 SELECT * FROM t2 ORDER BY a;
73 a b
74 1 0
75 2 0
76 4 4
77 5 5
78 6 5
79 7 7
80 8 7
81 9 8
82 10 10
83 connection server_2;
84 include/stop_slave.inc
85 SET GLOBAL transaction_isolation= @old_isolation;
86 SET GLOBAL slave_parallel_mode=@old_parallel_mode;
87 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
88 include/start_slave.inc
89 connection server_1;
90 DROP TABLE t1, t2;
91 connection server_2;
92 call mtr.add_suppression("Deadlock found when trying to get lock.*");
93 include/rpl_end.inc