[MDEV-38026] Recovery of FILE_CREATE fails to create a file - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.6, 10.11, 11.4, 11.8
Fix Version/s: 10.6.25, 10.11.16, 11.4.10, 11.8.6
Component/s: Storage Engine - InnoDB
Labels:

Bug Category:
Can result in unexpected behaviour
Release Note Summary:
If the server was killed during an operation that creates a .ibd file, such as TRUNCATE TABLE, it could fail to recover.

Description

Recovery issue found while testing ~~MDEV-37994~~ on release build
Please check if its related

Leads to:-

origin/MDEV-37994 8b3e0d97ad028378d8eb2a2586e28a8ddfaa650f
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:12 0 [ERROR] InnoDB: Tablespace 2045 was not found at ./test/FTS_00000000000007ff_0000000000000bdd_INDEX_6.ibd.
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:12 0 [ERROR] InnoDB: Set innodb_force_recovery=1 to ignore this and to permanently lose all changes to the tablespace.
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:12 0 [ERROR] InnoDB: Plugin initialization aborted with error Tablespace not found
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:12 0 [Note] InnoDB: Starting shutdown...
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [Note] mariadbd: Aria engine: starting recovery
# 2025-11-04T23:47:36 [3984102] \| recovered pages: 0% 10% 20% 30% 41% 51% 61% 71% 82% 92% 100% (0.0 seconds); tables to flush: 1 0
# 2025-11-04T23:47:36 [3984102] \| (0.0 seconds);
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [Note] mariadbd: Aria engine: recovery done
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [Note] Plugin 'FEEDBACK' is disabled.
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [Warning] 'innodb-lock-schedule-algorithm' was removed. It does nothing now and exists only for compatibility with old my.cnf files.
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [Warning] /Server_bin/MDEV-37994_RelWithDebInfo/bin/mariadbd: unknown variable 'loose-table_lock_wait_timeout=50'
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [Warning] /Server_bin/MDEV-37994_RelWithDebInfo/bin/mariadbd: unknown variable 'loose-debug_assert_on_not_freed_memory=0'
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [Warning] /Server_bin/MDEV-37994_RelWithDebInfo/bin/mariadbd: unknown option '--loose-innodb-sync-debug'
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [Warning] /Server_bin/MDEV-37994_RelWithDebInfo/bin/mariadbd: unknown variable 'loose-innodb_evict_tables_on_commit_debug=off'
# 2025-11-04T23:47:36 [3984102] \| 2025-11-04 23:47:13 0 [ERROR] Unknown/unsupported storage engine: InnoDB

RR trace is present on SDP:-
/data/results/1762326053/TBR-1105

Attachments

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

encryption_keys.txt
2025-11-05 09:39
0.4 kB
Marko Mäkelä
data.tar.xz
2025-11-05 09:39
3.31 MB
Marko Mäkelä

Issue Links

relates to

MDEV-37994 Race condition between checkpoint and .ibd file creation

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Saahil Alam

Assigned for Implementation:: Marko Mäkelä

Assigned for Review:: Thirunarayanan Balathandayuthapani

Assigned for Testing:: Saahil Alam

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2025-11-05 09:10

Updated:: 6 days ago 09:32

Resolved:: 2025-11-07 06:36

Git Integration

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