[MDEV-26106] [ERROR] InnoDB: Unlock row could not find a 2 mode lock on the record Created: 2021-07-07  Updated: 2021-07-08  Resolved: 2021-07-08

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6
Fix Version/s: 10.5.12, 10.6.4

Type: Bug Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
PartOf

 Description   

This is MariaDB's variant of https://bugs.mysql.com/bug.php?id=76803 .

If there is an outer join with a constant inner table, a locking-read statement (UPDATE or SELECT... FOR UPDATE) will produce these kind of warnings in the error log:

[ERROR] InnoDB: Unlock row could not find a 3 mode lock on the record. Current
 
statement: SELECT * FROM t1 LEFT JOIN t2 ON t1.c2=t2.c2 AND t2.c1=1 FOR UPDATE



 Comments   
Comment by Sergei Petrunia [ 2021-07-07 ]

bb-10.5-mdev26106

Generated at Thu Feb 08 09:42:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.