mysqld: /data/src/10.4/sql/item.h:1347: virtual bool Item::val_native(THD*, Native*): Assertion `0' failed.
|
220704 14:54:31 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f598c556662 in __GI___assert_fail (assertion=0x558ad9ed7587 "0", file=0x558ad9ed74f3 "/data/src/10.4/sql/item.h", line=1347, function=0x558ad9ed7648 "virtual bool Item::val_native(THD*, Native*)") at assert.c:101
|
No locals.
|
#8 0x0000558ad90ee8fc in Item::val_native (this=0x7f597425ad48, thd=0x7f5974000d90, to=0x7f5974016dc8) at /data/src/10.4/sql/item.h:1347
|
__PRETTY_FUNCTION__ = "virtual bool Item::val_native(THD*, Native*)"
|
#9 0x0000558ad9650104 in Arg_comparator::min_max_update_field_native (this=0x7f5974016d00, thd=0x7f5974000d90, field=0x7f5974259ca0, item=0x7f597425ad48, cmp_sign=-1) at /data/src/10.4/sql/item_sum.cc:3118
|
_db_stack_frame_ = {func = 0x558ada0c9378 "Item_sum_min_max::min_max_update_native_field", file = 0x558ada0c83d8 "/data/src/10.4/sql/item_sum.cc", level = 2147483663, line = -1, prev = 0x7f5986526fe0}
|
#10 0x0000558ad96503be in Item_sum_min_max::min_max_update_native_field (this=0x7f5974014f20) at /data/src/10.4/sql/item_sum.cc:3141
|
_db_stack_frame_ = {func = 0x558ada0c9328 "Item_sum_min_max::update_field", file = 0x558ada0c83d8 "/data/src/10.4/sql/item_sum.cc", level = 2147483662, line = -1, prev = 0x7f5986527040}
|
__PRETTY_FUNCTION__ = "void Item_sum_min_max::min_max_update_native_field()"
|
thd = 0x7f5974000d90
|
#11 0x0000558ad964ffbb in Item_sum_min_max::update_field (this=0x7f5974014f20) at /data/src/10.4/sql/item_sum.cc:3084
|
_db_stack_frame_ = {func = 0x558ad9f17b6a "end_update", file = 0x558ad9f13fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483661, line = -1, prev = 0x7f59865270f0}
|
tmp_item = 0x7f5974014e10
|
#12 0x0000558ad92a1bcf in update_tmptable_sum_func (func_ptr=0x7f5974016e78, tmp_table=0x7f5974258328) at /data/src/10.4/sql/sql_select.cc:25701
|
func = 0x7f5974014f20
|
#13 0x0000558ad9298a27 in end_update (join=0x7f5974016438, join_tab=0x7f5974017e38, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:22164
|
table = 0x7f5974258328
|
group = 0x0
|
error = 21898
|
_db_stack_frame_ = {func = 0x558ad9f17657 "sub_select_aggr_tab", file = 0x558ad9f13fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483660, line = -1, prev = 0x7f59865271b0}
|
#14 0x0000558ad92ab864 in AGGR_OP::put_record (this=0x7f5974018830, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:28967
|
rc = 21898
|
#15 0x0000558ad92b1a21 in AGGR_OP::put_record (this=0x7f5974018830) at /data/src/10.4/sql/sql_select.h:1054
|
No locals.
|
#16 0x0000558ad929439a in sub_select_postjoin_aggr (join=0x7f5974016438, join_tab=0x7f5974017e38, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20367
|
rc = 32601
|
aggr = 0x7f5974018830
|
__PRETTY_FUNCTION__ = "enum_nested_loop_state sub_select_postjoin_aggr(JOIN*, JOIN_TAB*, bool)"
|
_db_stack_frame_ = {func = 0x558ad9f176eb "evaluate_join_record", file = 0x558ad9f13fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483659, line = -1, prev = 0x7f5986527260}
|
#17 0x0000558ad929509a in evaluate_join_record (join=0x7f5974016438, join_tab=0x7f5974017a90, error=0) at /data/src/10.4/sql/sql_select.cc:20874
|
rc = NESTED_LOOP_OK
|
found = true
|
return_tab = 0x7f5974017a90
|
shortcut_for_distinct = false
|
found_records = 2
|
select_cond = 0x0
|
select_cond_result = true
|
_db_stack_frame_ = {func = 0x558ad9f176e0 "sub_select", file = 0x558ad9f13fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483658, line = -1, prev = 0x7f5986527300}
|
#18 0x0000558ad9294aac in sub_select (join=0x7f5974016438, join_tab=0x7f5974017a90, end_of_records=false) at /data/src/10.4/sql/sql_select.cc:20686
|
_db_stack_frame_ = {func = 0x558ad9f17500 "do_select", file = 0x558ad9f13fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483657, line = -1, prev = 0x7f59865273a0}
|
error = 0
|
rc = NESTED_LOOP_OK
|
info = 0x7f5974017b58
|
skip_over = false
|
#19 0x0000558ad9293d65 in do_select (join=0x7f5974016438, procedure=0x0) at /data/src/10.4/sql/sql_select.cc:20183
|
join_tab = 0x7f5974017a90
|
rc = 0
|
error = NESTED_LOOP_OK
|
_db_stack_frame_ = {func = 0x558ad9f15019 "JOIN::exec_inner", file = 0x558ad9f13fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483656, line = -1, prev = 0x7f5986527400}
|
__PRETTY_FUNCTION__ = "int do_select(JOIN*, Procedure*)"
|
#20 0x0000558ad926868a in JOIN::exec_inner (this=0x7f5974016438) at /data/src/10.4/sql/sql_select.cc:4545
|
columns_list = 0x7f59740149a0
|
_db_stack_frame_ = {func = 0x558ad9f150f7 "mysql_select", file = 0x558ad9f13fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483655, line = -1, prev = 0x7f5986527540}
|
__PRETTY_FUNCTION__ = "void JOIN::exec_inner()"
|
trace_wrapper = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x558ada680510 <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 = 0x558ada680510 <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 = 0x558ada6804f0 <vtable for Json_writer_array+16>, my_writer = 0x0, context = {writer = 0x0}, closed = false}, <No data fields>}
|
#21 0x0000558ad926779a in JOIN::exec (this=0x7f5974016438) at /data/src/10.4/sql/sql_select.cc:4327
|
No locals.
|
#22 0x0000558ad9268f14 in mysql_select (thd=0x7f5974000d90, tables=0x7f59740150e8, wild_num=0, fields=@0x7f59740149a0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x7f5974014df8, last = 0x7f5974015078, elements = 2}, <No data fields>}, conds=0x0, og_num=1, order=0x0, group=0x7f59740158e0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5974016410, unit=0x7f5974004cc0, select_lex=0x7f5974014858) at /data/src/10.4/sql/sql_select.cc:4766
|
err = 0
|
free_join = true
|
_db_stack_frame_ = {func = 0x558ad9f14098 "handle_select", file = 0x558ad9f13fb0 "/data/src/10.4/sql/sql_select.cc", level = 2147483654, line = -1, prev = 0x7f5986527600}
|
join = 0x7f5974016438
|
#23 0x0000558ad9258802 in handle_select (thd=0x7f5974000d90, lex=0x7f5974004c00, result=0x7f5974016410, setup_tables_done_option=0) at /data/src/10.4/sql/sql_select.cc:436
|
unit = 0x7f5974004cc0
|
res = false
|
select_lex = 0x7f5974014858
|
_db_stack_frame_ = {func = 0x558ad9f07930 "mysql_execute_command", file = 0x558ad9f06cc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483653, line = -1, prev = 0x7f5986527c80}
|
#24 0x0000558ad921deee in execute_sqlcom_select (thd=0x7f5974000d90, all_tables=0x7f59740150e8) at /data/src/10.4/sql/sql_parse.cc:6449
|
save_protocol = 0x0
|
lex = 0x7f5974004c00
|
result = 0x7f5974016410
|
res = false
|
__PRETTY_FUNCTION__ = "bool execute_sqlcom_select(THD*, TABLE_LIST*)"
|
#25 0x0000558ad921470e in mysql_execute_command (thd=0x7f5974000d90) at /data/src/10.4/sql/sql_parse.cc:3963
|
privileges_requested = 1
|
res = 0
|
up_result = 0
|
lex = 0x7f5974004c00
|
select_lex = 0x7f5974014858
|
first_table = 0x7f59740150e8
|
all_tables = 0x7f59740150e8
|
unit = 0x7f5974004cc0
|
have_table_map_for_update = false
|
rpl_filter = 0x558ad9670d49 <inline_mysql_mutex_unlock(mysql_mutex_t*, char const*, uint)+107>
|
_db_stack_frame_ = {func = 0x558ad9f08bb8 "mysql_parse", file = 0x558ad9f06cc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483652, line = -1, prev = 0x7f5986528250}
|
__PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)"
|
ots = {ctx = 0x7f59740048e0, traceable = false}
|
trace_command = {<Json_writer_struct> = {_vptr.Json_writer_struct = 0x558ada680510 <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 = 0x558ada6804f0 <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
|
#26 0x0000558ad9221e72 in mysql_parse (thd=0x7f5974000d90, rawbuf=0x7f59740147a8 "SELECT b, MAX(a) FROM t_spider GROUP BY b", length=41, parser_state=0x7f5986528410, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7995
|
found_semicolon = 0x0
|
error = 32601
|
lex = 0x7f5974004c00
|
err = false
|
_db_stack_frame_ = {func = 0x558ad9f0713a "dispatch_command", file = 0x558ad9f06cc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483651, line = -1, prev = 0x7f59865283f0}
|
__PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*, bool, bool)"
|
#27 0x0000558ad920e312 in dispatch_command (command=COM_QUERY, thd=0x7f5974000d90, packet=0x7f597400ac01 "", packet_length=41, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
|
packet_end = 0x7f59740147d1 ""
|
parser_state = {m_lip = {lookahead_token = -1, lookahead_yylval = 0x0, m_thd = 0x7f5974000d90, m_ptr = 0x7f59740147d2 "\004", m_tok_start = 0x7f59740147d2 "\004", m_tok_end = 0x7f59740147d2 "\004", m_end_of_query = 0x7f59740147d1 "", m_tok_start_prev = 0x7f59740147d1 "", m_buf = 0x7f59740147a8 "SELECT b, MAX(a) FROM t_spider GROUP BY b", m_buf_length = 41, m_echo = true, m_echo_saved = 12, m_cpp_buf = 0x7f5974014828 "SELECT b, MAX(a) FROM t_spider GROUP BY b", m_cpp_ptr = 0x7f5974014851 "", m_cpp_tok_start = 0x7f5974014851 "", m_cpp_tok_start_prev = 0x7f5974014851 "", m_cpp_tok_end = 0x7f5974014851 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x558ad9e3664f <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 = (DISCARD_COMMENT | unknown: 0x5588), m_cpp_text_start = 0x7f5974014850 "b", m_cpp_text_end = 0x7f5974014851 "", 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 = 0x7f59740046e0}
|
net = 0x7f59740010b8
|
error = false
|
do_end_of_statement = true
|
_db_stack_frame_ = {func = 0x558ad9f06ec5 "do_command", file = 0x558ad9f06cc8 "/data/src/10.4/sql/sql_parse.cc", level = 2147483650, line = -1, prev = 0x7f5986528cb0}
|
drop_more_results = false
|
__PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint, bool, bool)"
|
__FUNCTION__ = "dispatch_command"
|
res = <optimized out>
|
#28 0x0000558ad920cbc5 in do_command (thd=0x7f5974000d90) at /data/src/10.4/sql/sql_parse.cc:1378
|
return_value = false
|
packet = 0x7f597400ac00 "\001"
|
packet_length = 42
|
net = 0x7f59740010b8
|
command = COM_QUERY
|
_db_stack_frame_ = {func = 0x558ada2c2368 "?func", file = 0x558ada2c236e "?file", level = 2147483649, line = -1, prev = 0x0}
|
__PRETTY_FUNCTION__ = "bool do_command(THD*)"
|
__FUNCTION__ = "do_command"
|
#29 0x0000558ad939bcb1 in do_handle_one_connection (connect=0x558adbae3680) at /data/src/10.4/sql/sql_connect.cc:1420
|
create_user = true
|
thr_create_utime = 3357782916951
|
thd = 0x7f5974000d90
|
__PRETTY_FUNCTION__ = "void do_handle_one_connection(CONNECT*)"
|
#30 0x0000558ad939b959 in handle_one_connection (arg=0x558adbae3680) at /data/src/10.4/sql/sql_connect.cc:1316
|
connect = 0x558adbae3680
|
#31 0x0000558ad98b8c69 in pfs_spawn_thread (arg=0x558adbb5b080) at /data/src/10.4/storage/perfschema/pfs.cc:1869
|
typed_arg = 0x558adbb5b080
|
user_arg = 0x558adbae3680
|
user_start_routine = 0x558ad939b929 <handle_one_connection(void*)>
|
pfs = 0x7f598a84d6c0
|
klass = 0x558adb804c00
|
#32 0x00007f598ca22ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
|
ret = <optimized out>
|
pd = <optimized out>
|
unwind_buf = {cancel_jmp_buf = {{jmp_buf = {140022482376448, -4508013413641608295, 140731783681246, 140731783681247, 140022482374272, 311296, 4594618343833609113, 4594596219298784153}, mask_was_saved = 0}}, priv = {pad = {0x0, 0x0, 0x0, 0x0}, data = {prev = 0x0, cleanup = 0x0, canceltype = 0}}}
|
not_first_call = 0
|
#33 0x00007f598c61fdef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
|