[New LWP 52174] [New LWP 52134] [New LWP 52135] [New LWP 52133] [New LWP 52137] [New LWP 52141] [New LWP 52138] [New LWP 52136] [New LWP 52146] [New LWP 52139] [New LWP 52140] [New LWP 52154] [New LWP 52144] [New LWP 52153] [New LWP 52145] [New LWP 52158] [New LWP 52148] [New LWP 52162] [New LWP 52156] [New LWP 52149] [New LWP 52159] [New LWP 52150] [New LWP 52142] [New LWP 52151] [New LWP 52143] [New LWP 52160] [New LWP 52152] [New LWP 52161] [New LWP 52155] [New LWP 52157] [New LWP 52163] [New LWP 52167] [New LWP 52164] [New LWP 52168] [New LWP 52176] [New LWP 52178] [New LWP 52180] [New LWP 52182] [New LWP 52183] [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/elenst/bld/10.2/bin/mysqld --no-defaults --basedir=/home/elenst/bld/10.2'. Program terminated with signal SIGABRT, Aborted. #0 0x00007f776d5ea59f in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0 [Current thread is 1 (Thread 0x7f77551c9700 (LWP 52174))] Thread 39 (Thread 0x7f7755057700 (LWP 52183)): #0 0x00007f776d5e9709 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779fdef6a in safe_cond_timedwait (cond=0x55e77ab6fe80 , mp=0x55e77ab72640 , abstime=0x7f7755056df0, file=0x55e77a06edc0 "/home/elenst/git/10.2/include/mysql/psi/mysql_thread.h", line=1186) at /home/elenst/git/10.2/mysys/thr_mutex.c:545 #2 0x000055e7795149bc in inline_mysql_cond_timedwait (that=0x55e77ab6fe80 , mutex=0x55e77ab72640 , abstime=0x7f7755056df0, src_file=0x55e77a070c30 "/home/elenst/git/10.2/sql/mysqld.cc", src_line=2968) at /home/elenst/git/10.2/include/mysql/psi/mysql_thread.h:1186 #3 0x000055e779519aac in cache_thread (thd=0x7f76d8000b00) at /home/elenst/git/10.2/sql/mysqld.cc:2967 #4 0x000055e779519d1a in one_thread_per_connection_end (thd=0x7f76d8000b00, put_in_cache=true) at /home/elenst/git/10.2/sql/mysqld.cc:3056 #5 0x000055e779744449 in do_handle_one_connection (connect=0x55e77dd21240) at /home/elenst/git/10.2/sql/sql_connect.cc:1354 #6 0x000055e7797440ef in handle_one_connection (arg=0x55e77dd21240) at /home/elenst/git/10.2/sql/sql_connect.cc:1241 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 38 (Thread 0x7f77550a1700 (LWP 52182)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x7f76f80f4730) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x7f76f80f4730, reset_sig_count=8) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x7f76f80f4730, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779b123e5 in lock_wait_suspend_thread (thr=0x7f76dc0ad4c8) at /home/elenst/git/10.2/storage/innobase/lock/lock0wait.cc:355 #5 0x000055e779bc19ff in row_mysql_handle_errors (new_err=0x7f775509c798, trx=0x7f7757217e28, thr=0x7f76dc0ad4c8, savept=0x0) at /home/elenst/git/10.2/storage/innobase/row/row0mysql.cc:735 #6 0x000055e779bfd30f in row_search_mvcc (buf=0x7f76dc01c8a8 "\377\377", mode=PAGE_CUR_G, prebuilt=0x7f76dc0acbf8, match_mode=0, direction=0) at /home/elenst/git/10.2/storage/innobase/row/row0sel.cc:5628 #7 0x000055e779a87052 in ha_innobase::index_read (this=0x7f76dc0d1f98, buf=0x7f76dc01c8a8 "\377\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:9687 #8 0x000055e779a88424 in ha_innobase::index_first (this=0x7f76dc0d1f98, buf=0x7f76dc01c8a8 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10125 #9 0x000055e779a886a4 in ha_innobase::rnd_next (this=0x7f76dc0d1f98, buf=0x7f76dc01c8a8 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10221 #10 0x000055e779872ba3 in handler::ha_rnd_next (this=0x7f76dc0d1f98, buf=0x7f76dc01c8a8 "\377\377") at /home/elenst/git/10.2/sql/handler.cc:2578 #11 0x000055e779867c16 in find_all_keys (thd=0x7f76d4000b00, param=0x7f775509dd40, select=0x7f76d4013f70, fs_info=0x7f76d40d16b0, buffpek_pointers=0x7f775509df40, tempfile=0x7f775509ddd0, pq=0x0, found_rows=0x7f76d40d1890) at /home/elenst/git/10.2/sql/filesort.cc:789 #12 0x000055e7798661ec in filesort (thd=0x7f76d4000b00, table=0x7f76dc10bbd0, filesort=0x7f76d40143b0, tracker=0x7f76d4014ba8, join=0x7f76d4011520, first_table_bit=1) at /home/elenst/git/10.2/sql/filesort.cc:279 #13 0x000055e779672d52 in create_sort_index (thd=0x7f76d4000b00, join=0x7f76d4011520, tab=0x7f76d4013620, fsort=0x7f76d40143b0) at /home/elenst/git/10.2/sql/sql_select.cc:21817 #14 0x000055e77966d7d7 in st_join_table::sort_table (this=0x7f76d4013620) at /home/elenst/git/10.2/sql/sql_select.cc:19652 #15 0x000055e77966d425 in join_init_read_record (tab=0x7f76d4013620) at /home/elenst/git/10.2/sql/sql_select.cc:19593 #16 0x000055e77966b3f1 in sub_select (join=0x7f76d4011520, join_tab=0x7f76d4013620, end_of_records=false) at /home/elenst/git/10.2/sql/sql_select.cc:18688 #17 0x000055e77966a9ee in do_select (join=0x7f76d4011520, procedure=0x0) at /home/elenst/git/10.2/sql/sql_select.cc:18235 #18 0x000055e77964557f in JOIN::exec_inner (this=0x7f76d4011520) at /home/elenst/git/10.2/sql/sql_select.cc:3566 #19 0x000055e779644a2e in JOIN::exec (this=0x7f76d4011520) at /home/elenst/git/10.2/sql/sql_select.cc:3361 #20 0x000055e779645bf0 in mysql_select (thd=0x7f76d4000b00, tables=0x7f76d40cbc78, wild_num=0, fields=..., conds=0x7f76d40cc3d8, og_num=1, order=0x0, group=0x7f76d40ccdc0, having=0x0, proc_param=0x0, select_options=2425621248, result=0x7f76d4011428, unit=0x7f76d40c9aa8, select_lex=0x7f76d40ca1e0) at /home/elenst/git/10.2/sql/sql_select.cc:3761 #21 0x000055e77963a2c1 in handle_select (thd=0x7f76d4000b00, lex=0x7f76d40c99e0, result=0x7f76d4011428, setup_tables_done_option=0) at /home/elenst/git/10.2/sql/sql_select.cc:376 #22 0x000055e7795fd0ad in mysql_execute_command (thd=0x7f76d4000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:3936 #23 0x000055e779627250 in Prepared_statement::execute (this=0x7f76d40c8f40, expanded_query=(String *) 0x7f775509f5b0 _binary "CREATE TEMPORARY TABLE `ps` AS SELECT `col_date_key` & `col_varchar_key` AS field1 FROM `D` WHERE @A := `col_time_key` GROUP BY TRIM( TRAILING ( ISNULL( `col_varchar_nokey` ) ) FROM ( BINARY `col_time_nokey` ) ) WITH ROLLUP", open_cursor=false) at /home/elenst/git/10.2/sql/sql_prepare.cc:4773 #24 0x000055e7796255b5 in Prepared_statement::execute_loop (this=0x7f76d40c8f40, expanded_query=(String *) 0x7f775509f5b0 _binary "CREATE TEMPORARY TABLE `ps` AS SELECT `col_date_key` & `col_varchar_key` AS field1 FROM `D` WHERE @A := `col_time_key` GROUP BY TRIM( TRAILING ( ISNULL( `col_varchar_nokey` ) ) FROM ( BINARY `col_time_nokey` ) ) WITH ROLLUP", open_cursor=false, packet=0x0, packet_end=0x0) at /home/elenst/git/10.2/sql/sql_prepare.cc:4203 #25 0x000055e779623292 in mysql_sql_stmt_execute (thd=0x7f76d4000b00) at /home/elenst/git/10.2/sql/sql_prepare.cc:3311 #26 0x000055e7795fbe5b in mysql_execute_command (thd=0x7f76d4000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:3483 #27 0x000055e779609a82 in mysql_parse (thd=0x7f76d4000b00, rawbuf=0x7f76d40111c8 "EXECUTE stmt /* QNO 2912 CON_ID 21 */", length=38, parser_state=0x7f77550a0250, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:7902 #28 0x000055e7795f76b3 in dispatch_command (command=COM_QUERY, thd=0x7f76d4000b00, packet=0x7f76d4008951 " EXECUTE stmt /* QNO 2912 CON_ID 21 */ ", packet_length=40, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:1806 #29 0x000055e7795f600f in do_command (thd=0x7f76d4000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:1360 #30 0x000055e77974436f in do_handle_one_connection (connect=0x55e77ddd3270) at /home/elenst/git/10.2/sql/sql_connect.cc:1335 #31 0x000055e7797440ef in handle_one_connection (arg=0x55e77ddd3270) at /home/elenst/git/10.2/sql/sql_connect.cc:1241 #32 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #33 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 37 (Thread 0x7f77550eb700 (LWP 52180)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x7f76d4099900) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x7f76d4099900, reset_sig_count=9) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x7f76d4099900, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779b123e5 in lock_wait_suspend_thread (thr=0x7f76e404dce8) at /home/elenst/git/10.2/storage/innobase/lock/lock0wait.cc:355 #5 0x000055e779bc19ff in row_mysql_handle_errors (new_err=0x7f77550e7f68, trx=0x7f7757216938, thr=0x7f76e404dce8, savept=0x0) at /home/elenst/git/10.2/storage/innobase/row/row0mysql.cc:735 #6 0x000055e779bfd30f in row_search_mvcc (buf=0x7f76e404ef48 "\377\377", mode=PAGE_CUR_G, prebuilt=0x7f76e404d418, match_mode=0, direction=0) at /home/elenst/git/10.2/storage/innobase/row/row0sel.cc:5628 #7 0x000055e779a87052 in ha_innobase::index_read (this=0x7f76e407f0e8, buf=0x7f76e404ef48 "\377\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:9687 #8 0x000055e779a88424 in ha_innobase::index_first (this=0x7f76e407f0e8, buf=0x7f76e404ef48 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10125 #9 0x000055e779a886a4 in ha_innobase::rnd_next (this=0x7f76e407f0e8, buf=0x7f76e404ef48 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10221 #10 0x000055e779872ba3 in handler::ha_rnd_next (this=0x7f76e407f0e8, buf=0x7f76e404ef48 "\377\377") at /home/elenst/git/10.2/sql/handler.cc:2578 #11 0x000055e7799de354 in rr_sequential (info=0x7f76e0014068) at /home/elenst/git/10.2/sql/records.cc:485 #12 0x000055e77966d60c in join_init_read_record (tab=0x7f76e0013fa0) at /home/elenst/git/10.2/sql/sql_select.cc:19613 #13 0x000055e77966b3f1 in sub_select (join=0x7f76e0012190, join_tab=0x7f76e0013fa0, end_of_records=false) at /home/elenst/git/10.2/sql/sql_select.cc:18688 #14 0x000055e77966a9ee in do_select (join=0x7f76e0012190, procedure=0x0) at /home/elenst/git/10.2/sql/sql_select.cc:18235 #15 0x000055e77964557f in JOIN::exec_inner (this=0x7f76e0012190) at /home/elenst/git/10.2/sql/sql_select.cc:3566 #16 0x000055e779644a2e in JOIN::exec (this=0x7f76e0012190) at /home/elenst/git/10.2/sql/sql_select.cc:3361 #17 0x000055e779645bf0 in mysql_select (thd=0x7f76e0000b00, tables=0x7f76e0011a58, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=553245739776, result=0x7f76e00120e8, unit=0x7f76e00046a8, select_lex=0x7f76e0004de0) at /home/elenst/git/10.2/sql/sql_select.cc:3761 #18 0x000055e77963a2c1 in handle_select (thd=0x7f76e0000b00, lex=0x7f76e00045e0, result=0x7f76e00120e8, setup_tables_done_option=1073741824) at /home/elenst/git/10.2/sql/sql_select.cc:376 #19 0x000055e7795fef36 in mysql_execute_command (thd=0x7f76e0000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:4525 #20 0x000055e779609a82 in mysql_parse (thd=0x7f76e0000b00, rawbuf=0x7f76e00111c8 "INSERT INTO `D` SELECT * FROM `D` /* QNO 3796 CON_ID 20 */", length=58, parser_state=0x7f77550ea250, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:7902 #21 0x000055e7795f76b3 in dispatch_command (command=COM_QUERY, thd=0x7f76e0000b00, packet=0x7f76e0008951 "INSERT INTO `D` SELECT * FROM `D` /* QNO 3796 CON_ID 20 */ ", packet_length=59, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:1806 #22 0x000055e7795f600f in do_command (thd=0x7f76e0000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:1360 #23 0x000055e77974436f in do_handle_one_connection (connect=0x55e77dd44eb0) at /home/elenst/git/10.2/sql/sql_connect.cc:1335 #24 0x000055e7797440ef in handle_one_connection (arg=0x55e77dd44eb0) at /home/elenst/git/10.2/sql/sql_connect.cc:1241 #25 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #26 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 36 (Thread 0x7f7755135700 (LWP 52178)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x7f76dc03c070) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x7f76dc03c070, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x7f76dc03c070, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779b123e5 in lock_wait_suspend_thread (thr=0x7f76dc09f2b8) at /home/elenst/git/10.2/storage/innobase/lock/lock0wait.cc:355 #5 0x000055e779bc19ff in row_mysql_handle_errors (new_err=0x7f77551318d8, trx=0x7f77572160d8, thr=0x7f76dc09f2b8, savept=0x0) at /home/elenst/git/10.2/storage/innobase/row/row0mysql.cc:735 #6 0x000055e779bfd30f in row_search_mvcc (buf=0x7f76dc1108c8 "\377\377", mode=PAGE_CUR_G, prebuilt=0x7f76dc09e9e8, match_mode=0, direction=0) at /home/elenst/git/10.2/storage/innobase/row/row0sel.cc:5628 #7 0x000055e779a87052 in ha_innobase::index_read (this=0x7f76dc0ff2d8, buf=0x7f76dc1108c8 "\377\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:9687 #8 0x000055e779a88424 in ha_innobase::index_first (this=0x7f76dc0ff2d8, buf=0x7f76dc1108c8 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10125 #9 0x000055e779a886a4 in ha_innobase::rnd_next (this=0x7f76dc0ff2d8, buf=0x7f76dc1108c8 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10221 #10 0x000055e779872ba3 in handler::ha_rnd_next (this=0x7f76dc0ff2d8, buf=0x7f76dc1108c8 "\377\377") at /home/elenst/git/10.2/sql/handler.cc:2578 #11 0x000055e779867c16 in find_all_keys (thd=0x7f76dc000b00, param=0x7f7755132e80, select=0x7f76dc016648, fs_info=0x7f76dc0daf20, buffpek_pointers=0x7f7755133080, tempfile=0x7f7755132f10, pq=0x0, found_rows=0x7f76dc0db100) at /home/elenst/git/10.2/sql/filesort.cc:789 #12 0x000055e7798661ec in filesort (thd=0x7f76dc000b00, table=0x7f76dc0fe6d0, filesort=0x7f76dc016a88, tracker=0x7f76dc017098, join=0x7f76dc0135e0, first_table_bit=1) at /home/elenst/git/10.2/sql/filesort.cc:279 #13 0x000055e779672d52 in create_sort_index (thd=0x7f76dc000b00, join=0x7f76dc0135e0, tab=0x7f76dc015cf8, fsort=0x7f76dc016a88) at /home/elenst/git/10.2/sql/sql_select.cc:21817 #14 0x000055e77966d7d7 in st_join_table::sort_table (this=0x7f76dc015cf8) at /home/elenst/git/10.2/sql/sql_select.cc:19652 #15 0x000055e77966d425 in join_init_read_record (tab=0x7f76dc015cf8) at /home/elenst/git/10.2/sql/sql_select.cc:19593 #16 0x000055e77966b3f1 in sub_select (join=0x7f76dc0135e0, join_tab=0x7f76dc015cf8, end_of_records=false) at /home/elenst/git/10.2/sql/sql_select.cc:18688 #17 0x000055e77966a9ee in do_select (join=0x7f76dc0135e0, procedure=0x0) at /home/elenst/git/10.2/sql/sql_select.cc:18235 #18 0x000055e77964557f in JOIN::exec_inner (this=0x7f76dc0135e0) at /home/elenst/git/10.2/sql/sql_select.cc:3566 #19 0x000055e779644a2e in JOIN::exec (this=0x7f76dc0135e0) at /home/elenst/git/10.2/sql/sql_select.cc:3361 #20 0x000055e779645bf0 in mysql_select (thd=0x7f76dc000b00, tables=0x7f76dc012308, wild_num=0, fields=..., conds=0x7f76dc012a30, og_num=1, order=0x0, group=0x7f76dc013120, having=0x7f76dc013178, proc_param=0x0, select_options=552171997952, result=0x7f76dc0134e8, unit=0x7f76dc0046a8, select_lex=0x7f76dc004de0) at /home/elenst/git/10.2/sql/sql_select.cc:3761 #21 0x000055e77963a2c1 in handle_select (thd=0x7f76dc000b00, lex=0x7f76dc0045e0, result=0x7f76dc0134e8, setup_tables_done_option=0) at /home/elenst/git/10.2/sql/sql_select.cc:376 #22 0x000055e7795fd0ad in mysql_execute_command (thd=0x7f76dc000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:3936 #23 0x000055e779609a82 in mysql_parse (thd=0x7f76dc000b00, rawbuf=0x7f76dc0111c8 "CREATE TABLE transforms.delete_returning_52177 SELECT CONVERT( ( ENCODE( `col_varchar_nokey`, `col_varchar_key` ) ) USING latin1 ) AS field1 FROM `D` WHERE IS_FREE_LOCK( 'pdwgza' ) GROUP BY UpdateXML"..., length=402, parser_state=0x7f7755134250, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:7902 #24 0x000055e7795f76b3 in dispatch_command (command=COM_QUERY, thd=0x7f76dc000b00, packet=0x7f76dc008951 "CREATE TABLE transforms.delete_returning_52177 SELECT CONVERT( ( ENCODE( `col_varchar_nokey`, `col_varchar_key` ) ) USING latin1 ) AS field1 FROM `D` WHERE IS_FREE_LOCK( 'pdwgza' ) GROUP BY UpdateXML"..., packet_length=403, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:1806 #25 0x000055e7795f600f in do_command (thd=0x7f76dc000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:1360 #26 0x000055e77974436f in do_handle_one_connection (connect=0x55e77dd21240) at /home/elenst/git/10.2/sql/sql_connect.cc:1335 #27 0x000055e7797440ef in handle_one_connection (arg=0x55e77dd21240) at /home/elenst/git/10.2/sql/sql_connect.cc:1241 #28 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #29 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 35 (Thread 0x7f775517f700 (LWP 52176)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x7f76f80be490) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x7f76f80be490, reset_sig_count=14) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x7f76f80be490, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779b123e5 in lock_wait_suspend_thread (thr=0x7f76e80b2868) at /home/elenst/git/10.2/storage/innobase/lock/lock0wait.cc:355 #5 0x000055e779bc19ff in row_mysql_handle_errors (new_err=0x7f775517bf68, trx=0x7f7757215ca8, thr=0x7f76e80b2868, savept=0x0) at /home/elenst/git/10.2/storage/innobase/row/row0mysql.cc:735 #6 0x000055e779bfd30f in row_search_mvcc (buf=0x7f76e8024038 "\377\377", mode=PAGE_CUR_G, prebuilt=0x7f76e80b1f98, match_mode=0, direction=0) at /home/elenst/git/10.2/storage/innobase/row/row0sel.cc:5628 #7 0x000055e779a87052 in ha_innobase::index_read (this=0x7f76e80f55e8, buf=0x7f76e8024038 "\377\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:9687 #8 0x000055e779a88424 in ha_innobase::index_first (this=0x7f76e80f55e8, buf=0x7f76e8024038 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10125 #9 0x000055e779a886a4 in ha_innobase::rnd_next (this=0x7f76e80f55e8, buf=0x7f76e8024038 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10221 #10 0x000055e779872ba3 in handler::ha_rnd_next (this=0x7f76e80f55e8, buf=0x7f76e8024038 "\377\377") at /home/elenst/git/10.2/sql/handler.cc:2578 #11 0x000055e7799de354 in rr_sequential (info=0x7f76e80bef30) at /home/elenst/git/10.2/sql/records.cc:485 #12 0x000055e77966d60c in join_init_read_record (tab=0x7f76e80bee68) at /home/elenst/git/10.2/sql/sql_select.cc:19613 #13 0x000055e77966b3f1 in sub_select (join=0x7f76e80b5e40, join_tab=0x7f76e80bee68, end_of_records=false) at /home/elenst/git/10.2/sql/sql_select.cc:18688 #14 0x000055e77966a9ee in do_select (join=0x7f76e80b5e40, procedure=0x0) at /home/elenst/git/10.2/sql/sql_select.cc:18235 #15 0x000055e77964557f in JOIN::exec_inner (this=0x7f76e80b5e40) at /home/elenst/git/10.2/sql/sql_select.cc:3566 #16 0x000055e779644a2e in JOIN::exec (this=0x7f76e80b5e40) at /home/elenst/git/10.2/sql/sql_select.cc:3361 #17 0x000055e779645bf0 in mysql_select (thd=0x7f76e8000b00, tables=0x7f76e8012088, wild_num=0, fields=..., conds=0x7f76e80128d8, og_num=1, order=0x0, group=0x7f76e80131b0, having=0x7f76e80136b8, proc_param=0x0, select_options=553245739777, result=0x7f76e80b5d98, unit=0x7f76e80046a8, select_lex=0x7f76e8004de0) at /home/elenst/git/10.2/sql/sql_select.cc:3761 #18 0x000055e77963a2c1 in handle_select (thd=0x7f76e8000b00, lex=0x7f76e80045e0, result=0x7f76e80b5d98, setup_tables_done_option=1073741824) at /home/elenst/git/10.2/sql/sql_select.cc:376 #19 0x000055e7795fef36 in mysql_execute_command (thd=0x7f76e8000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:4525 #20 0x000055e779609a82 in mysql_parse (thd=0x7f76e8000b00, rawbuf=0x7f76e80111c8 "REPLACE INTO transforms.insert_select_52175 SELECT DISTINCT BIT_OR( `col_int_nokey` ) AS field1 FROM `view_D` WHERE AES_DECRYPT( 'p', `col_date_nokey` ) GROUP BY @A := ( ExtractValue( 0, '/bba/ac/de/"..., length=375, parser_state=0x7f775517e250, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:7902 #21 0x000055e7795f76b3 in dispatch_command (command=COM_QUERY, thd=0x7f76e8000b00, packet=0x7f76e8008951 "REPLACE INTO transforms.insert_select_52175 SELECT DISTINCT BIT_OR( `col_int_nokey` ) AS field1 FROM `view_D` WHERE AES_DECRYPT( 'p', `col_date_nokey` ) GROUP BY @A := ( ExtractValue( 0, '/bba/ac/de/"..., packet_length=376, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:1806 #22 0x000055e7795f600f in do_command (thd=0x7f76e8000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:1360 #23 0x000055e77974436f in do_handle_one_connection (connect=0x55e77ddd3270) at /home/elenst/git/10.2/sql/sql_connect.cc:1335 #24 0x000055e7797440ef in handle_one_connection (arg=0x55e77ddd3270) at /home/elenst/git/10.2/sql/sql_connect.cc:1241 #25 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #26 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 34 (Thread 0x7f7755213700 (LWP 52168)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x7f76dc01efa0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x7f76dc01efa0, reset_sig_count=4) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x7f76dc01efa0, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779b123e5 in lock_wait_suspend_thread (thr=0x7f76e00cef58) at /home/elenst/git/10.2/storage/innobase/lock/lock0wait.cc:355 #5 0x000055e779bc19ff in row_mysql_handle_errors (new_err=0x7f775520ee28, trx=0x7f7757215878, thr=0x7f76e00cef58, savept=0x0) at /home/elenst/git/10.2/storage/innobase/row/row0mysql.cc:735 #6 0x000055e779bfd30f in row_search_mvcc (buf=0x7f76e0073ff8 "\377\377", mode=PAGE_CUR_G, prebuilt=0x7f76e00ce688, match_mode=0, direction=0) at /home/elenst/git/10.2/storage/innobase/row/row0sel.cc:5628 #7 0x000055e779a87052 in ha_innobase::index_read (this=0x7f76e00246f8, buf=0x7f76e0073ff8 "\377\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:9687 #8 0x000055e779a88424 in ha_innobase::index_first (this=0x7f76e00246f8, buf=0x7f76e0073ff8 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10125 #9 0x000055e779a886a4 in ha_innobase::rnd_next (this=0x7f76e00246f8, buf=0x7f76e0073ff8 "\377\377") at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:10221 #10 0x000055e779872ba3 in handler::ha_rnd_next (this=0x7f76e00246f8, buf=0x7f76e0073ff8 "\377\377") at /home/elenst/git/10.2/sql/handler.cc:2578 #11 0x000055e7799de354 in rr_sequential (info=0x7f76f84c7f10) at /home/elenst/git/10.2/sql/records.cc:485 #12 0x000055e77966d60c in join_init_read_record (tab=0x7f76f84c7e48) at /home/elenst/git/10.2/sql/sql_select.cc:19613 #13 0x000055e77966b3f1 in sub_select (join=0x7f76f8017758, join_tab=0x7f76f84c7e48, end_of_records=false) at /home/elenst/git/10.2/sql/sql_select.cc:18688 #14 0x000055e77966a9ee in do_select (join=0x7f76f8017758, procedure=0x0) at /home/elenst/git/10.2/sql/sql_select.cc:18235 #15 0x000055e77964557f in JOIN::exec_inner (this=0x7f76f8017758) at /home/elenst/git/10.2/sql/sql_select.cc:3566 #16 0x000055e779644a2e in JOIN::exec (this=0x7f76f8017758) at /home/elenst/git/10.2/sql/sql_select.cc:3361 #17 0x000055e779645bf0 in mysql_select (thd=0x7f76f8000b00, tables=0x7f76f839ff68, wild_num=0, fields=..., conds=0x0, og_num=3, order=0x7f76f83a0dc8, group=0x7f76f83a0930, having=0x0, proc_param=0x0, select_options=2416184065, result=0x7f76f8017660, unit=0x7f76f839c9c8, select_lex=0x7f76f839d100) at /home/elenst/git/10.2/sql/sql_select.cc:3761 #18 0x000055e77963a2c1 in handle_select (thd=0x7f76f8000b00, lex=0x7f76f839c900, result=0x7f76f8017660, setup_tables_done_option=0) at /home/elenst/git/10.2/sql/sql_select.cc:376 #19 0x000055e7795fd0ad in mysql_execute_command (thd=0x7f76f8000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:3936 #20 0x000055e779627250 in Prepared_statement::execute (this=0x7f76f8476f70, expanded_query=(String *) 0x7f77552115b0 _binary "CREATE TEMPORARY TABLE `ps` AS SELECT DISTINCT QUOTE( `col_time_nokey` ) AS field1, COUNT( DEGREES( `col_datetime_key` ) ) AS field2, CASE ( IF( `col_varchar_nokey`, ( WEEKOFYEAR( `col_date_nokey` ) ), ( SIN( `col_varchar_key` ) ) ) ) WHEN `col_datetime_key` THEN `col_varchar_nokey` ELSE ( OLD_PASSWORD( `col_int_nokey` ) ) END AS field3 FROM `view_D` GROUP BY IF( '1971-06-25 23:50:38.017424', '2028-05-18 21:12:49.033833', '14:22:16.049038' ) ORDER BY `col_varchar_nokey` DIV ( ATAN( `col_varchar_nokey` ) ), ExtractValue( 't', '/ddddaad/deabecbdaecceed/d/eaddb/bcab/eb/bdda/bdecc/bcbab/abedabbbceadcbdbd/aec/d/dbdbe' )", open_cursor=false) at /home/elenst/git/10.2/sql/sql_prepare.cc:4773 #21 0x000055e7796255b5 in Prepared_statement::execute_loop (this=0x7f76f8476f70, expanded_query=(String *) 0x7f77552115b0 _binary "CREATE TEMPORARY TABLE `ps` AS SELECT DISTINCT QUOTE( `col_time_nokey` ) AS field1, COUNT( DEGREES( `col_datetime_key` ) ) AS field2, CASE ( IF( `col_varchar_nokey`, ( WEEKOFYEAR( `col_date_nokey` ) ), ( SIN( `col_varchar_key` ) ) ) ) WHEN `col_datetime_key` THEN `col_varchar_nokey` ELSE ( OLD_PASSWORD( `col_int_nokey` ) ) END AS field3 FROM `view_D` GROUP BY IF( '1971-06-25 23:50:38.017424', '2028-05-18 21:12:49.033833', '14:22:16.049038' ) ORDER BY `col_varchar_nokey` DIV ( ATAN( `col_varchar_nokey` ) ), ExtractValue( 't', '/ddddaad/deabecbdaecceed/d/eaddb/bcab/eb/bdda/bdecc/bcbab/abedabbbceadcbdbd/aec/d/dbdbe' )", open_cursor=false, packet=0x0, packet_end=0x0) at /home/elenst/git/10.2/sql/sql_prepare.cc:4203 #22 0x000055e779623292 in mysql_sql_stmt_execute (thd=0x7f76f8000b00) at /home/elenst/git/10.2/sql/sql_prepare.cc:3311 #23 0x000055e7795fbe5b in mysql_execute_command (thd=0x7f76f8000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:3483 #24 0x000055e779609a82 in mysql_parse (thd=0x7f76f8000b00, rawbuf=0x7f76f8013650 "EXECUTE stmt ; SET @stmt_ins = CONCAT(\"INSERT INTO `ps` \", @stmt) ; PREPARE stmt FROM @stmt_ins; EXECUTE stmt; EXECUTE stmt; DEALLOCATE PREPARE stmt; DROP TEMPORARY TABLE `ps` /* QNO 4079 CON_ID 16 */", length=200, parser_state=0x7f7755212250, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:7902 #25 0x000055e7795f7b94 in dispatch_command (command=COM_QUERY, thd=0x7f76f8000b00, packet=0x7f76f8073891 "", packet_length=913, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:1896 #26 0x000055e7795f600f in do_command (thd=0x7f76f8000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:1360 #27 0x000055e77974436f in do_handle_one_connection (connect=0x55e77dd21240) at /home/elenst/git/10.2/sql/sql_connect.cc:1335 #28 0x000055e7797440ef in handle_one_connection (arg=0x55e77dd21240) at /home/elenst/git/10.2/sql/sql_connect.cc:1241 #29 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #30 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 33 (Thread 0x7f776c0dc700 (LWP 52164)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779fdec60 in safe_cond_wait (cond=0x55e77ab6fec0 , mp=0x55e77ab730c0 , file=0x55e77a07cb40 "/home/elenst/git/10.2/include/mysql/psi/mysql_thread.h", line=1149) at /home/elenst/git/10.2/mysys/thr_mutex.c:491 #2 0x000055e77954393a in inline_mysql_cond_wait (that=0x55e77ab6fec0 , mutex=0x55e77ab730c0 , src_file=0x55e77a07d420 "/home/elenst/git/10.2/sql/slave.cc", src_line=334) at /home/elenst/git/10.2/include/mysql/psi/mysql_thread.h:1149 #3 0x000055e77954451f in handle_slave_background (arg=0x0) at /home/elenst/git/10.2/sql/slave.cc:334 #4 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #5 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 32 (Thread 0x7f776c092700 (LWP 52167)): #0 0x00007f776ca6cb5d in poll () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x000055e77a03f5a7 in vio_io_wait (vio=0x55e77d386d70, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/elenst/git/10.2/vio/viosocket.c:945 #2 0x000055e77a03ddb6 in vio_socket_io_wait (vio=0x55e77d386d70, event=VIO_IO_EVENT_READ) at /home/elenst/git/10.2/vio/viosocket.c:108 #3 0x000055e77a03df6c in vio_read (vio=0x55e77d386d70, buf=0x7f76f4008950 "\a", size=4) at /home/elenst/git/10.2/vio/viosocket.c:184 #4 0x000055e77952b618 in my_real_read (net=0x7f76f4000df0, complen=0x7f776c091990, header=1 '\001') at /home/elenst/git/10.2/sql/net_serv.cc:892 #5 0x000055e77952be19 in my_net_read_packet_reallen (net=0x7f76f4000df0, read_from_server=1 '\001', reallen=0x7f776c0919f8) at /home/elenst/git/10.2/sql/net_serv.cc:1162 #6 0x000055e77952bdcd in my_net_read_packet (net=0x7f76f4000df0, read_from_server=1 '\001') at /home/elenst/git/10.2/sql/net_serv.cc:1146 #7 0x000055e7795f5ae8 in do_command (thd=0x7f76f4000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:1242 #8 0x000055e77974436f in do_handle_one_connection (connect=0x55e77ddd3270) at /home/elenst/git/10.2/sql/sql_connect.cc:1335 #9 0x000055e7797440ef in handle_one_connection (arg=0x55e77ddd3270) at /home/elenst/git/10.2/sql/sql_connect.cc:1241 #10 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #11 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 31 (Thread 0x7f776c126700 (LWP 52163)): #0 0x00007f776d5ed156 in sigwait () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e77951a9de in signal_hand (arg=0x0) at /home/elenst/git/10.2/sql/mysqld.cc:3505 #2 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #3 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 30 (Thread 0x7f7739ffb700 (LWP 52157)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x55e77d3d29a0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x55e77d3d29a0, reset_sig_count=2028) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x55e77d3d29a0, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779c2d13a in srv_resume_thread (slot=0x55e77a9ae8b8 , sig_count=0, wait=true, timeout_usec=0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x000055e779c30d8f in srv_worker_thread (arg=0x0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2600 #6 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #7 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 29 (Thread 0x7f773affd700 (LWP 52155)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x55e77d3d2920) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x55e77d3d2920, reset_sig_count=2120) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x55e77d3d2920, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779c2d13a in srv_resume_thread (slot=0x55e77a9ae880 , sig_count=0, wait=true, timeout_usec=0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x000055e779c30d8f in srv_worker_thread (arg=0x0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2600 #6 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #7 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 28 (Thread 0x7f771b7fe700 (LWP 52161)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779fdec60 in safe_cond_wait (cond=0x7f771b7fde10, mp=0x7f771b7fde50, file=0x55e77a1a2c60 "/home/elenst/git/10.2/include/mysql/psi/mysql_thread.h", line=1149) at /home/elenst/git/10.2/mysys/thr_mutex.c:491 #2 0x000055e779a715e8 in inline_mysql_cond_wait (that=0x7f771b7fde10, mutex=0x7f771b7fde50, src_file=0x55e77a1a4608 "/home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc", src_line=338) at /home/elenst/git/10.2/include/mysql/psi/mysql_thread.h:1149 #3 0x000055e779a75d1a in thd_destructor_proxy () at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:338 #4 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #5 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 27 (Thread 0x7f7740991700 (LWP 52152)): #0 0x00007f776d5e9709 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b4486e in os_event::timed_wait (this=0x55e77e01f920, abstime=0x7f7740990ea0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055e779b44b8b in os_event::wait_time_low (this=0x55e77e01f920, time_in_usec=10000000, reset_sig_count=74) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055e779b44d69 in os_event_wait_time_low (event=0x55e77e01f920, time_in_usec=10000000, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055e779d7353b in dict_stats_thread () at /home/elenst/git/10.2/storage/innobase/dict/dict0stats_bg.cc:451 #5 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 26 (Thread 0x7f771bfff700 (LWP 52160)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x55e77d3d2ca0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x55e77d3d2ca0, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x55e77d3d2ca0, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779cf756d in buf_resize_thread () at /home/elenst/git/10.2/storage/innobase/buf/buf0buf.cc:3083 #5 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 25 (Thread 0x7f7744999700 (LWP 52143)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f7744998c20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f7744998c20, m1=0x7f7744998cc8, m2=0x7f7744998cd0, request=0x7f7744998d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=7, m1=0x7f7744998cc8, m2=0x7f7744998cd0, request=0x7f7744998d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=7, m1=0x7f7744998cc8, m2=0x7f7744998cd0, request=0x7f7744998d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=7) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2b18 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 24 (Thread 0x7f7741192700 (LWP 52151)): #0 0x00007f776d5ecc1d in nanosleep () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b45300 in os_thread_sleep (tm=1000000) at /home/elenst/git/10.2/storage/innobase/os/os0thread.cc:230 #2 0x000055e779c30794 in srv_master_sleep () at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2411 #3 0x000055e779c308d2 in srv_master_thread (arg=0x0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2456 #4 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #5 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 23 (Thread 0x7f774519a700 (LWP 52142)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f7745199c20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f7745199c20, m1=0x7f7745199cc8, m2=0x7f7745199cd0, request=0x7f7745199d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=6, m1=0x7f7745199cc8, m2=0x7f7745199cd0, request=0x7f7745199d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=6, m1=0x7f7745199cc8, m2=0x7f7745199cd0, request=0x7f7745199d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=6) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2b10 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 22 (Thread 0x7f7741993700 (LWP 52150)): #0 0x00007f776d5e9709 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b4486e in os_event::timed_wait (this=0x55e77d3d2b20, abstime=0x7f7741992e60) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055e779b44b8b in os_event::wait_time_low (this=0x55e77d3d2b20, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055e779b44d69 in os_event_wait_time_low (event=0x55e77d3d2b20, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055e779c2ef83 in srv_monitor_thread () at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:1753 #5 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 21 (Thread 0x7f7738ff9700 (LWP 52159)): #0 0x00007f776d5ecc1d in nanosleep () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b45300 in os_thread_sleep (tm=1000000) at /home/elenst/git/10.2/storage/innobase/os/os0thread.cc:230 #2 0x000055e779cea160 in btr_defragment_thread () at /home/elenst/git/10.2/storage/innobase/btr/btr0defragment.cc:760 #3 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #4 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 20 (Thread 0x7f7742194700 (LWP 52149)): #0 0x00007f776d5e9709 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b4486e in os_event::timed_wait (this=0x55e77d3d2aa0, abstime=0x7f7742193cc0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055e779b44b8b in os_event::wait_time_low (this=0x55e77d3d2aa0, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055e779b44d69 in os_event_wait_time_low (event=0x55e77d3d2aa0, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055e779c2f4c2 in srv_error_monitor_thread () at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:1922 #5 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 19 (Thread 0x7f773a7fc700 (LWP 52156)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x55e77d3d2a20) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x55e77d3d2a20, reset_sig_count=2214) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x55e77d3d2a20, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779c2d13a in srv_resume_thread (slot=0x55e77a9ae8f0 , sig_count=0, wait=true, timeout_usec=0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x000055e779c30d8f in srv_worker_thread (arg=0x0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2600 #6 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #7 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 18 (Thread 0x7f776c170700 (LWP 52162)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779fdec60 in safe_cond_wait (cond=0x55e77ab9ee08 , mp=0x55e77ab9ed58 , file=0x55e77a177e00 "/home/elenst/git/10.2/include/mysql/psi/mysql_thread.h", line=1149) at /home/elenst/git/10.2/mysys/thr_mutex.c:491 #2 0x000055e779966f2a in inline_mysql_cond_wait (that=0x55e77ab9ee08 , mutex=0x55e77ab9ed58 , src_file=0x55e77a1783d0 "/home/elenst/git/10.2/sql/log.cc", src_line=9857) at /home/elenst/git/10.2/include/mysql/psi/mysql_thread.h:1149 #3 0x000055e779980b61 in binlog_background_thread (arg=0x0) at /home/elenst/git/10.2/sql/log.cc:9857 #4 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #5 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 17 (Thread 0x7f7742995700 (LWP 52148)): #0 0x00007f776d5e9709 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b4486e in os_event::timed_wait (this=0x55e77df08650, abstime=0x7f7742994e80) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055e779b44b8b in os_event::wait_time_low (this=0x55e77df08650, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055e779b44d69 in os_event_wait_time_low (event=0x55e77df08650, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055e779b12b4d in lock_wait_timeout_thread () at /home/elenst/git/10.2/storage/innobase/lock/lock0wait.cc:547 #5 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 16 (Thread 0x7f77397fa700 (LWP 52158)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x55e77d3d2ba0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x55e77d3d2ba0, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x55e77d3d2ba0, reset_sig_count=0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779d0e1ac in buf_dump_thread () at /home/elenst/git/10.2/storage/innobase/buf/buf0dump.cc:777 #5 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 15 (Thread 0x7f7743997700 (LWP 52145)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f7743996c20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f7743996c20, m1=0x7f7743996cc8, m2=0x7f7743996cd0, request=0x7f7743996d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=9, m1=0x7f7743996cc8, m2=0x7f7743996cd0, request=0x7f7743996d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=9, m1=0x7f7743996cc8, m2=0x7f7743996cd0, request=0x7f7743996d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=9) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2b28 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 14 (Thread 0x7f773bfff700 (LWP 52153)): #0 0x00007f776d5e9709 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b4486e in os_event::timed_wait (this=0x55e77dd0c590, abstime=0x7f773bffec70) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055e779b44b8b in os_event::wait_time_low (this=0x55e77dd0c590, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055e779b44d69 in os_event_wait_time_low (event=0x55e77dd0c590, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055e779c9b845 in ib_wqueue_timedwait (wq=0x55e77dd0c420, wait_in_usecs=5000000) at /home/elenst/git/10.2/storage/innobase/ut/ut0wqueue.cc:163 #5 0x000055e779dd3b31 in fts_optimize_thread (arg=0x55e77dd0c420) at /home/elenst/git/10.2/storage/innobase/fts/fts0opt.cc:3035 #6 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #7 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 13 (Thread 0x7f7744198700 (LWP 52144)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f7744197c20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f7744197c20, m1=0x7f7744197cc8, m2=0x7f7744197cd0, request=0x7f7744197d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=8, m1=0x7f7744197cc8, m2=0x7f7744197cd0, request=0x7f7744197d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=8, m1=0x7f7744197cc8, m2=0x7f7744197cd0, request=0x7f7744197d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=8) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2b20 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 12 (Thread 0x7f773b7fe700 (LWP 52154)): #0 0x00007f776d5e9360 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b44fe0 in os_event::wait (this=0x55e77d3d28a0) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:166 #2 0x000055e779b44a04 in os_event::wait_low (this=0x55e77d3d28a0, reset_sig_count=1296) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:336 #3 0x000055e779b44d8e in os_event_wait_low (event=0x55e77d3d28a0, reset_sig_count=1296) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:535 #4 0x000055e779c2d13a in srv_resume_thread (slot=0x55e77a9ae848 , sig_count=1296, wait=true, timeout_usec=0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x000055e779c3124e in srv_purge_coordinator_suspend (slot=0x55e77a9ae848 , rseg_history_len=93) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2753 #6 0x000055e779c315f3 in srv_purge_coordinator_thread (arg=0x0) at /home/elenst/git/10.2/storage/innobase/srv/srv0srv.cc:2840 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 11 (Thread 0x7f774619c700 (LWP 52140)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f774619bc20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f774619bc20, m1=0x7f774619bcc8, m2=0x7f774619bcd0, request=0x7f774619bd00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=4, m1=0x7f774619bcc8, m2=0x7f774619bcd0, request=0x7f774619bd00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=4, m1=0x7f774619bcc8, m2=0x7f774619bcd0, request=0x7f774619bd00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=4) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2b00 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 10 (Thread 0x7f774699d700 (LWP 52139)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f774699cc20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f774699cc20, m1=0x7f774699ccc8, m2=0x7f774699ccd0, request=0x7f774699cd00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=3, m1=0x7f774699ccc8, m2=0x7f774699ccd0, request=0x7f774699cd00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=3, m1=0x7f774699ccc8, m2=0x7f774699ccd0, request=0x7f774699cd00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=3) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2af8 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 9 (Thread 0x7f7743196700 (LWP 52146)): #0 0x00007f776d5e9709 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779b4486e in os_event::timed_wait (this=0x55e77d3d2c20, abstime=0x7f7743195c10) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:286 #2 0x000055e779b44b8b in os_event::wait_time_low (this=0x55e77d3d2c20, time_in_usec=1000000, reset_sig_count=2) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:413 #3 0x000055e779b44d69 in os_event_wait_time_low (event=0x55e77d3d2c20, time_in_usec=1000000, reset_sig_count=2) at /home/elenst/git/10.2/storage/innobase/os/os0event.cc:518 #4 0x000055e779d17900 in pc_sleep_if_needed (next_loop_time=1520437526948, sig_count=2, cur_time=1520437525948) at /home/elenst/git/10.2/storage/innobase/buf/buf0flu.cc:2718 #5 0x000055e779d18810 in buf_flush_page_cleaner_coordinator () at /home/elenst/git/10.2/storage/innobase/buf/buf0flu.cc:3203 #6 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #7 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 8 (Thread 0x7f7754ff6700 (LWP 52136)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f7754ff5c20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f7754ff5c20, m1=0x7f7754ff5cc8, m2=0x7f7754ff5cd0, request=0x7f7754ff5d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=0, m1=0x7f7754ff5cc8, m2=0x7f7754ff5cd0, request=0x7f7754ff5d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=0, m1=0x7f7754ff5cc8, m2=0x7f7754ff5cd0, request=0x7f7754ff5d00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=0) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2ae0 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 7 (Thread 0x7f774719e700 (LWP 52138)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f774719dc20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f774719dc20, m1=0x7f774719dcc8, m2=0x7f774719dcd0, request=0x7f774719dd00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=2, m1=0x7f774719dcc8, m2=0x7f774719dcd0, request=0x7f774719dd00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=2, m1=0x7f774719dcc8, m2=0x7f774719dcd0, request=0x7f774719dd00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=2) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2af0 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 6 (Thread 0x7f774599b700 (LWP 52141)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f774599ac20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f774599ac20, m1=0x7f774599acc8, m2=0x7f774599acd0, request=0x7f774599ad00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=5, m1=0x7f774599acc8, m2=0x7f774599acd0, request=0x7f774599ad00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=5, m1=0x7f774599acc8, m2=0x7f774599acd0, request=0x7f774599ad00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=5) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2b08 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 5 (Thread 0x7f774799f700 (LWP 52137)): #0 0x00007f776e4fc64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x000055e779b37f09 in LinuxAIOHandler::collect (this=0x7f774799ec20) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:1893 #2 0x000055e779b3843c in LinuxAIOHandler::poll (this=0x7f774799ec20, m1=0x7f774799ecc8, m2=0x7f774799ecd0, request=0x7f774799ed00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2038 #3 0x000055e779b385b4 in os_aio_linux_handler (global_segment=1, m1=0x7f774799ecc8, m2=0x7f774799ecd0, request=0x7f774799ed00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:2092 #4 0x000055e779b3d307 in os_aio_handler (segment=1, m1=0x7f774799ecc8, m2=0x7f774799ecd0, request=0x7f774799ed00) at /home/elenst/git/10.2/storage/innobase/os/os0file.cc:5720 #5 0x000055e779d8c16a in fil_aio_wait (segment=1) at /home/elenst/git/10.2/storage/innobase/fil/fil0fil.cc:5330 #6 0x000055e779c33d60 in io_handler_thread (arg=0x55e77abe2ae8 ) at /home/elenst/git/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #8 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 4 (Thread 0x7f776e90d740 (LWP 52133)): #0 0x00007f776ca6cb5d in poll () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x000055e779520724 in handle_connections_sockets () at /home/elenst/git/10.2/sql/mysqld.cc:6584 #2 0x000055e77951f9f2 in mysqld_main (argc=20, argv=0x55e77d2475a8) at /home/elenst/git/10.2/sql/mysqld.cc:6050 #3 0x000055e779514120 in main (argc=20, argv=0x7ffce8d45ce8) at /home/elenst/git/10.2/sql/main.cc:25 Thread 3 (Thread 0x7f7757e16700 (LWP 52135)): #0 0x00007f776d5e9709 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779fdef6a in safe_cond_timedwait (cond=0x55e77b3f4100 , mp=0x55e77b3f4040 , abstime=0x7f7757e15e50, file=0x55e77a307520 "/home/elenst/git/10.2/include/mysql/psi/mysql_thread.h", line=1186) at /home/elenst/git/10.2/mysys/thr_mutex.c:545 #2 0x000055e779e63af4 in inline_mysql_cond_timedwait (that=0x55e77b3f4100 , mutex=0x55e77b3f4040 , abstime=0x7f7757e15e50, src_file=0x55e77a307558 "/home/elenst/git/10.2/storage/maria/ma_servicethread.c", src_line=116) at /home/elenst/git/10.2/include/mysql/psi/mysql_thread.h:1186 #3 0x000055e779e63fa7 in my_service_thread_sleep (control=0x55e77a9b1b00 , sleep_time=30000000000) at /home/elenst/git/10.2/storage/maria/ma_servicethread.c:115 #4 0x000055e779e58bf1 in ma_checkpoint_background (arg=0x1e) at /home/elenst/git/10.2/storage/maria/ma_checkpoint.c:709 #5 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #6 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 2 (Thread 0x7f776c971700 (LWP 52134)): #0 0x00007f776d5e9709 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779fdef6a in safe_cond_timedwait (cond=0x55e77b405920 , mp=0x55e77b405860 , abstime=0x7f776c970f00, file=0x55e77a342bf0 "/home/elenst/git/10.2/include/mysql/psi/mysql_thread.h", line=1186) at /home/elenst/git/10.2/mysys/thr_mutex.c:545 #2 0x000055e779fdff2e in inline_mysql_cond_timedwait (that=0x55e77b405920 , mutex=0x55e77b405860 , abstime=0x7f776c970f00, src_file=0x55e77a342c28 "/home/elenst/git/10.2/mysys/thr_timer.c", src_line=292) at /home/elenst/git/10.2/include/mysql/psi/mysql_thread.h:1186 #3 0x000055e779fe09ec in timer_handler (arg=0x0) at /home/elenst/git/10.2/mysys/thr_timer.c:292 #4 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #5 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 1 (Thread 0x7f77551c9700 (LWP 52174)): #0 0x00007f776d5ea59f in pthread_kill () from /lib/x86_64-linux-gnu/libpthread.so.0 #1 0x000055e779fd96e2 in my_write_core (sig=6) at /home/elenst/git/10.2/mysys/stacktrace.c:477 #2 0x000055e77986c2e3 in handle_fatal_signal (sig=6) at /home/elenst/git/10.2/sql/signal_handler.cc:305 #3 #4 0x00007f776c9a7428 in raise () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x00007f776c9a902a in abort () from /lib/x86_64-linux-gnu/libc.so.6 #6 0x00007f776c99fbd7 in ?? () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x00007f776c99fc82 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x000055e779cfc09d in buf_page_get_gen (page_id=..., page_size=..., rw_latch=1, guess=0x0, mode=10, file=0x55e77a258078 "/home/elenst/git/10.2/storage/innobase/include/trx0undo.ic", line=180, mtr=0x7f77551c5b40, err=0x0) at /home/elenst/git/10.2/storage/innobase/buf/buf0buf.cc:4755 #9 0x000055e779c74b95 in trx_undo_page_get_s_latched (page_id=..., mtr=0x7f77551c5b40) at /home/elenst/git/10.2/storage/innobase/include/trx0undo.ic:179 #10 0x000055e779c77864 in trx_roll_pop_top_rec (trx=0x7f7757217198, undo=0x7f76e403b960, mtr=0x7f77551c5b40) at /home/elenst/git/10.2/storage/innobase/trx/trx0roll.cc:991 #11 0x000055e779c77e14 in trx_roll_pop_top_rec_of_trx (trx=0x7f7757217198, roll_ptr=0x7f76e415e610, heap=0x7f76e415eae0) at /home/elenst/git/10.2/storage/innobase/trx/trx0roll.cc:1077 #12 0x000055e779c12aaa in row_undo (node=0x7f76e415e5c8, thr=0x7f76e415e410) at /home/elenst/git/10.2/storage/innobase/row/row0undo.cc:269 #13 0x000055e779c12d20 in row_undo_step (thr=0x7f76e415e410) at /home/elenst/git/10.2/storage/innobase/row/row0undo.cc:352 #14 0x000055e779b75215 in que_thr_step (thr=0x7f76e415e410) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1047 #15 0x000055e779b7542f in que_run_threads_low (thr=0x7f76e415e410) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1111 #16 0x000055e779b755d8 in que_run_threads (thr=0x7f76e415e410) at /home/elenst/git/10.2/storage/innobase/que/que0que.cc:1151 #17 0x000055e779c7506e in trx_rollback_to_savepoint_low (trx=0x7f7757217198, savept=0x0) at /home/elenst/git/10.2/storage/innobase/trx/trx0roll.cc:112 #18 0x000055e779c753d9 in trx_rollback_for_mysql_low (trx=0x7f7757217198) at /home/elenst/git/10.2/storage/innobase/trx/trx0roll.cc:174 #19 0x000055e779c756d0 in trx_rollback_low (trx=0x7f7757217198) at /home/elenst/git/10.2/storage/innobase/trx/trx0roll.cc:206 #20 0x000055e779c75a07 in trx_rollback_for_mysql (trx=0x7f7757217198) at /home/elenst/git/10.2/storage/innobase/trx/trx0roll.cc:282 #21 0x000055e779a7befe in innobase_rollback (hton=0x55e77d2d9740, thd=0x7f76e4000b00, rollback_trx=true) at /home/elenst/git/10.2/storage/innobase/handler/ha_innodb.cc:4862 #22 0x000055e77986ffe0 in ha_rollback_trans (thd=0x7f76e4000b00, all=true) at /home/elenst/git/10.2/sql/handler.cc:1672 #23 0x000055e779759585 in xa_trans_force_rollback (thd=0x7f76e4000b00) at /home/elenst/git/10.2/sql/transaction.cc:141 #24 0x000055e77975b488 in trans_xa_commit (thd=0x7f76e4000b00) at /home/elenst/git/10.2/sql/transaction.cc:922 #25 0x000055e779604619 in mysql_execute_command (thd=0x7f76e4000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:6074 #26 0x000055e779609a82 in mysql_parse (thd=0x7f76e4000b00, rawbuf=0x7f76e40111c8 "XA COMMIT 'xid191' /* QNO 11370 CON_ID 17 */", length=45, parser_state=0x7f77551c8250, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:7902 #27 0x000055e7795f76b3 in dispatch_command (command=COM_QUERY, thd=0x7f76e4000b00, packet=0x7f76e4008951 "XA COMMIT 'xid191' /* QNO 11370 CON_ID 17 */ ", packet_length=46, is_com_multi=false, is_next_command=false) at /home/elenst/git/10.2/sql/sql_parse.cc:1806 #28 0x000055e7795f600f in do_command (thd=0x7f76e4000b00) at /home/elenst/git/10.2/sql/sql_parse.cc:1360 #29 0x000055e77974436f in do_handle_one_connection (connect=0x55e77dd44eb0) at /home/elenst/git/10.2/sql/sql_connect.cc:1335 #30 0x000055e7797440ef in handle_one_connection (arg=0x55e77dd44eb0) at /home/elenst/git/10.2/sql/sql_connect.cc:1241 #31 0x00007f776d5e36ba in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0 #32 0x00007f776ca7882d in clone () from /lib/x86_64-linux-gnu/libc.so.6