--source include/master-slave.inc --source include/have_innodb.inc --connection slave --source include/stop_slave.inc CHANGE MASTER TO master_use_gtid=slave_pos; --source include/start_slave.inc --connection master create table t1 (a int) engine=innodb; create table t2 (a int); create table t3 (a int) engine=innodb; --save_master_pos --connection slave # Using ER_UNKNOWN_STORAGE_ENGINE wont work let $slave_sql_errno= 1286; --source include/wait_for_slave_sql_error_and_skip.inc --sync_with_master --let $assert_text= Status should be 'Slave has read all relay log...' --let $assert_cond= "[SHOW SLAVE STATUS, Slave_SQL_Running_State, 1]" #Like "Slave has read all relay log%" --source include/rpl_assert.inc show tables; show create table t2; --error ER_NO_SUCH_TABLE show create table t1; --error ER_NO_SUCH_TABLE show create table t3; --connection master drop table if exists t1; drop table if exists t2; drop table if exists t3; --source include/save_master_gtid.inc --connection slave --source include/sync_with_master_gtid.inc CALL mtr.add_suppression('Slave: Unknown storage engine .* Error_code: 1286'); --source include/rpl_end.inc