[MDEV-11481] MariaRocks port: rocksdb.select_for_update_skip_locked_nowait (DISABLED) Created: 2016-12-03  Updated: 2023-04-16

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: N/A
Fix Version/s: 10.6

Type: Bug Priority: Minor
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-9658 Make MyRocks in MariaDB stable Closed
Relates
relates to MDEV-13115 Implement SELECT [FOR UPDATE|LOCK IN ... Closed
relates to MDEV-19986 MyRocks: Range Locking: SeekForUpdate... Open

 Description   

rocksdb.select_for_update_skip_locked_nowait test fails, because MariaDB doesn't support these extensions:

SELECT ... FOR UPDATE SKIP LOCKED 


SELECT ... FOR UPDATE NOWAIT

Actually, MyRocks doesn't support them either - the test is only there to check that MyRocks returns a proper error code for such statements.

 Comments   
Comment by Clint Priest [ 2017-12-18 ]

Any chance MDEV-13115 might be getting any attention soon?

Comment by Sergei Petrunia [ 2018-04-12 ]

(I assume the above question is answered in MDEV-13115)

Changing fixVersion to 10.4 as these extensions are not really supported.

Comment by Daniel Black [ 2021-04-19 ]

MDEV-13115 has been implemented in 10.6 for InnoDB. There is mature handler interfaces. RocksDB needs to advertise the support (HA_CAN_SKIP_LOCKED) for the additional lock types TL_READ_SKIP_LOCKED, TL_WRITE_SKIP_LOCKED, and needs to process in ::store_lock.

Sorry that I should of moved the skip locked tests to a more generic location (f41f71992459610a136598b0f1e21310e3045bbc).

Generated at Thu Feb 08 07:50:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.