[MDEV-27992] DELETE fails to delete record after blocking is released - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.5.14, 10.6.6, 10.7.3
Fix Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3
Component/s: Data Manipulation - Delete, Locking, Storage Engine - InnoDB
Labels:
- transactions
Environment:
OS: Ubuntu-20.04 LTS

Description

Isolation Level: Read Committed & Read Uncommitted
One transaction modifies a row, the other transaction concurrently deletes that row and is blocked. After blocking is released, the second transaction DELETE fails.

/* init */ DROP TABLE IF EXISTS t;

/* init */ CREATE TABLE t(c1 INT PRIMARY KEY, c2 INT);

/* init */ INSERT INTO t(c1) VALUES (8);

/* t1 */ BEGIN;

/* t2 */ BEGIN;

/* t1 */ UPDATE t SET c1 = 5, c2 = 5;

/* t2 */ DELETE FROM t; -- blocked

/* t1 */ UPDATE t SET c1 = 3;

/* t1 */ COMMIT; -- t2 unblocked

/* t2 */ SELECT * FROM t FOR UPDATE; -- [(3, 5)]

/* t2 */ ROLLBACK;

Attachments

Issue Links

is caused by

MDEV-27025 insert-intention lock conflicts with waiting ORDINARY lock

Closed

relates to

MDEV-29433 innodb.lock_delete_updated is unstable

Closed

MDEV-24813 Locking full table scan fails to use table-level locking

In Review

mentioned in: Page Loading...; Page Loading...; Page Loading...; Page Loading...; Page Loading...

(3 mentioned in)

Activity

People

Assignee:: Vladislav Lesin

Reporter:: John Jove

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2022-03-03 08:21

Updated:: 2024-09-05 19:52

Resolved:: 2022-03-07 20:48

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.