Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 SET @saved_innodb_limit_optimistic_insert_debug = @@GLOBAL.innodb_limit_optimistic_insert_debug;
5 SET @@GLOBAL.innodb_limit_optimistic_insert_debug = 2;
6 connection master;
7 CREATE TABLE t1 (
8 c1 INT NOT NULL,
9 KEY(c1)
10 ) ENGINE=InnoDB;
11 CREATE TABLE t2 (
12 c1 INT NOT NULL,
13 FOREIGN KEY(c1) REFERENCES t1(c1)
14 ) ENGINE=InnoDB;
15 INSERT INTO t1 VALUES (1), (3), (4);
16 connection master1;
17 XA START 'XA1';
18 INSERT INTO t1 values(2);
19 XA END 'XA1';
20 connection master;
21 XA START 'XA2';
22 INSERT INTO t2 values(3);
23 XA END 'XA2';
24 XA PREPARE 'XA2';
25 connection master1;
26 XA PREPARE 'XA1';
27 XA COMMIT 'XA1';
28 connection master;
29 XA COMMIT 'XA2';
30 include/sync_slave_sql_with_master.inc
31 include/stop_slave.inc
32 DROP TABLE t2, t1;
33 RESET SLAVE;
34 RESET MASTER;
35 connection master;
36 Restore binary log from the master into the slave
37 include/diff_tables.inc [master:test.t1, slave:test.t1]
38 include/diff_tables.inc [master:test.t2, slave:test.t2]
39 DROP TABLE t2, t1;
40 connection slave;
41 CHANGE MASTER TO MASTER_LOG_FILE='LOG_FILE', MASTER_LOG_POS=LOG_POS, MASTER_USE_GTID=NO;
42 SET @@GLOBAL.innodb_limit_optimistic_insert_debug = @saved_innodb_limit_optimistic_insert_debug;
43 include/start_slave.inc
44 include/rpl_end.inc