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

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

    XMLWordPrintable

Details

    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

          People

            thiru Thirunarayanan Balathandayuthapani
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.