[MDEV-29982] Improve the InnoDB log overwrite error message - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
Fix Version/s: 10.11.2, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3
Component/s: Storage Engine - InnoDB
Labels:
- corruption
- shutdown

Description

Related to ~~MDEV-29905~~ it has been discussed that the error message for change buffer merge errors, like

2022-10-24 23:58:25 0 [ERROR] InnoDB: The age of the last checkpoint is 991661268, which exceeds the log capacity 966365799.

should be changed to avoid that the user is killing the shutdown process because of this error message and a long running shutdown.

The error message should be changed to

2022-10-24 23:58:25 0 [ERROR] InnoDB: The age of the last checkpoint is 991661268, which exceeds the log capacity 966365799. Shutdown is still in progress.

We also should add a second message

[Note] InnoDB: Corruption fixed by log checkpoint at LSN=xxxxx

as "end of fatal condition" message

Attachments

Issue Links

relates to

MDEV-27784 log_overwrite_warning displays an error instead of a warning

Closed

MDEV-29905 Change buffer operations fail to check for log file overflow

Closed

MDEV-33670 Redo log overwritten/corrupted

Confirmed

MDEV-34566 InnoDB: Crash recovery is broken due to insufficient innodb_log_file_size (but wasn't in crash recovery)

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Ralf Gebhardt

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2022-11-09 09:06

Updated:: 2024-11-19 06:08

Resolved:: 2022-11-14 11:58

Git Integration

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