mirror of
https://github.com/MariaDB/server.git
synced 2026-02-15 23:28:40 +01:00
66 lines
2.2 KiB
Text
66 lines
2.2 KiB
Text
set debug_sync='RESET';
|
|
set global rocksdb_debug_ttl_read_filter_ts = -10;
|
|
connect conn1, localhost, root,,;
|
|
connection default;
|
|
CREATE TABLE t1 (id INT, value INT, KEY (id), KEY (value)) ENGINE=ROCKSDB;
|
|
CREATE TABLE t2 (id INT, value INT) ENGINE=ROCKSDB;
|
|
CREATE TABLE t3 (id INT, kp1 INT, PRIMARY KEY (id), KEY(kp1)) ENGINE=ROCKSDB COMMENT='ttl_duration=1';
|
|
INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4), (5,5);
|
|
INSERT INTO t2 SELECT * FROM t1;
|
|
INSERT INTO t3 SELECT * FROM t1;
|
|
connection conn1;
|
|
set debug_sync='rocksdb.check_flags_rmi SIGNAL parked WAIT_FOR go';
|
|
SELECT value FROM t1 WHERE value = 3;
|
|
connection default;
|
|
set debug_sync='now WAIT_FOR parked';
|
|
KILL QUERY $conn1_id;
|
|
set debug_sync='now SIGNAL go';
|
|
connection conn1;
|
|
ERROR 70100: Query execution was interrupted
|
|
set debug_sync='RESET';
|
|
connection conn1;
|
|
set debug_sync='rocksdb.check_flags_rmi_scan SIGNAL parked WAIT_FOR go';
|
|
SELECT DISTINCT(id) FROM t1 WHERE value = 5 AND id IN (1, 3, 5);
|
|
connection default;
|
|
set debug_sync='now WAIT_FOR parked';
|
|
KILL QUERY $conn1_id;
|
|
set debug_sync='now SIGNAL go';
|
|
connection conn1;
|
|
ERROR 70100: Query execution was interrupted
|
|
set debug_sync='RESET';
|
|
connection conn1;
|
|
set debug_sync='rocksdb.check_flags_inwd SIGNAL parked WAIT_FOR go';
|
|
SELECT value FROM t1 WHERE value > 3;
|
|
connection default;
|
|
set debug_sync='now WAIT_FOR parked';
|
|
KILL QUERY $conn1_id;
|
|
set debug_sync='now SIGNAL go';
|
|
connection conn1;
|
|
ERROR 70100: Query execution was interrupted
|
|
set debug_sync='RESET';
|
|
connection conn1;
|
|
set debug_sync='rocksdb.check_flags_rnwd SIGNAL parked WAIT_FOR go';
|
|
SELECT id FROM t2;
|
|
connection default;
|
|
set debug_sync='now WAIT_FOR parked';
|
|
KILL QUERY $conn1_id;
|
|
set debug_sync='now SIGNAL go';
|
|
connection conn1;
|
|
ERROR 70100: Query execution was interrupted
|
|
set debug_sync='RESET';
|
|
connection conn1;
|
|
set debug_sync='rocksdb.check_flags_ser SIGNAL parked WAIT_FOR go';
|
|
SELECT kp1 FROM t3 ORDER BY kp1;
|
|
connection default;
|
|
set debug_sync='now WAIT_FOR parked';
|
|
KILL QUERY $conn1_id;
|
|
set debug_sync='now SIGNAL go';
|
|
connection conn1;
|
|
ERROR 70100: Query execution was interrupted
|
|
connection default;
|
|
disconnect conn1;
|
|
set debug_sync='RESET';
|
|
set global rocksdb_debug_ttl_read_filter_ts = DEFAULT;
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
DROP TABLE t3;
|