[MDEV-29744] safe_mutex: Found wrong usage of mutex 'LOCK_commit_ordered' and 'LOCK_global_system_variables', or of mutex 'LOCK_global_system_variables' and 'LOCK_log', on setting max_binlog_size or binlog_checksum and START TRANSACTION - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3(EOL), (15)
10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.6(EOL), 11.7(EOL)
Fix Version/s: 10.6.21, 10.11.11, 11.4.5, 11.7.2
Component/s: Binary Protocol, Locking
Labels:
- affects-tests
- mutex

Description

# mysqld options required for replay: --log-bin

SET GLOBAL max_binlog_size=98304;  # A valid and arbritary setting

START TRANSACTION WITH CONSISTENT SNAPSHOT;

Leads to:

10.11.0 6ebdd3013a18b01dbecec76b870810329eb76586 (Debug)
safe_mutex: Found wrong usage of mutex 'LOCK_commit_ordered' and 'LOCK_global_system_variables'

And

# mysqld options required for replay: --log-bin

START TRANSACTION WITH CONSISTENT SNAPSHOT;

SET GLOBAL max_binlog_size=98304;  # A valid and arbritary setting

Leads to:

10.11.0 6ebdd3013a18b01dbecec76b870810329eb76586 (Debug)
safe_mutex: Found wrong usage of mutex 'LOCK_global_system_variables' and 'LOCK_log'

Bug confirmed present in:
MariaDB: 10.3.37 (dbg), 10.4.27 (dbg), 10.5.18 (dbg), 10.6.10 (dbg), 10.7.6 (dbg), 10.8.5 (dbg), 10.9.3 (dbg), 10.10.2 (dbg), 10.11.0 (dbg)

Attachments

Issue Links

is duplicated by

MDEV-35197 Wrong locking order of LOCK_log and LOCK_global_system_variables, potential deadlock of server

Closed

relates to

MDEV-35197 Wrong locking order of LOCK_log and LOCK_global_system_variables, potential deadlock of server

Closed

Activity

Transition	Time In Source Status	Execution Times

Roel Van de Paar made transition - 2022-10-14 23:06

Open

Confirmed

6d 16h 59m

Kristian Nielsen made transition - 2024-10-22 08:40

Confirmed

In Progress

738d 9h 34m

Kristian Nielsen made transition - 2024-10-22 12:52

In Progress

In Review

4h 11m

Sergei Golubchik made transition - 2025-01-08 15:45

In Review

Stalled

78d 2h 52m

Kristian Nielsen made transition - 2025-01-09 09:50

Stalled

Closed

18h 5m

People

Assignee:: Kristian Nielsen

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2022-10-08 06:06

Updated:: 2025-01-09 23:07

Resolved:: 2025-01-09 09:50

Git Integration

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

MariaDB Server