// Setup master-slave replication // On master master [localhost] {msandbox} (test) > drop table keyvalue; ERROR 1051 (42S02): Unknown table 'test.keyvalue' master [localhost] {msandbox} (test) > CREATE TABLE `test`.`keyvalue` ( -> `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, -> `name` varchar(40), -> PRIMARY KEY (`id`) -> ) ENGINE=Innodb; Query OK, 0 rows affected (0.44 sec) master [localhost] {msandbox} (test) > master [localhost] {msandbox} (test) > set @id:=0; Query OK, 0 rows affected (0.00 sec) master [localhost] {msandbox} (test) > insert into `keyvalue` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)); Query OK, 4 rows affected, 1 warning (0.04 sec) Records: 4 Duplicates: 0 Warnings: 1 master [localhost] {msandbox} (test) > insert into `keyvalue`(`id`,`name`) -> select @id:=@id+1,md5(rand()*1000000) from -> `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9, -> `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit -> 1000000; Query OK, 1000000 rows affected, 3 warnings (29.84 sec) Records: 1000000 Duplicates: 0 Warnings: 3 // session 1 - slave 1 (don't wait for above inserts to complete) slave1 [localhost] {msandbox} (test) > flush tables with read lock; Query OK, 0 rows affected (0.00 sec) ... .. sleep for >5 minutes.. slave1 [localhost] {msandbox} (test) > unlock tables; Query OK, 0 rows affected (0.00 sec) // master Repeat similar steps once agaain on master... master [localhost] {msandbox} (test) > drop table keyvalue; ERROR 1051 (42S02): Unknown table 'test.keyvalue' master [localhost] {msandbox} (test) > CREATE TABLE `test`.`keyvalue` ( -> `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, -> `name` varchar(40), -> PRIMARY KEY (`id`) -> ) ENGINE=Innodb; Query OK, 0 rows affected (0.44 sec) master [localhost] {msandbox} (test) > master [localhost] {msandbox} (test) > set @id:=0; Query OK, 0 rows affected (0.00 sec) master [localhost] {msandbox} (test) > insert into `keyvalue` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)); Query OK, 4 rows affected, 1 warning (0.04 sec) Records: 4 Duplicates: 0 Warnings: 1 master [localhost] {msandbox} (test) > insert into `keyvalue`(`id`,`name`) -> select @id:=@id+1,md5(rand()*1000000) from -> `keyvalue` k1, `keyvalue` k2, `keyvalue` k3, `keyvalue` k4,`keyvalue` k5,`keyvalue` k6, `keyvalue` k7, `keyvalue` k8, `keyvalue` k9, -> `keyvalue` k0,`keyvalue` ka, `keyvalue` kb, `keyvalue` kc, `keyvalue` kd limit -> 1000000; Query OK, 1000000 rows affected, 3 warnings (29.84 sec) Records: 1000000 Duplicates: 0 Warnings: 3 // Session 1 - slave1 (don't wait for above inserts to complete) slave1 [localhost] {msandbox} ((none)) > show processlist; +----+-------------+-----------+------+---------+------+----------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------+------------------------------------------------------------------------------------------------------+ | 62 | msandbox | localhost | NULL | Sleep | 257 | | NULL | | 66 | msandbox | localhost | NULL | Sleep | 2246 | | NULL | | 70 | msandbox | localhost | NULL | Query | 0 | init | show processlist | | 71 | system user | | NULL | Connect | 354 | Waiting for master to send event | NULL | | 72 | system user | | test | Connect | 38 | Sending data | insert into `keyvalue`(`id`,`name`) select @id:=@id+1,md5(rand()*1000000) from `keyvalue` k1, | +----+-------------+-----------+------+---------+------+----------------------------------+------------------------------------------------------------------------------------------------------+ 5 rows in set (0.00 sec) ^^ Confirm that "insert into... in progress) and run flush tables with read lock and observe "Waiting for commit lock" slave1 [localhost] {msandbox} ((none)) > flush tables with read lock; Query OK, 0 rows affected (57.32 sec) slave1 [localhost] {msandbox} ((none)) > show processlist; +----+-------------+-----------+------+---------+------+----------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-------------+-----------+------+---------+------+----------------------------------+------------------+ | 70 | msandbox | localhost | NULL | Query | 0 | init | show processlist | | 71 | system user | | NULL | Connect | 425 | Waiting for master to send event | NULL | | 72 | system user | | NULL | Connect | 109 | Waiting for commit lock | NULL | +----+-------------+-----------+------+---------+------+----------------------------------+------------------+ 3 rows in set (0.00 sec) slave1 [localhost] {msandbox} ((none)) > show slave status\G ^^ When state is in "Waiting for commit lock"...try to see "show slave status\G" slave1 [localhost] {msandbox} (test) > show slave status\G ^^ Hangs // session 2 - slave 1 slave1 [localhost] {msandbox} ((none)) > show slave status\G ^^ Hangs // session 3 - slave 1 slave1 [localhost] {msandbox} ((none)) > show slave status\G ^^ Hangs // session 4 - slave 1 slave1 [localhost] {msandbox} ((none)) > show slave status\G ^^ Hangs /////////////////////// gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p 19001 > /tmp/st.log [New LWP 20766] [New LWP 20765] [New LWP 20463] [New LWP 20445] [New LWP 20444] [New LWP 19917] [New LWP 19916] [New LWP 19551] [New LWP 19537] [New LWP 19438] [New LWP 19283] [New LWP 19027] [New LWP 19026] [New LWP 19025] [New LWP 19024] [New LWP 19023] [New LWP 19022] [New LWP 19021] [New LWP 19020] [New LWP 19019] [New LWP 19018] [New LWP 19013] [New LWP 19012] [New LWP 19011] [New LWP 19010] [New LWP 19009] [New LWP 19008] [New LWP 19007] [New LWP 19006] [New LWP 19005] [New LWP 19004] [Thread debugging using libthread_db enabled] 0x0000003b24edea63 in poll () from /lib64/libc.so.6 Thread 32 (Thread 0x7fbd24d57700 (LWP 19004)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=0, message1=0x7fbd24d56e58, message2=0x7fbd24d56e50, type=0x7fbd24d56e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=0, message1=0x7fbd24d56e58, message2=0x7fbd24d56e50, type=0x7fbd24d56e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 31 (Thread 0x7fbcfd8c9700 (LWP 19005)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=1, message1=0x7fbcfd8c8e58, message2=0x7fbcfd8c8e50, type=0x7fbcfd8c8e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=1, message1=0x7fbcfd8c8e58, message2=0x7fbcfd8c8e50, type=0x7fbcfd8c8e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 30 (Thread 0x7fbcfd0c8700 (LWP 19006)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=2, message1=0x7fbcfd0c7e58, message2=0x7fbcfd0c7e50, type=0x7fbcfd0c7e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=2, message1=0x7fbcfd0c7e58, message2=0x7fbcfd0c7e50, type=0x7fbcfd0c7e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 29 (Thread 0x7fbcfc8c7700 (LWP 19007)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=3, message1=0x7fbcfc8c6e58, message2=0x7fbcfc8c6e50, type=0x7fbcfc8c6e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=3, message1=0x7fbcfc8c6e58, message2=0x7fbcfc8c6e50, type=0x7fbcfc8c6e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 28 (Thread 0x7fbcfc0c6700 (LWP 19008)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=4, message1=0x7fbcfc0c5e58, message2=0x7fbcfc0c5e50, type=0x7fbcfc0c5e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=4, message1=0x7fbcfc0c5e58, message2=0x7fbcfc0c5e50, type=0x7fbcfc0c5e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 27 (Thread 0x7fbcfb8c5700 (LWP 19009)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=5, message1=0x7fbcfb8c4e58, message2=0x7fbcfb8c4e50, type=0x7fbcfb8c4e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=5, message1=0x7fbcfb8c4e58, message2=0x7fbcfb8c4e50, type=0x7fbcfb8c4e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 26 (Thread 0x7fbcfb0c4700 (LWP 19010)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=6, message1=0x7fbcfb0c3e58, message2=0x7fbcfb0c3e50, type=0x7fbcfb0c3e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=6, message1=0x7fbcfb0c3e58, message2=0x7fbcfb0c3e50, type=0x7fbcfb0c3e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=6) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7fbcfa8c3700 (LWP 19011)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=7, message1=0x7fbcfa8c2e58, message2=0x7fbcfa8c2e50, type=0x7fbcfa8c2e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=7, message1=0x7fbcfa8c2e58, message2=0x7fbcfa8c2e50, type=0x7fbcfa8c2e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=7) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7fbcfa0c2700 (LWP 19012)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=8, message1=0x7fbcfa0c1e58, message2=0x7fbcfa0c1e50, type=0x7fbcfa0c1e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=8, message1=0x7fbcfa0c1e58, message2=0x7fbcfa0c1e50, type=0x7fbcfa0c1e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=8) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7fbcf98c1700 (LWP 19013)): #0 0x0000003a9e800614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095c3bf in os_aio_linux_collect (global_seg=9, message1=0x7fbcf98c0e58, message2=0x7fbcf98c0e50, type=0x7fbcf98c0e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:4915 #2 os_aio_linux_handle (global_seg=9, message1=0x7fbcf98c0e58, message2=0x7fbcf98c0e50, type=0x7fbcf98c0e48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0file.cc:5059 #3 0x0000000000a60cce in fil_aio_wait (segment=9) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fil/fil0fil.cc:5519 #4 0x00000000009c3d78 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0start.cc:477 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7fbcf829b700 (LWP 19018)): #0 0x0000003b2560b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095f8cd in os_cond_wait_timed (event=0x25de780, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x25de780, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:723 #3 0x0000000000947f53 in lock_wait_timeout_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/lock/lock0wait.cc:503 #4 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7fbcf7a9a700 (LWP 19019)): #0 0x0000003b2560b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095f8cd in os_cond_wait_timed (event=0x221e800, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x221e800, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:723 #3 0x00000000009bfbf5 in srv_error_monitor_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0srv.cc:1763 #4 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7fbcf7299700 (LWP 19020)): #0 0x0000003b2560b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095f8cd in os_cond_wait_timed (event=0x221e890, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x221e890, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:723 #3 0x00000000009c1c5d in srv_monitor_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0srv.cc:1532 #4 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7fbcf8a9c700 (LWP 19021)): #0 0x0000003b24ee0d03 in select () from /lib64/libc.so.6 #1 0x000000000095fc6f in os_thread_sleep (tm=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0thread.cc:255 #2 0x00000000009c32a4 in srv_master_sleep (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0srv.cc:2294 #3 srv_master_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0srv.cc:2338 #4 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7fbcf6a98700 (LWP 19022)): #0 0x0000003b2560b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095fa72 in os_cond_wait (event=0x221e770, reset_sig_count=415) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x221e770, reset_sig_count=415) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:610 #3 0x00000000009c264d in srv_purge_coordinator_suspend (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0srv.cc:2631 #4 srv_purge_coordinator_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/srv/srv0srv.cc:2748 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7fbcf6297700 (LWP 19023)): #0 0x0000003b24ee0d03 in select () from /lib64/libc.so.6 #1 0x000000000095fc6f in os_thread_sleep (tm=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0thread.cc:255 #2 0x0000000000a258ab in page_cleaner_sleep_if_needed (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/buf/buf0flu.cc:2379 #3 buf_flush_page_cleaner_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/buf/buf0flu.cc:2420 #4 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7fbcf5a96700 (LWP 19024)): #0 0x0000003b2560b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095fa72 in os_cond_wait (event=0x221e920, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x221e920, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:610 #3 0x0000000000a20721 in buf_dump_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/buf/buf0dump.cc:594 #4 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7fbcf5295700 (LWP 19025)): #0 0x0000003b2560b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095f8cd in os_cond_wait_timed (event=0x25e23d0, time_in_usec=, reset_sig_count=77) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x25e23d0, time_in_usec=, reset_sig_count=77) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:723 #3 0x0000000000a52c45 in dict_stats_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/dict/dict0stats_bg.cc:348 #4 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7fbcf4a94700 (LWP 19026)): #0 0x0000003b2560b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095f8cd in os_cond_wait_timed (event=0x2697400, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x2697400, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/os/os0sync.cc:723 #3 0x00000000009ea9b4 in ib_wqueue_timedwait (wq=0x2697308, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/ut/ut0wqueue.cc:154 #4 0x0000000000a82a59 in fts_optimize_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/innobase/fts/fts0opt.cc:2972 #5 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7fbcf90c0700 (LWP 19027)): #0 0x0000003b2560f2a5 in sigwait () from /lib64/libpthread.so.0 #1 0x0000000000582682 in signal_hand (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mysqld.cc:3116 #2 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #3 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #4 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7fbcf907f700 (LWP 19283)): #0 0x0000003b2560e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003b256093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003b25609326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000006ed410 in inline_mysql_mutex_lock (thd=0x26ae3a0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:688 #4 mysql_execute_command (thd=0x26ae3a0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:2782 #5 0x00000000006eeed8 in mysql_parse (thd=0x26ae3a0, rawbuf=0x7fbce0004f50 "show slave status", length=, parser_state=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:6204 #6 0x00000000006ef8c1 in dispatch_command (command=COM_QUERY, thd=0x26ae3a0, packet=0x27aa761 "show slave status", packet_length=17) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:1332 #7 0x00000000006f0da7 in do_command (thd=0x26ae3a0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:1036 #8 0x00000000006badc6 in do_handle_one_connection (thd_arg=0x26ae3a0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:977 #9 0x00000000006baea5 in handle_one_connection (arg=0x270c4f0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:893 #10 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #11 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #12 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7fbcf8fbc700 (LWP 19438)): #0 0x0000003b2560b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000057d26f in block_until_new_connection (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:1162 #2 one_thread_per_connection_end (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mysqld.cc:2704 #3 0x00000000006bad52 in do_handle_one_connection (thd_arg=0x26f00b0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:984 #4 0x00000000006baea5 in handle_one_connection (arg=0x26e8ec0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:893 #5 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #6 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #7 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7fbcf8f7b700 (LWP 19537)): #0 0x0000003b2560b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000057d26f in block_until_new_connection (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:1162 #2 one_thread_per_connection_end (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mysqld.cc:2704 #3 0x00000000006bad52 in do_handle_one_connection (thd_arg=0x27713e0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:984 #4 0x00000000006baea5 in handle_one_connection (arg=0x2702e00) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:893 #5 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #6 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #7 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7fbcf8f3a700 (LWP 19551)): #0 0x0000003b2560b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000057d26f in block_until_new_connection (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:1162 #2 one_thread_per_connection_end (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mysqld.cc:2704 #3 0x00000000006bad52 in do_handle_one_connection (thd_arg=0x2702e00) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:984 #4 0x00000000006baea5 in handle_one_connection (arg=0x276bc60) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:893 #5 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #6 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #7 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7fbcf8ef9700 (LWP 19916)): #0 0x0000003b2560b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000057d26f in block_until_new_connection (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:1162 #2 one_thread_per_connection_end (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mysqld.cc:2704 #3 0x00000000006bad52 in do_handle_one_connection (thd_arg=0x276bc60) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:984 #4 0x00000000006baea5 in handle_one_connection (arg=0x26ae3a0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:893 #5 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #6 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #7 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7fbcf8eb8700 (LWP 19917)): #0 0x0000003b2560b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000057d26f in block_until_new_connection (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:1162 #2 one_thread_per_connection_end (thd=, block_pthread=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mysqld.cc:2704 #3 0x00000000006bad52 in do_handle_one_connection (thd_arg=0x26da580) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:984 #4 0x00000000006baea5 in handle_one_connection (arg=0x26e3d70) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:893 #5 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #6 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #7 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7fbcf8e77700 (LWP 20444)): #0 0x0000003b2560e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003b256093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003b25609326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000008c8efd in inline_mysql_mutex_lock (thd=0x2702e00, mi=0x2203a60) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:688 #4 show_slave_status (thd=0x2702e00, mi=0x2203a60) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/rpl_slave.cc:2643 #5 0x00000000006ea80d in mysql_execute_command (thd=0x2702e00) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:2783 #6 0x00000000006eeed8 in mysql_parse (thd=0x2702e00, rawbuf=0x7fbcc40049b0 "show slave status", length=, parser_state=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:6204 #7 0x00000000006ef8c1 in dispatch_command (command=COM_QUERY, thd=0x2702e00, packet=0x27713e1 "", packet_length=17) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:1332 #8 0x00000000006f0da7 in do_command (thd=0x2702e00) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:1036 #9 0x00000000006badc6 in do_handle_one_connection (thd_arg=0x2702e00) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:977 #10 0x00000000006baea5 in handle_one_connection (arg=0x2778290) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:893 #11 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #12 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #13 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7fbcf8e36700 (LWP 20445)): #0 0x0000003b2560e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003b256093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003b25609326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000006ed410 in inline_mysql_mutex_lock (thd=0x276bc60) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:688 #4 mysql_execute_command (thd=0x276bc60) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:2782 #5 0x00000000006eeed8 in mysql_parse (thd=0x276bc60, rawbuf=0x7fbcc0004bd0 "show slave status", length=, parser_state=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:6204 #6 0x00000000006ef8c1 in dispatch_command (command=COM_QUERY, thd=0x276bc60, packet=0x270bed1 "show slave status", packet_length=17) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:1332 #7 0x00000000006f0da7 in do_command (thd=0x276bc60) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:1036 #8 0x00000000006badc6 in do_handle_one_connection (thd_arg=0x276bc60) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:977 #9 0x00000000006baea5 in handle_one_connection (arg=0x26e7d80) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:893 #10 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #11 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #12 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7fbcf8df5700 (LWP 20463)): #0 0x0000003b2560e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003b256093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003b25609326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000006ed410 in inline_mysql_mutex_lock (thd=0x27e2220) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:688 #4 mysql_execute_command (thd=0x27e2220) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:2782 #5 0x00000000006eeed8 in mysql_parse (thd=0x27e2220, rawbuf=0x7fbccc004bd0 "show slave status", length=, parser_state=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:6204 #6 0x00000000006ef8c1 in dispatch_command (command=COM_QUERY, thd=0x27e2220, packet=0x26f00b1 "show slave status", packet_length=17) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:1332 #7 0x00000000006f0da7 in do_command (thd=0x27e2220) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_parse.cc:1036 #8 0x00000000006badc6 in do_handle_one_connection (thd_arg=0x27e2220) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:977 #9 0x00000000006baea5 in handle_one_connection (arg=0x26de590) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/sql_connect.cc:893 #10 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #11 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #12 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7fbcf903e700 (LWP 20765)): #0 0x0000003b24edea63 in poll () from /lib64/libc.so.6 #1 0x0000000000b64337 in vio_io_wait (vio=, event=, timeout=3600000) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/vio/viosocket.c:771 #2 0x0000000000b64423 in vio_socket_io_wait (vio=0x7fbcf903da10, event=VIO_IO_EVENT_WRITE) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/vio/viosocket.c:68 #3 0x0000000000b6463c in vio_read (vio=0x7fbce4012f90, buf=0x7fbce40008c0 "P", size=16384) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/vio/viosocket.c:123 #4 0x0000000000b646ee in vio_read_buff (vio=0x7fbcf903da10, buf=0x7fbce40048d0 "", size=4) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/vio/viosocket.c:157 #5 0x00000000006638a2 in net_read_raw_loop (net=0x7fbce4017530, count=4) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/net_serv.cc:663 #6 0x00000000006639f8 in net_read_packet_header (net=0x7fbcf903da10) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/net_serv.cc:751 #7 0x00000000006644a8 in net_read_packet (net=0x7fbcf903da10) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/net_serv.cc:810 #8 my_net_read (net=0x7fbcf903da10) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/net_serv.cc:888 #9 0x000000000078a8ea in cli_safe_read (mysql=0x7fbcf903da10) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql-common/client.c:620 #10 0x00000000008d0436 in handle_slave_io (arg=0x2203a60) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/rpl_slave.cc:3167 #11 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #12 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #13 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fbcf8ffd700 (LWP 20766)): #0 0x0000003b2560b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000660cec in inline_mysql_cond_timedwait (this=0x7fbcd80009a8, owner=0x7fbcd80008c0, abs_timeout=0x7fbcf8ffbe50, set_status_on_timeout=true, wait_state_name=0x122ce48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x7fbcd80009a8, owner=0x7fbcd80008c0, abs_timeout=0x7fbcf8ffbe50, set_status_on_timeout=true, wait_state_name=0x122ce48) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mdl.cc:1305 #3 0x00000000006626a5 in MDL_context::acquire_lock (this=0x7fbcd80009a8, mdl_request=0x7fbcf8ffbec0, lock_wait_timeout=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mdl.cc:2241 #4 0x000000000058cd95 in ha_commit_trans (thd=0x7fbcd80008c0, all=, ignore_global_read_lock=false) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/handler.cc:1403 #5 0x00000000007821f3 in trans_commit (thd=0x7fbcd80008c0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/transaction.cc:228 #6 0x000000000088862b in Xid_log_event::do_commit (this=, thd=0x189) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/log_event.cc:7204 #7 0x000000000088f85c in Xid_log_event::do_apply_event (this=0x7fbcd8034e20, rli=0x26f6fa0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/log_event.cc:7340 #8 0x000000000088b20d in Log_event::apply_event (this=0x7fbcd8034e20, rli=0x26f6fa0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/log_event.cc:2988 #9 0x00000000008d14ab in apply_event_and_update_pos (ptr_ev=0x7fbcf8ffc588, thd=0x7fbcd80008c0, rli=0x26f6fa0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/rpl_slave.cc:3407 #10 0x00000000008d1ff8 in exec_relay_log_event (thd=0x7fbcd80008c0, rli=0x26f6fa0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/rpl_slave.cc:3782 #11 0x00000000008d3319 in handle_slave_sql (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/rpl_slave.cc:5590 #12 0x0000000000ac3886 in pfs_spawn_thread (arg=) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/storage/perfschema/pfs.cc:1858 #13 0x0000003b25607851 in start_thread () from /lib64/libpthread.so.0 #14 0x0000003b24ee811d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7fbd24d59720 (LWP 19001)): #0 0x0000003b24edea63 in poll () from /lib64/libc.so.6 #1 0x00000000005814ea in handle_connections_sockets () at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mysqld.cc:6128 #2 0x0000000000583343 in mysqld_main (argc=21, argv=0x2119ea0) at /export/home/pb2/build/sb_0-9714019-1373474833.36/mysql-5.6.13/sql/mysqld.cc:5553 #3 0x0000003b24e1ecdd in __libc_start_main () from /lib64/libc.so.6 #4 0x00000000005779e9 in _start ()