+thread apply all bt Thread 26 (LWP 10152): +bt #0 0x0000000005bf0a63 in poll () from /lib64/libc.so.6 #1 0x0000000000518e51 in handle_connections_sockets () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mysqld.cc:5383 #2 0x000000000051f0a4 in mysqld_main (argc=48, argv=0x610be08) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mysqld.cc:4822 #3 0x0000000000513fed in main (argc=, argv=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/main.cc:25 Thread 25 (LWP 10157): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=0, array=0x7610ea0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=0, message1=0x6f06e78, message2=0x6f06e70, type=0x6f06e68, space_id=0x6f06e60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 24 (LWP 10158): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=0, array=0x761f320) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=1, message1=0x117bee78, message2=0x117bee70, type=0x117bee68, space_id=0x117bee60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 23 (LWP 10159): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=0, array=0x762d7a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=2, message1=0x121bfe78, message2=0x121bfe70, type=0x121bfe68, space_id=0x121bfe60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=2) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 22 (LWP 10160): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=1, array=0x762d7a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=3, message1=0x12bc0e78, message2=0x12bc0e70, type=0x12bc0e68, space_id=0x12bc0e60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=3) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 21 (LWP 10161): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=2, array=0x762d7a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=4, message1=0x135c1e78, message2=0x135c1e70, type=0x135c1e68, space_id=0x135c1e60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 20 (LWP 10162): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=3, array=0x762d7a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=5, message1=0x13fc2e78, message2=0x13fc2e70, type=0x13fc2e68, space_id=0x13fc2e60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=5) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 19 (LWP 10163): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=0, array=0x7665c30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=6, message1=0x149c3e78, message2=0x149c3e70, type=0x149c3e68, space_id=0x149c3e60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=6) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 18 (LWP 10164): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=1, array=0x7665c30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=7, message1=0x153c4e78, message2=0x153c4e70, type=0x153c4e68, space_id=0x153c4e60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=7) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 17 (LWP 10165): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=2, array=0x7665c30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=8, message1=0x15dc5e78, message2=0x15dc5e70, type=0x15dc5e68, space_id=0x15dc5e60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 16 (LWP 10166): +bt #0 0x000000000504a614 in ?? () from /lib64/libaio.so.1 #1 0x000000000095a2e8 in os_aio_linux_collect (seg_size=256, segment=3, array=0x7665c30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=9, message1=0x167c6e78, message2=0x167c6e70, type=0x167c6e68, space_id=0x167c6e60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000900f80 in fil_aio_wait (segment=9) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000865f09 in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 15 (LWP 10167): +bt #0 0x0000000004e3843c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095e2f7 in os_cond_wait (mutex=0x73b5240, cond=0x73b5278) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x73b5240, reset_sig_count=1914) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x0000000000860a1a in srv_redo_log_follow_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:3076 #4 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 14 (LWP 10170): +bt #0 0x0000000004e387bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095e1fe in os_cond_wait_timed (abstime=0x193c8e20, mutex=0x73b5000, cond=0x73b5038) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x73b5000, time_in_usec=, reset_sig_count=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:716 #3 0x00000000008641bc in srv_lock_timeout_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:2694 #4 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 13 (LWP 10171): +bt #0 0x0000000004e387bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095e1fe in os_cond_wait_timed (abstime=0x19dc9df0, mutex=0x73b4f40, cond=0x73b4f78) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x73b4f40, time_in_usec=, reset_sig_count=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:716 #3 0x0000000000864112 in srv_error_monitor_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:2907 #4 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 12 (LWP 10172): +bt #0 0x0000000004e387bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095e1fe in os_cond_wait_timed (abstime=0x1a7cae20, mutex=0x73b50c0, cond=0x73b50f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x73b50c0, time_in_usec=, reset_sig_count=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:716 #3 0x0000000000862cd8 in srv_monitor_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:2544 #4 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 11 (LWP 10173): +bt #0 0x0000000005bf2d03 in select () from /lib64/libc.so.6 #1 0x000000000095e887 in os_thread_sleep (tm=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0thread.c:259 #2 0x0000000000860ac9 in srv_LRU_dump_restore_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:2953 #3 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #4 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 10 (LWP 10174): +bt #0 0x0000000005bf2d03 in select () from /lib64/libc.so.6 #1 0x000000000095e887 in os_thread_sleep (tm=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0thread.c:259 #2 0x0000000000864642 in srv_master_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:3366 #3 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #4 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 9 (LWP 10175): +bt #0 0x0000000004e3843c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095e2f7 in os_cond_wait (mutex=0x1007c6b0, cond=0x1007c6e8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1007c6b0, reset_sig_count=39752) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000086a3fa in sync_array_wait_event (arr=0x6293c20, index=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000086abac in rw_lock_s_lock_spin (lock=0x1183c60 , pass=, file_name=0xb5ca98 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c", line=680) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:453 #5 0x000000000083bffd in rw_lock_s_lock_func (line=680, file_name=0xb5ca98 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c", lock=, pass=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:419 #6 pfs_rw_lock_s_lock_func (line=680, file_name=0xb5ca98 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:779 #7 row_mysql_freeze_data_dictionary_func (trx=0x1048e078, file=0xb5ca98 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c", line=680) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1814 #8 0x00000000009907b9 in row_purge_parse_undo_rec (thr=0x10090090, updated_extern=0x1c5cdd08, node=0x1048e938) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:680 #9 row_purge (thr=0x10090090, node=0x1048e938) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:758 #10 row_purge_step (thr=0x10090090) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:805 #11 0x000000000097e30d in que_thr_step (thr=0x10090090) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1259 #12 que_run_threads_low (thr=0x10090090) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1319 #13 que_run_threads (thr=0x10090090) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1356 #14 0x0000000000870e15 in trx_purge (limit=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0purge.c:1195 #15 0x0000000000860507 in srv_purge_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:4037 #16 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #17 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 8 (LWP 10177): +bt #0 0x0000000004e3c2a5 in sigwait () from /lib64/libpthread.so.0 #1 0x000000000051800f in signal_hand (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mysqld.cc:2748 #2 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #3 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 7 (LWP 10179): +bt #0 0x0000000004e3b54d in read () from /lib64/libpthread.so.0 #1 0x0000000000a1cc3d in vio_read (vio=0x104de840, buf=0x100ead80 "\a", size=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/vio/viosocket.c:56 #2 0x0000000000520c70 in my_real_read (net=0x104db780, complen=0x40b0d88) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:834 #3 0x0000000000520f9b in my_net_read (net=0x104db780) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:1033 #4 0x00000000005a2176 in do_command (thd=0x104db550) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:734 #5 0x00000000006479b1 in do_handle_one_connection (thd_arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #6 0x0000000000647aa7 in handle_one_connection (arg=0x104db550) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #7 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #8 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 6 (LWP 23736): +bt #0 0x0000000004e3843c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095e2f7 in os_cond_wait (mutex=0x103ecfd0, cond=0x103ed008) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x103ecfd0, reset_sig_count=29646) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000086a3fa in sync_array_wait_event (arr=0x6293c20, index=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000086be39 in mutex_spin_wait (mutex=0x1007c378, file_name=0xb43020 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c", line=343) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x00000000008e3c3a in mutex_enter_func (line=343, file_name=0xb43020 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c", mutex=0x1007c378) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x1007c378, file_name=0xb43020 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c", line=343) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 0x00000000008e3e97 in dict_table_decrement_handle_count (table=0x10123f08, dict_locked=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c:343 #8 0x000000000083ceb7 in row_prebuilt_free (prebuilt=0x172b5ca8, dict_locked=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:846 #9 0x000000000081dc32 in ha_innobase::close (this=0x16b2f5a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:5041 #10 0x000000000061ed14 in closefrm (table=0x16b3b2a0, free_share=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/table.cc:2154 #11 0x000000000055549c in close_temporary (table=0x16b3b2a0, free_share=true, delete_table=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:2242 #12 0x000000000055a800 in close_temporary_table (thd=0x16cc4420, table=0x16b3b2a0, free_share=true, delete_table=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:2216 #13 0x0000000000605f65 in mysql_alter_table (thd=, new_db=0x17754590 "query111097", new_name=0x177545a8 "t1", create_info=0x41b3570, table_list=, alter_info=0x16cc4420, order_num=0, order=0x0, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:6874 #14 0x00000000007c1a21 in Alter_table_statement::execute (this=, thd=0x16cc4420) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_alter.cc:106 #15 0x000000000059f198 in mysql_execute_command (thd=0x16cc4420) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4615 #16 0x000000000059fa80 in mysql_parse (thd=0x16cc4420, rawbuf=0x177544b0 "ALTER TABLE query111097 . `t1` DROP COLUMN `c48`", length=, parser_state=0x41b4b10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #17 0x00000000005a0d9f in dispatch_command (command=COM_QUERY, thd=0x16cc4420, packet=, packet_length=48) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #18 0x00000000005a22d9 in do_command (thd=0x16cc4420) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #19 0x00000000006479b1 in do_handle_one_connection (thd_arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #20 0x0000000000647aa7 in handle_one_connection (arg=0x16cc4420) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #21 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #22 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 5 (LWP 23771): +bt #0 0x0000000004e3969c in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000007e2779 in my_write_core (sig=6) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/mysys/stacktrace.c:433 #2 0x00000000006ab0ea in handle_fatal_signal (sig=6) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/signal_handler.cc:249 #3 #4 0x0000000005b448a5 in raise () from /lib64/libc.so.6 #5 0x0000000005b46085 in abort () from /lib64/libc.so.6 #6 0x00000000008d4346 in buf_flush_or_remove_page (bpage=0x7cf6420, buf_pool=0x76b8eb8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0lru.c:507 #7 buf_flush_or_remove_pages (id=10468, buf_pool=0x76b8eb8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0lru.c:564 #8 buf_flush_dirty_pages (id=, buf_pool=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0lru.c:606 #9 buf_LRU_flush_or_remove_pages (id=10468, buf_remove=BUF_REMOVE_FLUSH_NO_WRITE) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0lru.c:804 #10 0x000000000090687a in fil_delete_tablespace (id=10468, evict_all=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:2398 #11 0x0000000000841d1b in row_drop_table_for_mysql (name=0x16db44d8 "query011069/#sql2-27a8-7a4", trx=, drop_db=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:3577 #12 0x000000000081d3f3 in ha_innobase::delete_table (this=, name=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:8451 #13 0x00000000006b396c in handler::ha_delete_table (this=0x16f004a0, name=0x2691c060 "./query011069/#sql2-27a8-7a4") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3660 #14 0x00000000006b3ba4 in ha_delete_table (thd=0x101a8f20, table_type=, path=0x2691c060 "./query011069/#sql2-27a8-7a4", db=0x16d40300 "query011069", alias=0x2691df40 "#sql2-27a8-7a4", generate_warning=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:2211 #15 0x00000000006030a7 in quick_rm_table (base=0x6293750, db=0x16d40300 "query011069", table_name=0x2691df40 "#sql2-27a8-7a4", flags=3) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:2416 #16 0x0000000000606b84 in mysql_alter_table (thd=, new_db=0x16d40300 "query011069", new_name=0x16d40318 "t1", create_info=0x2691e570, table_list=, alter_info=0x2691e650, order_num=0, order=0x0, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:7004 #17 0x00000000007c1a21 in Alter_table_statement::execute (this=, thd=0x101a8f20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_alter.cc:106 #18 0x000000000059f198 in mysql_execute_command (thd=0x101a8f20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4615 #19 0x000000000059fa80 in mysql_parse (thd=0x101a8f20, rawbuf=0x16d40220 "ALTER TABLE query011069 . `t1` DROP COLUMN `c34`", length=, parser_state=0x2691fb10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #20 0x00000000005a0d9f in dispatch_command (command=COM_QUERY, thd=0x101a8f20, packet=, packet_length=48) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #21 0x00000000005a22d9 in do_command (thd=0x101a8f20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #22 0x00000000006479b1 in do_handle_one_connection (thd_arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #23 0x0000000000647aa7 in handle_one_connection (arg=0x101a8f20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #24 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #25 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 4 (LWP 23778): +bt #0 0x0000000004e3843c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000095e2f7 in os_cond_wait (mutex=0x103ecfd0, cond=0x103ed008) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x103ecfd0, reset_sig_count=29646) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000086a3fa in sync_array_wait_event (arr=0x6293c20, index=2) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000086be39 in mutex_spin_wait (mutex=0x1007c378, file_name=0xb43020 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c", line=762) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x00000000008e3c3a in mutex_enter_func (line=762, file_name=0xb43020 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c", mutex=0x1007c378) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x1007c378, file_name=0xb43020 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c", line=762) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 0x00000000008f043c in dict_table_get (table_name=0x416f300 "query111092/#sql-27a8_7a7", inc_mysql_count=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c:762 #8 0x000000000081fa86 in ha_innobase::open (this=0x1010cff0, name=, mode=, test_if_locked=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:4701 #9 0x00000000006adf89 in handler::ha_open (this=0x1010cff0, table_arg=0x169df470, name=0x169e0080 "./query111092/#sql-27a8_7a7", mode=2, test_if_locked=2) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:2320 #10 0x000000000061e685 in open_table_from_share (thd=0x16edd190, share=, alias=, db_stat=7, prgflag=, ha_open_flags=0, outparam=0x169df470, is_create_table=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/table.cc:2064 #11 0x000000000056081f in open_table_uncached (thd=0x16edd190, path=, db=, table_name=0x4171e80 "#sql-27a8_7a7", add_to_temporary_tables_list=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:6001 #12 0x0000000000604b42 in mysql_alter_table (thd=, new_db=0x16f40ac0 "query111092", new_name=0x16f40ad8 "t1", create_info=0x4172570, table_list=, alter_info=0x4172601, order_num=0, order=0x0, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:6625 #13 0x00000000007c1a21 in Alter_table_statement::execute (this=, thd=0x16edd190) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_alter.cc:106 #14 0x000000000059f198 in mysql_execute_command (thd=0x16edd190) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4615 #15 0x000000000059fa80 in mysql_parse (thd=0x16edd190, rawbuf=0x16f409e0 "ALTER TABLE query111092 . `t1` DROP COLUMN `c29`", length=, parser_state=0x4173b10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #16 0x00000000005a0d9f in dispatch_command (command=COM_QUERY, thd=0x16edd190, packet=, packet_length=48) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #17 0x00000000005a22d9 in do_command (thd=0x16edd190) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #18 0x00000000006479b1 in do_handle_one_connection (thd_arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #19 0x0000000000647aa7 in handle_one_connection (arg=0x16edd190) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #20 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #21 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 3 (LWP 11070): +bt #0 0x0000000004e3b54d in read () from /lib64/libpthread.so.0 #1 0x0000000000a1cc3d in vio_read (vio=0x1689c690, buf=0x16df54a0 "\001", size=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/vio/viosocket.c:56 #2 0x0000000000520c70 in my_real_read (net=0x16d39340, complen=0x26613d88) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:834 #3 0x0000000000520f9b in my_net_read (net=0x16d39340) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:1033 #4 0x00000000005a2176 in do_command (thd=0x16d39110) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:734 #5 0x00000000006479b1 in do_handle_one_connection (thd_arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #6 0x0000000000647aa7 in handle_one_connection (arg=0x16d39110) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #7 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #8 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 2 (LWP 11094): +bt #0 0x0000000004e3b54d in read () from /lib64/libpthread.so.0 #1 0x0000000000a1cc3d in vio_read (vio=0x17399460, buf=0x17728c10 "\001", size=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/vio/viosocket.c:56 #2 0x0000000000520c70 in my_real_read (net=0x17725ce0, complen=0x268ded88) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:834 #3 0x0000000000520f9b in my_net_read (net=0x17725ce0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:1033 #4 0x00000000005a2176 in do_command (thd=0x17725ab0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:734 #5 0x00000000006479b1 in do_handle_one_connection (thd_arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #6 0x0000000000647aa7 in handle_one_connection (arg=0x17725ab0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #7 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #8 0x0000000005bfa11d in clone () from /lib64/libc.so.6 Thread 1 (LWP 11098): +bt #0 0x0000000004e3b54d in read () from /lib64/libpthread.so.0 #1 0x0000000000a1cc3d in vio_read (vio=0x1873f6e0, buf=0x169f1c50 "\001", size=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/vio/viosocket.c:56 #2 0x0000000000520c70 in my_real_read (net=0x1012a1f0, complen=0x26960d88) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:834 #3 0x0000000000520f9b in my_net_read (net=0x1012a1f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:1033 #4 0x00000000005a2176 in do_command (thd=0x10129fc0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:734 #5 0x00000000006479b1 in do_handle_one_connection (thd_arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #6 0x0000000000647aa7 in handle_one_connection (arg=0x10129fc0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #7 0x0000000004e34851 in start_thread () from /lib64/libpthread.so.0 #8 0x0000000005bfa11d in clone () from /lib64/libc.so.6 +quit