[MDEV-7895] HANDLER READ doesn't upgrade metadata lock from S to SR Created: 2015-04-01  Updated: 2015-05-12  Resolved: 2015-05-12

Status: Closed
Project: MariaDB Server
Component/s: Locking
Affects Version/s: 10.0.17, 10.1.3
Fix Version/s: 10.1.4

Type: Bug Priority: Minor
Reporter: Sergey Vojtovich Assignee: Sergey Vojtovich
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-7660 MySQL WL#6671 "Improve scalability by... Closed

 Description   

This problem was fixed along with MySQL WL#6671 "Improve scalability by not using thr_lock.c locks for InnoDB tables".

Change code for HANDLER READ statements to upgrade S metadata lock to
SR metadata lock for the duration of read. This allows us properly
isolate HANDLER READ from LOCK TABLES WRITE and makes metadata locking
for these statements consistent with locking for other DML.

 Comments   
Comment by Sergey Vojtovich [ 2015-04-01 ]

Sergei, please review fix for this bug.

Comment by Sergei Golubchik [ 2015-05-09 ]

probably not relevant anymore. should be resurrected if we'll decide that it's still needed

Comment by Sergey Vojtovich [ 2015-05-12 ]

This task is not relevant anymore since we don't plan to apply MySQL WL#6671 "Improve scalability by not using thr_lock.c locks for InnoDB tables".

The aim is to fix it in InnoDB instead of fixing it in MDL.

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