Debian Codegraph @

mysql-test/suite/rpl/t/rpl_parallel_free_deferred_event.test

raw
1 --echo *** MDEV-5788 Incorrect free of rgi->deferred_events in parallel replication ***
2
3 --source include/have_innodb.inc
4 --source include/master-slave.inc
5
6 --connection server_2
7 --source include/stop_slave.inc
8 CHANGE MASTER TO master_use_gtid=slave_pos;
9 --source include/start_slave.inc
10
11 --connection server_1
12 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
13 CREATE TABLE t3 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
14 --save_master_pos
15
16 --connection server_2
17 --sync_with_master
18 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
19 # Use just two worker threads, so we are sure to get the rpl_group_info added
20 # to the free list, which is what triggered the bug.
21 --source include/stop_slave.inc
22 SET GLOBAL replicate_ignore_table="test.t3";
23 SET GLOBAL slave_parallel_threads=2;
24 --source include/start_slave.inc
25
26 --connection server_1
27 INSERT INTO t3 VALUES (100, rand());
28 INSERT INTO t3 VALUES (101, rand());
29 --save_master_pos
30
31 --connection server_2
32 --sync_with_master
33
34 --connection server_1
35 INSERT INTO t3 VALUES (102, rand());
36 INSERT INTO t3 VALUES (103, rand());
37 INSERT INTO t3 VALUES (104, rand());
38 INSERT INTO t3 VALUES (105, rand());
39 --save_master_pos
40
41 --connection server_2
42 --sync_with_master
43 --source include/stop_slave.inc
44 SET GLOBAL replicate_ignore_table="";
45 --source include/start_slave.inc
46
47 --connection server_1
48 INSERT INTO t3 VALUES (106, rand());
49 INSERT INTO t3 VALUES (107, rand());
50 --save_master_pos
51
52 --connection server_2
53 --sync_with_master
54 --replace_column 2 #
55 SELECT * FROM t3 WHERE a >= 100 ORDER BY a;
56
57
58 # Clean up.
59 --connection server_2
60 --source include/stop_slave.inc
61 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
62 --source include/start_slave.inc
63
64 --connection server_1
65 DROP TABLE t3;
66
67 --source include/rpl_end.inc