gistfile1.txt

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
main.range 'innodb_plugin'               [ fail ]
        Test ended at 2016-11-02 01:14:37

CURRENT_TEST: main.range
mysqltest: At line 36: query 'select event_date,type,event_id from t1 WHERE event_date >= "1999-07-01" AND event_date < "1999-07-15" AND (type=100600 OR type=100100) ORDER BY event_date' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
);
INSERT INTO t1 VALUES ('1999-07-10',100100,24), ('1999-07-11',100100,25),
('1999-07-13',100600,0), ('1999-07-13',100600,4), ('1999-07-13',100600,26),
('1999-07-14',100600,10), ('1999-07-15',100600,16), ('1999-07-15',100800,45),
('1999-07-15',101000,47), ('1999-07-16',100800,46), ('1999-07-20',100600,5),
('1999-07-20',100600,27), ('1999-07-21',100600,11), ('1999-07-22',100600,17),
('1999-07-23',100100,39), ('1999-07-24',100100,39), ('1999-07-24',100500,40),
('1999-07-25',100100,39), ('1999-07-27',100600,1), ('1999-07-27',100600,6),
('1999-07-27',100600,28), ('1999-07-28',100600,12), ('1999-07-29',100500,41),
('1999-07-29',100600,18), ('1999-07-30',100500,41), ('1999-07-31',100500,41),
('1999-08-01',100700,34), ('1999-08-03',100600,7), ('1999-08-03',100600,29),
('1999-08-04',100600,13), ('1999-08-05',100500,42), ('1999-08-05',100600,19),
('1999-08-06',100500,42), ('1999-08-07',100500,42), ('1999-08-08',100500,42),
('1999-08-10',100600,2), ('1999-08-10',100600,9), ('1999-08-10',100600,30),
('1999-08-11',100600,14), ('1999-08-12',100600,20), ('1999-08-17',100500,8),
('1999-08-17',100600,31), ('1999-08-18',100600,15), ('1999-08-19',100600,22),
('1999-08-24',100600,3), ('1999-08-24',100600,32), ('1999-08-27',100500,43),
('1999-08-31',100600,33), ('1999-09-17',100100,37), ('1999-09-18',100100,37),
('1999-09-19',100100,37), ('2000-12-18',100700,38);
select event_date,type,event_id from t1 WHERE event_date >= "1999-07-01" AND event_date < "1999-07-15" AND (type=100600 OR type=100100) ORDER BY event_date;

More results from queries before failure can be found in /home/psergey/dev-git/10.2-look-hf/mysql-test/var/log/range.log


Server [mysqld.1 - pid: 29254, winpid: 29254, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
...


stack_bottom = 0x7fda301c2a30 thread_stack 0x48c00
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(my_print_stacktrace+0x38)[0x7fda2fad1a9d]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(handle_fatal_signal+0x3a8)[0x7fda2f45c4d3]
/lib/x86_64-linux-gnu/libpthread.so.0(+0x10d10)[0x7fda2d195d10]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(+0x4e3a9e)[0x7fda2f19da9e]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_ZN13List_iteratorI10SEL_IMERGEEppEi+0x1b)[0x7fda2f5b2ff3]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(+0x8d6cb8)[0x7fda2f590cb8]
mysys/stacktrace.c:267(my_print_stacktrace)[0x7fda2f5a15fc]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_ZN13Item_cond_and11get_mm_treeEP15RANGE_OPT_PARAMPP4Item+0xd4)[0x7fda2f59f27e]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_ZN10SQL_SELECT17test_quick_selectEP3THD6BitmapILj64EEyybbb+0xb83)[0x7fda2f594317]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(+0x598f67)[0x7fda2f252f67]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(+0x59b3c9)[0x7fda2f2553c9]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_ZN4JOIN14optimize_innerEv+0x1328)[0x7fda2f24bbca]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_ZN4JOIN8optimizeEv+0x3e)[0x7fda2f24a69e]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_Z12mysql_selectP3THDP10TABLE_LISTjR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x265)[0x7fda2f252cea]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_Z13handle_selectP3THDP3LEXP13select_resultm+0x15f)[0x7fda2f2481fb]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(+0x55dc44)[0x7fda2f217c44]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_Z21mysql_execute_commandP3THD+0x180e)[0x7fda2f20da7a]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_statebb+0x29a)[0x7fda2f21b411]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcjbb+0xf2e)[0x7fda2f2097d1]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_Z10do_commandP3THD+0x763)[0x7fda2f208202]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(_Z24do_handle_one_connectionP7CONNECT+0x1bd)[0x7fda2f3443be]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(handle_one_connection+0x30)[0x7fda2f34414b]
/home/psergey/dev-git/10.2-look-hf/sql/mysqld(+0xdb844a)[0x7fda2fa7244a]
sql/sql_list.h:452(base_list_iterator::next())[0x7fda2d18c6aa]
sql/sql_list.h:561(List_iterator<SEL_IMERGE>::operator++(int))[0x7fda2c8aaeed]

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0x7fda16864088): select event_date,type,event_id from t1 WHERE event_date >= "1999-07-01" AND event_date < "1999-07-15" AND (type=100600 OR type=100100) ORDER BY event_date
Connection ID (thread ID): 3
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=off,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.
Writing a core file
----------SERVER LOG END-------------


 - saving '/home/psergey/dev-git/10.2-look-hf/mysql-test/var/log/main.range-innodb_plugin/' to '/home/psergey/dev-git/10.2-look-hf/mysql-test/var/log/main.range-innodb_plugin/'
 - found 'core' (0/5)

Trying 'dbx' to get a backtrace

Trying 'gdb' to get a backtrace
Core generated by '/home/psergey/dev-git/10.2-look-hf/sql/mysqld'
Output from gdb follows. The first stack trace is from the failing thread.
The following stack traces are from all threads (so the failing one is
duplicated).
--------------------------
[New LWP 29279]
[New LWP 29261]
[New LWP 29262]
[New LWP 29257]
[New LWP 29256]
[New LWP 29263]
[New LWP 29267]
[New LWP 29265]
[New LWP 29271]
[New LWP 29269]
[New LWP 29266]
[New LWP 29272]
[New LWP 29274]
[New LWP 29273]
[New LWP 29268]
[New LWP 29260]
[New LWP 29275]
[New LWP 29270]
[New LWP 29276]
[New LWP 29258]
[New LWP 29259]
[New LWP 29255]
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1".
Core was generated by `/home/psergey/dev-git/10.2-look-hf/sql/mysqld --defaults-group-suffix=.1 --defa'.
Program terminated with signal SIGSEGV, Segmentation fault.
#0  __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
62      ../sysdeps/unix/sysv/linux/pthread_kill.c: No such file or directory.
#0  __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
#1  0x00007fda2fad1b8e in my_write_core (sig=11) at /home/psergey/dev-git/10.2-look-hf/mysys/stacktrace.c:477
#2  0x00007fda2f45c862 in handle_fatal_signal (sig=11) at /home/psergey/dev-git/10.2-look-hf/sql/signal_handler.cc:294
#3  <signal handler called>
#4  0x00007fda2f19da9e in base_list_iterator::next (this=0x7fda301bfc00) at /home/psergey/dev-git/10.2-look-hf/sql/sql_list.h:452
#5  0x00007fda2f5b2ff3 in List_iterator<SEL_IMERGE>::operator++ (this=0x7fda301bfc00) at /home/psergey/dev-git/10.2-look-hf/sql/sql_list.h:561
#6  0x00007fda2f590cb8 in imerge_list_and_tree (param=0x7fda301bfea0, merges=0x7fda301bfca0, tree=0x7fda169cc110, replace=true) at /home/psergey/dev-git/10.2-look-hf/sql/opt_range.cc:1130
#7  0x00007fda2f5a15fc in tree_and (param=0x7fda301bfea0, tree1=0x7fda301bfc70, tree2=0x7fda169cc110) at /home/psergey/dev-git/10.2-look-hf/sql/opt_range.cc:8239
#8  0x00007fda2f59f27e in Item_cond_and::get_mm_tree (this=0x7fda16865260, param=0x7fda301bfea0, cond_ptr=0x7fda16867e78) at /home/psergey/dev-git/10.2-look-hf/sql/opt_range.cc:7412
#9  0x00007fda2f594317 in SQL_SELECT::test_quick_select (this=0x7fda16867e70, thd=0x7fda16816070, keys_to_use=..., prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=true) at /home/psergey/dev-git/10.2-look-hf/sql/opt_range.cc:2551
#10 0x00007fda2f252f67 in get_quick_record_count (thd=0x7fda16816070, select=0x7fda16867e70, table=0x7fda168dc070, keys=0x7fda16866d18, limit=18446744073709551615) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:3604
#11 0x00007fda2f2553c9 in make_join_statistics (join=0x7fda16865d80, tables_list=..., keyuse_array=0x7fda16866060) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:4226
#12 0x00007fda2f24bbca in JOIN::optimize_inner (this=0x7fda16865d80) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:1455
#13 0x00007fda2f24a69e in JOIN::optimize (this=0x7fda16865d80) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:1076
#14 0x00007fda2f252cea in mysql_select (thd=0x7fda16816070, tables=0x7fda168645b0, wild_num=0, fields=..., conds=0x7fda16865260, og_num=1, order=0x7fda16865c40, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fda16865d60, unit=0x7fda16819b18, select_lex=0x7fda1681a250) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:3553
#15 0x00007fda2f2481fb in handle_select (thd=0x7fda16816070, lex=0x7fda16819a50, result=0x7fda16865d60, setup_tables_done_option=0) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:373
#16 0x00007fda2f217c44 in execute_sqlcom_select (thd=0x7fda16816070, all_tables=0x7fda168645b0) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:6345
#17 0x00007fda2f20da7a in mysql_execute_command (thd=0x7fda16816070) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:3376
#18 0x00007fda2f21b411 in mysql_parse (thd=0x7fda16816070, rawbuf=0x7fda16864088 "select event_date,type,event_id from t1 WHERE event_date >= \"1999-07-01\" AND event_date < \"1999-07-15\" AND (type=100600 OR type=100100) ORDER BY event_date", length=155, parser_state=0x7fda301c1dd0, is_com_multi=false, is_next_command=false) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:7788
#19 0x00007fda2f2097d1 in dispatch_command (command=COM_QUERY, thd=0x7fda16816070, packet=0x7fda16858071 "select event_date,type,event_id from t1 WHERE event_date >= \"1999-07-01\" AND event_date < \"1999-07-15\" AND (type=100600 OR type=100100) ORDER BY event_date", packet_length=155, is_com_multi=false, is_next_command=false) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:1805
#20 0x00007fda2f208202 in do_command (thd=0x7fda16816070) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:1365
#21 0x00007fda2f3443be in do_handle_one_connection (connect=0x7fda2bc72b70) at /home/psergey/dev-git/10.2-look-hf/sql/sql_connect.cc:1354
#22 0x00007fda2f34414b in handle_one_connection (arg=0x7fda2bc72b70) at /home/psergey/dev-git/10.2-look-hf/sql/sql_connect.cc:1260
#23 0x00007fda2fa7244a in pfs_spawn_thread (arg=0x7fda1f60a370) at /home/psergey/dev-git/10.2-look-hf/storage/perfschema/pfs.cc:1862
#24 0x00007fda2d18c6aa in start_thread (arg=0x7fda301c3300) at pthread_create.c:333
#25 0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 22 (Thread 0x7fda30264780 (LWP 29255)):
#0  0x00007fda2c89f8dd in poll () at ../sysdeps/unix/syscall-template.S:81
#1  0x00007fda2f142d7c in handle_connections_sockets () at /home/psergey/dev-git/10.2-look-hf/sql/mysqld.cc:6569
#2  0x00007fda2f142152 in mysqld_main (argc=144, argv=0x7fda2bc5dac0) at /home/psergey/dev-git/10.2-look-hf/sql/mysqld.cc:6035
#3  0x00007fda2f137060 in main (argc=20, argv=0x7ffc589c8008) at /home/psergey/dev-git/10.2-look-hf/sql/main.cc:25

Thread 21 (Thread 0x7fda223fe700 (LWP 29259)):
#0  0x00007fda2e27364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x00007fda25b83468 in os_aio_linux_collect (array=0x7fda277e7150, segment=0, seg_size=256) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5326
#2  0x00007fda25b83836 in os_aio_linux_handle (global_seg=1, message1=0x7fda223fde80, message2=0x7fda223fde88, type=0x7fda223fde90) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5478
#3  0x00007fda25a9e8e9 in fil_aio_wait (segment=1) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/fil/fil0fil.cc:6045
#4  0x00007fda25c58670 in io_handler_thread (arg=0x7fda25fef548 <n+8>) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0start.cc:515
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda223fe700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 20 (Thread 0x7fda22bff700 (LWP 29258)):
#0  0x00007fda2e27364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x00007fda25b83468 in os_aio_linux_collect (array=0x7fda277e71a0, segment=0, seg_size=256) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5326
#2  0x00007fda25b83836 in os_aio_linux_handle (global_seg=0, message1=0x7fda22bfee80, message2=0x7fda22bfee88, type=0x7fda22bfee90) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5478
#3  0x00007fda25a9e8e9 in fil_aio_wait (segment=0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/fil/fil0fil.cc:6045
#4  0x00007fda25c58670 in io_handler_thread (arg=0x7fda25fef540 <n>) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0start.cc:515
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda22bff700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 19 (Thread 0x7fda3020d300 (LWP 29276)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
#1  0x00007fda2fad70a3 in safe_cond_wait (cond=0x7fda30560f60 <COND_slave_background>, mp=0x7fda30564240 <LOCK_slave_background>, file=0x7fda2fb82800 "/home/psergey/dev-git/10.2-look-hf/include/mysql/psi/mysql_thread.h", line=1138) at /home/psergey/dev-git/10.2-look-hf/mysys/thr_mutex.c:491
#2  0x00007fda2f163644 in inline_mysql_cond_wait (that=0x7fda30560f60 <COND_slave_background>, mutex=0x7fda30564240 <LOCK_slave_background>, src_file=0x7fda2fb83040 "/home/psergey/dev-git/10.2-look-hf/sql/slave.cc", src_line=338) at /home/psergey/dev-git/10.2-look-hf/include/mysql/psi/mysql_thread.h:1138
#3  0x00007fda2f164256 in handle_slave_background (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/sql/slave.cc:338
#4  0x00007fda2fa7244a in pfs_spawn_thread (arg=0x7fda24fc6170) at /home/psergey/dev-git/10.2-look-hf/storage/perfschema/pfs.cc:1862
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda3020d300) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 18 (Thread 0x7fda1b7ff700 (LWP 29270)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1  0x00007fda25b85d9d in os_cond_wait_timed (cond=0x7fda24f39f40, fast_mutex=0x7fda24f39f00, abstime=0x7fda1b7fee10) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:177
#2  0x00007fda25b86555 in os_event_wait_time_low (event=0x7fda24f39f00, time_in_usec=1000000, reset_sig_count=1) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:705
#3  0x00007fda25a3b78b in page_cleaner_sleep_if_needed (next_loop_time=1478038477482) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/buf/buf0flu.cc:2274
#4  0x00007fda25a3b843 in buf_flush_page_cleaner_thread (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/buf/buf0flu.cc:2310
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda1b7ff700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 17 (Thread 0x7fda30257300 (LWP 29275)):
#0  do_sigwait (sig=0x7fda302569d0, set=<optimized out>) at ../sysdeps/unix/sysv/linux/sigwait.c:64
#1  __sigwait (set=<optimized out>, sig=0x7fda302569d0) at ../sysdeps/unix/sysv/linux/sigwait.c:96
#2  0x00007fda2f13d592 in signal_hand (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/sql/mysqld.cc:3555
#3  0x00007fda2fa7244a in pfs_spawn_thread (arg=0x7fda24fc54f0) at /home/psergey/dev-git/10.2-look-hf/storage/perfschema/pfs.cc:1862
#4  0x00007fda2d18c6aa in start_thread (arg=0x7fda30257300) at pthread_create.c:333
#5  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 16 (Thread 0x7fda21bfd700 (LWP 29260)):
#0  0x00007fda2e27364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x00007fda25b83468 in os_aio_linux_collect (array=0x7fda277e7100, segment=0, seg_size=256) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5326
#2  0x00007fda25b83836 in os_aio_linux_handle (global_seg=2, message1=0x7fda21bfce80, message2=0x7fda21bfce88, type=0x7fda21bfce90) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5478
#3  0x00007fda25a9e8e9 in fil_aio_wait (segment=2) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/fil/fil0fil.cc:6045
#4  0x00007fda25c58670 in io_handler_thread (arg=0x7fda25fef550 <n+16>) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0start.cc:515
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda21bfd700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 15 (Thread 0x7fda1d3fd700 (LWP 29268)):
#0  0x00007fda2c8a1743 in select () at ../sysdeps/unix/syscall-template.S:81
#1  0x00007fda25b870ab in os_thread_sleep (tm=1000000) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0thread.cc:261
#2  0x00007fda25c54df3 in srv_master_sleep () at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0srv.cc:2514
#3  0x00007fda25c54f0a in srv_master_thread (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0srv.cc:2558
#4  0x00007fda2d18c6aa in start_thread (arg=0x7fda1d3fd700) at pthread_create.c:333
#5  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 14 (Thread 0x7fda193fd700 (LWP 29273)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1  0x00007fda25b85d9d in os_cond_wait_timed (cond=0x7fda22f2e7c0, fast_mutex=0x7fda22f2e780, abstime=0x7fda193fcde0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:177
#2  0x00007fda25b86555 in os_event_wait_time_low (event=0x7fda22f2e780, time_in_usec=5000000, reset_sig_count=1) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:705
#3  0x00007fda25c98b3d in ib_wqueue_timedwait (wq=0x7fda2779cbb8, wait_in_usecs=5000000) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/ut/ut0wqueue.cc:154
#4  0x00007fda25ad8f14 in fts_optimize_thread (arg=0x7fda2779cbb8) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/fts/fts0opt.cc:3064
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda193fd700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 13 (Thread 0x7fda183ff700 (LWP 29274)):
#0  0x00007fda2c8a1743 in select () at ../sysdeps/unix/syscall-template.S:81
#1  0x00007fda25b870ab in os_thread_sleep (tm=1000000) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0thread.cc:261
#2  0x00007fda25a17b1a in btr_defragment_thread (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/btr/btr0defragment.cc:758
#3  0x00007fda2d18c6aa in start_thread (arg=0x7fda183ff700) at pthread_create.c:333
#4  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 12 (Thread 0x7fda19bfe700 (LWP 29272)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1  0x00007fda25b85d9d in os_cond_wait_timed (cond=0x7fda24f3aac0, fast_mutex=0x7fda24f3aa80, abstime=0x7fda19bfde90) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:177
#2  0x00007fda25b86555 in os_event_wait_time_low (event=0x7fda24f3aa80, time_in_usec=10000000, reset_sig_count=1) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:705
#3  0x00007fda25a8ac49 in dict_stats_thread (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/dict/dict0stats_bg.cc:545
#4  0x00007fda2d18c6aa in start_thread (arg=0x7fda19bfe700) at pthread_create.c:333
#5  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 11 (Thread 0x7fda1e3ff700 (LWP 29266)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1  0x00007fda25b85d9d in os_cond_wait_timed (cond=0x7fda287f9c40, fast_mutex=0x7fda287f9c00, abstime=0x7fda1e3fee30) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:177
#2  0x00007fda25b86555 in os_event_wait_time_low (event=0x7fda287f9c00, time_in_usec=1000000, reset_sig_count=1) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:705
#3  0x00007fda25c53b44 in srv_error_monitor_thread (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0srv.cc:1973
#4  0x00007fda2d18c6aa in start_thread (arg=0x7fda1e3ff700) at pthread_create.c:333
#5  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 10 (Thread 0x7fda1cbfc700 (LWP 29269)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
#1  0x00007fda25b85e85 in os_cond_wait (cond=0x7fda287f9bc0, fast_mutex=0x7fda287f9b80) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:214
#2  0x00007fda25b863ad in os_event_wait_low (event=0x7fda287f9b80, reset_sig_count=1) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:592
#3  0x00007fda25c557a9 in srv_purge_coordinator_suspend (slot=0x7fda277d8e80, rseg_history_len=6) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0srv.cc:2848
#4  0x00007fda25c55c98 in srv_purge_coordinator_thread (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0srv.cc:2967
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda1cbfc700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 9 (Thread 0x7fda1a3ff700 (LWP 29271)):
#0  pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185
#1  0x00007fda25b85e85 in os_cond_wait (cond=0x7fda287f9d40, fast_mutex=0x7fda287f9d00) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:214
#2  0x00007fda25b863ad in os_event_wait_low (event=0x7fda287f9d00, reset_sig_count=1) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:592
#3  0x00007fda25a34268 in buf_dump_thread (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/buf/buf0dump.cc:703
#4  0x00007fda2d18c6aa in start_thread (arg=0x7fda1a3ff700) at pthread_create.c:333
#5  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 8 (Thread 0x7fda1f3ff700 (LWP 29265)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1  0x00007fda25b85d9d in os_cond_wait_timed (cond=0x7fda24f3a3c0, fast_mutex=0x7fda24f3a380, abstime=0x7fda1f3fee70) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:177
#2  0x00007fda25b86555 in os_event_wait_time_low (event=0x7fda24f3a380, time_in_usec=1000000, reset_sig_count=1) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:705
#3  0x00007fda25b5fe89 in lock_wait_timeout_thread (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/lock/lock0wait.cc:536
#4  0x00007fda2d18c6aa in start_thread (arg=0x7fda1f3ff700) at pthread_create.c:333
#5  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 7 (Thread 0x7fda1dbfe700 (LWP 29267)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1  0x00007fda25b85d9d in os_cond_wait_timed (cond=0x7fda287f9cc0, fast_mutex=0x7fda287f9c80, abstime=0x7fda1dbfde40) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:177
#2  0x00007fda25b86555 in os_event_wait_time_low (event=0x7fda287f9c80, time_in_usec=5000000, reset_sig_count=1) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0sync.cc:705
#3  0x00007fda25c53509 in srv_monitor_thread (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0srv.cc:1727
#4  0x00007fda2d18c6aa in start_thread (arg=0x7fda1dbfe700) at pthread_create.c:333
#5  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 6 (Thread 0x7fda203fa700 (LWP 29263)):
#0  0x00007fda2e27364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x00007fda25b83468 in os_aio_linux_collect (array=0x7fda277e71f0, segment=1, seg_size=256) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5326
#2  0x00007fda25b83836 in os_aio_linux_handle (global_seg=5, message1=0x7fda203f9e80, message2=0x7fda203f9e88, type=0x7fda203f9e90) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5478
#3  0x00007fda25a9e8e9 in fil_aio_wait (segment=5) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/fil/fil0fil.cc:6045
#4  0x00007fda25c58670 in io_handler_thread (arg=0x7fda25fef568 <n+40>) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0start.cc:515
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda203fa700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 5 (Thread 0x7fda26fff700 (LWP 29256)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1  0x00007fda2fad73ad in safe_cond_timedwait (cond=0x7fda30ddf0c0 <COND_timer>, mp=0x7fda30ddf000 <LOCK_timer>, abstime=0x7fda26ffee70, file=0x7fda2fd9a800 "/home/psergey/dev-git/10.2-look-hf/include/mysql/psi/mysql_thread.h", line=1175) at /home/psergey/dev-git/10.2-look-hf/mysys/thr_mutex.c:545
#2  0x00007fda2fad82fb in inline_mysql_cond_timedwait (that=0x7fda30ddf0c0 <COND_timer>, mutex=0x7fda30ddf000 <LOCK_timer>, abstime=0x7fda26ffee70, src_file=0x7fda2fd9a848 "/home/psergey/dev-git/10.2-look-hf/mysys/thr_timer.c", src_line=292) at /home/psergey/dev-git/10.2-look-hf/include/mysql/psi/mysql_thread.h:1175
#3  0x00007fda2fad8df1 in timer_handler (arg=0x0) at /home/psergey/dev-git/10.2-look-hf/mysys/thr_timer.c:292
#4  0x00007fda2fa7244a in pfs_spawn_thread (arg=0x7fda2bc519f0) at /home/psergey/dev-git/10.2-look-hf/storage/perfschema/pfs.cc:1862
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda26fff700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 4 (Thread 0x7fda24bff700 (LWP 29257)):
#0  pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:238
#1  0x00007fda2fad73ad in safe_cond_timedwait (cond=0x7fda30dccf40 <COND_checkpoint>, mp=0x7fda30dcce80 <LOCK_checkpoint>, abstime=0x7fda24bfedc0, file=0x7fda2fd5a190 "/home/psergey/dev-git/10.2-look-hf/include/mysql/psi/mysql_thread.h", line=1175) at /home/psergey/dev-git/10.2-look-hf/mysys/thr_mutex.c:545
#2  0x00007fda2f94e2fa in inline_mysql_cond_timedwait (that=0x7fda30dccf40 <COND_checkpoint>, mutex=0x7fda30dcce80 <LOCK_checkpoint>, abstime=0x7fda24bfedc0, src_file=0x7fda2fd5a1d8 "/home/psergey/dev-git/10.2-look-hf/storage/maria/ma_servicethread.c", src_line=116) at /home/psergey/dev-git/10.2-look-hf/include/mysql/psi/mysql_thread.h:1175
#3  0x00007fda2f94e7df in my_service_thread_sleep (control=0x7fda303a3800 <checkpoint_control>, sleep_time=29000000000) at /home/psergey/dev-git/10.2-look-hf/storage/maria/ma_servicethread.c:115
#4  0x00007fda2f943714 in ma_checkpoint_background (arg=0x1e) at /home/psergey/dev-git/10.2-look-hf/storage/maria/ma_checkpoint.c:708
#5  0x00007fda2fa7244a in pfs_spawn_thread (arg=0x7fda2bc55870) at /home/psergey/dev-git/10.2-look-hf/storage/perfschema/pfs.cc:1862
#6  0x00007fda2d18c6aa in start_thread (arg=0x7fda24bff700) at pthread_create.c:333
#7  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 3 (Thread 0x7fda20bfb700 (LWP 29262)):
#0  0x00007fda2e27364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x00007fda25b83468 in os_aio_linux_collect (array=0x7fda277e71f0, segment=0, seg_size=256) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5326
#2  0x00007fda25b83836 in os_aio_linux_handle (global_seg=4, message1=0x7fda20bfae80, message2=0x7fda20bfae88, type=0x7fda20bfae90) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5478
#3  0x00007fda25a9e8e9 in fil_aio_wait (segment=4) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/fil/fil0fil.cc:6045
#4  0x00007fda25c58670 in io_handler_thread (arg=0x7fda25fef560 <n+32>) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0start.cc:515
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda20bfb700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 2 (Thread 0x7fda213fc700 (LWP 29261)):
#0  0x00007fda2e27364a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1
#1  0x00007fda25b83468 in os_aio_linux_collect (array=0x7fda277e7100, segment=1, seg_size=256) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5326
#2  0x00007fda25b83836 in os_aio_linux_handle (global_seg=3, message1=0x7fda213fbe80, message2=0x7fda213fbe88, type=0x7fda213fbe90) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/os/os0file.cc:5478
#3  0x00007fda25a9e8e9 in fil_aio_wait (segment=3) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/fil/fil0fil.cc:6045
#4  0x00007fda25c58670 in io_handler_thread (arg=0x7fda25fef558 <n+24>) at /home/psergey/dev-git/10.2-look-hf/storage/innobase/srv/srv0start.cc:515
#5  0x00007fda2d18c6aa in start_thread (arg=0x7fda213fc700) at pthread_create.c:333
#6  0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109

Thread 1 (Thread 0x7fda301c3300 (LWP 29279)):
#0  __pthread_kill (threadid=<optimized out>, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
#1  0x00007fda2fad1b8e in my_write_core (sig=11) at /home/psergey/dev-git/10.2-look-hf/mysys/stacktrace.c:477
#2  0x00007fda2f45c862 in handle_fatal_signal (sig=11) at /home/psergey/dev-git/10.2-look-hf/sql/signal_handler.cc:294
#3  <signal handler called>
#4  0x00007fda2f19da9e in base_list_iterator::next (this=0x7fda301bfc00) at /home/psergey/dev-git/10.2-look-hf/sql/sql_list.h:452
#5  0x00007fda2f5b2ff3 in List_iterator<SEL_IMERGE>::operator++ (this=0x7fda301bfc00) at /home/psergey/dev-git/10.2-look-hf/sql/sql_list.h:561
#6  0x00007fda2f590cb8 in imerge_list_and_tree (param=0x7fda301bfea0, merges=0x7fda301bfca0, tree=0x7fda169cc110, replace=true) at /home/psergey/dev-git/10.2-look-hf/sql/opt_range.cc:1130
#7  0x00007fda2f5a15fc in tree_and (param=0x7fda301bfea0, tree1=0x7fda301bfc70, tree2=0x7fda169cc110) at /home/psergey/dev-git/10.2-look-hf/sql/opt_range.cc:8239
#8  0x00007fda2f59f27e in Item_cond_and::get_mm_tree (this=0x7fda16865260, param=0x7fda301bfea0, cond_ptr=0x7fda16867e78) at /home/psergey/dev-git/10.2-look-hf/sql/opt_range.cc:7412
#9  0x00007fda2f594317 in SQL_SELECT::test_quick_select (this=0x7fda16867e70, thd=0x7fda16816070, keys_to_use=..., prev_tables=0, limit=18446744073709551615, force_quick_range=false, ordered_output=false, remove_false_parts_of_where=true) at /home/psergey/dev-git/10.2-look-hf/sql/opt_range.cc:2551
#10 0x00007fda2f252f67 in get_quick_record_count (thd=0x7fda16816070, select=0x7fda16867e70, table=0x7fda168dc070, keys=0x7fda16866d18, limit=18446744073709551615) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:3604
#11 0x00007fda2f2553c9 in make_join_statistics (join=0x7fda16865d80, tables_list=..., keyuse_array=0x7fda16866060) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:4226
#12 0x00007fda2f24bbca in JOIN::optimize_inner (this=0x7fda16865d80) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:1455
#13 0x00007fda2f24a69e in JOIN::optimize (this=0x7fda16865d80) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:1076
#14 0x00007fda2f252cea in mysql_select (thd=0x7fda16816070, tables=0x7fda168645b0, wild_num=0, fields=..., conds=0x7fda16865260, og_num=1, order=0x7fda16865c40, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fda16865d60, unit=0x7fda16819b18, select_lex=0x7fda1681a250) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:3553
#15 0x00007fda2f2481fb in handle_select (thd=0x7fda16816070, lex=0x7fda16819a50, result=0x7fda16865d60, setup_tables_done_option=0) at /home/psergey/dev-git/10.2-look-hf/sql/sql_select.cc:373
#16 0x00007fda2f217c44 in execute_sqlcom_select (thd=0x7fda16816070, all_tables=0x7fda168645b0) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:6345
#17 0x00007fda2f20da7a in mysql_execute_command (thd=0x7fda16816070) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:3376
#18 0x00007fda2f21b411 in mysql_parse (thd=0x7fda16816070, rawbuf=0x7fda16864088 "select event_date,type,event_id from t1 WHERE event_date >= \"1999-07-01\" AND event_date < \"1999-07-15\" AND (type=100600 OR type=100100) ORDER BY event_date", length=155, parser_state=0x7fda301c1dd0, is_com_multi=false, is_next_command=false) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:7788
#19 0x00007fda2f2097d1 in dispatch_command (command=COM_QUERY, thd=0x7fda16816070, packet=0x7fda16858071 "select event_date,type,event_id from t1 WHERE event_date >= \"1999-07-01\" AND event_date < \"1999-07-15\" AND (type=100600 OR type=100100) ORDER BY event_date", packet_length=155, is_com_multi=false, is_next_command=false) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:1805
#20 0x00007fda2f208202 in do_command (thd=0x7fda16816070) at /home/psergey/dev-git/10.2-look-hf/sql/sql_parse.cc:1365
#21 0x00007fda2f3443be in do_handle_one_connection (connect=0x7fda2bc72b70) at /home/psergey/dev-git/10.2-look-hf/sql/sql_connect.cc:1354
#22 0x00007fda2f34414b in handle_one_connection (arg=0x7fda2bc72b70) at /home/psergey/dev-git/10.2-look-hf/sql/sql_connect.cc:1260
#23 0x00007fda2fa7244a in pfs_spawn_thread (arg=0x7fda1f60a370) at /home/psergey/dev-git/10.2-look-hf/storage/perfschema/pfs.cc:1862
#24 0x00007fda2d18c6aa in start_thread (arg=0x7fda301c3300) at pthread_create.c:333
#25 0x00007fda2c8aaeed in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109


Only  1  of 2 completed.