(gdb) thread apply all backtrace Thread 20 (Thread 0x7f6c9ec87710 (LWP 12660)): #0 0x0000003281800614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000b5e3de in os_aio_linux_collect (array=0x3516210, segment=0, seg_size=256) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:4918 #2 0x0000000000b5e780 in os_aio_linux_handle (global_seg=0, message1=0x7f6c9ec86e40, message2=0x7f6c9ec86e38, type=0x7f6c9ec86e30) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:5062 #3 0x0000000000d02f14 in fil_aio_wait (segment=0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/fil/fil0fil.cc:5568 #4 0x0000000000c1d12d in io_handler_thread (arg=0x17cb8a0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0start.cc:480 #5 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7f6c954c1710 (LWP 12661)): #0 0x0000003281800614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000b5e3de in os_aio_linux_collect (array=0x3508f50, segment=0, seg_size=256) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:4918 #2 0x0000000000b5e780 in os_aio_linux_handle (global_seg=1, message1=0x7f6c954c0e40, message2=0x7f6c954c0e38, type=0x7f6c954c0e30) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:5062 #3 0x0000000000d02f14 in fil_aio_wait (segment=1) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/fil/fil0fil.cc:5568 #4 0x0000000000c1d12d in io_handler_thread (arg=0x17cb8a8) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0start.cc:480 #5 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7f6c94cc0710 (LWP 12662)): #0 0x0000003281800614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000b5e3de in os_aio_linux_collect (array=0x34c0c30, segment=0, seg_size=256) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:4918 #2 0x0000000000b5e780 in os_aio_linux_handle (global_seg=2, message1=0x7f6c94cbfe40, message2=0x7f6c94cbfe38, type=0x7f6c94cbfe30) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:5062 #3 0x0000000000d02f14 in fil_aio_wait (segment=2) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/fil/fil0fil.cc:5568 #4 0x0000000000c1d12d in io_handler_thread (arg=0x17cb8b0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0start.cc:480 #5 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7f6c944bf710 (LWP 12663)): #0 0x0000003281800614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000b5e3de in os_aio_linux_collect (array=0x34c0c30, segment=1, seg_size=256) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:4918 #2 0x0000000000b5e780 in os_aio_linux_handle (global_seg=3, message1=0x7f6c944bee40, message2=0x7f6c944bee38, type=0x7f6c944bee30) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:5062 #3 0x0000000000d02f14 in fil_aio_wait (segment=3) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/fil/fil0fil.cc:5568 #4 0x0000000000c1d12d in io_handler_thread (arg=0x17cb8b8) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0start.cc:480 #5 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7f6c93cbe710 (LWP 12664)): #0 0x0000003281800614 in ?? () from /lib64/libaio.so.1 ---Type to continue, or q to quit--- #1 0x0000000000b5e3de in os_aio_linux_collect (array=0x35234d0, segment=0, seg_size=256) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:4918 #2 0x0000000000b5e780 in os_aio_linux_handle (global_seg=4, message1=0x7f6c93cbde40, message2=0x7f6c93cbde38, type=0x7f6c93cbde30) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:5062 #3 0x0000000000d02f14 in fil_aio_wait (segment=4) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/fil/fil0fil.cc:5568 #4 0x0000000000c1d12d in io_handler_thread (arg=0x17cb8c0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0start.cc:480 #5 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7f6c934bd710 (LWP 12665)): #0 0x0000003281800614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000b5e3de in os_aio_linux_collect (array=0x35234d0, segment=1, seg_size=256) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:4918 #2 0x0000000000b5e780 in os_aio_linux_handle (global_seg=5, message1=0x7f6c934bce40, message2=0x7f6c934bce38, type=0x7f6c934bce30) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0file.cc:5062 #3 0x0000000000d02f14 in fil_aio_wait (segment=5) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/fil/fil0fil.cc:5568 #4 0x0000000000c1d12d in io_handler_thread (arg=0x17cb8c8) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0start.cc:480 #5 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7f6c92893710 (LWP 12667)): #0 0x000000328280b7a9 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b606b3 in os_cond_wait_timed (cond=0x35e0010, fast_mutex=0x35dffd0, abstime=0x7f6c92892e30) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:177 #2 0x0000000000b60ed4 in os_event_wait_time_low (event=0x35dffd0, time_in_usec=1000000, reset_sig_count=1) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:723 #3 0x0000000000b41cb4 in lock_wait_timeout_thread (arg=0x0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/lock/lock0wait.cc:503 #4 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7f6c92092710 (LWP 12668)): #0 0x000000328280b7a9 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b606b3 in os_cond_wait_timed (cond=0x34cbd80, fast_mutex=0x34cbd40, abstime=0x7f6c92091df0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:177 #2 0x0000000000b60ed4 in os_event_wait_time_low (event=0x34cbd40, time_in_usec=1000000, reset_sig_count=1) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:723 #3 0x0000000000c18df1 in srv_error_monitor_thread (arg=0x0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0srv.cc:1763 #4 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7f6c91891710 (LWP 12669)): #0 0x000000328280b7a9 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b606b3 in os_cond_wait_timed (cond=0x34cbe10, fast_mutex=0x34cbdd0, abstime=0x7f6c91890de0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:177 #2 0x0000000000b60ed4 in os_event_wait_time_low (event=0x34cbdd0, time_in_usec=5000000, reset_sig_count=1) ---Type to continue, or q to quit--- at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:723 #3 0x0000000000c18849 in srv_monitor_thread (arg=0x0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0srv.cc:1532 #4 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7f6c91090710 (LWP 12670)): #0 0x0000003281cda093 in select () from /lib64/libc.so.6 #1 0x0000000000b61a13 in os_thread_sleep (tm=1000000) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0thread.cc:258 #2 0x0000000000c19baf in srv_master_sleep () at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0srv.cc:2294 #3 0x0000000000c19cc2 in srv_master_thread (arg=0x0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0srv.cc:2338 #4 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7f6c9088f710 (LWP 12671)): #0 0x000000328280b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b607a9 in os_cond_wait (cond=0x34cbcf0, fast_mutex=0x34cbcb0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:214 #2 0x0000000000b60cf7 in os_event_wait_low (event=0x34cbcb0, reset_sig_count=2) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:610 #3 0x0000000000c1a50f in srv_purge_coordinator_suspend (slot=0x34cbac0, rseg_history_len=9) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0srv.cc:2631 #4 0x0000000000c1a9c0 in srv_purge_coordinator_thread (arg=0x0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/srv/srv0srv.cc:2748 #5 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7f6c83fff710 (LWP 12672)): #0 0x0000003281cda093 in select () from /lib64/libc.so.6 #1 0x0000000000b61a13 in os_thread_sleep (tm=1000000) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0thread.cc:258 #2 0x0000000000cb048b in page_cleaner_sleep_if_needed (next_loop_time=1390314222806) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/buf/buf0flu.cc:2379 #3 0x0000000000cb0573 in buf_flush_page_cleaner_thread (arg=0x0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/buf/buf0flu.cc:2420 #4 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7f6c837fe710 (LWP 12673)): #0 0x000000328280b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b607a9 in os_cond_wait (cond=0x34cbea0, fast_mutex=0x34cbe60) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:214 #2 0x0000000000b60cf7 in os_event_wait_low (event=0x34cbe60, reset_sig_count=1) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:610 #3 0x0000000000ca96a7 in buf_dump_thread (arg=0x0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/buf/buf0dump.cc:594 #4 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7f6c82ffd710 (LWP 12674)): #0 0x000000328280b7a9 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b606b3 in os_cond_wait_timed (cond=0x35e9ad0, fast_mutex=0x35e9a90, abstime=0x7f6c82ffce50) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:177 ---Type to continue, or q to quit--- #2 0x0000000000b60ed4 in os_event_wait_time_low (event=0x35e9a90, time_in_usec=10000000, reset_sig_count=1) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:723 #3 0x0000000000cf22dd in dict_stats_thread (arg=0x0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/dict/dict0stats_bg.cc:349 #4 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7f6c827fc710 (LWP 12675)): #0 0x000000328280b7a9 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b606b3 in os_cond_wait_timed (cond=0x360bb50, fast_mutex=0x360bb10, abstime=0x7f6c827fbda0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:177 #2 0x0000000000b60ed4 in os_event_wait_time_low (event=0x360bb10, time_in_usec=5000000, reset_sig_count=1) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/os/os0sync.cc:723 #3 0x0000000000c5a408 in ib_wqueue_timedwait (wq=0x3609608, wait_in_usecs=5000000) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/ut/ut0wqueue.cc:154 #4 0x0000000000d2cdb4 in fts_optimize_thread (arg=0x3609608) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/innobase/fts/fts0opt.cc:2994 #5 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7f6c9c360710 (LWP 12676)): #0 0x000000328280f265 in sigwait () from /lib64/libpthread.so.0 #1 0x0000000000609862 in signal_hand (arg=0x0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/mysqld.cc:3179 #2 0x0000000000ad0349 in pfs_spawn_thread (arg=0x3605e40) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/perfschema/pfs.cc:1858 #3 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #4 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7f6c9c31f710 (LWP 12680)): #0 0x000000328280b7a9 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6ad4f in inline_mysql_cond_timedwait (that=0x7f6c780008c8, mutex=0x7f6c6c00cd48, abstime=0x7f6c9c31c280, src_file=0x1025fc0 "/home/ushastry/mybuilds/mysql-5.6.15-release/mysys/thr_lock.c", src_line=462) at /home/ushastry/mybuilds/mysql-5.6.15-release/include/mysql/psi/mysql_thread.h:1188 #2 0x0000000000a6b393 in wait_for_lock (wait=0x7f6c6c00cd98, data=0x7f6c7804e598, in_wait_list=0 '\000', lock_wait_timeout=31536000) at /home/ushastry/mybuilds/mysql-5.6.15-release/mysys/thr_lock.c:462 #3 0x0000000000a6bc10 in thr_lock (data=0x7f6c7804e598, owner=0x36bf520, lock_type=TL_WRITE, lock_wait_timeout=31536000) at /home/ushastry/mybuilds/mysql-5.6.15-release/mysys/thr_lock.c:787 #4 0x0000000000a6c4b0 in thr_multi_lock (data=0x7f6c78052e90, count=1, owner=0x36bf520, lock_wait_timeout=31536000) at /home/ushastry/mybuilds/mysql-5.6.15-release/mysys/thr_lock.c:1060 #5 0x0000000000910e2b in mysql_lock_tables (thd=0x36be6a0, tables=0x7f6c78006130, count=1, flags=0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/lock.cc:321 #6 0x000000000074c562 in lock_tables (thd=0x36be6a0, tables=0x7f6c780050a8, count=1, flags=0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_base.cc:5865 #7 0x000000000074bd37 in open_and_lock_tables (thd=0x36be6a0, tables=0x7f6c780050a8, derived=false, flags=0, prelocking_strategy=0x7f6c9c31c640) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_base.cc:5629 #8 0x000000000074b73c in open_n_lock_single_table (thd=0x36be6a0, table_l=0x7f6c780050a8, lock_type=TL_WRITE, flags=0, prelocking_strategy=0x7f6c9c31c640) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_base.cc:5468 #9 0x00000000008361e0 in open_n_lock_single_table (thd=0x36be6a0, table_l=0x7f6c780050a8, lock_type=TL_WRITE, flags=0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_base.h:462 ---Type to continue, or q to quit--- #10 0x000000000095b4fe in mysql_admin_table (thd=0x36be6a0, tables=0x7f6c780050a8, check_opt=0x36c15b8, operator_name=0xfe3278 "optimize", lock_type=TL_WRITE, open_for_modify=false, repair_table_use_frm=false, extra_open_options=0, prepare_func=0, operator_func= (int (handler::*)(handler *, THD *, HA_CHECK_OPT *)) 0x626148 , view_operator_func=0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_admin.cc:805 #11 0x000000000095c485 in Sql_cmd_optimize_table::execute (this=0x7f6c78005610, thd=0x36be6a0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_admin.cc:1110 #12 0x00000000007b6bfa in mysql_execute_command (thd=0x36be6a0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_parse.cc:4936 #13 0x00000000007b9c29 in mysql_parse (thd=0x36be6a0, rawbuf=0x7f6c78004fd0 "OPTIMIZE TABLE t1", length=17, parser_state=0x7f6c9c31e680) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_parse.cc:6235 #14 0x00000000007ad2f5 in dispatch_command (command=COM_QUERY, thd=0x36be6a0, packet=0x378e4d1 "", packet_length=17) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_parse.cc:1334 #15 0x00000000007ac47a in do_command (thd=0x36be6a0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_parse.cc:1036 #16 0x00000000007762c9 in do_handle_one_connection (thd_arg=0x36be6a0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_connect.cc:982 #17 0x0000000000775df2 in handle_one_connection (arg=0x36be6a0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_connect.cc:898 #18 0x0000000000ad0349 in pfs_spawn_thread (arg=0x360ca10) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/perfschema/pfs.cc:1858 #19 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #20 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7f6c9c2de710 (LWP 12684)): #0 0x000000328280b7a9 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006f4770 in inline_mysql_cond_timedwait (that=0x37925f8, mutex=0x37925c8, abstime=0x7f6c9c2d9ba0, src_file=0xf09f88 "/home/ushastry/mybuilds/mysql-5.6.15-release/sql/mdl.cc", src_line=1327) at /home/ushastry/mybuilds/mysql-5.6.15-release/include/mysql/psi/mysql_thread.h:1188 #2 0x00000000006f55b0 in MDL_wait::timed_wait (this=0x37925c8, owner=0x37924e0, abs_timeout=0x7f6c9c2d9ba0, set_status_on_timeout=false, wait_state_name=0x1498d30) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/mdl.cc:1327 #3 0x00000000006f6934 in MDL_context::acquire_lock (this=0x37925c8, mdl_request=0x7f6c9c2d9c60, lock_wait_timeout=31536000) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/mdl.cc:2246 #4 0x00000000006f6fc8 in MDL_context::upgrade_shared_lock (this=0x37925c8, mdl_ticket=0x7f6c6c0081f0, new_type=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/mdl.cc:2428 #5 0x0000000000746206 in wait_while_table_is_used (thd=0x37924e0, table=0x7f6c6c00a540, function=HA_EXTRA_PREPARE_FOR_RENAME) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_base.cc:2200 #6 0x000000000081d424 in mysql_inplace_alter_table (thd=0x37924e0, table_list=0x7f6c6c004d58, table=0x7f6c6c00a540, altered_table=0x7f6c6c037dd0, ha_alter_info=0x7f6c9c2daad0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f6c9c2db430, alter_ctx=0x7f6c9c2da020) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_table.cc:6515 #7 0x000000000082128d in mysql_alter_table (thd=0x37924e0, new_db=0x7f6c6c0052b8 "test", new_name=0x0, create_info=0x7f6c9c2dbea0, table_list=0x7f6c6c004d58, alter_info=0x7f6c9c2dbf80, order_num=0, order=0x0, ignore=false) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_table.cc:8200 #8 0x000000000095d7cd in Sql_cmd_alter_table::execute (this=0x7f6c6c005390, thd=0x37924e0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_alter.cc:313 #9 0x00000000007b6bfa in mysql_execute_command (thd=0x37924e0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_parse.cc:4936 #10 0x00000000007b9c29 in mysql_parse (thd=0x37924e0, rawbuf=0x7f6c6c004c30 "ALTER TABLE t1 ADD INDEX b(b), ALGORITHM=INPLACE, LOCK=NONE", length=59, parser_state=0x7f6c9c2dd680) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_parse.cc:6235 #11 0x00000000007ad2f5 in dispatch_command (command=COM_QUERY, thd=0x37924e0, packet=0x37961e1 "ALTER TABLE t1 ADD INDEX b(b), ALGORITHM=INPLACE, LOCK=NONE", packet_length=59) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_parse.cc:1334 #12 0x00000000007ac47a in do_command (thd=0x37924e0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_parse.cc:1036 #13 0x00000000007762c9 in do_handle_one_connection (thd_arg=0x37924e0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_connect.cc:982 ---Type to continue, or q to quit--- #14 0x0000000000775df2 in handle_one_connection (arg=0x37924e0) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_connect.cc:898 #15 0x0000000000ad0349 in pfs_spawn_thread (arg=0x360d600) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/perfschema/pfs.cc:1858 #16 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #17 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7f6c9c29d710 (LWP 12685)): #0 0x000000328280b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000060393f in inline_mysql_cond_wait (that=0x1790500, mutex=0x178dfe0, src_file=0xe6d408 "/home/ushastry/mybuilds/mysql-5.6.15-release/sql/mysqld.cc", src_line=2662) at /home/ushastry/mybuilds/mysql-5.6.15-release/include/mysql/psi/mysql_thread.h:1151 #2 0x0000000000608af7 in block_until_new_connection () at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/mysqld.cc:2662 #3 0x0000000000608de9 in one_thread_per_connection_end (thd=0x379a320, block_pthread=true) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/mysqld.cc:2763 #4 0x0000000000776332 in do_handle_one_connection (thd_arg=0x379a320) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_connect.cc:989 #5 0x0000000000775df2 in handle_one_connection (arg=0x379a320) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/sql_connect.cc:898 #6 0x0000000000ad0349 in pfs_spawn_thread (arg=0x3734ba0) at /home/ushastry/mybuilds/mysql-5.6.15-release/storage/perfschema/pfs.cc:1858 #7 0x00000032828077e1 in start_thread () from /lib64/libpthread.so.0 #8 0x0000003281ce153d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7f6c9ec89720 (LWP 12658)): #0 0x0000003281cd7e33 in poll () from /lib64/libc.so.6 #1 0x000000000060e153 in handle_connections_sockets () at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/mysqld.cc:6232 #2 0x000000000060d512 in mysqld_main (argc=77, argv=0x33c0748) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/mysqld.cc:5651 #3 0x00000000006033d4 in main (argc=7, argv=0x7fffea277858) at /home/ushastry/mybuilds/mysql-5.6.15-release/sql/main.cc:25 (gdb)