Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.6, 10.11, 11.4, 11.8
-
Can result in unexpected behaviour
-
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
Issue Links
- relates to
-
-
- Closed
-