Attaching to process 32255 Reading symbols from /home/sbester/mysql/5.5/mysql-5.5.17-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 0x7fdb84de8710 (LWP 4621)] [New Thread 0x7fdb855c7710 (LWP 4619)] [New Thread 0x7fdb86544710 (LWP 4617)] [New Thread 0x7fdb84f2d710 (LWP 4615)] [New Thread 0x7fdb850b3710 (LWP 4613)] [New Thread 0x7fdb85d65710 (LWP 4611)] [New Thread 0x7fdb86689710 (LWP 4609)] [New Thread 0x7fdb85851710 (LWP 4607)] [New Thread 0x7fdb863ff710 (LWP 4605)] [New Thread 0x7fdb85d24710 (LWP 4603)] [New Thread 0x7fdb84d66710 (LWP 4601)] [New Thread 0x7fdb9c116710 (LWP 4599)] [New Thread 0x7fdb862fb710 (LWP 4597)] [New Thread 0x7fdb8578e710 (LWP 4595)] [New Thread 0x7fdb85649710 (LWP 4593)] [New Thread 0x7fdb85adb710 (LWP 4591)] [New Thread 0x7fdb868d2710 (LWP 4589)] [New Thread 0x7fdb85504710 (LWP 4587)] [New Thread 0x7fdb863be710 (LWP 4585)] [New Thread 0x7fdb859d7710 (LWP 4583)] [New Thread 0x7fdb85072710 (LWP 4581)] [New Thread 0x7fdb8670b710 (LWP 4579)] [New Thread 0x7fdb8568a710 (LWP 4577)] [New Thread 0x7fdb852bb710 (LWP 4575)] [New Thread 0x7fdb869d6710 (LWP 4573)] [New Thread 0x7fdb85ca2710 (LWP 4571)] [New Thread 0x7fdb89534710 (LWP 4569)] [New Thread 0x7fdb86585710 (LWP 4567)] [New Thread 0x7fdb9c157710 (LWP 4564)] [New Thread 0x7fdb85892710 (LWP 4560)] [New Thread 0x7fdb89575710 (LWP 32361)] [New Thread 0x7fdb9c1d9710 (LWP 32272)] [New Thread 0x7fdb873d7710 (LWP 32271)] [New Thread 0x7fdb891da710 (LWP 32270)] [New Thread 0x7fdb87dd8710 (LWP 32269)] [New Thread 0x7fdb887d9710 (LWP 32268)] [New Thread 0x7fdb8a287710 (LWP 32266)] [New Thread 0x7fdb8ac88710 (LWP 32265)] [New Thread 0x7fdb8b689710 (LWP 32264)] [New Thread 0x7fdb8c08a710 (LWP 32263)] [New Thread 0x7fdb8ca8b710 (LWP 32262)] [New Thread 0x7fdb8d48c710 (LWP 32261)] [New Thread 0x7fdb8de8d710 (LWP 32260)] [New Thread 0x7fdb8e88e710 (LWP 32259)] [New Thread 0x7fdb8f28f710 (LWP 32258)] [New Thread 0x7fdb9d682710 (LWP 32257)] 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 0x00000030e14d7de3 in poll () from /lib64/libc.so.6 Thread 47 (Thread 0x7fdb9d682710 (LWP 32257)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x00000000008dfd78 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4427 #2 os_aio_linux_handle (global_seg=0, message1=0x7fdb9d681e78, message2=0x7fdb9d681e70, type=0x7fdb9d681e68) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4571 #3 0x00000000008a291e in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4528 #4 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 0x7fdb8f28f710 (LWP 32258)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x00000000008dfd78 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4427 #2 os_aio_linux_handle (global_seg=1, message1=0x7fdb8f28ee78, message2=0x7fdb8f28ee70, type=0x7fdb8f28ee68) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4571 #3 0x00000000008a291e in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4528 #4 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 0x7fdb8e88e710 (LWP 32259)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x00000000008dfd78 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4427 #2 os_aio_linux_handle (global_seg=2, message1=0x7fdb8e88de78, message2=0x7fdb8e88de70, type=0x7fdb8e88de68) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4571 #3 0x00000000008a291e in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4528 #4 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 0x7fdb8de8d710 (LWP 32260)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x00000000008dfd78 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4427 #2 os_aio_linux_handle (global_seg=3, message1=0x7fdb8de8ce78, message2=0x7fdb8de8ce70, type=0x7fdb8de8ce68) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4571 #3 0x00000000008a291e in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4528 #4 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 0x7fdb8d48c710 (LWP 32261)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x00000000008dfd78 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4427 #2 os_aio_linux_handle (global_seg=4, message1=0x7fdb8d48be78, message2=0x7fdb8d48be70, type=0x7fdb8d48be68) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4571 #3 0x00000000008a291e in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4528 #4 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 0x7fdb8ca8b710 (LWP 32262)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x00000000008dfd78 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4427 #2 os_aio_linux_handle (global_seg=5, message1=0x7fdb8ca8ae78, message2=0x7fdb8ca8ae70, type=0x7fdb8ca8ae68) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4571 #3 0x00000000008a291e in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4528 #4 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 0x7fdb8c08a710 (LWP 32263)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=31) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=3679) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x000000000086e95e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=3679) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 0x0000000000872953 in buf_page_io_complete (bpage=0x7fdb8fd4a700) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:3679 #8 0x00000000008a2ae8 in fil_aio_wait (segment=6) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4565 #9 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 0x7fdb8b689710 (LWP 32264)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=29) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=3679) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x000000000086e95e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=3679) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 0x0000000000872953 in buf_page_io_complete (bpage=0x7fdb8fd5c700) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:3679 #8 0x00000000008a2ae8 in fil_aio_wait (segment=7) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4565 #9 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 39 (Thread 0x7fdb8ac88710 (LWP 32265)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=3679) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x000000000086e95e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=3679) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 0x0000000000872953 in buf_page_io_complete (bpage=0x7fdb8fd3f780) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:3679 #8 0x00000000008a2ae8 in fil_aio_wait (segment=8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4565 #9 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 38 (Thread 0x7fdb8a287710 (LWP 32266)): #0 0x000000351c600614 in ?? () from /lib64/libaio.so.1 #1 0x00000000008dfd78 in os_aio_linux_collect (seg_size=, segment=, array=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4427 #2 os_aio_linux_handle (global_seg=9, message1=0x7fdb8a286e78, message2=0x7fdb8a286e70, type=0x7fdb8a286e68) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0file.c:4571 #3 0x00000000008a291e in fil_aio_wait (segment=9) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/fil/fil0fil.c:4528 #4 0x000000000082fc20 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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 0x7fdb887d9710 (LWP 32268)): #0 0x00000030e180b729 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e290b in os_cond_wait_timed (abstime=, mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1e82f30, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:716 #3 0x000000000082bd00 in srv_lock_timeout_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/srv/srv0srv.c:2287 #4 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #5 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 36 (Thread 0x7fdb87dd8710 (LWP 32269)): #0 0x00000030e180b729 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e290b in os_cond_wait_timed (abstime=, mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1e82ea0, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:716 #3 0x000000000082b901 in srv_error_monitor_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/srv/srv0srv.c:2469 #4 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #5 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 35 (Thread 0x7fdb891da710 (LWP 32270)): #0 0x00000030e180b729 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e290b in os_cond_wait_timed (abstime=, mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1e82fc0, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:716 #3 0x000000000082e504 in srv_monitor_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/srv/srv0srv.c:2137 #4 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #5 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 34 (Thread 0x7fdb873d7710 (LWP 32271)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x207d070, reset_sig_count=759) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=3) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834087 in rw_lock_s_lock_spin (lock=0x7fdb8fd31ec0, pass=, file_name=0xa265d8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0flu.c", line=1294) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0rw.c:456 #5 0x000000000087a2ee in rw_lock_s_lock_func (line=, file_name=, pass=, lock=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0rw.ic:782 #7 buf_flush_page (flush_type=, bpage=, buf_pool=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0flu.c:1293 #8 buf_flush_try_neighbors (n_to_flush=, n_flushed=, flush_type=, offset=, space=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0flu.c:1463 #9 buf_flush_page_and_try_neighbors (bpage=, flush_type=BUF_FLUSH_LIST, n_to_flush=200, count=0x7fdb873d6c48) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0flu.c:1529 #10 0x000000000087a7b8 in buf_flush_flush_list_batch (lsn_limit=, min_n=, buf_pool=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0flu.c:1651 #11 buf_flush_batch (buf_pool=0x2044888, flush_type=, min_n=200, lsn_limit=18446744073709551615) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0flu.c:1733 #12 0x000000000087abb7 in buf_flush_list (min_n=200, lsn_limit=18446744073709551615) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0flu.c:1959 #13 0x000000000082c61f in srv_master_thread (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/srv/srv0srv.c:2847 #14 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #15 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 33 (Thread 0x7fdb9c1d9710 (LWP 32272)): #0 0x00000030e180f1e5 in sigwait () from /lib64/libpthread.so.0 #1 0x00000000005000cb in signal_hand (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/mysqld.cc:2752 #2 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #3 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 32 (Thread 0x7fdb89575710 (LWP 32361)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=33) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=4487) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x000000000086e95e in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=4487) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 0x0000000000871411 in buf_stats_get_pool_info (all_pool_info=, pool_id=, buf_pool=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:4487 #8 buf_print_io (file=0x1ffd0f0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:4715 #9 0x000000000082e099 in srv_printf_innodb_monitor (file=0x1ffd0f0, nowait=, trx_start=, trx_end=0x7fdb895737a0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/srv/srv0srv.c:1938 #10 0x0000000000803704 in innodb_show_status (hton=, thd=0x247c470, stat_print=0x669e20 ) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:9285 #11 0x000000000066fcf1 in ha_show_status (thd=0x247c470, db_type=0x1b8fba0, stat=HA_ENGINE_STATUS) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/handler.cc:4533 #12 0x0000000000577424 in mysql_execute_command (thd=0x247c470) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2297 #13 0x000000000057933a in mysql_parse (thd=0x247c470, rawbuf=, length=, parser_state=0x7fdb89574bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #14 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x247c470, packet=, packet_length=25) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #15 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #16 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #17 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #18 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 31 (Thread 0x7fdb85892710 (LWP 4560)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=12) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb8588f7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb68158c28, mode=4, latch_mode=1, cursor=0x7fdb68158998, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb8588f7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68069e30 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68069c30, buf=0x7fdb68069e30 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb68155c78) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681ace70, join_tab=0x7fdb68155bf8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681ace70, fields=0x23f6788, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681ace70) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x23f4680, rref_pointer_array=0x23f6850, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb681552b8, unit=0x23f6060, select_lex=0x23f6680) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x23f4680, lex=0x23f5fb0, result=0x7fdb681552b8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x23f4680, all_tables=0x7fdb681549b0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x23f4680) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x23f4680, rawbuf=, length=, parser_state=0x7fdb85891bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x23f4680, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 30 (Thread 0x7fdb9c157710 (LWP 4564)): #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 0x0000000000512c90 in inline_mysql_mutex_lock (src_line=, src_file=, that=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/include/mysql/psi/mysql_thread.h:617 #4 PolyLock_mutex::wrlock (this=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sys_vars_shared.h:55 #5 0x00000000005114d4 in AutoWLock (l=, this=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sys_vars_shared.h:73 #6 sys_var::update (this=0x1bbe230, thd=0x2797a90, var=0x65) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/set_var.cc:204 #7 0x00000000005127ea in set_var::update (this=0xfffffffffffffe00, thd=0x80) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/set_var.cc:674 #8 0x0000000000511b59 in sql_set_variables (thd=0x2797a90, var_list=0x2799fb8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/set_var.cc:578 #9 0x00000000005774d9 in mysql_execute_command (thd=0x2797a90) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:3111 #10 0x000000000057933a in mysql_parse (thd=0x2797a90, rawbuf=, length=, parser_state=0x7fdb9c156bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #11 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x2797a90, packet=, packet_length=39) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #12 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #13 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #14 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #15 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 29 (Thread 0x7fdb86585710 (LWP 4567)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=25) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb865827e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb681a7c08, mode=4, latch_mode=1, cursor=0x7fdb681a7978, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb865827e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68121f10 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68121d10, buf=0x7fdb68121f10 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb680a6668) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb680f3050, join_tab=0x7fdb680a65e8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb680f3050, fields=0x27482f8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb680f3050) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x27461f0, rref_pointer_array=0x27483c0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb680a5ca8, unit=0x2747bd0, select_lex=0x27481f0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x27461f0, lex=0x2747b20, result=0x7fdb680a5ca8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x27461f0, all_tables=0x7fdb680a53a0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x27461f0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x27461f0, rawbuf=, length=, parser_state=0x7fdb86584bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x27461f0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 28 (Thread 0x7fdb89534710 (LWP 4569)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=17) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb895317e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb6807f698, mode=4, latch_mode=1, cursor=0x7fdb6807f408, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb895317e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb681acc80 "\376\006\065\067\060\060\065\070", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb681aca80, buf=0x7fdb681acc80 "\376\006\065\067\060\060\065\070", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb681bf8d8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb6810a2e0, join_tab=0x7fdb681bf858, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb6810a2e0, fields=0x7fdb6810b948, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb6810a2e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x2542610, rref_pointer_array=0x25447e0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6810a2c0, unit=0x2543ff0, select_lex=0x2544610) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x2542610, lex=0x2543f40, result=0x7fdb6810a2c0, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x2542610, all_tables=0x7fdb68109d00) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x2542610) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x2542610, rawbuf=, length=, parser_state=0x7fdb89533bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x2542610, packet=, packet_length=28) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 27 (Thread 0x7fdb85ca2710 (LWP 4571)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=15) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb85c9f7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb6807d418, mode=4, latch_mode=1, cursor=0x7fdb68087a48, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb85c9f7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb680877f0 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb680875f0, buf=0x7fdb680877f0 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6815b898) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb680d28b0, join_tab=0x7fdb6815b818, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb680d28b0, fields=0x25aa598, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb680d28b0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x25a8490, rref_pointer_array=0x25aa660, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6815aed8, unit=0x25a9e70, select_lex=0x25aa490) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x25a8490, lex=0x25a9dc0, result=0x7fdb6815aed8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x25a8490, all_tables=0x7fdb6815a5d0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x25a8490) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x25a8490, rawbuf=, length=, parser_state=0x7fdb85ca1bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x25a8490, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 26 (Thread 0x7fdb869d6710 (LWP 4573)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=28) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb869d37e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb68160688, mode=4, latch_mode=1, cursor=0x7fdb681603f8, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb869d37e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68013950 "6\006\064\066\062\060\062\064\066\066\066\066\246i\244u\372\250!\223"\372, N\207\234\215\355^\267\372N\207\234\215\356d\252\372N\207\234\215\372:~\022\232\025\235\215WD$\363i\204u\030M!\342\371i\204u\030N\035\337\371i\204u\030\310\071\001h\333\177", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68013750, buf=0x7fdb68013950 "6\006\064\066\062\060\062\064\066\066\066\066\246i\244u\372\250!\223"\372, N\207\234\215\355^\267\372N\207\234\215\356d\252\372N\207\234\215\372:~\022\232\025\235\215WD$\363i\204u\030M!\342\371i\204u\030N\035\337\371i\204u\030\310\071\001h\333\177", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb680fef38) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb680951a0, join_tab=0x7fdb680feeb8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb680951a0, fields=0x25287c8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb680951a0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x25266c0, rref_pointer_array=0x2528890, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb680fe3b8, unit=0x25280a0, select_lex=0x25286c0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x25266c0, lex=0x2527ff0, result=0x7fdb680fe3b8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x25266c0, all_tables=0x7fdb680fd670) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x25266c0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x25266c0, rawbuf=, length=, parser_state=0x7fdb869d5bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x25266c0, packet=, packet_length=40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7fdb852bb710 (LWP 4575)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=20) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb852b87e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb681a1e98, mode=4, latch_mode=1, cursor=0x7fdb680e04e8, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb852b87e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb680740b0 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68073eb0, buf=0x7fdb680740b0 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb681583d8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb68132400, join_tab=0x7fdb68158358, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb68132400, fields=0x24b9228, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb68132400) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x24b7120, rref_pointer_array=0x24b92f0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb68157858, unit=0x24b8b00, select_lex=0x24b9120) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x24b7120, lex=0x24b8a50, result=0x7fdb68157858, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x24b7120, all_tables=0x7fdb68156b10) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x24b7120) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x24b7120, rawbuf=, length=, parser_state=0x7fdb852babc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x24b7120, packet=, packet_length=40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7fdb8568a710 (LWP 4577)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=10) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb856877e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb68041498, mode=4, latch_mode=1, cursor=0x7fdb68041208, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb856877e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb681a4ae0 "\332\006\063\071\067\061\061\065\333\177", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb681a48e0, buf=0x7fdb681a4ae0 "\332\006\063\071\067\061\061\065\333\177", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb680c6c08) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb68014190, join_tab=0x7fdb680c6b88, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb68014190, fields=0x27027a8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb68014190) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x27006a0, rref_pointer_array=0x2702870, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb680c6088, unit=0x2702080, select_lex=0x27026a0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x27006a0, lex=0x2701fd0, result=0x7fdb680c6088, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x27006a0, all_tables=0x7fdb680c5340) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x27006a0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x27006a0, rawbuf=, length=, parser_state=0x7fdb85689bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x27006a0, packet=, packet_length=40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7fdb8670b710 (LWP 4579)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=4) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa21450 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/buf0buf.ic", line=813) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x00000000008d81c4 in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_block_free (block=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/buf0buf.ic:813 #8 mem_heap_block_free (heap=0x23a55b0, block=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/mem/mem0mem.c:515 #9 0x00000000008b28e0 in ha_remove_all_nodes_to_page (table=0x23a5578, fold=, page=0x7fdb90850000 "ޭ\276", ) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/ha/ha0ha.c:333 #10 0x000000000086b875 in btr_search_drop_page_hash_index (block=0x7fdb8fd31e00) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0sea.c:1156 #11 0x0000000000870469 in buf_pool_drop_hash_index_instance (released_search_latch=, buf_pool=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:1342 #12 buf_pool_drop_hash_index () at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:1379 #13 0x0000000000869cbc in btr_search_disable () at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0sea.c:224 #14 0x0000000000580f45 in sys_var_pluginvar::global_update (this=0x1bbe230, thd=0x26f9470, var=0x7fdb68023250) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_plugin.cc:2955 #15 0x00000000005114fb in sys_var::update (this=0x1bbe230, thd=0x26f9470, var=0x7fdb68023250) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/set_var.cc:207 #16 0x00000000005127ea in set_var::update (this=0xfffffffffffffe00, thd=0x80) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/set_var.cc:674 #17 0x0000000000511b59 in sql_set_variables (thd=0x26f9470, var_list=0x26fb998) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/set_var.cc:578 #18 0x00000000005774d9 in mysql_execute_command (thd=0x26f9470) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:3111 #19 0x000000000057933a in mysql_parse (thd=0x26f9470, rawbuf=, length=, parser_state=0x7fdb8670abc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #20 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x26f9470, packet=, packet_length=39) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #21 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #22 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #23 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #24 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7fdb85072710 (LWP 4581)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb8506f7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb68004f28, mode=4, latch_mode=1, cursor=0x7fdb681a0748, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb8506f7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb681a1a30 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb681a1830, buf=0x7fdb681a1a30 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb680d64f8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681727c0, join_tab=0x7fdb680d6478, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681727c0, fields=0x24ea398, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681727c0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x24e8290, rref_pointer_array=0x24ea460, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb680d5950, unit=0x24e9c70, select_lex=0x24ea290) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x24e8290, lex=0x24e9bc0, result=0x7fdb680d5950, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x24e8290, all_tables=0x7fdb680d4be0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x24e8290) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x24e8290, rawbuf=, length=, parser_state=0x7fdb85071bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x24e8290, packet=, packet_length=41) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7fdb859d7710 (LWP 4583)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=19) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb859d47e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb680e5d18, mode=4, latch_mode=1, cursor=0x7fdb680e5a88, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb859d47e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68021ef0 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68021cf0, buf=0x7fdb68021ef0 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6812f438) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681dabd0, join_tab=0x7fdb6812f3b8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681dabd0, fields=0x27c6c88, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681dabd0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x27c4b80, rref_pointer_array=0x27c6d50, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6812ea78, unit=0x27c6560, select_lex=0x27c6b80) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x27c4b80, lex=0x27c64b0, result=0x7fdb6812ea78, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x27c4b80, all_tables=0x7fdb6812e170) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x27c4b80) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x27c4b80, rawbuf=, length=, parser_state=0x7fdb859d6bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x27c4b80, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7fdb863be710 (LWP 4585)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=14) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb863bb7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb681317e8, mode=4, latch_mode=1, cursor=0x7fdb680071d8, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb863bb7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb680479e0 "\332\006\065\070\060\063\071\071floor(rand()*1\006\065\064\065\064\067\061\252낣\035\222W\363'mZh+j", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb680477e0, buf=0x7fdb680479e0 "\332\006\065\070\060\063\071\071floor(rand()*1\006\065\064\065\064\067\061\252낣\035\222W\363'mZh+j", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6813d478) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681ec800, join_tab=0x7fdb6813d3f8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681ec800, fields=0x24f1758, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681ec800) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x24ef650, rref_pointer_array=0x24f1820, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6813cab8, unit=0x24f1030, select_lex=0x24f1650) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x24ef650, lex=0x24f0f80, result=0x7fdb6813cab8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x24ef650, all_tables=0x7fdb6813c1b0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x24ef650) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x24ef650, rawbuf=, length=, parser_state=0x7fdb863bdbc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x24ef650, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7fdb85504710 (LWP 4587)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=27) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb855017e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb681cdf68, mode=4, latch_mode=1, cursor=0x7fdb6814b338, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb855017e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb681b4da0 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb681b4ba0, buf=0x7fdb681b4da0 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb680b2ab8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb680e9470, join_tab=0x7fdb680b2a38, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb680e9470, fields=0x24a71b8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb680e9470) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x24a50b0, rref_pointer_array=0x24a7280, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb680b20f8, unit=0x24a6a90, select_lex=0x24a70b0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x24a50b0, lex=0x24a69e0, result=0x7fdb680b20f8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x24a50b0, all_tables=0x7fdb680b17f0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x24a50b0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x24a50b0, rawbuf=, length=, parser_state=0x7fdb85503bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x24a50b0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7fdb868d2710 (LWP 4589)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=5) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb868cf7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb681c9a08, mode=4, latch_mode=1, cursor=0x7fdb681c9778, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb868cf7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb680e8350 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb680e8150, buf=0x7fdb680e8350 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6814d0a8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681bb040, join_tab=0x7fdb6814d028, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681bb040, fields=0x24b1978, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681bb040) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x24af870, rref_pointer_array=0x24b1a40, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6814c6e8, unit=0x24b1250, select_lex=0x24b1870) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x24af870, lex=0x24b11a0, result=0x7fdb6814c6e8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x24af870, all_tables=0x7fdb6814bde0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x24af870) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x24af870, rawbuf=, length=, parser_state=0x7fdb868d1bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x24af870, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7fdb85adb710 (LWP 4591)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=30) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb85ad87e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb6816efd8, mode=4, latch_mode=1, cursor=0x7fdb6816ed48, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb85ad87e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb6800d550 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb6800d350, buf=0x7fdb6800d550 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6802e5a8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681f5a00, join_tab=0x7fdb6802e528, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681f5a00, fields=0x26d8718, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681f5a00) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x26d6610, rref_pointer_array=0x26d87e0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6802dbe8, unit=0x26d7ff0, select_lex=0x26d8610) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x26d6610, lex=0x26d7f40, result=0x7fdb6802dbe8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x26d6610, all_tables=0x7fdb6802d2e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x26d6610) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x26d6610, rawbuf=, length=, parser_state=0x7fdb85adabc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x26d6610, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7fdb85649710 (LWP 4593)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=7) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb856467e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb6806bd18, mode=4, latch_mode=1, cursor=0x7fdb6806ba88, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb856467e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb6816bdb0 "\332\006\064\061\062\064\060\064\333\177", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb6816bbb0, buf=0x7fdb6816bdb0 "\332\006\064\061\062\064\060\064\333\177", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb68135f08) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb68019c10, join_tab=0x7fdb68135e88, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb68019c10, fields=0x2549078, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb68019c10) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x2546f70, rref_pointer_array=0x2549140, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb68135360, unit=0x2548950, select_lex=0x2548f70) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x2546f70, lex=0x25488a0, result=0x7fdb68135360, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x2546f70, all_tables=0x7fdb681345f0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x2546f70) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x2546f70, rawbuf=, length=, parser_state=0x7fdb85648bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x2546f70, packet=, packet_length=41) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7fdb8578e710 (LWP 4595)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=23) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb8578b7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb681718e8, mode=4, latch_mode=1, cursor=0x7fdb6808c548, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb8578b7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68091c40 "h\006\065\067\071\063\064\071B\227\214\212\377\364w\314B\227\214\212\005!\006\065\064\070\060\071\061\035Z\240\323L\214\212\003=\301\002Ց\214", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68091a40, buf=0x7fdb68091c40 "h\006\065\067\071\063\064\071B\227\214\212\377\364w\314B\227\214\212\005!\006\065\064\070\060\071\061\035Z\240\323L\214\212\003=\301\002Ց\214", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6811ff28) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681f1a20, join_tab=0x7fdb6811fea8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681f1a20, fields=0x2840088, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681f1a20) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x283df80, rref_pointer_array=0x2840150, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6811f380, unit=0x283f960, select_lex=0x283ff80) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x283df80, lex=0x283f8b0, result=0x7fdb6811f380, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x283df80, all_tables=0x7fdb6811e610) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x283df80) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x283df80, rawbuf=, length=, parser_state=0x7fdb8578dbc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x283df80, packet=, packet_length=41) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7fdb862fb710 (LWP 4597)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=11) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb862f87e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb6814dd98, mode=4, latch_mode=1, cursor=0x7fdb681530c8, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb862f87e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb6814f400 "\332\005\061\063\066\071\062\071\333\177", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb6814f200, buf=0x7fdb6814f400 "\332\005\061\063\066\071\062\071\333\177", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb681681d8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681bd030, join_tab=0x7fdb68168158, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681bd030, fields=0x249b3b8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681bd030) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x24992b0, rref_pointer_array=0x249b480, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb68167818, unit=0x249ac90, select_lex=0x249b2b0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x24992b0, lex=0x249abe0, result=0x7fdb68167818, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x24992b0, all_tables=0x7fdb68166f10) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x24992b0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x24992b0, rawbuf=, length=, parser_state=0x7fdb862fabc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x24992b0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7fdb9c116710 (LWP 4599)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=24) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb9c1137e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb680c12f8, mode=4, latch_mode=1, cursor=0x7fdb680f58c8, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb9c1137e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb681619a0 "\332\005\071\067\070\060\060\066\333\177", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb681617a0, buf=0x7fdb681619a0 "\332\005\071\067\070\060\060\066\333\177", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb680bb208) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681c2200, join_tab=0x7fdb680bb188, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681c2200, fields=0x24a2158, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681c2200) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x24a0050, rref_pointer_array=0x24a2220, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb680ba848, unit=0x24a1a30, select_lex=0x24a2050) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x24a0050, lex=0x24a1980, result=0x7fdb680ba848, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x24a0050, all_tables=0x7fdb680b9f40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x24a0050) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x24a0050, rawbuf=, length=, parser_state=0x7fdb9c115bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x24a0050, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7fdb84d66710 (LWP 4601)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb84d637e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb681505d8, mode=4, latch_mode=1, cursor=0x7fdb68150348, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb84d637e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb681498d0 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb681496d0, buf=0x7fdb681498d0 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6813b318) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681d8be0, join_tab=0x7fdb6813b298, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681d8be0, fields=0x2741b58, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681d8be0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x273fa50, rref_pointer_array=0x2741c20, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6813a770, unit=0x2741430, select_lex=0x2741a50) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x273fa50, lex=0x2741380, result=0x7fdb6813a770, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x273fa50, all_tables=0x7fdb68139a00) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x273fa50) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x273fa50, rawbuf=, length=, parser_state=0x7fdb84d65bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x273fa50, packet=, packet_length=41) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7fdb85d24710 (LWP 4603)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=18) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb85d217e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb680ce508, mode=4, latch_mode=1, cursor=0x7fdb680ce278, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb85d217e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68059090 "\332\005\061\063\060\060\060\067", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68058e90, buf=0x7fdb68059090 "\332\005\061\063\060\060\060\067", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6801feb8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681e9ef0, join_tab=0x7fdb6801fe38, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681e9ef0, fields=0x27448e8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681e9ef0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x27427e0, rref_pointer_array=0x27449b0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6801f338, unit=0x27441c0, select_lex=0x27447e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x27427e0, lex=0x2744110, result=0x7fdb6801f338, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x27427e0, all_tables=0x7fdb6801e5f0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x27427e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x27427e0, rawbuf=, length=, parser_state=0x7fdb85d23bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x27427e0, packet=, packet_length=40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7fdb863ff710 (LWP 4605)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=9) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb863fc7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb680c4bb8, mode=4, latch_mode=1, cursor=0x7fdb68143788, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb863fc7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb6804f440 "\332\006\064\066\062\060\062\064", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb6804f240, buf=0x7fdb6804f440 "\332\006\064\066\062\060\062\064", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6818d6a8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681f3a10, join_tab=0x7fdb6818d628, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681f3a10, fields=0x2670648, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681f3a10) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x266e540, rref_pointer_array=0x2670710, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6818cb28, unit=0x266ff20, select_lex=0x2670540) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x266e540, lex=0x266fe70, result=0x7fdb6818cb28, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x266e540, all_tables=0x7fdb6818bde0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x266e540) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x266e540, rawbuf=, length=, parser_state=0x7fdb863febc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x266e540, packet=, packet_length=40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7fdb85851710 (LWP 4607)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb8584e7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb680ae5b8, mode=4, latch_mode=1, cursor=0x7fdb680ae328, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb8584e7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb680f6b60 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb680f6960, buf=0x7fdb680f6b60 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb681990a8) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb6808d4a0, join_tab=0x7fdb68199028, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb6808d4a0, fields=0x26773e8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb6808d4a0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x26752e0, rref_pointer_array=0x26774b0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb681986e8, unit=0x2676cc0, select_lex=0x26772e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x26752e0, lex=0x2676c10, result=0x7fdb681986e8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x26752e0, all_tables=0x7fdb68197de0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x26752e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x26752e0, rawbuf=, length=, parser_state=0x7fdb85850bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x26752e0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7fdb86689710 (LWP 4609)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=21) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb866867e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb6815dc88, mode=4, latch_mode=1, cursor=0x7fdb680655c8, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb866867e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68034b80 "\332\006\063\062\071\066\062\071\333\177", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68034980, buf=0x7fdb68034b80 "\332\006\063\062\071\066\062\071\333\177", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb680a4c28) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681e23c0, join_tab=0x7fdb680a4ba8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681e23c0, fields=0x2753cf8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681e23c0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x2751bf0, rref_pointer_array=0x2753dc0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb680a40a8, unit=0x27535d0, select_lex=0x2753bf0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x2751bf0, lex=0x2753520, result=0x7fdb680a40a8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x2751bf0, all_tables=0x7fdb680a3360) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x2751bf0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x2751bf0, rawbuf=, length=, parser_state=0x7fdb86688bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x2751bf0, packet=, packet_length=40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7fdb85d65710 (LWP 4611)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=22) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb85d627e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb68142148, mode=4, latch_mode=1, cursor=0x7fdb6805d278, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb85d627e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68036200 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68036000, buf=0x7fdb68036200 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb680c9d88) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681efa30, join_tab=0x7fdb680c9d08, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681efa30, fields=0x278c288, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681efa30) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x278a180, rref_pointer_array=0x278c350, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb680c9208, unit=0x278bb60, select_lex=0x278c180) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x278a180, lex=0x278bab0, result=0x7fdb680c9208, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x278a180, all_tables=0x7fdb680c84c0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x278a180) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x278a180, rawbuf=, length=, parser_state=0x7fdb85d64bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x278a180, packet=, packet_length=40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7fdb850b3710 (LWP 4613)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=26) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb850b07e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb681b6808, mode=4, latch_mode=1, cursor=0x7fdb681b6578, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb850b07e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb681b5a50 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb681b5850, buf=0x7fdb681b5a50 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6807be78) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb6809a680, join_tab=0x7fdb6807bdf8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb6809a680, fields=0x2793028, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb6809a680) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x2790f20, rref_pointer_array=0x27930f0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6807b2f8, unit=0x2792900, select_lex=0x2792f20) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x2790f20, lex=0x2792850, result=0x7fdb6807b2f8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x2790f20, all_tables=0x7fdb6807a5b0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x2790f20) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x2790f20, rawbuf=, length=, parser_state=0x7fdb850b2bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x2790f20, packet=, packet_length=40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7fdb84f2d710 (LWP 4615)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=6) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb84f2a7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb68191e38, mode=4, latch_mode=1, cursor=0x7fdb681c7e38, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb84f2a7e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68080b30 "", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68080930, buf=0x7fdb68080b30 "", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb6817bc68) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681ce330, join_tab=0x7fdb6817bbe8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681ce330, fields=0x25ff048, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681ce330) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x25fcf40, rref_pointer_array=0x25ff110, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb6817b2a8, unit=0x25fe920, select_lex=0x25fef40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x25fcf40, lex=0x25fe870, result=0x7fdb6817b2a8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x25fcf40, all_tables=0x7fdb6817a9a0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x25fcf40) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x25fcf40, rawbuf=, length=, parser_state=0x7fdb84f2cbc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x25fcf40, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7fdb86544710 (LWP 4617)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=16) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb865417e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb68137238, mode=4, latch_mode=1, cursor=0x7fdb68136fa8, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb865417e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb6813bd20 ",\005\065\067\070\071\065\061\001", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb6813bb20, buf=0x7fdb6813bd20 ",\005\065\067\070\071\065\061\001", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb68183c18) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb6809c670, join_tab=0x7fdb68183b98, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb6809c670, fields=0x2605de8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb6809c670) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x2603ce0, rref_pointer_array=0x2605eb0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb68183258, unit=0x26056c0, select_lex=0x2605ce0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x2603ce0, lex=0x2605610, result=0x7fdb68183258, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x2603ce0, all_tables=0x7fdb68182950) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x2603ce0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x2603ce0, rawbuf=, length=, parser_state=0x7fdb86543bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x2603ce0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7fdb855c7710 (LWP 4619)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=13) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb855c47e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb680d85e8, mode=4, latch_mode=1, cursor=0x7fdb680d8358, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb855c47e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb68040290 "2\006\063\070\061\065\061\065\067\061\062\060\066\067\024\066\064\065\061\063\071\070\005\070\060\060\064\063\062\005\006", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb68040090, buf=0x7fdb68040290 "2\006\063\070\061\065\061\065\067\061\062\060\066\067\024\066\064\065\061\063\071\070\005\070\060\060\064\063\062\005\006", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb681d1838) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb68097190, join_tab=0x7fdb681d17b8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb68097190, fields=0x24fd1e8, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb68097190) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x24fb0e0, rref_pointer_array=0x24fd2b0, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb681d0e78, unit=0x24fcac0, select_lex=0x24fd0e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x24fb0e0, lex=0x24fca10, result=0x7fdb681d0e78, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x24fb0e0, all_tables=0x7fdb681d0570) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x24fb0e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x24fb0e0, rawbuf=, length=, parser_state=0x7fdb855c6bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x24fb0e0, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fdb84de8710 (LWP 4621)): #0 0x00000030e180b3bc in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000008e2a05 in os_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x2044c60, reset_sig_count=118500) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/os/os0sync.c:609 #3 0x0000000000833bfb in sync_array_wait_event (arr=0x1b8fde0, index=2) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0arr.c:458 #4 0x0000000000834eca in mutex_spin_wait (mutex=0x2044888, file_name=0xa253f8 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c", line=2310) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/sync/sync0sync.c:643 #5 0x0000000000875bbc in mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=, file_name=, mutex=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/sync0sync.ic:251 #7 buf_page_get_gen (space=44, zip_size=0, offset=3, rw_latch=3, guess=0x7fdb8fd57f00, mode=10, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb84de57e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/buf/buf0buf.c:2310 #8 0x000000000085e605 in btr_cur_search_to_nth_level (index=0x7fdb6815e0d8, level=0, tuple=0x7fdb68059a98, mode=4, latch_mode=1, cursor=0x7fdb681a5738, has_search_latch=0, file=0xa1cce0 "/export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c", line=2918, mtr=0x7fdb84de57e0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/btr/btr0cur.c:590 #9 0x000000000081f184 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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/include/btr0pcur.ic:514 #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-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:2916 #11 row_search_for_mysql (buf=0x7fdb681a54e0 "\b\006\063\071\067\061\061\065", '\017' "\220, \023\006\063\061\060\061\064\065", mode=1, prebuilt=, match_mode=0, direction=1) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/row/row0sel.c:4395 #12 0x00000000007fb74c in ha_innobase::general_fetch (this=0x7fdb681a52e0, buf=0x7fdb681a54e0 "\b\006\063\071\067\061\061\065", '\017' "\220, \023\006\063\061\060\061\064\065", direction=1, match_mode=4294967295) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/storage/innobase/handler/ha_innodb.cc:5968 #13 0x0000000000592a0d in join_read_next (info=0x7fdb681e5868) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:12504 #14 0x00000000005981d9 in sub_select (join=0x7fdb681e73f0, join_tab=0x7fdb681e57e8, end_of_records=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11722 #15 0x000000000059d9fd in do_select (join=0x7fdb681e73f0, fields=0x2503f88, table=0x0, procedure=0x0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:11483 #16 0x00000000005b1b05 in JOIN::exec (this=0x7fdb681e73f0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2370 #17 0x00000000005ad853 in mysql_select (thd=0x2501e80, rref_pointer_array=0x2504050, tables=, wild_num=, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x7fdb681e4ea8, unit=0x2503860, select_lex=0x2503e80) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:2579 #18 0x00000000005b35b9 in handle_select (thd=0x2501e80, lex=0x25037b0, result=0x7fdb681e4ea8, setup_tables_done_option=0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_select.cc:297 #19 0x0000000000571881 in execute_sqlcom_select (thd=0x2501e80, all_tables=0x7fdb681e45a0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:4517 #20 0x0000000000576eca in mysql_execute_command (thd=0x2501e80) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:2118 #21 0x000000000057933a in mysql_parse (thd=0x2501e80, rawbuf=, length=, parser_state=0x7fdb84de7bc0) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:5554 #22 0x000000000057aeb1 in dispatch_command (command=COM_QUERY, thd=0x2501e80, packet=, packet_length=32) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_parse.cc:1034 #23 0x000000000060f4f7 in do_handle_one_connection (thd_arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:789 #24 0x000000000060f564 in handle_one_connection (arg=) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/sql_connect.cc:708 #25 0x00000030e1807761 in start_thread () from /lib64/libpthread.so.0 #26 0x00000030e14e14ed in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7fdb9d684700 (LWP 32255)): #0 0x00000030e14d7de3 in poll () from /lib64/libc.so.6 #1 0x000000000050104a in handle_connections_sockets () at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/mysqld.cc:5202 #2 0x0000000000506ba2 in mysqld_main (argc=39, argv=0x1b8f458) at /export/home/pb2/build/sb_0-4087579-1318423023.65/mysql-5.5.17/sql/mysqld.cc:4650 #3 0x00000030e141ec5d in __libc_start_main () from /lib64/libc.so.6 #4 0x00000000004fc1da in _start ()