[MDEV-33062] innodb_undo_log_truncate=ON prevents fast shutdown - Jira

XML

Word

Printable

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(EOL), 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)
Fix Version/s: 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3, 11.3.2
Component/s: Storage Engine - InnoDB
Labels:
- performance
- shutdown

Description

When the function trx_purge_truncate_history() is shrinking undo tablespaces due to innodb_undo_log_truncate=ON, it will keep doing so even after a fast shutdown has been initiated. It should only do that on a shutdown with innodb_fast_shutdown=0.

This was noticed by axel while testing the fix of ~~MDEV-33009~~.

Attachments

Issue Links

relates to

MDEV-33009 Server hangs for a long time with innodb_undo_log_truncate=ON

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2023-12-19 09:20

Updated:: 2023-12-20 06:25

Resolved:: 2023-12-20 06:25

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

0.25d

Git Integration

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