170823 12:38:19 [ERROR] mysqld got signal 11 ;

Server version: 10.2.9-MariaDB

key_buffer_size=134217728

read_buffer_size=131072

max_used_connections=1

max_threads=153

thread_count=7

It is possible that mysqld could use up to 

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 467265 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7f2e880009a8

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 = 0x7f2ee90a0e98 thread_stack 0x49000

/home/alice/AM/m8-10.2/build/sql//mysqld(my_print_stacktrace+0x29)[0x55f42bc50b49]

/home/alice/AM/m8-10.2/build/sql//mysqld(handle_fatal_signal+0x305)[0x55f42b74a155]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f2effc1e390]

/home/alice/AM/m8-10.2/build/sql//mysqld(_Z45fix_semijoin_strategies_for_picked_join_orderP4JOIN+0x89)[0x55f42b6bf289]

mysys/stacktrace.c:268(my_print_stacktrace)[0x55f42b5f553b]

sql/opt_subselect.cc:3453(fix_semijoin_strategies_for_picked_join_order(JOIN*))[0x55f42b60e003]

sql/sql_select.cc:8859(JOIN::get_best_combination())[0x55f42b6132b2]

sql/sql_select.cc:1086(JOIN::optimize())[0x55f42b61617a]

sql/sql_select.cc:3664(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55f42b618250]

sql/sql_select.cc:24924(mysql_explain_union(THD*, st_select_lex_unit*, select_result*))[0x55f42b61857e]

sql/sql_parse.cc:6388(execute_sqlcom_select(THD*, TABLE_LIST*) [clone .constprop.192])[0x55f42b5bf64b]

sql/sql_parse.cc:3460(mysql_execute_command(THD*))[0x55f42b5cb8f2]

sql/sql_parse.cc:7886(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55f42b5ce5dd]

sql/sql_parse.cc:1812(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55f42b5d11c9]

sql/sql_parse.cc:1362(do_command(THD*))[0x55f42b5d1a4f]

sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x55f42b68e594]

sql/sql_connect.cc:1262(handle_one_connection)[0x55f42b68e704]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f2effc146ba]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f2eff0a93dd]

Version: '10.2.9-MariaDB-debug-log'  socket: '/data/bld/10.2/mysql-test/var/tmp/mysqld.1.sock'  port: 16020  Source distribution

mysqld: /home/alice/git/10.2/sql/sql_select.cc:7368: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.

170823 13:45:03 [ERROR] mysqld got signal 6 ;

Server version: 10.2.9-MariaDB-debug-log

key_buffer_size=1048576

read_buffer_size=131072

max_used_connections=1

max_threads=153

thread_count=7

It is possible that mysqld could use up to 

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63146 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x7fd44c000a98

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 = 0x7fd4a4541e70 thread_stack 0x49000

/data/bld/10.2/bin/mysqld(my_print_stacktrace+0x38)[0x563d2315976b]

/data/bld/10.2/bin/mysqld(handle_fatal_signal+0x3a3)[0x563d229e625e]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fd4ac525390]

/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7fd4ab8de428]

/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7fd4ab8e002a]

mysys/stacktrace.c:267(my_print_stacktrace)[0x7fd4ab8d6bd7]

sql/signal_handler.cc:168(handle_fatal_signal)[0x7fd4ab8d6c82]

sql/sql_select.cc:7370(greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int))[0x563d227cd07e]

sql/sql_select.cc:6938(choose_plan(JOIN*, unsigned long long))[0x563d227cc551]

sql/sql_select.cc:4428(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x563d227c55e7]

sql/sql_select.cc:1509(JOIN::optimize_inner())[0x563d227bb070]

sql/sql_select.cc:1085(JOIN::optimize())[0x563d227b989d]

sql/sql_select.cc:3664(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x563d227c288e]

sql/sql_select.cc:24924(mysql_explain_union(THD*, st_select_lex_unit*, select_result*))[0x563d227f8b03]

sql/sql_parse.cc:6385(execute_sqlcom_select(THD*, TABLE_LIST*))[0x563d22782df1]

sql/sql_parse.cc:3460(mysql_execute_command(THD*))[0x563d22778eb1]

sql/sql_parse.cc:7886(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x563d22786b29]

sql/sql_parse.cc:1814(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x563d2277484b]

sql/sql_parse.cc:1360(do_command(THD*))[0x563d227731be]

sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x563d228bfb66]

sql/sql_connect.cc:1261(handle_one_connection)[0x563d228bf8e6]

perfschema/pfs.cc:1864(pfs_spawn_thread)[0x563d22c19f9a]

/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fd4ac51b6ba]

/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7fd4ab9b03dd]

Thread 1 (Thread 0x7f4eac0c3700 (LWP 21570)):

#0  __pthread_kill (threadid=<optimized out>, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62

#1  0x000055ec7f7d485d in my_write_core (sig=6) at /home/alice/git/10.2/mysys/stacktrace.c:477

#2  0x000055ec7f0615fd in handle_fatal_signal (sig=6) at /home/alice/git/10.2/sql/signal_handler.cc:299

#3  <signal handler called>

#4  0x00007f4eb21f7428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54

#5  0x00007f4eb21f902a in __GI_abort () at abort.c:89

#6  0x00007f4eb21efbd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55ec7f872678 "join->best_read < double(1.79769313486231570815e+308L)", file=file@entry=0x55ec7f871ac8 "/home/alice/git/10.2/sql/sql_select.cc", line=line@entry=7368, function=function@entry=0x55ec7f874920 <greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int)::__PRETTY_FUNCTION__> "bool greedy_search(JOIN*, table_map, uint, uint, uint)") at assert.c:92

#7  0x00007f4eb21efc82 in __GI___assert_fail (assertion=0x55ec7f872678 "join->best_read < double(1.79769313486231570815e+308L)", file=0x55ec7f871ac8 "/home/alice/git/10.2/sql/sql_select.cc", line=7368, function=0x55ec7f874920 <greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int)::__PRETTY_FUNCTION__> "bool greedy_search(JOIN*, table_map, uint, uint, uint)") at assert.c:101

#8  0x000055ec7ee4807e in greedy_search (join=0x7f4e5cedea20, remaining_tables=144115188075855871, search_depth=62, prune_level=1, use_cond_selectivity=1) at /home/alice/git/10.2/sql/sql_select.cc:7368

#9  0x000055ec7ee47551 in choose_plan (join=0x7f4e5cedea20, join_tables=144115188075855871) at /home/alice/git/10.2/sql/sql_select.cc:6938

#10 0x000055ec7ee405e7 in make_join_statistics (join=0x7f4e5cedea20, tables_list=..., keyuse_array=0x7f4e5ceded40) at /home/alice/git/10.2/sql/sql_select.cc:4428

#11 0x000055ec7ee36070 in JOIN::optimize_inner (this=0x7f4e5cedea20) at /home/alice/git/10.2/sql/sql_select.cc:1509

#12 0x000055ec7ee3489d in JOIN::optimize (this=0x7f4e5cedea20) at /home/alice/git/10.2/sql/sql_select.cc:1085

#13 0x000055ec7ee3d88e in mysql_select (thd=0x7f4e5c000a98, tables=0x7f4e5c033160, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748612, result=0x7f4e5ceddfd0, unit=0x7f4e5c004638, select_lex=0x7f4e5c004d90) at /home/alice/git/10.2/sql/sql_select.cc:3664

#14 0x000055ec7ee73b03 in mysql_explain_union (thd=0x7f4e5c000a98, unit=0x7f4e5c004638, result=0x7f4e5ceddfd0) at /home/alice/git/10.2/sql/sql_select.cc:24924

#15 0x000055ec7edfddf1 in execute_sqlcom_select (thd=0x7f4e5c000a98, all_tables=0x7f4e5c033160) at /home/alice/git/10.2/sql/sql_parse.cc:6385

#16 0x000055ec7edf3eb1 in mysql_execute_command (thd=0x7f4e5c000a98) at /home/alice/git/10.2/sql/sql_parse.cc:3460

#17 0x000055ec7ee01b29 in mysql_parse (thd=0x7f4e5c000a98, rawbuf=0x7f4e5c19d6c0 "explain \nSELECT asd_user.name\nFROM asd_user \nJOIN\n(\nSELECT \nt1.id,\nt1.name,\nt1.abv1,\nIFNULL(c1.score, 0)+ IF(c1.score = 25, 30, 0) + IF(c1.score = 25, 120, 0) score \nFROM\n(\nSELECT\nasd_user.id,\nasd_use"..., length=89440, parser_state=0x7f4eac0c21f0, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:7886

#18 0x000055ec7edef84b in dispatch_command (command=COM_QUERY, thd=0x7f4e5c000a98, packet=0x7f4e5c187689 "", packet_length=89440, is_com_multi=false, is_next_command=false) at /home/alice/git/10.2/sql/sql_parse.cc:1812

#19 0x000055ec7edee1be in do_command (thd=0x7f4e5c000a98) at /home/alice/git/10.2/sql/sql_parse.cc:1360

#20 0x000055ec7ef3ab66 in do_handle_one_connection (connect=0x55ec83065b48) at /home/alice/git/10.2/sql/sql_connect.cc:1354

#21 0x000055ec7ef3a8e6 in handle_one_connection (arg=0x55ec83065b48) at /home/alice/git/10.2/sql/sql_connect.cc:1260

#22 0x000055ec7f294f9a in pfs_spawn_thread (arg=0x55ec82fdb908) at /home/alice/git/10.2/storage/perfschema/pfs.cc:1862

#23 0x00007f4eb2e346ba in start_thread (arg=0x7f4eac0c3700) at pthread_create.c:333

#24 0x00007f4eb22c93dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

# NOTE: This test case has an advantage of finishing in reasonable time,

#       because it has join conditions.

#       NATURAL JOIN as such is irrelevant here, it is just to avoid explicit ON clauses

--source include/have_innodb.inc

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (id INT) ENGINE=InnoDB;

INSERT INTO t1 VALUES 

(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),

(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),

(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),

(31),(32),(33),(34),(35),(36),(37),(38),(39),(40),

(41),(42),(43),(44),(45),(46),(47),(48),(49),(50);

DROP TABLE IF EXISTS t2;

CREATE TABLE t2 (id INT) ENGINE=InnoDB;

INSERT INTO t2 VALUES (1),(2);

DROP TABLE IF EXISTS t3;

CREATE TABLE t3 (id INT) ENGINE=InnoDB;

INSERT INTO t3 VALUES (1),(2);

ANALYZE TABLE t1, t2, t3;

SELECT * FROM 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_1

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_2 

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_3 

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_4 

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_5 

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_6 

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_7

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_8

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_9

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_10

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_11

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_12

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_13

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_14

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_15

INNER JOIN 

(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL JOIN t1 p4 NATURAL JOIN t2 r4 NATURAL JOIN t3 d4 NATURAL JOIN t1 p5 NATURAL JOIN t2 r5 NATURAL JOIN t3 d5 NATURAL JOIN t1 p6 NATURAL JOIN t2 r6 NATURAL JOIN t3 d6 NATURAL JOIN t1 p7 NATURAL JOIN t2 r7 NATURAL JOIN t3 d7 NATURAL JOIN t1 p8 NATURAL JOIN t2 r8 NATURAL JOIN t3 d8 NATURAL JOIN t1 p9 ) gp_16

;

mysqld: /data/src/10.2/sql/sql_select.cc:7368: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion 

`join->best_read < double(1.79769313486231570815e+308L)' failed.

170824 20:32:41 [ERROR] mysqld got signal 6 ;

#7  0x00007fbd70a3bee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6

#8  0x0000563f40e1ee92 in greedy_search (join=0x7fbd1c268328, remaining_tables=1099511627775, search_depth=62, prune_level=1, use_cond_selectivity=1) at /data/src/10.2/sql/sql_select.cc:7368

#9  0x0000563f40e1e350 in choose_plan (join=0x7fbd1c268328, join_tables=1099511627775) at /data/src/10.2/sql/sql_select.cc:6938

#10 0x0000563f40e17246 in make_join_statistics (join=0x7fbd1c268328, tables_list=..., keyuse_array=0x7fbd1c268618) at /data/src/10.2/sql/sql_select.cc:4428

#11 0x0000563f40e0cdb4 in JOIN::optimize_inner (this=0x7fbd1c268328) at /data/src/10.2/sql/sql_select.cc:1509

#12 0x0000563f40e0b5b9 in JOIN::optimize (this=0x7fbd1c268328) at /data/src/10.2/sql/sql_select.cc:1085

#13 0x0000563f40e1452c in mysql_select (thd=0x7fbd1c000b00, tables=0x7fbd1c07f300, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fbd1c268308, unit=0x7fbd1c0046a0, select_lex=0x7fbd1c004dd8) at /data/src/10.2/sql/sql_select.cc:3664

#14 0x0000563f40e08eea in handle_select (thd=0x7fbd1c000b00, lex=0x7fbd1c0045d8, result=0x7fbd1c268308, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373

#15 0x0000563f40dd4da0 in execute_sqlcom_select (thd=0x7fbd1c000b00, all_tables=0x7fbd1c07f300) at /data/src/10.2/sql/sql_parse.cc:6446

#16 0x0000563f40dcada0 in mysql_execute_command (thd=0x7fbd1c000b00) at /data/src/10.2/sql/sql_parse.cc:3460

#17 0x0000563f40dd8762 in mysql_parse (thd=0x7fbd1c000b00, rawbuf=0x7fbd1c012428 "SELECT * FROM \n(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL J"..., length=8027, parser_state=0x7fbd64094200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7886

#18 0x0000563f40dc676d in dispatch_command (command=COM_QUERY, thd=0x7fbd1c000b00, packet=0x7fbd1c13ea91 "SELECT * FROM \n(SELECT p1.* FROM t1 p1 NATURAL JOIN t2 r1 NATURAL JOIN t3 d1 NATURAL JOIN t1 p2 NATURAL JOIN t2 r2 NATURAL JOIN t3 d2 NATURAL JOIN t1 p3 NATURAL JOIN t2 r3 NATURAL JOIN t3 d3 NATURAL J"..., packet_length=8028, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812

#19 0x0000563f40dc50e7 in do_command (thd=0x7fbd1c000b00) at /data/src/10.2/sql/sql_parse.cc:1360

#20 0x0000563f40f11a53 in do_handle_one_connection (connect=0x563f43a157d0) at /data/src/10.2/sql/sql_connect.cc:1354

#21 0x0000563f40f117e0 in handle_one_connection (arg=0x563f43a157d0) at /data/src/10.2/sql/sql_connect.cc:1260

#22 0x0000563f4132d8e0 in pfs_spawn_thread (arg=0x563f43a1fd40) at /data/src/10.2/storage/perfschema/pfs.cc:1862

#23 0x00007fbd72980494 in start_thread (arg=0x7fbd64095700) at pthread_create.c:333

#24 0x00007fbd70af893f in clone () from /lib/x86_64-linux-gnu/libc.so.6

# NOTE: It is shorter than test case 1 due to using comma instead of NATURAL JOIN,

#      but it will run forever if it doesn't crash

--source include/have_innodb.inc

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (id INT) ENGINE=InnoDB;

INSERT INTO t1 VALUES 

(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),

(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),

(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),

(31),(32),(33),(34),(35),(36),(37),(38),(39),(40),

(41),(42),(43),(44),(45),(46),(47),(48),(49),(50);

DROP TABLE IF EXISTS t2;

CREATE TABLE t2 (id INT) ENGINE=InnoDB;

INSERT INTO t2 VALUES (1),(2);

DROP TABLE IF EXISTS t3;

CREATE TABLE t3 (id INT) ENGINE=InnoDB;

INSERT INTO t3 VALUES (1),(2);

ANALYZE TABLE t1, t2, t3;

SELECT * FROM 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_1

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_2 

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_3 

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_4 

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_5 

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_6 

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_7

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_8

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_9

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_10

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_11

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_12

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_13

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_14

INNER JOIN

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_15

INNER JOIN 

(SELECT p1.* FROM t1 p1, t2 r1, t3 d1, t1 p2, t2 r2, t3 d2, t1 p3, t2 r3, t3 d3, t1 p4, t2 r4, t3 d4, t1 p5, t2 r5, t3 d5, t1 p6, t2 r6, t3 d6, t1 p7, t2 r7, t3 d7, t1 p8, t2 r8, t3 d8, t1 p9 ) gp_16

;

MariaDB [(none)]> show processlist\G

*************************** 1. row ***************************

      Id: 3

    User: root

    Host: localhost

      db: test

 Command: Query

    Time: 632

   State: statistics

    Info: SELECT asd_user.name, IFNULL(gp_1.score, 0) AS gp_1_score, IFNULL(gp_2.score, 0) AS gp_2_score, IFNU

Progress: 0.000

Thread 28 (Thread 0x7f79d5464700 (LWP 30039)):

#0  0x00007f79d310974d in poll () at ../sysdeps/unix/syscall-template.S:84

#1  0x000055d7116241d3 in vio_io_wait (vio=0x7f79bf3a3bf0, event=VIO_IO_EVENT_READ, timeout=28800000) at /git/10.1/src/vio/viosocket.c:992

#2  0x000055d711622a3f in vio_socket_io_wait (vio=0x7f79bf3a3bf0, event=VIO_IO_EVENT_READ) at /git/10.1/src/vio/viosocket.c:108

#3  0x000055d711622bf2 in vio_read (vio=0x7f79bf3a3bf0, buf=0x7f79a32ac070 "\001", size=4) at /git/10.1/src/vio/viosocket.c:184

#4  0x000055d710c65406 in my_real_read (net=0x7f79a32a6330, complen=0x7f79d5463800, header=1 '\001') at /git/10.1/src/sql/net_serv.cc:877

#5  0x000055d710c65b9a in my_net_read_packet (net=0x7f79a32a6330, read_from_server=1 '\001') at /git/10.1/src/sql/net_serv.cc:1140

#6  0x000055d710d2072a in do_command (thd=0x7f79a32a6070) at /git/10.1/src/sql/sql_parse.cc:1002

#7  0x000055d710e5cd49 in do_handle_one_connection (thd_arg=0x7f79a32a6070) at /git/10.1/src/sql/sql_connect.cc:1330

#8  0x000055d710e5ca98 in handle_one_connection (arg=0x7f79a32a6070) at /git/10.1/src/sql/sql_connect.cc:1242

#9  0x00007f79d3a6a6ba in start_thread (arg=0x7f79d5464700) at pthread_create.c:333

#10 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 27 (Thread 0x7f79d54ae700 (LWP 29957)):

#0  0x000055d7115c7a7f in my_thread_var_dbug () at /git/10.1/src/mysys/my_thr_init.c:444

#1  0x000055d7115e8432 in code_state () at /git/10.1/src/dbug/dbug.c:350

#2  0x000055d7115ea74f in _db_enter_ (_func_=0x55d711687b0c "best_access_path", _file_=0x55d711686f48 "/git/10.1/src/sql/sql_select.cc", _line_=5948, _stack_frame_=0x7f79d54a6af0) at /git/10.1/src/dbug/dbug.c:1101

#3  0x000055d710d71c35 in best_access_path (join=0x7f79a3d327e8, s=0x7f79a31dd5b0, remaining_tables=2032, idx=34, disable_jbuf=false, record_count=9765625, pos=0x7f79a31e1580, loose_scan_pos=0x7f79d54a6c70) at /git/10.1/src/sql/sql_select.cc:5948

#4  0x000055d710d768e9 in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2032, idx=34, record_count=9765625, read_time=65273670.200000003, search_depth=28, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7925

#5  0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2040, idx=33, record_count=9765625, read_time=53554920.200000003, search_depth=29, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#6  0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2044, idx=32, record_count=9765625, read_time=41836170.200000003, search_depth=30, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#7  0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2046, idx=31, record_count=9765625, read_time=30117420.199999999, search_depth=31, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#8  0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=33556478, idx=30, record_count=9765625, read_time=28164290.199999999, search_depth=32, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#9  0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=50333694, idx=29, record_count=9765625, read_time=16445540.199999999, search_depth=33, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#10 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099561961470, idx=28, record_count=9765625, read_time=14492410.199999999, search_depth=34, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#11 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099830396926, idx=27, record_count=9765625, read_time=12539280.199999999, search_depth=35, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#12 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099830921214, idx=26, record_count=9765625, read_time=10586150.199999999, search_depth=36, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#13 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099839309822, idx=25, record_count=1953125, read_time=8607945.1999999993, search_depth=37, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#14 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099839571966, idx=24, record_count=1953125, read_time=6264195.2000000002, search_depth=38, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#15 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1099973789694, idx=23, record_count=1953125, read_time=3920445.2000000002, search_depth=39, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#16 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649729603582, idx=22, record_count=1953125, read_time=1576695.2, search_depth=40, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#17 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649733797886, idx=21, record_count=1953125, read_time=1186065.2, search_depth=41, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#18 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649733928958, idx=20, record_count=390625, read_time=790736.19999999995, search_depth=42, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#19 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649736026110, idx=19, record_count=390625, read_time=321986.20000000001, search_depth=43, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#20 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649803134974, idx=18, record_count=78125, read_time=242946.20000000001, search_depth=44, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#21 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1649803200510, idx=17, record_count=78125, read_time=227316.20000000001, search_depth=45, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#22 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1666983069694, idx=16, record_count=78125, read_time=211686.20000000001, search_depth=46, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#23 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1675573004286, idx=15, record_count=78125, read_time=117936.2, search_depth=47, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#24 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1675573037054, idx=14, record_count=78125, read_time=24186.200000000001, search_depth=48, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#25 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1675573053438, idx=13, record_count=15625, read_time=8390.2000000000007, search_depth=49, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#26 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1950450960382, idx=12, record_count=3125, read_time=5229.1999999999998, search_depth=50, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#27 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1950450968574, idx=11, record_count=3125, read_time=4599.1999999999998, search_depth=51, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#28 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1950450972670, idx=10, record_count=3125, read_time=849.20000000000005, search_depth=52, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#29 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1950452021246, idx=9, record_count=625, read_time=215.19999999999999, search_depth=53, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#30 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1954746988542, idx=8, record_count=125, read_time=87.200000000000003, search_depth=54, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#31 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=1954746990590, idx=7, record_count=25, read_time=61.200000000000003, search_depth=55, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#32 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2092185944062, idx=6, record_count=25, read_time=51.200000000000003, search_depth=56, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#33 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2160905420798, idx=5, record_count=25, read_time=21.199999999999999, search_depth=57, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#34 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2195265159166, idx=4, record_count=5, read_time=15.199999999999999, search_depth=58, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#35 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2197412642814, idx=3, record_count=5, read_time=9.1999999999999993, search_depth=59, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#36 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2198486384638, idx=2, record_count=5, read_time=3.2000000000000002, search_depth=60, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#37 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2199023255550, idx=1, record_count=1, read_time=1.2, search_depth=61, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#38 0x000055d710d76dcc in best_extension_by_limited_search (join=0x7f79a3d327e8, remaining_tables=2199023255551, idx=0, record_count=1, read_time=0, search_depth=62, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7996

#39 0x000055d710d74f1a in greedy_search (join=0x7f79a3d327e8, remaining_tables=2199023255551, search_depth=62, prune_level=1, use_cond_selectivity=1) at /git/10.1/src/sql/sql_select.cc:7159

#40 0x000055d710d7446b in choose_plan (join=0x7f79a3d327e8, join_tables=2199023255551) at /git/10.1/src/sql/sql_select.cc:6736

#41 0x000055d710d6d9f3 in make_join_statistics (join=0x7f79a3d327e8, tables_list=..., keyuse_array=0x7f79a3d32b28) at /git/10.1/src/sql/sql_select.cc:4247

#42 0x000055d710d636d6 in JOIN::optimize_inner (this=0x7f79a3d327e8) at /git/10.1/src/sql/sql_select.cc:1403

#43 0x000055d710d623b0 in JOIN::optimize (this=0x7f79a3d327e8) at /git/10.1/src/sql/sql_select.cc:1058

#44 0x000055d710d6ad17 in mysql_select (thd=0x7f79bf3f7070, rref_pointer_array=0x7f79ae0acd50, tables=0x7f79ae107c60, wild_num=0, fields=..., conds=0x0, og_num=11, order=0x7f79ae112a90, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7f79a3d326f0, unit=0x7f79ae0ace38, select_lex=0x7f79ae0acaa8) at /git/10.1/src/sql/sql_select.cc:3485

#45 0x000055d710cfb23f in mysql_derived_fill (thd=0x7f79bf3f7070, lex=0x7f79bf3faaf0, derived=0x7f79ae113ea8) at /git/10.1/src/sql/sql_derived.cc:955

#46 0x000055d710cfa009 in mysql_derived_merge (thd=0x7f79bf3f7070, lex=0x7f79bf3faaf0, derived=0x7f79ae113ea8) at /git/10.1/src/sql/sql_derived.cc:464

#47 0x000055d710cf9912 in mysql_handle_single_derived (lex=0x7f79bf3faaf0, derived=0x7f79ae113ea8, phases=8) at /git/10.1/src/sql/sql_derived.cc:196

#48 0x000055d710e2413a in TABLE_LIST::handle_derived (this=0x7f79ae113ea8, lex=0x7f79bf3faaf0, phases=8) at /git/10.1/src/sql/table.cc:7218

#49 0x000055d710d0e0de in LEX::handle_list_of_derived (this=0x7f79bf3faaf0, table_list=0x7f79ae0abe38, phases=8) at /git/10.1/src/sql/sql_lex.h:3026

#50 0x000055d710d1864a in st_select_lex::handle_derived (this=0x7f79bf3fb2b8, lex=0x7f79bf3faaf0, phases=8) at /git/10.1/src/sql/sql_lex.cc:3854

#51 0x000055d710d62634 in JOIN::optimize_inner (this=0x7f79a3d2d7d8) at /git/10.1/src/sql/sql_select.cc:1110

#52 0x000055d710d623b0 in JOIN::optimize (this=0x7f79a3d2d7d8) at /git/10.1/src/sql/sql_select.cc:1058

#53 0x000055d710d6ad17 in mysql_select (thd=0x7f79bf3f7070, rref_pointer_array=0x7f79bf3fb560, tables=0x7f79ae0abe38, wild_num=0, fields=..., conds=0x0, og_num=11, order=0x7f79a3d26300, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f79a3d2d7b8, unit=0x7f79bf3fabb8, select_lex=0x7f79bf3fb2b8) at /git/10.1/src/sql/sql_select.cc:3485

#54 0x000055d710d60487 in handle_select (thd=0x7f79bf3f7070, lex=0x7f79bf3faaf0, result=0x7f79a3d2d7b8, setup_tables_done_option=0) at /git/10.1/src/sql/sql_select.cc:388

#55 0x000055d710d2fc92 in execute_sqlcom_select (thd=0x7f79bf3f7070, all_tables=0x7f79ae0abe38) at /git/10.1/src/sql/sql_parse.cc:5951

#56 0x000055d710d25fe0 in mysql_execute_command (thd=0x7f79bf3f7070) at /git/10.1/src/sql/sql_parse.cc:3038

#57 0x000055d710d338e3 in mysql_parse (thd=0x7f79bf3f7070, rawbuf=0x7f79ae02d088 "SELECT asd_user.name, IFNULL(gp_1.score, 0) AS gp_1_score, IFNULL(gp_2.score, 0) AS gp_2_score, IFNULL(gp_3.score, 0) AS gp_3_score, IFNULL(gp_4.score, 0) AS gp_4_score, IFNULL(gp_5.score, 0) AS gp_5_"..., length=140919, parser_state=0x7f79d54ad0b0) at /git/10.1/src/sql/sql_parse.cc:7469

#58 0x000055d710d21f70 in dispatch_command (command=COM_QUERY, thd=0x7f79bf3f7070, packet=0x7f79ae009071 "SELECT asd_user.name, IFNULL(gp_1.score, 0) AS gp_1_score, IFNULL(gp_2.score, 0) AS gp_2_score, IFNULL(gp_3.score, 0) AS gp_3_score, IFNULL(gp_4.score, 0) AS gp_4_score, IFNULL(gp_5.score, 0) AS gp_5_"..., packet_length=140919) at /git/10.1/src/sql/sql_parse.cc:1499

#59 0x000055d710d20cf2 in do_command (thd=0x7f79bf3f7070) at /git/10.1/src/sql/sql_parse.cc:1131

#60 0x000055d710e5cd49 in do_handle_one_connection (thd_arg=0x7f79bf3f7070) at /git/10.1/src/sql/sql_connect.cc:1330

#61 0x000055d710e5ca98 in handle_one_connection (arg=0x7f79bf3f7070) at /git/10.1/src/sql/sql_connect.cc:1242

#62 0x00007f79d3a6a6ba in start_thread (arg=0x7f79d54ae700) at pthread_create.c:333

#63 0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 26 (Thread 0x7f79d54f8700 (LWP 29949)):

#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185

#1  0x000055d7115cf18d in safe_cond_wait (cond=0x55d711ffcac0 <COND_slave_background>, mp=0x55d711fffb80 <LOCK_slave_background>, file=0x55d711660ee0 "/git/10.1/src/include/mysql/psi/mysql_thread.h", line=1165) at /git/10.1/src/mysys/thr_mutex.c:493

#2  0x000055d710c79846 in inline_mysql_cond_wait (that=0x55d711ffcac0 <COND_slave_background>, mutex=0x55d711fffb80 <LOCK_slave_background>, src_file=0x55d711661790 "/git/10.1/src/sql/slave.cc", src_line=336) at /git/10.1/src/include/mysql/psi/mysql_thread.h:1165

#3  0x000055d710c7a536 in handle_slave_background (arg=0x0) at /git/10.1/src/sql/slave.cc:336

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79d54f8700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 25 (Thread 0x7f79d5542700 (LWP 29948)):

#0  do_sigwait (sig=0x7f79d5541ca0, set=<optimized out>) at ../sysdeps/unix/sysv/linux/sigwait.c:64

#1  __sigwait (set=<optimized out>, sig=0x7f79d5541ca0) at ../sysdeps/unix/sysv/linux/sigwait.c:96

#2  0x000055d710c56a6f in signal_hand (arg=0x0) at /git/10.1/src/sql/mysqld.cc:3408

#3  0x00007f79d3a6a6ba in start_thread (arg=0x7f79d5542700) at pthread_create.c:333

#4  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 24 (Thread 0x7f79a63fe700 (LWP 29947)):

#0  0x00007f79d310b5d3 in select () at ../sysdeps/unix/syscall-template.S:84

#1  0x000055d7113011a1 in os_thread_sleep (tm=1000000) at /git/10.1/src/storage/xtradb/os/os0thread.cc:307

#2  0x000055d71144e2ba in btr_defragment_thread () at /git/10.1/src/storage/xtradb/btr/btr0defragment.cc:708

#3  0x00007f79d3a6a6ba in start_thread (arg=0x7f79a63fe700) at pthread_create.c:333

#4  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 23 (Thread 0x7f79a6bff700 (LWP 29946)):

#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185

#1  0x000055d7113005bf in os_cond_wait (cond=0x7f79d1b5b2e8, fast_mutex=0x7f79d1b5b2b0) at /git/10.1/src/storage/xtradb/os/os0sync.cc:196

#2  0x000055d71130092d in os_event_wait_low (event=0x7f79d1b5b2b0, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:477

#3  0x000055d711468272 in buf_dump_thread () at /git/10.1/src/storage/xtradb/buf/buf0dump.cc:731

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79a6bff700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 22 (Thread 0x7f79a7fff700 (LWP 29945)):

#0  0x00007f79d310b5d3 in select () at ../sysdeps/unix/syscall-template.S:84

#1  0x000055d7113011a1 in os_thread_sleep (tm=1000000) at /git/10.1/src/storage/xtradb/os/os0thread.cc:307

#2  0x000055d7114709e0 in page_cleaner_sleep_if_needed (next_loop_time=1558080728612) at /git/10.1/src/storage/xtradb/buf/buf0flu.cc:2678

#3  0x000055d71147135f in buf_flush_lru_manager_thread (arg=0x0) at /git/10.1/src/storage/xtradb/buf/buf0flu.cc:2979

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79a7fff700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 21 (Thread 0x7f79acffe700 (LWP 29944)):

#0  0x00007f79d310b5d3 in select () at ../sysdeps/unix/syscall-template.S:84

#1  0x000055d7113011a1 in os_thread_sleep (tm=1000000) at /git/10.1/src/storage/xtradb/os/os0thread.cc:307

#2  0x000055d7114709e0 in page_cleaner_sleep_if_needed (next_loop_time=1558080728618) at /git/10.1/src/storage/xtradb/buf/buf0flu.cc:2678

#3  0x000055d711470d31 in buf_flush_page_cleaner_thread (arg=0x0) at /git/10.1/src/storage/xtradb/buf/buf0flu.cc:2819

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79acffe700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 20 (Thread 0x7f79a9ff8700 (LWP 29943)):

#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185

#1  0x000055d7113005bf in os_cond_wait (cond=0x7f79d1b5b198, fast_mutex=0x7f79d1b5b160) at /git/10.1/src/storage/xtradb/os/os0sync.cc:196

#2  0x000055d71130092d in os_event_wait_low (event=0x7f79d1b5b160, reset_sig_count=13) at /git/10.1/src/storage/xtradb/os/os0sync.cc:477

#3  0x000055d7113be296 in srv_resume_thread (slot=0x55d712859018 <srv_sys+536>, sig_count=13, wait=true, timeout_usec=0) at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:1082

#4  0x000055d7113c36af in srv_purge_coordinator_suspend (slot=0x55d712859018 <srv_sys+536>, rseg_history_len=129) at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:3492

#5  0x000055d7113c3a61 in srv_purge_coordinator_thread (arg=0x0) at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:3583

#6  0x00007f79d3a6a6ba in start_thread (arg=0x7f79a9ff8700) at pthread_create.c:333

#7  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 19 (Thread 0x7f79aa7f9700 (LWP 29942)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5cd98, fast_mutex=0x7f79d1b5cd60, abstime=0x7f79aa7f8c60) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159

#2  0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5cd60, time_in_usec=5000000, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591

#3  0x000055d7114093a5 in ib_wqueue_timedwait (wq=0x7f79d185fd78, wait_in_usecs=5000000) at /git/10.1/src/storage/xtradb/ut/ut0wqueue.cc:155

#4  0x000055d71150b6fa in fts_optimize_thread (arg=0x7f79d185fd78) at /git/10.1/src/storage/xtradb/fts/fts0opt.cc:2908

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79aa7f9700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 18 (Thread 0x7f79aaffa700 (LWP 29941)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5c7e8, fast_mutex=0x7f79d1b5c7b0, abstime=0x7f79aaff9d10) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159

#2  0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5c7b0, time_in_usec=10000000, reset_sig_count=2) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591

#3  0x000055d7114bf433 in dict_stats_thread () at /git/10.1/src/storage/xtradb/dict/dict0stats_bg.cc:534

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79aaffa700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 17 (Thread 0x7f79ab7fb700 (LWP 29940)):

#0  0x00007f79d310b5d3 in select () at ../sysdeps/unix/syscall-template.S:84

#1  0x000055d7113011a1 in os_thread_sleep (tm=1000000) at /git/10.1/src/storage/xtradb/os/os0thread.cc:307

#2  0x000055d7113c2b04 in srv_master_sleep () at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:3116

#3  0x000055d7113c2c48 in srv_master_thread (arg=0x0) at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:3166

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79ab7fb700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 16 (Thread 0x7f79abffc700 (LWP 29939)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5b208, fast_mutex=0x7f79d1b5b1d0, abstime=0x7f79abffbcb0) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159

#2  0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5b1d0, time_in_usec=1000000, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591

#3  0x000055d7113c139c in srv_error_monitor_thread () at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:2424

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79abffc700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 15 (Thread 0x7f79ac7fd700 (LWP 29938)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5c548, fast_mutex=0x7f79d1b5c510, abstime=0x7f79ac7fccf0) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159

#2  0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5c510, time_in_usec=1000000, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591

#3  0x000055d7112cf2c9 in lock_wait_timeout_thread () at /git/10.1/src/storage/xtradb/lock/lock0wait.cc:597

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79ac7fd700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 14 (Thread 0x7f79ad7ff700 (LWP 29936)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x000055d7113004d7 in os_cond_wait_timed (cond=0x7f79d1b5b278, fast_mutex=0x7f79d1b5b240, abstime=0x7f79ad7fecc0) at /git/10.1/src/storage/xtradb/os/os0sync.cc:159

#2  0x000055d711300ad8 in os_event_wait_time_low (event=0x7f79d1b5b240, time_in_usec=5000000, reset_sig_count=1) at /git/10.1/src/storage/xtradb/os/os0sync.cc:591

#3  0x000055d7113c0d6e in srv_monitor_thread () at /git/10.1/src/storage/xtradb/srv/srv0srv.cc:2183

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79ad7ff700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 13 (Thread 0x7f79aeff6700 (LWP 29935)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881260, segment=3, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=9, message1=0x7f79aeff5cc0, message2=0x7f79aeff5cc8, type=0x7f79aeff5cd0, space_id=0x7f79aeff5cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=9) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d768 <n+72>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79aeff6700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 12 (Thread 0x7f79af7f7700 (LWP 29934)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881260, segment=2, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=8, message1=0x7f79af7f6cc0, message2=0x7f79af7f6cc8, type=0x7f79af7f6cd0, space_id=0x7f79af7f6cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=8) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d760 <n+64>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79af7f7700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 11 (Thread 0x7f79afff8700 (LWP 29933)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881260, segment=1, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=7, message1=0x7f79afff7cc0, message2=0x7f79afff7cc8, type=0x7f79afff7cd0, space_id=0x7f79afff7cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=7) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d758 <n+56>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79afff8700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 10 (Thread 0x7f79b07f9700 (LWP 29932)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881260, segment=0, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=6, message1=0x7f79b07f8cc0, message2=0x7f79b07f8cc8, type=0x7f79b07f8cd0, space_id=0x7f79b07f8cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=6) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d750 <n+48>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79b07f9700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 9 (Thread 0x7f79b0ffa700 (LWP 29931)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881140, segment=3, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=5, message1=0x7f79b0ff9cc0, message2=0x7f79b0ff9cc8, type=0x7f79b0ff9cd0, space_id=0x7f79b0ff9cd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=5) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d748 <n+40>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79b0ffa700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 8 (Thread 0x7f79b17fb700 (LWP 29930)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881140, segment=2, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=4, message1=0x7f79b17facc0, message2=0x7f79b17facc8, type=0x7f79b17facd0, space_id=0x7f79b17facd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=4) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d740 <n+32>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79b17fb700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 7 (Thread 0x7f79b1ffc700 (LWP 29929)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881140, segment=1, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=3, message1=0x7f79b1ffbcc0, message2=0x7f79b1ffbcc8, type=0x7f79b1ffbcd0, space_id=0x7f79b1ffbcd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=3) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d738 <n+24>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79b1ffc700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 6 (Thread 0x7f79b27fd700 (LWP 29928)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881140, segment=0, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=2, message1=0x7f79b27fccc0, message2=0x7f79b27fccc8, type=0x7f79b27fccd0, space_id=0x7f79b27fccd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=2) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d730 <n+16>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79b27fd700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 5 (Thread 0x7f79b2ffe700 (LWP 29927)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d18811a0, segment=0, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=1, message1=0x7f79b2ffdcc0, message2=0x7f79b2ffdcc8, type=0x7f79b2ffdcd0, space_id=0x7f79b2ffdcd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=1) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d728 <n+8>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79b2ffe700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 4 (Thread 0x7f79b37ff700 (LWP 29926)):

#0  0x00007f79d4bbb64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1

#1  0x000055d7112fd707 in os_aio_linux_collect (array=0x7f79d1881200, segment=0, seg_size=256) at /git/10.1/src/storage/xtradb/os/os0file.cc:5618

#2  0x000055d7112fdacd in os_aio_linux_handle (global_seg=0, message1=0x7f79b37fecc0, message2=0x7f79b37fecc8, type=0x7f79b37fecd0, space_id=0x7f79b37fecd8) at /git/10.1/src/storage/xtradb/os/os0file.cc:5772

#3  0x000055d7114d3885 in fil_aio_wait (segment=0) at /git/10.1/src/storage/xtradb/fil/fil0fil.cc:6262

#4  0x000055d7113c5b0b in io_handler_thread (arg=0x55d71285d720 <n>) at /git/10.1/src/storage/xtradb/srv/srv0start.cc:585

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79b37ff700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 3 (Thread 0x7f79befff700 (LWP 29925)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x000055d7115cf497 in safe_cond_timedwait (cond=0x55d71282b8a0 <COND_checkpoint>, mp=0x55d71282b7e0 <LOCK_checkpoint>, abstime=0x7f79beffec90, file=0x55d711786320 "/git/10.1/src/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/src/mysys/thr_mutex.c:547

#2  0x000055d71116bf62 in inline_mysql_cond_timedwait (that=0x55d71282b8a0 <COND_checkpoint>, mutex=0x55d71282b7e0 <LOCK_checkpoint>, abstime=0x7f79beffec90, src_file=0x55d711786360 "/git/10.1/src/storage/maria/ma_servicethread.c", src_line=116) at /git/10.1/src/include/mysql/psi/mysql_thread.h:1202

#3  0x000055d71116c3f9 in my_service_thread_sleep (control=0x55d711e34b20 <checkpoint_control>, sleep_time=30000000000) at /git/10.1/src/storage/maria/ma_servicethread.c:115

#4  0x000055d711160d47 in ma_checkpoint_background (arg=0x1e) at /git/10.1/src/storage/maria/ma_checkpoint.c:708

#5  0x00007f79d3a6a6ba in start_thread (arg=0x7f79befff700) at pthread_create.c:333

#6  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 2 (Thread 0x7f79d0fbf700 (LWP 29924)):

#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225

#1  0x000055d7115cf497 in safe_cond_timedwait (cond=0x55d71287ff40 <COND_timer>, mp=0x55d71287fe80 <LOCK_timer>, abstime=0x7f79d0fbed40, file=0x55d711869030 "/git/10.1/src/include/mysql/psi/mysql_thread.h", line=1202) at /git/10.1/src/mysys/thr_mutex.c:547

#2  0x000055d7115d0437 in inline_mysql_cond_timedwait (that=0x55d71287ff40 <COND_timer>, mutex=0x55d71287fe80 <LOCK_timer>, abstime=0x7f79d0fbed40, src_file=0x55d711869070 "/git/10.1/src/mysys/thr_timer.c", src_line=292) at /git/10.1/src/include/mysql/psi/mysql_thread.h:1202

#3  0x000055d7115d0ee5 in timer_handler (arg=0x0) at /git/10.1/src/mysys/thr_timer.c:292

#4  0x00007f79d3a6a6ba in start_thread (arg=0x7f79d0fbf700) at pthread_create.c:333

#5  0x00007f79d311541d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 1 (Thread 0x7f79d555e900 (LWP 29920)):

#0  0x00007f79d310974d in poll () at ../sysdeps/unix/syscall-template.S:84

#1  0x000055d710c5c88d in handle_connections_sockets () at /git/10.1/src/sql/mysqld.cc:6548

#2  0x000055d710c5b838 in mysqld_main (argc=11, argv=0x7f79d180f640) at /git/10.1/src/sql/mysqld.cc:5973

#3  0x000055d710c50810 in main (argc=3, argv=0x7ffd17dd3ae8) at /git/10.1/src/sql/main.cc:25

mysqld: /home/igor/maria-git/5.5/sql/sql_select.cc:6666: bool greedy_search(JOIN*, table_map, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.