[MDEV-29433] innodb.lock_delete_updated is unstable - Jira

XML

Word

Printable

Details

Type: Task
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Fix Version/s: 10.6.10, 10.7.6, 10.8.5, 10.9.3, 10.3.37, 10.4.27, 10.5.18, 10.10.2
Component/s: Storage Engine - InnoDB, Tests, MTR
Labels:
None

Description

The test from ~~MDEV-27992~~ is failing:

innodb.lock_delete_updated 'innodb'      w3 [ fail ]

        Test ended at 2022-08-31 13:50:52

CURRENT_TEST: innodb.lock_delete_updated

mysqltest: At line 26: query 'reap' succeeded - should have failed with error ER_LOCK_DEADLOCK (1213)...

Maybe we should use some syncpoint instead of include/wait_condition.inc, for example, lock_wait_suspend_thread_enter for 10.[345] and lock_wait_start for 10.6+, to make sure DELETE created waiting lock before the next UPDATE begins locking.

Attachments

Issue Links

relates to

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

Closed

Activity

People

Assignee:: Vladislav Lesin (Inactive)

Reporter:: Vladislav Lesin (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2022-09-01 06:41

Updated:: 2022-09-13 12:49

Resolved:: 2022-09-08 15:14

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

2h 50m

Git Integration

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