#2 0x0000560107e5c5a1 in handle_fatal_signal (sig=11) at /data/src/10.4/sql/signal_handler.cc:366
|
curr_time = 1657456648
|
tm = {tm_sec = 28, tm_min = 37, tm_hour = 15, tm_mday = 10, tm_mon = 6, tm_year = 122, tm_wday = 0, tm_yday = 190, tm_isdst = 1, tm_gmtoff = 10800, tm_zone = 0x56010b924930 "EEST"}
|
thd = 0x7fd280000d90
|
print_invalid_query_pointer = false
|
#3 <signal handler called>
|
No locals.
|
#4 0x0000560107e8dab6 in Item_field::fix_outer_field (this=0x7fd280016a18, thd=0x7fd280000d90, from_field=0x7fd2908a9c40, reference=0x7fd280016b30) at /data/src/10.4/sql/item.cc:5567
|
prev_subselect_item = 0x0
|
place = IN_ON
|
field_found = false
|
upward_lookup = true
|
table_list = 0x0
|
last_checked_context = 0x7fd280005518
|
ref = 0x1
|
current_sel = 0x7fd280016580
|
outer_context = 0x7fd280005518
|
select = 0x7fd2800054c8
|
__PRETTY_FUNCTION__ = "int Item_field::fix_outer_field(THD*, Field**, Item**)"
|
#5 0x0000560107e8f150 in Item_field::fix_fields (this=0x7fd280016a18, thd=0x7fd280000d90, reference=0x7fd280016b30) at /data/src/10.4/sql/item.cc:5984
|
ret = 0
|
table_list = 0x5601092be3a0 <end_of_list>
|
__PRETTY_FUNCTION__ = "virtual bool Item_field::fix_fields(THD*, Item**)"
|
from_field = 0x1
|
outer_fixed = false
|
select = 0x7fd280016580
|
#6 0x0000560107a0f429 in Item::fix_fields_if_needed (this=0x7fd280016a18, thd=0x7fd280000d90, ref=0x7fd280016b30) at /data/src/10.4/sql/item.h:964
|
No locals.
|
#7 0x0000560107a0f45f in Item::fix_fields_if_needed_for_scalar (this=0x7fd280016a18, thd=0x7fd280000d90, ref=0x7fd280016b30) at /data/src/10.4/sql/item.h:968
|
No locals.
|
#8 0x0000560107a8f2f0 in setup_fields (thd=0x7fd280000d90, ref_pointer_array={m_array = 0x7fd280019c38, m_size = 3}, fields=@0x7fd2800166c8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd280016b28, last = 0x7fd280016b28, elements = 1}, <No data fields>}, column_usage=MARK_COLUMNS_READ, sum_func_list=0x7fd2800199d8, pre_fix=0x7fd2800166e0, allow_sum_func=true) at /data/src/10.4/sql/sql_base.cc:7714
|
item = 0x7fd280016a18
|
saved_column_usage = MARK_COLUMNS_READ
|
save_allow_sum_func = {buffer = {0}}
|
it = {<base_list_iterator> = {list = 0x7fd2800166c8, el = 0x7fd280016b28, prev = 0x7fd2800166c8, current = 0x7fd280016b28}, <No data fields>}
|
save_is_item_list_lookup = true
|
make_pre_fix = true
|
_db_stack_frame_ = {func = 0x560108828487 "JOIN::prepare", file = 0x560108827fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483661, line = -1, prev = 0x7fd2908a9ec0}
|
__PRETTY_FUNCTION__ = "bool setup_fields(THD*, Ref_ptr_array, List<Item>&, enum_column_usage, List<Item>*, List<Item>*, bool)"
|
li = {<base_list_iterator> = {list = 0x7fd280005c58, el = 0x5601092be3a0 <end_of_list>, prev = 0x7fd280005c58, current = 0x5601092be3a0 <end_of_list>}, <No data fields>}
|
var = 0x0
|
ref = {m_array = 0x7fd280019c38, m_size = 3}
|
#9 0x0000560107b6ff2a in JOIN::prepare (this=0x7fd2800196b8, tables_init=0x7fd280016b70, wild_num=0, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fd280016580, unit_arg=0x7fd280017260) at /data/src/10.4/sql/sql_select.cc:1278
|
_db_stack_frame_ = {func = 0x5601089d999a "Item_in_subselect::fix_fields", file = 0x5601089d82b8 "/data/src/10.4/sql/item_subselect.cc", level = 2147483660, line = -1, prev = 0x7fd2908aa0c0}
|
trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
trace_prepare = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <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 = 0x560108f944f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
tbl = 0x0
|
li = {<base_list_iterator> = {list = 0x7fd2800167b8, el = 0x5601092be3a0 <end_of_list>, prev = 0x0, current = 0x0}, <No data fields>}
|
real_og_num = 0
|
__PRETTY_FUNCTION__ = "int JOIN::prepare(TABLE_LIST*, uint, COND*, uint, ORDER*, bool, ORDER*, Item*, ORDER*, SELECT_LEX*, SELECT_LEX_UNIT*)"
|
save_place = NO_MATTER
|
with_clause = 0x560108723088 <my_thread_var_dbug+31>
|
with_elem = 0x7fd280000cd0
|
res = 324
|
#10 0x0000560107f4ec6d in subselect_single_select_engine::prepare (this=0x7fd280017c90, thd=0x7fd280000d90) at /data/src/10.4/sql/item_subselect.cc:3845
|
save_select = 0x7fd280015000
|
#11 0x0000560107f412f1 in Item_subselect::fix_fields (this=0x7fd280017a68, thd_param=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item_subselect.cc:289
|
save_where = 0x5601089d9952 "IN/ALL/ANY subquery"
|
uncacheable = 0 '\000'
|
res = false
|
__PRETTY_FUNCTION__ = "virtual bool Item_subselect::fix_fields(THD*, Item**)"
|
#12 0x0000560107f4dbb6 in Item_in_subselect::fix_fields (this=0x7fd280017a68, thd_arg=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item_subselect.cc:3507
|
outer_cols_num = 0
|
inner_cols = 0x7fd2908aa320
|
save_where = 0x560108803c11 "on clause"
|
_db_stack_frame_ = {func = 0x560108803c1b "setup_conds", file = 0x560108801108 "/data/src/10.4/sql/sql_base.cc", level = 2147483659, line = -1, prev = 0x7fd2908aa3d0}
|
__PRETTY_FUNCTION__ = "virtual bool Item_in_subselect::fix_fields(THD*, Item**)"
|
#13 0x0000560107a0f429 in Item::fix_fields_if_needed (this=0x7fd280017a68, thd=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item.h:964
|
No locals.
|
#14 0x0000560107a0f45f in Item::fix_fields_if_needed_for_scalar (this=0x7fd280017a68, thd=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item.h:968
|
No locals.
|
#15 0x0000560107a953af in Item::fix_fields_if_needed_for_bool (this=0x7fd280017a68, thd=0x7fd280000d90, ref=0x7fd280015d70) at /data/src/10.4/sql/item.h:972
|
No locals.
|
#16 0x0000560107a913b2 in setup_on_expr (thd=0x7fd280000d90, table=0x7fd280015d10, is_update=false) at /data/src/10.4/sql/sql_base.cc:8332
|
embedded = 0x7fd280015d10
|
embedding = 0x7fd280015d10
|
buff = " \242\212\220\322\177\000\000\306\030\306\a\001V\000\000\230\203\001\200\000\000\000\000\370U\001\200\322\177\000\000\200\242\212\220\322\177\000\000\061\032\306\a\000\000\000\000\b\001\275\b\001V\000\000\000\000\000\000\000\000\000\000`\242\212\220\322\177\000\000\\/r\b\001V\000\000p\242\212\220\322\177\000\000\\/r\b\001V\000\000\200\242\212\220\322\177\000\000\210\060r\b\001V\000\000\220\242\212\220\322\177\000\000`\v\000\200\322\177\000\000\240\242\212\220\322\177\000\000\341rt\b\001V\000\000\320\f\000\200\322\177\000\000\260\f\000\200\322\177\000\000\320\242\212\220\322\177\000\000\002\233t\b\001V\000\000W\001\275\b\001V\000\000\320\f\000\200\030\001\000\000\320|\001\200\322\177\000\000\000"...
|
#17 0x0000560107a91847 in setup_conds (thd=0x7fd280000d90, tables=0x7fd2800155f8, leaves=@0x7fd280015238: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd280019470, last = 0x7fd280019480, elements = 2}, <No data fields>}, conds=0x7fd280019308) at /data/src/10.4/sql/sql_base.cc:8451
|
select_lex = 0x7fd280015000
|
table = 0x0
|
it_is_update = false
|
save_is_item_list_lookup = true
|
derived = 0x0
|
save_resolve_in_select_list = true
|
_db_stack_frame_ = {func = 0x5601088281a1 "setup_without_group", file = 0x560108827fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483658, line = -1, prev = 0x7fd2908aa460}
|
#18 0x0000560107b6d213 in setup_without_group (thd=0x7fd280000d90, ref_pointer_array={m_array = 0x7fd2800195b8, m_size = 6}, tables=0x7fd2800155f8, leaves=@0x7fd280015238: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd280019470, last = 0x7fd280019480, elements = 2}, <No data fields>}, fields=@0x7fd280015148: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd2800155a0, last = 0x7fd2800155a0, elements = 1}, <No data fields>}, all_fields=@0x7fd280019220: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7fd2800155a0, last = 0x7fd2800155a0, elements = 1}, <No data fields>}, conds=0x7fd280019308, order=0x0, group=0x0, win_specs=@0x7fd280015430: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5601092be3a0 <end_of_list>, last = 0x7fd280015430, elements = 0}, <No data fields>}, win_funcs=@0x7fd280015448: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x5601092be3a0 <end_of_list>, last = 0x7fd280015448, elements = 0}, <No data fields>}, hidden_group_fields=0x7fd2800191e7, reserved=0x7fd280015304) at /data/src/10.4/sql/sql_select.cc:724
|
res = 5
|
save_place = NO_MATTER
|
select = 0x7fd280015000
|
save_allow_sum_func = {buffer = {0}}
|
saved_non_agg_field_used = false
|
_db_stack_frame_ = {func = 0x560108828487 "JOIN::prepare", file = 0x560108827fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483657, line = -1, prev = 0x7fd2908aa590}
|
#19 0x0000560107b70063 in JOIN::prepare (this=0x7fd280018f00, tables_init=0x7fd2800155f8, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fd280015000, unit_arg=0x7fd280004cc0) at /data/src/10.4/sql/sql_select.cc:1283
|
_db_stack_frame_ = {func = 0x56010883e720 "st_select_lex_unit::prepare_join", file = 0x56010883e558 "/data/src/10.4/sql/sql_union.cc", level = 2147483656, line = -1, prev = 0x7fd2908aa710}
|
trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <vtable for Json_writer_object+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
trace_prepare = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <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 = 0x560108f944f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
tbl = 0x0
|
li = {<base_list_iterator> = {list = 0x7fd280015238, el = 0x5601092be3a0 <end_of_list>, prev = 0x0, current = 0x0}, <No data fields>}
|
real_og_num = 0
|
__PRETTY_FUNCTION__ = "int JOIN::prepare(TABLE_LIST*, uint, COND*, uint, ORDER*, bool, ORDER*, Item*, ORDER*, SELECT_LEX*, SELECT_LEX_UNIT*)"
|
save_place = NO_MATTER
|
with_clause = 0x560108723088 <my_thread_var_dbug+31>
|
with_elem = 0x7fd280000cd0
|
res = 1
|
#20 0x0000560107c34730 in st_select_lex_unit::prepare_join (this=0x7fd280004cc0, thd_arg=0x7fd280000d90, sl=0x7fd280015000, tmp_result=0x0, additional_options=0, is_union_select=false) at /data/src/10.4/sql/sql_union.cc:647
|
_db_stack_frame_ = {func = 0x56010883e931 "st_select_lex_unit::prepare", file = 0x56010883e558 "/data/src/10.4/sql/sql_union.cc", level = 2147483655, line = -1, prev = 0x7fd2908aa830}
|
derived = 0x0
|
can_skip_order_by = false
|
join = 0x7fd280018f00
|
#21 0x0000560107c35df8 in st_select_lex_unit::prepare (this=0x7fd280004cc0, derived_arg=0x0, sel_result=0x0, additional_options=0) at /data/src/10.4/sql/sql_union.cc:994
|
lex_select_save = 0x7fd280015000
|
sl = 0x7fd280015000
|
first_sl = 0x7fd280015000
|
is_recursive = false
|
is_rec_result_table_created = false
|
union_part_count = 0
|
tmp_result = 0x0
|
is_union_select = false
|
have_except = false
|
have_intersect = false
|
instantiate_tmp_table = false
|
single_tvc = false
|
single_tvc_wo_order = false
|
_db_stack_frame_ = {func = 0x5601088408fa "mysql_create_view", file = 0x560108840888 "/data/src/10.4/sql/sql_view.cc", level = 2147483654, line = -1, prev = 0x7fd2908aa990}
|
__PRETTY_FUNCTION__ = "bool st_select_lex_unit::prepare(TABLE_LIST*, select_result*, ulong)"
|
#22 0x0000560107c4794d in mysql_create_view (thd=0x7fd280000d90, views=0x7fd280014930, mode=VIEW_CREATE_NEW) at /data/src/10.4/sql/sql_view.cc:539
|
lex = 0x7fd280004c00
|
link_to_local = true
|
view = 0x7fd280014930
|
tables = 0x7fd2800155f8
|
tbl = 0x0
|
select_lex = 0x7fd280015000
|
sl = 0x7fd200000000
|
unit = 0x7fd280004cc0
|
res = false
|
_db_stack_frame_ = {func = 0x56010881b930 "mysql_execute_command", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7fd2908aac80}
|
__PRETTY_FUNCTION__ = "bool mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode)"
|
#23 0x0000560107b300d2 in mysql_execute_command (thd=0x7fd280000d90) at /data/src/10.4/sql/sql_parse.cc:6007
|
res = 0
|
up_result = 0
|
lex = 0x7fd280004c00
|
select_lex = 0x7fd280015000
|
first_table = 0x7fd280014930
|
all_tables = 0x7fd280014930
|
unit = 0x7fd280004cc0
|
have_table_map_for_update = false
|
rpl_filter = 0x560107f84d49 <inline_mysql_mutex_unlock(mysql_mutex_t*, char const*, uint)+107>
|
_db_stack_frame_ = {func = 0x56010881cbb8 "mysql_parse", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7fd2908ab250}
|
__PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)"
|
ots = {ctx = 0x7fd2800048e0, traceable = false}
|
trace_command = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x560108f94510 <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 = 0x560108f944f0 <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
|
#24 0x0000560107b35e72 in mysql_parse (thd=0x7fd280000d90, rawbuf=0x7fd2800147a8 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", length=96, parser_state=0x7fd2908ab410, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7995
|
found_semicolon = 0x0
|
error = 32722
|
lex = 0x7fd280004c00
|
err = false
|
_db_stack_frame_ = {func = 0x56010881b13a "dispatch_command", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7fd2908ab3f0}
|
__PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)"
|
#25 0x0000560107b22312 in dispatch_command (command=COM_QUERY, thd=0x7fd280000d90, packet=0x7fd28000ac01 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", packet_length=96, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
|
packet_end = 0x7fd280014808 ""
|
parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7fd280000d90, m_ptr = 0x7fd280014809 "\004", m_tok_start = 0x7fd280014809 "\004", m_tok_end = 0x7fd280014809 "\004", m_end_of_query = 0x7fd280014808 "", m_tok_start_prev = 0x7fd280014808 "", m_buf = 0x7fd2800147a8 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", m_buf_length = 96, m_echo = true, m_echo_saved = 12, m_cpp_buf = 0x7fd280014860 "CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)", m_cpp_ptr = 0x7fd2800148c0 "", m_cpp_tok_start = 0x7fd2800148c0 "", m_cpp_tok_start_prev = 0x7fd2800148c0 "", m_cpp_tok_end = 0x7fd2800148c0 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x56010874a6d3 <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: 0x5600), m_cpp_text_start = 0x7fd2800148be "t)", m_cpp_text_end = 0x7fd2800148bf ")", 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 = 0x7fd2800046e0}
|
net = 0x7fd2800010b8
|
error = false
|
do_end_of_statement = true
|
_db_stack_frame_ = {func = 0x56010881aec5 "do_command", file = 0x56010881acc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7fd2908abcb0}
|
drop_more_results = false
|
__PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)"
|
__FUNCTION__ = "dispatch_command"
|
res = <optimized out>
|
#26 0x0000560107b20bc5 in do_command (thd=0x7fd280000d90) at /data/src/10.4/sql/sql_parse.cc:1378
|
return_value = false
|
packet = 0x7fd28000ac00 "\003CREATE VIEW v AS SELECT t1.* FROM t AS t1 JOIN t AS t2 ON t2.a IN (SELECT unknown_column FROM t)"
|
packet_length = 97
|
net = 0x7fd2800010b8
|
command = COM_QUERY
|
_db_stack_frame_ = {func = 0x560108bd6368 "?func", file = 0x560108bd636e "?file", level = 2147483649, line = -1, prev = 0x0}
|
__PRETTY_FUNCTION__ = "bool do_command(THD*)"
|
__FUNCTION__ = "do_command"
|
#27 0x0000560107cafcb1 in do_handle_one_connection (connect=0x56010bc1d460) at /data/src/10.4/sql/sql_connect.cc:1420
|
create_user = true
|
thr_create_utime = 3878760542504
|
thd = 0x7fd280000d90
|
__PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*)"
|
#28 0x0000560107caf959 in handle_one_connection (arg=0x56010bc1d460) at /data/src/10.4/sql/sql_connect.cc:1316
|
connect = 0x56010bc1d460
|
#29 0x00005601081ccc69 in pfs_spawn_thread (arg=0x56010bc94e60) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
typed_arg = 0x56010bc94e60
|
user_arg = 0x56010bc1d460
|
user_start_routine = 0x560107caf929 <handle_one_connection(void*)>
|
pfs = 0x7fd294bd06c0
|
klass = 0x56010b93ec00
|
#30 0x00007fd296da5ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
ret = <optimized out>
|
pd = <optimized out>
|
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140542344873728, -6042312553587541252, 140724509942974, 140724509942975, 140542344871552, 311296, 6016885705157376764, 6016889410557967100}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
|
not_first_call = 0
|
#31 0x00007fd2969a2def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|
cs15r.err