[MDEV-37467] Kill+restart during ALTER leads to InnoDB: Table … contains unrecognizable instant ALTER metadata - Jira

XML

Word

Printable

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Critical
Resolution: Unresolved
Affects Version/s: 10.6, 10.11, 10.4(EOL), 10.5(EOL)
Fix Version/s: 10.6, 10.11
Component/s: Data Definition - Alter Table, Storage Engine - InnoDB
Labels:

Bug Category:
Can result in hang or crash

Description

Assertion found on debug build
Leads to :-

GIT_SHOW: HEAD -> 10.11, origin/10.11 e8026a50197cbfccd70a2072cbc0ae4728a4ab40 2025-08-15T09:47:40+03:00

# 2025-08-19T22:40:06 [1904603] | 2025-08-19 22:40:06 0 [ERROR] InnoDB: Table `test`.`t1` contains unrecognizable instant ALTER metadata

# 2025-08-19T22:40:06 [1904603] | mariadbd: /data/Server/10.11_new/storage/innobase/dict/dict0load.cc:2535: dict_table_t* dict_load_table_one(const st_::span<const char>&, dict_err_ignore_t, dict_names_t&): Assertion `!table || (ignore_err & ~DICT_ERR_IGNORE_FK_NOKEY) || !table->is_readable() || !table->corrupted' failed.

Stacktrace
# 2025-08-19T22:42:19 [1904603] \| Thread 1 (Thread 2067397.2067397 (mariadbd)):
# 2025-08-19T22:42:19 [1904603] \| #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=140423666822400) at ./nptl/pthread_kill.c:44
# 2025-08-19T22:42:19 [1904603] \| #1 __pthread_kill_internal (signo=6, threadid=140423666822400) at ./nptl/pthread_kill.c:78
# 2025-08-19T22:42:19 [1904603] \| #2 __GI___pthread_kill (threadid=140423666822400, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
# 2025-08-19T22:42:19 [1904603] \| #3 0x00007fb6eecc1476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
# 2025-08-19T22:42:19 [1904603] \| #4 0x00007fb6eeca77f3 in __GI_abort () at ./stdlib/abort.c:79
# 2025-08-19T22:42:19 [1904603] \| #5 0x00007fb6eeca771b in __assert_fail_base (fmt=0x7fb6eee5c130 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x555d174c4f48 "!table \|\| (ignore_err & ~DICT_ERR_IGNORE_FK_NOKEY) \|\| !table->is_readable() \|\| !table->corrupted", file=0x555d174c3800 "/data/Server/10.11_new/storage/innobase/dict/dict0load.cc", line=2535, function=<optimized out>) at ./assert/assert.c:92
# 2025-08-19T22:42:19 [1904603] \| #6 0x00007fb6eecb8e96 in __GI___assert_fail (assertion=0x555d174c4f48 "!table \|\| (ignore_err & ~DICT_ERR_IGNORE_FK_NOKEY) \|\| !table->is_readable() \|\| !table->corrupted", file=0x555d174c3800 "/data/Server/10.11_new/storage/innobase/dict/dict0load.cc", line=2535, function=0x555d174c4bf0 "dict_table_t* dict_load_table_one(const st_::span<const char>&, dict_err_ignore_t, dict_names_t&)") at ./assert/assert.c:101
# 2025-08-19T22:42:19 [1904603] \| #7 0x0000555d16e94802 in dict_load_table_one (name=..., ignore_err=ignore_err@entry=DICT_ERR_IGNORE_NONE, fk_tables=std::__debug::deque with 0 elements) at /data/Server/10.11_new/storage/innobase/dict/dict0load.cc:2535
# 2025-08-19T22:42:19 [1904603] \| #8 0x0000555d16e94ba2 in dict_sys_t::load_table (this=this@entry=0x555d17c58700 <dict_sys>, name=..., ignore=ignore@entry=DICT_ERR_IGNORE_NONE) at /data/Server/10.11_new/storage/innobase/dict/dict0load.cc:2569
# 2025-08-19T22:42:19 [1904603] \| #9 0x0000555d16e78099 in dict_table_open_on_name (table_name=table_name@entry=0x7ffd35e16a60 "test/t1", dict_locked=dict_locked@entry=false, ignore_err=ignore_err@entry=DICT_ERR_IGNORE_NONE) at /data/Server/10.11_new/storage/innobase/dict/dict0dict.cc:1071
# 2025-08-19T22:42:19 [1904603] \| #10 0x0000555d16af2091 in innodb_check_version (hton=<optimized out>, path=0x7ffd35e16fc0 "./test/t1", version=<optimized out>, create_id=8060) at /data/Server/10.11_new/storage/innobase/handler/ha_innodb.cc:1917
# 2025-08-19T22:42:19 [1904603] \| #11 0x0000555d16595a31 in ddl_log_execute_action (thd=thd@entry=0x555d199aea28, mem_root=mem_root@entry=0x7ffd35e17420, ddl_log_entry=ddl_log_entry@entry=0x7ffd35e17460) at /data/Server/10.11_new/sql/ddl_log.cc:2040
# 2025-08-19T22:42:19 [1904603] \| #12 0x0000555d16596319 in ddl_log_execute_entry_no_lock (thd=thd@entry=0x555d199aea28, first_entry=<optimized out>) at /data/Server/10.11_new/sql/ddl_log.cc:2421
# 2025-08-19T22:42:19 [1904603] \| #13 0x0000555d16597260 in ddl_log_execute_recovery () at /data/Server/10.11_new/sql/ddl_log.cc:2797
# 2025-08-19T22:42:19 [1904603] \| #14 0x0000555d16332f2e in init_server_components () at /data/Server/10.11_new/sql/mysqld.cc:5528
# 2025-08-19T22:42:19 [1904603] \| #15 0x0000555d16336cba in mysqld_main (argc=<optimized out>, argv=<optimized out>) at /data/Server/10.11_new/sql/mysqld.cc:5882
# 2025-08-19T22:42:19 [1904603] \| #16 0x0000555d16329e56 in main (argc=<optimized out>, argv=<optimized out>) at /data/Server/10.11_new/sql/main.cc:34

Seems there is a recovery failure
RR trace is present on pluto:-
/data/results/1755633923/TBR-1322

Attachments

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

data.tar.xz
1.92 MB
2025-08-20 11:26

Issue Links

is caused by

MDEV-15562 Instant DROP COLUMN or changing the order of columns

Closed

Activity

People

Assignee:: Marko Mäkelä

Reporter:: Saahil Alam

Assigned for Implementation:: Marko Mäkelä

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2025-08-20 09:41

Updated:: 2025-08-20 11:29

Git Integration

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