[New LWP 11145] [New LWP 11103] [New LWP 11101] [New LWP 11149] [New LWP 11120] [New LWP 11128] [New LWP 11115] [New LWP 11135] [New LWP 11150] [New LWP 11104] [New LWP 11109] [New LWP 11143] [New LWP 11117] [New LWP 11116] [New LWP 11110] [New LWP 11111] [New LWP 11141] [New LWP 11124] [New LWP 11122] [New LWP 11118] [New LWP 11126] [New LWP 11112] [New LWP 11107] [New LWP 11127] [New LWP 11147] [New LWP 11106] [New LWP 11102] [New LWP 11121] [New LWP 11119] [New LWP 11099] [New LWP 11113] [New LWP 11123] [New LWP 11105] [New LWP 11125] [New LWP 11108] [New LWP 11129] [New LWP 11130] [New LWP 11134] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `/data/bld/10.2/bin/mysqld --no-defaults --basedir=/data/bld/10.2 --lc-messages-'. Program terminated with signal SIGABRT, Aborted. #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 Thread 38 (Thread 0x7f2454fc6700 (LWP 11134)): #0 0x00007f247055e4ed in poll () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x00005619eea56f3d in vio_io_wait (vio=0x5619f10ed9c0, event=VIO_IO_EVENT_READ, timeout=28800000) at /data/src/10.2/vio/viosocket.c:945 #2 0x00005619eea55752 in vio_socket_io_wait (vio=0x5619f10ed9c0, event=VIO_IO_EVENT_READ) at /data/src/10.2/vio/viosocket.c:108 #3 0x00005619eea5590a in vio_read (vio=0x5619f10ed9c0, buf=0x7f23fc008850 "\a", size=4) at /data/src/10.2/vio/viosocket.c:184 #4 0x00005619edf4b568 in my_real_read (net=0x7f23fc000df0, complen=0x7f2454fc5940, header=1 '\001') at /data/src/10.2/sql/net_serv.cc:892 #5 0x00005619edf4bd6d in my_net_read_packet_reallen (net=0x7f23fc000df0, read_from_server=1 '\001', reallen=0x7f2454fc59a8) at /data/src/10.2/sql/net_serv.cc:1162 #6 0x00005619edf4bd21 in my_net_read_packet (net=0x7f23fc000df0, read_from_server=1 '\001') at /data/src/10.2/sql/net_serv.cc:1146 #7 0x00005619ee01592d in do_command (thd=0x7f23fc000b00) at /data/src/10.2/sql/sql_parse.cc:1242 #8 0x00005619ee164646 in do_handle_one_connection (connect=0x5619f1114ce0) at /data/src/10.2/sql/sql_connect.cc:1335 #9 0x00005619ee1643d3 in handle_one_connection (arg=0x5619f1114ce0) at /data/src/10.2/sql/sql_connect.cc:1241 #10 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f119d860) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #11 0x00007f2472181494 in start_thread (arg=0x7f2454fc6700) at pthread_create.c:333 #12 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 37 (Thread 0x7f2455010700 (LWP 11130)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005619ee9f67c0 in safe_cond_wait (cond=0x5619ef5a5fa0 , mp=0x5619ef5a9280 , file=0x5619eea94180 "/data/src/10.2/include/mysql/psi/mysql_thread.h", line=1149) at /data/src/10.2/mysys/thr_mutex.c:491 #2 0x00005619edf63736 in inline_mysql_cond_wait (that=0x5619ef5a5fa0 , mutex=0x5619ef5a9280 , src_file=0x5619eea9493d "/data/src/10.2/sql/slave.cc", src_line=334) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1149 #3 0x00005619edf64318 in handle_slave_background (arg=0x0) at /data/src/10.2/sql/slave.cc:334 #4 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f10ed9c0) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #5 0x00007f2472181494 in start_thread (arg=0x7f2455010700) at pthread_create.c:333 #6 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 36 (Thread 0x7f245505a700 (LWP 11129)): #0 do_sigwait (set=, set@entry=0x7f2455059e30, sig=sig@entry=0x7f2455059e00) at ../sysdeps/unix/sysv/linux/sigwait.c:64 #1 0x00007f247218aced in __sigwait (set=0x7f2455059e30, sig=0x7f2455059e00) at ../sysdeps/unix/sysv/linux/sigwait.c:96 #2 0x00005619edf3aa53 in signal_hand (arg=0x0) at /data/src/10.2/sql/mysqld.cc:3505 #3 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f10f6750) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #4 0x00007f2472181494 in start_thread (arg=0x7f245505a700) at pthread_create.c:333 #5 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 35 (Thread 0x7f244399a700 (LWP 11108)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f2443999c40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f2443999c40, m1=0x7f2443999ce8, m2=0x7f2443999cf0, request=0x7f2443999d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=5, m1=0x7f2443999ce8, m2=0x7f2443999cf0, request=0x7f2443999d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=5, m1=0x7f2443999ce8, m2=0x7f2443999cf0, request=0x7f2443999d20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=5) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe26fe8 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f244399a700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 34 (Thread 0x7f2432ffd700 (LWP 11125)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005619ee662414 in os_event::wait (this=0x5619f07afc40) at /data/src/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005619ee661e23 in os_event::wait_low (this=0x5619f07afc40, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005619ee6621c9 in os_event_wait_low (event=0x5619f07afc40, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:535 #4 0x00005619ee8277fe in buf_dump_thread () at /data/src/10.2/storage/innobase/buf/buf0dump.cc:777 #5 0x00007f2472181494 in start_thread (arg=0x7f2432ffd700) at pthread_create.c:333 #6 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 33 (Thread 0x7f244519d700 (LWP 11105)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f244519cc40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f244519cc40, m1=0x7f244519cce8, m2=0x7f244519ccf0, request=0x7f244519cd20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=2, m1=0x7f244519cce8, m2=0x7f244519ccf0, request=0x7f244519cd20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=2, m1=0x7f244519cce8, m2=0x7f244519ccf0, request=0x7f244519cd20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=2) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe26fd0 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f244519d700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 32 (Thread 0x7f2433fff700 (LWP 11123)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005619ee662414 in os_event::wait (this=0x5619f07af9c0) at /data/src/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005619ee661e23 in os_event::wait_low (this=0x5619f07af9c0, reset_sig_count=7181) at /data/src/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005619ee6621c9 in os_event_wait_low (event=0x5619f07af9c0, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:535 #4 0x00005619ee748d29 in srv_resume_thread (slot=0x5619ef3e8880 , sig_count=0, wait=true, timeout_usec=0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x00005619ee74c935 in srv_worker_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2600 #6 0x00007f2472181494 in start_thread (arg=0x7f2433fff700) at pthread_create.c:333 #7 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 31 (Thread 0x7f2441195700 (LWP 11113)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005619ee661cb9 in os_event::timed_wait (this=0x5619f07afcc0, abstime=0x7f2441194c30) at /data/src/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005619ee661fc3 in os_event::wait_time_low (this=0x5619f07afcc0, time_in_usec=984000, reset_sig_count=2) at /data/src/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005619ee6621a4 in os_event_wait_time_low (event=0x5619f07afcc0, time_in_usec=984000, reset_sig_count=2) at /data/src/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005619ee830e6f in pc_sleep_if_needed (next_loop_time=1520536951090, sig_count=2, cur_time=1520536950106) at /data/src/10.2/storage/innobase/buf/buf0flu.cc:2718 #5 0x00005619ee831d4e in buf_flush_page_cleaner_coordinator () at /data/src/10.2/storage/innobase/buf/buf0flu.cc:3203 #6 0x00007f2472181494 in start_thread (arg=0x7f2441195700) at pthread_create.c:333 #7 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 30 (Thread 0x7f247259ab80 (LWP 11099)): #0 0x00007f247055e4ed in poll () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x00005619edf40760 in handle_connections_sockets () at /data/src/10.2/sql/mysqld.cc:6586 #2 0x00005619edf3fa40 in mysqld_main (argc=19, argv=0x5619f05647e8) at /data/src/10.2/sql/mysqld.cc:6052 #3 0x00005619edf341d0 in main (argc=19, argv=0x7ffdd08ed528) at /data/src/10.2/sql/main.cc:25 Thread 29 (Thread 0x7f243a7fc700 (LWP 11119)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005619ee661cb9 in os_event::timed_wait (this=0x5619f13fd000, abstime=0x7f243a7fbea0) at /data/src/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005619ee661fc3 in os_event::wait_time_low (this=0x5619f13fd000, time_in_usec=10000000, reset_sig_count=159) at /data/src/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005619ee6621a4 in os_event_wait_time_low (event=0x5619f13fd000, time_in_usec=10000000, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005619ee88bc76 in dict_stats_thread () at /data/src/10.2/storage/innobase/dict/dict0stats_bg.cc:451 #5 0x00007f2472181494 in start_thread (arg=0x7f243a7fc700) at pthread_create.c:333 #6 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 28 (Thread 0x7f24397fa700 (LWP 11121)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005619ee662414 in os_event::wait (this=0x5619f07af940) at /data/src/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005619ee661e23 in os_event::wait_low (this=0x5619f07af940, reset_sig_count=4541) at /data/src/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005619ee6621c9 in os_event_wait_low (event=0x5619f07af940, reset_sig_count=4541) at /data/src/10.2/storage/innobase/os/os0event.cc:535 #4 0x00005619ee748d29 in srv_resume_thread (slot=0x5619ef3e8848 , sig_count=4541, wait=true, timeout_usec=0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x00005619ee74cdf0 in srv_purge_coordinator_suspend (slot=0x5619ef3e8848 , rseg_history_len=75) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2753 #6 0x00005619ee74d18b in srv_purge_coordinator_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2840 #7 0x00007f2472181494 in start_thread (arg=0x7f24397fa700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 27 (Thread 0x7f2455c5c700 (LWP 11102)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005619ee9f6aca in safe_cond_timedwait (cond=0x5619efddbb00 , mp=0x5619efddba40 , abstime=0x7f2455c5be00, file=0x5619eebcb5f0 "/data/src/10.2/include/mysql/psi/mysql_thread.h", line=1186) at /data/src/10.2/mysys/thr_mutex.c:545 #2 0x00005619ee4d15bf in inline_mysql_cond_timedwait (that=0x5619efddbb00 , mutex=0x5619efddba40 , abstime=0x7f2455c5be00, src_file=0x5619eebcb620 "/data/src/10.2/storage/maria/ma_servicethread.c", src_line=116) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1186 #3 0x00005619ee4d1a71 in my_service_thread_sleep (control=0x5619ef3d6880 , sleep_time=29000000000) at /data/src/10.2/storage/maria/ma_servicethread.c:115 #4 0x00005619ee4c6731 in ma_checkpoint_background (arg=0x1e) at /data/src/10.2/storage/maria/ma_checkpoint.c:709 #5 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f0691500) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #6 0x00007f2472181494 in start_thread (arg=0x7f2455c5c700) at pthread_create.c:333 #7 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 26 (Thread 0x7f244499c700 (LWP 11106)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f244499bc40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f244499bc40, m1=0x7f244499bce8, m2=0x7f244499bcf0, request=0x7f244499bd20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=3, m1=0x7f244499bce8, m2=0x7f244499bcf0, request=0x7f244499bd20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=3, m1=0x7f244499bce8, m2=0x7f244499bcf0, request=0x7f244499bd20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=3) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe26fd8 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f244499c700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 25 (Thread 0x7f245422f700 (LWP 11147)): #0 __lll_lock_wait () at ../sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135 #1 0x00007f2472183cc6 in __GI___pthread_mutex_lock (mutex=0x5619ef5d4428 ) at ../nptl/pthread_mutex_lock.c:135 #2 0x00005619ee9f5f95 in safe_mutex_lock (mp=0x5619ef5d4400 , my_flags=0, file=0x5619eeb06460 "/data/src/10.2/sql/table_cache.cc", line=900) at /data/src/10.2/mysys/thr_mutex.c:292 #3 0x00005619ee206b27 in inline_mysql_mutex_lock (that=0x5619ef5d4400 , src_file=0x5619eeb06460 "/data/src/10.2/sql/table_cache.cc", src_line=900) at /data/src/10.2/include/mysql/psi/mysql_thread.h:681 #4 0x00005619ee208ec3 in tdc_acquire_share (thd=0x7f23e0000b00, tl=0x7f245422c2e0, flags=3, out_table=0x7f245422b998) at /data/src/10.2/sql/table_cache.cc:900 #5 0x00005619edfa8e07 in open_table (thd=0x7f23e0000b00, table_list=0x7f245422c2e0, ot_ctx=0x7f245422bdd0) at /data/src/10.2/sql/sql_base.cc:1742 #6 0x00005619edfabd69 in open_and_process_table (thd=0x7f23e0000b00, lex=0x7f23e00045e0, tables=0x7f245422c2e0, counter=0x7f245422be64, flags=2050, prelocking_strategy=0x7f245422bee0, has_prelocking_list=false, ot_ctx=0x7f245422bdd0) at /data/src/10.2/sql/sql_base.cc:3409 #7 0x00005619edfacea4 in open_tables (thd=0x7f23e0000b00, options=..., start=0x7f245422be48, counter=0x7f245422be64, flags=2050, prelocking_strategy=0x7f245422bee0) at /data/src/10.2/sql/sql_base.cc:3928 #8 0x00005619edfae698 in open_and_lock_tables (thd=0x7f23e0000b00, options=..., tables=0x7f245422c2e0, derived=false, flags=2050, prelocking_strategy=0x7f245422bee0) at /data/src/10.2/sql/sql_base.cc:4682 #9 0x00005619edfa1b93 in open_and_lock_tables (thd=0x7f23e0000b00, tables=0x7f245422c2e0, derived=false, flags=2050) at /data/src/10.2/sql/sql_base.h:494 #10 0x00005619edfb7e28 in open_system_tables_for_read (thd=0x7f23e0000b00, table_list=0x7f245422c2e0, backup=0x7f245422c100) at /data/src/10.2/sql/sql_base.cc:8485 #11 0x00005619ee0cb3ea in open_stat_tables (thd=0x7f23e0000b00, tables=0x7f245422c2e0, backup=0x7f245422c100, for_write=true) at /data/src/10.2/sql/sql_statistics.cc:271 #12 0x00005619ee0ce22c in delete_statistics_for_table (thd=0x7f23e0000b00, db=0x7f245422d580, tab=0x7f245422d590) at /data/src/10.2/sql/sql_statistics.cc:3297 #13 0x00005619ee0dc4de in mysql_rm_table (thd=0x7f23e0000b00, tables=0x7f23e0011230, if_exists=0 '\000', drop_temporary=0 '\000') at /data/src/10.2/sql/sql_table.cc:2035 #14 0x00005619ee01fa06 in mysql_execute_command (thd=0x7f23e0000b00) at /data/src/10.2/sql/sql_parse.cc:4742 #15 0x00005619ee0295d1 in mysql_parse (thd=0x7f23e0000b00, rawbuf=0x7f23e00110c8 "DROP TABLE transforms.insert_select_11146 /* QNO 2499 CON_ID 18 */", length=66, parser_state=0x7f245422e200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902 #16 0x00005619ee0174f1 in dispatch_command (command=COM_QUERY, thd=0x7f23e0000b00, packet=0x7f23e0008851 "DROP TABLE transforms.insert_select_11146 /* QNO 2499 CON_ID 18 */ ", packet_length=67, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806 #17 0x00005619ee015e54 in do_command (thd=0x7f23e0000b00) at /data/src/10.2/sql/sql_parse.cc:1360 #18 0x00005619ee164646 in do_handle_one_connection (connect=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1335 #19 0x00005619ee1643d3 in handle_one_connection (arg=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1241 #20 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f1185cd0) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #21 0x00007f2472181494 in start_thread (arg=0x7f245422f700) at pthread_create.c:333 #22 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 24 (Thread 0x7f2431ffb700 (LWP 11127)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005619ee662414 in os_event::wait (this=0x5619f07afd40) at /data/src/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005619ee661e23 in os_event::wait_low (this=0x5619f07afd40, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005619ee6621c9 in os_event_wait_low (event=0x5619f07afd40, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:535 #4 0x00005619ee810ce2 in buf_resize_thread () at /data/src/10.2/storage/innobase/buf/buf0buf.cc:3083 #5 0x00007f2472181494 in start_thread (arg=0x7f2431ffb700) at pthread_create.c:333 #6 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 23 (Thread 0x7f244419b700 (LWP 11107)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f244419ac40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f244419ac40, m1=0x7f244419ace8, m2=0x7f244419acf0, request=0x7f244419ad20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=4, m1=0x7f244419ace8, m2=0x7f244419acf0, request=0x7f244419ad20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=4, m1=0x7f244419ace8, m2=0x7f244419acf0, request=0x7f244419ad20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=4) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe26fe0 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f244419b700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 22 (Thread 0x7f2441996700 (LWP 11112)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f2441995c40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f2441995c40, m1=0x7f2441995ce8, m2=0x7f2441995cf0, request=0x7f2441995d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=9, m1=0x7f2441995ce8, m2=0x7f2441995cf0, request=0x7f2441995d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=9, m1=0x7f2441995ce8, m2=0x7f2441995cf0, request=0x7f2441995d20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=9) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe27008 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f2441996700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 21 (Thread 0x7f24327fc700 (LWP 11126)): #0 0x00007f247218a7dd in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005619ee66272f in os_thread_sleep (tm=1000000) at /data/src/10.2/storage/innobase/os/os0thread.cc:230 #2 0x00005619ee8039af in btr_defragment_thread () at /data/src/10.2/storage/innobase/btr/btr0defragment.cc:760 #3 0x00007f2472181494 in start_thread (arg=0x7f24327fc700) at pthread_create.c:333 #4 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 20 (Thread 0x7f243affd700 (LWP 11118)): #0 0x00007f247218a7dd in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x00005619ee66272f in os_thread_sleep (tm=1000000) at /data/src/10.2/storage/innobase/os/os0thread.cc:230 #2 0x00005619ee74c33e in srv_master_sleep () at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2411 #3 0x00005619ee74c470 in srv_master_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2456 #4 0x00007f2472181494 in start_thread (arg=0x7f243affd700) at pthread_create.c:333 #5 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 19 (Thread 0x7f2438ff9700 (LWP 11122)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005619ee662414 in os_event::wait (this=0x5619f07afa40) at /data/src/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005619ee661e23 in os_event::wait_low (this=0x5619f07afa40, reset_sig_count=7035) at /data/src/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005619ee6621c9 in os_event_wait_low (event=0x5619f07afa40, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:535 #4 0x00005619ee748d29 in srv_resume_thread (slot=0x5619ef3e88b8 , sig_count=0, wait=true, timeout_usec=0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x00005619ee74c935 in srv_worker_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2600 #6 0x00007f2472181494 in start_thread (arg=0x7f2438ff9700) at pthread_create.c:333 #7 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 18 (Thread 0x7f24337fe700 (LWP 11124)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005619ee662414 in os_event::wait (this=0x5619f07afac0) at /data/src/10.2/storage/innobase/os/os0event.cc:166 #2 0x00005619ee661e23 in os_event::wait_low (this=0x5619f07afac0, reset_sig_count=6824) at /data/src/10.2/storage/innobase/os/os0event.cc:336 #3 0x00005619ee6621c9 in os_event_wait_low (event=0x5619f07afac0, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:535 #4 0x00005619ee748d29 in srv_resume_thread (slot=0x5619ef3e88f0 , sig_count=0, wait=true, timeout_usec=0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:934 #5 0x00005619ee74c935 in srv_worker_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2600 #6 0x00007f2472181494 in start_thread (arg=0x7f24337fe700) at pthread_create.c:333 #7 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 17 (Thread 0x7f2454f32700 (LWP 11141)): #0 __lll_lock_wait () at ../sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135 #1 0x00007f2472183b95 in __GI___pthread_mutex_lock (mutex=0x5619efe43868 ) at ../nptl/pthread_mutex_lock.c:80 #2 0x00005619ee9f5f95 in safe_mutex_lock (mp=0x5619efe43840 , my_flags=0, file=0x5619eed562b0 "/data/src/10.2/storage/myisam/mi_close.c", line=35) at /data/src/10.2/mysys/thr_mutex.c:292 #3 0x00005619ee95010d in inline_mysql_mutex_lock (that=0x5619efe43840 , src_file=0x5619eed562b0 "/data/src/10.2/storage/myisam/mi_close.c", src_line=35) at /data/src/10.2/include/mysql/psi/mysql_thread.h:681 #4 0x00005619ee950324 in mi_close (info=0x7f24001911a0) at /data/src/10.2/storage/myisam/mi_close.c:35 #5 0x00005619ee939a1a in ha_myisam::close (this=0x7f2400216fe8) at /data/src/10.2/storage/myisam/ha_myisam.cc:907 #6 0x00005619ee292b73 in handler::ha_close (this=0x7f2400216fe8) at /data/src/10.2/sql/handler.cc:2566 #7 0x00005619ee11ecce in closefrm (table=0x7f2400431250) at /data/src/10.2/sql/table.cc:3419 #8 0x00005619ee206f02 in intern_close_table (table=0x7f2400431250) at /data/src/10.2/sql/table_cache.cc:222 #9 0x00005619ee2070a1 in tc_remove_table (table=0x7f2400431250) at /data/src/10.2/sql/table_cache.cc:260 #10 0x00005619ee207592 in tc_add_table (thd=0x7f23f0000b00, table=0x7f23f00fba30) at /data/src/10.2/sql/table_cache.cc:383 #11 0x00005619edfa93de in open_table (thd=0x7f23f0000b00, table_list=0x7f23f0011300, ot_ctx=0x7f2454f2f170) at /data/src/10.2/sql/sql_base.cc:1904 #12 0x00005619edfff809 in create_table_from_items (thd=0x7f23f0000b00, create_info=0x7f2454f30910, create_table=0x7f23f0011300, alter_info=0x7f2454f30860, items=0x7f23f0004f08, lock=0x7f2454f30288, hooks=0x7f2454f302c0) at /data/src/10.2/sql/sql_insert.cc:4145 #13 0x00005619edfffdf5 in select_create::prepare (this=0x7f23f0012520, values=..., u=0x7f23f00046a8) at /data/src/10.2/sql/sql_insert.cc:4300 #14 0x00005619ee05c32e in JOIN::prepare (this=0x7f23f0012618, tables_init=0x7f23f0011ad0, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, skip_order_by=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7f23f0004de0, unit_arg=0x7f23f00046a8) at /data/src/10.2/sql/sql_select.cc:1049 #15 0x00005619ee0656b5 in mysql_select (thd=0x7f23f0000b00, tables=0x7f23f0011ad0, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=552708868864, result=0x7f23f0012520, unit=0x7f23f00046a8, select_lex=0x7f23f0004de0) at /data/src/10.2/sql/sql_select.cc:3739 #16 0x00005619ee059db2 in handle_select (thd=0x7f23f0000b00, lex=0x7f23f00045e0, result=0x7f23f0012520, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:376 #17 0x00005619ee01cebb in mysql_execute_command (thd=0x7f23f0000b00) at /data/src/10.2/sql/sql_parse.cc:3936 #18 0x00005619ee0295d1 in mysql_parse (thd=0x7f23f0000b00, rawbuf=0x7f23f00110c8 "CREATE TABLE transforms.insert_select_11140 SELECT * FROM INFORMATION_SCHEMA.`INNODB_FT_BEING_DELETED` AS table1 LIMIT 35 /* QNO 2561 CON_ID 15 */ /* QNO 2569 CON_ID 15 */", length=173, parser_state=0x7f2454f31200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902 #19 0x00005619ee0174f1 in dispatch_command (command=COM_QUERY, thd=0x7f23f0000b00, packet=0x7f23f0008851 "CREATE TABLE transforms.insert_select_11140 SELECT * FROM INFORMATION_SCHEMA.`INNODB_FT_BEING_DELETED` AS table1 LIMIT 35 /* QNO 2561 CON_ID 15 */ /* QNO 2569 CON_ID 15 */ ", packet_length=174, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806 #20 0x00005619ee015e54 in do_command (thd=0x7f23f0000b00) at /data/src/10.2/sql/sql_parse.cc:1360 #21 0x00005619ee164646 in do_handle_one_connection (connect=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1335 #22 0x00005619ee1643d3 in handle_one_connection (arg=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1241 #23 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f11536b0) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #24 0x00007f2472181494 in start_thread (arg=0x7f2454f32700) at pthread_create.c:333 #25 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 16 (Thread 0x7f2442197700 (LWP 11111)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f2442196c40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f2442196c40, m1=0x7f2442196ce8, m2=0x7f2442196cf0, request=0x7f2442196d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=8, m1=0x7f2442196ce8, m2=0x7f2442196cf0, request=0x7f2442196d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=8, m1=0x7f2442196ce8, m2=0x7f2442196cf0, request=0x7f2442196d20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=8) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe27000 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f2442197700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 15 (Thread 0x7f2442998700 (LWP 11110)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f2442997c40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f2442997c40, m1=0x7f2442997ce8, m2=0x7f2442997cf0, request=0x7f2442997d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=7, m1=0x7f2442997ce8, m2=0x7f2442997cf0, request=0x7f2442997d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=7, m1=0x7f2442997ce8, m2=0x7f2442997cf0, request=0x7f2442997d20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=7) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe26ff8 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f2442998700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 14 (Thread 0x7f243bfff700 (LWP 11116)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005619ee661cb9 in os_event::timed_wait (this=0x5619f07afb40, abstime=0x7f243bffece0) at /data/src/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005619ee661fc3 in os_event::wait_time_low (this=0x5619f07afb40, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005619ee6621a4 in os_event_wait_time_low (event=0x5619f07afb40, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005619ee74b0a5 in srv_error_monitor_thread () at /data/src/10.2/storage/innobase/srv/srv0srv.cc:1922 #5 0x00007f2472181494 in start_thread (arg=0x7f243bfff700) at pthread_create.c:333 #6 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 13 (Thread 0x7f243b7fe700 (LWP 11117)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005619ee661cb9 in os_event::timed_wait (this=0x5619f07afbc0, abstime=0x7f243b7fde60) at /data/src/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005619ee661fc3 in os_event::wait_time_low (this=0x5619f07afbc0, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005619ee6621a4 in os_event_wait_time_low (event=0x5619f07afbc0, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005619ee74ab6f in srv_monitor_thread () at /data/src/10.2/storage/innobase/srv/srv0srv.cc:1753 #5 0x00007f2472181494 in start_thread (arg=0x7f243b7fe700) at pthread_create.c:333 #6 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 12 (Thread 0x7f2454ee8700 (LWP 11143)): #0 __lll_lock_wait () at ../sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135 #1 0x00007f2472183cc6 in __GI___pthread_mutex_lock (mutex=0x5619efe3fe40 ) at ../nptl/pthread_mutex_lock.c:135 #2 0x00005619ee9f6153 in safe_mutex_lock (mp=0x5619efe41d08 , my_flags=0, file=0x5619eebc6af8 "/data/src/10.2/storage/maria/ma_pagecache.c", line=4012) at /data/src/10.2/mysys/thr_mutex.c:335 #3 0x00005619ee4b9e3f in inline_mysql_mutex_lock (that=0x5619efe41d08 , src_file=0x5619eebc6af8 "/data/src/10.2/storage/maria/ma_pagecache.c", src_line=4012) at /data/src/10.2/include/mysql/psi/mysql_thread.h:681 #4 0x00005619ee4c297a in pagecache_write_part (pagecache=0x5619efe41c40 , file=0x7f23e80fae08, pageno=0, level=0, buff=0x7f23e8113ae0 "$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$I\222$\003", type=PAGECACHE_PLAIN_PAGE, lock=PAGECACHE_LOCK_LEFT_UNLOCKED, pin=PAGECACHE_PIN_LEFT_UNPINNED, write_mode=PAGECACHE_WRITE_DELAY, page_link=0x7f2454ee5a50, first_REDO_LSN_for_page=0, offset=0, size=8192) at /data/src/10.2/storage/maria/ma_pagecache.c:4012 #5 0x00005619ee505f93 in write_changed_bitmap (share=0x7f23e80fa300, bitmap=0x7f23e80fadc8) at /data/src/10.2/storage/maria/ma_bitmap.c:174 #6 0x00005619ee5067cd in _ma_bitmap_flush (share=0x7f23e80fa300) at /data/src/10.2/storage/maria/ma_bitmap.c:433 #7 0x00005619ee500164 in _ma_scan_init_block_record (info=0x7f23e81b15d0) at /data/src/10.2/storage/maria/ma_blockrec.c:5262 #8 0x00005619ee4ede4f in maria_scan_init (info=0x7f23e81b15d0) at /data/src/10.2/storage/maria/ma_scan.c:29 #9 0x00005619ee49a458 in ha_maria::rnd_init (this=0x7f23e80be6d8, scan=true) at /data/src/10.2/storage/maria/ha_maria.cc:2447 #10 0x00005619edfa0e24 in handler::ha_rnd_init (this=0x7f23e80be6d8, scan=true) at /data/src/10.2/sql/handler.h:2839 #11 0x00005619ee294393 in handler::ha_rnd_init_with_error (this=0x7f23e80be6d8, scan=true) at /data/src/10.2/sql/handler.cc:2786 #12 0x00005619ee3fe8a7 in init_read_record (info=0x7f23e81104e8, thd=0x7f23e8000b00, table=0x7f23e80ea668, select=0x0, filesort=0x0, use_record_cache=1, print_error=true, disable_rr_cache=false) at /data/src/10.2/sql/records.cc:299 #13 0x00005619ee08d5cc in join_init_read_record (tab=0x7f23e8110420) at /data/src/10.2/sql/sql_select.cc:19610 #14 0x00005619ee08b3f6 in sub_select (join=0x7f23e8108db0, join_tab=0x7f23e8110420, end_of_records=false) at /data/src/10.2/sql/sql_select.cc:18688 #15 0x00005619ee08a9f1 in do_select (join=0x7f23e8108db0, procedure=0x0) at /data/src/10.2/sql/sql_select.cc:18235 #16 0x00005619ee0650f3 in JOIN::exec_inner (this=0x7f23e8108db0) at /data/src/10.2/sql/sql_select.cc:3566 #17 0x00005619ee0645a0 in JOIN::exec (this=0x7f23e8108db0) at /data/src/10.2/sql/sql_select.cc:3361 #18 0x00005619ee06576b in mysql_select (thd=0x7f23e8000b00, tables=0x7f23e8011f90, wild_num=1, fields=..., conds=0x7f23e8014c68, og_num=0, order=0x0, group=0x0, having=0x7f23e81067a0, proc_param=0x0, select_options=552440433408, result=0x7f23e8108d90, unit=0x7f23e80046a8, select_lex=0x7f23e8004de0) at /data/src/10.2/sql/sql_select.cc:3761 #19 0x00005619ee059db2 in handle_select (thd=0x7f23e8000b00, lex=0x7f23e80045e0, result=0x7f23e8108d90, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:376 #20 0x00005619ee025b9b in execute_sqlcom_select (thd=0x7f23e8000b00, all_tables=0x7f23e8011f90) at /data/src/10.2/sql/sql_parse.cc:6456 #21 0x00005619ee01bc22 in mysql_execute_command (thd=0x7f23e8000b00) at /data/src/10.2/sql/sql_parse.cc:3467 #22 0x00005619ee0295d1 in mysql_parse (thd=0x7f23e8000b00, rawbuf=0x7f23e80110c8 "SELECT * FROM (INFORMATION_SCHEMA.`INNODB_SYS_INDEXES` AS table1 RIGHT OUTER JOIN INFORMATION_SCHEMA.`INNODB_BUFFER_PAGE` AS table2 ON ( table2.`IS_HASHED` = table1.`PAGE_NO` ) ) WHERE ( ( ( ( ( table"..., length=778, parser_state=0x7f2454ee7200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902 #23 0x00005619ee0174f1 in dispatch_command (command=COM_QUERY, thd=0x7f23e8000b00, packet=0x7f23e8008851 "", packet_length=780, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806 #24 0x00005619ee015e54 in do_command (thd=0x7f23e8000b00) at /data/src/10.2/sql/sql_parse.cc:1360 #25 0x00005619ee164646 in do_handle_one_connection (connect=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1335 #26 0x00005619ee1643d3 in handle_one_connection (arg=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1241 #27 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f07616f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #28 0x00007f2472181494 in start_thread (arg=0x7f2454ee8700) at pthread_create.c:333 #29 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 11 (Thread 0x7f2443199700 (LWP 11109)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f2443198c40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f2443198c40, m1=0x7f2443198ce8, m2=0x7f2443198cf0, request=0x7f2443198d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=6, m1=0x7f2443198ce8, m2=0x7f2443198cf0, request=0x7f2443198d20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=6, m1=0x7f2443198ce8, m2=0x7f2443198cf0, request=0x7f2443198d20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=6) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe26ff0 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f2443199700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 10 (Thread 0x7f244599e700 (LWP 11104)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f244599dc40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f244599dc40, m1=0x7f244599dce8, m2=0x7f244599dcf0, request=0x7f244599dd20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=1, m1=0x7f244599dce8, m2=0x7f244599dcf0, request=0x7f244599dd20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=1, m1=0x7f244599dce8, m2=0x7f244599dcf0, request=0x7f244599dd20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=1) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe26fc8 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f244599e700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 9 (Thread 0x7f245419b700 (LWP 11150)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005619ee9f6aca in safe_cond_timedwait (cond=0x5619ef5a5f60 , mp=0x5619ef5a8800 , abstime=0x7f245419ada0, file=0x5619eea862c0 "/data/src/10.2/include/mysql/psi/mysql_thread.h", line=1186) at /data/src/10.2/mysys/thr_mutex.c:545 #2 0x00005619edf34a69 in inline_mysql_cond_timedwait (that=0x5619ef5a5f60 , mutex=0x5619ef5a8800 , abstime=0x7f245419ada0, src_file=0x5619eea8802a "/data/src/10.2/sql/mysqld.cc", src_line=2968) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1186 #3 0x00005619edf39aec in cache_thread (thd=0x7f23d8000b00) at /data/src/10.2/sql/mysqld.cc:2967 #4 0x00005619edf39d90 in one_thread_per_connection_end (thd=0x7f23d8000b00, put_in_cache=true) at /data/src/10.2/sql/mysqld.cc:3056 #5 0x00005619ee16472f in do_handle_one_connection (connect=0x5619f1154e20) at /data/src/10.2/sql/sql_connect.cc:1354 #6 0x00005619ee1643d3 in handle_one_connection (arg=0x5619f1154e20) at /data/src/10.2/sql/sql_connect.cc:1241 #7 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f115d460) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #8 0x00007f2472181494 in start_thread (arg=0x7f245419b700) at pthread_create.c:333 #9 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 8 (Thread 0x7f2454f7c700 (LWP 11135)): #0 __lll_lock_wait () at ../sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135 #1 0x00007f2472183b95 in __GI___pthread_mutex_lock (mutex=0x5619efe43868 ) at ../nptl/pthread_mutex_lock.c:80 #2 0x00005619ee9f5f95 in safe_mutex_lock (mp=0x5619efe43840 , my_flags=0, file=0x5619eed562b0 "/data/src/10.2/storage/myisam/mi_close.c", line=35) at /data/src/10.2/mysys/thr_mutex.c:292 #3 0x00005619ee95010d in inline_mysql_mutex_lock (that=0x5619efe43840 , src_file=0x5619eed562b0 "/data/src/10.2/storage/myisam/mi_close.c", src_line=35) at /data/src/10.2/include/mysql/psi/mysql_thread.h:681 #4 0x00005619ee950324 in mi_close (info=0x7f24001a09c0) at /data/src/10.2/storage/myisam/mi_close.c:35 #5 0x00005619ee939a1a in ha_myisam::close (this=0x7f2400147d68) at /data/src/10.2/storage/myisam/ha_myisam.cc:907 #6 0x00005619ee292b73 in handler::ha_close (this=0x7f2400147d68) at /data/src/10.2/sql/handler.cc:2566 #7 0x00005619ee11ecce in closefrm (table=0x7f2400216040) at /data/src/10.2/sql/table.cc:3419 #8 0x00005619ee206f02 in intern_close_table (table=0x7f2400216040) at /data/src/10.2/sql/table_cache.cc:222 #9 0x00005619ee2070a1 in tc_remove_table (table=0x7f2400216040) at /data/src/10.2/sql/table_cache.cc:260 #10 0x00005619ee207592 in tc_add_table (thd=0x7f2400000ba0, table=0x7f2400178ef0) at /data/src/10.2/sql/table_cache.cc:383 #11 0x00005619edfa93de in open_table (thd=0x7f2400000ba0, table_list=0x7f2400013748, ot_ctx=0x7f2454f771f0) at /data/src/10.2/sql/sql_base.cc:1904 #12 0x00005619edfabd69 in open_and_process_table (thd=0x7f2400000ba0, lex=0x7f2400004680, tables=0x7f2400013748, counter=0x7f2454f772bc, flags=0, prelocking_strategy=0x7f2454f772c0, has_prelocking_list=false, ot_ctx=0x7f2454f771f0) at /data/src/10.2/sql/sql_base.cc:3409 #13 0x00005619edfacea4 in open_tables (thd=0x7f2400000ba0, options=..., start=0x7f2454f772a0, counter=0x7f2454f772bc, flags=0, prelocking_strategy=0x7f2454f772c0) at /data/src/10.2/sql/sql_base.cc:3928 #14 0x00005619edfa5cd4 in open_tables (thd=0x7f2400000ba0, tables=0x7f2454f772a0, counter=0x7f2454f772bc, flags=0, prelocking_strategy=0x7f2454f772c0) at /data/src/10.2/sql/sql_base.h:237 #15 0x00005619edfae8b8 in open_normal_and_derived_tables (thd=0x7f2400000ba0, tables=0x7f2400013748, flags=0, dt_phases=2) at /data/src/10.2/sql/sql_base.cc:4745 #16 0x00005619edf8b4f2 in mysql_table_grant (thd=0x7f2400000ba0, table_list=0x7f2400013748, user_list=..., columns=..., rights=0, revoke_grant=false) at /data/src/10.2/sql/sql_acl.cc:6434 #17 0x00005619ee021afa in mysql_execute_command (thd=0x7f2400000ba0) at /data/src/10.2/sql/sql_parse.cc:5266 #18 0x00005619ee0295d1 in mysql_parse (thd=0x7f2400000ba0, rawbuf=0x7f2400013478 "GRANT UPDATE ( `col_date_nokey`, `col_datetime_key` ) ON `D` TO 'someuser'@'somehost' /* QNO 14765 CON_ID 14 */", length=111, parser_state=0x7f2454f7b200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902 #19 0x00005619ee0174f1 in dispatch_command (command=COM_QUERY, thd=0x7f2400000ba0, packet=0x7f24000de161 "GRANT UPDATE ( `col_date_nokey`, `col_datetime_key` ) ON `D` TO 'someuser'@'somehost' /* QNO 14765 CON_ID 14 */ ", packet_length=112, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806 #20 0x00005619ee015e54 in do_command (thd=0x7f2400000ba0) at /data/src/10.2/sql/sql_parse.cc:1360 #21 0x00005619ee164646 in do_handle_one_connection (connect=0x5619f1197a50) at /data/src/10.2/sql/sql_connect.cc:1335 #22 0x00005619ee1643d3 in handle_one_connection (arg=0x5619f1197a50) at /data/src/10.2/sql/sql_connect.cc:1241 #23 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f119dc10) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #24 0x00007f2472181494 in start_thread (arg=0x7f2454f7c700) at pthread_create.c:333 #25 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 7 (Thread 0x7f2440994700 (LWP 11115)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005619ee661cb9 in os_event::timed_wait (this=0x5619f12e5880, abstime=0x7f2440993e80) at /data/src/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005619ee661fc3 in os_event::wait_time_low (this=0x5619f12e5880, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005619ee6621a4 in os_event_wait_time_low (event=0x5619f12e5880, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005619ee630bbe in lock_wait_timeout_thread () at /data/src/10.2/storage/innobase/lock/lock0wait.cc:547 #5 0x00007f2472181494 in start_thread (arg=0x7f2440994700) at pthread_create.c:333 #6 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 6 (Thread 0x7f24317fa700 (LWP 11128)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x00005619ee9f67c0 in safe_cond_wait (cond=0x7f24317f9dc0, mp=0x7f24317f9e00, file=0x5619eebf1980 "/data/src/10.2/include/mysql/psi/mysql_thread.h", line=1149) at /data/src/10.2/mysys/thr_mutex.c:491 #2 0x00005619ee59172d in inline_mysql_cond_wait (that=0x7f24317f9dc0, mutex=0x7f24317f9e00, src_file=0x5619eebf3038 "/data/src/10.2/storage/innobase/handler/ha_innodb.cc", src_line=338) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1149 #3 0x00005619ee595dc7 in thd_destructor_proxy () at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:338 #4 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f10eb000) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #5 0x00007f2472181494 in start_thread (arg=0x7f24317fa700) at pthread_create.c:333 #6 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 5 (Thread 0x7f2439ffb700 (LWP 11120)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005619ee661cb9 in os_event::timed_wait (this=0x5619f10ea1b0, abstime=0x7f2439ffac90) at /data/src/10.2/storage/innobase/os/os0event.cc:286 #2 0x00005619ee661fc3 in os_event::wait_time_low (this=0x5619f10ea1b0, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:413 #3 0x00005619ee6621a4 in os_event_wait_time_low (event=0x5619f10ea1b0, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:518 #4 0x00005619ee7b571f in ib_wqueue_timedwait (wq=0x5619f10ea0a0, wait_in_usecs=5000000) at /data/src/10.2/storage/innobase/ut/ut0wqueue.cc:163 #5 0x00005619ee8eaf1f in fts_optimize_thread (arg=0x5619f10ea0a0) at /data/src/10.2/storage/innobase/fts/fts0opt.cc:3035 #6 0x00007f2472181494 in start_thread (arg=0x7f2439ffb700) at pthread_create.c:333 #7 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 4 (Thread 0x7f24541e5700 (LWP 11149)): #0 __lll_lock_wait () at ../sysdeps/unix/sysv/linux/x86_64/lowlevellock.S:135 #1 0x00007f2472183cc6 in __GI___pthread_mutex_lock (mutex=0x5619efe3fe40 ) at ../nptl/pthread_mutex_lock.c:135 #2 0x00005619ee9f6d93 in safe_mutex_destroy (mp=0x7f2400139c60, file=0x5619eed67bb0 "/data/src/10.2/mysys/thr_lock.c", line=463) at /data/src/10.2/mysys/thr_mutex.c:635 #3 0x00005619ee9f2f0c in inline_mysql_mutex_destroy (that=0x7f2400139c60, src_file=0x5619eed67bb0 "/data/src/10.2/mysys/thr_lock.c", src_line=463) at /data/src/10.2/include/mysql/psi/mysql_thread.h:640 #4 0x00005619ee9f34bc in thr_lock_delete (lock=0x7f2400139c48) at /data/src/10.2/mysys/thr_lock.c:463 #5 0x00005619ee95065e in mi_close (info=0x7f24001606d0) at /data/src/10.2/storage/myisam/mi_close.c:104 #6 0x00005619ee939a1a in ha_myisam::close (this=0x7f24003fe6d8) at /data/src/10.2/storage/myisam/ha_myisam.cc:907 #7 0x00005619ee292b73 in handler::ha_close (this=0x7f24003fe6d8) at /data/src/10.2/sql/handler.cc:2566 #8 0x00005619ee11ecce in closefrm (table=0x7f240012b780) at /data/src/10.2/sql/table.cc:3419 #9 0x00005619ee206f02 in intern_close_table (table=0x7f240012b780) at /data/src/10.2/sql/table_cache.cc:222 #10 0x00005619ee2070a1 in tc_remove_table (table=0x7f240012b780) at /data/src/10.2/sql/table_cache.cc:260 #11 0x00005619ee207592 in tc_add_table (thd=0x7f23e4000b00, table=0x7f23e42c9290) at /data/src/10.2/sql/table_cache.cc:383 #12 0x00005619edfa93de in open_table (thd=0x7f23e4000b00, table_list=0x7f23e4012ee8, ot_ctx=0x7f24541e3010) at /data/src/10.2/sql/sql_base.cc:1904 #13 0x00005619edfabd69 in open_and_process_table (thd=0x7f23e4000b00, lex=0x7f23e40045e0, tables=0x7f23e4012ee8, counter=0x7f24541e30a4, flags=0, prelocking_strategy=0x7f24541e3120, has_prelocking_list=false, ot_ctx=0x7f24541e3010) at /data/src/10.2/sql/sql_base.cc:3409 #14 0x00005619edfacea4 in open_tables (thd=0x7f23e4000b00, options=..., start=0x7f24541e3088, counter=0x7f24541e30a4, flags=0, prelocking_strategy=0x7f24541e3120) at /data/src/10.2/sql/sql_base.cc:3928 #15 0x00005619edfae698 in open_and_lock_tables (thd=0x7f23e4000b00, options=..., tables=0x7f23e4011670, derived=true, flags=0, prelocking_strategy=0x7f24541e3120) at /data/src/10.2/sql/sql_base.cc:4682 #16 0x00005619edfa1b93 in open_and_lock_tables (thd=0x7f23e4000b00, tables=0x7f23e4011670, derived=true, flags=0) at /data/src/10.2/sql/sql_base.h:494 #17 0x00005619ee0256f9 in execute_sqlcom_select (thd=0x7f23e4000b00, all_tables=0x7f23e4011670) at /data/src/10.2/sql/sql_parse.cc:6377 #18 0x00005619ee01bc22 in mysql_execute_command (thd=0x7f23e4000b00) at /data/src/10.2/sql/sql_parse.cc:3467 #19 0x00005619ee0295d1 in mysql_parse (thd=0x7f23e4000b00, rawbuf=0x7f23e40110c8 "/* GenTest::Transform::ExecuteAsUnion */ ( SELECT * FROM mysql.`proxies_priv` AS table1 HAVING (table1.`Grantor` < '2012-04-15 13:44:45.016460' IS NULL OR table1.`With_grant` <= 4) LIMIT 32 /* QNO 15"..., length=470, parser_state=0x7f24541e4200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902 #20 0x00005619ee0174f1 in dispatch_command (command=COM_QUERY, thd=0x7f23e4000b00, packet=0x7f23e4008851 "/* GenTest::Transform::ExecuteAsUnion */ ( SELECT * FROM mysql.`proxies_priv` AS table1 HAVING (table1.`Grantor` < '2012-04-15 13:44:45.016460' IS NULL OR table1.`With_grant` <= 4) LIMIT 32 /* QNO 15"..., packet_length=471, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806 #21 0x00005619ee015e54 in do_command (thd=0x7f23e4000b00) at /data/src/10.2/sql/sql_parse.cc:1360 #22 0x00005619ee164646 in do_handle_one_connection (connect=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1335 #23 0x00005619ee1643d3 in handle_one_connection (arg=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1241 #24 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f1148050) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #25 0x00007f2472181494 in start_thread (arg=0x7f24541e5700) at pthread_create.c:333 #26 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 3 (Thread 0x7f246a711700 (LWP 11101)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x00005619ee9f6aca in safe_cond_timedwait (cond=0x5619efe3ff80 , mp=0x5619efe3fec0 , abstime=0x7f246a710eb0, file=0x5619eed68670 "/data/src/10.2/include/mysql/psi/mysql_thread.h", line=1186) at /data/src/10.2/mysys/thr_mutex.c:545 #2 0x00005619ee9f7a8b in inline_mysql_cond_timedwait (that=0x5619efe3ff80 , mutex=0x5619efe3fec0 , abstime=0x7f246a710eb0, src_file=0x5619eed686a0 "/data/src/10.2/mysys/thr_timer.c", src_line=292) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1186 #3 0x00005619ee9f8542 in timer_handler (arg=0x0) at /data/src/10.2/mysys/thr_timer.c:292 #4 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f067eae0) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #5 0x00007f2472181494 in start_thread (arg=0x7f246a711700) at pthread_create.c:333 #6 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 2 (Thread 0x7f2454e3d700 (LWP 11103)): #0 0x00007f2471f786ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x00005619ee6556f0 in LinuxAIOHandler::collect (this=0x7f2454e3cc40) at /data/src/10.2/storage/innobase/os/os0file.cc:1893 #2 0x00005619ee655bfe in LinuxAIOHandler::poll (this=0x7f2454e3cc40, m1=0x7f2454e3cce8, m2=0x7f2454e3ccf0, request=0x7f2454e3cd20) at /data/src/10.2/storage/innobase/os/os0file.cc:2038 #3 0x00005619ee655d5e in os_aio_linux_handler (global_segment=0, m1=0x7f2454e3cce8, m2=0x7f2454e3ccf0, request=0x7f2454e3cd20) at /data/src/10.2/storage/innobase/os/os0file.cc:2092 #4 0x00005619ee65a8c9 in os_aio_handler (segment=0, m1=0x7f2454e3cce8, m2=0x7f2454e3ccf0, request=0x7f2454e3cd20) at /data/src/10.2/storage/innobase/os/os0file.cc:5720 #5 0x00005619ee8a433e in fil_aio_wait (segment=0) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5331 #6 0x00005619ee74f899 in io_handler_thread (arg=0x5619efe26fc0 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:342 #7 0x00007f2472181494 in start_thread (arg=0x7f2454e3d700) at pthread_create.c:333 #8 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 1 (Thread 0x7f2454e9e700 (LWP 11145)): #0 __pthread_kill (threadid=, signo=6) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x00005619ee9f126d in my_write_core (sig=6) at /data/src/10.2/mysys/stacktrace.c:477 #2 0x00005619ee28c4bc in handle_fatal_signal (sig=6) at /data/src/10.2/sql/signal_handler.cc:305 #3 #4 0x00007f24704b1fcf in raise () from /lib/x86_64-linux-gnu/libc.so.6 #5 0x00007f24704b33fa in abort () from /lib/x86_64-linux-gnu/libc.so.6 #6 0x00007f24704aae37 in __assert_fail_base () from /lib/x86_64-linux-gnu/libc.so.6 #7 0x00007f24704aaee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x00005619ee9f701c in add_to_locked_mutex (locked_mutex=0x7f23ec05b740, current_mutex=0x5619ef5d4400 ) at /data/src/10.2/mysys/thr_mutex.c:747 #9 0x00005619ee9f6f20 in add_used_to_locked_mutex (used_mutex=0x5619ef5d4400 , locked_mutex=0x7f23ec05b740) at /data/src/10.2/mysys/thr_mutex.c:721 #10 0x00005619ee9f62b6 in safe_mutex_lock (mp=0x7f23f003dd50, my_flags=0, file=0x5619eeb06460 "/data/src/10.2/sql/table_cache.cc", line=744) at /data/src/10.2/mysys/thr_mutex.c:386 #11 0x00005619ee206b27 in inline_mysql_mutex_lock (that=0x7f23f003dd50, src_file=0x5619eeb06460 "/data/src/10.2/sql/table_cache.cc", src_line=744) at /data/src/10.2/include/mysql/psi/mysql_thread.h:681 #12 0x00005619ee20870f in tdc_lock_share (thd=0x7f23ec000b00, db=0x7f23ec0117e0 "test", table_name=0x7f23ec011198 "t2") at /data/src/10.2/sql/table_cache.cc:744 #13 0x00005619ee20972a in tdc_remove_table (thd=0x7f23ec000b00, remove_type=TDC_RT_REMOVE_UNUSED, db=0x7f23ec0117e0 "test", table_name=0x7f23ec011198 "t2", kill_delayed_threads=false) at /data/src/10.2/sql/table_cache.cc:1086 #14 0x00005619ee17828c in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *)) (thd=0x7f23ec000b00, tables=0x7f23ec0111d0, check_opt=0x7f23ec0055a8, operator_name=0x5619eeae4308 "optimize", lock_type=TL_WRITE, open_for_modify=true, repair_table_use_frm=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5619ee296de8 , view_operator_func=0x0) at /data/src/10.2/sql/sql_admin.cc:1152 #15 0x00005619ee178d86 in Sql_cmd_optimize_table::execute (this=0x7f23ec0117e8, thd=0x7f23ec000b00) at /data/src/10.2/sql/sql_admin.cc:1363 #16 0x00005619ee024c57 in mysql_execute_command (thd=0x7f23ec000b00) at /data/src/10.2/sql/sql_parse.cc:6208 #17 0x00005619ee0295d1 in mysql_parse (thd=0x7f23ec000b00, rawbuf=0x7f23ec0110c8 "OPTIMIZE TABLE t2 /* QNO 1736 CON_ID 17 */", length=42, parser_state=0x7f2454e9d200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7902 #18 0x00005619ee0174f1 in dispatch_command (command=COM_QUERY, thd=0x7f23ec000b00, packet=0x7f23ec008851 "", packet_length=43, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1806 #19 0x00005619ee015e54 in do_command (thd=0x7f23ec000b00) at /data/src/10.2/sql/sql_parse.cc:1360 #20 0x00005619ee164646 in do_handle_one_connection (connect=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1335 #21 0x00005619ee1643d3 in handle_one_connection (arg=0x5619f07646a0) at /data/src/10.2/sql/sql_connect.cc:1241 #22 0x00005619ee5841f8 in pfs_spawn_thread (arg=0x5619f1185a60) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #23 0x00007f2472181494 in start_thread (arg=0x7f2454e9e700) at pthread_create.c:333 #24 0x00007f247056793f in clone () from /lib/x86_64-linux-gnu/libc.so.6