Debian Codegraph @

mysql-test/suite/binlog_encryption/rpl_parallel_gtid_slave_pos_update_fail.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection server_2;
4 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
5 include/stop_slave.inc
6 SET GLOBAL slave_parallel_threads=10;
7 CHANGE MASTER TO master_use_gtid=slave_pos;
8 include/start_slave.inc
9 connection server_1;
10 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
11 CREATE TABLE t4 (a INT PRIMARY KEY, b INT, KEY b_idx(b)) ENGINE=InnoDB;
12 INSERT INTO t4 VALUES (1,NULL), (2,2), (3,NULL), (4,4), (5, NULL), (6, 6);
13 connect con1,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
14 connect con2,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
15 connection server_2;
16 include/stop_slave.inc
17 connection con1;
18 SET debug_sync='commit_after_release_LOCK_prepare_ordered SIGNAL master_queued1 WAIT_FOR master_cont1';
19 UPDATE t4 SET b=NULL WHERE a=6;
20 connection server_1;
21 SET debug_sync='now WAIT_FOR master_queued1';
22 connection con2;
23 SET debug_sync='commit_after_release_LOCK_prepare_ordered SIGNAL master_queued2';
24 DELETE FROM t4 WHERE b <= 1;
25 connection server_1;
26 SET debug_sync='now WAIT_FOR master_queued2';
27 SET debug_sync='now SIGNAL master_cont1';
28 connection con1;
29 connection con2;
30 SET debug_sync='RESET';
31 connection server_2;
32 SET @old_dbug= @@GLOBAL.debug_dbug;
33 SET GLOBAL debug_dbug="+d,disable_thd_need_ordering_with";
34 include/start_slave.inc
35 SET GLOBAL debug_dbug=@old_dbug;
36 SELECT * FROM t4 ORDER BY a;
37 a b
38 1 NULL
39 2 2
40 3 NULL
41 4 4
42 5 NULL
43 6 NULL
44 SET @last_gtid= 'GTID';
45 SELECT IF(@@gtid_slave_pos LIKE CONCAT('%',@last_gtid,'%'), "GTID found ok",
46 CONCAT("GTID ", @last_gtid, " not found in gtid_slave_pos=", @@gtid_slave_pos))
47 AS result;
48 result
49 GTID found ok
50 SELECT "ROW FOUND" AS `Is the row found?`
51 FROM mysql.gtid_slave_pos
52 WHERE CONCAT(domain_id, "-", server_id, "-", seq_no) = @last_gtid;
53 Is the row found?
54 ROW FOUND
55 connection server_2;
56 include/stop_slave.inc
57 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
58 include/start_slave.inc
59 SET DEBUG_SYNC= 'RESET';
60 connection server_1;
61 DROP TABLE t4;
62 SET DEBUG_SYNC= 'RESET';
63 disconnect con1;
64 disconnect con2;
65 include/rpl_end.inc