Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
5 CREATE TABLE t1(a INT) ENGINE=INNODB;
6 INSERT INTO t1 VALUES(1);
7 include/save_master_gtid.inc
8 connection slave;
9 include/sync_with_master_gtid.inc
10 include/stop_slave.inc
11 set @@global.slave_parallel_threads= 2;
12 set @@global.slave_parallel_mode= OPTIMISTIC;
13 set @@global.slave_transaction_retries= 2;
14 *** MDEV-28776: rpl.rpl_mark_optimize_tbl_ddl fails with timeout on sync_with_master
15 connection master;
16 SET @@gtid_seq_no= 100;
17 INSERT INTO t1 SELECT 1+a FROM t1;
18 SET @@gtid_seq_no= 200;
19 INSERT INTO t1 SELECT 2+a FROM t1;
20 SELECT * FROM t1 ORDER BY a;
21 a
22 1
23 2
24 3
25 4
26 include/save_master_gtid.inc
27 connection slave;
28 SET @save_dbug= @@GLOBAL.debug_dbug;
29 SET GLOBAL debug_dbug="+d,rpl_parallel_delay_gtid_0_x_100_start";
30 SET GLOBAL debug_dbug="+d,rpl_write_record_small_sleep_gtid_100_200";
31 SET GLOBAL debug_dbug="+d,small_sleep_after_lock_wait";
32 SET GLOBAL debug_dbug="+d,rpl_delay_deadlock_kill";
33 include/start_slave.inc
34 include/sync_with_master_gtid.inc
35 SET GLOBAL debug_dbug= @save_dbug;
36 SELECT * FROM t1 ORDER BY a;
37 a
38 1
39 2
40 3
41 4
42 connection slave;
43 include/stop_slave.inc
44 SET @@global.slave_parallel_threads= 0;
45 SET @@global.slave_parallel_mode= optimistic;
46 SET @@global.slave_transaction_retries= 10;
47 include/start_slave.inc
48 connection master;
49 DROP TABLE t1;
50 include/rpl_end.inc