1call mtr.add_suppression("File.*t1.* not found"); 2create table mysql.t1 (a int, b char(16), index(a)); 3insert mysql.t1 values (100, 'test'),(101,'test'); 4create table t1 (a int, b char(16), index(a)) 5data directory="MYSQLTEST_VARDIR/tmp/foo"; 6insert t1 values (200, 'some'),(201,'some'); 7select * from t1; 8a b 9200 some 10201 some 11flush tables; 12set debug_sync='mi_open_datafile SIGNAL ok WAIT_FOR go'; 13select * from t1; 14connect con1, localhost, root; 15set debug_sync='now WAIT_FOR ok'; 16set debug_sync='now SIGNAL go'; 17connection default; 18ERROR HY000: File 'MYSQLTEST_VARDIR/tmp/foo/t1.MYD' not found (Errcode: 20 <errmsg>) 19flush tables; 20drop table if exists t1; 21create table t1 (a int, b char(16), index (a)) 22index directory="MYSQLTEST_VARDIR/tmp/foo"; 23insert t1 values (200, 'some'),(201,'some'); 24explain select a from t1; 25id select_type table type possible_keys key key_len ref rows Extra 261 SIMPLE t1 index NULL a 5 NULL 2 Using index 27select a from t1; 28a 29200 30201 31flush tables; 32set debug_sync='mi_open_kfile SIGNAL waiting WAIT_FOR run'; 33select a from t1; 34connection con1; 35set debug_sync='now WAIT_FOR waiting'; 36set debug_sync='now SIGNAL run'; 37connection default; 38ERROR HY000: Can't find file: './test/t1.MYI' (errno: 20 <errmsg>) 39flush tables; 40drop table if exists t1; 41drop table mysql.t1; 42set debug_sync='RESET'; 43