[MDEV-25975] Turning on innodb_disallow_writes will cause mysqladmin shutdown to hang - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
Fix Version/s: 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3, 10.9.1
Component/s: Locking, Storage Engine - InnoDB
Labels:
- Memory_leak
- affects-tests
- hang
- lock

Description

SET GLOBAL innodb_disallow_writes=ON;

# Exit the client, and execute: mysqladmin shutdown

(No other SQL is required and innodb_fast_shutdown=1)

Will cause mysqladmin shutdown to hang, on debug and optimized builds alike.

Attachments

Issue Links

blocks

MDEV-27437 Galera snapshot transfer fails to upgrade between some major versions

Closed

causes

MDEV-28247 Disable background ibuf merge during Galera SST

Closed

relates to

MDEV-28256 Galera SST fails with 'InnoDB: Upgrade after a crash is not supported'

Closed

MDEV-24845 Oddities around innodb_fatal_semaphore_wait_threshold and global.innodb_disallow_writes

Closed

MDEV-26491 SIGABRT when setting innodb_disallow_writes and --innodb-fatal-semaphore-wait-threshold=2 and attempting DROP TABLE

Closed

Activity

Ascending order - Click to sort in descending order

Roel Van de Paar created issue - 2021-06-21 10:30

Roel Van de Paar made changes - 2021-06-21 10:31

Field	Original Value	New Value
Status	Open [ 1 ]	Confirmed [ 10101 ]

Marko Mäkelä made changes - 2021-08-28 07:53

Link

This issue relates to ~~MDEV-24845~~ [ ~~MDEV-24845~~ ]

Marko Mäkelä made changes - 2021-08-28 07:54

Link

This issue relates to ~~MDEV-26491~~ [ ~~MDEV-26491~~ ]

Roel Van de Paar made changes - 2021-08-29 19:15

Labels

hang

affects-tests hang

Roel Van de Paar made changes - 2021-11-05 04:54

Component/s

Locking [ 10900 ]

Roel Van de Paar made changes - 2021-11-05 04:54

Labels

affects-tests hang

affects-tests hang lock

Roel Van de Paar made changes - 2021-11-05 04:55

Labels

affects-tests hang lock

Memory_leak affects-tests hang lock

Roel Van de Paar made changes - 2021-11-05 04:55

Affects Version/s

10.7 [ 24805 ]

Roel Van de Paar made changes - 2021-11-05 04:55

Fix Version/s

10.6 [ 24028 ]

Sergei Golubchik made changes - 2021-12-06 21:36

Workflow

MariaDB v3 [ 122870 ]

MariaDB v4 [ 144371 ]

Jan Lindström (Inactive) made changes - 2022-01-24 11:07

Assignee

Seppo Jaakola [ seppo ]

Jan Lindström [ jplindst ]

Jan Lindström (Inactive) made changes - 2022-01-24 11:09

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Duplicate [ 3 ]
Status	Confirmed [ 10101 ]	Closed [ 6 ]

Roel Van de Paar made changes - 2022-01-26 05:07

Comment

[ Please test all testcases in this bug upon fixing ~~MDEV-24845~~. Thank you ]

Roel Van de Paar made changes - 2022-01-26 05:09

Resolution	Duplicate [ 3 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Julien Fritsch made changes - 2022-01-26 10:57

Fix Version/s		10.2 [ 14601 ]
Fix Version/s		10.3 [ 22126 ]
Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.7 [ 24805 ]
Fix Version/s	N/A [ 14700 ]

Roel Van de Paar made changes - 2022-01-28 04:41

Fix Version/s

10.7 [ 24805 ]

Roel Van de Paar made changes - 2022-01-28 22:06

Fix Version/s

10.7 [ 24805 ]

Marko Mäkelä made changes - 2022-03-30 10:00

Assignee

Jan Lindström [ jplindst ]

Marko Mäkelä [ marko ]

Marko Mäkelä made changes - 2022-03-30 10:04

Assignee	Marko Mäkelä [ marko ]	Jan Lindström [ jplindst ]
Status	Stalled [ 10000 ]	In Review [ 10002 ]

Marko Mäkelä made changes - 2022-03-30 10:04

Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]

Jan Lindström (Inactive) made changes - 2022-04-05 14:03

Assignee

Jan Lindström [ jplindst ]

Marko Mäkelä [ marko ]

Jan Lindström (Inactive) made changes - 2022-04-05 14:31

Assignee

Marko Mäkelä [ marko ]

Jan Lindström [ jplindst ]

Jan Lindström (Inactive) made changes - 2022-04-05 14:32

Assignee	Jan Lindström [ jplindst ]	Marko Mäkelä [ marko ]
Status	In Review [ 10002 ]	Stalled [ 10000 ]

Marko Mäkelä made changes - 2022-04-06 11:18

Link

This issue causes ~~MDEV-28247~~ [ ~~MDEV-28247~~ ]

Marko Mäkelä made changes - 2022-04-06 11:32

issue.field.resolutiondate

2022-04-06 11:32:13.0

2022-04-06 11:32:13.321

Marko Mäkelä made changes - 2022-04-06 11:32

Fix Version/s		10.3.35 [ 27512 ]
Fix Version/s		10.4.25 [ 27510 ]
Fix Version/s		10.5.16 [ 27508 ]
Fix Version/s		10.6.8 [ 27506 ]
Fix Version/s		10.7.4 [ 27504 ]
Fix Version/s		10.8.3 [ 27502 ]
Fix Version/s		10.9.1 [ 27114 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.7 [ 24805 ]
Fix Version/s	10.8 [ 26121 ]
Fix Version/s	10.9 [ 26905 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Marko Mäkelä made changes - 2022-04-07 12:36

Link

This issue relates to ~~MDEV-28256~~ [ ~~MDEV-28256~~ ]

Marko Mäkelä made changes - 2022-04-07 12:41

Link

This issue blocks ~~MDEV-27437~~ [ ~~MDEV-27437~~ ]

People

Assignee:: Marko Mäkelä

Reporter:: Roel Van de Paar

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2021-06-21 10:30

Updated:: 2022-04-07 12:41

Resolved:: 2022-04-06 11:32

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration