[New LWP 12817] [New LWP 12818] [New LWP 12819] [New LWP 12820] [New LWP 12821] [New LWP 12822] [New LWP 12823] [New LWP 12824] [New LWP 12826] [New LWP 12827] [New LWP 12828] [New LWP 12829] [New LWP 12830] [New LWP 12831] [New LWP 12832] [New LWP 12833] [New LWP 12834] [New LWP 12835] [New LWP 12836] [New LWP 12837] [New LWP 12838] [New LWP 12839] [New LWP 12840] [New LWP 12841] [New LWP 12842] [New LWP 12845] [New LWP 12848] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". 0x00007fab726578bd in poll () at ../sysdeps/unix/syscall-template.S:84 Thread 28 (Thread 0x7fab6cba6700 (LWP 12848)): #0 0x0000563c93a77eb5 in rw_lock_validate (lock=0x563c961d2e50) at /data/src/10.2/storage/innobase/sync/sync0rw.cc:860 #1 0x0000563c93a78278 in rw_lock_own (lock=0x563c961d2e50, lock_type=4) at /data/src/10.2/storage/innobase/sync/sync0rw.cc:998 #2 0x0000563c93b29c93 in buf_pool_watch_is_sentinel (buf_pool=0x563c9617ffb0, bpage=0x7fab6cec1a58) at /data/src/10.2/storage/innobase/buf/buf0buf.cc:3343 #3 0x0000563c93b2c640 in buf_page_get_low (page_id=..., page_size=..., rw_latch=1, guess=0x0, mode=10, file=0x563c94080920 "/data/src/10.2/storage/innobase/row/row0sel.cc", line=1338, mtr=0x7fab6cba2720, err=0x7fab6cba1598) at /data/src/10.2/storage/innobase/buf/buf0buf.cc:4283 #4 0x0000563c93b2df72 in buf_page_get_gen (page_id=..., page_size=..., rw_latch=1, guess=0x7fab6cec1a58, mode=10, file=0x563c94080920 "/data/src/10.2/storage/innobase/row/row0sel.cc", line=1338, mtr=0x7fab6cba2720, err=0x7fab6cba1598) at /data/src/10.2/storage/innobase/buf/buf0buf.cc:4882 #5 0x0000563c93af410a in btr_cur_search_to_nth_level_func (index=0x7fab44013890, level=0, tuple=0x7fab1803dc00, mode=PAGE_CUR_GE, latch_mode=1, cursor=0x7fab1803d910, has_search_latch=0, file=0x563c94080920 "/data/src/10.2/storage/innobase/row/row0sel.cc", line=1338, mtr=0x7fab6cba2720, autoinc=0) at /data/src/10.2/storage/innobase/btr/btr0cur.cc:1261 #6 0x0000563c93a28fa0 in btr_pcur_open_with_no_init_func (index=0x7fab44013890, tuple=0x7fab1803dc00, mode=PAGE_CUR_GE, latch_mode=1, cursor=0x7fab1803d910, has_search_latch=0, file=0x563c94080920 "/data/src/10.2/storage/innobase/row/row0sel.cc", line=1338, mtr=0x7fab6cba2720) at /data/src/10.2/storage/innobase/include/btr0pcur.ic:521 #7 0x0000563c93a2c973 in row_sel_open_pcur (plan=0x7fab1803d900, has_search_latch=0, mtr=0x7fab6cba2720) at /data/src/10.2/storage/innobase/row/row0sel.cc:1338 #8 0x0000563c93a2d3c8 in row_sel (node=0x7fab1803d810, thr=0x7fab1803dd50) at /data/src/10.2/storage/innobase/row/row0sel.cc:1715 #9 0x0000563c93a2e7ae in row_sel_step (thr=0x7fab1803dd50) at /data/src/10.2/storage/innobase/row/row0sel.cc:2399 #10 0x0000563c939aecd4 in que_thr_step (thr=0x7fab1803dd50) at /data/src/10.2/storage/innobase/que/que0que.cc:1020 #11 0x0000563c939aefee in que_run_threads_low (thr=0x7fab1803dd50) at /data/src/10.2/storage/innobase/que/que0que.cc:1104 #12 0x0000563c939af1a3 in que_run_threads (thr=0x7fab1803dd50) at /data/src/10.2/storage/innobase/que/que0que.cc:1144 #13 0x0000563c939af44c in que_eval_sql (info=0x7fab18041c10, sql=0x563c94108c48 "PROCEDURE DELETE_FROM_TABLE_STATS () IS\nBEGIN\nDELETE FROM \"mysql/innodb_table_stats\" WHERE\ndatabase_name = :database_name AND\ntable_name = :table_name;\nEND;\n", reserve_dict_mutex=0, trx=0x7fab6d7b94b8) at /data/src/10.2/storage/innobase/que/que0que.cc:1221 #14 0x0000563c93b97e99 in dict_stats_exec_sql (pinfo=0x7fab18041c10, sql=0x563c94108c48 "PROCEDURE DELETE_FROM_TABLE_STATS () IS\nBEGIN\nDELETE FROM \"mysql/innodb_table_stats\" WHERE\ndatabase_name = :database_name AND\ntable_name = :table_name;\nEND;\n", trx=0x7fab6d7b94b8) at /data/src/10.2/storage/innobase/dict/dict0stats.cc:305 #15 0x0000563c93b9ebed in dict_stats_delete_from_table_stats (database_name=0x7fab6cba2e30 "db", table_name=0x7fab6cba2f00 "#mysql50##sql-ib19") at /data/src/10.2/storage/innobase/dict/dict0stats.cc:3469 #16 0x0000563c93b9ee0a in dict_stats_drop_table (db_and_table=0x7fab18031dd0 "db/#sql-ib19", errstr=0x7fab6cba33e0 "", errstr_sz=1024) at /data/src/10.2/storage/innobase/dict/dict0stats.cc:3554 #17 0x0000563c93a03308 in row_drop_table_for_mysql (name=0x7fab18031dd0 "db/#sql-ib19", trx=0x7fab6d7b8390, sqlcom=SQLCOM_DROP_DB, create_failed=false, nonatomic=true) at /data/src/10.2/storage/innobase/row/row0mysql.cc:3399 #18 0x0000563c93a04b6b in row_drop_database_for_mysql (name=0x7fab18041a80 "db/", trx=0x7fab6d7b8390, found=0x7fab6cba4240) at /data/src/10.2/storage/innobase/row/row0mysql.cc:4008 #19 0x0000563c938c9c24 in innobase_drop_database (hton=0x563c960cc6c0, path=0x7fab6cba47c0 "./db/") at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:13542 #20 0x0000563c936c02f3 in dropdb_handlerton (unused1=0x0, plugin=0x7fab1803ce80, path=0x7fab6cba47c0) at /data/src/10.2/sql/handler.cc:742 #21 0x0000563c9346201d in plugin_foreach_with_mask (thd=0x0, func=0x563c936c029a , type=1, state_mask=8, arg=0x7fab6cba47c0) at /data/src/10.2/sql/sql_plugin.cc:2402 #22 0x0000563c936c0328 in ha_drop_database (path=0x7fab6cba47c0 "./db/") at /data/src/10.2/sql/handler.cc:749 #23 0x0000563c93413571 in mysql_rm_db_internal (thd=0x7fab18000af0, db=0x7fab18011120 "db", if_exists=false, silent=false) at /data/src/10.2/sql/sql_db.cc:937 #24 0x0000563c93413c4d in mysql_rm_db (thd=0x7fab18000af0, db=0x7fab18011120 "db", if_exists=false) at /data/src/10.2/sql/sql_db.cc:1071 #25 0x0000563c9344ab65 in mysql_execute_command (thd=0x7fab18000af0) at /data/src/10.2/sql/sql_parse.cc:4736 #26 0x0000563c9345427b in mysql_parse (thd=0x7fab18000af0, rawbuf=0x7fab18011088 "DROP DATABASE db", length=16, parser_state=0x7fab6cba5610, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7741 #27 0x0000563c934425a8 in dispatch_command (command=COM_QUERY, thd=0x7fab18000af0, packet=0x7fab180088a1 "DROP DATABASE db", packet_length=16, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1832 #28 0x0000563c93441023 in do_command (thd=0x7fab18000af0) at /data/src/10.2/sql/sql_parse.cc:1385 #29 0x0000563c93596259 in do_handle_one_connection (connect=0x563c96675a00) at /data/src/10.2/sql/sql_connect.cc:1336 #30 0x0000563c93595fc4 in handle_one_connection (arg=0x563c96675a00) at /data/src/10.2/sql/sql_connect.cc:1241 #31 0x0000563c93dabc64 in pfs_spawn_thread (arg=0x563c965d1c30) at /data/src/10.2/storage/perfschema/pfs.cc:1869 #32 0x00007fab7452c4a4 in start_thread (arg=0x7fab6cba6700) at pthread_create.c:456 #33 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 27 (Thread 0x7fab6cbf1700 (LWP 12845)): #0 0x00007fab726578bd in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x0000563c93e6c4fa in vio_io_wait (vio=0x563c965d1880, event=VIO_IO_EVENT_READ, timeout=28800000) at /data/src/10.2/vio/viosocket.c:945 #2 0x0000563c93e6ad09 in vio_socket_io_wait (vio=0x563c965d1880, event=VIO_IO_EVENT_READ) at /data/src/10.2/vio/viosocket.c:108 #3 0x0000563c93e6aebf in vio_read (vio=0x563c965d1880, buf=0x7fab24095ac0 "d", size=4) at /data/src/10.2/vio/viosocket.c:184 #4 0x0000563c93364957 in my_real_read (net=0x7fab24000dd8, complen=0x7fab6cbf0d50, header=1 '\001') at /data/src/10.2/sql/net_serv.cc:892 #5 0x0000563c9336515a in my_net_read_packet_reallen (net=0x7fab24000dd8, read_from_server=1 '\001', reallen=0x7fab6cbf0db8) at /data/src/10.2/sql/net_serv.cc:1162 #6 0x0000563c9336510e in my_net_read_packet (net=0x7fab24000dd8, read_from_server=1 '\001') at /data/src/10.2/sql/net_serv.cc:1146 #7 0x0000563c93440b32 in do_command (thd=0x7fab24000af0) at /data/src/10.2/sql/sql_parse.cc:1261 #8 0x0000563c93596259 in do_handle_one_connection (connect=0x563c96684d30) at /data/src/10.2/sql/sql_connect.cc:1336 #9 0x0000563c93595fc4 in handle_one_connection (arg=0x563c96684d30) at /data/src/10.2/sql/sql_connect.cc:1241 #10 0x0000563c93dabc64 in pfs_spawn_thread (arg=0x563c965d1880) at /data/src/10.2/storage/perfschema/pfs.cc:1869 #11 0x00007fab7452c4a4 in start_thread (arg=0x7fab6cbf1700) at pthread_create.c:456 #12 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 26 (Thread 0x7fab6cc3c700 (LWP 12842)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000563c93e0deba in safe_cond_wait (cond=0x563c949c9040 , mp=0x563c949cc240 , file=0x563c93eaa580 "/data/src/10.2/include/mysql/psi/mysql_thread.h", line=1145) at /data/src/10.2/mysys/thr_mutex.c:491 #2 0x0000563c9337c980 in inline_mysql_cond_wait (that=0x563c949c9040 , mutex=0x563c949cc240 , src_file=0x563c93eaae15 "/data/src/10.2/sql/slave.cc", src_line=337) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1145 #3 0x0000563c9337d5c5 in handle_slave_background (arg=0x0) at /data/src/10.2/sql/slave.cc:337 #4 0x0000563c93dabc64 in pfs_spawn_thread (arg=0x563c96671c20) at /data/src/10.2/storage/perfschema/pfs.cc:1869 #5 0x00007fab7452c4a4 in start_thread (arg=0x7fab6cc3c700) at pthread_create.c:456 #6 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 25 (Thread 0x7fab6cc87700 (LWP 12841)): #0 do_sigwait (set=, set@entry=0x7fab6cc86e30, sig=sig@entry=0x7fab6cc86e00) at ../sysdeps/unix/sysv/linux/sigwait.c:64 #1 0x00007fab74535d0d in __sigwait (set=0x7fab6cc86e30, sig=0x7fab6cc86e00) at ../sysdeps/unix/sysv/linux/sigwait.c:96 #2 0x0000563c93353d26 in signal_hand (arg=0x0) at /data/src/10.2/sql/mysqld.cc:3509 #3 0x0000563c93dabc64 in pfs_spawn_thread (arg=0x563c965ca050) at /data/src/10.2/storage/perfschema/pfs.cc:1869 #4 0x00007fab7452c4a4 in start_thread (arg=0x7fab6cc87700) at pthread_create.c:456 #5 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 24 (Thread 0x7fab4cff9700 (LWP 12840)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000563c93e0e1c4 in safe_cond_timedwait (cond=0x563c9524eb60 , mp=0x563c9524eaa0 , abstime=0x7fab4cff8e00, file=0x563c941564c0 "/data/src/10.2/include/mysql/psi/mysql_thread.h", line=1182) at /data/src/10.2/mysys/thr_mutex.c:545 #2 0x0000563c93c8ad0b in inline_mysql_cond_timedwait (that=0x563c9524eb60 , mutex=0x563c9524eaa0 , abstime=0x7fab4cff8e00, src_file=0x563c941564f0 "/data/src/10.2/storage/maria/ma_servicethread.c", src_line=116) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1182 #3 0x0000563c93c8b20d in my_service_thread_sleep (control=0x563c9480ac00 , sleep_time=30000000000) at /data/src/10.2/storage/maria/ma_servicethread.c:115 #4 0x0000563c93c7fc84 in ma_checkpoint_background (arg=0x1e) at /data/src/10.2/storage/maria/ma_checkpoint.c:709 #5 0x0000563c93dabc64 in pfs_spawn_thread (arg=0x563c9659a510) at /data/src/10.2/storage/perfschema/pfs.cc:1869 #6 0x00007fab7452c4a4 in start_thread (arg=0x7fab4cff9700) at pthread_create.c:456 #7 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 23 (Thread 0x7fab4d7fa700 (LWP 12839)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000563c93e0deba in safe_cond_wait (cond=0x7fab4d7f9dc0, mp=0x7fab4d7f9e00, file=0x563c93feb980 "/data/src/10.2/include/mysql/psi/mysql_thread.h", line=1156) at /data/src/10.2/mysys/thr_mutex.c:491 #2 0x0000563c938adb86 in inline_mysql_cond_wait (that=0x7fab4d7f9dc0, mutex=0x7fab4d7f9e00, src_file=0x563c93fed2f0 "/data/src/10.2/storage/innobase/handler/ha_innodb.cc", src_line=328) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1156 #3 0x0000563c938b1f0c in thd_destructor_proxy () at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:328 #4 0x0000563c93dabc64 in pfs_spawn_thread (arg=0x563c9629d180) at /data/src/10.2/storage/perfschema/pfs.cc:1869 #5 0x00007fab7452c4a4 in start_thread (arg=0x7fab4d7fa700) at pthread_create.c:456 #6 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 22 (Thread 0x7fab4dffb700 (LWP 12838)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000563c9397f168 in os_event::wait (this=0x563c960fdfa0) at /data/src/10.2/storage/innobase/os/os0event.cc:158 #2 0x0000563c9397ec5e in os_event::wait_low (this=0x563c960fdfa0, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:325 #3 0x0000563c9397ef51 in os_event_wait_low (event=0x563c960fdfa0, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:507 #4 0x0000563c93b29344 in buf_resize_thread () at /data/src/10.2/storage/innobase/buf/buf0buf.cc:3137 #5 0x00007fab7452c4a4 in start_thread (arg=0x7fab4dffb700) at pthread_create.c:456 #6 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 21 (Thread 0x7fab4e7fc700 (LWP 12837)): #0 0x00007fab745357fd in nanosleep () at ../sysdeps/unix/syscall-template.S:84 #1 0x0000563c9397f4a5 in os_thread_sleep (tm=1000000) at /data/src/10.2/storage/innobase/os/os0thread.cc:231 #2 0x0000563c93b1bc35 in btr_defragment_thread () at /data/src/10.2/storage/innobase/btr/btr0defragment.cc:715 #3 0x00007fab7452c4a4 in start_thread (arg=0x7fab4e7fc700) at pthread_create.c:456 #4 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 20 (Thread 0x7fab4effd700 (LWP 12836)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000563c9397f168 in os_event::wait (this=0x563c960fdea0) at /data/src/10.2/storage/innobase/os/os0event.cc:158 #2 0x0000563c9397ec5e in os_event::wait_low (this=0x563c960fdea0, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:325 #3 0x0000563c9397ef51 in os_event_wait_low (event=0x563c960fdea0, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:507 #4 0x0000563c93b3febb in buf_dump_thread () at /data/src/10.2/storage/innobase/buf/buf0dump.cc:806 #5 0x00007fab7452c4a4 in start_thread (arg=0x7fab4effd700) at pthread_create.c:456 #6 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 19 (Thread 0x7fab4f7fe700 (LWP 12835)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000563c9397f168 in os_event::wait (this=0x563c960fdc20) at /data/src/10.2/storage/innobase/os/os0event.cc:158 #2 0x0000563c9397ec5e in os_event::wait_low (this=0x563c960fdc20, reset_sig_count=187) at /data/src/10.2/storage/innobase/os/os0event.cc:325 #3 0x0000563c9397ef51 in os_event_wait_low (event=0x563c960fdc20, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:507 #4 0x0000563c93a63ef6 in srv_resume_thread (slot=0x563c94806c40 , sig_count=0, wait=true, timeout_usec=0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:940 #5 0x0000563c93a67935 in srv_worker_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2613 #6 0x00007fab7452c4a4 in start_thread (arg=0x7fab4f7fe700) at pthread_create.c:456 #7 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 18 (Thread 0x7fab4ffff700 (LWP 12834)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000563c9397f168 in os_event::wait (this=0x563c960fdd20) at /data/src/10.2/storage/innobase/os/os0event.cc:158 #2 0x0000563c9397ec5e in os_event::wait_low (this=0x563c960fdd20, reset_sig_count=162) at /data/src/10.2/storage/innobase/os/os0event.cc:325 #3 0x0000563c9397ef51 in os_event_wait_low (event=0x563c960fdd20, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:507 #4 0x0000563c93a63ef6 in srv_resume_thread (slot=0x563c94806cb0 , sig_count=0, wait=true, timeout_usec=0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:940 #5 0x0000563c93a67935 in srv_worker_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2613 #6 0x00007fab7452c4a4 in start_thread (arg=0x7fab4ffff700) at pthread_create.c:456 #7 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 17 (Thread 0x7fab5cff9700 (LWP 12833)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000563c9397f168 in os_event::wait (this=0x563c960fdca0) at /data/src/10.2/storage/innobase/os/os0event.cc:158 #2 0x0000563c9397ec5e in os_event::wait_low (this=0x563c960fdca0, reset_sig_count=166) at /data/src/10.2/storage/innobase/os/os0event.cc:325 #3 0x0000563c9397ef51 in os_event_wait_low (event=0x563c960fdca0, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:507 #4 0x0000563c93a63ef6 in srv_resume_thread (slot=0x563c94806c78 , sig_count=0, wait=true, timeout_usec=0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:940 #5 0x0000563c93a67935 in srv_worker_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2613 #6 0x00007fab7452c4a4 in start_thread (arg=0x7fab5cff9700) at pthread_create.c:456 #7 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 16 (Thread 0x7fab5d7fa700 (LWP 12832)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000563c9397f168 in os_event::wait (this=0x563c960fdba0) at /data/src/10.2/storage/innobase/os/os0event.cc:158 #2 0x0000563c9397ec5e in os_event::wait_low (this=0x563c960fdba0, reset_sig_count=131) at /data/src/10.2/storage/innobase/os/os0event.cc:325 #3 0x0000563c9397ef51 in os_event_wait_low (event=0x563c960fdba0, reset_sig_count=131) at /data/src/10.2/storage/innobase/os/os0event.cc:507 #4 0x0000563c93a63ef6 in srv_resume_thread (slot=0x563c94806c08 , sig_count=131, wait=true, timeout_usec=0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:940 #5 0x0000563c93a67e00 in srv_purge_coordinator_suspend (slot=0x563c94806c08 , rseg_history_len=0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2774 #6 0x0000563c93a681a5 in srv_purge_coordinator_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2861 #7 0x00007fab7452c4a4 in start_thread (arg=0x7fab5d7fa700) at pthread_create.c:456 #8 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 15 (Thread 0x7fab5dffb700 (LWP 12831)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000563c9397eac8 in os_event::timed_wait (this=0x563c9629c100, abstime=0x7fab5dffac90) at /data/src/10.2/storage/innobase/os/os0event.cc:275 #2 0x0000563c9397ed83 in os_event::wait_time_low (this=0x563c9629c100, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:385 #3 0x0000563c9397ef2c in os_event_wait_time_low (event=0x563c9629c100, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:490 #4 0x0000563c93ace0a5 in ib_wqueue_timedwait (wq=0x563c962839e0, wait_in_usecs=5000000) at /data/src/10.2/storage/innobase/ut/ut0wqueue.cc:156 #5 0x0000563c93bfcf60 in fts_optimize_thread (arg=0x563c962839e0) at /data/src/10.2/storage/innobase/fts/fts0opt.cc:2833 #6 0x00007fab7452c4a4 in start_thread (arg=0x7fab5dffb700) at pthread_create.c:456 #7 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 14 (Thread 0x7fab5e7fc700 (LWP 12830)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000563c9397eac8 in os_event::timed_wait (this=0x563c9624d340, abstime=0x7fab5e7fbeb0) at /data/src/10.2/storage/innobase/os/os0event.cc:275 #2 0x0000563c9397ed83 in os_event::wait_time_low (this=0x563c9624d340, time_in_usec=10000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:385 #3 0x0000563c9397ef2c in os_event_wait_time_low (event=0x563c9624d340, time_in_usec=10000000, reset_sig_count=0) at /data/src/10.2/storage/innobase/os/os0event.cc:490 #4 0x0000563c93ba20ab in dict_stats_thread () at /data/src/10.2/storage/innobase/dict/dict0stats_bg.cc:475 #5 0x00007fab7452c4a4 in start_thread (arg=0x7fab5e7fc700) at pthread_create.c:456 #6 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 13 (Thread 0x7fab5effd700 (LWP 12829)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000563c9397f168 in os_event::wait (this=0x563c96273c80) at /data/src/10.2/storage/innobase/os/os0event.cc:158 #2 0x0000563c9397ec5e in os_event::wait_low (this=0x563c96273c80, reset_sig_count=3) at /data/src/10.2/storage/innobase/os/os0event.cc:325 #3 0x0000563c9397ef51 in os_event_wait_low (event=0x563c96273c80, reset_sig_count=3) at /data/src/10.2/storage/innobase/os/os0event.cc:507 #4 0x0000563c93a745b7 in sync_array_wait_event (arr=0x563c960adce0, cell=@0x7fab5effcd40: 0x7fab6dbb6090) at /data/src/10.2/storage/innobase/sync/sync0arr.cc:471 #5 0x0000563c938e1af5 in TTASEventMutex::enter (this=0x563c96273b70, max_spins=60, max_delay=4, filename=0x563c940f9900 "/data/src/10.2/storage/innobase/dict/dict0dict.cc", line=997) at /data/src/10.2/storage/innobase/include/ib0mutex.h:516 #6 0x0000563c938dfeeb in PolicyMutex >::enter (this=0x563c96273b70, n_spins=30, n_delay=4, name=0x563c940f9900 "/data/src/10.2/storage/innobase/dict/dict0dict.cc", line=997) at /data/src/10.2/storage/innobase/include/ib0mutex.h:637 #7 0x0000563c93b6ed23 in dict_table_open_on_id (table_id=19, dict_locked=0, table_op=DICT_TABLE_OP_OPEN_ONLY_IF_CACHED) at /data/src/10.2/storage/innobase/dict/dict0dict.cc:997 #8 0x0000563c93a015a1 in row_drop_tables_for_mysql_in_background () at /data/src/10.2/storage/innobase/row/row0mysql.cc:2561 #9 0x0000563c93a669ad in srv_master_do_active_tasks () at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2214 #10 0x0000563c93a6752c in srv_master_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2463 #11 0x00007fab7452c4a4 in start_thread (arg=0x7fab5effd700) at pthread_create.c:456 #12 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 12 (Thread 0x7fab5f7fe700 (LWP 12828)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000563c9397eac8 in os_event::timed_wait (this=0x563c960fde20, abstime=0x7fab5f7fde70) at /data/src/10.2/storage/innobase/os/os0event.cc:275 #2 0x0000563c9397ed83 in os_event::wait_time_low (this=0x563c960fde20, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:385 #3 0x0000563c9397ef2c in os_event_wait_time_low (event=0x563c960fde20, time_in_usec=5000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:490 #4 0x0000563c93a65c4f in srv_monitor_thread () at /data/src/10.2/storage/innobase/srv/srv0srv.cc:1749 #5 0x00007fab7452c4a4 in start_thread (arg=0x7fab5f7fe700) at pthread_create.c:456 #6 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 11 (Thread 0x7fab64ff9700 (LWP 12827)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000563c9397eac8 in os_event::timed_wait (this=0x563c960fdda0, abstime=0x7fab64ff8cd0) at /data/src/10.2/storage/innobase/os/os0event.cc:275 #2 0x0000563c9397ed83 in os_event::wait_time_low (this=0x563c960fdda0, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:385 #3 0x0000563c9397ef2c in os_event_wait_time_low (event=0x563c960fdda0, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:490 #4 0x0000563c93a6617b in srv_error_monitor_thread () at /data/src/10.2/storage/innobase/srv/srv0srv.cc:1913 #5 0x00007fab7452c4a4 in start_thread (arg=0x7fab64ff9700) at pthread_create.c:456 #6 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 10 (Thread 0x7fab5ffff700 (LWP 12826)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000563c9397eac8 in os_event::timed_wait (this=0x563c9623b700, abstime=0x7fab5fffee90) at /data/src/10.2/storage/innobase/os/os0event.cc:275 #2 0x0000563c9397ed83 in os_event::wait_time_low (this=0x563c9623b700, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:385 #3 0x0000563c9397ef2c in os_event_wait_time_low (event=0x563c9623b700, time_in_usec=1000000, reset_sig_count=1) at /data/src/10.2/storage/innobase/os/os0event.cc:490 #4 0x0000563c9394ba2c in lock_wait_timeout_thread () at /data/src/10.2/storage/innobase/lock/lock0wait.cc:525 #5 0x00007fab7452c4a4 in start_thread (arg=0x7fab5ffff700) at pthread_create.c:456 #6 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 9 (Thread 0x7fab657fa700 (LWP 12824)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000563c9397eac8 in os_event::timed_wait (this=0x563c960fdf20, abstime=0x7fab657f9c20) at /data/src/10.2/storage/innobase/os/os0event.cc:275 #2 0x0000563c9397ed83 in os_event::wait_time_low (this=0x563c960fdf20, time_in_usec=778000, reset_sig_count=2) at /data/src/10.2/storage/innobase/os/os0event.cc:385 #3 0x0000563c9397ef2c in os_event_wait_time_low (event=0x563c960fdf20, time_in_usec=778000, reset_sig_count=2) at /data/src/10.2/storage/innobase/os/os0event.cc:490 #4 0x0000563c93b48e46 in pc_sleep_if_needed (next_loop_time=2637527772, sig_count=2, cur_time=2637526994) at /data/src/10.2/storage/innobase/buf/buf0flu.cc:2707 #5 0x0000563c93b49cea in buf_flush_page_cleaner_coordinator () at /data/src/10.2/storage/innobase/buf/buf0flu.cc:3173 #6 0x00007fab7452c4a4 in start_thread (arg=0x7fab657fa700) at pthread_create.c:456 #7 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 8 (Thread 0x7fab65ffb700 (LWP 12823)): #0 0x00007fab7411b6ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000563c93971b09 in LinuxAIOHandler::collect (this=0x7fab65ffac20) at /data/src/10.2/storage/innobase/os/os0file.cc:1936 #2 0x0000563c9397212a in LinuxAIOHandler::poll (this=0x7fab65ffac20, m1=0x7fab65ffacc8, m2=0x7fab65ffacd0, request=0x7fab65ffad00) at /data/src/10.2/storage/innobase/os/os0file.cc:2097 #3 0x0000563c939722a4 in os_aio_linux_handler (global_segment=5, m1=0x7fab65ffacc8, m2=0x7fab65ffacd0, request=0x7fab65ffad00) at /data/src/10.2/storage/innobase/os/os0file.cc:2151 #4 0x0000563c939770d9 in os_aio_handler (segment=5, m1=0x7fab65ffacc8, m2=0x7fab65ffacd0, request=0x7fab65ffad00) at /data/src/10.2/storage/innobase/os/os0file.cc:5781 #5 0x0000563c93bb93be in fil_aio_wait (segment=5) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5119 #6 0x0000563c93a6a9b8 in io_handler_thread (arg=0x563c94a3e2a8 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:332 #7 0x00007fab7452c4a4 in start_thread (arg=0x7fab65ffb700) at pthread_create.c:456 #8 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 7 (Thread 0x7fab667fc700 (LWP 12822)): #0 0x00007fab7411b6ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000563c93971b09 in LinuxAIOHandler::collect (this=0x7fab667fbc20) at /data/src/10.2/storage/innobase/os/os0file.cc:1936 #2 0x0000563c9397212a in LinuxAIOHandler::poll (this=0x7fab667fbc20, m1=0x7fab667fbcc8, m2=0x7fab667fbcd0, request=0x7fab667fbd00) at /data/src/10.2/storage/innobase/os/os0file.cc:2097 #3 0x0000563c939722a4 in os_aio_linux_handler (global_segment=4, m1=0x7fab667fbcc8, m2=0x7fab667fbcd0, request=0x7fab667fbd00) at /data/src/10.2/storage/innobase/os/os0file.cc:2151 #4 0x0000563c939770d9 in os_aio_handler (segment=4, m1=0x7fab667fbcc8, m2=0x7fab667fbcd0, request=0x7fab667fbd00) at /data/src/10.2/storage/innobase/os/os0file.cc:5781 #5 0x0000563c93bb93be in fil_aio_wait (segment=4) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5119 #6 0x0000563c93a6a9b8 in io_handler_thread (arg=0x563c94a3e2a0 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:332 #7 0x00007fab7452c4a4 in start_thread (arg=0x7fab667fc700) at pthread_create.c:456 #8 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 6 (Thread 0x7fab66ffd700 (LWP 12821)): #0 0x00007fab7411b6ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000563c93971b09 in LinuxAIOHandler::collect (this=0x7fab66ffcc20) at /data/src/10.2/storage/innobase/os/os0file.cc:1936 #2 0x0000563c9397212a in LinuxAIOHandler::poll (this=0x7fab66ffcc20, m1=0x7fab66ffccc8, m2=0x7fab66ffccd0, request=0x7fab66ffcd00) at /data/src/10.2/storage/innobase/os/os0file.cc:2097 #3 0x0000563c939722a4 in os_aio_linux_handler (global_segment=3, m1=0x7fab66ffccc8, m2=0x7fab66ffccd0, request=0x7fab66ffcd00) at /data/src/10.2/storage/innobase/os/os0file.cc:2151 #4 0x0000563c939770d9 in os_aio_handler (segment=3, m1=0x7fab66ffccc8, m2=0x7fab66ffccd0, request=0x7fab66ffcd00) at /data/src/10.2/storage/innobase/os/os0file.cc:5781 #5 0x0000563c93bb93be in fil_aio_wait (segment=3) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5119 #6 0x0000563c93a6a9b8 in io_handler_thread (arg=0x563c94a3e298 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:332 #7 0x00007fab7452c4a4 in start_thread (arg=0x7fab66ffd700) at pthread_create.c:456 #8 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 5 (Thread 0x7fab677fe700 (LWP 12820)): #0 0x00007fab7411b6ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000563c93971b09 in LinuxAIOHandler::collect (this=0x7fab677fdc20) at /data/src/10.2/storage/innobase/os/os0file.cc:1936 #2 0x0000563c9397212a in LinuxAIOHandler::poll (this=0x7fab677fdc20, m1=0x7fab677fdcc8, m2=0x7fab677fdcd0, request=0x7fab677fdd00) at /data/src/10.2/storage/innobase/os/os0file.cc:2097 #3 0x0000563c939722a4 in os_aio_linux_handler (global_segment=2, m1=0x7fab677fdcc8, m2=0x7fab677fdcd0, request=0x7fab677fdd00) at /data/src/10.2/storage/innobase/os/os0file.cc:2151 #4 0x0000563c939770d9 in os_aio_handler (segment=2, m1=0x7fab677fdcc8, m2=0x7fab677fdcd0, request=0x7fab677fdd00) at /data/src/10.2/storage/innobase/os/os0file.cc:5781 #5 0x0000563c93bb93be in fil_aio_wait (segment=2) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5119 #6 0x0000563c93a6a9b8 in io_handler_thread (arg=0x563c94a3e290 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:332 #7 0x00007fab7452c4a4 in start_thread (arg=0x7fab677fe700) at pthread_create.c:456 #8 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 4 (Thread 0x7fab67fff700 (LWP 12819)): #0 0x00007fab7411b6ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000563c93971b09 in LinuxAIOHandler::collect (this=0x7fab67ffec20) at /data/src/10.2/storage/innobase/os/os0file.cc:1936 #2 0x0000563c9397212a in LinuxAIOHandler::poll (this=0x7fab67ffec20, m1=0x7fab67ffecc8, m2=0x7fab67ffecd0, request=0x7fab67ffed00) at /data/src/10.2/storage/innobase/os/os0file.cc:2097 #3 0x0000563c939722a4 in os_aio_linux_handler (global_segment=1, m1=0x7fab67ffecc8, m2=0x7fab67ffecd0, request=0x7fab67ffed00) at /data/src/10.2/storage/innobase/os/os0file.cc:2151 #4 0x0000563c939770d9 in os_aio_handler (segment=1, m1=0x7fab67ffecc8, m2=0x7fab67ffecd0, request=0x7fab67ffed00) at /data/src/10.2/storage/innobase/os/os0file.cc:5781 #5 0x0000563c93bb93be in fil_aio_wait (segment=1) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5119 #6 0x0000563c93a6a9b8 in io_handler_thread (arg=0x563c94a3e288 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:332 #7 0x00007fab7452c4a4 in start_thread (arg=0x7fab67fff700) at pthread_create.c:456 #8 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 3 (Thread 0x7fab6ca64700 (LWP 12818)): #0 0x00007fab7411b6ca in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000563c93971b09 in LinuxAIOHandler::collect (this=0x7fab6ca63c20) at /data/src/10.2/storage/innobase/os/os0file.cc:1936 #2 0x0000563c9397212a in LinuxAIOHandler::poll (this=0x7fab6ca63c20, m1=0x7fab6ca63cc8, m2=0x7fab6ca63cd0, request=0x7fab6ca63d00) at /data/src/10.2/storage/innobase/os/os0file.cc:2097 #3 0x0000563c939722a4 in os_aio_linux_handler (global_segment=0, m1=0x7fab6ca63cc8, m2=0x7fab6ca63cd0, request=0x7fab6ca63d00) at /data/src/10.2/storage/innobase/os/os0file.cc:2151 #4 0x0000563c939770d9 in os_aio_handler (segment=0, m1=0x7fab6ca63cc8, m2=0x7fab6ca63cd0, request=0x7fab6ca63d00) at /data/src/10.2/storage/innobase/os/os0file.cc:5781 #5 0x0000563c93bb93be in fil_aio_wait (segment=0) at /data/src/10.2/storage/innobase/fil/fil0fil.cc:5119 #6 0x0000563c93a6a9b8 in io_handler_thread (arg=0x563c94a3e280 ) at /data/src/10.2/storage/innobase/srv/srv0start.cc:332 #7 0x00007fab7452c4a4 in start_thread (arg=0x7fab6ca64700) at pthread_create.c:456 #8 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 2 (Thread 0x7fab6e4d9700 (LWP 12817)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000563c93e0e1c4 in safe_cond_timedwait (cond=0x563c952601e0 , mp=0x563c95260120 , abstime=0x7fab6e4d8eb0, file=0x563c941935b0 "/data/src/10.2/include/mysql/psi/mysql_thread.h", line=1182) at /data/src/10.2/mysys/thr_mutex.c:545 #2 0x0000563c93e0f139 in inline_mysql_cond_timedwait (that=0x563c952601e0 , mutex=0x563c95260120 , abstime=0x7fab6e4d8eb0, src_file=0x563c941935e0 "/data/src/10.2/mysys/thr_timer.c", src_line=292) at /data/src/10.2/include/mysql/psi/mysql_thread.h:1182 #3 0x0000563c93e0fc46 in timer_handler (arg=0x0) at /data/src/10.2/mysys/thr_timer.c:292 #4 0x0000563c93dabc64 in pfs_spawn_thread (arg=0x563c96089890) at /data/src/10.2/storage/perfschema/pfs.cc:1869 #5 0x00007fab7452c4a4 in start_thread (arg=0x7fab6e4d9700) at pthread_create.c:456 #6 0x00007fab72660d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97 Thread 1 (Thread 0x7fab74942ec0 (LWP 12816)): #0 0x00007fab726578bd in poll () at ../sysdeps/unix/syscall-template.S:84 #1 0x0000563c93359b50 in handle_connections_sockets () at /data/src/10.2/sql/mysqld.cc:6667 #2 0x0000563c93358e32 in mysqld_main (argc=144, argv=0x563c95f6a2f0) at /data/src/10.2/sql/mysqld.cc:6133 #3 0x0000563c9334d6d0 in main (argc=22, argv=0x7ffee2f25ec8) at /data/src/10.2/sql/main.cc:25