[draft] crash in MDL_lock::reschedule_waiters

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