Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.11
-
Can result in hang or crash
Description
Assertion found on 10.11
|
MariaDB 10.11.15-MariaDB-debug-log source revision 2f5bad2f2bbe1c43bf796edb67b93fc64d3c3157 |
2026-04-22 5:17:43 14 [ERROR] InnoDB: The table `test`.`t2` doesn't have a corresponding tablespace, it was discarded.
|
2026-04-22 5:17:43 14 [ERROR] InnoDB: The table `test`.`t2` doesn't have a corresponding tablespace, it was discarded.
|
2026-04-22 5:17:43 14 [ERROR] Got error 194 when reading table './test/t2'
|
2026-04-22 5:17:43 14 [ERROR] InnoDB: The table `test`.`t2` doesn't have a corresponding tablespace, it was discarded.
|
2026-04-22 05:17:44 0x623c239cd6c0 InnoDB: Assertion failure in file /data/Server/10.11E/storage/innobase/pars/pars0pars.cc line 771
|
InnoDB: Failing assertion: sym_node->table != NULL
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mariadbd startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
|
InnoDB: about forcing recovery.
|
260422 5:17:44 [ERROR] /Server_bin/10.11E_debug_Og/bin/mariadbd got signal 6 ;
|
Sorry, we probably made a mistake, and this is a bug.
|
|
|
Your assistance in bug reporting will enable us to fix this for the next release.
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
|
a bug on https://jira.mariadb.org/.
|
|
|
Please include the information from the server start above, to the end of the
|
information below.
|
|
|
Server version: 10.11.15-MariaDB-debug-log source revision: 2f5bad2f2bbe1c43bf796edb67b93fc64d3c3157
|
|
|
The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
|
contains instructions to obtain a better version of the backtrace below.
|
Following these instructions will help MariaDB developers provide a fix quicker.
|
|
|
Attempting backtrace. Include this in the bug report.
|
(note: Retrieving this information may fail)
|
|
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:44
|
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>) at ./nptl/pthread_kill.c:78
|
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
|
#3 __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
|
#4 __GI_abort () at ./stdlib/abort.c:79
|
#5 ut_dbg_assertion_failed (expr=expr@entry="sym_node->table != NULL", file=file@entry="/data/Server/10.11E/storage/innobase/pars/pars0pars.cc", line=line@entry=771) at /data/Server/10.11E/storage/innobase/ut/ut0dbg.cc:60
|
#6 pars_retrieve_table_def (sym_node=sym_node@entry=) at /data/Server/10.11E/storage/innobase/pars/pars0pars.cc:771
|
#7 pars_update_statement (node=, cursor_sym=cursor_sym@entry=, search_cond=) at /data/Server/10.11E/storage/innobase/pars/pars0pars.cc:1177
|
#8 yyparse () at /dev/shm/build_dir/storage/innobase/pars0grm.y:349
|
#9 pars_sql (info=info@entry=, str=str@entry="PROCEDURE P() IS\nBEGIN UPDATE $table_name SET value = :value WHERE key = :name;\nEND;\n") at /data/Server/10.11E/storage/innobase/pars/pars0pars.cc:1978
|
#10 fts_parse_sql (fts_table=fts_table@entry=, info=info@entry=, sql=sql@entry="BEGIN UPDATE $table_name SET value = :value WHERE key = :name;") at /data/Server/10.11E/storage/innobase/fts/fts0sql.cc:136
|
#11 fts_config_set_value (trx=trx@entry=, fts_table=fts_table@entry=, name="use_stopword", value=value@entry=) at /data/Server/10.11E/storage/innobase/fts/fts0config.cc:218
|
#12 fts_config_set_ulint (trx=trx@entry=, fts_table=fts_table@entry=, name=<optimized out>, name@entry="use_stopword", int_value=int_value@entry=1) at /data/Server/10.11E/storage/innobase/fts/fts0config.cc:419
|
#13 fts_load_stopword (table=table@entry=, trx=trx@entry=, session_stopword_table=session_stopword_table@entry=, stopword_is_on=true, reload=reload@entry=false) at /data/Server/10.11E/storage/innobase/fts/fts0fts.cc:5878
|
#14 innobase_fts_load_stopword (table=, trx=, thd=) at /data/Server/10.11E/storage/innobase/handler/ha_innodb.cc:11479
|
#15 prepare_inplace_alter_table_dict (ha_alter_info=<optimized out>, altered_table=altered_table@entry=, old_table=<optimized out>, table_name=<optimized out>, flags=<optimized out>, flags2=<optimized out>, fts_doc_id_col=<optimized out>,
|
add_fts_doc_id=<optimized out>, add_fts_doc_id_idx=<optimized out>) at /data/Server/10.11E/storage/innobase/handler/handler0alter.cc:7483
|
#16 ha_innobase::prepare_inplace_alter_table (this=, altered_table=<optimized out>, ha_alter_info=<optimized out>) at /data/Server/10.11E/storage/innobase/handler/handler0alter.cc:8795
|
#17 handler::ha_prepare_inplace_alter_table (this=, altered_table=altered_table@entry=, ha_alter_info=ha_alter_info@entry=) at /data/Server/10.11E/sql/handler.cc:5411
|
#18 mysql_inplace_alter_table (thd=thd@entry=, table_list=, table=table@entry=, altered_table=altered_table@entry=, ha_alter_info=ha_alter_info@entry=, target_mdl_request=target_mdl_request@entry=, ddl_log_state=, trigger_param=, alter_ctx=,
|
partial_alter=false, start_alter_id=0, if_exists=false) at /data/Server/10.11E/sql/sql_table.cc:8073
|
#19 mysql_alter_table (thd=thd@entry=, new_db=new_db@entry=, new_name=<optimized out>, create_info=create_info@entry=, table_list=<optimized out>, table_list@entry=, recreate_info=recreate_info@entry=, alter_info=<optimized out>,
|
order_num=<optimized out>, order=<optimized out>, ignore=<optimized out>, if_exists=<optimized out>) at /data/Server/10.11E/sql/sql_table.cc:11404
|
#20 Sql_cmd_alter_table::execute (this=<optimized out>, thd=) at /data/Server/10.11E/sql/sql_alter.cc:688
|
#21 mysql_execute_command (thd=thd@entry=, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/Server/10.11E/sql/sql_parse.cc:6169
|
#22 mysql_parse (thd=thd@entry=, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=) at /data/Server/10.11E/sql/sql_parse.cc:8184
|
#23 dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=, packet=packet@entry="ALTER TABLE t2 ADD FULLTEXT INDEX IF NOT EXISTS ft_fz_773 (col_varchar);", packet_length=packet_length@entry=72, blocking=blocking@entry=true)
|
at /data/Server/10.11E/sql/sql_parse.cc:1906
|
#24 do_command (thd=thd@entry=, blocking=blocking@entry=true) at /data/Server/10.11E/sql/sql_parse.cc:1419
|
#25 do_handle_one_connection (connect=<optimized out>, connect@entry=, put_in_cache=put_in_cache@entry=true) at /data/Server/10.11E/sql/sql_connect.cc:1475
|
#26 handle_one_connection (arg=) at /data/Server/10.11E/sql/sql_connect.cc:1387
|
#27 start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
|
#28 clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:100
|
|
|
|
|
Connection ID (thread ID): 14
|
Status: NOT_KILLED
|
Query (0x77a4780135c0): ALTER TABLE t2 ADD FULLTEXT INDEX IF NOT EXISTS ft_fz_773 (col_varchar)
|
|
Startup options used |
--loose-innodb-buffer-pool-size=128M
|
--loose-innodb-log-file-size=48M
|
--max-connections=50
|
--loose-innodb-flush-log-at-trx-commit=0
|
--loose-sync-binlog=0
|
--core-file
|
--loose-innodb_lock_schedule_algorithm=fcfs
|
--loose-idle_write_transaction_timeout=0
|
--loose-idle_transaction_timeout=0
|
--loose-idle_readonly_transaction_timeout=0
|
--connect_timeout=60
|
--loose-innodb_fatal_semaphore_wait_threshold=300
|
--log_output=none
|
--log_bin_trust_function_creators=1
|
--loose-debug_assert_on_not_freed_memory=0
|
--loose-innodb_read_only_compressed=OFF
|
--loose-max-statement-time=30
|
--loose-innodb_page_size=64K
|
--loose-innodb-buffer-pool-size=256M
|
--lock-wait-timeout=15
|
--loose-innodb-lock-wait-timeout=10
|
--sql_mode=traditional
|
--loose-innodb_file_per_table=1
|
--loose-innodb_stats_persistent=on
|
--loose-innodb_adaptive_hash_index=on
|
--loose-innodb_sort_buffer_size=65536
|
--loose-innodb_random_read_ahead=ON
|
--loose-innodb-open-files=10
|
--log-bin
|
--sync-binlog=1
|
--loose-innodb_evict_tables_on_commit_debug=on
|
--loose-innodb_undo_log_truncate=ON
|
--loose-innodb_rollback_on_timeout=OFF
|
RR trace is present on SDP:-
/data/DB_killer/BUGS/MDEV-39411/rr