Debian Codegraph @

mysql-test/suite/binlog_encryption/rpl_parallel_ignore_error_on_rotate.result

raw
1 *** MDEV-6551: Some replication errors are ignored if slave_parallel_threads > 0 ***
2 include/master-slave.inc
3 [connection master]
4 connection server_2;
5 include/stop_slave.inc
6 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
7 SET @old_parallel_mode=@@GLOBAL.slave_parallel_mode;
8 SET GLOBAL slave_parallel_threads=1;
9 CHANGE MASTER TO master_use_gtid=slave_pos;
10 CALL mtr.add_suppression("Commit failed due to failure of an earlier commit on which this one depends");
11 include/start_slave.inc
12 connection server_1;
13 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
14 CREATE TABLE t2 (a int PRIMARY KEY) ENGINE=InnoDB;
15 SET gtid_domain_id=1;
16 INSERT INTO t2 VALUES (1);
17 SET gtid_domain_id=0;
18 SET gtid_domain_id=2;
19 INSERT INTO t2 VALUES (2);
20 SET gtid_domain_id=0;
21 INSERT INTO t2 VALUES (31);
22 include/save_master_gtid.inc
23 connection server_2;
24 include/sync_with_master_gtid.inc
25 include/stop_slave.inc
26 SET GLOBAL slave_parallel_threads= 0;
27 include/start_slave.inc
28 SET sql_log_bin= 0;
29 INSERT INTO t2 VALUES (32);
30 SET sql_log_bin= 1;
31 connection server_1;
32 INSERT INTO t2 VALUES (32);
33 FLUSH LOGS;
34 INSERT INTO t2 VALUES (33);
35 INSERT INTO t2 VALUES (34);
36 SELECT * FROM t2 WHERE a >= 30 ORDER BY a;
37 a
38 31
39 32
40 33
41 34
42 include/save_master_gtid.inc
43 connection server_2;
44 include/wait_for_slave_sql_error.inc [errno=1062]
45 connection server_2;
46 include/stop_slave_io.inc
47 SET GLOBAL slave_parallel_threads=10;
48 START SLAVE;
49 include/wait_for_slave_sql_error.inc [errno=1062]
50 START SLAVE SQL_THREAD;
51 include/wait_for_slave_sql_error.inc [errno=1062]
52 SELECT * FROM t2 WHERE a >= 30 ORDER BY a;
53 a
54 31
55 32
56 SET sql_slave_skip_counter= 1;
57 ERROR HY000: When using parallel replication and GTID with multiple replication domains, @@sql_slave_skip_counter can not be used. Instead, setting @@gtid_slave_pos explicitly can be used to skip to after a given GTID position
58 include/stop_slave_io.inc
59 include/start_slave.inc
60 include/sync_with_master_gtid.inc
61 SELECT * FROM t2 WHERE a >= 30 ORDER BY a;
62 a
63 31
64 32
65 33
66 34
67 connection server_2;
68 include/stop_slave.inc
69 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
70 SET GLOBAL slave_parallel_mode=@old_parallel_mode;
71 include/start_slave.inc
72 connection server_1;
73 DROP TABLE t2;
74 include/rpl_end.inc