--source include/have_innodb.inc
|
--source include/have_binlog_format_row.inc
|
--let $rpl_server_count= 3
|
--let $rpl_topology= 1->2->3
|
--source include/rpl_init.inc
|
|
--echo #
|
--echo # Initialize test data
|
--connection server_1
|
create table t1 (a int) engine=innodb;
|
insert into t1 values (1);
|
insert into t1 values (2);
|
--source include/save_master_gtid.inc
|
|
--connection server_2
|
--source include/sync_with_master_gtid.inc
|
|
--connection server_2
|
set statement SQL_LOG_BIN=0 FOR delete from t1 where a=1;
|
|
--connection server_1
|
xa start '1';
|
update t1 set a=3 where a=1;
|
xa end '1';
|
xa prepare '1';
|
xa commit '1';
|
--source include/save_master_gtid.inc
|
|
--connection server_3
|
--let $slave_sql_errno=1397
|
--source include/wait_for_slave_sql_error.inc
|
--die Hit Error 'XAER_NOTA: Unknown XID' on query
|
|
--echo #
|
--echo # Cleanup
|
--connection server_1
|
DROP TABLE t1;
|
--source include/save_master_gtid.inc
|
|
--connection server_2
|
--source include/sync_with_master_gtid.inc
|
|
--source include/rpl_end.inc
|
|
--echo # End of tests
|