Debian Codegraph @

mysql-test/suite/binlog_encryption/rpl_parallel_wrong_binlog_order.result

raw
1 *** MDEV-6775: Wrong binlog order in parallel replication ***
2 include/master-slave.inc
3 [connection master]
4 connection server_2;
5 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
6 include/stop_slave.inc
7 SET GLOBAL slave_parallel_threads=10;
8 CHANGE MASTER TO master_use_gtid=slave_pos;
9 include/start_slave.inc
10 connection server_1;
11 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
12 CREATE TABLE t4 (a INT PRIMARY KEY, b INT, KEY b_idx(b)) ENGINE=InnoDB;
13 INSERT INTO t4 VALUES (1,NULL), (3,NULL), (4,4), (5, NULL), (6, 6);
14 connect con1,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
15 connect con2,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
16 include/save_master_gtid.inc
17 connection server_2;
18 include/sync_with_master_gtid.inc
19 include/stop_slave.inc
20 SET @old_dbug= @@GLOBAL.debug_dbug;
21 SET GLOBAL debug_dbug="+d,inject_binlog_commit_before_get_LOCK_log";
22 SET @old_format=@@GLOBAL.binlog_format;
23 SET GLOBAL binlog_format=ROW;
24 SET GLOBAL slave_parallel_threads=0;
25 SET GLOBAL slave_parallel_threads=10;
26 connection con1;
27 SET @old_format= @@binlog_format;
28 SET binlog_format= statement;
29 SET debug_sync='commit_after_release_LOCK_prepare_ordered SIGNAL master_queued1 WAIT_FOR master_cont1';
30 UPDATE t4 SET b=NULL WHERE a=6;
31 connection server_1;
32 SET debug_sync='now WAIT_FOR master_queued1';
33 connection con2;
34 SET @old_format= @@binlog_format;
35 SET binlog_format= statement;
36 SET debug_sync='commit_after_release_LOCK_prepare_ordered SIGNAL master_queued2';
37 DELETE FROM t4 WHERE b <= 3;
38 connection server_1;
39 SET debug_sync='now WAIT_FOR master_queued2';
40 SET debug_sync='now SIGNAL master_cont1';
41 connection con1;
42 SET binlog_format= @old_format;
43 connection con2;
44 SET binlog_format= @old_format;
45 SET debug_sync='RESET';
46 SELECT * FROM t4 ORDER BY a;
47 a b
48 1 NULL
49 3 NULL
50 4 4
51 5 NULL
52 6 NULL
53 connection server_2;
54 include/start_slave.inc
55 SET debug_sync= 'now WAIT_FOR waiting';
56 SELECT * FROM t4 ORDER BY a;
57 a b
58 1 NULL
59 3 NULL
60 4 4
61 5 NULL
62 6 NULL
63 SET debug_sync= 'now SIGNAL cont';
64 include/stop_slave.inc
65 SET GLOBAL debug_dbug=@old_dbug;
66 SET GLOBAL binlog_format= @old_format;
67 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
68 include/start_slave.inc
69 SET DEBUG_SYNC= 'RESET';
70 connection server_1;
71 DROP TABLE t4;
72 SET DEBUG_SYNC= 'RESET';
73 disconnect con1;
74 disconnect con2;
75 include/rpl_end.inc