[MDEV-36017] Fatal InnoDB error: Unknown error Temp file write failure - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.11.9, 10.11.10
Fix Version/s: 10.6.23, 10.11.13, 11.4.7, 11.8.3, 12.0.2
Component/s: Storage Engine - InnoDB
Labels:
None
Environment:
Ubuntu 20.04

Bug Category:
Can result in hang or crash
Sprint:
Q3/2025 Maintenance

Description

The last few days one of our 10.11.10 galera clusters is crashing completely with the follow error: [ERROR] [FATAL] InnoDB: Unknown error Temp file write failure

I've attached the full log.

Looking at the log it seems to be caused by an OPTIMIZE. The table that is being optimized has about 6.7M rows, about 2M are added and removed each day.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

node01.log
10 kB
2025-02-03 09:37

Issue Links

relates to

MDEV-37194 Crash when partitioning a large table.

Closed

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: Rick Tuk

Votes:: 1 Vote for this issue

Watchers:: 10 Start watching this issue

Dates

Created:: 2025-02-03 09:38

Updated:: 2025-07-10 11:20

Resolved:: 2025-05-26 05:13

Git Integration

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