Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 include/stop_slave.inc
5 set @save_par_thds= @@global.slave_parallel_threads;
6 set @save_strict_mode= @@global.gtid_strict_mode;
7 set @save_innodb_lock_wait_timeout= @@global.innodb_lock_wait_timeout;
8 change master to master_use_gtid=slave_pos;
9 set @@global.slave_parallel_threads= 4;
10 set @@global.slave_parallel_mode= optimistic;
11 set @@global.gtid_strict_mode=ON;
12 set statement sql_log_bin=0 for alter table mysql.gtid_slave_pos engine=innodb;
13 include/start_slave.inc
14 connection master;
15 create table t1 (a int primary key, b int) engine=innodb;
16 insert t1 values (1,1);
17 include/save_master_gtid.inc
18 connection slave;
19 include/sync_with_master_gtid.inc
20 include/stop_slave.inc
21 set @@global.innodb_lock_wait_timeout= 1;
22 connection master;
23 set @@session.gtid_seq_no=100;
24 xa start '1';
25 update t1 set b=b+10 where a=1;
26 xa end '1';
27 xa prepare '1';
28 xa commit '1';
29 include/save_master_gtid.inc
30 connection slave1;
31 BEGIN;
32 SELECT * FROM mysql.gtid_slave_pos WHERE seq_no=100 FOR UPDATE;
33 domain_id sub_id server_id seq_no
34 connection slave;
35 include/start_slave.inc
36 include/wait_for_slave_sql_error.inc [errno=1942]
37 include/stop_slave_io.inc
38 connection slave1;
39 ROLLBACK;
40 # Cleanup
41 connection master;
42 drop table t1;
43 connection slave;
44 # TODO: Remove after fixing MDEV-21777
45 set @@global.gtid_slave_pos= "0-1-100";
46 set @@global.slave_parallel_threads= @save_par_thds;
47 set @@global.gtid_strict_mode= @save_strict_mode;
48 set @@global.innodb_lock_wait_timeout= @save_innodb_lock_wait_timeout;
49 include/start_slave.inc
50 include/rpl_end.inc
51 # End of rpl_xa_prepare_gtid_fail.test