Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-39411

InnoDB: Failing assertion: sym_node->table != NULL

    XMLWordPrintable

Details

    • 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

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            saahil Saahil Alam
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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