0x00007f055644abe4 in __lll_lock_wait () from /lib/libpthread.so.0 Thread 50 (Thread 0x7f05550eb700 (LWP 20463)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=0) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 49 (Thread 0x7efe3c81d700 (LWP 20464)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=1) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 48 (Thread 0x7efe3c01c700 (LWP 20465)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=2) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 47 (Thread 0x7efe3b81b700 (LWP 20466)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=3) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 46 (Thread 0x7efe3b01a700 (LWP 20467)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=4) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 45 (Thread 0x7efe3a819700 (LWP 20468)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=5) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 44 (Thread 0x7efe3a018700 (LWP 20469)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=6) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 43 (Thread 0x7efe39817700 (LWP 20470)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=7) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 42 (Thread 0x7efe39016700 (LWP 20471)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=8) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 41 (Thread 0x7efe38815700 (LWP 20472)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=9) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 40 (Thread 0x7efe38014700 (LWP 20473)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=10) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 39 (Thread 0x7efe37813700 (LWP 20474)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=11) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 38 (Thread 0x7efe37012700 (LWP 20475)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=12) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 37 (Thread 0x7efe36811700 (LWP 20476)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=13) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 36 (Thread 0x7efe36010700 (LWP 20477)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=14) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 35 (Thread 0x7efe3580f700 (LWP 20478)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=15) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 34 (Thread 0x7efe3500e700 (LWP 20479)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=16) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 33 (Thread 0x7efe3480d700 (LWP 20480)): #0 0x00007f055623c664 in ?? () from /lib/libaio.so.1 #1 0x000000000089de57 in os_aio_linux_collect (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4526 #2 os_aio_linux_handle (global_seg=, message1=, message2=, type=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0file.c:4670 #3 0x00000000008620d6 in fil_aio_wait (segment=17) at /usr/src/mysql/mysql-5.5.28/storage/innobase/fil/fil0fil.c:4563 #4 0x00000000007fda78 in io_handler_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0start.c:482 #5 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #6 0x00007f05551bb02d in clone () from /lib/libc.so.6 #7 0x0000000000000000 in ?? () Thread 32 (Thread 0x7efe3380b700 (LWP 20491)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000008a12d6 in os_cond_wait (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:609 #3 0x0000000000801217 in sync_array_wait_event (arr=0x2f8d360, index=3) at /usr/src/mysql/mysql-5.5.28/storage/innobase/sync/sync0arr.c:458 #4 0x000000000080251d in mutex_spin_wait (mutex=0x2f98648, file_name=0x9e6ba0 "/usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0srv.c", line=2291) at /usr/src/librus/mysql-5.5.28/storage/innobase/sync/sync0sync.c:643 #5 0x00000000007fa3b2 in mutex_enter_func (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:251 #7 srv_lock_timeout_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0srv.c:2291 #8 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #9 0x00007f05551bb02d in clone () from /lib/libc.so.6 #10 0x0000000000000000 in ?? () Thread 31 (Thread 0x7efe3300a700 (LWP 20492)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000008a12d6 in os_cond_wait (event=0x2f98720, reset_sig_count=1) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2f98720, reset_sig_count=1) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:609 #3 0x0000000000801217 in sync_array_wait_event (arr=0x2f8d360, index=6) at /usr/src/mysql/mysql-5.5.28/storage/innobase/sync/sync0arr.c:458 #4 0x000000000080251d in mutex_spin_wait (mutex=0xf60740, file_name=0x9e6ba0 "/usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0srv.c", line=1787) at /usr/src/librus/mysql-5.5.28/storage/innobase/sync/sync0sync.c:643 #5 0x00000000007fa084 in mutex_enter_func (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:251 #7 srv_refresh_innodb_monitor_stats (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0srv.c:1787 #8 srv_error_monitor_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0srv.c:2427 #9 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #10 0x00007f05551bb02d in clone () from /lib/libc.so.6 #11 0x0000000000000000 in ?? () Thread 30 (Thread 0x7efe32809700 (LWP 20493)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000008a12d6 in os_cond_wait (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:609 #3 0x0000000000801217 in sync_array_wait_event (arr=0x2f8d360, index=5) at /usr/src/mysql/mysql-5.5.28/storage/innobase/sync/sync0arr.c:458 #4 0x000000000080251d in mutex_spin_wait (mutex=0x2f98648, file_name=0x9fbaa8 "/usr/src/mysql/mysql-5.5.28/storage/innobase/lock/lock0lock.c", line=4468) at /usr/src/librus/mysql-5.5.28/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000887110 in mutex_enter_func (mutex=0x2f98648, line=4468, file_name=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x2f98648, line=4468, file_name=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:251 #7 0x0000000000887390 in lock_print_info_summary (file=0x7f0555447860, nowait=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/lock/lock0lock.c:4468 #8 0x00000000007fc635 in srv_printf_innodb_monitor (file=0x7f0555447860, nowait=0, trx_start=0x0, trx_end=0x0) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0srv.c:1879 #9 0x00000000007fcf44 in srv_monitor_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0srv.c:2157 #10 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #11 0x00007f05551bb02d in clone () from /lib/libc.so.6 #12 0x0000000000000000 in ?? () Thread 29 (Thread 0x7efe3400c700 (LWP 20494)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000008a12d6 in os_cond_wait (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:609 #3 0x0000000000801217 in sync_array_wait_event (arr=0x2f8d360, index=4) at /usr/src/mysql/mysql-5.5.28/storage/innobase/sync/sync0arr.c:458 #4 0x000000000080251d in mutex_spin_wait (mutex=0x2f98648, file_name=0x9e2600 "/usr/src/mysql/mysql-5.5.28/storage/innobase/row/row0mysql.c", line=2262) at /usr/src/librus/mysql-5.5.28/storage/innobase/sync/sync0sync.c:643 #5 0x00000000007e7a02 in mutex_enter_func () at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func () at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:251 #7 row_drop_tables_for_mysql_in_background () at /usr/src/mysql/mysql-5.5.28/storage/innobase/row/row0mysql.c:2262 #8 0x00000000007fb0c6 in srv_master_thread (arg=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/srv/srv0srv.c:2782 #9 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #10 0x00007f05551bb02d in clone () from /lib/libc.so.6 #11 0x0000000000000000 in ?? () Thread 28 (Thread 0x7f0556845700 (LWP 20495)): #0 0x00007f055644bca7 in do_sigwait () from /lib/libpthread.so.0 #1 0x00007f055644bd27 in sigwait () from /lib/libpthread.so.0 #2 0x000000000050882b in signal_hand (arg=) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2698 #3 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #4 0x00007f05551bb02d in clone () from /lib/libc.so.6 #5 0x0000000000000000 in ?? () Thread 27 (Thread 0x7f0556814700 (LWP 22667)): #0 0x00007f055644b0bd in read () from /lib/libpthread.so.0 #1 0x00000000008f9a32 in vio_read_buff (vio=0x39, buf=0x2cea3670 "", size=4) at /usr/src/mysql/mysql-5.5.28/vio/viosocket.c:95 #2 0x000000000050f8ab in my_real_read (net=0x2b2b7420, complen=) at /usr/src/mysql/mysql-5.5.28/sql/net_serv.cc:831 #3 0x000000000050fca5 in my_net_read (net=0x39) at /usr/src/mysql/mysql-5.5.28/sql/net_serv.cc:1028 #4 0x000000000063fa7a in cli_safe_read (mysql=0x39) at /usr/src/mysql/mysql-5.5.28/sql-common/client.c:735 #5 0x0000000000522b13 in read_event (arg=) at /usr/src/mysql/mysql-5.5.28/sql/slave.cc:2226 #6 handle_slave_io (arg=) at /usr/src/mysql/mysql-5.5.28/sql/slave.cc:2948 #7 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #8 0x00007f05551bb02d in clone () from /lib/libc.so.6 #9 0x0000000000000000 in ?? () Thread 26 (Thread 0x7f05567e3700 (LWP 22668)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000008a12d6 in os_cond_wait (event=0x2b25dc60, reset_sig_count=1628776) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2b25dc60, reset_sig_count=1628776) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:609 #3 0x0000000000801217 in sync_array_wait_event (arr=0x2f8d360, index=0) at /usr/src/mysql/mysql-5.5.28/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000801f41 in rw_lock_x_lock_wait (lock=0x2b25db58, pass=, file_name=0x9ee2b0 "/usr/src/mysql/mysql-5.5.28/storage/innobase/btr/btr0sea.c", line=1134) at /usr/src/librus/mysql-5.5.28/storage/innobase/sync/sync0rw.c:535 #5 rw_lock_x_lock_low (lock=0x2b25db58, pass=, file_name=0x9ee2b0 "/usr/src/mysql/mysql-5.5.28/storage/innobase/btr/btr0sea.c", line=1134) at /usr/src/librus/mysql-5.5.28/storage/innobase/sync/sync0rw.c:578 #6 rw_lock_x_lock_func (lock=0x2b25db58, pass=, file_name=0x9ee2b0 "/usr/src/mysql/mysql-5.5.28/storage/innobase/btr/btr0sea.c", line=1134) at /usr/src/librus/mysql-5.5.28/storage/innobase/sync/sync0rw.c:637 #7 0x0000000000832fca in pfs_rw_lock_x_lock_func (lock=0x2b25db58, line=1134, file_name=, pass=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0rw.ic:689 #8 0x0000000000833678 in btr_search_drop_page_hash_index (block=0x7f035ed29280) at /usr/src/mysql/mysql-5.5.28/storage/innobase/btr/btr0sea.c:1134 #9 0x0000000000845802 in buf_LRU_free_block (bpage=0x7f035ed29280, zip=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/buf/buf0lru.c:1820 #10 0x0000000000846539 in buf_LRU_free_from_common_LRU_list (buf_pool=, n_iterations=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/buf/buf0lru.c:884 #11 buf_LRU_search_and_free_block (buf_pool=, n_iterations=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/buf/buf0lru.c:927 #12 0x000000000084694f in buf_LRU_get_free_block (buf_pool=0x425a428) at /usr/src/mysql/mysql-5.5.28/storage/innobase/buf/buf0lru.c:1153 #13 0x00000000008384de in buf_block_alloc (buf_pool=0x2b25dc9c) at /usr/src/mysql/mysql-5.5.28/storage/innobase/buf/buf0buf.c:427 #14 0x0000000000897510 in mem_heap_create_block (heap=0x7efe1c54e650, n=128, type=1, file_name=0x7efe1c54e658 "x0trx.c", line=171) at /usr/src/mysql/mysql-5.5.28/storage/innobase/mem/mem0mem.c:350 #15 0x0000000000897630 in mem_heap_add_block (heap=0x7efe1c54e650, n=18446744073709551104) at /usr/src/mysql/mysql-5.5.28/storage/innobase/mem/mem0mem.c:446 #16 0x0000000000887d59 in mem_heap_alloc (type_mode=, block=, heap_no=141, index=, trx=0x7efe1c4afc48) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/mem0mem.ic:186 #17 lock_rec_create (type_mode=, block=, heap_no=141, index=, trx=0x7efe1c4afc48) at /usr/src/mysql/mysql-5.5.28/storage/innobase/lock/lock0lock.c:1710 #18 0x000000000088ab5b in lock_rec_lock_fast (impl=0, mode=1027, block=0x7f01b54cbf00, heap_no=141, index=0x7efe04391208, thr=0x184212) at /usr/src/mysql/mysql-5.5.28/storage/innobase/lock/lock0lock.c:1993 #19 lock_rec_lock (impl=0, mode=1027, block=0x7f01b54cbf00, heap_no=141, index=0x7efe04391208, thr=0x184212) at /usr/src/mysql/mysql-5.5.28/storage/innobase/lock/lock0lock.c:2124 #20 0x000000000088ac79 in lock_clust_rec_read_check_and_lock (flags=, block=0x7f01b54cbf00, rec=0x7f02502dd31a "", index=0x7efe04391208, offsets=, mode=LOCK_X, gap_mode=1024, thr=0x7efe0550e6e8) at /usr/src/mysql/mysql-5.5.28/storage/innobase/lock/lock0lock.c:5538 #21 0x00000000007eea8e in row_sel_get_clust_rec_for_mysql (buf=0x7efe066bf7f0 "\374\205XV", mode=, prebuilt=0x7efe0550df98, match_mode=, direction=1) at /usr/src/mysql/mysql-5.5.28/storage/innobase/row/row0sel.c:2983 #22 row_search_for_mysql (buf=0x7efe066bf7f0 "\374\205XV", mode=, prebuilt=0x7efe0550df98, match_mode=, direction=1) at /usr/src/mysql/mysql-5.5.28/storage/innobase/row/row0sel.c:4405 #23 0x00000000007ced69 in ha_innobase::general_fetch (this=0x7efe05513d20, buf=0x7efe066bf7f0 "\374\205XV", direction=1, match_mode=4294967295) at /usr/src/mysql/mysql-5.5.28/storage/innobase/handler/ha_innodb.cc:6183 #24 0x000000000065c0b4 in handler::read_multi_range_next (this=0x7efe05513d20, found_range_p=0x7f05567e0838) at /usr/src/mysql/mysql-5.5.28/sql/handler.cc:4568 #25 0x0000000000702e2d in QUICK_RANGE_SELECT::get_next (this=0x7efe05572ee0) at /usr/src/mysql/mysql-5.5.28/sql/opt_range.cc:8674 #26 0x00000000007039e9 in QUICK_ROR_INTERSECT_SELECT::get_next (this=0x7efe0543c410) at /usr/src/mysql/mysql-5.5.28/sql/opt_range.cc:8449 #27 0x0000000000719c91 in rr_quick (info=0x7f05567e0b40) at /usr/src/mysql/mysql-5.5.28/sql/records.cc:344 #28 0x00000000005d9f95 in mysql_update (thd=0x2ce90c50, table_list=0x7efe05c57c28, fields=, values=, conds=0x7efe05c589b0, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f05567e1fd8, updated_return=0x7f05567e1fd0) at /usr/src/mysql/mysql-5.5.28/sql/sql_update.cc:653 #29 0x0000000000573d28 in mysql_execute_command (thd=0x2ce90c50) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:2790 #30 0x0000000000577099 in mysql_parse (thd=0x2ce90c50, rawbuf=, length=110, parser_state=0x7f05567e20a0) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:5627 #31 0x00000000006f82f4 in Query_log_event::do_apply_event (this=0x7efe071c0060, rli=0x2b303700, query_arg=, q_len_arg=1451107024) at /usr/src/mysql/mysql-5.5.28/sql/log_event.cc:3427 #32 0x000000000051b14d in Log_event::apply_event (ev=0x7efe071c0060, thd=, rli=0x2b303700) at /usr/src/mysql/mysql-5.5.28/sql/log_event.h:1139 #33 apply_event_and_update_pos (ev=0x7efe071c0060, thd=, rli=0x2b303700) at /usr/src/mysql/mysql-5.5.28/sql/slave.cc:2392 #34 0x0000000000520726 in exec_relay_log_event (thd=, rli=0x2b303700) at /usr/src/mysql/mysql-5.5.28/sql/slave.cc:2552 #35 0x0000000000521a75 in handle_slave_sql (arg=) at /usr/src/mysql/mysql-5.5.28/sql/slave.cc:3377 #36 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #37 0x00007f05551bb02d in clone () from /lib/libc.so.6 #38 0x0000000000000000 in ?? () Thread 25 (Thread 0x7efe31cf8700 (LWP 22793)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 24 (Thread 0x7efe23db3700 (LWP 23246)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 23 (Thread 0x7efe3120f700 (LWP 23349)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 22 (Thread 0x7efe30416700 (LWP 23618)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 21 (Thread 0x7efe30042700 (LWP 23817)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 20 (Thread 0x7efe315e3700 (LWP 23913)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 19 (Thread 0x7efe310b8700 (LWP 23914)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 18 (Thread 0x7efe23c2b700 (LWP 24158)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 17 (Thread 0x7efe23e77700 (LWP 15702)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 16 (Thread 0x7efe305cf700 (LWP 21253)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 15 (Thread 0x7efe31c34700 (LWP 21255)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 14 (Thread 0x7efe30e6c700 (LWP 21256)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000008a12d6 in os_cond_wait (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:609 #3 0x0000000000801217 in sync_array_wait_event (arr=0x2f8d360, index=1) at /usr/src/mysql/mysql-5.5.28/storage/innobase/sync/sync0arr.c:458 #4 0x000000000080251d in mutex_spin_wait (mutex=0x2f98648, file_name=0x9eb410 "/usr/src/mysql/mysql-5.5.28/storage/innobase/trx/trx0trx.c", line=405) at /usr/src/librus/mysql-5.5.28/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000815442 in mutex_enter_func (trx=0x7efe0cd63608) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (trx=0x7efe0cd63608) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:251 #7 trx_free_for_mysql (trx=0x7efe0cd63608) at /usr/src/mysql/mysql-5.5.28/storage/innobase/trx/trx0trx.c:405 #8 0x00000000007d0205 in innobase_close_connection (hton=, thd=) at /usr/src/mysql/mysql-5.5.28/storage/innobase/handler/ha_innodb.cc:3112 #9 0x000000000065ee5e in closecon_handlerton (thd=0x7efe24199690, plugin=, unused=) at /usr/src/mysql/mysql-5.5.28/sql/handler.cc:724 #10 0x000000000057de71 in plugin_foreach_with_mask (thd=, func=, type=, state_mask=4294967287, arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_plugin.cc:2023 #11 0x0000000000552977 in ~THD (this=0x7efe24199690, __in_chrg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_class.cc:1364 #12 0x00000000005091fc in unlink_thd (thd=0x7efe24199690) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2189 #13 0x000000000050922f in one_thread_per_connection_end (thd=0x2f986dc, put_in_cache=128) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2293 #14 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #15 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #16 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #17 0x00007f05551bb02d in clone () from /lib/libc.so.6 #18 0x0000000000000000 in ?? () Thread 13 (Thread 0x7efe311ad700 (LWP 21257)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 12 (Thread 0x7efe30631700 (LWP 26226)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 11 (Thread 0x7efe30eff700 (LWP 26228)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 10 (Thread 0x7efe31e4f700 (LWP 13499)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 9 (Thread 0x7efe30b2b700 (LWP 13502)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 8 (Thread 0x7efe30168700 (LWP 13503)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 7 (Thread 0x7efe3142a700 (LWP 13505)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 6 (Thread 0x7efe31645700 (LWP 13508)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 5 (Thread 0x7efe23f9d700 (LWP 8995)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 4 (Thread 0x7efe3084c700 (LWP 8996)): #0 0x00007f055644abe4 in __lll_lock_wait () from /lib/libpthread.so.0 #1 0x00007f055644611f in _L_lock_1172 () from /lib/libpthread.so.0 #2 0x00007f055644606a in pthread_mutex_lock () from /lib/libpthread.so.0 #3 0x000000000072492c in inline_mysql_mutex_lock (this=0x7efe04a7eba0, thd=0x7efe246a5130, argp=0x7efe30848ce0, argcount=, return_value_fld=) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:617 #4 sp_head::execute_function (this=0x7efe04a7eba0, thd=0x7efe246a5130, argp=0x7efe30848ce0, argcount=, return_value_fld=) at /usr/src/mysql/mysql-5.5.28/sql/sp_head.cc:1936 #5 0x000000000069dc91 in Item_func_sp::execute_impl (this=0x7efe05518888, thd=0x7efe246a5130) at /usr/src/mysql/mysql-5.5.28/sql/item_func.cc:6430 #6 0x00000000006a3662 in Item_func_sp::execute (this=0x7efe05518888) at /usr/src/mysql/mysql-5.5.28/sql/item_func.cc:6359 #7 0x00000000006aab39 in Item_func_sp::val_real (this=0xf38ea0) at /usr/src/mysql/mysql-5.5.28/sql/item_func.h:1796 #8 0x000000000067b4e7 in Arg_comparator::compare_real_fixed (this=0x7efe05519710) at /usr/src/mysql/mysql-5.5.28/sql/item_cmpfunc.cc:1452 #9 0x0000000000681d32 in Arg_comparator::compare (this=) at /usr/src/mysql/mysql-5.5.28/sql/item_cmpfunc.h:88 #10 Item_func_ge::val_int (this=) at /usr/src/mysql/mysql-5.5.28/sql/item_cmpfunc.cc:2002 #11 0x0000000000666acc in Item::val_bool (this=0x7efe05519660) at /usr/src/mysql/mysql-5.5.28/sql/item.cc:200 #12 0x000000000067bfe1 in Item_func_if::val_real (this=0x7efe1c3051f8) at /usr/src/mysql/mysql-5.5.28/sql/item_cmpfunc.cc:2718 #13 0x00000000006cc857 in Item_sum_sum::update_field (this=0x7efe1c3052c8) at /usr/src/mysql/mysql-5.5.28/sql/item_sum.cc:2296 #14 0x0000000000596729 in update_tmptable_sum_func (join=, join_tab=, end_of_records=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:16051 #15 end_update (join=, join_tab=, end_of_records=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:12937 #16 0x000000000058e74c in evaluate_join_record (join=0x7efe1c22b328, join_tab=0x7efe1c392c90, error=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11892 #17 0x000000000059476e in sub_select (join=0x7efe1c22b328, join_tab=0x7efe1c392c90, end_of_records=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11745 #18 0x000000000058e74c in evaluate_join_record (join=0x7efe1c22b328, join_tab=0x7efe1c392a38, error=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11892 #19 0x000000000059476e in sub_select (join=0x7efe1c22b328, join_tab=0x7efe1c392a38, end_of_records=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11745 #20 0x000000000058e74c in evaluate_join_record (join=0x7efe1c22b328, join_tab=0x7efe1c3927e0, error=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11892 #21 0x000000000059476e in sub_select (join=0x7efe1c22b328, join_tab=0x7efe1c3927e0, end_of_records=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11745 #22 0x000000000058e74c in evaluate_join_record (join=0x7efe1c22b328, join_tab=0x7efe1c392588, error=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11892 #23 0x000000000059476e in sub_select (join=0x7efe1c22b328, join_tab=0x7efe1c392588, end_of_records=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11745 #24 0x000000000058e74c in evaluate_join_record (join=0x7efe1c22b328, join_tab=0x7efe1c392330, error=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11892 #25 0x000000000059476e in sub_select (join=0x7efe1c22b328, join_tab=0x7efe1c392330, end_of_records=) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11745 #26 0x000000000059961b in do_select (join=0x7efe1c22b328, fields=0x0, table=0x7efe1c290770, procedure=0x0) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11510 #27 0x00000000005aa120 in JOIN::exec (this=0x7efe1c22b328) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:1986 #28 0x00000000005abea2 in mysql_select (thd=0x7efe246a5130, rref_pointer_array=, tables=0x7efe1c2b5a00, wild_num=0, fields=, conds=, og_num=4, order=0x7efe1c22b0f0, group=0x7efe1c22ae90, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7efe1c22b308, unit=0x7efe246a6b08, select_lex=0x7efe246a7128) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:2588 #29 0x00000000005ac904 in handle_select (thd=0x7efe246a5130, lex=0x7efe246a6a58, result=0x7efe1c22b308, setup_tables_done_option=0) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:297 #30 0x0000000000570514 in execute_sqlcom_select (thd=0x7efe246a5130, all_tables=0x7efe1c2b5a00) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:4590 #31 0x0000000000575a2d in mysql_execute_command (thd=0x7efe246a5130) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:2151 #32 0x0000000000577099 in mysql_parse (thd=0x7efe246a5130, rawbuf=, length=665, parser_state=0x7efe3084b9d0) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:5627 #33 0x00000000005789f3 in dispatch_command (command=COM_QUERY, thd=0x7efe246a5130, packet=, packet_length=) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:1037 #34 0x00000000006058c6 in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:840 #35 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #36 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #37 0x00007f05551bb02d in clone () from /lib/libc.so.6 #38 0x0000000000000000 in ?? () Thread 3 (Thread 0x7efe30073700 (LWP 8997)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000005094ef in inline_mysql_cond_wait (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:980 #2 cache_thread (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2230 #3 one_thread_per_connection_end (thd=, put_in_cache=true) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:2295 #4 0x000000000060581d in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:847 #5 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #6 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #7 0x00007f05551bb02d in clone () from /lib/libc.so.6 #8 0x0000000000000000 in ?? () Thread 2 (Thread 0x7efe31add700 (LWP 8998)): #0 0x00007f055644816c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #1 0x00000000008a12d6 in os_cond_wait (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2f986a0, reset_sig_count=1720348) at /usr/src/mysql/mysql-5.5.28/storage/innobase/os/os0sync.c:609 #3 0x0000000000801217 in sync_array_wait_event (arr=0x2f8d360, index=2) at /usr/src/mysql/mysql-5.5.28/storage/innobase/sync/sync0arr.c:458 #4 0x000000000080251d in mutex_spin_wait (mutex=0x2f98648, file_name=0x9eb410 "/usr/src/mysql/mysql-5.5.28/storage/innobase/trx/trx0trx.c", line=754) at /usr/src/librus/mysql-5.5.28/storage/innobase/sync/sync0sync.c:643 #5 0x00000000008156d2 in mutex_enter_func (trx=0x7efe048d3ca8, rseg_id=18446744073709551615) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (trx=0x7efe048d3ca8, rseg_id=18446744073709551615) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/sync0sync.ic:251 #7 trx_start (trx=0x7efe048d3ca8, rseg_id=18446744073709551615) at /usr/src/mysql/mysql-5.5.28/storage/innobase/trx/trx0trx.c:754 #8 0x00000000007efc50 in trx_start_if_not_started (buf=0x7efe04a17000 "\240\002)", , mode=, prebuilt=0x7efe04a18408, match_mode=, direction=0) at /usr/src/mysql/mysql-5.5.28/storage/innobase/include/trx0trx.ic:38 #9 row_search_for_mysql (buf=0x7efe04a17000 "\240\002)", , mode=, prebuilt=0x7efe04a18408, match_mode=, direction=0) at /usr/src/mysql/mysql-5.5.28/storage/innobase/row/row0sel.c:3774 #10 0x00000000007cea14 in ha_innobase::index_read (this=0x7efe04a155e0, buf=0x7efe04a17000 "\240\002)", , key_ptr=0x7efe0c2dbcb0 "/\b", key_len=4, find_flag=HA_READ_KEY_EXACT) at /usr/src/mysql/mysql-5.5.28/storage/innobase/handler/ha_innodb.cc:5948 #11 0x0000000000594df5 in join_read_always_key (tab=0x7efe0cf63aa0) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:12379 #12 0x0000000000594753 in sub_select (join=0x7efe054e0fe0, join_tab=0x80, end_of_records=176) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11744 #13 0x000000000059961b in do_select (join=0x7efe054e0fe0, fields=0x0, table=0x7efe0cbe22d0, procedure=0x0) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:11510 #14 0x00000000005aa120 in JOIN::exec (this=0x7efe054e0fe0) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:1986 #15 0x00000000005abea2 in mysql_select (thd=0x7efe2448f880, rref_pointer_array=, tables=0x7efe0545c548, wild_num=0, fields=, conds=, og_num=1, order=0x7efe054e0ef0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748609, result=0x7efe054e0fc0, unit=0x7efe24491258, select_lex=0x7efe24491878) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:2588 #16 0x00000000005ac904 in handle_select (thd=0x7efe2448f880, lex=0x7efe244911a8, result=0x7efe054e0fc0, setup_tables_done_option=0) at /usr/src/mysql/mysql-5.5.28/sql/sql_select.cc:297 #17 0x0000000000570514 in execute_sqlcom_select (thd=0x7efe2448f880, all_tables=0x7efe0545c548) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:4590 #18 0x0000000000575a2d in mysql_execute_command (thd=0x7efe2448f880) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:2151 #19 0x0000000000577099 in mysql_parse (thd=0x7efe2448f880, rawbuf=, length=217, parser_state=0x7efe31adc9d0) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:5627 #20 0x00000000005789f3 in dispatch_command (command=COM_QUERY, thd=0x7efe2448f880, packet=, packet_length=) at /usr/src/mysql/mysql-5.5.28/sql/sql_parse.cc:1037 #21 0x00000000006058c6 in do_handle_one_connection (thd_arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:840 #22 0x000000000060592a in handle_one_connection (arg=) at /usr/src/mysql/mysql-5.5.28/sql/sql_connect.cc:759 #23 0x00007f05564438ba in start_thread () from /lib/libpthread.so.0 #24 0x00007f05551bb02d in clone () from /lib/libc.so.6 #25 0x0000000000000000 in ?? () Thread 1 (Thread 0x7f0556867720 (LWP 20461)): #0 0x00007f055644abe4 in __lll_lock_wait () from /lib/libpthread.so.0 #1 0x00007f055644611f in _L_lock_1172 () from /lib/libpthread.so.0 #2 0x00007f055644606a in pthread_mutex_lock () from /lib/libpthread.so.0 #3 0x000000000055402a in inline_mysql_mutex_lock (this=0x7efe241bfc70) at /usr/src/mysql/mysql-5.5.28/include/mysql/psi/mysql_thread.h:617 #4 sql_rnd_with_mutex (this=0x7efe241bfc70) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.h:477 #5 THD (this=0x7efe241bfc70) at /usr/src/mysql/mysql-5.5.28/sql/sql_class.cc:899 #6 0x00000000005097a5 in handle_connections_sockets () at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:5311 #7 0x000000000050df4f in mysqld_main (argc=65, argv=0x2f56ad8) at /usr/src/mysql/mysql-5.5.28/sql/mysqld.cc:4611 #8 0x00007f055510ac4d in __libc_start_main () from /lib/libc.so.6 #9 0x000000000050573d in _start () InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream InnoDB: Warning: a long semaphore wait: --Thread 139660902676224 has waited at btr0sea.c line 1134 for 706.00 seconds the semaphore: btr_search_drop_page_hash_index() 1130 if (UNIV_LIKELY_NULL(heap)) { 1131 mem_heap_free(heap); 1132 } 1133 1134 rw_lock_x_lock(&btr_search_latch); X-lock (wait_ex) on RW-latch at 0x2b25db58 created in file btr0sea.c line 178 a writer (thread id 139660902676224) has reserved it in mode wait exclusive number of readers 1, waiters flag 0, lock_word: ffffffffffffffff Last time read locked in file row0sel.c line 3677 row_search_for_mysql() 3675 #ifndef UNIV_SEARCH_DEBUG 3676 if (!trx->has_search_latch) { 3677 rw_lock_s_lock(&btr_search_latch); 3678 trx->has_search_latch = TRUE; 3679 } 3680 #endif Last time write locked in file /usr/src/mysql/mysql-5.5.28/storage/innobase/btr/btr0sea.c line 633 btr_search_info_update_slow() 626 <------>if (cursor->flag == BTR_CUR_HASH_FAIL) { 627 <------><------>/* Update the hash node reference, if appropriate */ 628 629 #ifdef UNIV_SEARCH_PERF_STAT 630 <------><------>btr_search_n_hash_fail++; 631 #endif /* UNIV_SEARCH_PERF_STAT */ 632 633 <------><------>rw_lock_x_lock(&btr_search_latch); 634 635 <------><------>btr_search_update_hash_ref(info, block, cursor); 636 637 <------><------>rw_lock_x_unlock(&btr_search_latch); 638 <------>} InnoDB: Warning: a long semaphore wait: --Thread 139630207223552 has waited at trx0trx.c line 405 for 706.00 seconds the semaphore: Mutex at 0x2f98648 created file srv0srv.c line 1018, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 139630220269312 has waited at trx0trx.c line 754 for 706.00 seconds the semaphore: Mutex at 0x2f98648 created file srv0srv.c line 1018, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 139630250866432 has waited at srv0srv.c line 2291 for 706.00 seconds the semaphore: Mutex at 0x2f98648 created file srv0srv.c line 1018, lock var 1 waiters flag 1 InnoDB: Warning: a long semaphore wait: --Thread 139630259259136 has waited at row0mysql.c line 2262 for 706.00 seconds the semaphore: Mutex at 0x2f98648 created file srv0srv.c line 1018, lock var 1 waiters flag 1 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 InnoDB: ###### Diagnostic info printed to the standard error stream