|
Server version: 10.2.14-MariaDB
|
|
Thread pointer: 0x7fa8380009a8
|
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 = 0x7fa8b027cec8 thread_stack 0x49000
|
/alice/10.2.14/bin/mysqld(my_print_stacktrace+0x2e)[0xddebae]
|
/alice/10.2.14/bin/mysqld(handle_fatal_signal+0x471)[0x7df981]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fa8b29fe390]
|
linux/raise.c:54(__GI_raise)[0x7fa8b1787428]
|
stdlib/abort.c:91(__GI_abort)[0x7fa8b178902a]
|
posix/libc_fatal.c:175(__fsetlocking)[0x7fa8b17c97ea]
|
malloc/malloc.c:4105(_int_free)[0x7fa8b17d237a]
|
malloc/malloc.c:2969(__GI___libc_free)[0x7fa8b17d653c]
|
/alice/10.2.14/bin/mysqld(delete_dynamic+0x1f)[0xdc1ccf]
|
/alice/10.2.14/bin/mysqld(_ZN18QUICK_RANGE_SELECTD0Ev+0x5e)[0x944aae]
|
sql/gcalc_tools.cc:502(Gcalc_result_receiver::add_point(double, double))[0x94435a]
|
sql/sql_list.h:545(List<Buffered_log>::delete_elements())[0x62657f]
|
sql/mysqld.cc:1227(net_after_header_psi(st_net*, void*, unsigned long, char))[0x6269bf]
|
/alice/10.2.14/bin/mysqld(_ZN4JOIN9join_freeEv+0x49)[0x626f49]
|
/alice/10.2.14/bin/mysqld(_ZN4JOIN10exec_innerEv+0xbcf)[0x64fd1f]
|
/alice/10.2.14/bin/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1fc)[0x64e65c]
|
/alice/10.2.14/bin/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x254)[0x650274]
|
/alice/10.2.14/bin/mysqld[0x5e7cf4]
|
/alice/10.2.14/bin/mysqld(_Z21mysql_execute_commandP3THD+0x1327)[0x5eb287]
|
/alice/10.2.14/bin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x4dd)[0x604c5d]
|
/alice/10.2.14/bin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x9e)[0x60a81e]
|
/alice/10.2.14/bin/mysqld[0x60b386]
|
/alice/10.2.14/bin/mysqld(_Z19mysqld_stmt_executeP3THDPcj+0x28)[0x60b4e8]
|
/alice/10.2.14/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x20ad)[0x5f771d]
|
/alice/10.2.14/bin/mysqld(_Z10do_commandP3THD+0x1c2)[0x5f8702]
|
/alice/10.2.14/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x235)[0x6ddc35]
|
/alice/10.2.14/bin/mysqld(handle_one_connection+0x3f)[0x6dddff]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fa8b29f46ba]
|
x86_64/clone.S:111(clone)[0x7fa8b185941d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7fa8380176e0): SELECT COUNT(*) AS AGGREGATE FROM `test`.`t1` WHERE `onsite_consult_id` = ? AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND `test`.`t1`.`deleted_at` IS NULL
|
Connection ID (thread ID): 10
|
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
|
Server version: 10.2.14-MariaDB
|
key_buffer_size=134217728
|
read_buffer_size=131072
|
max_used_connections=2
|
max_threads=153
|
thread_count=8
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467245 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f1a800008c8
|
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 = 0x7f1afc1b4ec8 thread_stack 0x49000
|
/alice/10.2.14/bin/mysqld(my_print_stacktrace+0x2e)[0xddebae]
|
/alice/10.2.14/bin/mysqld(handle_fatal_signal+0x471)[0x7df981]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f1aff2cd390]
|
/alice/10.2.14/bin/mysqld(_ZN8MDL_lock18reschedule_waitersEv+0x99)[0x6e7bb9]
|
/alice/10.2.14/bin/mysqld(_ZN8MDL_lock13remove_ticketEP7LF_PINSMS_NS_11Ticket_listEP10MDL_ticket+0xd4)[0x6e87d4]
|
/alice/10.2.14/bin/mysqld(_ZN11MDL_context27release_transactional_locksEv+0x43)[0x6e8bb3]
|
/alice/10.2.14/bin/mysqld(_Z21mysql_execute_commandP3THD+0x7f3)[0x5ea753]
|
/alice/10.2.14/bin/mysqld(_ZN18Prepared_statement7executeEP6Stringb+0x4dd)[0x604c5d]
|
/alice/10.2.14/bin/mysqld(_ZN18Prepared_statement12execute_loopEP6StringbPhS2_+0x9e)[0x60a81e]
|
/alice/10.2.14/bin/mysqld[0x60b386]
|
/alice/10.2.14/bin/mysqld(_Z19mysqld_stmt_executeP3THDPcj+0x28)[0x60b4e8]
|
/alice/10.2.14/bin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0x20ad)[0x5f771d]
|
/alice/10.2.14/bin/mysqld(_Z10do_commandP3THD+0x1c2)[0x5f8702]
|
/alice/10.2.14/bin/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x235)[0x6ddc35]
|
/alice/10.2.14/bin/mysqld(handle_one_connection+0x3f)[0x6dddff]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f1aff2c36ba]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f1afe12841d]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f1a8002dd20): SELECT COUNT(*) AS AGGREGATE FROM `test`.`t1` WHERE `onsite_consult_id` = ? AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND EXISTS (SELECT * FROM `test`.`t2` WHERE `test`.`t1`.`id` = `test`.`t2`.`focus_id` AND `id` != ? AND `test`.`t2`.`deleted_at` IS NULL) AND `test`.`t1`.`deleted_at` IS NULL
|
Connection ID (thread ID): 17
|
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
|
|