[MDEV-27550] The test galera.MW-328D no longer reproduces a deadlock - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5, 10.6, 10.7(EOL), 10.8(EOL)
Fix Version/s: 10.7.4, 10.5.16, 10.6.8, 10.8.3
Component/s: Galera, Tests
Labels:
None

Description

Ever since InnoDB stopped to flag some bogus record lock conflicts, the test galera.MW-328D started failing:

10.6 bd03c0e51629e1c3969a171137712a6bb854c232
CURRENT_TEST: galera.MW-328D
mysqltest: At line 37: query 'reap' succeeded - should have failed with error ER_LOCK_DEADLOCK (1213)...

10.5 be8113861c2d12bb0f7048523f886cab53326d8e
CURRENT_TEST: galera.MW-328D
mysqltest: At line 37: query 'reap' succeeded - should have failed with errno 1213...

This test will have to be adjusted so that it will reproduce a real locking conflict and deadlock, or it should be removed.

Attachments

Issue Links

relates to

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

Closed

mentioned in: Page Failed to load

Activity

Ascending order - Click to sort in descending order

Vladislav Lesin added a comment - 2022-01-20 05:40

The reason of the the failure is the following. The transaction of connection node_1 acquires lock, then the transaction of node_1a creates conflicting waiting for node_1 lock, then node_1 transaction requests lock. Before ~~MDEV-27025~~ fix the requested lock would conflict with the waiting lock of node_1a. After the fix, the lock is granted as node_1 already holds lock, and node_1a waiting for node_1.

Vladislav Lesin added a comment - 2022-01-20 05:40 The reason of the the failure is the following. The transaction of connection node_1 acquires lock, then the transaction of node_1a creates conflicting waiting for node_1 lock, then node_1 transaction requests lock. Before MDEV-27025 fix the requested lock would conflict with the waiting lock of node_1a. After the fix, the lock is granted as node_1 already holds lock, and node_1a waiting for node_1.

Marko Mäkelä added a comment - 2022-03-07 15:46

Now that ~~MDEV-27025~~ is being reverted due to the regression ~~MDEV-27992~~, this test will start to work again.

Marko Mäkelä added a comment - 2022-03-07 15:46 Now that MDEV-27025 is being reverted due to the regression MDEV-27992 , this test will start to work again.

People

Assignee:: Vladislav Lesin

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2022-01-20 05:34

Updated:: 2024-06-05 09:54

Resolved:: 2022-03-08 11:06

Git Integration

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

MariaDB Server