[MDEV-29066] Server crash with SIGFPE in spider_db_set_cardinarity - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Minor
Resolution: Unresolved
Affects Version/s: 10.4
Fix Version/s: 10.4
Component/s: Storage Engine - Spider
Labels:
- not-10.10
- not-10.5
- not-10.6
- not-10.7
- not-10.8
- not-10.9

Description

Set to minor because I can only reproduce it on 10.4. If the problem doesn't exist in higher versions, it might be not worth fixing.

--source plugin/spider/spider/include/init_spider.inc

SET spider_same_server_link= on;

eval create server s foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port $MASTER_MYPORT);

CREATE TABLE t (a INT);

CREATE TABLE t_spider (a INT) ENGINE=SPIDER COMMENT = "wrapper 'mysql', srv 's', table 't'";

SHOW INDEXES FROM t_spider;

ALTER TABLE t ADD COLUMN b INT, ADD KEY(b);

ALTER TABLE t_spider ADD COLUMN b INT, ADD KEY(b);

SHOW INDEXES FROM t_spider;

# Cleanup

DROP TABLE t_spider, t;

--source plugin/spider/spider/include/deinit_spider.inc

10.4 9a0cbd31
#2 0x000056095393b5a1 in handle_fatal_signal (sig=8) at /data/src/10.4/sql/signal_handler.cc:366
curr_time = 1657310656
tm = {tm_sec = 16, tm_min = 4, tm_hour = 23, tm_mday = 8, tm_mon = 6, tm_year = 122, tm_wday = 5, tm_yday = 188, tm_isdst = 1, tm_gmtoff = 10800, tm_zone = 0x56095648a930 "EEST"}
thd = 0x7f63a4000d90
print_invalid_query_pointer = false
#3 <signal handler called>
No locals.
#4 0x00007f63b497273b in spider_db_set_cardinarity (spider=0x7f63a41f7d48, table=0x7f63a41f8f80) at /data/src/10.4/storage/spider/spd_db_conn.cc:6029
roop_count = 0
roop_count2 = 0
share = 0x7f63a41edb60
key_info = 0x7f63a423f990
key_part = 0x7f63a423fa48
field = 0x7f63a423f8b8
rec_per_key = 140065932314944
_db_stack_frame_ = {func = 0x7f63b4aa85a2 "ha_spider::info", file = 0x7f63b4aa7100 "/data/src/10.4/storage/spider/ha_spider.cc", level = 2147483661, line = -1, prev = 0x7f63b4b30c20}
#5 0x00007f63b4a182dd in ha_spider::info (this=0x7f63a41f7d48, flag=30) at /data/src/10.4/storage/spider/ha_spider.cc:9009
tmp_time = 1657310656
tmp_auto_increment_mode = 0
error_num = 0
thd = 0x7f63a4000d90
sts_interval = 10
sts_mode = 1
sts_sync = 0
sts_bg_mode = 2
spider_init_error_table = 0x0
_db_stack_frame_ = {func = 0x560954311823 "get_schema_stat_record", file = 0x56095430f7e0 "/data/src/10.4/sql/sql_show.cc", level = 2147483660, line = -1, prev = 0x7f63b4b30d10}
#6 0x00005609536c21db in get_schema_stat_record (thd=0x7f63a4000d90, tables=0x7f63a41dacb8, table=0x7f63a41e1fd8, res=false, db_name=0x7f63a4014d28, table_name=0x7f63a4014d38) at /data/src/10.4/sql/sql_show.cc:6760
show_table = 0x7f63a41f8f80
key_info = 0x7f63a41e0140
cs = 0x560954d861a0 <my_charset_utf8_general_ci>
_db_stack_frame_ = {func = 0x560954311012 "fill_schema_table_by_open", file = 0x56095430f7e0 "/data/src/10.4/sql/sql_show.cc", level = 2147483659, line = -1, prev = 0x7f63b4b30e30}
__PRETTY_FUNCTION__ = "int get_schema_stat_record(THD, TABLE_LIST, TABLE, bool, const LEX_CSTRING, const LEX_CSTRING*)"
#7 0x00005609536b93a8 in fill_schema_table_by_open (thd=0x7f63a4000d90, mem_root=0x7f63a4006768, is_show_fields_or_keys=true, table=0x7f63a41e1fd8, schema_table=0x560954baca60 <schema_tables+1984>, orig_db_name=0x7f63a4014d28, orig_table_name=0x7f63a4014d38, open_tables_state_backup=0x7f63b4b32bb0, can_deadlock=false) at /data/src/10.4/sql/sql_show.cc:4744
buf = "\364\000\036\244c\177\000\000\000\000\000\000\000\000\000\000\374\377\377\377\002\000\000\000\000\001\036\244c\177\000\000\000\001\036\244c\177\000\000\000\000\000\000\000\000\000\000\374\377\377\377\002\000\000\000\370\000\036\244c\177\000\000\370"
i_s_arena = {_vptr.Query_arena = 0x560954a767e8 <vtable for Query_arena+16>, free_list = 0x0, mem_root = 0x7f63a4006768, is_backup_arena = false, is_reprepared = false, state = Query_arena::STMT_CONVENTIONAL_EXECUTION}
backup_arena = {_vptr.Query_arena = 0x560954a767e8 <vtable for Query_arena+16>, free_list = 0x7f63a4017660, mem_root = 0x7f63a4006768, is_backup_arena = true, is_reprepared = false, state = Query_arena::STMT_CONVENTIONAL_EXECUTION}
old_arena = 0x7f63a4000da8
old_lex = 0x7f63a4004c00
temp_lex = {<Query_tables_list> = {sql_command = SQLCOM_SHOW_KEYS, query_tables = 0x7f63a41dacb8, query_tables_last = 0x7f63a41dacc0, query_tables_own_last = 0x0, sroutines = {key_offset = 0, key_length = 0, blength = 0, records = 0, flags = 0, array = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0, malloc_flags = 0}, get_key = 0x0, hash_function = 0x0, free = 0x0, charset = 0x0}, sroutines_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b30f38}, sroutines_list_own_last = 0x7f63b4b30f38, sroutines_list_own_elements = 0, table_count = 0, binlog_stmt_flags = 0, stmt_accessed_table_flag = 0}, _vptr.LEX = 0x560954a73680 <vtable for LEX+16>, unit = {<st_select_lex_node> = {next = 0x0, prev = 0x0, master = 0x0, slave = 0x7f63b4b31768, link_next = 0x0, link_prev = 0x0, options = 0, uncacheable = 0 '\000', linkage = GLOBAL_OPTIONS_TYPE, distinct = true, no_table_names_allowed = false}, result_table_list = {next_local = 0x0, next_global = 0x0, prev_global = 0x0, db = {str = 0x0, length = 0}, table_name = {str = 0x0, length = 0}, schema_table_name = {str = 0x0, length = 0}, alias = {str = 0x0, length = 0}, option = 0x0, on_expr = 0x0, on_context = 0x0, sj_on_expr = 0x0, sj_inner_tables = 0, sj_in_exprs = 0, sj_subq_pred = 0x0, original_subq_pred_used_tables = 0, jtbm_subselect = 0x0, jtbm_table_no = 0, sj_mat_info = 0x0, prep_on_expr = 0x0, cond_equal = 0x0, natural_join = 0x0, is_natural_join = false, join_using_fields = 0x0, join_columns = 0x0, is_join_columns_complete = false, next_name_resolution_table = 0x0, index_hints = 0x0, table = 0x0, table_id = 0, derived_result = 0x0, map = 0, correspondent_table = 0x0, derived = 0x0, with = 0x0, with_internal_reference_map = 0, next_with_rec_ref = 0x0, is_derived_with_recursive_reference = false, block_handle_derived = false, dt_handler = 0x0, derived_spec = {str = 0x0, length = 0}, pushdown_derived = 0x0, schema_table = 0x0, schema_select_lex = 0x0, schema_table_reformed = false, schema_table_param = 0x0, select_lex = 0x0, view = 0x0, field_translation = 0x0, field_translation_end = 0x0, field_translation_updated = false, merge_underlying_list = 0x0, view_tables = 0x0, belong_to_view = 0x0, belong_to_derived = 0x0, referencing_view = 0x0, view_used_tables = 0, map_exec = 0, tablenr_exec = 0, maybe_null_exec = 0, parent_l = 0x0, security_ctx = 0x0, view_sctx = 0x0, allowed_show = false, where = 0x0, check_option = 0x0, select_stmt = {str = 0x0, length = 0}, md5 = {str = 0x0, length = 0}, source = {str = 0x0, length = 0}, view_db = {str = 0x0, length = 0}, view_name = {str = 0x0, length = 0}, timestamp = {str = 0x0, length = 0}, definer = {<AUTHID> = {user = {str = 0x0, length = 0}, host = {str = 0x0, length = 0}}, auth = 0x0}, file_version = 0, mariadb_version = 0, updatable_view = 0, algorithm = 0, view_suid = 0, with_check = 0, effective_with_check = 0 '\000', derived_type = 0 '\000', grant = {grant_table_user = 0x0, grant_table_role = 0x0, version = 0, privilege = 0, want_privilege = 0, orig_want_privilege = 0, m_internal = {m_schema_lookup_done = false, m_schema_access = 0x0, m_table_lookup_done = false, m_table_access = 0x0}}, engine_data = 0, callback_func = 0x0, lock_type = TL_UNLOCK, mdl_type = MDL_INTENTION_EXCLUSIVE, table_options = 0, outer_join = 0, shared = 0, updatable = false, straight = false, updating = false, force_index = false, ignore_leaves = false, crashed = false, dep_tables = 0, on_expr_dep_tables = 0, nested_join = 0x0, embedding = 0x0, join_list = 0x0, lifted = false, cacheable_table = false, table_in_first_from_clause = false, open_type = OT_TEMPORARY_OR_BASE, contain_auto_increment = false, compact_view_format = false, where_processed = false, check_option_processed = false, required_type = TABLE_TYPE_UNKNOWN, db_type = 0x0, timestamp_buffer = '\000' <repeats 19 times>, prelocking_placeholder = TABLE_LIST::PRELOCK_NONE, open_strategy = TABLE_LIST::OPEN_NORMAL, is_alias = false, is_fqtn = false, fill_me = false, merged = false, merged_for_insert = false, sequence = false, used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31370, elements = 0}, <No data fields>}, persistent_used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31388, elements = 0}, <No data fields>}, view_creation_ctx = 0x0, view_client_cs_name = {str = 0x0, length = 0}, view_connection_cl_name = {str = 0x0, length = 0}, view_body_utf8 = {str = 0x0, length = 0}, trg_event_map = 0 '\000', slave_fk_event_map = 0 '\000', optimized_away = false, materialized = false, i_s_requested_object = 0, prohibit_cond_pushdown = false, table_open_method = 0, schema_table_state = NOT_PROCESSED, is_table_read_plan = 0x0, mdl_request = {type = MDL_NOT_INITIALIZED, duration = MDL_STATEMENT, next_in_list = 0x0, prev_in_list = 0x0, ticket = 0x0, key = {m_length = 0, m_db_name_length = 0, m_hash_value = 0, m_ptr = '\000' <repeats 386 times>}}, partition_names = 0x0, vers_conditions = {type = SYSTEM_TIME_UNSPECIFIED, orig_type = SYSTEM_TIME_UNSPECIFIED, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x0, field_end = 0x0, period = 0x0}, period_conditions = {type = SYSTEM_TIME_UNSPECIFIED, orig_type = SYSTEM_TIME_UNSPECIFIED, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x0, field_end = 0x0, period = 0x0}, for_insert_data = 0 '\000', m_table_ref_type = TABLE_REF_NULL, m_table_ref_version = 0}, union_result = 0x0, found_rows_for_union = 0, saved_error = false, table = 0x0, result = 0x0, pre_last_parse = 0x0, prepared = false, optimized = false, optimized_2 = false, executed = false, cleaned = false, optimize_started = false, item_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b316a8, elements = 0}, <No data fields>}, types = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b316c0, elements = 0}, <No data fields>}, intersect_mark = 0x0, with_wrapped_tvc = false, return_to = 0x0, select_limit_cnt = 18446744073709551615, offset_limit_cnt = 0, item = 0x0, derived = 0x0, is_view = false, with_clause = 0x0, with_element = 0x0, cloned_from = 0x0, thd = 0x7f63a4000d90, fake_select_lex = 0x0, saved_fake_select_lex = 0x0, union_distinct = 0x0, describe = false, last_procedure = 0x0, columns_are_renamed = false}, builtin_select = {<st_select_lex_node> = {next = 0x0, prev = 0x7f63b4b30f78, master = 0x7f63b4b30f60, slave = 0x0, link_next = 0x0, link_prev = 0x7f63b4b31be8, options = 0, uncacheable = 0 '\000', linkage = UNSPECIFIED_TYPE, distinct = true, no_table_names_allowed = false}, first_nested = 0x0, context = {<Sql_alloc> = {<No data fields>}, outer_context = 0x0, table_list = 0x0, first_name_resolution_table = 0x0, last_name_resolution_table = 0x0, natural_join_first_table = 0x0, select_lex = 0x7f63b4b31768, error_processor = 0x56095397cb39 <dummy_error_processor(THD, void)>, error_processor_data = 0x0, resolve_in_select_list = false, security_ctx = 0x0}, db = {str = 0x0, length = 0}, where = 0x0, having = 0x0, prep_where = 0x0, prep_having = 0x0, cond_pushed_into_where = 0x0, cond_pushed_into_having = 0x0, attach_to_conds = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31848, elements = 0}, <No data fields>}, cond_value = Item::COND_UNDEF, having_value = Item::COND_UNDEF, parent_lex = 0x7f63b4b30ea0, olap = UNSPECIFIED_OLAP_TYPE, table_list = {<Sql_alloc> = {<No data fields>}, elements = 1, first = 0x7f63a41dacb8, next = 0x7f63a41dacb8}, group_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b31898}, group_list_ptrs = 0x0, item_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b318b0, elements = 0}, <No data fields>}, pre_fix = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b318c8, elements = 0}, <No data fields>}, is_item_list_lookup = false, ftfunc_list = 0x7f63b4b318f0, ftfunc_list_alloc = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b318f0, elements = 0}, <No data fields>}, min_max_opt_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31908, elements = 0}, <No data fields>}, join = 0x0, top_join_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31928, elements = 0}, <No data fields>}, join_list = 0x7f63b4b31928, embedding = 0x0, sj_nests = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31950, elements = 0}, <No data fields>}, sj_subselects = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31968, elements = 0}, <No data fields>}, in_funcs = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31980, elements = 0}, <No data fields>}, curr_tvc_name = 0, have_merged_subqueries = false, leaf_tables = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b319a0, elements = 0}, <No data fields>}, leaf_tables_exec = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b319b8, elements = 0}, <No data fields>}, leaf_tables_prep = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b319d0, elements = 0}, <No data fields>}, prep_leaf_list_state = st_select_lex::UNINIT, insert_tables = 22025, merged_into = 0x560954322d36, type = 0x0, order_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b31a08}, gorder_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b31a20}, select_limit = 0x0, offset_limit = 0x0, is_set_query_expr_tail = false, ref_pointer_array = {m_array = 0x0, m_size = 0}, select_n_having_items = 0, cond_count = 0, between_count = 0, max_equal_elems = 0, select_n_where_fields = 0, select_n_reserved = 0, hidden_bit_fields = 0, fields_in_window_functions = 0, parsing_place = NO_MATTER, save_parsing_place = NO_MATTER, context_analysis_place = NO_MATTER, with_sum_func = false, table_join_options = 0, in_sum_expr = 0, select_number = 1, nest_level_base = 0x7f63b4b30f60, nest_level = 0, inner_sum_func_list = 0x0, with_wild = 0, braces = false, automatic_brackets = false, having_fix_field = false, having_fix_field_for_pushed_cond = false, inner_refs_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31ab8, elements = 0}, <No data fields>}, n_sum_items = 0, n_child_sum_items = 0, explicit_limit = false, expr_cache_may_be_used = {false <repeats 12 times>}, subquery_in_having = false, with_all_modifier = false, is_correlated = false, changed_elements = 0 '\000', first_natural_join_processing = true, first_cond_optimization = true, no_wrap_view_item = false, exclude_from_table_unique_test = false, is_service_select = false, cur_pos_in_select_list = 0, udf_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31af8, elements = 0}, <No data fields>}, prev_join_using = 0x0, select_list_tables = 0, name_visibility_map = {buffer = {0}}, with_dep = 0, grouping_tmp_fields = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31b30, elements = 0}, <No data fields>}, lock_type = TL_UNLOCK, save_many_values = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31b50, elements = 0}, <No data fields>}, save_insert_list = 0x0, tvc = 0x0, in_tvc = false, select_h = 0x0, pushdown_select = 0x0, versioned_tables = 0, window_specs = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31b98, elements = 0}, <No data fields>}, window_funcs = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31bb0, elements = 0}, <No data fields>}, m_non_agg_field_used = false, m_agg_func_used = false, m_custom_agg_func_used = false, current_index_hint_type = INDEX_HINT_IGNORE, current_index_hint_clause = 0 '\000', index_hints = 0x0}, current_select = 0x7f63b4b31768, all_selects_list = 0x7f63b4b31768, curr_with_clause = 0x0, with_clauses_list = 0x0, with_clauses_list_last_next = 0x7f63b4b31bf8, clone_spec_offset = 0, create_view = 0x0, explain = 0x0, charset = 0x7f63a4000cd0, stmt_lex = 0x7f63b4b30ea0, name = {str = 0x0, length = 0}, help_arg = 0x0, backup_dir = 0xb4b31eb0 <error: Cannot access memory at address 0xb4b31eb0>, to_log = 0x5609546ab7ea "dirname_part", wild = 0x0, exchange = 0x0, result = 0x0, comment = {str = 0x5609546aec12 "cleanup_dirname", length = 0}, ident = {str = 0x7f63b4b31ca0 "\220\r", length = 281476388102280}, grant_user = 0x7f63b4b31cc0, xid = 0x5609542296d3 <DoTrace+150>, thd = 0x7f63a4000d90, plugins = {buffer = 0x7f63b4b31cc8 "", elements = 1, max_element = 16, alloc_increment = 16, size_of_element = 8, malloc_flags = 256}, plugins_static_buffer = {0x7f63a4239300, 0x7f63a4026830, 0x7f63b4b31f30, 0x7f630000000e, 0x7f63a4000cd0, 0x0 <repeats 11 times>}, create_view_select = {str = 0x0, length = 0}, current_select_number = 0, raw_trg_on_table_name_begin = 0x0, raw_trg_on_table_name_end = 0x0, part_info = 0x0, definer = 0x0, account_options = {<user_resources> = {questions = 0, updates = 0, conn_per_hour = 0, user_conn = 0, max_statement_time = 0, specified_limits = 0}, ssl_type = SSL_TYPE_NONE, x509_subject = {str = 0x0, length = 0}, x509_issuer = {str = 0x0, length = 0}, ssl_cipher = {str = 0x0, length = 94598070974466}, account_locked = ACCOUNTLOCK_UNSPECIFIED, password_expire = PASSWORD_EXPIRE_UNSPECIFIED, num_expiration_days = 140066210127360}, table_type = TABLE_TYPE_UNKNOWN, ref_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31df0, elements = 0}, <No data fields>}, users_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31e08, elements = 0}, <No data fields>}, columns = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31e20, elements = 0}, <No data fields>}, insert_list = 0x6e00000000, field_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31e40, elements = 0}, <No data fields>}, value_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31e58, elements = 0}, <No data fields>}, update_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31e70, elements = 0}, <No data fields>}, many_values = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31e88, elements = 0}, <No data fields>}, var_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31ea0, elements = 0}, <No data fields>}, stmt_var_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31eb8, elements = 0}, <No data fields>}, old_var_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31ed0, elements = 0}, <No data fields>}, arena_for_set_stmt = 0x0, mem_root_for_set_stmt = 0x0, set_var_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31ef8, elements = 0}, <No data fields>}, param_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31f10, elements = 0}, <No data fields>}, view_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31f28, elements = 0}, <No data fields>}, with_column_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31f40, elements = 0}, <No data fields>}, column_list = 0x0, index_list = 0x0, context_stack = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b31f68, elements = 0}, <No data fields>}, select_stack = {0x747365742d6c7173, 0x706d742f7261762f, 0x2e646c7173796d2f, 0x2f31, 0x0 <repeats 24 times>, 0x63322d326c717323, 0x342d38363966, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x5609546af108, 0x0, 0x7f63b4b320d0, 0x1000054202088, 0x7f63b4b320f0, 0x5609542296d3 <DoTrace+150>, 0x7f63b4b320f0, 0x7f63a4000cd0, 0x7f63a4000cd0, 0xa4000cb0, 0x5609546aec36, 0x0, 0x7f63b4b32120, 0x1000054202088, 0x7f63b4b32140, 0x5609542296d3 <DoTrace+150>, 0x7f63b4b32140, 0x7f63a4000cd0, 0x7f63a4000cd0, 0x1a4000cb0, 0x7f63b4b32190, 0x560954228718 <_db_enter_+282>, 0x7f63b4b321c0, 0x12300000000, 0x5609546aebd8, 0x4fc19600, 0x5609546aec48, 0x0}, select_stack_top = 0, select_stack_outer_barrier = 0, proc_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b32190}, auxiliary_table_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b321a8}, save_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b321c0}, last_field = 0x13a8000000d, in_sum_func = 0x0, udf = {name = {str = 0x622f74380000000c <error: Cannot access memory at address 0x622f74380000000c>, length = 140066210128704}, returns = 3134225580, type = (UDFTYPE_FUNCTION \| UDFTYPE_AGGREGATE \| unknown: 0x7f60), dl = 0x7f63bad055e1 "Mc\004$H\213D$ I\001\350L\001\300H9\003s\004L\211k L\211C\030\351@\374\377\377\200\371P\017\205\226", dlhandle = 0x747365742d6c7173, func = 0x7f63bad04665, func_init = 0x7f63bad08338, func_deinit = 0xd0, func_clear = 0x10b, func_add = 0x7f63b4b32380, func_remove = 0x7f63bad07cac, usage_count = 140066312705505}, check_opt = {flags = 8, sql_flags = 32611, start_time = 140065929956560, key_cache = 0x7f63bad08338}, create_info = {<HA_CREATE_INFO> = {<Table_scope_and_contents_source_st> = {<Table_scope_and_contents_source_pod_st> = {alter_table_convert_to_charset = 0x7f63b4b322b0, tabledef_version = {str = 0x15 <error: Cannot access memory at address 0x15>, length = 140066321539168}, connect_string = {str = 0x0, length = 140066210128704}, comment = {str = 0x7f63bb573180 "", length = 140066312049313}, alias = {str = 0x7f63b4b322b0 "\340\"\263\264c\177", length = 140063178489857}, password = 0x15 <error: Cannot access memory at address 0x15>, tablespace = 0x7f63b4b325d0 "", data_file_name = 0x7f63b4b322e0 "", index_file_name = 0x7f63bb573720 "", max_rows = 140066210128928, min_rows = 140066312733168, auto_increment_value = 21, table_options = 0, 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 = 3031639064, db_type = 0x0, row_type = ROW_TYPE_DEFAULT, 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 = 0x7f63bad04288 <_Unwind_Backtrace+56>, mdl_ticket = 0x0, table_was_deleted = 40, seq_create_info = 0x0}, vers_info = {<Table_period_info> = {<Sql_alloc> = {<No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x5609542f0710 "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}, 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}}, <Schema_specification_st> = {default_table_charset = 0x7f63bb573180}, <No data fields>}, <DDL_options_st> = {m_options = DDL_options_st::OPT_NONE}, <No data fields>}, last_key = 0xffffffffffffffc8, mi = {repl_ignore_server_ids = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 16, size_of_element = 8, malloc_flags = 0}, repl_do_domain_ids = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 16, size_of_element = 8, malloc_flags = 0}, repl_ignore_domain_ids = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 16, size_of_element = 8, malloc_flags = 0}, host = 0x0, user = 0x0, password = 0x0, log_file_name = 0x0, ssl_key = 0x0, ssl_cert = 0x0, ssl_ca = 0x0, ssl_capath = 0x0, ssl_cipher = 0x0, ssl_crl = 0x0, ssl_crlpath = 0x0, relay_log_name = 0x0, connection_name = {str = 0x0, length = 0}, gtid_pos_str = {str = 0x0, length = 0}, pos = 0, relay_log_pos = 0, server_id = 0, port = 0, connect_retry = 0, heartbeat_period = 0, sql_delay = -1, ssl = LEX_MASTER_INFO::LEX_MI_UNCHANGED, ssl_verify_server_cert = LEX_MASTER_INFO::LEX_MI_UNCHANGED, heartbeat_opt = LEX_MASTER_INFO::LEX_MI_UNCHANGED, repl_ignore_server_ids_opt = LEX_MASTER_INFO::LEX_MI_UNCHANGED, repl_do_domain_ids_opt = LEX_MASTER_INFO::LEX_MI_UNCHANGED, repl_ignore_domain_ids_opt = LEX_MASTER_INFO::LEX_MI_UNCHANGED, use_gtid_opt = LEX_MASTER_INFO::LEX_GTID_UNCHANGED}, server_options = {port = 0, server_name = {str = 0x560954a2f235 "\377\377\001)G\236\002\367\n", length = 130843}, host = {str = 0x7f63b4b325d0 "", length = 140066210130032}, db = {str = 0x7f63bac38e7f <backtrace_helper+47> "H\211\302\213C\020\205\300~\021H\213\vHc\360H\213<\361H9\|\361\370t\026H\211S\b\203\300\001\211C\020;C\024t\r[1\300A\\]\303H9S\bu\344[\270\005", length = 140066210129360}, username = {str = 0x7f63b4b326c0 "\001", length = 140066210130032}, password = {str = 0x7f63bad042b4 <_Unwind_Backtrace+100> "\205\300\017\205\204", length = 0}, scheme = {str = 0x0, length = 0}, socket = {str = 0x7f63b4b334a0 "\310\200\001\244c\177", length = 0}, owner = {str = 0x0, length = 140066210133216}}, relay_log_connection_name = {str = 0x0, length = 0}, reset_slave_info = {all = false}, type = 0, next_binlog_file_number = 0, kill_signal = 3031643304, kill_type = (KILL_TYPE_USER \| KILL_TYPE_QUERY \| unknown: 0x7f60), is_shutdown_wait_for_slaves = 176, allow_sum_func = {buffer = {0}}, m_sql_cmd = 0x0, clause_that_disallows_subselect = 0x0, selects_allow_into = false, selects_allow_procedure = false, parse_vcol_expr = false, duplicates = DUP_ERROR, tx_isolation = 3031643376, ha_read_mode = 32611, {ha_rkey_mode = 1399176960, xa_opt = 1399176960, with_admin_option = false, with_persistent_for_clause = false}, option_type = SHOW_OPT_DEFAULT, drop_mode = (DROP_CASCADE \| unknown: 0x54a2f234), profile_query_id = 22025, profile_options = 0, grant = 0, grant_tot_col = 0, which_columns = 0, backup_stage = 1399175950, fk_match_option = 22025, fk_update_opt = FK_OPTION_UNDEF, fk_delete_opt = 1073741824, slave_thd_opt = 0, start_transaction_opt = 0, nest_level = 0, table_count = 22025, describe = 0 '\000', analyze_stmt = false, explain_json = false, derived_tables = 0 '\000', context_analysis_only = 2 '\002', with_cte_resolution = false, only_cte_resolution = false, local_file = false, check_exists = false, autocommit = 38, verbose = false, no_write_to_binlog = 180, tx_chain = (TVL_NO \| TVL_UNKNOWN \| unknown: 0x7f60), tx_release = (unknown: 0x54202088), safe_to_cache_query = true, ignore = false, next_is_main = false, next_is_down = false, parsing_options = {allows_variable = true, lookup_keywords_after_qualifier = false}, lex_options = 0 '\000', sql_cache = LEX::SQL_CACHE_UNSPECIFIED, alter_info = {drop_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b326c8, elements = 0}, <No data fields>}, alter_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b326e0, elements = 0}, <No data fields>}, key_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b326f8, elements = 0}, <No data fields>}, create_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b32710, elements = 0}, <No data fields>}, check_constraint_list = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b32728, elements = 0}, <No data fields>}, flags = 0, partition_flags = 0, keys_onoff = Alter_info::LEAVE_AS_IS, partition_names = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b32758, elements = 0}, <No data fields>}, num_parts = 0, requested_algorithm = Alter_info::ALTER_TABLE_ALGORITHM_NONE, requested_lock = Alter_info::ALTER_TABLE_LOCK_DEFAULT}, create_last_non_select_table = 0x7f63b4b327b0, prepared_stmt = {m_name = {<Lex_ident_sys_st> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, m_code = 0x0, m_params = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b327a0, elements = 0}, <No data fields>}}, sphead = 0x0, spname = 0x0, sp_lex_in_use = 16, all_privileges = 42, spcont = 0x0, sp_chistics = {comment = {str = 0x7f63a4000cd0 "\327\240\001M\374\177", length = 0}, suid = (unknown: 0x10), detistic = false, daccess = 6, agg_type = DEFAULT_AGGREGATE}, event_parse_data = 0x0, empty_field_list_on_rset = false, trg_chistics = {<st_trg_execution_order> = {ordering_clause = (TRG_ORDER_FOLLOWS \| TRG_ORDER_PRECEDES \| unknown: 0x5365c0a4), anchor_trigger_name = {str = 0x7f63baef6110 <__gxx_personality_v0> "AWAVAUATUSH\201\354\250", length = 18446744073709551608}}, action_time = TRG_ACTION_AFTER, event = TRG_EVENT_INSERT, ordering_clause_begin = 0x10 <error: Cannot access memory at address 0x10>, ordering_clause_end = 0x11b1b <error: Cannot access memory at address 0x11b1b>}, trg_table_fields = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b32840}, {stmt_definition_begin = 0x7f63b4b32870 "", keyword_delayed_begin_offset = 3031640176}, {stmt_definition_end = 0x560954202088 <my_thread_var_dbug+31> "H\211E\370H\203}\370", keyword_delayed_end_offset = 1411391624}, option_list = 0x7f63b4b34e80, option_list_last = 0x7f63a4000b60, use_only_table_context = false, alter_tablespace_info = 0x5609542262e1 <code_state+167>, escape_used = false, default_used = false, is_lex_started = true, used_tables = 0, limit_rows_examined = 0x0, limit_rows_examined_cnt = 18446744073709551615, delete_gtid_domain = {buffer = 0x7f63b4b328c0 "\340(\263\264c\177", elements = 0, max_element = 16, alloc_increment = 16, size_of_element = 4, malloc_flags = 256}, gtid_domain_static_buffer = {3031640288, 32611, 1411391624, 22025, 3031640304, 32611, 2751466336, 32611, 3031640320, 32611, 1411539681, 22025, 2751466704, 32611, 2751466672, 32611}, save_group_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b32908}, save_order_list = {<Sql_alloc> = {<No data fields>}, elements = 0, first = 0x0, next = 0x7f63b4b32920}, win_ref = 0x0, win_frame = 0x0, frame_top_bound = 0x0, frame_bottom_bound = 0x0, win_spec = 0x0, vers_conditions = {type = SYSTEM_TIME_UNSPECIFIED, orig_type = SYSTEM_TIME_UNSPECIFIED, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x0, field_end = 0x0, period = 0x7f63b4b329d0}, period_conditions = {type = SYSTEM_TIME_UNSPECIFIED, orig_type = SYSTEM_TIME_UNSPECIFIED, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x7f63b4b32a40, field_end = 0x5609535976af <THD::reset_n_backup_open_tables_state(Open_tables_backup*)+175>, period = 0x7f63b4b32bb0}}
lex = 0x7f63b4b30ea0
db_name = {str = 0x7f63a401a700 "test", length = 4}
table_name = {str = 0x7f63a401a708 "t_spider", length = 8}
table_list = 0x7f63a41dacb8
result = false
_db_stack_frame_ = {func = 0x560954311299 "get_all_tables", file = 0x56095430f7e0 "/data/src/10.4/sql/sql_show.cc", level = 2147483658, line = -1, prev = 0x7f63b4b32ae0}
__PRETTY_FUNCTION__ = "bool fill_schema_table_by_open(THD, MEM_ROOT, bool, TABLE, ST_SCHEMA_TABLE, LEX_CSTRING, LEX_CSTRING, Open_tables_backup*, bool)"
#8 0x00005609536ba5b6 in get_all_tables (thd=0x7f63a4000d90, tables=0x7f63a4016470, cond=0x0) at /data/src/10.4/sql/sql_show.cc:5255
_db_stack_frame_ = {func = 0x560954311eb6 "get_schema_tables_result", file = 0x56095430f7e0 "/data/src/10.4/sql/sql_show.cc", level = 2147483657, line = -1, prev = 0x7f63b4b33390}
lex = 0x7f63a4004c00
table = 0x7f63a41e1fd8
table_acl_check = {next_local = 0x0, next_global = 0x0, prev_global = 0x0, db = {str = 0x7f63bad04288 <_Unwind_Backtrace+56> "\017\037\204", length = 0}, table_name = {str = 0x7f63bad04728 "\017\266\023\200\372Ru\333D\017\266", length = 0}, schema_table_name = {str = 0x560954b99548 <DW.ref.__gxx_personality_v0> "\020a\357\272c\177", length = 4611686018427387904}, alias = {str = 0xb4b32db0 <error: Cannot access memory at address 0xb4b32db0>, length = 94598070989064}, option = 0x0, on_expr = 0x7f63b4b32c90, on_context = 0x1000054202088, sj_on_expr = 0x7f63b4b32cb0, sj_inner_tables = 94598066247379, sj_in_exprs = 3031641264, sj_subq_pred = 0x7f63a4000cd0, original_subq_pred_used_tables = 140065929956560, jtbm_subselect = 0x1a4000cb0, jtbm_table_no = 3031641840, sj_mat_info = 0x560954228945 <_db_return_+209>, prep_on_expr = 0x26188000000b, cond_equal = 0x7f63b4b32f40, natural_join = 0xa, is_natural_join = 208, join_using_fields = 0x0, join_columns = 0x7f63b4b32db0, is_join_columns_complete = 128, next_name_resolution_table = 0x7f63bac652a1 <__GI___dl_iterate_phdr+401>, index_hints = 0xffffffffffffffc8, table = 0x1, table_id = 0, derived_result = 0x7f63bad05100, map = 94598044872704, correspondent_table = 0x7f63bb573720, derived = 0x560952dc7040, with = 0x7f63bad0000c <__gttf2+348>, with_internal_reference_map = 21, next_with_rec_ref = 0x0, is_derived_with_recursive_reference = true, block_handle_derived = false, dt_handler = 0x7f63b4b355d8, derived_spec = {str = 0x0, length = 746775358187083264}, pushdown_derived = 0x0, schema_table = 0x7f63b4b32e80, schema_select_lex = 0x7f63b4b32f28, schema_table_reformed = 128, schema_table_param = 0x7f63b4b33130, select_lex = 0x56095364b801 <handle_select(THD, LEX, select_result, unsigned long)+403>, view = 0x0, field_translation = 0x7f63bad061e1 <_Unwind_Find_FDE+97>, field_translation_end = 0x56095364b801 <handle_select(THD, LEX, select_result, unsigned long)+403>, field_translation_updated = false, merge_underlying_list = 0x0, view_tables = 0x56095364b66e <handle_select(THD, LEX, select_result, unsigned long)>, belong_to_view = 0x5609548a97b8, belong_to_derived = 0x1, referencing_view = 0x7f63b4b334f0, view_used_tables = 94598072824878, map_exec = 140066210131584, tablenr_exec = 1418368952, maybe_null_exec = 22025, parent_l = 0x5609548a97cd, security_ctx = 0x56095486f439, view_sctx = 0x7f63b4b32f70, allowed_show = 200, where = 0x0, check_option = 0x7f63b4b32e38, select_stmt = {str = 0x0, length = 94598074658454}, md5 = {str = 0x1ff1b <error: Cannot access memory at address 0x1ff1b>, length = 3031641728}, source = {str = 0x5609546af108 "alloc_root", length = 0}, view_db = {str = 0x7f63b4b32e80 "\240.\263\264c\177", length = 94598066085724}, view_name = {str = 0x7f63b4b32e90 "\260.\263\264c\177", length = 94598066085724}, timestamp = {str = 0x7f63b4b32ea0 "\300.\263\264c\177", length = 94598066086024}, definer = {<AUTHID> = {user = {str = 0x7f63b4b32eb0 "\320\f", length = 140065929956192}, host = {str = 0x7f63b4b32ec0 "\360.\263\264c\177", length = 94598066234081}}, auth = 0x7f63a4000cd0}, file_version = 140065929956528, mariadb_version = 140066210131696, updatable_view = 94598066244354, algorithm = 94598070989143, view_suid = 1205342309584, with_check = 140066210133352, effective_with_check = 0 '\000', derived_type = 150 '\226', grant = {grant_table_user = 0x7f63b4b32f70, grant_table_role = 0x5609541f0443 <alloc_root+891>, version = 24, privilege = 140065929979752, want_privilege = 24, orig_want_privilege = 94598053804034, m_internal = {m_schema_lookup_done = 150, m_schema_access = 0x0, m_table_lookup_done = 232, m_table_access = 0x18}}, engine_data = 94598067171752, callback_func = 0x54306fb0, lock_type = 1416273795, mdl_type = 22025, table_options = 0, outer_join = 3031641984, shared = 32611, updatable = 136, straight = 32, updating = 32, force_index = 84, ignore_leaves = false, crashed = false, dep_tables = 140066210131872, on_expr_dep_tables = 94598066247379, nested_join = 0x7f63b4b32fa0, embedding = 0x7f63a4000cd0, join_list = 0x7f63a4000cd0, lifted = 176, cacheable_table = 12, table_in_first_from_clause = false, open_type = OT_TEMPORARY_ONLY, contain_auto_increment = 224, compact_view_format = 49, where_processed = 179, check_option_processed = 180, required_type = 32611, db_type = 0x560954228945 <_db_return_+209>, timestamp_buffer = "\320/\263\264c\177\000\000\020\062\263\264c\177\000\000\n\000\000", prelocking_placeholder = (TABLE_LIST::PRELOCK_ROUTINE \| TABLE_LIST::PRELOCK_FK \| unknown: 0x7f60), open_strategy = (unknown: 0xa4000cd0), is_alias = 99, is_fqtn = 127, fill_me = false, merged = false, merged_for_insert = 244, sequence = 47, used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b32fd8, elements = 0}, <No data fields>}, persistent_used_items = {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x560954d9d3a0 <end_of_list>, last = 0x7f63b4b32ff0, elements = 0}, <No data fields>}, view_creation_ctx = 0x5369853b, view_client_cs_name = {str = 0x5609542e81cf "THD::push_internal_handler", length = 0}, view_connection_cl_name = {str = 0x7f63b4b33040 "`0\263\264c\177", length = 281476388102280}, view_body_utf8 = {str = 0x7f63b4b33060 "\377\377\377\377c\177", length = 94598066247379}, trg_event_map = 96 '`', slave_fk_event_map = 48 '0', optimized_away = 179, materialized = 180, i_s_requested_object = 32611, prohibit_cond_pushdown = 208, table_open_method = 32611, schema_table_state = (unknown: 0xa4000cd0), is_table_read_plan = 0x1a4000cb0, mdl_request = {type = MDL_NOT_INITIALIZED, duration = 32611, next_in_list = 0x560954228945 <_db_return_+209>, prev_in_list = 0x7f63b4b330a0, ticket = 0x0, key = {m_length = 9, m_db_name_length = 0, m_hash_value = 32611, m_ptr = "\320\f\000\244c\177\000\000\320\f\000\244c\177\000\000\260\f\000\244\001\000\000\000\340\062\263\264c\177\000\000E\211\"T\tV\000\000pd\001\244c\177\000\000\200\063\263\264c\177\000\000\t\000\000\000c\177\000\000\320\f\000\244c\177\000\000\001\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\033\033\001", '\000' <repeats 13 times>, "p\243\001\244c\177\000\000$ 1T\tV\000\000 1\263\264c\177\000\000\210 T\tV\000\000\200N\263\264c\177\000\000`\v\000\244\000\000\000\000\002~0T\tV\000\000\000\000\000\000\000\000\000\000P1\263\264c\177\000\000\210 T\000\000\001\000p1\263\264c\177\000\000\323\226\"T\tV\000\000"...}}, partition_names = 0x208, vers_conditions = {type = 3098038464, orig_type = 95, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x7f63b8e5adb0, field_end = 0x7f63b8e5a318, period = 0x7f63b863a7d0}, period_conditions = {type = 1447744000, orig_type = 22025, used = false, delete_history = false, start = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, end = {<vers_history_point_t> = {unit = VERS_UNDEFINED, item = 0x0}, <No data fields>}, name = {<Lex_cstring> = {<st_mysql_const_lex_string> = {str = 0x0, length = 0}, <No data fields>}, <No data fields>}, field_start = 0x7f63b4b332f0, field_end = 0x5609534d02b9 <THD::enter_stage(PSI_stage_info_v1 const, char const, char const, unsigned int)+301>, period = 0x560954311eb6}, for_insert_data = -88 '\250', m_table_ref_type = 32611, m_table_ref_version = 140066210132720}
lsel = 0x7f63a4014888
schema_table = 0x560954baca60 <schema_tables+1984>
plan = 0x7f63a401a370
schema_table_idx = SCH_STATISTICS
db_names = {array = {buffer = 0x560956672cc0 '\245' <repeats 128 times>, "h4z\025", elements = 0, max_element = 16, alloc_increment = 16, size_of_element = 8, malloc_flags = 0}}
partial_cond = 0xa5a5a5a5a5a5a5a5
error = 1
open_tables_state_backup = {<Open_tables_state> = {m_reprepare_observer = 0x0, open_tables = 0x0, temporary_tables = 0x7f63a41b6e30, derived_tables = 0x7f63a41e1fd8, rec_tables = 0x0, lock = 0x7f63a4018080, extra_lock = 0x0, locked_tables_mode = LTM_NONE, current_tablenr = 0, state_flags = 0}, mdl_system_tables_svp = {m_stmt_ticket = 0x0, m_trans_ticket = 0x0}}
sctx = 0x7f63a4002bc0
table_open_method = 3
can_deadlock = false
tmp_mem_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 0, block_size = 0, total_alloc = 0, block_num = 0, first_block_usage = 0, error_handler = 0x0, name = 0x0}
old_sp_caches = {sp_proc_cache = 0x0, sp_func_cache = 0x0, sp_package_spec_cache = 0x0, sp_package_body_cache = 0x0}
__PRETTY_FUNCTION__ = "int get_all_tables(THD, TABLE_LIST, COND*)"
#9 0x00005609536ccc60 in get_schema_tables_result (join=0x7f63a40180c8, executed_place=PROCESSED_BY_JOIN_EXEC) at /data/src/10.4/sql/sql_show.cc:9080
is_subselect = false
cond = 0x0
backup_ctx = {m_thd = 0x7f63a4000d90, m_sctx = 0x7f63a4002bc0}
check_level_save = {m_thd = 0x7f63a4000d90, m_check_level = CHECK_FIELD_IGNORE}
table_list = 0x7f63a4016470
thd = 0x7f63a4000d90
lex = 0x7f63a4004c00
result = false
org_stage = {m_key = 37, m_name = 0x5609542c73bd "Executing", m_flags = 0}
_db_stack_frame_ = {func = 0x560954308019 "JOIN::exec_inner", file = 0x560954306fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483656, line = -1, prev = 0x7f63b4b33400}
err_handler = {<Internal_error_handler> = {_vptr.Internal_error_handler = 0x560954a82518 <vtable for Warnings_only_error_handler+16>, m_prev_internal_handler = 0x0}, <No data fields>}
tab = 0x7f63a4019860
#10 0x000056095365b39d in JOIN::exec_inner (this=0x7f63a40180c8) at /data/src/10.4/sql/sql_select.cc:4502
columns_list = 0x7f63a4005610
_db_stack_frame_ = {func = 0x5609543080f7 "mysql_select", file = 0x560954306fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483655, line = -1, prev = 0x7f63b4b33540}
__PRETTY_FUNCTION__ = "void JOIN::exec_inner()"
trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560954a73510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
trace_exec = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560954a73510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
trace_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560954a734f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
#11 0x000056095365a79a in JOIN::exec (this=0x7f63a40180c8) at /data/src/10.4/sql/sql_select.cc:4327
No locals.
#12 0x000056095365bf14 in mysql_select (thd=0x7f63a4000d90, tables=0x7f63a4016470, wild_num=0, fields=@0x7f63a4005610: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7f63a4015528, last = 0x7f63a4016428, elements = 13}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7f63a40180a0, unit=0x7f63a4004cc0, select_lex=0x7f63a40054c8) at /data/src/10.4/sql/sql_select.cc:4766
err = 0
free_join = true
_db_stack_frame_ = {func = 0x560954307098 "handle_select", file = 0x560954306fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483654, line = -1, prev = 0x7f63b4b33600}
join = 0x7f63a40180c8
#13 0x000056095364b802 in handle_select (thd=0x7f63a4000d90, lex=0x7f63a4004c00, result=0x7f63a40180a0, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:436
unit = 0x7f63a4004cc0
res = false
select_lex = 0x7f63a40054c8
_db_stack_frame_ = {func = 0x5609542fa930 "mysql_execute_command", file = 0x5609542f9cc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f63b4b33c80}
#14 0x0000560953610eee in execute_sqlcom_select (thd=0x7f63a4000d90, all_tables=0x7f63a4016470) at /data/src/10.4/sql/sql_parse.cc:6449
save_protocol = 0x0
lex = 0x7f63a4004c00
result = 0x7f63a40180a0
res = false
__PRETTY_FUNCTION__ = "bool execute_sqlcom_select(THD, TABLE_LIST)"
#15 0x000056095360770e in mysql_execute_command (thd=0x7f63a4000d90) at /data/src/10.4/sql/sql_parse.cc:3963
privileges_requested = 1
res = 0
up_result = 0
lex = 0x7f63a4004c00
select_lex = 0x7f63a40054c8
first_table = 0x7f63a4016470
all_tables = 0x7f63a4016470
unit = 0x7f63a4004cc0
have_table_map_for_update = false
rpl_filter = 0x560953a63d49 <inline_mysql_mutex_unlock(mysql_mutex_t, char const, uint)+107>
_db_stack_frame_ = {func = 0x5609542fbbb8 "mysql_parse", file = 0x5609542f9cc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f63b4b34250}
__PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)"
ots = {ctx = 0x7f63a40048e0, traceable = false}
trace_command = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560954a73510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
trace_command_steps = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560954a734f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
orig_binlog_format = BINLOG_FORMAT_MIXED
orig_current_stmt_binlog_format = BINLOG_FORMAT_STMT
#16 0x0000560953614e72 in mysql_parse (thd=0x7f63a4000d90, rawbuf=0x7f63a40147a8 "SHOW INDEXES FROM t_spider", length=26, parser_state=0x7f63b4b34410, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7995
found_semicolon = 0x0
error = 32611
lex = 0x7f63a4004c00
err = false
_db_stack_frame_ = {func = 0x5609542fa13a "dispatch_command", file = 0x5609542f9cc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f63b4b343f0}
__PRETTY_FUNCTION__ = "void mysql_parse(THD, char, uint, Parser_state*, bool, bool)"
#17 0x0000560953601312 in dispatch_command (command=COM_QUERY, thd=0x7f63a4000d90, packet=0x7f63a400ac01 "SHOW INDEXES FROM t_spider", packet_length=26, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
packet_end = 0x7f63a40147c2 ""
parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f63a4000d90, m_ptr = 0x7f63a40147c3 "\004", m_tok_start = 0x7f63a40147c3 "\004", m_tok_end = 0x7f63a40147c3 "\004", m_end_of_query = 0x7f63a40147c2 "", m_tok_start_prev = 0x7f63a40147c2 "", m_buf = 0x7f63a40147a8 "SHOW INDEXES FROM t_spider", m_buf_length = 26, m_echo = true, m_echo_saved = 12, m_cpp_buf = 0x7f63a4014820 "SHOW INDEXES FROM t_spider", m_cpp_ptr = 0x7f63a401483a "", m_cpp_tok_start = 0x7f63a401483a "", m_cpp_tok_start_prev = 0x7f63a401483a "", m_cpp_tok_end = 0x7f63a401483a "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x5609542296d3 <DoTrace+150> "\203\370\005\177\063\205\300\017\210\255", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false, multi_statements = true, yylineno = 1, m_digest = 0x0, in_comment = NO_COMMENT, in_comment_saved = (PRESERVE_COMMENT \| unknown: 0x5608), m_cpp_text_start = 0x7f63a4014832 "t_spider", m_cpp_text_end = 0x7f63a401483a "", m_underscore_cs = 0x0}, m_yacc = {yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = {m_item = {0x0 <repeats 12 times>}}, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ}, m_digest_psi = 0x7f63a40046e0}
net = 0x7f63a40010b8
error = false
do_end_of_statement = true
_db_stack_frame_ = {func = 0x5609542f9ec5 "do_command", file = 0x5609542f9cc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f63b4b34cb0}
drop_more_results = false
__PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD, char, uint, bool, bool)"
__FUNCTION__ = "dispatch_command"
res = <optimized out>
#18 0x00005609535ffbc5 in do_command (thd=0x7f63a4000d90) at /data/src/10.4/sql/sql_parse.cc:1378
return_value = false
packet = 0x7f63a400ac00 "\003SHOW INDEXES FROM t_spider"
packet_length = 27
net = 0x7f63a40010b8
command = COM_QUERY
_db_stack_frame_ = {func = 0x5609546b5368 "?func", file = 0x5609546b536e "?file", level = 2147483649, line = -1, prev = 0x0}
__PRETTY_FUNCTION__ = "bool do_command(THD*)"
__FUNCTION__ = "do_command"
#19 0x000056095378ecb1 in do_handle_one_connection (connect=0x560956783460) at /data/src/10.4/sql/sql_connect.cc:1420
create_user = true
thr_create_utime = 3732768344776
thd = 0x7f63a4000d90
__PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*)"
#20 0x000056095378e959 in handle_one_connection (arg=0x560956783460) at /data/src/10.4/sql/sql_connect.cc:1316
connect = 0x560956783460
#21 0x0000560953cabc69 in pfs_spawn_thread (arg=0x5609567fae60) at /data/src/10.4/storage/perfschema/pfs.cc:1869
typed_arg = 0x5609567fae60
user_arg = 0x560956783460
user_start_routine = 0x56095378e929 <handle_one_connection(void*)>
pfs = 0x7f63b8e596c0
klass = 0x5609564a4c00
#22 0x00007f63bb02eea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
ret = <optimized out>
pd = <optimized out>
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140066210141952, -4812647732707428283, 140721600433438, 140721600433439, 140066210139776, 311296, 4895803139520886853, 4895831053538195525}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
not_first_call = 0
#23 0x00007f63bac2bdef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Couldn't reproduce on 10.3 and 10.5.

Attachments

Activity

People

Assignee:: Yuchen Pei

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2022-07-08 20:07

Updated:: 2023-05-23 04:33

Git Integration

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