Attaching to process 7431 Reading symbols from /home/sbester/mysql/5.5/mysql-5.5.13-linux2.6-x86_64/bin/mysqld...done. Reading symbols from /lib64/libpthread.so.0...(no debugging symbols found)...done. [Thread debugging using libthread_db enabled] [New Thread 0x7fdcb8566710 (LWP 7715)] [New Thread 0x7fdcb85a7710 (LWP 7540)] [New Thread 0x7fdcb85e8710 (LWP 7538)] [New Thread 0x7fdcb8629710 (LWP 7536)] [New Thread 0x7fdcb866a710 (LWP 7534)] [New Thread 0x7fdcb86ab710 (LWP 7532)] [New Thread 0x7fdcb86ec710 (LWP 7530)] [New Thread 0x7fdcb872d710 (LWP 7528)] [New Thread 0x7fdcb876e710 (LWP 7526)] [New Thread 0x7fdcb87af710 (LWP 7524)] [New Thread 0x7fdcb87f0710 (LWP 7522)] [New Thread 0x7fdcb8831710 (LWP 7520)] [New Thread 0x7fdcb8872710 (LWP 7518)] [New Thread 0x7fdcb88b3710 (LWP 7516)] [New Thread 0x7fdcb88f4710 (LWP 7514)] [New Thread 0x7fdcb8935710 (LWP 7512)] [New Thread 0x7fdcb8976710 (LWP 7510)] [New Thread 0x7fdcb89b7710 (LWP 7508)] [New Thread 0x7fdcb89f8710 (LWP 7506)] [New Thread 0x7fdcb8a39710 (LWP 7504)] [New Thread 0x7fdcb8a7a710 (LWP 7502)] [New Thread 0x7fdcb8abb710 (LWP 7500)] [New Thread 0x7fdccc06c710 (LWP 7498)] [New Thread 0x7fdccc0ad710 (LWP 7496)] [New Thread 0x7fdccc0ee710 (LWP 7494)] [New Thread 0x7fdccc12f710 (LWP 7492)] [New Thread 0x7fdccc170710 (LWP 7490)] [New Thread 0x7fdcabfff710 (LWP 7488)] [New Thread 0x7fdccc1b1710 (LWP 7486)] [New Thread 0x7fdccc233710 (LWP 7484)] [New Thread 0x7fdccc1f2710 (LWP 7482)] [New Thread 0x7fdccc274710 (LWP 7463)] [New Thread 0x7fdcb96ef710 (LWP 7462)] [New Thread 0x7fdcba0f0710 (LWP 7461)] [New Thread 0x7fdcbaaf1710 (LWP 7460)] [New Thread 0x7fdcbb4f2710 (LWP 7459)] [New Thread 0x7fdcbc0f9710 (LWP 7442)] [New Thread 0x7fdcbcafa710 (LWP 7441)] [New Thread 0x7fdcbd4fb710 (LWP 7440)] [New Thread 0x7fdcbdefc710 (LWP 7439)] [New Thread 0x7fdcbe8fd710 (LWP 7438)] [New Thread 0x7fdcbf2fe710 (LWP 7437)] [New Thread 0x7fdcbfcff710 (LWP 7436)] [New Thread 0x7fdcccc75710 (LWP 7435)] [New Thread 0x7fdccd676710 (LWP 7434)] [New Thread 0x7fdccf58f710 (LWP 7433)] Loaded symbols for /lib64/libpthread.so.0 Reading symbols from /lib64/libaio.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/libaio.so.1 Reading symbols from /lib64/libm.so.6...(no debugging symbols found)...done. Loaded symbols for /lib64/libm.so.6 Reading symbols from /lib64/librt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/librt.so.1 Reading symbols from /lib64/libcrypt.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/libcrypt.so.1 Reading symbols from /lib64/libdl.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/libdl.so.2 Reading symbols from /lib64/libc.so.6...(no debugging symbols found)...done. Loaded symbols for /lib64/libc.so.6 Reading symbols from /lib64/ld-linux-x86-64.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/ld-linux-x86-64.so.2 Reading symbols from /lib64/libfreebl3.so...(no debugging symbols found)...done. Loaded symbols for /lib64/libfreebl3.so Reading symbols from /lib64/libgcc_s.so.1...(no debugging symbols found)...done. Loaded symbols for /lib64/libgcc_s.so.1 Reading symbols from /lib64/libnss_files.so.2...(no debugging symbols found)...done. Loaded symbols for /lib64/libnss_files.so.2 0x00000030e180dfb4 in __lll_lock_wait () from /lib64/libpthread.so.0 Thread 47 (Thread 0x7fdccf58f710 (LWP 7433)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x000000000088ac08 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4420 #2 os_aio_linux_handle (global_seg=0, message1=0x7fdccf58ee78, message2=0x7fdccf58ee70, type=0x7fdccf58ee68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4564 #3 0x000000000084d9ee in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4527 #4 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 46 (Thread 0x7fdccd676710 (LWP 7434)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x000000000088ac08 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4420 #2 os_aio_linux_handle (global_seg=1, message1=0x7fdccd675e78, message2=0x7fdccd675e70, type=0x7fdccd675e68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4564 #3 0x000000000084d9ee in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4527 #4 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 45 (Thread 0x7fdcccc75710 (LWP 7435)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x000000000088ac08 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4420 #2 os_aio_linux_handle (global_seg=2, message1=0x7fdcccc74e78, message2=0x7fdcccc74e70, type=0x7fdcccc74e68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4564 #3 0x000000000084d9ee in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4527 #4 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 44 (Thread 0x7fdcbfcff710 (LWP 7436)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x000000000088ac08 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4420 #2 os_aio_linux_handle (global_seg=3, message1=0x7fdcbfcfee78, message2=0x7fdcbfcfee70, type=0x7fdcbfcfee68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4564 #3 0x000000000084d9ee in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4527 #4 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 43 (Thread 0x7fdcbf2fe710 (LWP 7437)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x000000000088ac08 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4420 #2 os_aio_linux_handle (global_seg=4, message1=0x7fdcbf2fde78, message2=0x7fdcbf2fde70, type=0x7fdcbf2fde68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4564 #3 0x000000000084d9ee in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4527 #4 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 42 (Thread 0x7fdcbe8fd710 (LWP 7438)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x000000000088ac08 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4420 #2 os_aio_linux_handle (global_seg=5, message1=0x7fdcbe8fce78, message2=0x7fdcbe8fce70, type=0x7fdcbe8fce68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4564 #3 0x000000000084d9ee in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4527 #4 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 41 (Thread 0x7fdcbdefc710 (LWP 7439)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=17) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=4084) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=4084) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081dd03 in buf_page_io_complete (bpage=0x7fdcbfd46e00) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:4084 #8 0x000000000084dbb8 in fil_aio_wait (segment=6) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4564 #9 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #10 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #11 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 40 (Thread 0x7fdcbd4fb710 (LWP 7440)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x000000000088ac08 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4420 #2 os_aio_linux_handle (global_seg=7, message1=0x7fdcbd4fae78, message2=0x7fdcbd4fae70, type=0x7fdcbd4fae68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4564 #3 0x000000000084d9ee in fil_aio_wait (segment=7) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4527 #4 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 39 (Thread 0x7fdcbcafa710 (LWP 7441)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x000000000088ac08 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4420 #2 os_aio_linux_handle (global_seg=8, message1=0x7fdcbcaf9e78, message2=0x7fdcbcaf9e70, type=0x7fdcbcaf9e68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4564 #3 0x000000000084d9ee in fil_aio_wait (segment=8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4527 #4 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 38 (Thread 0x7fdcbc0f9710 (LWP 7442)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x000000000088ac08 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4420 #2 os_aio_linux_handle (global_seg=9, message1=0x7fdcbc0f8e78, message2=0x7fdcbc0f8e70, type=0x7fdcbc0f8e68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0file.c:4564 #3 0x000000000084d9ee in fil_aio_wait (segment=9) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/fil/fil0fil.c:4527 #4 0x00000000007dc120 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0start.c:482 #5 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #6 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 37 (Thread 0x7fdcbb4f2710 (LWP 7459)): #0 0x00000030e180b729 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088d97b in os_cond_wait_timed (abstime=, mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x31559d0, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:716 #3 0x00000000007d8210 in srv_lock_timeout_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0srv.c:2283 #4 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #5 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 36 (Thread 0x7fdcbaaf1710 (LWP 7460)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2e65600, reset_sig_count=1) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=34) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0xf23a60, file_name=0xa13b20 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0srv.c", line=1785) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x00000000007d80c8 in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 srv_refresh_innodb_monitor_stats () at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0srv.c:1785 #8 srv_error_monitor_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0srv.c:2422 #9 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #10 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 35 (Thread 0x7fdcba0f0710 (LWP 7461)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=4890) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=4890) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x00000000008201ae in buf_stats_get_pool_info (all_pool_info=, pool_id=, buf_pool=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:4890 #8 buf_print_io (file=0x30e1779860) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:5110 #9 0x00000000007da599 in srv_printf_innodb_monitor (file=0x30e1779860, nowait=, trx_start=, trx_end=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0srv.c:1936 #10 0x00000000007dab1f in srv_monitor_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0srv.c:2153 #11 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #12 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 34 (Thread 0x7fdcb96ef710 (LWP 7462)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3360480, reset_sig_count=247) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=7) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x7fdcbfd40a40, pass=, file_name=0xa1c9e0 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0flu.c", line=1292) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000826aae in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 buf_flush_page (flush_type=, bpage=, buf_pool=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0flu.c:1291 #8 buf_flush_try_neighbors (n_to_flush=, n_flushed=, flush_type=, offset=, space=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0flu.c:1461 #9 buf_flush_page_and_try_neighbors (bpage=, flush_type=BUF_FLUSH_LIST, n_to_flush=200, count=0x7fdcb96eec58) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0flu.c:1527 #10 0x0000000000826f78 in buf_flush_flush_list_batch (lsn_limit=, min_n=, buf_pool=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0flu.c:1649 #11 buf_flush_batch (buf_pool=0x3317308, flush_type=, min_n=200, lsn_limit=18446744073709551615) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0flu.c:1731 #12 0x0000000000827377 in buf_flush_list (min_n=200, lsn_limit=18446744073709551615) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0flu.c:1957 #13 0x00000000007d8b2f in srv_master_thread (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0srv.c:2843 #14 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #15 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 33 (Thread 0x7fdccc274710 (LWP 7463)): #0 0x00000030e180f1e5 in sigwait () from /lib64/libpthread.so.0 #1 0x00000000004ff1bb in signal_hand (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/mysqld.cc:2702 #2 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #3 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 32 (Thread 0x7fdccc1f2710 (LWP 7482)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=23) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=390, rw_latch=1, guess=0x0, mode=10, file=0xa1b350 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c", line=420, mtr=0x7fdccc1ef700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x0000000000813de6 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0btr.ic:55 #9 btr_pcur_move_to_next_page (cursor=0x7fdc88019848, mtr=0x7fdccc1ef700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c:419 #10 0x00000000007cab90 in btr_pcur_move_to_next (cursor=0x33177c4, mtr=0x80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:360 #11 0x00000000007cb27b in row_search_for_mysql (buf=0x7fdc880195f0 "", mode=1, prebuilt=0x7fdc8801a6e8, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4545 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc880193f0, buf=0x7fdc880195f0 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdcac005e98) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdcac0263b0, join_tab=0x7fdcac005e18, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdcac0263b0, fields=0x373c1b0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdcac0263b0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x373a0a0, rref_pointer_array=0x373c278, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdcac0054d8, unit=0x373ba88, select_lex=0x373c0a8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x373a0a0, lex=0x373b9d8, result=0x7fdcac0054d8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x373a0a0, all_tables=0x7fdcac004bd0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x373a0a0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x373a0a0, rawbuf=, length=, parser_state=0x7fdccc1f1ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x373a0a0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 31 (Thread 0x7fdccc233710 (LWP 7484)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=2) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=410, rw_latch=1, guess=0x0, mode=10, file=0xa1b350 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c", line=420, mtr=0x7fdccc230700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x0000000000813de6 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0btr.ic:55 #9 btr_pcur_move_to_next_page (cursor=0x7fdca401f928, mtr=0x7fdccc230700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c:419 #10 0x00000000007cab90 in btr_pcur_move_to_next (cursor=0x33177c4, mtr=0x80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:360 #11 0x00000000007cb27b in row_search_for_mysql (buf=0x7fdca4022110 "\334\006\071\061\070\063\060\064", ' ' , "\004\070\070\062\065", ' ' , mode=1, prebuilt=0x7fdca4022368, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4545 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdca4021f10, buf=0x7fdca4022110 "\334\006\071\061\070\063\060\064", ' ' , "\004\070\070\062\065", ' ' , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdcb0005f08) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdcb0020b80, join_tab=0x7fdcb0005e88, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdcb0020b80, fields=0x377ee00, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdcb0020b80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x377ccf0, rref_pointer_array=0x377eec8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdcb0005548, unit=0x377e6d8, select_lex=0x377ecf8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x377ccf0, lex=0x377e628, result=0x7fdcb0005548, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x377ccf0, all_tables=0x7fdcb0004c40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x377ccf0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x377ccf0, rawbuf=, length=, parser_state=0x7fdccc232ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x377ccf0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 30 (Thread 0x7fdccc1b1710 (LWP 7486)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=13) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x3677d58, pass=, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1279) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000818228 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd58800, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1279 #8 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdc8c00c028) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #9 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #10 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdc8c00c2b8, mode=4, latch_mode=1, cursor=0x7fdc8c00c028, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdccc1ae700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #11 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #12 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #13 row_search_for_mysql (buf=0x7fdc8c0086c0 "\236\006\065\065\071\070\060\065", ' ' , "\006\071\070\065\060\065\061", ' ' , mode=1, prebuilt=0x7fdc8c00bc48, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #14 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc8c0084c0, buf=0x7fdc8c0086c0 "\236\006\065\065\071\070\060\065", ' ' , "\006\071\070\065\060\065\061", ' ' , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #15 0x000000000059141d in join_read_next (info=0x7fdca4005f08) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #16 0x0000000000597229 in sub_select (join=0x7fdca4025060, join_tab=0x7fdca4005e88, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #17 0x000000000059ca4d in do_select (join=0x7fdca4025060, fields=0x3785ba0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #18 0x00000000005b0505 in JOIN::exec (this=0x7fdca4025060) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #19 0x00000000005ac253 in mysql_select (thd=0x3783a90, rref_pointer_array=0x3785c68, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdca4005548, unit=0x3785478, select_lex=0x3785a98) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #20 0x00000000005b1fb9 in handle_select (thd=0x3783a90, lex=0x37853c8, result=0x7fdca4005548, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #21 0x00000000005703d1 in execute_sqlcom_select (thd=0x3783a90, all_tables=0x7fdca4004c40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #22 0x00000000005759ff in mysql_execute_command (thd=0x3783a90) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #23 0x0000000000577dea in mysql_parse (thd=0x3783a90, rawbuf=, length=, parser_state=0x7fdccc1b0ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #24 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x3783a90, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #25 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #26 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #27 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #28 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 29 (Thread 0x7fdcabfff710 (LWP 7488)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=6) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x3677d58, pass=, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1279) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000818228 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd58800, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1279 #8 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdc800088b8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #9 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #10 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdc8000c5a8, mode=4, latch_mode=1, cursor=0x7fdc800088b8, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcabffc700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #11 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #12 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #13 row_search_for_mysql (buf=0x7fdc80009e20 "", mode=1, prebuilt=0x7fdc800084d8, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #14 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc80009c20, buf=0x7fdc80009e20 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #15 0x000000000059141d in join_read_next (info=0x7fdca0005f08) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #16 0x0000000000597229 in sub_select (join=0x7fdca001d6b0, join_tab=0x7fdca0005e88, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #17 0x000000000059ca4d in do_select (join=0x7fdca001d6b0, fields=0x378c940, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #18 0x00000000005b0505 in JOIN::exec (this=0x7fdca001d6b0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #19 0x00000000005ac253 in mysql_select (thd=0x378a830, rref_pointer_array=0x378ca08, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdca0005548, unit=0x378c218, select_lex=0x378c838) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #20 0x00000000005b1fb9 in handle_select (thd=0x378a830, lex=0x378c168, result=0x7fdca0005548, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #21 0x00000000005703d1 in execute_sqlcom_select (thd=0x378a830, all_tables=0x7fdca0004c40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #22 0x00000000005759ff in mysql_execute_command (thd=0x378a830) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #23 0x0000000000577dea in mysql_parse (thd=0x378a830, rawbuf=, length=, parser_state=0x7fdcabffeae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #24 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x378a830, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #25 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #26 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #27 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #28 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 28 (Thread 0x7fdccc170710 (LWP 7490)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=19) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0xa0f0c0 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic", line=552, mtr=0x7fdccc16d6c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080bdb4 in btr_cur_open_at_index_side_func (from_left=1, index=0x7fdcac00da88, latch_mode=1, cursor=0x7fdcc800bb68, file=0xa0f0c0 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic", line=552, mtr=0x7fdccc16d6c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:865 #9 0x00000000007c83ea in btr_pcur_open_at_index_side (from_left=53573572, index=0x80, latch_mode=5750666, pcur=0x7fdcc800bb68, do_init=, mtr=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:551 #10 0x00000000007cd31d in row_search_for_mysql (buf=0x7fdcc800b1b0 "\006\006\065\064\060\065\062\065", ' ' , "\006\071\071\071\071\065\061", ' ' , mode=1, prebuilt=0x7fdcc800b8f8, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:3841 #11 0x00000000007a9c37 in ha_innobase::index_read (this=0x7fdcc800afb0, buf=0x7fdcc800b1b0 "\006\006\065\064\060\065\062\065", ' ' , "\006\071\071\071\071\065\061", ' ' , key_ptr=, key_len=0, find_flag=HA_READ_AFTER_KEY) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5709 #12 0x00000000007a70d9 in ha_innobase::index_first (this=0x7fdcc800afb0, buf=0x7fdcc800b1b0 "\006\006\065\064\060\065\062\065", ' ' , "\006\071\071\071\071\065\061", ' ' ) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:6011 #13 0x000000000059e5e2 in join_read_first (tab=0x7fdc98006498) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12473 #14 0x0000000000597216 in sub_select (join=0x7fdc98017d50, join_tab=0x80, end_of_records=138) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11700 #15 0x000000000059ca4d in do_select (join=0x7fdc98017d50, fields=0x37936e0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc98017d50) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x37915d0, rref_pointer_array=0x37937a8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc98005998, unit=0x3792fb8, select_lex=0x37935d8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x37915d0, lex=0x3792f08, result=0x7fdc98005998, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x37915d0, all_tables=0x7fdc98004c50) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x37915d0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x37915d0, rawbuf=, length=, parser_state=0x7fdccc16fae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37915d0, packet=, packet_length=40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 27 (Thread 0x7fdccc12f710 (LWP 7492)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=11) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x3677d58, pass=, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1279) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000818228 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd58800, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1279 #8 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdcac00d8c8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #9 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #10 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdcac00e5d8, mode=4, latch_mode=1, cursor=0x7fdcac00d8c8, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdccc12c700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #11 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #12 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #13 row_search_for_mysql (buf=0x7fdcac009b90 "", mode=1, prebuilt=0x7fdcac00e248, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #14 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdcac009990, buf=0x7fdcac009b90 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #15 0x000000000059141d in join_read_next (info=0x7fdc9c006518) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #16 0x0000000000597229 in sub_select (join=0x7fdc9c01d400, join_tab=0x7fdc9c006498, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #17 0x000000000059ca4d in do_select (join=0x7fdc9c01d400, fields=0x379a480, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #18 0x00000000005b0505 in JOIN::exec (this=0x7fdc9c01d400) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #19 0x00000000005ac253 in mysql_select (thd=0x3798370, rref_pointer_array=0x379a548, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc9c005998, unit=0x3799d58, select_lex=0x379a378) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #20 0x00000000005b1fb9 in handle_select (thd=0x3798370, lex=0x3799ca8, result=0x7fdc9c005998, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #21 0x00000000005703d1 in execute_sqlcom_select (thd=0x3798370, all_tables=0x7fdc9c004c50) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #22 0x00000000005759ff in mysql_execute_command (thd=0x3798370) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #23 0x0000000000577dea in mysql_parse (thd=0x3798370, rawbuf=, length=, parser_state=0x7fdccc12eae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #24 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x3798370, packet=, packet_length=40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #25 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #26 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #27 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #28 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 26 (Thread 0x7fdccc0ee710 (LWP 7494)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=24) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0xa0f0c0 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic", line=552, mtr=0x7fdccc0eb6c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080bdb4 in btr_cur_open_at_index_side_func (from_left=1, index=0x7fdcac00da88, latch_mode=1, cursor=0x7fdc900183c8, file=0xa0f0c0 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic", line=552, mtr=0x7fdccc0eb6c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:865 #9 0x00000000007c83ea in btr_pcur_open_at_index_side (from_left=53573572, index=0x80, latch_mode=5750666, pcur=0x7fdc900183c8, do_init=, mtr=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:551 #10 0x00000000007cd31d in row_search_for_mysql (buf=0x7fdc90017a10 "", mode=1, prebuilt=0x7fdc90018158, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:3841 #11 0x00000000007a9c37 in ha_innobase::index_read (this=0x7fdc90017810, buf=0x7fdc90017a10 "", key_ptr=, key_len=0, find_flag=HA_READ_AFTER_KEY) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5709 #12 0x00000000007a70d9 in ha_innobase::index_first (this=0x7fdc90017810, buf=0x7fdc90017a10 "") at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:6011 #13 0x000000000059e5e2 in join_read_first (tab=0x7fdc90005e88) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12473 #14 0x0000000000597216 in sub_select (join=0x7fdc9001ab80, join_tab=0x80, end_of_records=138) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11700 #15 0x000000000059ca4d in do_select (join=0x7fdc9001ab80, fields=0x37a1220, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc9001ab80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x379f110, rref_pointer_array=0x37a12e8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc90005548, unit=0x37a0af8, select_lex=0x37a1118) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x379f110, lex=0x37a0a48, result=0x7fdc90005548, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x379f110, all_tables=0x7fdc90004c40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x379f110) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x379f110, rawbuf=, length=, parser_state=0x7fdccc0edae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x379f110, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7fdccc0ad710 (LWP 7496)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=20) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=385, rw_latch=1, guess=0x0, mode=10, file=0xa1b350 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c", line=420, mtr=0x7fdccc0aa700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x0000000000813de6 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0btr.ic:55 #9 btr_pcur_move_to_next_page (cursor=0x7fdca0008d48, mtr=0x7fdccc0aa700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c:419 #10 0x00000000007cab90 in btr_pcur_move_to_next (cursor=0x33177c4, mtr=0x80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:360 #11 0x00000000007cb27b in row_search_for_mysql (buf=0x7fdca0009f70 "d\006\070\070\071\067\071\065", ' ' , "\006\065\062\061\070\070\061", ' ' , mode=1, prebuilt=0x7fdca000a1c8, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4545 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdca0009d70, buf=0x7fdca0009f70 "d\006\070\070\071\067\071\065", ' ' , "\006\065\062\061\070\070\061", ' ' , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdc94005f08) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdc94019760, join_tab=0x7fdc94005e88, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdc94019760, fields=0x37a7fc0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc94019760) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x37a5eb0, rref_pointer_array=0x37a8088, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc94005548, unit=0x37a7898, select_lex=0x37a7eb8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x37a5eb0, lex=0x37a77e8, result=0x7fdc94005548, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x37a5eb0, all_tables=0x7fdc94004c40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x37a5eb0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x37a5eb0, rawbuf=, length=, parser_state=0x7fdccc0acae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37a5eb0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7fdccc06c710 (LWP 7498)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=3, rw_latch=3, guess=0x7fdcbfd1d280, mode=10, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdccc069700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080aa35 in btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdcb0023ff8, mode=4, latch_mode=1, cursor=0x7fdcb0023d68, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdccc069700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:586 #9 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #10 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #11 row_search_for_mysql (buf=0x7fdcb0020440 "", mode=1, prebuilt=0x7fdcb0023988, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdcb0020240, buf=0x7fdcb0020440 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdc88005f08) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdc8801bf40, join_tab=0x7fdc88005e88, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdc8801bf40, fields=0x37aed60, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc8801bf40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x37acc50, rref_pointer_array=0x37aee28, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc88005548, unit=0x37ae638, select_lex=0x37aec58) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x37acc50, lex=0x37ae588, result=0x7fdc88005548, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x37acc50, all_tables=0x7fdc88004c40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x37acc50) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x37acc50, rawbuf=, length=, parser_state=0x7fdccc06bae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37acc50, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7fdcb8abb710 (LWP 7500)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=22) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=384, rw_latch=1, guess=0x0, mode=10, file=0xa1b350 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c", line=420, mtr=0x7fdcb8ab8700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x0000000000813de6 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0btr.ic:55 #9 btr_pcur_move_to_next_page (cursor=0x7fdc9c016a88, mtr=0x7fdcb8ab8700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c:419 #10 0x00000000007cab90 in btr_pcur_move_to_next (cursor=0x33177c4, mtr=0x80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:360 #11 0x00000000007cb27b in row_search_for_mysql (buf=0x7fdc9c016830 "", mode=1, prebuilt=0x7fdc9c018008, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4545 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc9c016630, buf=0x7fdc9c016830 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdc8c006518) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdc8c014b90, join_tab=0x7fdc8c006498, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdc8c014b90, fields=0x37b5b00, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc8c014b90) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x37b39f0, rref_pointer_array=0x37b5bc8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc8c005998, unit=0x37b53d8, select_lex=0x37b59f8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x37b39f0, lex=0x37b5328, result=0x7fdc8c005998, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x37b39f0, all_tables=0x7fdc8c004c50) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x37b39f0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x37b39f0, rawbuf=, length=, parser_state=0x7fdcb8abaae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37b39f0, packet=, packet_length=40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7fdcb8a7a710 (LWP 7502)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=5) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0e58 in rw_lock_x_lock_func (lock=0x3677d58, pass=0, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1385) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:702 #5 0x0000000000819045 in pfs_rw_lock_x_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:692 #6 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd56280, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1385 #7 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdca4011a18) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #8 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #9 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdca4011ca8, mode=4, latch_mode=1, cursor=0x7fdca4011a18, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb8a77700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #10 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #11 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #12 row_search_for_mysql (buf=0x7fdca4011160 "\376\006\067\060\064\062\065\066", ' ' , "\006\071\061\062\060\067\063", ' ' "\337, \355lr\030J\006\227\336\064B\201\212J\006\232\310\067F\201\212K\b\235\310\067F\201\212\071+\255\237\033J~\212Y\223\341\376\t@~\212B\273", , mode=1, prebuilt=0x7fdca40117a8, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #13 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdca4010f60, buf=0x7fdca4011160 "\376\006\067\060\064\062\065\066", ' ' , "\006\071\061\062\060\067\063", ' ' "\337, \355lr\030J\006\227\336\064B\201\212J\006\232\310\067F\201\212K\b\235\310\067F\201\212\071+\255\237\033J~\212Y\223\341\376\t@~\212B\273", , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #14 0x000000000059141d in join_read_next (info=0x7fdc80005f08) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #15 0x0000000000597229 in sub_select (join=0x7fdc8001b230, join_tab=0x7fdc80005e88, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #16 0x000000000059ca4d in do_select (join=0x7fdc8001b230, fields=0x37bc8a0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #17 0x00000000005b0505 in JOIN::exec (this=0x7fdc8001b230) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #18 0x00000000005ac253 in mysql_select (thd=0x37ba790, rref_pointer_array=0x37bc968, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc80005548, unit=0x37bc178, select_lex=0x37bc798) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #19 0x00000000005b1fb9 in handle_select (thd=0x37ba790, lex=0x37bc0c8, result=0x7fdc80005548, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #20 0x00000000005703d1 in execute_sqlcom_select (thd=0x37ba790, all_tables=0x7fdc80004c40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #21 0x00000000005759ff in mysql_execute_command (thd=0x37ba790) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #22 0x0000000000577dea in mysql_parse (thd=0x37ba790, rawbuf=, length=, parser_state=0x7fdcb8a79ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #23 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37ba790, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #24 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #25 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #26 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #27 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7fdcb8a39710 (LWP 7504)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=14) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x3677d58, pass=, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1279) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000818228 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd58800, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1279 #8 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdcb000b058) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #9 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #10 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdcb000b2e8, mode=4, latch_mode=1, cursor=0x7fdcb000b058, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb8a36700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #11 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #12 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #13 row_search_for_mysql (buf=0x7fdcb000a530 "", mode=1, prebuilt=0x7fdcb000ac78, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #14 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdcb000a330, buf=0x7fdcb000a530 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #15 0x000000000059141d in join_read_next (info=0x7fdc84006568) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #16 0x0000000000597229 in sub_select (join=0x7fdc84008950, join_tab=0x7fdc840064e8, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #17 0x000000000059ca4d in do_select (join=0x7fdc84008950, fields=0x37c3640, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #18 0x00000000005b0505 in JOIN::exec (this=0x7fdc84008950) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #19 0x00000000005ac253 in mysql_select (thd=0x37c1530, rref_pointer_array=0x37c3708, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc840059c0, unit=0x37c2f18, select_lex=0x37c3538) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #20 0x00000000005b1fb9 in handle_select (thd=0x37c1530, lex=0x37c2e68, result=0x7fdc840059c0, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #21 0x00000000005703d1 in execute_sqlcom_select (thd=0x37c1530, all_tables=0x7fdc84004c50) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #22 0x00000000005759ff in mysql_execute_command (thd=0x37c1530) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #23 0x0000000000577dea in mysql_parse (thd=0x37c1530, rawbuf=, length=, parser_state=0x7fdcb8a38ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #24 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37c1530, packet=, packet_length=41) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #25 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #26 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #27 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #28 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7fdcb89f8710 (LWP 7506)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=9) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x3677d58, pass=, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1279) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000818228 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd58800, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1279 #8 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdca400fd78) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #9 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #10 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdca4016c68, mode=4, latch_mode=1, cursor=0x7fdca400fd78, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb89f5700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #11 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #12 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #13 row_search_for_mysql (buf=0x7fdca4013640 "(\003\067\071\070", ' ' , "\006\071\062\066\061\063\060", ' ' , "?\225\370\244\226P\212*,\225\373\244\226Q\214-,\225\373\244\226W\362wH\344\340\215\226\215y\303\313ݬ}\030\216q\300\313ݬ}\030E\260\256\025\225l\215\226\270\066\001\244\334\177", mode=1, prebuilt=0x7fdca4013d88, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #14 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdca4013440, buf=0x7fdca4013640 "(\003\067\071\070", ' ' , "\006\071\062\066\061\063\060", ' ' , "?\225\370\244\226P\212*,\225\373\244\226Q\214-,\225\373\244\226W\362wH\344\340\215\226\215y\303\313ݬ}\030\216q\300\313ݬ}\030E\260\256\025\225l\215\226\270\066\001\244\334\177", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #15 0x000000000059141d in join_read_next (info=0x7fdc78005f08) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #16 0x0000000000597229 in sub_select (join=0x7fdc78032a50, join_tab=0x7fdc78005e88, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #17 0x000000000059ca4d in do_select (join=0x7fdc78032a50, fields=0x37cab10, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #18 0x00000000005b0505 in JOIN::exec (this=0x7fdc78032a50) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #19 0x00000000005ac253 in mysql_select (thd=0x37c8a00, rref_pointer_array=0x37cabd8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc78005548, unit=0x37ca3e8, select_lex=0x37caa08) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #20 0x00000000005b1fb9 in handle_select (thd=0x37c8a00, lex=0x37ca338, result=0x7fdc78005548, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #21 0x00000000005703d1 in execute_sqlcom_select (thd=0x37c8a00, all_tables=0x7fdc78004c40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #22 0x00000000005759ff in mysql_execute_command (thd=0x37c8a00) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #23 0x0000000000577dea in mysql_parse (thd=0x37c8a00, rawbuf=, length=, parser_state=0x7fdcb89f7ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #24 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37c8a00, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #25 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #26 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #27 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #28 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7fdcb89b7710 (LWP 7508)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=27) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=529, rw_latch=1, guess=0x0, mode=10, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb89b4700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080aa35 in btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdcac0257f8, mode=4, latch_mode=1, cursor=0x7fdcac025568, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb89b4700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:586 #9 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #10 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #11 row_search_for_mysql (buf=0x7fdcac024b40 "n\006\071\064\060\063\071\066", ' ' , "\006\070\071\064\071\061\064", ' ' , mode=1, prebuilt=0x7fdcac025188, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdcac024940, buf=0x7fdcac024b40 "n\006\071\064\060\063\071\066", ' ' , "\006\070\071\064\071\061\064", ' ' , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x37dce88) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x37f21f0, join_tab=0x37dce08, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x37f21f0, fields=0x37d1fe0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x37f21f0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x37cfed0, rref_pointer_array=0x37d20a8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x37dc308, unit=0x37d18b8, select_lex=0x37d1ed8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x37cfed0, lex=0x37d1808, result=0x37dc308, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x37cfed0, all_tables=0x37db5c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x37cfed0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x37cfed0, rawbuf=, length=, parser_state=0x7fdcb89b6ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37cfed0, packet=, packet_length=40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7fdcb8976710 (LWP 7510)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=4) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x3677d58, pass=, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1279) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000818228 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd58800, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1279 #8 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdc98010348) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #9 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #10 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdc9801be38, mode=4, latch_mode=1, cursor=0x7fdc98010348, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb8973700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #11 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #12 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #13 row_search_for_mysql (buf=0x7fdc9800f920 "\006\006\063\070\071\060\060\062", ' ' , "\005\065\064\060\071\066", ' ' , mode=1, prebuilt=0x7fdc9800ff68, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #14 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc9800f720, buf=0x7fdc9800f920 "\006\006\063\070\071\060\060\062", ' ' , "\005\065\064\060\071\066", ' ' , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #15 0x000000000059141d in join_read_next (info=0x7fdc78013ab8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #16 0x0000000000597229 in sub_select (join=0x7fdc78034a40, join_tab=0x7fdc78013a38, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #17 0x000000000059ca4d in do_select (join=0x7fdc78034a40, fields=0x37e64a0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #18 0x00000000005b0505 in JOIN::exec (this=0x7fdc78034a40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #19 0x00000000005ac253 in mysql_select (thd=0x37e4390, rref_pointer_array=0x37e6568, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc78012f38, unit=0x37e5d78, select_lex=0x37e6398) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #20 0x00000000005b1fb9 in handle_select (thd=0x37e4390, lex=0x37e5cc8, result=0x7fdc78012f38, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #21 0x00000000005703d1 in execute_sqlcom_select (thd=0x37e4390, all_tables=0x7fdc780121f0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #22 0x00000000005759ff in mysql_execute_command (thd=0x37e4390) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #23 0x0000000000577dea in mysql_parse (thd=0x37e4390, rawbuf=, length=, parser_state=0x7fdcb8975ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #24 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37e4390, packet=, packet_length=40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #25 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #26 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #27 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #28 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7fdcb8935710 (LWP 7512)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=26) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=470, rw_latch=1, guess=0x0, mode=10, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb8932700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080aa35 in btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdc8800c258, mode=4, latch_mode=1, cursor=0x7fdc8800bfc8, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb8932700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:586 #9 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #10 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #11 row_search_for_mysql (buf=0x7fdc88008610 "", mode=1, prebuilt=0x7fdc8800bbe8, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc88008410, buf=0x7fdc88008610 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdc840106b8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdc84017bc0, join_tab=0x7fdc84010638, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdc84017bc0, fields=0x37ed240, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc84017bc0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x37eb130, rref_pointer_array=0x37ed308, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc8400fb10, unit=0x37ecb18, select_lex=0x37ed138) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x37eb130, lex=0x37eca68, result=0x7fdc8400fb10, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x37eb130, all_tables=0x7fdc8400eda0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x37eb130) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x37eb130, rawbuf=, length=, parser_state=0x7fdcb8934ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37eb130, packet=, packet_length=41) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7fdcb88f4710 (LWP 7514)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=3) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=3, rw_latch=3, guess=0x7fdcbfd1d280, mode=10, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb88f1700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080aa35 in btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdc9800d2d8, mode=4, latch_mode=1, cursor=0x7fdc9800d048, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb88f1700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:586 #9 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #10 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #11 row_search_for_mysql (buf=0x7fdc9800c890 "", mode=1, prebuilt=0x7fdc980089f8, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc9800c690, buf=0x7fdc9800c890 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdc80011e38) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdc800179b0, join_tab=0x7fdc80011db8, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdc800179b0, fields=0x37f62e0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc800179b0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x37f41d0, rref_pointer_array=0x37f63a8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc80011478, unit=0x37f5bb8, select_lex=0x37f61d8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x37f41d0, lex=0x37f5b08, result=0x7fdc80011478, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x37f41d0, all_tables=0x7fdc80010b70) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x37f41d0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x37f41d0, rawbuf=, length=, parser_state=0x7fdcb88f3ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37f41d0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7fdcb88b3710 (LWP 7516)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=1) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0xa0f0c0 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic", line=552, mtr=0x7fdcb88b06c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080bdb4 in btr_cur_open_at_index_side_func (from_left=1, index=0x7fdcac00da88, latch_mode=1, cursor=0x7fdcb0010408, file=0xa0f0c0 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic", line=552, mtr=0x7fdcb88b06c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:865 #9 0x00000000007c83ea in btr_pcur_open_at_index_side (from_left=53573572, index=0x80, latch_mode=5750666, pcur=0x7fdcb0010408, do_init=, mtr=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:551 #10 0x00000000007cd31d in row_search_for_mysql (buf=0x7fdcb0011440 "\376\006\071\060\067\070\066\063", mode=1, prebuilt=0x7fdcb0016208, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:3841 #11 0x00000000007a9c37 in ha_innobase::index_read (this=0x7fdcb0011240, buf=0x7fdcb0011440 "\376\006\071\060\067\070\066\063", key_ptr=, key_len=0, find_flag=HA_READ_AFTER_KEY) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5709 #12 0x00000000007a70d9 in ha_innobase::index_first (this=0x7fdcb0011240, buf=0x7fdcb0011440 "\376\006\071\060\067\070\066\063") at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:6011 #13 0x000000000059e5e2 in join_read_first (tab=0x7fdc8c0140c8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12473 #14 0x0000000000597216 in sub_select (join=0x7fdc8c016b80, join_tab=0x80, end_of_records=138) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11700 #15 0x000000000059ca4d in do_select (join=0x7fdc8c016b80, fields=0x37fd080, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc8c016b80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x37faf70, rref_pointer_array=0x37fd148, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc8c0135c8, unit=0x37fc958, select_lex=0x37fcf78) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x37faf70, lex=0x37fc8a8, result=0x7fdc8c0135c8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x37faf70, all_tables=0x7fdc8c012880) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x37faf70) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x37faf70, rawbuf=, length=, parser_state=0x7fdcb88b2ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x37faf70, packet=, packet_length=40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7fdcb8872710 (LWP 7518)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=18) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x3677d58, pass=, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1279) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000818228 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd58800, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1279 #8 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdcb0013318) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #9 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #10 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdcb00135a8, mode=4, latch_mode=1, cursor=0x7fdcb0013318, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb886f700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #11 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #12 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #13 row_search_for_mysql (buf=0x7fdcb0011cd0 "\\\006\061\065\061\071\061\065", ' ' , "\006\070\065\065\063\065\063", ' ' , mode=1, prebuilt=0x7fdcb000f748, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #14 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdcb0011ad0, buf=0x7fdcb0011cd0 "\\\006\061\065\061\071\061\065", ' ' , "\006\070\065\065\063\065\063", ' ' , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #15 0x000000000059141d in join_read_next (info=0x7fdc88014d58) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #16 0x0000000000597229 in sub_select (join=0x7fdc88017400, join_tab=0x7fdc88014cd8, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #17 0x000000000059ca4d in do_select (join=0x7fdc88017400, fields=0x3803e20, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #18 0x00000000005b0505 in JOIN::exec (this=0x7fdc88017400) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #19 0x00000000005ac253 in mysql_select (thd=0x3801d10, rref_pointer_array=0x3803ee8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc88014398, unit=0x38036f8, select_lex=0x3803d18) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #20 0x00000000005b1fb9 in handle_select (thd=0x3801d10, lex=0x3803648, result=0x7fdc88014398, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #21 0x00000000005703d1 in execute_sqlcom_select (thd=0x3801d10, all_tables=0x7fdc88013a90) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #22 0x00000000005759ff in mysql_execute_command (thd=0x3801d10) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #23 0x0000000000577dea in mysql_parse (thd=0x3801d10, rawbuf=, length=, parser_state=0x7fdcb8871ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #24 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x3801d10, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #25 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #26 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #27 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #28 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7fdcb8831710 (LWP 7520)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=30) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=429, rw_latch=1, guess=0x0, mode=10, file=0xa1b350 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c", line=420, mtr=0x7fdcb882e700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x0000000000813de6 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0btr.ic:55 #9 btr_pcur_move_to_next_page (cursor=0x7fdca000c118, mtr=0x7fdcb882e700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c:419 #10 0x00000000007cab90 in btr_pcur_move_to_next (cursor=0x33177c4, mtr=0x80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:360 #11 0x00000000007cb27b in row_search_for_mysql (buf=0x7fdca000a650 "\334\006\071\067\070\061\065\064", ' ' , "\006\062\070\067\062\071\071", ' ' , mode=1, prebuilt=0x7fdca000bea8, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4545 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdca000a450, buf=0x7fdca000a650 "\334\006\071\067\070\061\065\064", ' ' , "\006\062\070\067\062\071\071", ' ' , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdc94013ab8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdc94017770, join_tab=0x7fdc94013a38, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdc94017770, fields=0x380abc0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc94017770) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x3808ab0, rref_pointer_array=0x380ac88, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc940130f8, unit=0x380a498, select_lex=0x380aab8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x3808ab0, lex=0x380a3e8, result=0x7fdc940130f8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x3808ab0, all_tables=0x7fdc940127f0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x3808ab0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x3808ab0, rawbuf=, length=, parser_state=0x7fdcb8830ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x3808ab0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7fdcb87f0710 (LWP 7522)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=10) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x3677d58, pass=, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1279) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000818228 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd5b800, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1279 #8 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdc8001abd8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #9 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #10 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdc8001ae68, mode=4, latch_mode=1, cursor=0x7fdc8001abd8, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb87ed700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #11 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #12 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #13 row_search_for_mysql (buf=0x7fdc80016340 "8\006\067\063\067\064\066\065", ' ' , "\006\071\065\063\061\064\064", ' ' , "\177\034\360\224\221Rz\235s\034\360\224\221Sz\236s\034\360\224\221Un\234s\034\360\224\221X\250\257e\034\360\224\221I\213:m!\360\224\221V\027̂!\360\224\221\270c\001\200\334\177", mode=1, prebuilt=0x7fdc80017528, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #14 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc80016140, buf=0x7fdc80016340 "8\006\067\063\067\064\066\065", ' ' , "\006\071\065\063\061\064\064", ' ' , "\177\034\360\224\221Rz\235s\034\360\224\221Sz\236s\034\360\224\221Un\234s\034\360\224\221X\250\257e\034\360\224\221I\213:m!\360\224\221V\027̂!\360\224\221\270c\001\200\334\177", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #15 0x000000000059141d in join_read_next (info=0x7fdc90013f38) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #16 0x0000000000597229 in sub_select (join=0x7fdc90018b90, join_tab=0x7fdc90013eb8, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #17 0x000000000059ca4d in do_select (join=0x7fdc90018b90, fields=0x3811c70, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #18 0x00000000005b0505 in JOIN::exec (this=0x7fdc90018b90) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #19 0x00000000005ac253 in mysql_select (thd=0x380fb60, rref_pointer_array=0x3811d38, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc90013578, unit=0x3811548, select_lex=0x3811b68) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #20 0x00000000005b1fb9 in handle_select (thd=0x380fb60, lex=0x3811498, result=0x7fdc90013578, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #21 0x00000000005703d1 in execute_sqlcom_select (thd=0x380fb60, all_tables=0x7fdc90012c70) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #22 0x00000000005759ff in mysql_execute_command (thd=0x380fb60) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #23 0x0000000000577dea in mysql_parse (thd=0x380fb60, rawbuf=, length=, parser_state=0x7fdcb87efae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #24 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x380fb60, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #25 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #26 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #27 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #28 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7fdcb87af710 (LWP 7524)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=31) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=418, rw_latch=1, guess=0x0, mode=10, file=0xa1b350 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c", line=420, mtr=0x7fdcb87ac700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x0000000000813de6 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0btr.ic:55 #9 btr_pcur_move_to_next_page (cursor=0x7fdc78017ca8, mtr=0x7fdcb87ac700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c:419 #10 0x00000000007cab90 in btr_pcur_move_to_next (cursor=0x33177c4, mtr=0x80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:360 #11 0x00000000007cb27b in row_search_for_mysql (buf=0x7fdc780172f0 "", mode=1, prebuilt=0x7fdc78017a38, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4545 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc780170f0, buf=0x7fdc780172f0 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdc9c012588) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdc9c01f5b0, join_tab=0x7fdc9c012508, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdc9c01f5b0, fields=0x38196f0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc9c01f5b0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x38175e0, rref_pointer_array=0x38197b8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc9c011bc8, unit=0x3818fc8, select_lex=0x38195e8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x38175e0, lex=0x3818f18, result=0x7fdc9c011bc8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x38175e0, all_tables=0x7fdc9c0112c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x38175e0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x38175e0, rawbuf=, length=, parser_state=0x7fdcb87aeae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x38175e0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7fdcb876e710 (LWP 7526)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=21) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=418, rw_latch=1, guess=0x0, mode=10, file=0xa1b350 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c", line=420, mtr=0x7fdcb876b700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x0000000000813de6 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0btr.ic:55 #9 btr_pcur_move_to_next_page (cursor=0x37e13f8, mtr=0x7fdcb876b700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c:419 #10 0x00000000007cab90 in btr_pcur_move_to_next (cursor=0x33177c4, mtr=0x80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:360 #11 0x00000000007cb27b in row_search_for_mysql (buf=0x37d2e70 "L\006\063\062\060\064\064\063", ' ' , "\006\066\066\064\063\071\070", ' ' , mode=1, prebuilt=0x37e1188, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4545 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x37d2c70, buf=0x37d2e70 "L\006\063\062\060\064\064\063", ' ' , "\006\066\066\064\063\071\070", ' ' , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdc98015c18) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdc9801e340, join_tab=0x7fdc98015b98, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdc9801e340, fields=0x3820bc0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdc9801e340) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x381eab0, rref_pointer_array=0x3820c88, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdc98015258, unit=0x3820498, select_lex=0x3820ab8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x381eab0, lex=0x38203e8, result=0x7fdc98015258, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x381eab0, all_tables=0x7fdc98014950) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x381eab0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x381eab0, rawbuf=, length=, parser_state=0x7fdcb876dae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x381eab0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7fdcb872d710 (LWP 7528)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=29) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=3, rw_latch=3, guess=0x7fdcbfd1d280, mode=10, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb872a700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080aa35 in btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdc9c00c1e8, mode=4, latch_mode=1, cursor=0x7fdc9c00bf58, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb872a700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:586 #9 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #10 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #11 row_search_for_mysql (buf=0x7fdc9c0086d0 "", mode=1, prebuilt=0x7fdc9c00bb78, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc9c0084d0, buf=0x7fdc9c0086d0 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdca0017158) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdca001b6c0, join_tab=0x7fdca00170d8, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdca001b6c0, fields=0x3828090, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdca001b6c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x3825f80, rref_pointer_array=0x3828158, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdca00165d8, unit=0x3827968, select_lex=0x3827f88) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x3825f80, lex=0x38278b8, result=0x7fdca00165d8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x3825f80, all_tables=0x7fdca0015890) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x3825f80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x3825f80, rawbuf=, length=, parser_state=0x7fdcb872cae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x3825f80, packet=, packet_length=40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7fdcb86ec710 (LWP 7530)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=16) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa177b8 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/buf0buf.ic", line=766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000883014 in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 buf_block_free (block=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/buf0buf.ic:766 #8 mem_heap_block_free (heap=0x36780d0, block=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/mem/mem0mem.c:515 #9 0x000000000085d9b0 in ha_remove_all_nodes_to_page (table=0x3678098, fold=, page=0x7fdcc0ac4000 "ޭ\276", ) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/ha/ha0ha.c:333 #10 0x0000000000817d55 in btr_search_drop_page_hash_index (block=0x7fdcbfd40980) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1155 #11 0x000000000081ca59 in buf_pool_drop_hash_index_instance (released_search_latch=, buf_pool=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:1407 #12 buf_pool_drop_hash_index () at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:1444 #13 0x000000000081619c in btr_search_disable () at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:224 #14 0x000000000057f995 in sys_var_pluginvar::global_update (this=0x2e92b10, thd=0x382d3f0, var=0x7fdca401d190) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_plugin.cc:2919 #15 0x00000000005105cb in sys_var::update (this=0x2e92b10, thd=0x382d3f0, var=0x7fdca401d190) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/set_var.cc:206 #16 0x00000000005118ba in set_var::update (this=0xfffffffffffffe00, thd=0x80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/set_var.cc:673 #17 0x0000000000510c29 in sql_set_variables (thd=0x382d3f0, var_list=0x382f920) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/set_var.cc:577 #18 0x0000000000576011 in mysql_execute_command (thd=0x382d3f0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:3039 #19 0x0000000000577dea in mysql_parse (thd=0x382d3f0, rawbuf=, length=, parser_state=0x7fdcb86ebae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #20 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x382d3f0, packet=, packet_length=39) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #21 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #22 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7fdcb86ab710 (LWP 7532)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=402, rw_latch=1, guess=0x0, mode=10, file=0xa1b350 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c", line=420, mtr=0x7fdcb86a8700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x0000000000813de6 in btr_block_get_func (mtr=, line=, file=, mode=, page_no=, zip_size=, space=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0btr.ic:55 #9 btr_pcur_move_to_next_page (cursor=0x7fdc7800aee8, mtr=0x7fdcb86a8700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0pcur.c:419 #10 0x00000000007cab90 in btr_pcur_move_to_next (cursor=0x33177c4, mtr=0x80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:360 #11 0x00000000007cb27b in row_search_for_mysql (buf=0x7fdc7800a530 "", mode=1, prebuilt=0x7fdc7800ac78, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4545 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc7800a330, buf=0x7fdc7800a530 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdcb001df88) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdcb0025330, join_tab=0x7fdcb001df08, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdcb0025330, fields=0x3836d00, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdcb0025330) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x3834bf0, rref_pointer_array=0x3836dc8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdcb001d5c8, unit=0x38365d8, select_lex=0x3836bf8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x3834bf0, lex=0x3836528, result=0x7fdcb001d5c8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x3834bf0, all_tables=0x7fdcb001ccc0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x3834bf0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x3834bf0, rawbuf=, length=, parser_state=0x7fdcb86aaae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x3834bf0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7fdcb866a710 (LWP 7534)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=15) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=4, rw_latch=3, guess=0x0, mode=10, file=0xa0f0c0 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic", line=552, mtr=0x7fdcb86676c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080bdb4 in btr_cur_open_at_index_side_func (from_left=1, index=0x7fdcac00da88, latch_mode=1, cursor=0x7fdc90008d78, file=0xa0f0c0 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic", line=552, mtr=0x7fdcb86676c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:865 #9 0x00000000007c83ea in btr_pcur_open_at_index_side (from_left=53573572, index=0x80, latch_mode=5750666, pcur=0x7fdc90008d78, do_init=, mtr=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:551 #10 0x00000000007cd31d in row_search_for_mysql (buf=0x7fdc9000bde0 "", mode=1, prebuilt=0x7fdc900084d8, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:3841 #11 0x00000000007a9c37 in ha_innobase::index_read (this=0x7fdc9000bbe0, buf=0x7fdc9000bde0 "", key_ptr=, key_len=0, find_flag=HA_READ_AFTER_KEY) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5709 #12 0x00000000007a70d9 in ha_innobase::index_first (this=0x7fdc9000bbe0, buf=0x7fdc9000bde0 "") at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:6011 #13 0x000000000059e5e2 in join_read_first (tab=0x7fdcac020508) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12473 #14 0x0000000000597216 in sub_select (join=0x7fdcac0283a0, join_tab=0x80, end_of_records=138) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11700 #15 0x000000000059ca4d in do_select (join=0x7fdcac0283a0, fields=0x383e050, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdcac0283a0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x383bf40, rref_pointer_array=0x383e118, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdcac01fbc8, unit=0x383d928, select_lex=0x383df48) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x383bf40, lex=0x383d878, result=0x7fdcac01fbc8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x383bf40, all_tables=0x7fdcac01f2c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x383bf40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x383bf40, rawbuf=, length=, parser_state=0x7fdcb8669ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x383bf40, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7fdcb8629710 (LWP 7536)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3677de0, reset_sig_count=123514) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=12) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e0587 in rw_lock_s_lock_spin (lock=0x3677d58, pass=, file_name=0xa1b488 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c", line=1279) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0rw.c:456 #5 0x0000000000818228 in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:418 #6 pfs_rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0rw.ic:782 #7 btr_search_build_page_hash_index (index=0x7fdcac00d058, block=0x7fdcbfd58800, n_fields=1, n_bytes=0, left_side=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:1279 #8 0x00000000008196c4 in btr_search_info_update_slow (info=, cursor=0x7fdc9c01a868) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0sea.c:657 #9 0x000000000080b2d1 in btr_search_info_update (cursor=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0sea.ic:83 #10 btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdc9c01aaf8, mode=4, latch_mode=1, cursor=0x7fdc9c01a868, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb8626700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:787 #11 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #12 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #13 row_search_for_mysql (buf=0x7fdc9c016e10 "\334\006\061\065\061\071\061\065", ' ' , "\006\070\065\065\063\065\063", ' ' , mode=1, prebuilt=0x7fdc9c01a488, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #14 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc9c016c10, buf=0x7fdc9c016e10 "\334\006\061\065\061\071\061\065", ' ' , "\006\070\065\065\063\065\063", ' ' , direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #15 0x000000000059141d in join_read_next (info=0x7fdcb4005f08) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #16 0x0000000000597229 in sub_select (join=0x7fdcb400a980, join_tab=0x7fdcb4005e88, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #17 0x000000000059ca4d in do_select (join=0x7fdcb400a980, fields=0x3845630, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #18 0x00000000005b0505 in JOIN::exec (this=0x7fdcb400a980) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #19 0x00000000005ac253 in mysql_select (thd=0x3843520, rref_pointer_array=0x38456f8, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdcb4005548, unit=0x3844f08, select_lex=0x3845528) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #20 0x00000000005b1fb9 in handle_select (thd=0x3843520, lex=0x3844e58, result=0x7fdcb4005548, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #21 0x00000000005703d1 in execute_sqlcom_select (thd=0x3843520, all_tables=0x7fdcb4004c40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #22 0x00000000005759ff in mysql_execute_command (thd=0x3843520) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #23 0x0000000000577dea in mysql_parse (thd=0x3843520, rawbuf=, length=, parser_state=0x7fdcb8628ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #24 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x3843520, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #25 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #26 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #27 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #28 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7fdcb85e8710 (LWP 7538)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=28) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=3, rw_latch=3, guess=0x7fdcbfd1d280, mode=10, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb85e5700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080aa35 in btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdc9400b278, mode=4, latch_mode=1, cursor=0x7fdc9400afe8, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb85e5700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:586 #9 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #10 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #11 row_search_for_mysql (buf=0x7fdc9400a4c0 "", mode=1, prebuilt=0x7fdc9400ac08, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdc9400a2c0, buf=0x7fdc9400a4c0 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x7fdcc8006bf8) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x7fdcc800cc70, join_tab=0x7fdcc8006b78, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x7fdcc800cc70, fields=0x384caa0, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x7fdcc800cc70) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x384a990, rref_pointer_array=0x384cb68, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdcc8006238, unit=0x384c378, select_lex=0x384c998) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x384a990, lex=0x384c2c8, result=0x7fdcc8006238, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x384a990, all_tables=0x7fdcc8005930) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x384a990) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x384a990, rawbuf=, length=, parser_state=0x7fdcb85e7ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x384a990, packet=, packet_length=32) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7fdcb85a7710 (LWP 7540)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x3317780, reset_sig_count=192589) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=25) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x000000000081ae3e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x3317308, file_name=0xa1b740 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c", line=2766) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 0x000000000081e7c5 in buf_page_get_gen (space=1, zip_size=0, offset=455, rw_latch=1, guess=0x0, mode=10, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb85a4700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/buf/buf0buf.c:2766 #8 0x000000000080aa35 in btr_cur_search_to_nth_level (index=0x7fdcac00d058, level=0, tuple=0x7fdca400b2e8, mode=4, latch_mode=1, cursor=0x7fdca400b058, has_search_latch=0, file=0xa13080 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c", line=2902, mtr=0x7fdcb85a4700) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/btr/btr0cur.c:586 #9 0x00000000007cc550 in btr_pcur_open_with_no_init_func (mtr=, line=, file=, has_search_latch=, cursor=, latch_mode=, mode=, tuple=, index=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/btr0pcur.ic:515 #10 row_sel_get_clust_rec_for_mysql (mtr=, offset_heap=, offsets=, out_rec=, thr=, rec=, sec_index=, prebuilt=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:2900 #11 row_search_for_mysql (buf=0x7fdca400a530 "", mode=1, prebuilt=0x7fdca400ac78, match_mode=0, direction=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/row/row0sel.c:4336 #12 0x00000000007a844c in ha_innobase::general_fetch (this=0x7fdca400a330, buf=0x7fdca400a530 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:5922 #13 0x000000000059141d in join_read_next (info=0x385ed78) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:12487 #14 0x0000000000597229 in sub_select (join=0x386ad80, join_tab=0x385ecf8, end_of_records=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11705 #15 0x000000000059ca4d in do_select (join=0x386ad80, fields=0x3853b50, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:11466 #16 0x00000000005b0505 in JOIN::exec (this=0x386ad80) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2370 #17 0x00000000005ac253 in mysql_select (thd=0x3851a40, rref_pointer_array=0x3853c18, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x385e1d0, unit=0x3853428, select_lex=0x3853a48) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:2579 #18 0x00000000005b1fb9 in handle_select (thd=0x3851a40, lex=0x3853378, result=0x385e1d0, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_select.cc:297 #19 0x00000000005703d1 in execute_sqlcom_select (thd=0x3851a40, all_tables=0x385d460) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:4466 #20 0x00000000005759ff in mysql_execute_command (thd=0x3851a40) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2052 #21 0x0000000000577dea in mysql_parse (thd=0x3851a40, rawbuf=, length=, parser_state=0x7fdcb85a6ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #22 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x3851a40, packet=, packet_length=41) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #23 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #24 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fdcb8566710 (LWP 7715)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000088da75 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2e65600, reset_sig_count=1) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/os/os0sync.c:609 #3 0x00000000007e00fb in sync_array_wait_event (arr=0x2e64ac0, index=33) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0arr.c:458 #4 0x00000000007e13ca in mutex_spin_wait (mutex=0xf23a60, file_name=0xa13b20 "/export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0srv.c", line=1826) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/sync/sync0sync.c:643 #5 0x00000000007da848 in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/include/sync0sync.ic:251 #7 srv_printf_innodb_monitor (file=0x32cfb70, nowait=0, trx_start=0x7fdcb85646c8, trx_end=0x7fdcb85646c0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/srv/srv0srv.c:1826 #8 0x00000000007af044 in innodb_show_status (hton=, thd=0x3863790, stat_print=0x668170 ) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/storage/innobase/handler/ha_innodb.cc:9177 #9 0x000000000066dfe1 in ha_show_status (thd=0x3863790, db_type=0x2e64880, stat=HA_ENGINE_STATUS) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/handler.cc:4521 #10 0x0000000000575f5c in mysql_execute_command (thd=0x3863790) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:2231 #11 0x0000000000577dea in mysql_parse (thd=0x3863790, rawbuf=, length=, parser_state=0x7fdcb8565ae0) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:5503 #12 0x0000000000579961 in dispatch_command (command=COM_QUERY, thd=0x3863790, packet=, packet_length=25) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_parse.cc:1034 #13 0x000000000060d917 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:771 #14 0x000000000060d984 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_connect.cc:707 #15 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #16 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7fdccf591700 (LWP 7431)): #0 0x00000030e180dfb4 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x00000030e18092fb in _L_lock_1021 () from /lib64/libpthread.so.0 #2 0x00000030e180927e in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x000000000054f5bf in inline_mysql_mutex_lock (src_line=, src_file=, that=) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/include/mysql/psi/mysql_thread.h:617 #4 THD::init (this=0x386cd60) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_class.cc:920 #5 0x000000000054fc9d in THD::THD (this=0x386cd60) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/sql_class.cc:603 #6 0x0000000000500238 in handle_connections_sockets () at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/mysqld.cc:5289 #7 0x0000000000505c72 in mysqld_main (argc=34, argv=0x2e63e78) at /export/home/pb2/build/sb_0-3314961-1305136713.18/mysql-5.5.13/sql/mysqld.cc:4600 #8 0x00000030e141ec5d in __libc_start_main () from /lib64/libc.so.6 #9 0x00000000004fb3da in _start ()