1set debug_sync='RESET'; 2set global rocksdb_debug_ttl_read_filter_ts = -10; 3connect conn1, localhost, root,,; 4connection default; 5CREATE TABLE t1 (id INT, value INT, KEY (id), KEY (value)) ENGINE=ROCKSDB; 6CREATE TABLE t2 (id INT, value INT) ENGINE=ROCKSDB; 7CREATE TABLE t3 (id INT, kp1 INT, PRIMARY KEY (id), KEY(kp1)) ENGINE=ROCKSDB COMMENT='ttl_duration=1'; 8INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4), (5,5); 9INSERT INTO t2 SELECT * FROM t1; 10INSERT INTO t3 SELECT * FROM t1; 11connection conn1; 12set debug_sync='rocksdb.check_flags_rmi SIGNAL parked WAIT_FOR go'; 13SELECT value FROM t1 WHERE value = 3; 14connection default; 15set debug_sync='now WAIT_FOR parked'; 16KILL QUERY $conn1_id; 17set debug_sync='now SIGNAL go'; 18connection conn1; 19ERROR 70100: Query execution was interrupted 20set debug_sync='RESET'; 21connection conn1; 22set debug_sync='rocksdb.check_flags_rmi_scan SIGNAL parked WAIT_FOR go'; 23SELECT DISTINCT(id) FROM t1 WHERE value = 5 AND id IN (1, 3, 5); 24connection default; 25set debug_sync='now WAIT_FOR parked'; 26KILL QUERY $conn1_id; 27set debug_sync='now SIGNAL go'; 28connection conn1; 29ERROR 70100: Query execution was interrupted 30set debug_sync='RESET'; 31connection conn1; 32set debug_sync='rocksdb.check_flags_inwd SIGNAL parked WAIT_FOR go'; 33SELECT value FROM t1 WHERE value > 3; 34connection default; 35set debug_sync='now WAIT_FOR parked'; 36KILL QUERY $conn1_id; 37set debug_sync='now SIGNAL go'; 38connection conn1; 39ERROR 70100: Query execution was interrupted 40set debug_sync='RESET'; 41connection conn1; 42set debug_sync='rocksdb.check_flags_rnwd SIGNAL parked WAIT_FOR go'; 43SELECT id FROM t2; 44connection default; 45set debug_sync='now WAIT_FOR parked'; 46KILL QUERY $conn1_id; 47set debug_sync='now SIGNAL go'; 48connection conn1; 49ERROR 70100: Query execution was interrupted 50set debug_sync='RESET'; 51connection conn1; 52set debug_sync='rocksdb.check_flags_ser SIGNAL parked WAIT_FOR go'; 53SELECT kp1 FROM t3 ORDER BY kp1; 54connection default; 55set debug_sync='now WAIT_FOR parked'; 56KILL QUERY $conn1_id; 57set debug_sync='now SIGNAL go'; 58connection conn1; 59ERROR 70100: Query execution was interrupted 60connection default; 61disconnect conn1; 62set debug_sync='RESET'; 63set global rocksdb_debug_ttl_read_filter_ts = DEFAULT; 64DROP TABLE t1; 65DROP TABLE t2; 66DROP TABLE t3; 67