Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 MDEV-31655: Parallel replication deadlock victim preference code erroneously removed
4 connection server_1;
5 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
6 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
7 BEGIN;
8 COMMIT;
9 include/save_master_gtid.inc
10 connection server_2;
11 include/sync_with_master_gtid.inc
12 include/stop_slave.inc
13 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
14 SET @old_parallel_mode=@@GLOBAL.slave_parallel_mode;
15 set @@global.slave_parallel_threads= 5;
16 set @@global.slave_parallel_mode= conservative;
17 SET @old_dbug= @@GLOBAL.debug_dbug;
18 SET GLOBAL debug_dbug= "+d,rpl_mdev31655_zero_retries";
19 connection server_1;
20 SET @old_dbug= @@SESSION.debug_dbug;
21 SET SESSION debug_dbug="+d,binlog_force_commit_id";
22 SET @commit_id= 1+1000;
23 SET @commit_id= 2+1000;
24 SET @commit_id= 3+1000;
25 SET @commit_id= 4+1000;
26 SET @commit_id= 5+1000;
27 SET @commit_id= 6+1000;
28 SET @commit_id= 7+1000;
29 SET @commit_id= 8+1000;
30 SET @commit_id= 9+1000;
31 SET @commit_id= 10+1000;
32 SET SESSION debug_dbug= @old_dbug;
33 SELECT COUNT(*), SUM(a*100*b) FROM t1;
34 COUNT(*) SUM(a*100*b)
35 10 225000
36 include/save_master_gtid.inc
37 connection server_2;
38 include/start_slave.inc
39 include/sync_with_master_gtid.inc
40 SET GLOBAL debug_dbug= @old_dbug;
41 SELECT COUNT(*), SUM(a*100*b) FROM t1;
42 COUNT(*) SUM(a*100*b)
43 10 225000
44 connection server_2;
45 include/stop_slave.inc
46 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
47 SET GLOBAL slave_parallel_mode=@old_parallel_mode;
48 include/start_slave.inc
49 connection server_1;
50 DROP TABLE t1;
51 include/rpl_end.inc