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

InnoDB: Failing assertion: trx->error_state == DB_SUCCESS in que_run_threads

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.4, 11.5(EOL)
    • 10.6, 10.11, 11.4
    • Full-text Search

    Description

      There is MDEV-14833 but it looks unrelated.

      CREATE TABLE server_stopword (value VARCHAR(1));
      SET GLOBAL innodb_ft_server_stopword_table='test/server_stopword';
      CREATE TABLE t (t VARCHAR(1) COLLATE utf8_unicode_ci,FULLTEXT (t));
      TRUNCATE TABLE t;
      

      Changing 'value' to 'VALUE' stops the bug from occuring.

      Leads to:

      10.11.2 70be59913c90e93fe5136d6f6df03c4254aa515d (Debug)

      InnoDB: Failing assertion: trx->error_state == DB_SUCCESS
      

      10.11.2 70be59913c90e93fe5136d6f6df03c4254aa515d (Debug)

      Core was generated by `/test/MD070123-mariadb-10.11.2-linux-x86_64-dbg/bin/mysqld --no-defaults --core'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=22958177695296)
          at ./nptl/pthread_kill.c:44
      [Current thread is 1 (Thread 0x14e15e06b640 (LWP 474766))]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=22958177695296) at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=22958177695296) at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=22958177695296, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      #3  0x000014e176cdc476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      #4  0x000014e176cc27f3 in __GI_abort () at ./stdlib/abort.c:79
      #5  0x0000563fd154fbdc in ut_dbg_assertion_failed (expr=expr@entry=0x563fd1ac8340 "trx->error_state == DB_SUCCESS", file=file@entry=0x563fd1af5dc8 "/test/10.11_dbg/storage/innobase/que/que0que.cc", line=line@entry=672) at /test/10.11_dbg/storage/innobase/ut/ut0dbg.cc:60
      #6  0x0000563fd144fdcf in que_run_threads (thr=<optimized out>) at /test/10.11_dbg/storage/innobase/que/que0que.cc:672
      #7  0x0000563fd167736c in fts_eval_sql (trx=trx@entry=0x14e16e45e180, graph=graph@entry=0x14e11c1417f8) at /test/10.11_dbg/storage/innobase/fts/fts0sql.cc:163
      #8  0x0000563fd16692cf in fts_config_set_value (trx=trx@entry=0x14e16e45e180, fts_table=fts_table@entry=0x14e15e069260, name=name@entry=0x563fd1adb442 "stopword_table_name", value=value@entry=0x14e15e069220) at /test/10.11_dbg/storage/innobase/fts/fts0config.cc:253
      #9  0x0000563fd166261c in fts_load_stopword (table=table@entry=0x14e11c12ab60, trx=<optimized out>, trx@entry=0x0, session_stopword_table=session_stopword_table@entry=0x14e11c013cc8 "test/server_stopword", stopword_is_on=<optimized out>, reload=reload@entry=false) at /test/10.11_dbg/storage/innobase/fts/fts0fts.cc:5684
      #10 0x0000563fd1344ccc in innobase_fts_load_stopword (table=table@entry=0x14e11c12ab60, trx=trx@entry=0x0, thd=thd@entry=0x14e11c000d58) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:11390
      #11 0x0000563fd135d240 in create_table_info_t::create_table_update_dict (table=0x14e11c12ab60, thd=0x14e11c000d58, info=@0x14e15e0698a0: {<Table_scope_and_contents_source_st> = {<Table_scope_and_contents_source_pod_st> = {alter_table_convert_to_charset = 0x0, tabledef_version = {str = 0x0, length = 0}, org_tabledef_version = {str = 0x0, length = 0}, connect_string = {str = 0x0, length = 0}, comment = {str = 0x14e11c023710 "", length = 0}, alias = {str = 0x0, length = 0}, org_storage_engine_name = {str = 0x0, length = 0}, new_storage_engine_name = {str = 0x0, length = 0}, password = 0x0, tablespace = 0x0, data_file_name = 0x0, index_file_name = 0x0, max_rows = 0, min_rows = 0, auto_increment_value = 0, table_options = 9, avg_row_length = 0, used_fields = 0, key_block_size = 0, expression_length = 0, field_check_constraints = 0, stats_sample_pages = 0, null_bits = 0, options = 0, merge_insert_method = 0, extra_size = 0, db_type = 0x0, row_type = ROW_TYPE_DYNAMIC, transactional = HA_CHOICE_UNDEF, storage_media = HA_SM_DEFAULT, page_checksum = HA_CHOICE_UNDEF, option_list = 0x0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, varchar = false, sequence = false, check_constraint_list = 0x0, option_struct = 0x0, fields_option_struct = 0x0, indexes_option_struct = 0x0, table = 0x0, pos_in_locked_tables = 0x0, merge_list = 0x0, mdl_ticket = 0x0, table_was_deleted = false, seq_create_info = 0x0}, vers_info = {<Table_period_info> = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x563fd1a4d4e9 "SYSTEM_TIME", length = 11}, <No data fields>}, <No data fields>}, period = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, create_if_not_exists = false, constr = 0x0, unique_keys = 0}, as_row = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, versioned_fields = false, unversioned_fields = false}, period_info = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, period = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, create_if_not_exists = false, constr = 0x0, unique_keys = 0}}, <Schema_specification_st> = {default_table_charset = 0x563fd21db4a0 <my_charset_latin1>, schema_comment = 0x0}, alter_info = 0x0}, t=@0x14e11c125f88: {s = 0x14e11c023000, file = 0x14e11c1267a0, next = 0x0, prev = 0x0, share_all_next = 0x0, share_all_prev = 0x14e11c11bde8, global_free_next = 0x0, global_free_prev = 0x0, instance = 0, in_use = 0x14e11c000d58, record = {0x14e11c126388 "\377", 0x14e11c126390 "\245\245\245\245\245\245\245\245\320c\022\034\341\024", 0x14e11c126390 "\245\245\245\245\245\245\245\245\320c\022\034\341\024"}, write_row_record = 0x0, insert_values = 0x0, covering_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, intersect_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, keys_in_use_for_query = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, keys_in_use_for_group_by = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, keys_in_use_for_order_by = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, constraint_dependent_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, key_info = 0x14e11c1264b0, field = 0x14e11c126398, vfield = 0x0, default_field = 0x0, next_number_field = 0x0, found_next_number_field = 0x0, check_constraints = 0x0, triggers = 0x0, pos_in_table_list = 0x14e11c0131e8, pos_in_locked_tables = 0x0, internal_tables = 0x0, group = 0x0, alias = {<Charset> = {m_charset = 0x563fd21b8080 <my_charset_bin>}, <Binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x14e11c10bde8 "t", str_length = 1, Alloced_length = 8, extra_alloc = 0, alloced = true, thread_specific = false}, <No data fields>}, null_flags = 0x14e11c126388 "\377", def_read_set = {bitmap = 0x14e11c126590, last_word_ptr = 0x14e11c126590, last_word_mask = 4294967294, n_bits = 1}, def_write_set = {bitmap = 0x14e11c126594, last_word_ptr = 0x14e11c126594, last_word_mask = 4294967294, n_bits = 1}, tmp_set = {bitmap = 0x14e11c12659c, last_word_ptr = 0x14e11c12659c, last_word_mask = 4294967294, n_bits = 1}, def_rpl_write_set = {bitmap = 0x14e11c1265a8, last_word_ptr = 0x14e11c1265a8, last_word_mask = 4294967294, n_bits = 1}, eq_join_set = {bitmap = 0x14e11c1265a0, last_word_ptr = 0x14e11c1265a0, last_word_mask = 4294967294, n_bits = 1}, cond_set = {bitmap = 0x14e11c1265a4, last_word_ptr = 0x14e11c1265a4, last_word_mask = 4294967294, n_bits = 1}, read_set = 0x14e11c1260b8, write_set = 0x14e11c1260d0, rpl_write_set = 0x0, has_value_set = {bitmap = 0x14e11c126598, last_word_ptr = 0x14e11c126598, last_word_mask = 4294967294, n_bits = 1}, query_id = 5, collected_stats = 0x0, used_stat_records = 0, opt_range_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {11936128518282651045}}, opt_range = 0x14e11c1263a8, const_key_parts = 0x14e11c1263c8, opt_range_condition_rows = 0, cond_selectivity = 1, cond_selectivity_sampling_explain = 0x0, map = 0, lock_position = 0, lock_data_start = 0, lock_count = 0, tablenr = 0, used_fields = 0, temp_pool_slot = 0, status = 3, db_stat = 33, derived_select_number = 0, maybe_null = 0, current_lock = 1, copy_blobs = false, next_number_field_updated = false, null_row = false, no_rows_with_nulls = false, null_catch_flags = 0 '\000', force_index = false, force_index_order = false, force_index_group = false, distinct = false, const_table = false, no_rows = false, used_for_duplicate_elimination = false, keep_row_order = false, no_keyread = false, locked_by_logger = false, locked_by_name = false, fulltext_searched = false, no_cache = false, open_by_handler = false, auto_increment_field_not_null = false, insert_or_update = false, alias_name_used = false, get_fields_in_item_tree = false, vcol_refix_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x563fd228ef00 <end_of_list>, last = 0x14e11c126210, elements = 0}, <No data fields>}, m_needs_reopen = false, created = true, master_had_triggers = false, reginfo = {join_tab = 0x0, lock_type = TL_WRITE, skip_locked = false, not_exists_optimize = false, impossible_range = false}, mem_root = {free = 0x14e11c126368, used = 0x14e11c126788, pre_alloc = 0x0, min_malloc = 32, block_size = 1016, block_num = 6, first_block_usage = 0, flags = 0, error_handler = 0x563fd0ec84c4 <sql_alloc_error_handler()>, psi_key = 0}, blob_storage = 0x0, grant = {grant_table_user = 0x0, grant_table_role = 0x0, grant_public = 0x0, version = 0, privilege = (SELECT_ACL | INSERT_ACL | UPDATE_ACL | DELETE_ACL | CREATE_ACL | DROP_ACL | RELOAD_ACL | SHUTDOWN_ACL | PROCESS_ACL | FILE_ACL | GRANT_ACL | REFERENCES_ACL | INDEX_ACL | ALTER_ACL | SHOW_DB_ACL | SUPER_ACL | CREATE_TMP_ACL | LOCK_TABLES_ACL | EXECUTE_ACL | REPL_SLAVE_ACL | BINLOG_MONITOR_ACL | CREATE_VIEW_ACL | SHOW_VIEW_ACL | CREATE_PROC_ACL | ALTER_PROC_ACL | CREATE_USER_ACL | EVENT_ACL | TRIGGER_ACL | CREATE_TABLESPACE_ACL | DELETE_HISTORY_ACL | SET_USER_ACL | FEDERATED_ADMIN_ACL | CONNECTION_ADMIN_ACL | READ_ONLY_ADMIN_ACL | REPL_SLAVE_ADMIN_ACL | REPL_MASTER_ADMIN_ACL | BINLOG_ADMIN_ACL | BINLOG_REPLAY_ACL | SLAVE_MONITOR_ACL), want_privilege = NO_ACL, orig_want_privilege = DROP_ACL, m_internal = {m_schema_lookup_done = true, m_schema_access = 0x0, m_table_lookup_done = true, m_table_access = 0x0}}, expr_arena = 0x0, part_info = 0x0, all_partitions_pruned_away = false, max_keys = 0, stats_is_read = false, histograms_are_read = false, mdl_ticket = 0x14e11c01d1c0, spl_opt_info = 0x0, keys_usable_for_splitting = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, notnull_cond = 0x0, with_impossible_ranges = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, range_rowid_filter_cost_info_elems = 0, range_rowid_filter_cost_info = 0x0, range_rowid_filter_cost_info_ptr = 0x0, vers_write = false}) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:13047
      #12 0x0000563fd1363648 in ha_innobase::truncate (this=0x14e11c1267a0) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:13887
      #13 0x0000563fd107049a in handler::ha_truncate (this=0x14e11c1267a0) at /test/10.11_dbg/sql/handler.cc:5087
      #14 0x0000563fd0f2645f in Sql_cmd_truncate_table::handler_truncate (this=this@entry=0x14e11c013908, thd=thd@entry=0x14e11c000d58, table_ref=table_ref@entry=0x14e11c0131e8, is_tmp_table=is_tmp_table@entry=false) at /test/10.11_dbg/sql/sql_truncate.cc:255
      #15 0x0000563fd0f2733e in Sql_cmd_truncate_table::truncate_table (this=this@entry=0x14e11c013908, thd=thd@entry=0x14e11c000d58, table_ref=table_ref@entry=0x14e11c0131e8) at /test/10.11_dbg/sql/sql_truncate.cc:507
      #16 0x0000563fd0f27488 in Sql_cmd_truncate_table::execute (this=0x14e11c013908, thd=0x14e11c000d58) at /test/10.11_dbg/sql/sql_truncate.cc:573
      #17 0x0000563fd0da9261 in mysql_execute_command (thd=thd@entry=0x14e11c000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.11_dbg/sql/sql_parse.cc:6001
      #18 0x0000563fd0daac7a in mysql_parse (thd=thd@entry=0x14e11c000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14e15e06a2c0) at /test/10.11_dbg/sql/sql_parse.cc:8000
      #19 0x0000563fd0dace0e in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14e11c000d58, packet=packet@entry=0x14e11c00ae09 "TRUNCATE TABLE t", packet_length=packet_length@entry=16, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_class.h:243
      #20 0x0000563fd0daec67 in do_command (thd=0x14e11c000d58, blocking=blocking@entry=true) at /test/10.11_dbg/sql/sql_parse.cc:1407
      #21 0x0000563fd0ef8d30 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x563fd41beb68, put_in_cache=put_in_cache@entry=true) at /test/10.11_dbg/sql/sql_connect.cc:1416
      #22 0x0000563fd0ef8f8f in handle_one_connection (arg=0x563fd41beb68) at /test/10.11_dbg/sql/sql_connect.cc:1318
      #23 0x000014e176d2eb43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #24 0x000014e176dc0a00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      10.11.2 70be59913c90e93fe5136d6f6df03c4254aa515d (Optimized)

      InnoDB: Failing assertion: trx->error_state == DB_SUCCESS
      

      10.11.2 70be59913c90e93fe5136d6f6df03c4254aa515d (Optimized)

      Core was generated by `/test/MD070123-mariadb-10.11.2-linux-x86_64-opt/bin/mysqld --no-defaults --core'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=22714476836416)
          at ./nptl/pthread_kill.c:44
      [Current thread is 1 (Thread 0x14a8a052b640 (LWP 474463))]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=22714476836416) at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=22714476836416) at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=22714476836416, signo=signo@entry=6) at ./nptl/pthread_kill.c:89
      #3  0x000014a8cdfcb476 in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
      #4  0x000014a8cdfb17f3 in __GI_abort () at ./stdlib/abort.c:79
      #5  0x0000560930ccabe1 in ut_dbg_assertion_failed (expr=expr@entry=0x56093188d550 "trx->error_state == DB_SUCCESS", file=file@entry=0x56093188d520 "/test/10.11_opt/storage/innobase/que/que0que.cc", line=line@entry=672) at /test/10.11_opt/storage/innobase/ut/ut0dbg.cc:60
      #6  0x0000560930cb76a2 in que_run_threads (thr=<optimized out>) at /test/10.11_opt/storage/innobase/que/que0que.cc:672
      #7  que_run_threads (thr=<optimized out>) at /test/10.11_opt/storage/innobase/que/que0que.cc:666
      #8  0x00005609314afb1d in fts_eval_sql (trx=trx@entry=0x14a8c574d180, graph=graph@entry=0x14a84c124dd8) at /test/10.11_opt/storage/innobase/fts/fts0sql.cc:163
      #9  0x00005609314a5acc in fts_config_set_value (trx=trx@entry=0x14a8c574d180, fts_table=fts_table@entry=0x14a8a0528bc0, name=name@entry=0x5609318877cb "stopword_table_name", value=value@entry=0x14a8a0528b80) at /test/10.11_opt/storage/innobase/fts/fts0config.cc:253
      #10 0x00005609314a19b5 in fts_load_stopword (table=table@entry=0x14a84c112d58, trx=0x14a8c574d180, trx@entry=0x0, session_stopword_table=session_stopword_table@entry=0x14a84c011308 "test/server_stopword", stopword_is_on=<optimized out>, reload=reload@entry=false) at /test/10.11_opt/storage/innobase/fts/fts0fts.cc:5684
      #11 0x0000560931309507 in innobase_fts_load_stopword (table=table@entry=0x14a84c112d58, trx=trx@entry=0x0, thd=thd@entry=0x14a84c000c68) at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:11390
      #12 0x000056093130aa9d in create_table_info_t::create_table_update_dict (table=0x14a84c112d58, thd=0x14a84c000c68, info=@0x14a8a0529200: {<Table_scope_and_contents_source_st> = {<Table_scope_and_contents_source_pod_st> = {alter_table_convert_to_charset = 0x0, tabledef_version = {str = 0x0, length = 0}, org_tabledef_version = {str = 0x0, length = 0}, connect_string = {str = 0x0, length = 0}, comment = {str = 0x14a84c0fc980 "", length = 0}, alias = {str = 0x0, length = 0}, org_storage_engine_name = {str = 0x0, length = 0}, new_storage_engine_name = {str = 0x0, length = 0}, password = 0x0, tablespace = 0x0, data_file_name = 0x0, index_file_name = 0x0, max_rows = 0, min_rows = 0, auto_increment_value = 0, table_options = 9, avg_row_length = 0, used_fields = 0, key_block_size = 0, expression_length = 0, field_check_constraints = 0, stats_sample_pages = 0, null_bits = 0, options = 0, merge_insert_method = 0, extra_size = 0, db_type = 0x0, row_type = ROW_TYPE_DYNAMIC, transactional = HA_CHOICE_UNDEF, storage_media = HA_SM_DEFAULT, page_checksum = HA_CHOICE_UNDEF, option_list = 0x0, stats_auto_recalc = HA_STATS_AUTO_RECALC_DEFAULT, varchar = false, sequence = false, check_constraint_list = 0x0, option_struct = 0x0, fields_option_struct = 0x0, indexes_option_struct = 0x0, table = 0x0, pos_in_locked_tables = 0x0, merge_list = 0x0, mdl_ticket = 0x0, table_was_deleted = false, seq_create_info = 0x0}, vers_info = {<Table_period_info> = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x560931837acb "SYSTEM_TIME", length = 11}, <No data fields>}, <No data fields>}, period = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, create_if_not_exists = false, constr = 0x0, unique_keys = 0}, as_row = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, versioned_fields = false, unversioned_fields = false}, period_info = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, period = {start = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, end = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}}, create_if_not_exists = false, constr = 0x0, unique_keys = 0}}, <Schema_specification_st> = {default_table_charset = 0x560931f25de0 <my_charset_latin1>, schema_comment = 0x0}, alter_info = 0x0}, t=@0x14a84c10f958: {s = 0x14a84c0fc370, file = 0x14a84c110170, next = 0x0, prev = 0x0, share_all_next = 0x0, share_all_prev = 0x14a84c0fc0a8, global_free_next = 0x0, global_free_prev = 0x0, instance = 0, in_use = 0x14a84c000c68, record = {0x14a84c10fd58 "\377", 0x14a84c10fd60 "x\375\020L\250\024", 0x14a84c10fd60 "x\375\020L\250\024"}, write_row_record = 0x0, insert_values = 0x0, covering_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, intersect_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, keys_in_use_for_query = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, keys_in_use_for_group_by = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, keys_in_use_for_order_by = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, constraint_dependent_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, key_info = 0x14a84c10fe80, field = 0x14a84c10fd68, vfield = 0x0, default_field = 0x0, next_number_field = 0x0, found_next_number_field = 0x0, check_constraints = 0x0, triggers = 0x0, pos_in_table_list = 0x14a84c010828, pos_in_locked_tables = 0x0, internal_tables = 0x0, group = 0x0, alias = {<Charset> = {m_charset = 0x560931f029c0 <my_charset_bin>}, <Binary_string> = {<Sql_alloc> = {<No data fields>}, Ptr = 0x14a84c105388 "t", str_length = 1, Alloced_length = 8, extra_alloc = 0, alloced = true, thread_specific = false}, <No data fields>}, null_flags = 0x14a84c10fd58 "\377", def_read_set = {bitmap = 0x14a84c10ff60, last_word_ptr = 0x14a84c10ff60, last_word_mask = 4294967294, n_bits = 1}, def_write_set = {bitmap = 0x14a84c10ff64, last_word_ptr = 0x14a84c10ff64, last_word_mask = 4294967294, n_bits = 1}, tmp_set = {bitmap = 0x14a84c10ff6c, last_word_ptr = 0x14a84c10ff6c, last_word_mask = 4294967294, n_bits = 1}, def_rpl_write_set = {bitmap = 0x14a84c10ff78, last_word_ptr = 0x14a84c10ff78, last_word_mask = 4294967294, n_bits = 1}, eq_join_set = {bitmap = 0x14a84c10ff70, last_word_ptr = 0x14a84c10ff70, last_word_mask = 4294967294, n_bits = 1}, cond_set = {bitmap = 0x14a84c10ff74, last_word_ptr = 0x14a84c10ff74, last_word_mask = 4294967294, n_bits = 1}, read_set = 0x14a84c10fa88, write_set = 0x14a84c10faa0, rpl_write_set = 0x0, has_value_set = {bitmap = 0x14a84c10ff68, last_word_ptr = 0x14a84c10ff68, last_word_mask = 4294967294, n_bits = 1}, query_id = 5, collected_stats = 0x0, used_stat_records = 0, opt_range_keys = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, opt_range = 0x14a84c10fd78, const_key_parts = 0x14a84c10fd98, opt_range_condition_rows = 0, cond_selectivity = 1, cond_selectivity_sampling_explain = 0x0, map = 0, lock_position = 0, lock_data_start = 0, lock_count = 0, tablenr = 0, used_fields = 0, temp_pool_slot = 0, status = 3, db_stat = 33, derived_select_number = 0, maybe_null = 0, current_lock = 1, copy_blobs = false, next_number_field_updated = false, null_row = false, no_rows_with_nulls = false, null_catch_flags = 0 '\000', force_index = false, force_index_order = false, force_index_group = false, distinct = false, const_table = false, no_rows = false, used_for_duplicate_elimination = false, keep_row_order = false, no_keyread = false, locked_by_logger = false, locked_by_name = false, fulltext_searched = false, no_cache = false, open_by_handler = false, auto_increment_field_not_null = false, insert_or_update = false, alias_name_used = false, get_fields_in_item_tree = false, vcol_refix_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560931fd8770 <end_of_list>, last = 0x14a84c10fbe0, elements = 0}, <No data fields>}, m_needs_reopen = false, created = true, master_had_triggers = false, reginfo = {join_tab = 0x0, lock_type = TL_WRITE, skip_locked = false, not_exists_optimize = false, impossible_range = false}, mem_root = {free = 0x14a84c10fd38, used = 0x14a84c110158, pre_alloc = 0x0, min_malloc = 32, block_size = 1016, block_num = 6, first_block_usage = 0, flags = 0, error_handler = 0x560930f30d80 <sql_alloc_error_handler()>, psi_key = 0}, blob_storage = 0x0, grant = {grant_table_user = 0x0, grant_table_role = 0x0, grant_public = 0x0, version = 0, privilege = (SELECT_ACL | INSERT_ACL | UPDATE_ACL | DELETE_ACL | CREATE_ACL | DROP_ACL | RELOAD_ACL | SHUTDOWN_ACL | PROCESS_ACL | FILE_ACL | GRANT_ACL | REFERENCES_ACL | INDEX_ACL | ALTER_ACL | SHOW_DB_ACL | SUPER_ACL | CREATE_TMP_ACL | LOCK_TABLES_ACL | EXECUTE_ACL | REPL_SLAVE_ACL | BINLOG_MONITOR_ACL | CREATE_VIEW_ACL | SHOW_VIEW_ACL | CREATE_PROC_ACL | ALTER_PROC_ACL | CREATE_USER_ACL | EVENT_ACL | TRIGGER_ACL | CREATE_TABLESPACE_ACL | DELETE_HISTORY_ACL | SET_USER_ACL | FEDERATED_ADMIN_ACL | CONNECTION_ADMIN_ACL | READ_ONLY_ADMIN_ACL | REPL_SLAVE_ADMIN_ACL | REPL_MASTER_ADMIN_ACL | BINLOG_ADMIN_ACL | BINLOG_REPLAY_ACL | SLAVE_MONITOR_ACL), want_privilege = NO_ACL, orig_want_privilege = DROP_ACL, m_internal = {m_schema_lookup_done = true, m_schema_access = 0x0, m_table_lookup_done = true, m_table_access = 0x0}}, expr_arena = 0x0, part_info = 0x0, all_partitions_pruned_away = false, max_keys = 0, stats_is_read = false, histograms_are_read = false, mdl_ticket = 0x14a84c019f40, spl_opt_info = 0x0, keys_usable_for_splitting = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, notnull_cond = 0x0, with_impossible_ranges = {static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, buffer = {0}}, range_rowid_filter_cost_info_elems = 0, range_rowid_filter_cost_info = 0x0, range_rowid_filter_cost_info_ptr = 0x0, vers_write = false}) at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:13047
      #13 0x000056093131e754 in ha_innobase::truncate (this=0x14a84c110170) at /test/10.11_opt/storage/innobase/handler/ha_innodb.cc:13887
      #14 0x0000560930f73cdb in Sql_cmd_truncate_table::handler_truncate (this=<optimized out>, thd=0x14a84c000c68, table_ref=0x14a84c010828, is_tmp_table=<optimized out>) at /test/10.11_opt/sql/sql_truncate.cc:255
      #15 0x0000560930f749c0 in Sql_cmd_truncate_table::truncate_table (this=0x14a84c010f48, thd=0x14a84c000c68, table_ref=0x14a84c010828) at /test/10.11_opt/sql/sql_truncate.cc:507
      #16 0x0000560930f74c0e in Sql_cmd_truncate_table::execute (this=0x14a84c010f48, thd=0x14a84c000c68) at /test/10.11_opt/sql/sql_truncate.cc:573
      #17 0x0000560930e3e2ff in mysql_execute_command (thd=0x14a84c000c68, is_called_from_prepared_stmt=<optimized out>) at /test/10.11_opt/sql/sql_parse.cc:6001
      #18 0x0000560930e3f5c4 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x14a84c000c68) at /test/10.11_opt/sql/sql_parse.cc:8000
      #19 mysql_parse (thd=0x14a84c000c68, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.11_opt/sql/sql_parse.cc:7922
      #20 0x0000560930e41ba2 in dispatch_command (command=COM_QUERY, thd=0x14a84c000c68, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/10.11_opt/sql/sql_parse.cc:1991
      #21 0x0000560930e43340 in do_command (thd=0x14a84c000c68, blocking=blocking@entry=true) at /test/10.11_opt/sql/sql_parse.cc:1407
      #22 0x0000560930f58f77 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x560932fc0628, put_in_cache=put_in_cache@entry=true) at /test/10.11_opt/sql/sql_connect.cc:1416
      #23 0x0000560930f5924d in handle_one_connection (arg=0x560932fc0628) at /test/10.11_opt/sql/sql_connect.cc:1318
      #24 0x000014a8ce01db43 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #25 0x000014a8ce0afa00 in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Bug confirmed present in:
      MariaDB: 10.6.12 (dbg), 10.6.12 (opt), 10.7.8 (dbg), 10.7.8 (opt), 10.8.7 (dbg), 10.8.7 (opt), 10.9.5 (dbg), 10.9.5 (opt), 10.10.3 (dbg), 10.10.3 (opt), 10.11.2 (dbg), 10.11.2 (opt)

      Bug (or feature/syntax) confirmed not present in:
      MariaDB: 10.3.38 (dbg), 10.3.38 (opt), 10.4.28 (dbg), 10.4.28 (opt), 10.5.19 (dbg), 10.5.19 (opt)
      MySQL: 5.5.62 (dbg), 5.5.62 (opt), 5.6.51 (dbg), 5.6.51 (opt), 5.7.40 (dbg), 5.7.40 (opt), 8.0.31 (dbg), 8.0.31 (opt)

      Attachments

        Activity

          While fixing this, please also have a look into this separate issue:

          10.11.8 64314d3094ef5eb52223c613632292be96bd7732 (Debug)

          2024-05-09 13:38:35 8 [ERROR] InnoDB: preallocating 79691776 bytes for file ./ibdata1 failed with error 28
          2024-05-09 13:38:35 8 [Warning] InnoDB: Failed to create FTS index table test/FTS_0000000000000061_0000000000000082_INDEX_2
          2024-05-09 13:38:35 8 [ERROR] InnoDB: preallocating 79691776 bytes for file ./ibdata1 failed with error 28
          2024-05-09 13:38:35 8 [Warning] InnoDB: Failed to create FTS index table test/FTS_0000000000000064_000000000000008c_INDEX_1
          mariadbd: /test/10.11_dbg/storage/innobase/trx/trx0trx.cc:381: void trx_t::free(): Assertion `error_state == DB_SUCCESS' failed.
          

          i.e. the assert may fire when there is a OOS. Perhaps the assert can be improved or the OOS situation handled better?

          Roel Roel Van de Paar added a comment - While fixing this, please also have a look into this separate issue: 10.11.8 64314d3094ef5eb52223c613632292be96bd7732 (Debug) 2024-05-09 13:38:35 8 [ERROR] InnoDB: preallocating 79691776 bytes for file ./ibdata1 failed with error 28 2024-05-09 13:38:35 8 [Warning] InnoDB: Failed to create FTS index table test/FTS_0000000000000061_0000000000000082_INDEX_2 2024-05-09 13:38:35 8 [ERROR] InnoDB: preallocating 79691776 bytes for file ./ibdata1 failed with error 28 2024-05-09 13:38:35 8 [Warning] InnoDB: Failed to create FTS index table test/FTS_0000000000000064_000000000000008c_INDEX_1 mariadbd: /test/10.11_dbg/storage/innobase/trx/trx0trx.cc:381: void trx_t::free(): Assertion `error_state == DB_SUCCESS' failed. i.e. the assert may fire when there is a OOS. Perhaps the assert can be improved or the OOS situation handled better?
          Roel Roel Van de Paar added a comment - - edited

          Please also test with this testcase:

          CREATE TABLE server_stopword (value VARCHAR(30)) ENGINE=InnoDB;
          CREATE TEMPORARY TABLE t1 (i INT) ENGINE=InnoDB;
          CREATE TABLE t1 (a VARCHAR(255), FULLTEXT (a)) ENGINE=InnoDB;
          SET GLOBAL innodb_ft_server_stopword_table="test/server_stopword";
          DROP TABLE t1;
          TRUNCATE t1;
          

          Roel Roel Van de Paar added a comment - - edited Please also test with this testcase: CREATE TABLE server_stopword (value VARCHAR (30)) ENGINE=InnoDB; CREATE TEMPORARY TABLE t1 (i INT ) ENGINE=InnoDB; CREATE TABLE t1 (a VARCHAR (255), FULLTEXT (a)) ENGINE=InnoDB; SET GLOBAL innodb_ft_server_stopword_table= "test/server_stopword" ; DROP TABLE t1; TRUNCATE t1;
          ramesh Ramesh Sivaraman added a comment - - edited

          Latest 10.11 debug build crashes with different assertion, on release build truncate table statement goes to hang mode

          --source include/have_innodb.inc
           
          CREATE TABLE t1 (value VARCHAR(1)) ENGINE=INNODB;
          CREATE TABLE t2 (f TEXT,FULLTEXT (f)) ENGINE=INNODB;
          SET GLOBAL innodb_ft_server_stopword_table='test/t1';
          TRUNCATE TABLE t2;
          

          Leads to

          CS 10.11.12 6e6a1b316ca8df5116613fbe4ca2dc37b3c73bd1 (Debug) Build 03/03/2025

          mariadbd: /test/10.11_dbg/storage/innobase/sync/srw_lock.cc:696: void srw_lock_debug::rd_lock(): Assertion `!have_any()' failed.
          

          CS 10.11.12 6e6a1b316ca8df5116613fbe4ca2dc37b3c73bd1 (Debug) Build 03/03/2025

          Core was generated by `/test/MD030325-mariadb-10.11.12-linux-x86_64-dbg/bin/mariadbd --no-defaults --m'.
          Program terminated with signal SIGABRT, Aborted.
          #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
           
          [Current thread is 1 (Thread 0x147ec40606c0 (LWP 889338))]
          (gdb) bt
          #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  0x0000147ec604527e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26
          #4  0x0000147ec60288ff in __GI_abort () at ./stdlib/abort.c:79
          #5  0x0000147ec602881b in __assert_fail_base (fmt=0x147ec61d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5629b16d41c9 "!have_any()", 
              file=file@entry=0x5629b16d3f4b "/test/10.11_dbg/storage/innobase/sync/srw_lock.cc", line=line@entry=696, function=function@entry=0x5629b16d427a "void srw_lock_debug::rd_lock()") at ./assert/assert.c:96
          #6  0x0000147ec603b517 in __assert_fail (assertion=0x5629b16d41c9 "!have_any()", file=0x5629b16d3f4b "/test/10.11_dbg/storage/innobase/sync/srw_lock.cc", line=696, 
              function=0x5629b16d427a "void srw_lock_debug::rd_lock()") at ./assert/assert.c:105
          #7  0x00005629b104bef6 in srw_lock_debug::rd_lock (this=0x5629b1f1a240 <dict_sys+64>) at /test/10.11_dbg/storage/innobase/sync/srw_lock.cc:696
          #8  0x00005629b0dd8809 in dict_sys_t::freeze (this=0x5629b1f1a200 <dict_sys>) at include/dict0dict.h:1479
          #9  0x00005629b11635e5 in dict_table_open_on_id (table_id=34, dict_locked=false, table_op=DICT_TABLE_OP_NORMAL, thd=0x0, mdl=0x0) at /test/10.11_dbg/storage/innobase/dict/dict0dict.cc:820
          #10 0x00005629b1239983 in row_undo_ins_parse_undo_rec (node=0x147e7406a1e0, dict_locked=false) at /test/10.11_dbg/storage/innobase/row/row0uins.cc:399
          #11 0x00005629b12392e4 in row_undo_ins (node=0x147e7406a1e0, thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/row/row0uins.cc:578
          #12 0x00005629b101e810 in row_undo (node=0x147e7406a1e0, thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/row/row0undo.cc:401
          #13 0x00005629b101e4ec in row_undo_step (thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/row/row0undo.cc:442
          #14 0x00005629b0f47a3d in que_thr_step (thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/que/que0que.cc:551
          #15 0x00005629b0f47043 in que_run_threads_low (thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/que/que0que.cc:609
          #16 0x00005629b0f46df4 in que_run_threads (thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/que/que0que.cc:629
          #17 0x00005629b1074c8f in trx_t::rollback_low (this=0x147eb9002180, savept=0x0) at /test/10.11_dbg/storage/innobase/trx/trx0roll.cc:116
          #18 0x00005629b107562e in trx_t::rollback (this=0x147eb9002180, savept=0x0) at /test/10.11_dbg/storage/innobase/trx/trx0roll.cc:179
          #19 0x00005629b11f2b97 in fts_load_stopword (table=0x147e740544f0, trx=0x147eb9002180, session_stopword_table=0x147e74014068 "test/t1", stopword_is_on=true, reload=false)
              at /test/10.11_dbg/storage/innobase/fts/fts0fts.cc:5937
          #20 0x00005629b0dadf9e in innobase_fts_load_stopword (table=0x147e740544f0, trx=0x0, thd=0x147e74000d58) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:11571
          #21 0x00005629b0db3c61 in create_table_info_t::create_table_update_dict (table=0x147e740544f0, thd=0x147e74000d58, info=..., t=...) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:13298
          #22 0x00005629b0db79e7 in ha_innobase::truncate (this=0x147e7404fae8) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:14163
          #23 0x00005629b09ec841 in handler::ha_truncate (this=0x147e7404fae8) at /test/10.11_dbg/sql/handler.cc:5224
          #24 0x00005629b0810034 in Sql_cmd_truncate_table::handler_truncate (this=0x147e74013ca8, thd=0x147e74000d58, table_ref=0x147e74013590, is_tmp_table=false) at /test/10.11_dbg/sql/sql_truncate.cc:255
          #25 0x00005629b0810ec7 in Sql_cmd_truncate_table::truncate_table (this=0x147e74013ca8, thd=0x147e74000d58, table_ref=0x147e74013590) at /test/10.11_dbg/sql/sql_truncate.cc:532
          #26 0x00005629b08110e1 in Sql_cmd_truncate_table::execute (this=0x147e74013ca8, thd=0x147e74000d58) at /test/10.11_dbg/sql/sql_truncate.cc:598
          #27 0x00005629b06106c0 in mysql_execute_command (thd=0x147e74000d58, is_called_from_prepared_stmt=false) at /test/10.11_dbg/sql/sql_parse.cc:6167
          #28 0x00005629b05fe414 in mysql_parse (thd=0x147e74000d58, rawbuf=0x147e740134d0 "TRUNCATE TABLE t2", length=17, parser_state=0x147ec405ea30) at /test/10.11_dbg/sql/sql_parse.cc:8188
          #29 0x00005629b05fb8d4 in dispatch_command (command=COM_QUERY, thd=0x147e74000d58, packet=0x147e7400af59 "TRUNCATE TABLE t2", packet_length=17, blocking=true) at /test/10.11_dbg/sql/sql_parse.cc:1905
          #30 0x00005629b05fefc3 in do_command (thd=0x147e74000d58, blocking=true) at /test/10.11_dbg/sql/sql_parse.cc:1418
          #31 0x00005629b07d9a99 in do_handle_one_connection (connect=0x5629b75ca238, put_in_cache=true) at /test/10.11_dbg/sql/sql_connect.cc:1386
          #32 0x00005629b07d9832 in handle_one_connection (arg=0x5629b7604638) at /test/10.11_dbg/sql/sql_connect.cc:1298
          #33 0x0000147ec609caa4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447
          #34 0x0000147ec6129c3c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
          (gdb) 
          

          ramesh Ramesh Sivaraman added a comment - - edited Latest 10.11 debug build crashes with different assertion, on release build truncate table statement goes to hang mode --source include/have_innodb.inc   CREATE TABLE t1 (value VARCHAR (1)) ENGINE=INNODB; CREATE TABLE t2 (f TEXT,FULLTEXT (f)) ENGINE=INNODB; SET GLOBAL innodb_ft_server_stopword_table= 'test/t1' ; TRUNCATE TABLE t2; Leads to CS 10.11.12 6e6a1b316ca8df5116613fbe4ca2dc37b3c73bd1 (Debug) Build 03/03/2025 mariadbd: /test/10.11_dbg/storage/innobase/sync/srw_lock.cc:696: void srw_lock_debug::rd_lock(): Assertion `!have_any()' failed. CS 10.11.12 6e6a1b316ca8df5116613fbe4ca2dc37b3c73bd1 (Debug) Build 03/03/2025 Core was generated by `/test/MD030325-mariadb-10.11.12-linux-x86_64-dbg/bin/mariadbd --no-defaults --m'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44   [Current thread is 1 (Thread 0x147ec40606c0 (LWP 889338))] (gdb) bt #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 0x0000147ec604527e in __GI_raise (sig=sig@entry=6) at ../sysdeps/posix/raise.c:26 #4 0x0000147ec60288ff in __GI_abort () at ./stdlib/abort.c:79 #5 0x0000147ec602881b in __assert_fail_base (fmt=0x147ec61d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5629b16d41c9 "!have_any()", file=file@entry=0x5629b16d3f4b "/test/10.11_dbg/storage/innobase/sync/srw_lock.cc", line=line@entry=696, function=function@entry=0x5629b16d427a "void srw_lock_debug::rd_lock()") at ./assert/assert.c:96 #6 0x0000147ec603b517 in __assert_fail (assertion=0x5629b16d41c9 "!have_any()", file=0x5629b16d3f4b "/test/10.11_dbg/storage/innobase/sync/srw_lock.cc", line=696, function=0x5629b16d427a "void srw_lock_debug::rd_lock()") at ./assert/assert.c:105 #7 0x00005629b104bef6 in srw_lock_debug::rd_lock (this=0x5629b1f1a240 <dict_sys+64>) at /test/10.11_dbg/storage/innobase/sync/srw_lock.cc:696 #8 0x00005629b0dd8809 in dict_sys_t::freeze (this=0x5629b1f1a200 <dict_sys>) at include/dict0dict.h:1479 #9 0x00005629b11635e5 in dict_table_open_on_id (table_id=34, dict_locked=false, table_op=DICT_TABLE_OP_NORMAL, thd=0x0, mdl=0x0) at /test/10.11_dbg/storage/innobase/dict/dict0dict.cc:820 #10 0x00005629b1239983 in row_undo_ins_parse_undo_rec (node=0x147e7406a1e0, dict_locked=false) at /test/10.11_dbg/storage/innobase/row/row0uins.cc:399 #11 0x00005629b12392e4 in row_undo_ins (node=0x147e7406a1e0, thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/row/row0uins.cc:578 #12 0x00005629b101e810 in row_undo (node=0x147e7406a1e0, thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/row/row0undo.cc:401 #13 0x00005629b101e4ec in row_undo_step (thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/row/row0undo.cc:442 #14 0x00005629b0f47a3d in que_thr_step (thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/que/que0que.cc:551 #15 0x00005629b0f47043 in que_run_threads_low (thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/que/que0que.cc:609 #16 0x00005629b0f46df4 in que_run_threads (thr=0x147e740638b0) at /test/10.11_dbg/storage/innobase/que/que0que.cc:629 #17 0x00005629b1074c8f in trx_t::rollback_low (this=0x147eb9002180, savept=0x0) at /test/10.11_dbg/storage/innobase/trx/trx0roll.cc:116 #18 0x00005629b107562e in trx_t::rollback (this=0x147eb9002180, savept=0x0) at /test/10.11_dbg/storage/innobase/trx/trx0roll.cc:179 #19 0x00005629b11f2b97 in fts_load_stopword (table=0x147e740544f0, trx=0x147eb9002180, session_stopword_table=0x147e74014068 "test/t1", stopword_is_on=true, reload=false) at /test/10.11_dbg/storage/innobase/fts/fts0fts.cc:5937 #20 0x00005629b0dadf9e in innobase_fts_load_stopword (table=0x147e740544f0, trx=0x0, thd=0x147e74000d58) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:11571 #21 0x00005629b0db3c61 in create_table_info_t::create_table_update_dict (table=0x147e740544f0, thd=0x147e74000d58, info=..., t=...) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:13298 #22 0x00005629b0db79e7 in ha_innobase::truncate (this=0x147e7404fae8) at /test/10.11_dbg/storage/innobase/handler/ha_innodb.cc:14163 #23 0x00005629b09ec841 in handler::ha_truncate (this=0x147e7404fae8) at /test/10.11_dbg/sql/handler.cc:5224 #24 0x00005629b0810034 in Sql_cmd_truncate_table::handler_truncate (this=0x147e74013ca8, thd=0x147e74000d58, table_ref=0x147e74013590, is_tmp_table=false) at /test/10.11_dbg/sql/sql_truncate.cc:255 #25 0x00005629b0810ec7 in Sql_cmd_truncate_table::truncate_table (this=0x147e74013ca8, thd=0x147e74000d58, table_ref=0x147e74013590) at /test/10.11_dbg/sql/sql_truncate.cc:532 #26 0x00005629b08110e1 in Sql_cmd_truncate_table::execute (this=0x147e74013ca8, thd=0x147e74000d58) at /test/10.11_dbg/sql/sql_truncate.cc:598 #27 0x00005629b06106c0 in mysql_execute_command (thd=0x147e74000d58, is_called_from_prepared_stmt=false) at /test/10.11_dbg/sql/sql_parse.cc:6167 #28 0x00005629b05fe414 in mysql_parse (thd=0x147e74000d58, rawbuf=0x147e740134d0 "TRUNCATE TABLE t2", length=17, parser_state=0x147ec405ea30) at /test/10.11_dbg/sql/sql_parse.cc:8188 #29 0x00005629b05fb8d4 in dispatch_command (command=COM_QUERY, thd=0x147e74000d58, packet=0x147e7400af59 "TRUNCATE TABLE t2", packet_length=17, blocking=true) at /test/10.11_dbg/sql/sql_parse.cc:1905 #30 0x00005629b05fefc3 in do_command (thd=0x147e74000d58, blocking=true) at /test/10.11_dbg/sql/sql_parse.cc:1418 #31 0x00005629b07d9a99 in do_handle_one_connection (connect=0x5629b75ca238, put_in_cache=true) at /test/10.11_dbg/sql/sql_connect.cc:1386 #32 0x00005629b07d9832 in handle_one_connection (arg=0x5629b7604638) at /test/10.11_dbg/sql/sql_connect.cc:1298 #33 0x0000147ec609caa4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:447 #34 0x0000147ec6129c3c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78 (gdb)

          People

            thiru Thirunarayanan Balathandayuthapani
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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