Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.1.21, 10.2.6, 10.1(EOL), 10.2(EOL)
-
None
Description
170712 16:02:48 [ERROR] mysqld got signal 11 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
Server version: 10.2.6-MariaDB
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=19
|
max_threads=153
|
thread_count=25
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467201 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
Thread pointer: 0x7f71080009a8
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f71b0476d70 thread_stack 0x49000
|
/usr/sbin/mysqld(my_print_stacktrace+0x2b)[0x7f71ca7f0a6b]
|
/usr/sbin/mysqld(handle_fatal_signal+0x4d5)[0x7f71ca2880e5]
|
/lib64/libpthread.so.0(+0x3921c0f7e0)[0x7f71c97b47e0]
|
/usr/sbin/mysqld(_ZN4JOIN4execEv+0x1a)[0x7f71ca15d81a]
|
/usr/sbin/mysqld(_ZN24subselect_hash_sj_engine4execEv+0x4a)[0x7f71ca31efca]
|
/usr/sbin/mysqld(_ZN14Item_subselect4execEv+0x5a)[0x7f71ca315faa]
|
/usr/sbin/mysqld(_ZN17Item_in_subselect8val_boolEv+0x3c)[0x7f71ca31581c]
|
/usr/sbin/mysqld(_ZN17Item_in_optimizer7val_intEv+0x16d)[0x7f71ca2bab8d]
|
mysys/stacktrace.c:268(my_print_stacktrace)[0x7f71ca29623a]
|
/usr/sbin/mysqld(_ZN18Item_cache_wrapper5cacheEv+0x33)[0x7f71ca2afcf3]
|
/usr/sbin/mysqld(_ZN18Item_cache_wrapper8val_boolEv+0x58)[0x7f71ca2a5af8]
|
/usr/sbin/mysqld(_ZN13Item_func_not7val_intEv+0x1f)[0x7f71ca2b21af]
|
sql/sql_analyze_stmt.h:97(Time_and_counter_tracker::incr_loops())[0x7f71ca13730d]
|
sql/item_subselect.cc:5396(subselect_hash_sj_engine::exec())[0x7f71ca13f70e]
|
/usr/sbin/mysqld(_ZN4JOIN10exec_innerEv+0x993)[0x7f71ca15d613]
|
sql/item_cmpfunc.cc:1622(Item_in_optimizer::val_int())[0x7f71ca15d83c]
|
/usr/sbin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x12a)[0x7f71ca15c7ba]
|
/usr/sbin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x1d4)[0x7f71ca15da54]
|
sql/item.cc:9460(Item_cache_int::cache_value())[0x7f71ca105066]
|
sql/sql_select.cc:373(sult*, unsigned long))[0x7f71ca10f501]
|
sql/sql_parse.cc:3448(mysql_execute_command(THD*))[0x7f71ca386a6e]
|
sql/sp_head.cc:2997(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x7f71ca38c739]
|
sql/sp_head.cc:3151(sp_instr_stmt::execute(THD*, unsigned int*))[0x7f71ca38cc55]
|
sql/sp_head.cc:1325(sp_head::execute(THD*, bool))[0x7f71ca389b30]
|
sql/sp_head.cc:2112(sp_head::execute_procedure(THD*, List<Item>*))[0x7f71ca38af3e]
|
sql/sql_parse.cc:2883(do_execute_sp)[0x7f71ca104b7d]
|
sql/sql_parse.cc:5797(mysql_execute_command(THD*))[0x7f71ca10b46e]
|
sql/sql_parse.cc:7874(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x7f71ca11258a]
|
sql/sql_parse.cc:1812(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x7f71ca11480d]
|
sql/sql_parse.cc:1364(do_command(THD*))[0x7f71ca114dd1]
|
sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x7f71ca1d099f]
|
sql/sql_connect.cc:1262(handle_one_connection)[0x7f71ca1d0ac4]
|
/lib64/libpthread.so.0(+0x3921c07aa1)[0x7f71c97acaa1]
|
/lib64/libc.so.6(clone+0x6d)[0x7f71c7ec5aad]
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f7108021b90): select * from risk_sod
|
where cport_legal_entity_id not in(select distinct(rca.cport_legal_entity_id) from risk_client_accounts rca)
|
Connection ID (thread ID): 98
|
Status: NOT_KILLED
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
170712 16:02:48 mysqld_safe Number of processes running now: 0
|
170712 16:02:48 mysqld_safe mysqld restarted
|
2017-07-12 16:02:49 140496719788000 [Note] /usr/sbin/mysqld (mysqld 10.2.6-MariaDB) starting as process 17534 ...
|
Attachments
Issue Links
- duplicates
-
MDEV-10972 Insert from select / view / union -- repeatable crash in 10.1, 10.2 Linux/Mac/Windows
-
- Closed
-
- relates to
-
MDEV-13174 Repeatable daemon crash in 10.2.6 on show procedure / select sql_derived.cc:1081
-
- Closed
-
--source include/have_innodb.inc
call pr();
# Cleanup
Note: Most likely it has the same root cause as
MDEV-13174, but the stack trace is somewhat different here, so it makes sense to recheck both when one is fixed.10.2 488f46f3de51070fa91e5eadcc215b6a4e343f7b
#3 <signal handler called>
#4 0x000055c87d7aa4b4 in Time_and_counter_tracker::incr_loops (this=0x80) at /data/src/10.2/sql/sql_analyze_stmt.h:97
#5 0x000055c87d76e70b in JOIN::exec (this=0x7fddd0041188) at /data/src/10.2/sql/sql_select.cc:3277
#6 0x000055c87da64fa7 in subselect_hash_sj_engine::exec (this=0x7fddd004d798) at /data/src/10.2/sql/item_subselect.cc:5419
#7 0x000055c87da56f87 in Item_subselect::exec (this=0x7fddd0035f20) at /data/src/10.2/sql/item_subselect.cc:715
#8 0x000055c87da5759c in Item_in_subselect::exec (this=0x7fddd0035f20) at /data/src/10.2/sql/item_subselect.cc:895
#9 0x000055c87da5a0d3 in Item_in_subselect::val_bool (this=0x7fddd0035f20) at /data/src/10.2/sql/item_subselect.cc:1743
#10 0x000055c87d662c7b in Item::val_bool_result (this=0x7fddd0035f20) at /data/src/10.2/sql/item.h:1182
#11 0x000055c87d9d3b80 in Item_in_optimizer::val_int (this=0x7fddd0043ec0) at /data/src/10.2/sql/item_cmpfunc.cc:1621
#12 0x000055c87d662bef in Item::val_int_result (this=0x7fddd0043ec0) at /data/src/10.2/sql/item.h:1178
#13 0x000055c87d9c1a15 in Item_cache_int::cache_value (this=0x7fddd0051f60) at /data/src/10.2/sql/item.cc:9550
#14 0x000055c87d9cb81e in Item_cache_wrapper::cache (this=0x7fddd0051ea8) at /data/src/10.2/sql/item.cc:8273
#15 0x000055c87d9be290 in Item_cache_wrapper::val_bool (this=0x7fddd0051ea8) at /data/src/10.2/sql/item.cc:8437
#16 0x000055c87d9cfbd0 in Item_func_not::val_int (this=0x7fddd0036160) at /data/src/10.2/sql/item_cmpfunc.cc:284
#17 0x000055c87d795818 in evaluate_join_record (join=0x7fddd0040c20, join_tab=0x7fddd0047708, error=0) at /data/src/10.2/sql/sql_select.cc:18649
#18 0x000055c87d795452 in sub_select (join=0x7fddd0040c20, join_tab=0x7fddd0047708, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18554
#19 0x000055c87d7949eb in do_select (join=0x7fddd0040c20, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18098
#20 0x000055c87d76f299 in JOIN::exec_inner (this=0x7fddd0040c20) at /data/src/10.2/sql/sql_select.cc:3483
#21 0x000055c87d76e748 in JOIN::exec (this=0x7fddd0040c20) at /data/src/10.2/sql/sql_select.cc:3278
#22 0x000055c87d76f911 in mysql_select (thd=0x7fddd0000b00, tables=0x7fddd00352b8, wild_num=1, fields=..., conds=0x7fddd0036160, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147749632, result=0x7fddd0040c00, unit=0x7fddd0036ac0, select_lex=0x7fddd00371f8) at /data/src/10.2/sql/sql_select.cc:3678
#23 0x000055c87d76423c in handle_select (thd=0x7fddd0000b00, lex=0x7fddd00369f8, result=0x7fddd0040c00, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
#24 0x000055c87d73011a in execute_sqlcom_select (thd=0x7fddd0000b00, all_tables=0x7fddd00352b8) at /data/src/10.2/sql/sql_parse.cc:6443
#25 0x000055c87d726159 in mysql_execute_command (thd=0x7fddd0000b00) at /data/src/10.2/sql/sql_parse.cc:3458
#26 0x000055c87db120bc in sp_instr_stmt::exec_core (this=0x7fddd0036228, thd=0x7fddd0000b00, nextp=0x7fde1c3551c4) at /data/src/10.2/sql/sp_head.cc:3235
#27 0x000055c87db1172d in sp_lex_keeper::reset_lex_and_exec_core (this=0x7fddd0036268, thd=0x7fddd0000b00, nextp=0x7fde1c3551c4, open_tables=false, instr=0x7fddd0036228) at /data/src/10.2/sql/sp_head.cc:2998
#28 0x000055c87db11d67 in sp_instr_stmt::execute (this=0x7fddd0036228, thd=0x7fddd0000b00, nextp=0x7fde1c3551c4) at /data/src/10.2/sql/sp_head.cc:3151
#29 0x000055c87db0cfac in sp_head::execute (this=0x7fddd00344d8, thd=0x7fddd0000b00, merge_da_on_success=true) at /data/src/10.2/sql/sp_head.cc:1324
#30 0x000055c87db0f037 in sp_head::execute_procedure (this=0x7fddd00344d8, thd=0x7fddd0000b00, args=0x7fddd00052f8) at /data/src/10.2/sql/sp_head.cc:2113
#31 0x000055c87d72483e in do_execute_sp (thd=0x7fddd0000b00, sp=0x7fddd00344d8) at /data/src/10.2/sql/sql_parse.cc:2889
#32 0x000055c87d72d8f4 in mysql_execute_command (thd=0x7fddd0000b00) at /data/src/10.2/sql/sql_parse.cc:5799
#33 0x000055c87d733ada in mysql_parse (thd=0x7fddd0000b00, rawbuf=0x7fddd0012378 "call pr()", length=9, parser_state=0x7fde1c356200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7879
#34 0x000055c87d721b86 in dispatch_command (command=COM_QUERY, thd=0x7fddd0000b00, packet=0x7fddd013e9e1 "", packet_length=9, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1817
#35 0x000055c87d7204c7 in do_command (thd=0x7fddd0000b00) at /data/src/10.2/sql/sql_parse.cc:1362
#36 0x000055c87d86c259 in do_handle_one_connection (connect=0x55c880efeee0) at /data/src/10.2/sql/sql_connect.cc:1354
#37 0x000055c87d86bfe6 in handle_one_connection (arg=0x55c880efeee0) at /data/src/10.2/sql/sql_connect.cc:1260
#38 0x000055c87dc86300 in pfs_spawn_thread (arg=0x55c880e49f20) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#39 0x00007fde26630494 in start_thread (arg=0x7fde1c357700) at pthread_create.c:333
#40 0x00007fde247a893f in clone () from /lib/x86_64-linux-gnu/libc.so.6
10.1 56959e7b2ce621980bad1445a0a659c2b0fb4c83
#3 <signal handler called>
#4 0x0000561b551f50fa in Time_and_counter_tracker::incr_loops (this=0x78) at /data/src/10.1/sql/sql_analyze_stmt.h:97
#5 0x0000561b551b813b in JOIN::exec (this=0x7f3d3b22a7c0) at /data/src/10.1/sql/sql_select.cc:2510
#6 0x0000561b55461c51 in subselect_hash_sj_engine::exec (this=0x7f3d3b234bd0) at /data/src/10.1/sql/item_subselect.cc:5399
#7 0x0000561b55454d25 in Item_subselect::exec (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item_subselect.cc:710
#8 0x0000561b554552c6 in Item_in_subselect::exec (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item_subselect.cc:888
#9 0x0000561b55457a73 in Item_in_subselect::val_bool (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item_subselect.cc:1734
#10 0x0000561b550c2c25 in Item::val_bool_result (this=0x7f3d3b12fbd0) at /data/src/10.1/sql/item.h:1038
#11 0x0000561b553e91d8 in Item_in_optimizer::val_int (this=0x7f3d3b22d7a0) at /data/src/10.1/sql/item_cmpfunc.cc:1634
#12 0x0000561b550c2b99 in Item::val_int_result (this=0x7f3d3b22d7a0) at /data/src/10.1/sql/item.h:1034
#13 0x0000561b553db205 in Item_cache_int::cache_value (this=0x7f3d3b28b520) at /data/src/10.1/sql/item.cc:8891
#14 0x0000561b553e2d60 in Item_cache_wrapper::cache (this=0x7f3d3b28b470) at /data/src/10.1/sql/item.cc:7738
#15 0x0000561b553d83f8 in Item_cache_wrapper::val_bool (this=0x7f3d3b28b470) at /data/src/10.1/sql/item.cc:7902
#16 0x0000561b553e5322 in Item_func_not::val_int (this=0x7f3d3b12fdc8) at /data/src/10.1/sql/item_cmpfunc.cc:284
#17 0x0000561b551e1005 in evaluate_join_record (join=0x7f3d3b22a228, join_tab=0x7f3d3b2306c8, error=0) at /data/src/10.1/sql/sql_select.cc:18497
#18 0x0000561b551e0c2f in sub_select (join=0x7f3d3b22a228, join_tab=0x7f3d3b2306c8, end_of_records=false) at /data/src/10.1/sql/sql_select.cc:18398
#19 0x0000561b551e0492 in do_select (join=0x7f3d3b22a228, fields=0x7f3d3b12e968, table=0x0, procedure=0x0) at /data/src/10.1/sql/sql_select.cc:18053
#20 0x0000561b551baf00 in JOIN::exec_inner (this=0x7f3d3b22a228) at /data/src/10.1/sql/sql_select.cc:3225
#21 0x0000561b551b8191 in JOIN::exec (this=0x7f3d3b22a228) at /data/src/10.1/sql/sql_select.cc:2512
#22 0x0000561b551bb727 in mysql_select (thd=0x7f3d473c7070, rref_pointer_array=0x7f3d3b12eae0, tables=0x7f3d3b131e90, wild_num=1, fields=..., conds=0x7f3d3b12fdc8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147749632, result=0x7f3d3b22a208, unit=0x7f3d3b12e150, select_lex=0x7f3d3b12e850) at /data/src/10.1/sql/sql_select.cc:3449
#23 0x0000561b551b114c in handle_select (thd=0x7f3d473c7070, lex=0x7f3d3b12e088, result=0x7f3d3b22a208, setup_tables_done_option=0) at /data/src/10.1/sql/sql_select.cc:384
#24 0x0000561b55180ff6 in execute_sqlcom_select (thd=0x7f3d473c7070, all_tables=0x7f3d3b131e90) at /data/src/10.1/sql/sql_parse.cc:5923
#25 0x0000561b551774f2 in mysql_execute_command (thd=0x7f3d473c7070) at /data/src/10.1/sql/sql_parse.cc:2980
#26 0x0000561b55503e9a in sp_instr_stmt::exec_core (this=0x7f3d3b12fe88, thd=0x7f3d473c7070, nextp=0x7f3d52df9624) at /data/src/10.1/sql/sp_head.cc:3212
#27 0x0000561b5550358c in sp_lex_keeper::reset_lex_and_exec_core (this=0x7f3d3b12fec8, thd=0x7f3d473c7070, nextp=0x7f3d52df9624, open_tables=false, instr=0x7f3d3b12fe88) at /data/src/10.1/sql/sp_head.cc:2978
#28 0x0000561b55503b60 in sp_instr_stmt::execute (this=0x7f3d3b12fe88, thd=0x7f3d473c7070, nextp=0x7f3d52df9624) at /data/src/10.1/sql/sp_head.cc:3128
#29 0x0000561b554ff426 in sp_head::execute (this=0x7f3d3b131088, thd=0x7f3d473c7070, merge_da_on_success=true) at /data/src/10.1/sql/sp_head.cc:1316
#30 0x0000561b555012c0 in sp_head::execute_procedure (this=0x7f3d3b131088, thd=0x7f3d473c7070, args=0x7f3d473cb728) at /data/src/10.1/sql/sp_head.cc:2103
#31 0x0000561b55175bed in do_execute_sp (thd=0x7f3d473c7070, sp=0x7f3d3b131088) at /data/src/10.1/sql/sql_parse.cc:2412
#32 0x0000561b5517eb00 in mysql_execute_command (thd=0x7f3d473c7070) at /data/src/10.1/sql/sql_parse.cc:5285
#33 0x0000561b55184701 in mysql_parse (thd=0x7f3d473c7070, rawbuf=0x7f3d3b0fa088 "call pr()", length=9, parser_state=0x7f3d52dfa5e0) at /data/src/10.1/sql/sql_parse.cc:7339
#34 0x0000561b551736ec in dispatch_command (command=COM_QUERY, thd=0x7f3d473c7070, packet=0x7f3d49321071 "", packet_length=9) at /data/src/10.1/sql/sql_parse.cc:1490
#35 0x0000561b5517244b in do_command (thd=0x7f3d473c7070) at /data/src/10.1/sql/sql_parse.cc:1109
#36 0x0000561b552a9fb5 in do_handle_one_connection (thd_arg=0x7f3d473c7070) at /data/src/10.1/sql/sql_connect.cc:1349
#37 0x0000561b552a9d19 in handle_one_connection (arg=0x7f3d473c7070) at /data/src/10.1/sql/sql_connect.cc:1261
#38 0x0000561b55660bda in pfs_spawn_thread (arg=0x7f3d492ea970) at /data/src/10.1/storage/perfschema/pfs.cc:1860
#39 0x00007f3d52a8a494 in start_thread (arg=0x7f3d52dfbb00) at pthread_create.c:333
#40 0x00007f3d50bd593f in clone () from /lib/x86_64-linux-gnu/libc.so.6