Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5, 10.6, 10.11, 11.1(EOL), 11.2(EOL), 11.4, 11.6(EOL), 11.7
-
None
Description
SET sql_mode=''; |
INSTALL PLUGIN RocksDB SONAME 'ha_rocksdb'; |
CREATE TABLE t (c INT PRIMARY KEY,d INT,KEY (d)) ENGINE=RocksDB; |
BEGIN; |
INSERT INTO t VALUES (0,0); |
SET rocksdb_max_row_locks=0; |
SELECT * FROM t FOR UPDATE; |
Leads to:
CS 11.2.6 e91a79945822def1452787f825e6047c6a64dbd9 (Debug) |
CLI: ERROR 1296 (HY000): Got error 10 'Operation aborted: Failed to acquire lock due to rocksdb_max_row_locks limit' from ROCKSDB
|
ERR: [ERROR] Got error 220 when reading table './test/t' # 11.2
|
Same testcase, without index on d:
SET sql_mode=''; |
INSTALL PLUGIN RocksDB SONAME 'ha_rocksdb'; |
CREATE TABLE t (c INT PRIMARY KEY,d INT) ENGINE=RocksDB; |
BEGIN; |
INSERT INTO t VALUES (0,0); |
SET rocksdb_max_row_locks=0; |
SELECT * FROM t FOR UPDATE; |
Leads to:
CS 11.2.6 e91a79945822def1452787f825e6047c6a64dbd9 (Debug) |
CLI: ERROR 1296 (HY000): Got error 10 'Operation aborted: Failed to acquire lock due to rocksdb_max_row_locks limit' from ROCKSDB
|
ERR: - (no error)
|
Same as original testcase, but without BEGIN:
SET sql_mode=''; |
INSTALL PLUGIN RocksDB SONAME 'ha_rocksdb'; |
CREATE TABLE t (c INT PRIMARY KEY,d INT,KEY (d)) ENGINE=RocksDB; |
INSERT INTO t VALUES (0,0); |
SET rocksdb_max_row_locks=0; |
SELECT * FROM t FOR UPDATE; |
Leads to:
CS 11.2.6 e91a79945822def1452787f825e6047c6a64dbd9 (Debug) |
CLI: - (no error, expected query output c/d 0/0)
|
ERR: - (no error)
|