[New LWP 61256] [New LWP 61214] [New LWP 61227] [New LWP 61225] [New LWP 61224] [New LWP 61223] [New LWP 61222] [New LWP 61229] [New LWP 61220] [New LWP 61217] [New LWP 61221] [New LWP 61233] [New LWP 61216] [New LWP 61230] [New LWP 61236] [New LWP 61248] [New LWP 61242] [New LWP 61239] [New LWP 61258] [New LWP 61228] [New LWP 61237] [New LWP 61260] [New LWP 61240] [New LWP 61264] [New LWP 61218] [New LWP 61262] [New LWP 61219] [New LWP 61244] [New LWP 61231] [New LWP 61232] [New LWP 61238] [New LWP 61235] [New LWP 61265] [New LWP 61234] [New LWP 61241] [New LWP 61213] [New LWP 61243] [New LWP 61247] [New LWP 61215] [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/10.2/debug/sql/mysqld --no-defaults --basedir=/home/elenst/10.2/de'. Program terminated with signal SIGSEGV, Segmentation fault. #0 __pthread_kill (threadid=, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 [Current thread is 1 (Thread 0x7fb264534700 (LWP 61256))] Thread 39 (Thread 0x7fb24f0f7700 (LWP 61215)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24f0f6c20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24f0f6c20, m1=0x7fb24f0f6cc8, m2=0x7fb24f0f6cd0, request=0x7fb24f0f6d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=0, m1=0x7fb24f0f6cc8, m2=0x7fb24f0f6cd0, request=0x7fb24f0f6d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=0, m1=0x7fb24f0f6cc8, m2=0x7fb24f0f6cd0, request=0x7fb24f0f6d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=0) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263c60 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24f0f7700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 38 (Thread 0x7fb2645c8700 (LWP 61247)): #0 0x00007fb266ee8d8d in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005643806c18b3 in vio_io_wait (vio=0x564382e42d60, event=VIO_IO_EVENT_READ, timeout=28800000) at /home/elenst/10.2/vio/viosocket.c:945 #2 0x00005643806c00c2 in vio_socket_io_wait (vio=0x564382e42d60, event=VIO_IO_EVENT_READ) at /home/elenst/10.2/vio/viosocket.c:108 #3 0x00005643806c0278 in vio_read (vio=0x564382e42d60, buf=0x7fb1f4008950 "\a", size=4) at /home/elenst/10.2/vio/viosocket.c:184 #4 0x000056437fbb3365 in my_real_read (net=0x7fb1f4000df0, complen=0x7fb2645c7990, header=1 '\001') at /home/elenst/10.2/sql/net_serv.cc:892 #5 0x000056437fbb3b66 in my_net_read_packet_reallen (net=0x7fb1f4000df0, read_from_server=1 '\001', reallen=0x7fb2645c79f8) at /home/elenst/10.2/sql/net_serv.cc:1162 #6 0x000056437fbb3b1a in my_net_read_packet (net=0x7fb1f4000df0, read_from_server=1 '\001') at /home/elenst/10.2/sql/net_serv.cc:1146 #7 0x000056437fc7c7f1 in do_command (thd=0x7fb1f4000b00) at /home/elenst/10.2/sql/sql_parse.cc:1242 #8 0x000056437fdca17d in do_handle_one_connection (connect=0x564383848fa0) at /home/elenst/10.2/sql/sql_connect.cc:1335 #9 0x000056437fdc9efd in handle_one_connection (arg=0x564383848fa0) at /home/elenst/10.2/sql/sql_connect.cc:1241 #10 0x00007fb267a626da in start_thread (arg=0x7fb2645c8700) at pthread_create.c:456 #11 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 37 (Thread 0x7fb26465c700 (LWP 61243)): #0 do_sigwait (sig=0x7fb26465be50, set=) at ../sysdeps/unix/sysv/linux/sigwait.c:64 #1 __sigwait (set=, sig=0x7fb26465be50) at ../sysdeps/unix/sysv/linux/sigwait.c:96 #2 0x000056437fba2583 in signal_hand (arg=0x0) at /home/elenst/10.2/sql/mysqld.cc:3505 #3 0x00007fb267a626da in start_thread (arg=0x7fb26465c700) at pthread_create.c:456 #4 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 36 (Thread 0x7fb268d91740 (LWP 61213)): #0 0x00007fb266ee8d8d in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x000056437fba831f in handle_connections_sockets () at /home/elenst/10.2/sql/mysqld.cc:6586 #2 0x000056437fba75ed in mysqld_main (argc=20, argv=0x564382da35a8) at /home/elenst/10.2/sql/mysqld.cc:6052 #3 0x000056437fb9bc80 in main (argc=20, argv=0x7ffd9ee54b38) at /home/elenst/10.2/sql/main.cc:25 Thread 35 (Thread 0x7fb2397fa700 (LWP 61241)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643806618c6 in safe_cond_timedwait (cond=0x564381a75280 , mp=0x564381a751c0 , abstime=0x7fb2397f9e50, file=0x564380985bf0 "/home/elenst/10.2/include/mysql/psi/mysql_thread.h", line=1186) at /home/elenst/10.2/mysys/thr_mutex.c:545 #2 0x00005643804e16e0 in inline_mysql_cond_timedwait (that=0x564381a75280 , mutex=0x564381a751c0 , abstime=0x7fb2397f9e50, src_file=0x564380985c28 "/home/elenst/10.2/storage/maria/ma_servicethread.c", src_line=116) at /home/elenst/10.2/include/mysql/psi/mysql_thread.h:1186 #3 0x00005643804e1b93 in my_service_thread_sleep (control=0x564381032bc0 , sleep_time=30000000000) at /home/elenst/10.2/storage/maria/ma_servicethread.c:115 #4 0x00005643804d67df in ma_checkpoint_background (arg=0x1e) at /home/elenst/10.2/storage/maria/ma_checkpoint.c:709 #5 0x00007fb267a626da in start_thread (arg=0x7fb2397fa700) at pthread_create.c:456 #6 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 34 (Thread 0x7fb2417fa700 (LWP 61234)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643801c0988 in os_event::wait (this=0x564382e6da90) at /home/elenst/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005643801c03b4 in os_event::wait_low (this=0x564382e6da90, reset_sig_count=301) at /home/elenst/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005643801c0731 in os_event_wait_low (event=0x564382e6da90, reset_sig_count=0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:535 #4 0x00005643802a99ca in srv_resume_thread (slot=0x56438102f940 , sig_count=0, wait=true, timeout_usec=0) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x00005643802ad3b8 in srv_worker_thread (arg=0x0) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:2600 #6 0x00007fb267a626da in start_thread (arg=0x7fb2417fa700) at pthread_create.c:456 #7 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 33 (Thread 0x7fb2643c2700 (LWP 61265)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643806618c6 in safe_cond_timedwait (cond=0x5643811f0f80 , mp=0x5643811f3740 , abstime=0x7fb2643c1df0, file=0x5643806f1c20 "/home/elenst/10.2/include/mysql/psi/mysql_thread.h", line=1186) at /home/elenst/10.2/mysys/thr_mutex.c:545 #2 0x000056437fb9c51c in inline_mysql_cond_timedwait (that=0x5643811f0f80 , mutex=0x5643811f3740 , abstime=0x7fb2643c1df0, src_file=0x5643806f3a70 "/home/elenst/10.2/sql/mysqld.cc", src_line=2968) at /home/elenst/10.2/include/mysql/psi/mysql_thread.h:1186 #3 0x000056437fba164e in cache_thread (thd=0x7fb1d0000b00) at /home/elenst/10.2/sql/mysqld.cc:2967 #4 0x000056437fba18bf in one_thread_per_connection_end (thd=0x7fb1d0000b00, put_in_cache=true) at /home/elenst/10.2/sql/mysqld.cc:3056 #5 0x000056437fdca257 in do_handle_one_connection (connect=0x5643837bab50) at /home/elenst/10.2/sql/sql_connect.cc:1354 #6 0x000056437fdc9efd in handle_one_connection (arg=0x5643837bab50) at /home/elenst/10.2/sql/sql_connect.cc:1241 #7 0x00007fb267a626da in start_thread (arg=0x7fb2643c2700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 32 (Thread 0x7fb240ff9700 (LWP 61235)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643801c0988 in os_event::wait (this=0x564382e6db10) at /home/elenst/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005643801c03b4 in os_event::wait_low (this=0x564382e6db10, reset_sig_count=271) at /home/elenst/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005643801c0731 in os_event_wait_low (event=0x564382e6db10, reset_sig_count=0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:535 #4 0x00005643802a99ca in srv_resume_thread (slot=0x56438102f978 , sig_count=0, wait=true, timeout_usec=0) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x00005643802ad3b8 in srv_worker_thread (arg=0x0) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:2600 #6 0x00007fb267a626da in start_thread (arg=0x7fb240ff9700) at pthread_create.c:456 #7 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 31 (Thread 0x7fb23affd700 (LWP 61238)): #0 0x00007fb267a6bd2d in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005643801c0ca8 in os_thread_sleep (tm=1000000) at /home/elenst/10.2/storage/innobase/os/os0thread.cc:230 #2 0x00005643803665ed in btr_defragment_thread () at /home/elenst/10.2/storage/innobase/btr/btr0defragment.cc:760 #3 0x00007fb267a626da in start_thread (arg=0x7fb23affd700) at pthread_create.c:456 #4 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 30 (Thread 0x7fb2427fc700 (LWP 61232)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643801c021e in os_event::timed_wait (this=0x56438345e190, abstime=0x7fb2427fbc70) at /home/elenst/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005643801c0552 in os_event::wait_time_low (this=0x56438345e190, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005643801c070c in os_event_wait_time_low (event=0x56438345e190, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005643803177ca in ib_wqueue_timedwait (wq=0x56438345e020, wait_in_usecs=5000000) at /home/elenst/10.2/storage/innobase/ut/ut0wqueue.cc:163 #5 0x00005643804513be in fts_optimize_thread (arg=0x56438345e020) at /home/elenst/10.2/storage/innobase/fts/fts0opt.cc:3035 #6 0x00007fb267a626da in start_thread (arg=0x7fb2427fc700) at pthread_create.c:456 #7 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 29 (Thread 0x7fb242ffd700 (LWP 61231)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643801c021e in os_event::timed_wait (this=0x56438340e920, abstime=0x7fb242ffcea0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005643801c0552 in os_event::wait_time_low (this=0x56438340e920, time_in_usec=10000000, reset_sig_count=23) at /home/elenst/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005643801c070c in os_event_wait_time_low (event=0x56438340e920, time_in_usec=10000000, reset_sig_count=0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005643803f0ccd in dict_stats_thread () at /home/elenst/10.2/storage/innobase/dict/dict0stats_bg.cc:451 #5 0x00007fb267a626da in start_thread (arg=0x7fb242ffd700) at pthread_create.c:456 #6 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 28 (Thread 0x7fb264612700 (LWP 61244)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643806615bc in safe_cond_wait (cond=0x5643811f0fc0 , mp=0x5643811f41c0 , file=0x5643806ff8e0 "/home/elenst/10.2/include/mysql/psi/mysql_thread.h", line=1149) at /home/elenst/10.2/mysys/thr_mutex.c:491 #2 0x000056437fbcb2fc in inline_mysql_cond_wait (that=0x5643811f0fc0 , mutex=0x5643811f41c0 , src_file=0x5643807001a8 "/home/elenst/10.2/sql/slave.cc", src_line=334) at /home/elenst/10.2/include/mysql/psi/mysql_thread.h:1149 #3 0x000056437fbcbee4 in handle_slave_background (arg=0x0) at /home/elenst/10.2/sql/slave.cc:334 #4 0x00007fb267a626da in start_thread (arg=0x7fb264612700) at pthread_create.c:456 #5 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 27 (Thread 0x7fb24d0f3700 (LWP 61219)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24d0f2c20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24d0f2c20, m1=0x7fb24d0f2cc8, m2=0x7fb24d0f2cd0, request=0x7fb24d0f2d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=4, m1=0x7fb24d0f2cc8, m2=0x7fb24d0f2cd0, request=0x7fb24d0f2d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=4, m1=0x7fb24d0f2cc8, m2=0x7fb24d0f2cd0, request=0x7fb24d0f2d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=4) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263c80 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24d0f3700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 26 (Thread 0x7fb264456700 (LWP 61262)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643801c0988 in os_event::wait (this=0x7fb1e0011020) at /home/elenst/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005643801c03b4 in os_event::wait_low (this=0x7fb1e0011020, reset_sig_count=4) at /home/elenst/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005643801c0731 in os_event_wait_low (event=0x7fb1e0011020, reset_sig_count=0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:535 #4 0x000056438018e43a in lock_wait_suspend_thread (thr=0x7fb1f8905390) at /home/elenst/10.2/storage/innobase/lock/lock0wait.cc:355 #5 0x000056438023de73 in row_mysql_handle_errors (new_err=0x7fb264452a68, trx=0x7fb264a91508, thr=0x7fb1f8905390, savept=0x0) at /home/elenst/10.2/storage/innobase/row/row0mysql.cc:735 #6 0x0000564380279b82 in row_search_mvcc (buf=0x7fb1f88f08b8 "\377\377\377\377\377\377\377", mode=PAGE_CUR_G, prebuilt=0x7fb1f8903d18, match_mode=0, direction=0) at /home/elenst/10.2/storage/innobase/row/row0sel.cc:5628 #7 0x0000564380101e98 in ha_innobase::index_read (this=0x7fb1f88f00c8, buf=0x7fb1f88f08b8 "\377\377\377\377\377\377\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at /home/elenst/10.2/storage/innobase/handler/ha_innodb.cc:9687 #8 0x0000564380103270 in ha_innobase::index_first (this=0x7fb1f88f00c8, buf=0x7fb1f88f08b8 "\377\377\377\377\377\377\377") at /home/elenst/10.2/storage/innobase/handler/ha_innodb.cc:10125 #9 0x00005643801034f4 in ha_innobase::rnd_next (this=0x7fb1f88f00c8, buf=0x7fb1f88f08b8 "\377\377\377\377\377\377\377") at /home/elenst/10.2/storage/innobase/handler/ha_innodb.cc:10221 #10 0x000056437fef79e5 in handler::ha_rnd_next (this=0x7fb1f88f00c8, buf=0x7fb1f88f08b8 "\377\377\377\377\377\377\377") at /home/elenst/10.2/sql/handler.cc:2578 #11 0x000056438005e548 in rr_sequential (info=0x7fb264453f20) at /home/elenst/10.2/sql/records.cc:485 #12 0x00005643800893f3 in mysql_delete (thd=0x7fb1d8000b00, table_list=0x7fb1d8011370, conds=0x7fb1d8011bc8, order_list=0x7fb1d8005040, limit=18446744073709551615, options=549755813888, result=0x0) at /home/elenst/10.2/sql/sql_delete.cc:559 #13 0x000056437fc8605d in mysql_execute_command (thd=0x7fb1d8000b00) at /home/elenst/10.2/sql/sql_parse.cc:4613 #14 0x000056437fc906fc in mysql_parse (thd=0x7fb1d8000b00, rawbuf=0x7fb1d80111c8 "DELETE FROM `table0_innodb` WHERE `col_char_utf8_default_null` < RAND() /* QNO 333 CON_ID 20 */", length=96, parser_state=0x7fb264455250, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:7902 #15 0x000056437fc7e386 in dispatch_command (command=COM_QUERY, thd=0x7fb1d8000b00, packet=0x7fb1d8008951 " DELETE FROM `table0_innodb` WHERE `col_char_utf8_default_null` < RAND() /* QNO 333 CON_ID 20 */ ", packet_length=98, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:1806 #16 0x000056437fc7cd22 in do_command (thd=0x7fb1d8000b00) at /home/elenst/10.2/sql/sql_parse.cc:1359 #17 0x000056437fdca17d in do_handle_one_connection (connect=0x5643837bab50) at /home/elenst/10.2/sql/sql_connect.cc:1335 #18 0x000056437fdc9efd in handle_one_connection (arg=0x5643837bab50) at /home/elenst/10.2/sql/sql_connect.cc:1241 #19 0x00007fb267a626da in start_thread (arg=0x7fb264456700) at pthread_create.c:456 #20 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 25 (Thread 0x7fb24d8f4700 (LWP 61218)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24d8f3c20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24d8f3c20, m1=0x7fb24d8f3cc8, m2=0x7fb24d8f3cd0, request=0x7fb24d8f3d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=3, m1=0x7fb24d8f3cc8, m2=0x7fb24d8f3cd0, request=0x7fb24d8f3d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=3, m1=0x7fb24d8f3cc8, m2=0x7fb24d8f3cd0, request=0x7fb24d8f3d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=3) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263c78 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24d8f4700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 24 (Thread 0x7fb26440c700 (LWP 61264)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643801c0988 in os_event::wait (this=0x7fb1dc01c8c0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005643801c03b4 in os_event::wait_low (this=0x7fb1dc01c8c0, reset_sig_count=8) at /home/elenst/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005643801c0731 in os_event_wait_low (event=0x7fb1dc01c8c0, reset_sig_count=0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:535 #4 0x000056438018e43a in lock_wait_suspend_thread (thr=0x7fb1f8a2bce0) at /home/elenst/10.2/storage/innobase/lock/lock0wait.cc:355 #5 0x000056438023de73 in row_mysql_handle_errors (new_err=0x7fb2644088a8, trx=0x7fb264a91d68, thr=0x7fb1f8a2bce0, savept=0x0) at /home/elenst/10.2/storage/innobase/row/row0mysql.cc:735 #6 0x0000564380279b82 in row_search_mvcc (buf=0x7fb1f8a17208 "\377\357\377\377\377\377\377 ", mode=PAGE_CUR_G, prebuilt=0x7fb1f8a2a668, match_mode=0, direction=1) at /home/elenst/10.2/storage/innobase/row/row0sel.cc:5628 #7 0x0000564380102f32 in ha_innobase::general_fetch (this=0x7fb1f8a16a18, buf=0x7fb1f8a17208 "\377\357\377\377\377\377\377 ", direction=1, match_mode=0) at /home/elenst/10.2/storage/innobase/handler/ha_innodb.cc:10016 #8 0x000056438010352d in ha_innobase::rnd_next (this=0x7fb1f8a16a18, buf=0x7fb1f8a17208 "\377\357\377\377\377\377\377 ") at /home/elenst/10.2/storage/innobase/handler/ha_innodb.cc:10229 #9 0x000056437fef79e5 in handler::ha_rnd_next (this=0x7fb1f8a16a18, buf=0x7fb1f8a17208 "\377\357\377\377\377\377\377 ") at /home/elenst/10.2/sql/handler.cc:2578 #10 0x000056437feeca7c in find_all_keys (thd=0x7fb1cc000b00, param=0x7fb264409dc0, select=0x7fb1cc012528, fs_info=0x7fb1cc01de70, buffpek_pointers=0x7fb264409fc0, tempfile=0x7fb264409e50, pq=0x7fb264409d70, found_rows=0x7fb1cc01e050) at /home/elenst/10.2/sql/filesort.cc:789 #11 0x000056437feeb060 in filesort (thd=0x7fb1cc000b00, table=0x7fb1f8a15e10, filesort=0x7fb26440a290, tracker=0x7fb1cc012978, join=0x0, first_table_bit=0) at /home/elenst/10.2/sql/filesort.cc:274 #12 0x000056437fd6ca13 in mysql_update (thd=0x7fb1cc000b00, table_list=0x7fb1cc0113e8, fields=..., values=..., conds=0x7fb1cc011e20, order_num=1, order=0x7fb1cc0120d8, limit=9, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fb26440a8b0, updated_return=0x7fb26440a960) at /home/elenst/10.2/sql/sql_update.cc:552 #13 0x000056437fc84e49 in mysql_execute_command (thd=0x7fb1cc000b00) at /home/elenst/10.2/sql/sql_parse.cc:4273 #14 0x000056437fc906fc in mysql_parse (thd=0x7fb1cc000b00, rawbuf=0x7fb1cc0111c8 "UPDATE `table1_innodb` SET `col_int_unsigned` = 4 WHERE `col_enum_utf8_key_default_null` > 3 ORDER BY `col_char_utf8_not_null` LIMIT 9 /* QNO 289 CON_ID 21 */", length=159, parser_state=0x7fb26440b250, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:7902 #15 0x000056437fc7e386 in dispatch_command (command=COM_QUERY, thd=0x7fb1cc000b00, packet=0x7fb1cc008951 " UPDATE `table1_innodb` SET `col_int_unsigned` = 4 WHERE `col_enum_utf8_key_default_null` > 3 ORDER BY `col_char_utf8_not_null` LIMIT 9 /* QNO 289 CON_ID 21 */ ", packet_length=161, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:1806 #16 0x000056437fc7cd22 in do_command (thd=0x7fb1cc000b00) at /home/elenst/10.2/sql/sql_parse.cc:1359 #17 0x000056437fdca17d in do_handle_one_connection (connect=0x564383796f70) at /home/elenst/10.2/sql/sql_connect.cc:1335 #18 0x000056437fdc9efd in handle_one_connection (arg=0x564383796f70) at /home/elenst/10.2/sql/sql_connect.cc:1241 #19 0x00007fb267a626da in start_thread (arg=0x7fb26440c700) at pthread_create.c:456 #20 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 23 (Thread 0x7fb239ffb700 (LWP 61240)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643806615bc in safe_cond_wait (cond=0x7fb239ffae10, mp=0x7fb239ffae50, file=0x564380822ba0 "/home/elenst/10.2/include/mysql/psi/mysql_thread.h", line=1149) at /home/elenst/10.2/mysys/thr_mutex.c:491 #2 0x00005643800ec366 in inline_mysql_cond_wait (that=0x7fb239ffae10, mutex=0x7fb239ffae50, src_file=0x5643808244a0 "/home/elenst/10.2/storage/innobase/handler/ha_innodb.cc", src_line=338) at /home/elenst/10.2/include/mysql/psi/mysql_thread.h:1149 #3 0x00005643800f0b95 in thd_destructor_proxy () at /home/elenst/10.2/storage/innobase/handler/ha_innodb.cc:338 #4 0x00007fb267a626da in start_thread (arg=0x7fb239ffb700) at pthread_create.c:456 #5 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 22 (Thread 0x7fb2644a0700 (LWP 61260)): #0 __lll_lock_wait () at ../sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135 #1 0x00007fb267a64f0d in __GI___pthread_mutex_lock (mutex=0x56438126e390 ) at ../nptl/pthread_mutex_lock.c:80 #2 0x000056438016b525 in OSMutex::enter (this=0x56438126e388 ) at /home/elenst/10.2/storage/innobase/include/sync0types.h:471 #3 0x00005643801bdd7f in OSTrackMutex::enter (this=0x56438126e380 , max_spins=30, max_delay=6, filename=0x5643808c9d30 "/home/elenst/10.2/storage/innobase/sync/sync0debug.cc", line=1268) at /home/elenst/10.2/storage/innobase/include/ib0mutex.h:109 #4 0x00005643801bd583 in PolicyMutex >::enter (this=0x56438126e380 , n_spins=30, n_delay=6, name=0x5643808c9d30 "/home/elenst/10.2/storage/innobase/sync/sync0debug.cc", line=1268) at /home/elenst/10.2/storage/innobase/include/ib0mutex.h:635 #5 0x00005643802c465c in rw_lock_debug_mutex_enter () at /home/elenst/10.2/storage/innobase/sync/sync0debug.cc:1268 #6 0x00005643802bdc9b in rw_lock_remove_debug_info (lock=0x7fb2511b5838, pass=0, lock_type=5) at /home/elenst/10.2/storage/innobase/sync/sync0rw.cc:989 #7 0x00005643801ae00b in rw_lock_x_unlock_func (pass=0, lock=0x7fb2511b5838) at /home/elenst/10.2/storage/innobase/include/sync0rw.ic:399 #8 0x00005643801ae44a in pfs_rw_lock_x_unlock_func (pass=0, lock=0x7fb2511b5838) at /home/elenst/10.2/storage/innobase/include/sync0rw.ic:782 #9 0x00005643801af0c2 in buf_page_release_latch (block=0x7fb2511b5760, rw_latch=2) at /home/elenst/10.2/storage/innobase/include/buf0buf.ic:1331 #10 0x00005643801af3ae in memo_latch_release (slot=0x7fb26449d258) at /home/elenst/10.2/storage/innobase/mtr/mtr0mtr.cc:263 #11 0x00005643801b1860 in ReleaseLatches::operator() (this=0x7fb26449c587, slot=0x7fb26449d258) at /home/elenst/10.2/storage/innobase/mtr/mtr0mtr.cc:300 #12 0x00005643801b237c in Iterate::operator() (this=0x7fb26449c588, block=0x7fb26449d228) at /home/elenst/10.2/storage/innobase/mtr/mtr0mtr.cc:66 #13 0x00005643801b1f3e in dyn_buf_t<512ul>::for_each_block_in_reverse > (this=0x7fb26449d1f0, functor=...) at /home/elenst/10.2/storage/innobase/include/dyn0buf.h:367 #14 0x00005643801b0c3f in mtr_t::Command::release_latches (this=0x7fb26449c5e0) at /home/elenst/10.2/storage/innobase/mtr/mtr0mtr.cc:929 #15 0x00005643801b0de4 in mtr_t::Command::execute (this=0x7fb26449c5e0) at /home/elenst/10.2/storage/innobase/mtr/mtr0mtr.cc:973 #16 0x00005643801af95d in mtr_t::commit (this=0x7fb26449d1f0) at /home/elenst/10.2/storage/innobase/mtr/mtr0mtr.cc:571 #17 0x0000564380221c3d in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x7fb1f8222c88, offsets_heap=0x7fb1d40eae40, heap=0x7fb1d40eb2d0, entry=0x7fb1d4087f18, trx_id=0, thr=0x7fb1d405a8c8, dup_chk_only=false) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3114 #18 0x00005643802220d3 in row_ins_sec_index_entry (index=0x7fb1f8222c88, entry=0x7fb1d4087f18, thr=0x7fb1d405a8c8, dup_chk_only=false) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3244 #19 0x0000564380222244 in row_ins_index_entry (index=0x7fb1f8222c88, entry=0x7fb1d4087f18, thr=0x7fb1d405a8c8) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3292 #20 0x0000564380222732 in row_ins_index_entry_step (node=0x7fb1d4059d50, thr=0x7fb1d405a8c8) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3440 #21 0x0000564380222af0 in row_ins (node=0x7fb1d4059d50, thr=0x7fb1d405a8c8) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3582 #22 0x000056438022311e in row_ins_step (thr=0x7fb1d405a8c8) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3818 #23 0x000056438023f782 in row_insert_for_mysql (mysql_rec=0x7fb1d40235b8 "\233\067M\223\256\321", , prebuilt=0x7fb1d4058868) at /home/elenst/10.2/storage/innobase/row/row0mysql.cc:1407 #24 0x00005643800ff065 in ha_innobase::write_row (this=0x7fb1d4030cb8, record=0x7fb1d40235b8 "\233\067M\223\256\321", ) at /home/elenst/10.2/storage/innobase/handler/ha_innodb.cc:8442 #25 0x000056437ff00408 in handler::ha_write_row (this=0x7fb1d4030cb8, buf=0x7fb1d40235b8 "\233\067M\223\256\321", ) at /home/elenst/10.2/sql/handler.cc:6003 #26 0x000056437fc6061b in write_record (thd=0x7fb1d4000b00, table=0x7fb1d40300b0, info=0x7fb1d40c0cd8) at /home/elenst/10.2/sql/sql_insert.cc:1929 #27 0x000056437fc656c3 in select_insert::send_data (this=0x7fb1d40c0c98, values=...) at /home/elenst/10.2/sql/sql_insert.cc:3757 #28 0x000056437fcf4c72 in end_send (join=0x7fb1d40c0d40, join_tab=0x7fb1d40d8ee8, end_of_records=false) at /home/elenst/10.2/sql/sql_select.cc:19859 #29 0x000056437fcf2738 in evaluate_join_record (join=0x7fb1d40c0d40, join_tab=0x7fb1d40d8b38, error=0) at /home/elenst/10.2/sql/sql_select.cc:18911 #30 0x000056437fcf21d7 in sub_select (join=0x7fb1d40c0d40, join_tab=0x7fb1d40d8b38, end_of_records=false) at /home/elenst/10.2/sql/sql_select.cc:18730 #31 0x000056437fcf15b1 in do_select (join=0x7fb1d40c0d40, procedure=0x0) at /home/elenst/10.2/sql/sql_select.cc:18235 #32 0x000056437fccc0d1 in JOIN::exec_inner (this=0x7fb1d40c0d40) at /home/elenst/10.2/sql/sql_select.cc:3566 #33 0x000056437fccb580 in JOIN::exec (this=0x7fb1d40c0d40) at /home/elenst/10.2/sql/sql_select.cc:3361 #34 0x000056437fccc742 in mysql_select (thd=0x7fb1d4000b00, tables=0x7fb1d4011bd8, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=553245739776, result=0x7fb1d40c0c98, unit=0x7fb1d40046a8, select_lex=0x7fb1d4004de0) at /home/elenst/10.2/sql/sql_select.cc:3761 #35 0x000056437fcc0e17 in handle_select (thd=0x7fb1d4000b00, lex=0x7fb1d40045e0, result=0x7fb1d40c0c98, setup_tables_done_option=1073741824) at /home/elenst/10.2/sql/sql_select.cc:364 #36 0x000056437fc85b90 in mysql_execute_command (thd=0x7fb1d4000b00) at /home/elenst/10.2/sql/sql_parse.cc:4525 #37 0x000056437fc906fc in mysql_parse (thd=0x7fb1d4000b00, rawbuf=0x7fb1d40111c8 "INSERT INTO `view_table10_innodb_int_autoinc` SELECT * FROM `view_table1_innodb_int_autoinc` /* QNO 294 CON_ID 19 */", length=116, parser_state=0x7fb26449f250, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:7902 #38 0x000056437fc7e386 in dispatch_command (command=COM_QUERY, thd=0x7fb1d4000b00, packet=0x7fb1d4008951 "INSERT INTO `view_table10_innodb_int_autoinc` SELECT * FROM `view_table1_innodb_int_autoinc` /* QNO 294 CON_ID 19 */ ", packet_length=117, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:1806 #39 0x000056437fc7cd22 in do_command (thd=0x7fb1d4000b00) at /home/elenst/10.2/sql/sql_parse.cc:1359 #40 0x000056437fdca17d in do_handle_one_connection (connect=0x564383796f70) at /home/elenst/10.2/sql/sql_connect.cc:1335 #41 0x000056437fdc9efd in handle_one_connection (arg=0x564383796f70) at /home/elenst/10.2/sql/sql_connect.cc:1241 #42 0x00007fb267a626da in start_thread (arg=0x7fb2644a0700) at pthread_create.c:456 #43 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 21 (Thread 0x7fb23b7fe700 (LWP 61237)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643801c0988 in os_event::wait (this=0x564382e6dd10) at /home/elenst/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005643801c03b4 in os_event::wait_low (this=0x564382e6dd10, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005643801c0731 in os_event_wait_low (event=0x564382e6dd10, reset_sig_count=0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:535 #4 0x000056438038ac3b in buf_dump_thread () at /home/elenst/10.2/storage/innobase/buf/buf0dump.cc:777 #5 0x00007fb267a626da in start_thread (arg=0x7fb23b7fe700) at pthread_create.c:456 #6 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 20 (Thread 0x7fb243fff700 (LWP 61228)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643801c021e in os_event::timed_wait (this=0x564382e6dc10, abstime=0x7fb243ffecc0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005643801c0552 in os_event::wait_time_low (this=0x564382e6dc10, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005643801c070c in os_event_wait_time_low (event=0x564382e6dc10, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005643802abd44 in srv_error_monitor_thread () at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:1922 #5 0x00007fb267a626da in start_thread (arg=0x7fb243fff700) at pthread_create.c:456 #6 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 19 (Thread 0x7fb2644ea700 (LWP 61258)): #0 0x00007fb2671c1613 in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1 #1 0x00007fb2671c1d2b in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1 #2 0x00007fb2671c2d40 in ?? () from /lib/x86_64-linux-gnu/libgcc_s.so.1 #3 0x00007fb2671c35f8 in _Unwind_Backtrace () from /lib/x86_64-linux-gnu/libgcc_s.so.1 #4 0x00007fb266f037df in __GI___backtrace (array=, size=) at ../sysdeps/x86_64/backtrace.c:110 #5 0x0000564380668489 in sf_malloc (size=8, my_flags=16) at /home/elenst/10.2/mysys/safemalloc.c:141 #6 0x00005643806559af in my_malloc (size=8, my_flags=16) at /home/elenst/10.2/mysys/my_malloc.c:101 #7 0x000056437fc99e32 in intern_plugin_lock (lex=0x0, rc=0x7fb2644e73a8, state_mask=8) at /home/elenst/10.2/sql/sql_plugin.cc:978 #8 0x000056437fc9e696 in plugin_foreach_with_mask (thd=0x7fb1e0000b00, func=0x56437fefd7fd , type=1, state_mask=8, arg=0x7fb1e004b678) at /home/elenst/10.2/sql/sql_plugin.cc:2379 #9 0x000056437fefda6a in ha_discover_table (thd=0x7fb1e0000b00, share=0x7fb1e004b678) at /home/elenst/10.2/sql/handler.cc:4940 #10 0x000056437fd7bab7 in open_table_def (thd=0x7fb1e0000b00, share=0x7fb1e004b678, flags=11) at /home/elenst/10.2/sql/table.cc:604 #11 0x000056437fe6db3b in tdc_acquire_share (thd=0x7fb1e0000b00, tl=0x7fb1e006da30, flags=3, out_table=0x7fb2644e7838) at /home/elenst/10.2/sql/table_cache.cc:825 #12 0x000056437fc10c2d in open_table (thd=0x7fb1e0000b00, table_list=0x7fb1e006da30, ot_ctx=0x7fb2644e7c70) at /home/elenst/10.2/sql/sql_base.cc:1742 #13 0x000056437fc13bb2 in open_and_process_table (thd=0x7fb1e0000b00, lex=0x7fb1e00045e0, tables=0x7fb1e006da30, counter=0x7fb2644e7d04, flags=0, prelocking_strategy=0x7fb2644e7d88, has_prelocking_list=false, ot_ctx=0x7fb2644e7c70) at /home/elenst/10.2/sql/sql_base.cc:3409 #14 0x000056437fc14d55 in open_tables (thd=0x7fb1e0000b00, options=..., start=0x7fb2644e7ce8, counter=0x7fb2644e7d04, flags=0, prelocking_strategy=0x7fb2644e7d88) at /home/elenst/10.2/sql/sql_base.cc:3926 #15 0x000056437fc16506 in open_and_lock_tables (thd=0x7fb1e0000b00, options=..., tables=0x7fb1e00113e8, derived=true, flags=0, prelocking_strategy=0x7fb2644e7d88) at /home/elenst/10.2/sql/sql_base.cc:4682 #16 0x000056437fc099f7 in open_and_lock_tables (thd=0x7fb1e0000b00, tables=0x7fb1e00113e8, derived=true, flags=0) at /home/elenst/10.2/sql/sql_base.h:494 #17 0x00005643800881c1 in mysql_delete (thd=0x7fb1e0000b00, table_list=0x7fb1e00113e8, conds=0x7fb1e0011bf0, order_list=0x7fb1e0005040, limit=1, options=549755813888, result=0x0) at /home/elenst/10.2/sql/sql_delete.cc:252 #18 0x000056437fc8605d in mysql_execute_command (thd=0x7fb1e0000b00) at /home/elenst/10.2/sql/sql_parse.cc:4613 #19 0x000056437fc906fc in mysql_parse (thd=0x7fb1e0000b00, rawbuf=0x7fb1e00111c8 "DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_float_not_null_key` = 4 LIMIT 1 /* QNO 417 CON_ID 18 */", length=112, parser_state=0x7fb2644e9250, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:7902 #20 0x000056437fc7e386 in dispatch_command (command=COM_QUERY, thd=0x7fb1e0000b00, packet=0x7fb1e0008951 " DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_float_not_null_key` = 4 LIMIT 1 /* QNO 417 CON_ID 18 */ ", packet_length=114, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:1806 #21 0x000056437fc7cd22 in do_command (thd=0x7fb1e0000b00) at /home/elenst/10.2/sql/sql_parse.cc:1359 #22 0x000056437fdca17d in do_handle_one_connection (connect=0x564383848fa0) at /home/elenst/10.2/sql/sql_connect.cc:1335 #23 0x000056437fdc9efd in handle_one_connection (arg=0x564383848fa0) at /home/elenst/10.2/sql/sql_connect.cc:1241 #24 0x00007fb267a626da in start_thread (arg=0x7fb2644ea700) at pthread_create.c:456 #25 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 18 (Thread 0x7fb23a7fc700 (LWP 61239)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643801c0988 in os_event::wait (this=0x564382e6de10) at /home/elenst/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005643801c03b4 in os_event::wait_low (this=0x564382e6de10, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005643801c0731 in os_event_wait_low (event=0x564382e6de10, reset_sig_count=0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:535 #4 0x0000564380373be3 in buf_resize_thread () at /home/elenst/10.2/storage/innobase/buf/buf0buf.cc:3083 #5 0x00007fb267a626da in start_thread (arg=0x7fb23a7fc700) at pthread_create.c:456 #6 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 17 (Thread 0x7fb2646a6700 (LWP 61242)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643806615bc in safe_cond_wait (cond=0x56438121fe48 , mp=0x56438121fd98 , file=0x5643807f95c0 "/home/elenst/10.2/include/mysql/psi/mysql_thread.h", line=1149) at /home/elenst/10.2/mysys/thr_mutex.c:491 #2 0x000056437ffe76fe in inline_mysql_cond_wait (that=0x56438121fe48 , mutex=0x56438121fd98 , src_file=0x5643807f9b6c "/home/elenst/10.2/sql/log.cc", src_line=9857) at /home/elenst/10.2/include/mysql/psi/mysql_thread.h:1149 #3 0x0000564380001373 in binlog_background_thread (arg=0x0) at /home/elenst/10.2/sql/log.cc:9857 #4 0x00007fb267a626da in start_thread (arg=0x7fb2646a6700) at pthread_create.c:456 #5 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 16 (Thread 0x7fb26457e700 (LWP 61248)): #0 MutexDebug >::is_owned (this=0x56438126e3b8 ) at /home/elenst/10.2/storage/innobase/include/sync0policy.h:201 #1 0x00005643801be9c8 in MutexDebug >::release (this=0x56438126e3b8 , mutex=0x56438126e380 ) at /home/elenst/10.2/storage/innobase/include/sync0policy.ic:94 #2 0x00005643801bde89 in GenericPolicy >::release (this=0x56438126e3b8 , mutex=...) at /home/elenst/10.2/storage/innobase/include/sync0policy.h:369 #3 0x00005643801bd5fe in PolicyMutex >::exit (this=0x56438126e380 ) at /home/elenst/10.2/storage/innobase/include/ib0mutex.h:607 #4 0x00005643802c466f in rw_lock_debug_mutex_exit () at /home/elenst/10.2/storage/innobase/sync/sync0debug.cc:1275 #5 0x00005643802bde32 in rw_lock_own (lock=0x7fb251166398, lock_type=5) at /home/elenst/10.2/storage/innobase/sync/sync0rw.cc:1039 #6 0x000056438016f140 in buf_block_get_lock_hash_val (block=0x7fb2511662c0) at /home/elenst/10.2/storage/innobase/include/buf0buf.ic:800 #7 0x0000564380172077 in lock_rec_get_first_on_page (lock_hash=0x56438340b3d0, block=0x7fb2511662c0) at /home/elenst/10.2/storage/innobase/include/lock0priv.ic:160 #8 0x000056438017221b in lock_rec_get_first (hash=0x56438340b3d0, block=0x7fb2511662c0, heap_no=3) at /home/elenst/10.2/storage/innobase/include/lock0priv.ic:223 #9 0x00005643801836f4 in lock_rec_insert_check_and_lock (flags=0, rec=0x7fb251fec2b1 "", block=0x7fb2511662c0, index=0x7fb1f814bcb8, thr=0x7fb1f89ee0d0, mtr=0x7fb26457b1f0, inherit=0x7fb26457a248) at /home/elenst/10.2/storage/innobase/lock/lock0lock.cc:6583 #10 0x0000564380343360 in btr_cur_ins_lock_and_undo (flags=0, cursor=0x7fb26457a6e0, entry=0x7fb1f8868378, thr=0x7fb1f89ee0d0, mtr=0x7fb26457b1f0, inherit=0x7fb26457a248) at /home/elenst/10.2/storage/innobase/btr/btr0cur.cc:2800 #11 0x0000564380343d67 in btr_cur_optimistic_insert (flags=0, cursor=0x7fb26457a6e0, offsets=0x7fb26457a688, heap=0x7fb26457a650, entry=0x7fb1f8868378, rec=0x7fb26457a690, big_rec=0x7fb26457a698, n_ext=0, thr=0x7fb1f89ee0d0, mtr=0x7fb26457b1f0) at /home/elenst/10.2/storage/innobase/btr/btr0cur.cc:3030 #12 0x00005643802219a8 in row_ins_sec_index_entry_low (flags=0, mode=2, index=0x7fb1f814bcb8, offsets_heap=0x7fb1f89dd9f0, heap=0x7fb1f885c100, entry=0x7fb1f8868378, trx_id=0, thr=0x7fb1f89ee0d0, dup_chk_only=false) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3063 #13 0x00005643802220d3 in row_ins_sec_index_entry (index=0x7fb1f814bcb8, entry=0x7fb1f8868378, thr=0x7fb1f89ee0d0, dup_chk_only=false) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3244 #14 0x0000564380222244 in row_ins_index_entry (index=0x7fb1f814bcb8, entry=0x7fb1f8868378, thr=0x7fb1f89ee0d0) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3292 #15 0x0000564380222732 in row_ins_index_entry_step (node=0x7fb1d4039a48, thr=0x7fb1f89ee0d0) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3440 #16 0x0000564380222af0 in row_ins (node=0x7fb1d4039a48, thr=0x7fb1f89ee0d0) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3582 #17 0x000056438022311e in row_ins_step (thr=0x7fb1f89ee0d0) at /home/elenst/10.2/storage/innobase/row/row0ins.cc:3818 #18 0x000056438023f782 in row_insert_for_mysql (mysql_rec=0x7fb1d4019f98 "\033\353\352f\273z\366 ", prebuilt=0x7fb1d4036ff8) at /home/elenst/10.2/storage/innobase/row/row0mysql.cc:1407 #19 0x00005643800ff065 in ha_innobase::write_row (this=0x7fb1d401d8d8, record=0x7fb1d4019f98 "\033\353\352f\273z\366 ") at /home/elenst/10.2/storage/innobase/handler/ha_innodb.cc:8442 #20 0x000056437ff00408 in handler::ha_write_row (this=0x7fb1d401d8d8, buf=0x7fb1d4019f98 "\033\353\352f\273z\366 ") at /home/elenst/10.2/sql/handler.cc:6003 #21 0x000056437fc6061b in write_record (thd=0x7fb1f8000b00, table=0x7fb1d4019390, info=0x7fb1f82895f0) at /home/elenst/10.2/sql/sql_insert.cc:1929 #22 0x000056437fc656c3 in select_insert::send_data (this=0x7fb1f82895b0, values=...) at /home/elenst/10.2/sql/sql_insert.cc:3757 #23 0x000056437fcf4c72 in end_send (join=0x7fb1f8289658, join_tab=0x7fb1f89e6378, end_of_records=false) at /home/elenst/10.2/sql/sql_select.cc:19859 #24 0x000056437fcf2738 in evaluate_join_record (join=0x7fb1f8289658, join_tab=0x7fb1f89e5fc8, error=0) at /home/elenst/10.2/sql/sql_select.cc:18911 #25 0x000056437fcf21d7 in sub_select (join=0x7fb1f8289658, join_tab=0x7fb1f89e5fc8, end_of_records=false) at /home/elenst/10.2/sql/sql_select.cc:18730 #26 0x000056437fcf15b1 in do_select (join=0x7fb1f8289658, procedure=0x0) at /home/elenst/10.2/sql/sql_select.cc:18235 #27 0x000056437fccc0d1 in JOIN::exec_inner (this=0x7fb1f8289658) at /home/elenst/10.2/sql/sql_select.cc:3566 #28 0x000056437fccb580 in JOIN::exec (this=0x7fb1f8289658) at /home/elenst/10.2/sql/sql_select.cc:3361 #29 0x000056437fccc742 in mysql_select (thd=0x7fb1f8000b00, tables=0x7fb1f8013cc8, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=553245739776, result=0x7fb1f82895b0, unit=0x7fb1f80046a8, select_lex=0x7fb1f8004de0) at /home/elenst/10.2/sql/sql_select.cc:3761 #30 0x000056437fcc0e17 in handle_select (thd=0x7fb1f8000b00, lex=0x7fb1f80045e0, result=0x7fb1f82895b0, setup_tables_done_option=1073741824) at /home/elenst/10.2/sql/sql_select.cc:364 #31 0x000056437fc85b90 in mysql_execute_command (thd=0x7fb1f8000b00) at /home/elenst/10.2/sql/sql_parse.cc:4525 #32 0x000056437fc906fc in mysql_parse (thd=0x7fb1f8000b00, rawbuf=0x7fb1f8013388 "INSERT INTO `view_table1_innodb` SELECT * FROM `table0_innodb` /* QNO 4515 CON_ID 16 */", length=87, parser_state=0x7fb26457d250, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:7902 #33 0x000056437fc7e386 in dispatch_command (command=COM_QUERY, thd=0x7fb1f8000b00, packet=0x7fb1f8019c91 "INSERT INTO `view_table1_innodb` SELECT * FROM `table0_innodb` /* QNO 4515 CON_ID 16 */ ", packet_length=88, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:1806 #34 0x000056437fc7cd22 in do_command (thd=0x7fb1f8000b00) at /home/elenst/10.2/sql/sql_parse.cc:1359 #35 0x000056437fdca17d in do_handle_one_connection (connect=0x564383796f70) at /home/elenst/10.2/sql/sql_connect.cc:1335 #36 0x000056437fdc9efd in handle_one_connection (arg=0x564383796f70) at /home/elenst/10.2/sql/sql_connect.cc:1241 #37 0x00007fb267a626da in start_thread (arg=0x7fb26457e700) at pthread_create.c:456 #38 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 15 (Thread 0x7fb23bfff700 (LWP 61236)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005643801c0988 in os_event::wait (this=0x564382e6db90) at /home/elenst/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005643801c03b4 in os_event::wait_low (this=0x564382e6db90, reset_sig_count=290) at /home/elenst/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005643801c0731 in os_event_wait_low (event=0x564382e6db90, reset_sig_count=0) at /home/elenst/10.2/storage/innobase/os/os0event.cc:535 #4 0x00005643802a99ca in srv_resume_thread (slot=0x56438102f9b0 , sig_count=0, wait=true, timeout_usec=0) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x00005643802ad3b8 in srv_worker_thread (arg=0x0) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:2600 #6 0x00007fb267a626da in start_thread (arg=0x7fb23bfff700) at pthread_create.c:456 #7 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 14 (Thread 0x7fb2437fe700 (LWP 61230)): #0 0x00007fb267a6bd2d in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005643801c0ca8 in os_thread_sleep (tm=1000000) at /home/elenst/10.2/storage/innobase/os/os0thread.cc:230 #2 0x00005643802acde5 in srv_master_sleep () at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:2411 #3 0x00005643802acf23 in srv_master_thread (arg=0x0) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:2456 #4 0x00007fb267a626da in start_thread (arg=0x7fb2437fe700) at pthread_create.c:456 #5 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 13 (Thread 0x7fb24e8f6700 (LWP 61216)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24e8f5c20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24e8f5c20, m1=0x7fb24e8f5cc8, m2=0x7fb24e8f5cd0, request=0x7fb24e8f5d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=1, m1=0x7fb24e8f5cc8, m2=0x7fb24e8f5cd0, request=0x7fb24e8f5d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=1, m1=0x7fb24e8f5cc8, m2=0x7fb24e8f5cd0, request=0x7fb24e8f5d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=1) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263c68 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24e8f6700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 12 (Thread 0x7fb241ffb700 (LWP 61233)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643801c021e in os_event::timed_wait (this=0x564382e6da10, abstime=0x7fb241ffae00) at /home/elenst/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005643801c0552 in os_event::wait_time_low (this=0x564382e6da10, time_in_usec=10000, reset_sig_count=180) at /home/elenst/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005643801c070c in os_event_wait_time_low (event=0x564382e6da10, time_in_usec=10000, reset_sig_count=180) at /home/elenst/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005643802a99a3 in srv_resume_thread (slot=0x56438102f908 , sig_count=180, wait=true, timeout_usec=10000) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:930 #5 0x00005643802ad877 in srv_purge_coordinator_suspend (slot=0x56438102f908 , rseg_history_len=89) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:2753 #6 0x00005643802adc1c in srv_purge_coordinator_thread (arg=0x0) at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:2840 #7 0x00007fb267a626da in start_thread (arg=0x7fb241ffb700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 11 (Thread 0x7fb24c0f1700 (LWP 61221)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24c0f0c20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24c0f0c20, m1=0x7fb24c0f0cc8, m2=0x7fb24c0f0cd0, request=0x7fb24c0f0d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=6, m1=0x7fb24c0f0cc8, m2=0x7fb24c0f0cd0, request=0x7fb24c0f0d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=6, m1=0x7fb24c0f0cc8, m2=0x7fb24c0f0cd0, request=0x7fb24c0f0d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=6) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263c90 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24c0f1700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 10 (Thread 0x7fb24e0f5700 (LWP 61217)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24e0f4c20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24e0f4c20, m1=0x7fb24e0f4cc8, m2=0x7fb24e0f4cd0, request=0x7fb24e0f4d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=2, m1=0x7fb24e0f4cc8, m2=0x7fb24e0f4cd0, request=0x7fb24e0f4d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=2, m1=0x7fb24e0f4cc8, m2=0x7fb24e0f4cd0, request=0x7fb24e0f4d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=2) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263c70 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24e0f5700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 9 (Thread 0x7fb24c8f2700 (LWP 61220)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24c8f1c20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24c8f1c20, m1=0x7fb24c8f1cc8, m2=0x7fb24c8f1cd0, request=0x7fb24c8f1d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=5, m1=0x7fb24c8f1cc8, m2=0x7fb24c8f1cd0, request=0x7fb24c8f1d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=5, m1=0x7fb24c8f1cc8, m2=0x7fb24c8f1cd0, request=0x7fb24c8f1d00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=5) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263c88 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24c8f2700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 8 (Thread 0x7fb2496e7700 (LWP 61229)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643801c021e in os_event::timed_wait (this=0x564382e6dc90, abstime=0x7fb2496e6e60) at /home/elenst/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005643801c0552 in os_event::wait_time_low (this=0x564382e6dc90, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005643801c070c in os_event_wait_time_low (event=0x564382e6dc90, time_in_usec=5000000, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005643802ab7f1 in srv_monitor_thread () at /home/elenst/10.2/storage/innobase/srv/srv0srv.cc:1753 #5 0x00007fb267a626da in start_thread (arg=0x7fb2496e7700) at pthread_create.c:456 #6 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 7 (Thread 0x7fb24b8f0700 (LWP 61222)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24b8efc20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24b8efc20, m1=0x7fb24b8efcc8, m2=0x7fb24b8efcd0, request=0x7fb24b8efd00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=7, m1=0x7fb24b8efcc8, m2=0x7fb24b8efcd0, request=0x7fb24b8efd00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=7, m1=0x7fb24b8efcc8, m2=0x7fb24b8efcd0, request=0x7fb24b8efd00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=7) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263c98 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24b8f0700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 6 (Thread 0x7fb24b0ef700 (LWP 61223)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24b0eec20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24b0eec20, m1=0x7fb24b0eecc8, m2=0x7fb24b0eecd0, request=0x7fb24b0eed00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=8, m1=0x7fb24b0eecc8, m2=0x7fb24b0eecd0, request=0x7fb24b0eed00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=8, m1=0x7fb24b0eecc8, m2=0x7fb24b0eecd0, request=0x7fb24b0eed00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=8) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263ca0 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24b0ef700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 5 (Thread 0x7fb24a8ee700 (LWP 61224)): #0 0x00007fb26897e64a in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005643801b40a9 in LinuxAIOHandler::collect (this=0x7fb24a8edc20) at /home/elenst/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005643801b45df in LinuxAIOHandler::poll (this=0x7fb24a8edc20, m1=0x7fb24a8edcc8, m2=0x7fb24a8edcd0, request=0x7fb24a8edd00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005643801b4759 in os_aio_linux_handler (global_segment=9, m1=0x7fb24a8edcc8, m2=0x7fb24a8edcd0, request=0x7fb24a8edd00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005643801b9457 in os_aio_handler (segment=9, m1=0x7fb24a8edcc8, m2=0x7fb24a8edcd0, request=0x7fb24a8edd00) at /home/elenst/10.2/storage/innobase/os/os0file.cc:5720 #5 0x0000564380409acb in fil_aio_wait (segment=9) at /home/elenst/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005643802b0381 in io_handler_thread (arg=0x564381263ca8 ) at /home/elenst/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007fb267a626da in start_thread (arg=0x7fb24a8ee700) at pthread_create.c:456 #8 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 4 (Thread 0x7fb24a0ed700 (LWP 61225)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643801c021e in os_event::timed_wait (this=0x564382e6dd90, abstime=0x7fb24a0ecc10) at /home/elenst/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005643801c0552 in os_event::wait_time_low (this=0x564382e6dd90, time_in_usec=968000, reset_sig_count=2) at /home/elenst/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005643801c070c in os_event_wait_time_low (event=0x564382e6dd90, time_in_usec=968000, reset_sig_count=2) at /home/elenst/10.2/storage/innobase/os/os0event.cc:518 #4 0x0000564380394057 in pc_sleep_if_needed (next_loop_time=1520340917581, sig_count=2, cur_time=1520340916613) at /home/elenst/10.2/storage/innobase/buf/buf0flu.cc:2718 #5 0x0000564380394f70 in buf_flush_page_cleaner_coordinator () at /home/elenst/10.2/storage/innobase/buf/buf0flu.cc:3203 #6 0x00007fb267a626da in start_thread (arg=0x7fb24a0ed700) at pthread_create.c:456 #7 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 3 (Thread 0x7fb248ee6700 (LWP 61227)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643801c021e in os_event::timed_wait (this=0x56438340b350, abstime=0x7fb248ee5e80) at /home/elenst/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005643801c0552 in os_event::wait_time_low (this=0x56438340b350, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005643801c070c in os_event_wait_time_low (event=0x56438340b350, time_in_usec=1000000, reset_sig_count=1) at /home/elenst/10.2/storage/innobase/os/os0event.cc:518 #4 0x000056438018eb6d in lock_wait_timeout_thread () at /home/elenst/10.2/storage/innobase/lock/lock0wait.cc:547 #5 0x00007fb267a626da in start_thread (arg=0x7fb248ee6700) at pthread_create.c:456 #6 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 2 (Thread 0x7fb266deb700 (LWP 61214)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005643806618c6 in safe_cond_timedwait (cond=0x564381a86960 , mp=0x564381a868a0 , abstime=0x7fb266deaf00, file=0x5643809c23f0 "/home/elenst/10.2/include/mysql/psi/mysql_thread.h", line=1186) at /home/elenst/10.2/mysys/thr_mutex.c:545 #2 0x000056438066288a in inline_mysql_cond_timedwait (that=0x564381a86960 , mutex=0x564381a868a0 , abstime=0x7fb266deaf00, src_file=0x5643809c2428 "/home/elenst/10.2/mysys/thr_timer.c", src_line=292) at /home/elenst/10.2/include/mysql/psi/mysql_thread.h:1186 #3 0x0000564380663348 in timer_handler (arg=0x0) at /home/elenst/10.2/mysys/thr_timer.c:292 #4 0x00007fb267a626da in start_thread (arg=0x7fb266deb700) at pthread_create.c:456 #5 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105 Thread 1 (Thread 0x7fb264534700 (LWP 61256)): #0 __pthread_kill (threadid=, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62 #1 0x000056438065c03e in my_write_core (sig=11) at /home/elenst/10.2/mysys/stacktrace.c:477 #2 0x000056437fef1131 in handle_fatal_signal (sig=11) at /home/elenst/10.2/sql/signal_handler.cc:305 #3 #4 0x000056437fec3485 in Field::make_field (this=0x7fb1f80bc9f0, field=0x7fb2645315f0) at /home/elenst/10.2/sql/field.cc:1954 #5 0x000056437ff16c6e in Item_field::make_field (this=0x7fb1dc02da10, thd=0x7fb1dc000b00, tmp_field=0x7fb2645315f0) at /home/elenst/10.2/sql/item.cc:6296 #6 0x000056437ff1c00d in Item_ref::make_field (this=0x7fb1dc039f90, thd=0x7fb1dc000b00, field=0x7fb2645315f0) at /home/elenst/10.2/sql/item.cc:8086 #7 0x000056437fbba61f in Protocol::send_result_set_metadata (this=0x7fb1dc0010c0, list=0x7fb1dc004f08, flags=5) at /home/elenst/10.2/sql/protocol.cc:822 #8 0x000056437fc3c56c in select_send::send_result_set_metadata (this=0x7fb1dc011f90, list=..., flags=5) at /home/elenst/10.2/sql/sql_class.cc:2745 #9 0x00005643800893a2 in mysql_delete (thd=0x7fb1dc000b00, table_list=0x7fb1dc011490, conds=0x7fb1dc011c90, order_list=0x7fb1dc005040, limit=1, options=549755813888, result=0x7fb1dc011f90) at /home/elenst/10.2/sql/sql_delete.cc:550 #10 0x000056437fc8605d in mysql_execute_command (thd=0x7fb1dc000b00) at /home/elenst/10.2/sql/sql_parse.cc:4613 #11 0x000056437fc906fc in mysql_parse (thd=0x7fb1dc000b00, rawbuf=0x7fb1dc0111c8 "/* GenTest::Transform::ExecuteAsDeleteReturning */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_latin1_key` < 3 LIMIT 1 /* QNO 172 CON_ID 17 */ RETURNING * /* QNO 173 CON_ID 17 */", length=198, parser_state=0x7fb264533250, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:7902 #12 0x000056437fc7e386 in dispatch_command (command=COM_QUERY, thd=0x7fb1dc000b00, packet=0x7fb1dc008951 "", packet_length=199, is_com_multi=false, is_next_command=false) at /home/elenst/10.2/sql/sql_parse.cc:1806 #13 0x000056437fc7cd22 in do_command (thd=0x7fb1dc000b00) at /home/elenst/10.2/sql/sql_parse.cc:1359 #14 0x000056437fdca17d in do_handle_one_connection (connect=0x5643837bab50) at /home/elenst/10.2/sql/sql_connect.cc:1335 #15 0x000056437fdc9efd in handle_one_connection (arg=0x5643837bab50) at /home/elenst/10.2/sql/sql_connect.cc:1241 #16 0x00007fb267a626da in start_thread (arg=0x7fb264534700) at pthread_create.c:456 #17 0x00007fb266ef4d7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105