Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 call mtr.add_suppression("Deadlock found when trying to get lock; try restarting transaction");
4 call mtr.add_suppression("WSREP: handlerton rollback failed");
5 CREATE VIEW v_processlist as SELECT * FROM performance_schema.threads where type = 'FOREGROUND';
6 connection master;
7 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
8 connection slave;
9 include/stop_slave.inc
10 SET @old_parallel_threads = @@GLOBAL.slave_parallel_threads;
11 SET @@global.slave_parallel_threads = 7;
12 SET @old_parallel_mode = @@GLOBAL.slave_parallel_mode;
13 SET @@global.slave_parallel_mode ='optimistic';
14 SET @old_gtid_cleanup_batch_size = @@GLOBAL.gtid_cleanup_batch_size;
15 SET @@global.gtid_cleanup_batch_size = 1000000;
16 CHANGE MASTER TO master_use_gtid=slave_pos;
17 connection master;
18 CREATE TABLE t0 (a int, b INT) ENGINE=InnoDB;
19 CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
20 INSERT INTO t1 VALUES (1, 0);
21 include/save_master_gtid.inc
22 connection slave;
23 include/start_slave.inc
24 include/sync_with_master_gtid.inc
25 include/stop_slave.inc
26 connection master;
27 include/save_master_gtid.inc
28 connection slave;
29 include/start_slave.inc
30 include/sync_with_master_gtid.inc
31 include/diff_tables.inc [master:t0, slave:t0]
32 include/diff_tables.inc [master:t1, slave:t1]
33 connection slave;
34 include/stop_slave.inc
35 SET GLOBAL slave_parallel_mode=@old_parallel_mode;
36 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
37 include/start_slave.inc
38 connection master;
39 DROP VIEW v_processlist;
40 DROP TABLE t0, t1;
41 include/save_master_gtid.inc
42 connection slave;
43 include/sync_with_master_gtid.inc
44 SELECT COUNT(*) <= 5*@@GLOBAL.gtid_cleanup_batch_size
45 FROM mysql.gtid_slave_pos;
46 COUNT(*) <= 5*@@GLOBAL.gtid_cleanup_batch_size
47 1
48 SET GLOBAL gtid_cleanup_batch_size= @old_gtid_cleanup_batch_size;
49 connection master;
50 include/rpl_end.inc