(gdb) +thread apply all bt full Thread 48 (LWP 1531): +bt full #0 0x000000340c4df253 in poll () from /lib64/libc.so.6 No symbol table info available. #1 0x0000000000629b5a in handle_connections_sockets () at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:6243 is_unix_sock = vio_type = 4294967295 vio_flags = sock = { fd = 13, m_psi = 0x0 } retval = fds = {[0] = { fd = 13, events = 1, revents = 1 }, [1] = { fd = 14, events = 1, revents = 0 }, [2] = { fd = 22547024, events = 0, revents = 0 }} extra_ip_flags = flags = 2 pfs_fds = {[0] = { fd = 13, m_psi = 0x0 }, [1] = { fd = 14, m_psi = 0x0 }, [2] = { fd = 22296320, m_psi = 0x7feffe824 }} new_sock = { fd = 19, m_psi = 0x0 } error_count = 0 thd = cAddr = { ss_family = 10, __ss_align = 0, __ss_padding = "\000\000\377\377\177\000\000\001\000\000\000\000\a\000\000\000\267\274 \a\000\000\000\000\061\033T\001\000\000\000\000\200(X\001", '\000' , "\200\335\377\376\a\000\000\000\177dm\000\000\000\000\000F\214\337\000\000\000\000\000L\214\337\000\000\000\000\000\001\000\000\200\a", '\000' , "\060\000\000\000\060\000\000\000\220\335\377\376\a\000\000" } ip_flags = socket_flags = vio_tmp = socket_count = 2 _db_stack_frame_ = { func = 0xdf8c46 "?func", file = 0xdf8c4c "?file", level = 2147483649, prev = 0x0 } #2 0x000000000063044d in mysqld_main (argc=48, argv=0x4c2d9c8) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:5658 ho_error = #3 0x000000340c41ecdd in __libc_start_main () from /lib64/libc.so.6 No symbol table info available. #4 0x000000000062256d in _start () No symbol table info available. Thread 47 (LWP 1533): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x933edc0, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 0 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f97959f6000 end_pos = 256 events = 0x933f1c0 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=0, message1=0x5a27d98, message2=0x5a27d90, type=0x5a27d88, space_id=0x5a27d80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 0 array = 0x933edc0 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 0 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 46 (LWP 1534): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x933c980, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 0 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f97959f9000 end_pos = 256 events = 0x933cd80 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=1, message1=0x14427d98, message2=0x14427d90, type=0x14427d88, space_id=0x14427d80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 0 array = 0x933c980 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=1) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 1 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 45 (LWP 1535): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x933c570, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 0 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f9795a05000 end_pos = 256 events = 0x8ee93c0 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=2, message1=0x14e28d98, message2=0x14e28d90, type=0x14e28d88, space_id=0x14e28d80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 0 array = 0x933c570 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=2) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 2 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 44 (LWP 1536): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x933c570, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 256 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f9795a02000 end_pos = 512 events = 0x8eeb3c0 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=3, message1=0x15829d98, message2=0x15829d90, type=0x15829d88, space_id=0x15829d80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 1 array = 0x933c570 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=3) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 3 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 43 (LWP 1537): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x933c570, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 512 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f97959ff000 end_pos = 768 events = 0x8eed3c0 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=4, message1=0x1622ad98, message2=0x1622ad90, type=0x1622ad88, space_id=0x1622ad80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 2 array = 0x933c570 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=4) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 4 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 42 (LWP 1538): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x933c570, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 768 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f97959fc000 end_pos = 1024 events = 0x8eef3c0 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=5, message1=0x16c2bd98, message2=0x16c2bd90, type=0x16c2bd88, space_id=0x16c2bd80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 3 array = 0x933c570 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=5) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 5 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 41 (LWP 1539): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x9341200, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 0 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f97959f3000 end_pos = 256 events = 0x8efcc40 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=6, message1=0x1762cd98, message2=0x1762cd90, type=0x1762cd88, space_id=0x1762cd80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 0 array = 0x9341200 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=6) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 6 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 40 (LWP 1540): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x9341200, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 256 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f97959f0000 end_pos = 512 events = 0x8efec40 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=7, message1=0x1802dd98, message2=0x1802dd90, type=0x1802dd88, space_id=0x1802dd80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 1 array = 0x9341200 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=7) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 7 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 39 (LWP 1541): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x9341200, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 512 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f97959ed000 end_pos = 768 events = 0x8f00c40 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=8, message1=0x18a2ed98, message2=0x18a2ed90, type=0x18a2ed88, space_id=0x18a2ed80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 2 array = 0x9341200 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=8) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 8 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 38 (LWP 1542): +bt full #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 No symbol table info available. #1 0x0000000000a608b6 in os_aio_linux_collect (array=0x9341200, segment=, seg_size=256) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 i = ret = start_pos = 768 timeout = { tv_sec = 0, tv_nsec = 500000000 } io_ctx = 0x7f97959ea000 end_pos = 1024 events = 0x8f02c40 #2 0x0000000000a60fd9 in os_aio_linux_handle (global_seg=9, message1=0x1942fd98, message2=0x1942fd90, type=0x1942fd88, space_id=0x1942fd80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 any_reserved = segment = 3 array = 0x9341200 slot = i = ret = 0 n = 256 #3 0x0000000000baabd7 in fil_aio_wait (segment=9) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 ret = fil_node = message = type = space_id = 0 #4 0x0000000000afac28 in io_handler_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 segment = 9 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 37 (LWP 1545): +bt full #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a66571 in os_cond_wait_timed (cond=, fast_mutex=, abstime=0x1ae30d10) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 mutex = ret = #2 0x0000000000a66693 in os_event_wait_time_low (event=0x931ed30, time_in_usec=, reset_sig_count=1) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 timed_out = 0 abstime = { tv_sec = 1373964892, tv_nsec = 272873000 } #3 0x0000000000af5abf in srv_error_monitor_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:2084 old_lsn = 2504025 sig_count = waiter = 559175424 old_waiter = 559175424 sema = 0x196392b8 old_sema = 0x196392b8 fatal_cnt = 0 new_lsn = 2504025 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 36 (LWP 1544): +bt full #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a66571 in os_cond_wait_timed (cond=, fast_mutex=, abstime=0x1b831d60) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 mutex = ret = #2 0x0000000000a66693 in os_event_wait_time_low (event=0x12e220e0, time_in_usec=, reset_sig_count=29) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 timed_out = 0 abstime = { tv_sec = 1373964892, tv_nsec = 274792000 } #3 0x0000000000a46390 in lock_wait_timeout_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/lock/lock0wait.cc:503 slot = sig_count = 29 event = 0x12e220e0 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 35 (LWP 1546): +bt full #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a66571 in os_cond_wait_timed (cond=, fast_mutex=, abstime=0x1c232d30) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 mutex = ret = #2 0x0000000000a66693 in os_event_wait_time_low (event=0x931edf0, time_in_usec=, reset_sig_count=1) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 timed_out = 0 abstime = { tv_sec = 1373964892, tv_nsec = 77994000 } #3 0x0000000000af717d in srv_monitor_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:1822 sig_count = time_elapsed = last_tablespace_monitor_time = 1373964783 last_monitor_time = 1373964876 current_time = last_table_monitor_time = 1373964783 mutex_skipped = 0 last_srv_print_monitor = 0 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 34 (LWP 1547): +bt full #0 0x000000340c4e14f3 in select () from /lib64/libc.so.6 No symbol table info available. #1 0x0000000000a66e5f in os_thread_sleep (tm=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0thread.cc:255 t = { tv_sec = 1, tv_usec = 0 } #2 0x0000000000af4c1c in srv_master_sleep () at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:2803 No locals. #3 0x0000000000af8555 in srv_master_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:2847 slot = 0x931e978 old_activity_count = 1090 last_print_time = 1373964783 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 33 (LWP 1548): +bt full #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a66773 in os_cond_wait (cond=, fast_mutex=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 mutex = #2 0x0000000000a6683b in os_event_wait_low (event=0x931ec70, reset_sig_count=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610 No locals. #3 0x0000000000af43a0 in srv_purge_coordinator_suspend (slot=0x931e9b0, rseg_history_len=319) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:3140 ret = stop = sig_count = 401 #4 0x0000000000af4632 in srv_purge_coordinator_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:3257 slot = 0x931e9b0 n_total_purged = 0 rseg_history_len = 319 n_pages_purged = #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 32 (LWP 1549): +bt full #0 0x000000340c4e14f3 in select () from /lib64/libc.so.6 No symbol table info available. #1 0x0000000000a66e5f in os_thread_sleep (tm=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0thread.cc:255 t = { tv_sec = 0, tv_usec = 0 } #2 0x0000000000b6d10a in buf_flush_page_cleaner_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0flu.cc:2418 next_loop_time = 1373964891688 n_flushed = 0 last_activity = 1034 success = #3 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #4 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 31 (LWP 1550): +bt full #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a66773 in os_cond_wait (cond=, fast_mutex=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 mutex = #2 0x0000000000a6683b in os_event_wait_low (event=0x931eeb0, reset_sig_count=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610 No locals. #3 0x0000000000b6792c in buf_dump_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0dump.cc:594 No locals. #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 30 (LWP 1551): +bt full #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a66571 in os_cond_wait_timed (cond=, fast_mutex=, abstime=0x1f437d70) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 mutex = ret = #2 0x0000000000a66693 in os_event_wait_time_low (event=0x12e26c60, time_in_usec=, reset_sig_count=11) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 timed_out = 0 abstime = { tv_sec = 1373964901, tv_nsec = 404710000 } #3 0x0000000000ba2db2 in dict_stats_thread (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0stats_bg.cc:349 No locals. #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 29 (LWP 1552): +bt full #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a66571 in os_cond_wait_timed (cond=, fast_mutex=, abstime=0x1fe38cf0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 mutex = ret = #2 0x0000000000a66693 in os_event_wait_time_low (event=0x139fb690, time_in_usec=, reset_sig_count=1) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 timed_out = 0 abstime = { tv_sec = 1373964894, tv_nsec = 88422000 } #3 0x0000000000b27ae0 in ib_wqueue_timedwait (wq=0x196804d8, wait_in_usecs=5000000) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/ut/ut0wqueue.cc:154 error = sig_count = 1 node = #4 0x0000000000bd0bcc in fts_optimize_thread (arg=0x196804d8) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/fts/fts0opt.cc:2932 msg = heap = heap_alloc = current = done = 0 n_tables = n_optimize = wq = 0x196804d8 tables = 0x139fb7e8 exit_event = #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 28 (LWP 1553): +bt full #0 0x000000340cc0f2a5 in sigwait () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000628d5b in signal_hand (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:3159 error = set = { __val = {[0] = 548869, [1] = 0 } } sig = 0 #2 0x00000000009e4ce9 in pfs_spawn_thread (arg=0x196a6eb0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 typed_arg = 0x196a6eb0 user_arg = 0x0 pfs = user_start_routine = 0x628b90 klass = #3 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #4 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 27 (LWP 1554): +bt full #0 0x000000340c4df253 in poll () from /lib64/libc.so.6 No symbol table info available. #1 0x0000000000c77584 in vio_io_wait (vio=, event=VIO_IO_EVENT_READ, timeout=28800000) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:820 ret = revents = 8251 pfd = { fd = 34, events = 3, revents = 0 } sd = locker = 0x0 state = { m_flags = 427498960, m_socket = 0xffffffffffffffff, m_thread = 0x22, m_number_of_bytes = 13076320, m_timer_start = 428546800, m_timer = 0x340cc0e964 , m_operation = 34, m_src_file = 0x0, m_src_line = 425144544, m_wait = 0x198b2688 } _db_stack_frame_ = { func = 0xffb75b "vio_read", file = 0xffb430 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/vio/viosocket.c", level = 2147483651, prev = 0x198b1b70 } __PRETTY_FUNCTION__ = "vio_io_wait" #2 0x0000000000c77913 in vio_socket_io_wait (vio=, event=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:68 timeout = ret = __PRETTY_FUNCTION__ = "vio_socket_io_wait" #3 0x0000000000c7880f in vio_read (vio=0x19572dd0, buf=0x197b1dd0 "\a", size=4) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:123 error = ret = -1 flags = 64 _db_stack_frame_ = { func = 0xcc2124 "do_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483650, prev = 0x198b1cf0 } __PRETTY_FUNCTION__ = "vio_read" #4 0x00000000006e194f in net_read_raw_loop (net=0x197ae320, count=4) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:663 recvcnt = eof = false retry_count = 0 buf = #5 0x00000000006e1a60 in net_read_packet_header (net=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:745 user_data = 0x197ae0c0 pkt_nr = count = 4 __PRETTY_FUNCTION__ = "my_bool net_read_packet_header(NET*)" rc = server_extension = 0x197ae5c8 #6 0x00000000006e25e4 in net_read_packet (net=0x197ae320, complen=0x198b1c98) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:810 pkt_len = pkt_data_len = __PRETTY_FUNCTION__ = "ulong net_read_packet(NET*, size_t*)" #7 0x00000000006e284c in my_net_read (net=0x197ae320) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:888 len = complen = #8 0x000000000077d485 in do_command (thd=0x197ae0c0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:983 return_value = packet = 0x0 packet_length = net = 0x197ae320 command = __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = { func = 0xdf8c46 "?func", file = 0xdf8c4c "?file", level = 2147483649, prev = 0x0 } #9 0x0000000000746ecf in do_handle_one_connection (thd_arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 rc = create_user = true net = thd = 0x197ae0c0 #10 0x0000000000746f90 in handle_one_connection (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 thd = 0x197ae0c0 #11 0x00000000009e4ce9 in pfs_spawn_thread (arg=0x19573000) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 typed_arg = 0x19573000 user_arg = 0x197ae0c0 pfs = user_start_routine = 0x746f70 klass = #12 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #13 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 26 (LWP 1558): +bt full #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x00000000006dd5d0 in inline_mysql_cond_timedwait (that=0x19fb1ad8, mutex=0x19fb1aa8, abstime=0x198f0d50, src_file=, src_line=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 result = #2 0x00000000006dd715 in MDL_wait::timed_wait (this=0x19fb1aa8, owner=0x19fb1970, abs_timeout=0x198f0d50, set_status_on_timeout=true, wait_state_name=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 old_stage = { m_key = 46, m_name = 0xc82ec9 "Opening tables", m_flags = 435886760 } result = wait_result = __FUNCTION__ = "timed_wait" #3 0x00000000006dee2f in MDL_context::acquire_lock (this=0x19fb1aa8, mdl_request=0x1febcf48, lock_wait_timeout=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 ticket = 0x19503250 __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, ulong)" lock = 0x19466980 abs_timeout = { tv_sec = 1405500880, tv_nsec = 992976600 } wait_status = #4 0x0000000000721b09 in open_table_get_mdl_lock (thd=0x19fb1970, ot_ctx=0x198f1410, mdl_request=0x1febcf48, flags=, mdl_ticket=0x198f1290) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 mdl_deadlock_handler = { = { _vptr.Internal_error_handler = 0x1415a90 , m_prev_internal_handler = 0x0 }, members of MDL_deadlock_handler: m_ot_ctx = 0x198f1410, m_is_active = false } result = mdl_request_shared = { type = 21459752, duration = MDL_STATEMENT, next_in_list = 0x195332e8, prev_in_list = 0x198f0e40, ticket = 0x98b03e , key = { m_length = 6512, m_db_name_length = 6651, m_ptr = "\000\000\000\000\240\223N\031\000\000\000\000\063\265\310\000\000\000\000\000X\335\310\000\000\000\000\000\220A\375\031\000\000\000\000\252\341c\000\000\000\000\000\220A\375\031\000\000\000\000HC\375\031", '\000' , "`\016\217\031\000\000\000\000(sG\001", '\000' , "\260\016\217\031\000\000\000\000\000\032X\031\000\000\000\000\000\032X\031\000\000\000\000\000\032X\031\000\000\000\000\000\032X\031\000\000\000\000\000\032X\031\000\000\000\000\000\032X\031\000\000\000\000\210\066\217\031\000\000\000\000\240\016\217\031\000\000\000\000j\220\304\000\000\000\000\000\000\032X\031\000\000\000\000\t\000\000\200\000\000\000\000\360\016\217\031\000\000\000\000\202\235\304\000\000\000\000\000\000\017\217\031\000\000\000\000\000\032X\031x\b\000\000\000\032X\031\000\000\000\000\070xC \000\000\000\000\000\017\217\031\000\000\000\000p\031\373\031\000\000\000\000p\031\373\031\000\000\000\000\002\000\000\000\000\000\000\000@\017\217\031\000\000\000\000\302\217\237\000\000\000\000\000?\245\313\000\000\000\000\000H\002\313\000\000\000\000\000\t\000\000\200\000\000\000\000`\022\217\031\000\000\000\000p\031\373\031\000\000\000\000\230.\373\031\000\000\000\000г\353\037\000\000\000\000\000\032X\031\000\000\000\000\000\032X\031\000\000\000\000\210\066\217\031\000\000\000\000p\017\217\031\000\000\000\000j\220\304\000\000\000\000\000\200\017\217\031\000\000", static m_namespace_to_wait_state_name = {[0] = { m_key = 102, m_name = 0xca684d "Waiting for global read lock", m_flags = 0 }, [1] = { m_key = 103, m_name = 0xca6df8 "Waiting for schema metadata lock", m_flags = 0 }, [2] = { m_key = 104, m_name = 0xca6e20 "Waiting for table metadata lock", m_flags = 0 }, [3] = { m_key = 105, m_name = 0xca6e40 "Waiting for stored function metadata lock", m_flags = 0 }, [4] = { m_key = 106, m_name = 0xca6e70 "Waiting for stored procedure metadata lock", m_flags = 0 }, [5] = { m_key = 107, m_name = 0xca6ea0 "Waiting for trigger metadata lock", m_flags = 0 }, [6] = { m_key = 108, m_name = 0xca6ec8 "Waiting for event metadata lock", m_flags = 0 }, [7] = { m_key = 109, m_name = 0xca686a "Waiting for commit lock", m_flags = 0 }} } } __PRETTY_FUNCTION__ = "bool open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, uint, MDL_ticket**)" #5 0x000000000072640a in open_table (thd=0x19fb1970, table_list=0x1febcba8, ot_ctx=0x198f1410) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 table = key = alias = 0x1febcba0 "F" flags = 0 _db_stack_frame_ = { func = 0xcb0116 "open_and_process_table", file = 0xcb0248 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", level = 2147483656, prev = 0x198f1320 } __PRETTY_FUNCTION__ = "bool open_table(THD*, TABLE_LIST*, Open_table_context*)" mdl_ticket = key_length = 7 error = share = hash_value = #6 0x0000000000727bf1 in open_and_process_table (thd=0x19fb1970, lex=0x19fb3d38, tables=0x1febcba8, counter=0x19fb3df0, flags=, prelocking_strategy=0x198f1500, has_prelocking_list=false, ot_ctx=0x198f1410) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 error = safe_to_ignore_table = false _db_stack_frame_ = { func = 0xcaff08 "open_tables", file = 0xcb0248 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", level = 2147483655, prev = 0x198f1440 } __PRETTY_FUNCTION__ = "bool open_and_process_table(THD*, LEX*, TABLE_LIST*, uint*, uint, Prelocking_strategy*, bool, Open_table_context*)" #7 0x0000000000727f62 in open_tables (thd=0x19fb1970, start=0x198f14c8, counter=0x19fb3df0, flags=0, prelocking_strategy=0x198f1500) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 some_routine_modifies_data = false _db_stack_frame_ = { func = 0xcb1640 "open_normal_and_derived_tables", file = 0xcb0248 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", level = 2147483654, prev = 0x198f14d0 } xa_state = __PRETTY_FUNCTION__ = "bool open_tables(THD*, TABLE_LIST**, uint*, uint, Prelocking_strategy*)" table_to_open = 0x1febb3d8 ot_ctx = { m_failed_table = 0x0, m_start_of_statement_svp = { m_stmt_ticket = 0x0, m_trans_ticket = 0x195de550 }, m_timeout = 31536000, m_flags = 0, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = true, m_has_protection_against_grl = false } has_prelocking_list = false __FUNCTION__ = "open_tables" sroutine_to_open = 0x19fb3dd0 tables = error = false #8 0x00000000007285a6 in open_normal_and_derived_tables (thd=0x19fb1970, tables=0x1ff3b668, flags=0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 prelocking_strategy = { = { _vptr.Prelocking_strategy = 0x1415a50 }, } mdl_savepoint = { m_stmt_ticket = 0x0, m_trans_ticket = 0x195de550 } _db_stack_frame_ = { func = 0xcc1ea1 "mysql_execute_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483653, prev = 0x198f2230 } __PRETTY_FUNCTION__ = "bool open_normal_and_derived_tables(THD*, TABLE_LIST*, uint)" #9 0x000000000077439b in execute_sqlcom_select (thd=0x19fb1970, all_tables=0x1ff3b668) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 lex = 0x19fb3d38 result = 0x0 res = #10 0x0000000000777b6e in mysql_execute_command (thd=0x19fb1a58) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 res = lex = 0x19fb3d38 _db_stack_frame_ = { func = 0xcc2076 "mysql_parse", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483652, prev = 0x198f2310 } __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" trace_command = { = { started = false, requires_key = 25, has_disabled_I_S = 251, empty = 25, stmt = 0x993ec6 , saved_key = 0x198f21f0 " \"\217\031", previous_key = "p\031\373\031", '\000' , " " }, } trace_command_steps = { = { started = false, requires_key = 26, has_disabled_I_S = 88, empty = 25, stmt = 0x198f3688, saved_key = 0x198f21b0 "\232\v", previous_key = "j\220\304\000\000\000\000\000\250\261\363\037\000\000\000\000\n\000\000\000\000\000\000\000\232" }, } up_result = 0 ots = { ctx = 0x19fb3d18, error = false } __FUNCTION__ = "mysql_execute_command" select_lex = 0x19fb4448 first_table = 0x1ff3b668 all_tables = 0x1ff3b668 unit = 0x19fb3e00 have_table_map_for_update = false #11 0x000000000077bc88 in mysql_parse (thd=0x19fb1970, rawbuf=0x19fb1978 "\340cA\001", length=, parser_state=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 lex = 0x19fb3d38 err = found_semicolon = 0x0 qlen = 251 _db_stack_frame_ = { func = 0xcc208f "dispatch_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483651, prev = 0x198f2c40 } start_usecs = 1373964879171707 end_usecs = 0 start_cpu_nsecs = 18370642137 end_cpu_nsecs = 0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" end_time_error = 0 cputime_error = 0 __FUNCTION__ = "mysql_parse" error = start_time_error = 0 start_time = { tv_sec = 1373964879, tv_usec = 171707 } end_time = { tv_sec = 435886448, tv_usec = 428813024 } tp = { tv_sec = 18, tv_nsec = 370642137 } #12 0x000000000077c81f in dispatch_command (command=, thd=0x19fb1970, packet=, packet_length=536059563) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 packet_end = 0x1ff39eab "" parser_state = { m_lip = { m_thd = 0x19fb1970, yylineno = 1, yytoklen = 1, yylval = 0x198f2150, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x1ff39eac "\004", m_tok_start = 0x1ff39eac "\004", m_tok_end = 0x1ff39eac "\004", m_end_of_query = 0x1ff39eab "", m_tok_start_prev = 0x1ff39eab "", m_buf = 0x1ff39db0 "SELECT ( SELECT `col_datetime_key` FROM `D` WHERE `pk` = 1429602304 ) FROM `C` AS X LEFT JOIN `E` AS Y USING ( `col_varchar_1024_utf8_key` ) WHERE X . `col_varchar_1024_utf8_key` = ( SELECT `col_varchar_10_utf8_key` FROM `F` WHERE `pk` = 'a' ) LIMIT 7", m_buf_length = 251, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x1ff39f10 "SELECT ( SELECT `col_datetime_key` FROM `D` WHERE `pk` = 1429602304 ) FROM `C` AS X LEFT JOIN `E` AS Y USING ( `col_varchar_1024_utf8_key` ) WHERE X . `col_varchar_1024_utf8_key` = ( SELECT `col_varchar_10_utf8_key` FROM `F` WHERE `pk` = 'a' ) LIMIT 7", m_cpp_ptr = 0x1ff3a00b "", m_cpp_tok_start = 0x1ff3a00b "", m_cpp_tok_start_prev = 0x1ff3a00b "", m_cpp_tok_end = 0x1ff3a00b "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x200d3990 "\003SELECT ( SELECT `col_datetime_key` FROM `D` WHERE `pk` = 1429602304 ) FROM `C` AS X LEFT JOIN `E` AS Y USING ( `col_varchar_1024_utf8_key` ) WHERE X . `col_varchar_1024_utf8_key` = ( SELECT `col_varchar_10_utf8_key` FROM `F` WHERE `pk` = 'a' ) LIMIT 7", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 103 'g', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = (DISCARD_COMMENT | unknown: 10043076), m_cpp_text_start = 0x1ff3a00a "7", m_cpp_text_end = 0x1ff3a00b "", m_underscore_cs = 0x0, m_digest_psi = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {[0] = 0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ, m_ha_rkey_mode = HA_READ_KEY_EXACT } } net = 0x19fb1bd0 __FUNCTION__ = "dispatch_command" __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_stack_frame_ = { func = 0xcc2124 "do_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483650, prev = 0x198f2cf0 } #13 0x000000000077d4f5 in do_command (thd=0x19fb1970) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 return_value = packet = 0x200d3990 "\003SELECT ( SELECT `col_datetime_key` FROM `D` WHERE `pk` = 1429602304 ) FROM `C` AS X LEFT JOIN `E` AS Y USING ( `col_varchar_1024_utf8_key` ) WHERE X . `col_varchar_1024_utf8_key` = ( SELECT `col_varchar_10_utf8_key` FROM `F` WHERE `pk` = 'a' ) LIMIT 7" packet_length = net = 0x19fb1bd0 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = { func = 0xdf8c46 "?func", file = 0xdf8c4c "?file", level = 2147483649, prev = 0x0 } #14 0x0000000000746ecf in do_handle_one_connection (thd_arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 rc = create_user = true net = thd = 0x19fb1970 #15 0x0000000000746f90 in handle_one_connection (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 thd = 0x19579b20 #16 0x00000000009e4ce9 in pfs_spawn_thread (arg=0x197c1be0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 typed_arg = 0x197c1be0 user_arg = 0x19579b20 pfs = user_start_routine = 0x746f70 klass = #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 25 (LWP 1564): +bt full #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x0000000000a66773 in os_cond_wait (cond=, fast_mutex=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 mutex = #2 0x0000000000a6683b in os_event_wait_low (event=0x1948e4d0, reset_sig_count=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610 No locals. #3 0x0000000000a46c82 in lock_wait_suspend_thread (thr=0x1a053a00) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/lock/lock0wait.cc:322 wait_time = sec = 1373964878 lock_wait_timeout = 50 slot = 0x13828488 lock_type = 32 trx = 0x1a1cd388 had_dict_lock = 0 was_declared_inside_innodb = 0 start_time = 1373964878913819 finish_time = ms = 913819 #4 0x0000000000abf497 in row_mysql_handle_errors (new_err=0x19931d5c, trx=0x1a1cd388, thr=, savept=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0mysql.cc:631 err = DB_LOCK_WAIT #5 0x0000000000adcdef in row_search_for_mysql (buf=0x1ff67e20 "\377\377", mode=1, prebuilt=0x1a0531d8, match_mode=0, direction=0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0sel.cc:5034 index = 0x19f08ea8 clust_index = 0x19f08ea8 thr = 0x1a053a00 mtr_has_extra_clust_latch = 0 moves_up = 1 offsets_ = {[0] = 100, [1] = 13, [2] = 181731459, [3] = 435195560, [4] = 2147483659, [5] = 4, [6] = 10, [7] = 17, [8] = 21, [9] = 26, [10] = 31, [11] = 35, [12] = 40, [13] = 41, [14] = 44, [15] = 49, [16] = 54, [17] = 57, [18] = 0, [19] = 54271219634282, [20] = 0, [21] = 149852960, [22] = 429071096, [23] = 149852960, [24] = 149852960, [25] = 429082248, [26] = 429071088, [27] = 12845056, [28] = 537050160, [29] = 537050192, [30] = 537050256, [31] = 537050320, [32] = 537050384, [33] = 537050448, [34] = 429072160, [35] = 429082248, [36] = 429071168, [37] = 12882026, [38] = 1, [39] = 149852960, [40] = 429071760, [41] = 12886430, [42] = 13968612, [43] = 36039084549656, [44] = 2147483655, [45] = 429072160, [46] = 540831008, [47] = 1, [48] = 429071280, [49] = 6873175, [50] = 540831248, [51] = 2, [52] = 2, [53] = 0, [54] = 429071328, [55] = 6873175, [56] = 429071328, [57] = 6784597, [58] = 540831248, [59] = 540273560, [60] = 429071648, [61] = 9300180, [62] = 0, [63] = 149852960, [64] = 149852960, [65] = 149852960, [66] = 429072048, [67] = 429082248, [68] = 429071424, [69] = 12882026, [70] = 429071488, [71] = 149852960, [72] = 429072096, [73] = 429082248, [74] = 429071472, [75] = 10448981, [76] = 436548056, [77] = 537339440, [78] = 429071632, [79] = 10485952, [80] = 12, [81] = 545794768, [82] = 435195560, [83] = 10, [84] = 1296236545, [85] = 439158472, [86] = 120, [87] = 0, [88] = 0, [89] = 0, [90] = 540831248, [91] = 18446744073709551615, [92] = 429072176, [93] = 437211712, [94] = 10, [95] = 435195560, [96] = 435195560, [97] = 11, [98] = 429071760, [99] = 10486906} table_lock_waited = 0 search_tuple = pcur = 0x1a053250 trx = 0x1a1cd388 rec = 0xad50083 "\200" err = DB_LOCK_WAIT unique_search = set_also_gap_locks = 1 did_semi_consistent_read = 0 same_user_rec = 0 offsets = 0x19931a00 comp = 1 clust_rec = 0x19f08ea8 "\034" mtr = { state = 34676, memo = { heap = 0x0, used = 48, data = "7", '\000' , "\003", '\000' , "\001", '\000' , " \223\356\b\000\000\000\000 \223\356\b\000\000\000\000\210F\223\031\000\000\000\000\260\025\223\031\000\000\000\000j\220\304\000\000\000\000\000\300\025\223\031\000\000\000\000\217\306m\000\000\000\000\000\025\001\000\000\000\000\000\000\306>\231\000\000\000\000\000Ч\262\b\000\000\000\000\306>\231\000\000\000\000\000\360\025\223\031\000\000\000\000Ч\262\b\000\000\000\000\300\250\262\b\000\000\000\000_\224\231\000\000\000\000\000\000-s\031\000\000\000\000\000-s\031\000\000\000\000p\026\223\031\000\000\000\000\235\320m\000\000\000\000\000\240\030\223\031\000\000\000\000 \223\356\b\000\000\000\000\300\030\223\031\000\000\000\000\210F\223\031\000\000\000\000P\026\223\031\000\000\000\000j\220\304\000\000\000\000\000`\026\223\031\000\000\000\000 \223\356\b\000\000\000\000\240\030\223\031\000\000\000\000\236\241\304\000\000\000\000\000\260\030\223\031\000\000\000\000\236\241\304\000,\037\000\000\300\026\223\031\000\000\000\000\346\332m\000\311\030\000\000Ч\262\b\000\000\000\000 \223\356\b\000\000\000\000P\036\223\031\000\000\000\000\210F\223\031\000\000\000\000\300\026\223\031\000\000\000\000j\220\304\000\000\000\000\000\020\027\223\031\000\000\000\000 \223\356\b\000\000\000\000\020\031\223\031\000\000\000\000\236\241\304\000\000\000\000\000\n\000\000\200\000\000\000\000@\027\223\031\202\037\000\000\000\027\223\031\000\000\000\000\320*\210 \000\000\000\000\060&\a \000\000\000\000Ti< \000\000\000\000@\027\223\031\000\000\000\000 \223\356\b\000\000\000\000\060\032\223\031\000\000\000\000\210F\223\031\000\000\000\000@\027\223\031\000\000\000\000j\220\304\000\000\000\000\000\f\000\000\000\000\000\000\001 \223\356\b\000\000\000\000\220\031\223\031\000\000\000", base = { count = 12886430, start = 0x80000009, end = 0x1b3a19931830 }, list = { prev = 0x19931780, next = 0x203c5f98 }, buf_end = 0, magic_n = 0 }, log = { heap = 0x0, used = 0, data = "\260\027\223\031\000\000\000\000j\220\304\000\000\000\000\000\060\032\223\031\000\000\000\000 \223\356\b\000\000\000\000\000\032\223\031\000\000\000\000\236\241\304\000\000\000\000\000@\277\063 \000\000\000\000 \223\356\b_\027\000\000\360\027\223\031\000\000\000\000Up\237\000\000\000\000\000\330\061\005\032\000\000\000\000\060&\a \000\000\000\000\220\030\223\031\000\000\000\000\300\000\240\000\000\000\000\000\f\000\000\000\000\000\000\000\320*\210 \000\000\000\000\250\216\360\031\000\000\000\000\n\000\000\000\000\000\000\000\001\000CM\000\000\000\000\310\006-\032\000\000\000\000x", '\000' , "\240\030\223\031\000\000\000\000\377\377\377\377\377\377\377\377\300\030\223\031\000\000\000\000@R\017\032\000\000\000\000\n\000\000\000\000\000\000\000\250\216\360\031\000\000\000\000\330\061\005\032\000\000\000\000\v\000\000\000\000\000\000\000\020\031\223\031\000\000\000\000z\004\240\000\000\000\000\000\020\031\223\031\000\000\000\000&՟\000\000\000\000\000\020\031\223\031", '\000' , "\250\216\360\031\000\000\000\000\t\000\000\200\000\000\000\000\230\066\005\032\000\000\000\001\000\031\223\031\000\000\000\000P\036\223\031\000\000\000\000@R\017\032", '\000' , "\330\061\005\032\000\000\000\000\060\037\223\031\000\000\000\000\220\036\223\031\000\000\000\000\372\034\240\000\000\000\000\000@\031\223\031\000\000\000\000`ET\001\000\000\000\000\025\000\000\000\000\000\000\001@\277\063 \000\000\000\000f\373\312\000\000\000\000\000H\002\313\000\000\000\000\000\b\000\000\200\000\000\000\000\060\032\223\031\000\000\000\000\200\031\223\031\000\000\000\000 \223\356\b\000\000\000\000\000\034\223\031\000\000\000\000\210F\223\031\000\000\000\000\240\031\223\031\000\000\000\000j\220\304\000\000\000\000", base = { count = 429070992, start = 0x8ee9320, end = 0x19931bf0 }, list = { prev = 0xc4a19e <_db_return_+222>, next = 0x19931a00 }, buf_end = 0, magic_n = 0 }, inside_ibuf = 0, modifications = 0, made_dirty = 0, n_log_recs = 0, n_freed_pages = 0, log_mode = 21, start_lsn = 149852960, end_lsn = 429071424, magic_n = 54551 } next_buf = 0x0 result_rec = 0x0 next_offs = heap = 0x0 #6 0x0000000000a096d1 in ha_innobase::index_read (this=0x1a0f5240, buf=0x1ff67e20 "\377\377", key_ptr=0x0, key_len=0, find_flag=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:7848 ret = __PRETTY_FUNCTION__ = "virtual int ha_innobase::index_read(uchar*, const uchar*, uint, ha_rkey_function)" mode = index = match_mode = 0 error = _db_stack_frame_ = { func = 0xd96b9c "index_first", file = 0xd9a778 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc", level = 2147483657, prev = 0x19931e30 } #7 0x00000000009ff4f0 in ha_innobase::index_first (this=0x1a0f5240, buf=0x1ff67e20 "\377\377") at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:8245 error = _db_stack_frame_ = { func = 0xd85bf6 "rnd_next", file = 0xd9a778 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc", level = 2147483656, prev = 0x19931e80 } #8 0x0000000000a0928f in ha_innobase::rnd_next (this=0x1a0f5240, buf=0x1ff67e20 "\377\377") at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:8342 error = _db_stack_frame_ = { func = 0xc8af05 "handler::ha_rnd_next", file = 0xc8dd58 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/handler.cc", level = 2147483655, prev = 0x19931f10 } #9 0x000000000063c10a in handler::ha_rnd_next (this=0x1a0f5240, buf=0x1ff67e20 "\377\377") at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/handler.cc:2667 locker = 0x19931ed0 state = { m_flags = 3, m_io_operation = PSI_TABLE_FETCH_ROW, m_table = 0x6964580, m_table_share = 0xcd282b, m_thread = 0x6e2f200, m_timer_start = 462305777, m_timer = 0xc483e0 , m_wait = 0x19931f20, m_index = 64 } result = _db_stack_frame_ = { func = 0xcd282b "mysql_update", file = 0xcd2468 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc", level = 2147483654, prev = 0x199324d0 } __PRETTY_FUNCTION__ = "int handler::ha_rnd_next(uchar*)" #10 0x00000000008b8b4c in rr_sequential (info=0x19932370) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/records.cc:478 tmp = #11 0x00000000007e4ec2 in mysql_update (thd=0x2033bf40, table_list=0x203c5f98, fields=..., values=..., conds=0xca, order_num=429073552, order=0x1, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x19933268, updated_return=0x19933270) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:734 safe_update = false used_index = 0 want_privilege = 0 __PRETTY_FUNCTION__ = "int mysql_update(THD*, TABLE_LIST*, List&, List&, Item*, uint, ORDER*, ha_rows, enum_duplicates, bool, ha_rows*, ha_rows*)" transactional_table = true will_batch = false reverse = false id = used_key_is_modified = select_lex = 0x2033ea18 res = dup_key_found = 0 found = 0 old_covering_keys = { map = 32 } table = 0x20882ad0 update = { = {}, members of COPY_INFO: _vptr.COPY_INFO = 0x142d350 , m_optype = COPY_INFO::UPDATE_OPERATION, m_changed_columns = 0x2033eb38, m_changed_columns2 = 0x0, m_manage_defaults = true, m_function_default_columns = 0x203c7180, handle_duplicates = DUP_ERROR, ignore = false, stats = { records = 0, deleted = 0, updated = 0, copied = 0, error_count = 0, touched = 0 }, escape_char = 0, last_errno = 0, update_values = 0x2033ef58 } _db_stack_frame_ = { func = 0xcc1ea1 "mysql_execute_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483653, prev = 0x19933230 } loc_error = need_sort = false updated = 0 select = 0x203c71b0 info = { table = 0x20882ad0, forms = 0x19932370, unlock_row = 0x8b8a90 , read_record = 0x8b8b30 , thd = 0x2033bf40, select = 0x203c71b0, cache_records = 0, ref_length = 4, struct_length = 0, reclength = 0, rec_cache_size = 0, error_offset = 0, index = 0, ref_pos = 0x0, record = 0x1ff67e20 "\377\377", rec_buf = 0x0, cache = 0x0, cache_pos = 0x0, cache_end = 0x0, read_positions = 0x0, io_cache = 0x0, print_error = true, ignore_not_found_rows = false } __FUNCTION__ = "mysql_update" using_limit = false error = 0 using_filesort = false read_removal = false all_fields = { = { = {}, members of base_list: first = 0x154ace0 , last = 0x199324f0, elements = 0 }, } killed_status = THD::NOT_KILLED #12 0x0000000000777c5e in mysql_execute_command (thd=0x2033c028) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3511 found = 0 updated = 0 res = 0 lex = 0x2033e308 _db_stack_frame_ = { func = 0xcc2076 "mysql_parse", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483652, prev = 0x19933310 } __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" trace_command = { = { started = false, requires_key = 191, has_disabled_I_S = 51, empty = 32, stmt = 0x993ec6 , saved_key = 0x199331f0 " 2\223\031", previous_key = "@\277\063 ", '\000' , " " }, } trace_command_steps = { = { started = false, requires_key = 147, has_disabled_I_S = 238, empty = 8, stmt = 0x19934688, saved_key = 0x199331b0 "\232\v", previous_key = "j\220\304\000\000\000\000\000xl< \000\000\000\000\002\000\000\000\000\000\000\000\232" }, } up_result = 0 ots = { ctx = 0x2033e2e8, error = false } __FUNCTION__ = "mysql_execute_command" select_lex = 0x2033ea18 first_table = 0x203c5f98 all_tables = 0x203c5f98 unit = 0x2033e3d0 have_table_map_for_update = false #13 0x000000000077bc88 in mysql_parse (thd=0x2033bf40, rawbuf=0x2033bf48 "\340cA\001", length=, parser_state=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 lex = 0x2033e308 err = found_semicolon = 0x0 qlen = 140 _db_stack_frame_ = { func = 0xcc208f "dispatch_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483651, prev = 0x19933c40 } start_usecs = 1373964878907344 end_usecs = 0 start_cpu_nsecs = 686824461 end_cpu_nsecs = 0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" end_time_error = 0 cputime_error = 0 __FUNCTION__ = "mysql_parse" error = start_time_error = 0 start_time = { tv_sec = 1373964878, tv_usec = 907344 } end_time = { tv_sec = 540262208, tv_usec = 429079264 } tp = { tv_sec = 0, tv_nsec = 686824461 } #14 0x000000000077c81f in dispatch_command (command=, thd=0x2033bf40, packet=, packet_length=540827212) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 packet_end = 0x203c5e4c "" parser_state = { m_lip = { m_thd = 0x2033bf40, yylineno = 1, yytoklen = 2, yylval = 0x19933150, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x203c5e4d "\004", m_tok_start = 0x203c5e4d "\004", m_tok_end = 0x203c5e4d "\004", m_end_of_query = 0x203c5e4c "", m_tok_start_prev = 0x203c5e4c "", m_buf = 0x203c5dc0 "UPDATE `B` SET `col_varchar_1024_utf8` = CONVERT( 'she' , CHAR) WHERE `col_date_key` BETWEEN REPEAT( 0x354 , 255 ) AND REPEAT( 0xC502 , 51 )", m_buf_length = 140, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x203c5eb8 "UPDATE `B` SET `col_varchar_1024_utf8` = CONVERT( 'she' , CHAR) WHERE `col_date_key` BETWEEN REPEAT( 0x354 , 255 ) AND REPEAT( 0xC502 , 51 )", m_cpp_ptr = 0x203c5f44 "", m_cpp_tok_start = 0x203c5f44 "", m_cpp_tok_start_prev = 0x203c5f44 "", m_cpp_tok_end = 0x203c5f44 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x205dc380 "\003UPDATE `B` SET `col_varchar_1024_utf8` = CONVERT( 'she' , CHAR) WHERE `col_date_key` BETWEEN REPEAT( 0x354 , 255 ) AND REPEAT( 0xC502 , 51 )", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 127 '\177', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = (DISCARD_COMMENT | unknown: 10043076), m_cpp_text_start = 0x203c5f40 "51 )", m_cpp_text_end = 0x203c5f42 " )", m_underscore_cs = 0x0, m_digest_psi = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {[0] = 0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ, m_ha_rkey_mode = HA_READ_KEY_EXACT } } net = 0x2033c1a0 __FUNCTION__ = "dispatch_command" __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_stack_frame_ = { func = 0xcc2124 "do_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483650, prev = 0x19933cf0 } #15 0x000000000077d4f5 in do_command (thd=0x2033bf40) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 return_value = packet = 0x205dc380 "\003UPDATE `B` SET `col_varchar_1024_utf8` = CONVERT( 'she' , CHAR) WHERE `col_date_key` BETWEEN REPEAT( 0x354 , 255 ) AND REPEAT( 0xC502 , 51 )" packet_length = net = 0x2033c1a0 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = { func = 0xdf8c46 "?func", file = 0xdf8c4c "?file", level = 2147483649, prev = 0x0 } #16 0x0000000000746ecf in do_handle_one_connection (thd_arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 rc = create_user = true net = thd = 0x2033bf40 #17 0x0000000000746f90 in handle_one_connection (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 thd = 0x2033bf40 #18 0x00000000009e4ce9 in pfs_spawn_thread (arg=0x19562bc0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 typed_arg = 0x19562bc0 user_arg = 0x2033bf40 pfs = user_start_routine = 0x746f70 klass = #19 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #20 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 24 (LWP 1566): +bt full #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x00000000006dd5d0 in inline_mysql_cond_timedwait (that=0x203d4c08, mutex=0x203d4bd8, abstime=0x19972d50, src_file=, src_line=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 result = #2 0x00000000006dd715 in MDL_wait::timed_wait (this=0x203d4bd8, owner=0x203d4aa0, abs_timeout=0x19972d50, set_status_on_timeout=true, wait_state_name=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 old_stage = { m_key = 46, m_name = 0xc82ec9 "Opening tables", m_flags = 540888024 } result = wait_result = __FUNCTION__ = "timed_wait" #3 0x00000000006dee2f in MDL_context::acquire_lock (this=0x203d4bd8, mdl_request=0x204038f0, lock_wait_timeout=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 ticket = 0x197516d0 __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, ulong)" lock = 0x19466980 abs_timeout = { tv_sec = 1405500881, tv_nsec = 489776600 } wait_status = #4 0x0000000000721b09 in open_table_get_mdl_lock (thd=0x203d4aa0, ot_ctx=0x19973410, mdl_request=0x204038f0, flags=, mdl_ticket=0x19973290) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 mdl_deadlock_handler = { = { _vptr.Internal_error_handler = 0x1415a90 , m_prev_internal_handler = 0x0 }, members of MDL_deadlock_handler: m_ot_ctx = 0x19973410, m_is_active = false } result = mdl_request_shared = { type = 541083104, duration = MDL_STATEMENT, next_in_list = 0x22d2204045f0, prev_in_list = 0x19972e40, ticket = 0x65a146 , key = { m_length = 1, m_db_name_length = 0, m_ptr = "\000\000\000\000\060\037\264\b\000\000\000\000\200\060\227\031\000\000\000\000\210V\227\031\000\000\000\000 .\227\031\000\000\000\000j\220\304\000\000\000\000\000\260\060\227\031\000\000\000\000\060\037\264\b\000\000\000\000p0\227\031\000\000\000\000\236\241\304\000\000\000\000\000\200\060\227\031\000\000\000\000\060\037\264\b\214\000\000\000\220\060\227\031\000\000\000\000\060\037\264\b\000\000\000\000\060\037\264\b\000\000\000\000\060\037\264\b\000\000\000\000\060\037\264\b\000\000\000\000\060\037\264\b\000\000\000\000\060\037\264\b\000\000\000\000\210V\227\031\000\000\000\000\240.\227\031\000\000\000\000j\220\304\000\000\000\000\000\060\037\264\b\000\000\000\000\t\000\000\200\000\000\000\000\360.\227\031\000\000\000\000\202\235\304\000\000\000\000\000\000/\227\031\000\000\000\000\060\037\264\bx\b\000\000\060\037\264\b\000\000\000\000\030E\004 \000\000\000\000\000/\227\031\000\000\000\000\240J= \000\000\000\000\240J= \000\000\000\000\a\000\000\000\000\000\000\000@/\227\031\000\000\000\000\302\217\237\000\000\000\000\000?\245\313\000\000\000\000\000H\002\313\000\000\000\000\000\t\000\000\200\000\000\000\000`2\227\031\000\000\000\000\240J= \000\000\000\000\310_= \000\000\000\000\220/@ \000\000\000\000\060\037\264\b\000\000\000\000\060\037\264\b\000\000\000\000\210V\227\031\000\000\000\000p/\227\031\000\000\000\000j\220\304\000\000\000\000\000\200/\227\031\000\000", static m_namespace_to_wait_state_name = {[0] = { m_key = 102, m_name = 0xca684d "Waiting for global read lock", m_flags = 0 }, [1] = { m_key = 103, m_name = 0xca6df8 "Waiting for schema metadata lock", m_flags = 0 }, [2] = { m_key = 104, m_name = 0xca6e20 "Waiting for table metadata lock", m_flags = 0 }, [3] = { m_key = 105, m_name = 0xca6e40 "Waiting for stored function metadata lock", m_flags = 0 }, [4] = { m_key = 106, m_name = 0xca6e70 "Waiting for stored procedure metadata lock", m_flags = 0 }, [5] = { m_key = 107, m_name = 0xca6ea0 "Waiting for trigger metadata lock", m_flags = 0 }, [6] = { m_key = 108, m_name = 0xca6ec8 "Waiting for event metadata lock", m_flags = 0 }, [7] = { m_key = 109, m_name = 0xca686a "Waiting for commit lock", m_flags = 0 }} } } __PRETTY_FUNCTION__ = "bool open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, uint, MDL_ticket**)" #5 0x000000000072640a in open_table (thd=0x203d4aa0, table_list=0x20403550, ot_ctx=0x19973410) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 table = key = alias = 0x20403538 "alias2" flags = 0 _db_stack_frame_ = { func = 0xcb0116 "open_and_process_table", file = 0xcb0248 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", level = 2147483656, prev = 0x19973320 } __PRETTY_FUNCTION__ = "bool open_table(THD*, TABLE_LIST*, Open_table_context*)" mdl_ticket = key_length = 7 error = share = hash_value = #6 0x0000000000727bf1 in open_and_process_table (thd=0x203d4aa0, lex=0x203d6e68, tables=0x20403550, counter=0x203d6f20, flags=, prelocking_strategy=0x19973500, has_prelocking_list=false, ot_ctx=0x19973410) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 error = safe_to_ignore_table = false _db_stack_frame_ = { func = 0xcaff08 "open_tables", file = 0xcb0248 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", level = 2147483655, prev = 0x19973440 } __PRETTY_FUNCTION__ = "bool open_and_process_table(THD*, LEX*, TABLE_LIST*, uint*, uint, Prelocking_strategy*, bool, Open_table_context*)" #7 0x0000000000727f62 in open_tables (thd=0x203d4aa0, start=0x199734c8, counter=0x203d6f20, flags=0, prelocking_strategy=0x19973500) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 some_routine_modifies_data = false _db_stack_frame_ = { func = 0xcb1640 "open_normal_and_derived_tables", file = 0xcb0248 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", level = 2147483654, prev = 0x199734d0 } xa_state = __PRETTY_FUNCTION__ = "bool open_tables(THD*, TABLE_LIST**, uint*, uint, Prelocking_strategy*)" table_to_open = 0x20402f98 ot_ctx = { m_failed_table = 0x0, m_start_of_statement_svp = { m_stmt_ticket = 0x0, m_trans_ticket = 0x0 }, m_timeout = 31536000, m_flags = 0, m_action = Open_table_context::OT_NO_ACTION, m_has_locks = false, m_has_protection_against_grl = false } has_prelocking_list = false __FUNCTION__ = "open_tables" sroutine_to_open = 0x203d6f00 tables = error = false #8 0x00000000007285a6 in open_normal_and_derived_tables (thd=0x203d4aa0, tables=0x20402f90, flags=0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 prelocking_strategy = { = { _vptr.Prelocking_strategy = 0x1415a50 }, } mdl_savepoint = { m_stmt_ticket = 0x0, m_trans_ticket = 0x0 } _db_stack_frame_ = { func = 0xcc1ea1 "mysql_execute_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483653, prev = 0x19974230 } __PRETTY_FUNCTION__ = "bool open_normal_and_derived_tables(THD*, TABLE_LIST*, uint)" #9 0x000000000077439b in execute_sqlcom_select (thd=0x203d4aa0, all_tables=0x20402f90) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 lex = 0x203d6e68 result = 0x0 res = #10 0x0000000000777b6e in mysql_execute_command (thd=0x203d4b88) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 res = lex = 0x203d6e68 _db_stack_frame_ = { func = 0xcc2076 "mysql_parse", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483652, prev = 0x19974310 } __PRETTY_FUNCTION__ = "int mysql_execute_command(THD*)" trace_command = { = { started = false, requires_key = 74, has_disabled_I_S = 61, empty = 32, stmt = 0x993ec6 , saved_key = 0x199741f0 " B\227\031", previous_key = "\240J= ", '\000' , " " }, } trace_command_steps = { = { started = false, requires_key = 31, has_disabled_I_S = 180, empty = 8, stmt = 0x19975688, saved_key = 0x199741b0 "\232\v", previous_key = "j\220\304\000\000\000\000\000\000\224\066\032\000\000\000\000\002\000\000\000\000\000\000\000\232" }, } up_result = 0 ots = { ctx = 0x203d6e48, error = false } __FUNCTION__ = "mysql_execute_command" select_lex = 0x203d7578 first_table = 0x20402f90 all_tables = 0x20402f90 unit = 0x203d6f30 have_table_map_for_update = false #11 0x000000000077bc88 in mysql_parse (thd=0x203d4aa0, rawbuf=0x203d4aa8 "\340cA\001", length=, parser_state=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 lex = 0x203d6e68 err = found_semicolon = 0x0 qlen = 223 _db_stack_frame_ = { func = 0xcc208f "dispatch_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483651, prev = 0x19974c40 } start_usecs = 1373964881487632 end_usecs = 0 start_cpu_nsecs = 1291025923 end_cpu_nsecs = 0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint, Parser_state*)" end_time_error = 0 cputime_error = 0 __FUNCTION__ = "mysql_parse" error = start_time_error = 0 start_time = { tv_sec = 1373964881, tv_usec = 487632 } end_time = { tv_sec = 540887712, tv_usec = 429345504 } tp = { tv_sec = 1, tv_nsec = 291025923 } #12 0x000000000077c81f in dispatch_command (command=, thd=0x203d4aa0, packet=, packet_length=541076655) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 packet_end = 0x20402caf "" parser_state = { m_lip = { m_thd = 0x203d4aa0, yylineno = 1, yytoklen = 2, yylval = 0x19974150, lookahead_token = -1, lookahead_yylval = 0x0, m_ptr = 0x20402cb0 "\004", m_tok_start = 0x20402cb0 "\004", m_tok_end = 0x20402cb0 "\004", m_end_of_query = 0x20402caf "", m_tok_start_prev = 0x20402caf "", m_buf = 0x20402bd0 "SELECT alias1 . `pk` AS field1 FROM D AS alias1 RIGHT JOIN F AS alias2 ON alias1 . `col_varchar_10_utf8_key` = alias2 . `col_varchar_10_latin1` WHERE alias1 . `col_int_key` >= 2 AND alias1 . `col_int_key` < ( 2 + 10 )", m_buf_length = 223, m_echo = true, m_echo_saved = false, m_cpp_buf = 0x20402d18 "SELECT alias1 . `pk` AS field1 FROM D AS alias1 RIGHT JOIN F AS alias2 ON alias1 . `col_varchar_10_utf8_key` = alias2 . `col_varchar_10_latin1` WHERE alias1 . `col_int_key` >= 2 AND alias1 . `col_int_key` < ( 2 + 10 )", m_cpp_ptr = 0x20402df7 "", m_cpp_tok_start = 0x20402df7 "", m_cpp_tok_start_prev = 0x20402df7 "", m_cpp_tok_end = 0x20402df7 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x20429090 "\003 SELECT alias1 . `pk` AS field1 FROM D AS alias1 RIGHT JOIN F AS alias2 ON alias1 . `col_varchar_10_utf8_key` = alias2 . `col_varchar_10_latin1` WHERE alias1 . `col_int_key` >= 2 AND alias1 . `col_int_key` < ( 2 + 10 ) ", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 64 '@', ignore_space = false, stmt_prepare_mode = false, multi_statements = true, in_comment = NO_COMMENT, in_comment_saved = (DISCARD_COMMENT | unknown: 10043076), m_cpp_text_start = 0x20402df3 "10 )", m_cpp_text_end = 0x20402df5 " )", m_underscore_cs = 0x0, m_digest_psi = 0x0 }, m_yacc = { yacc_yyss = 0x0, yacc_yyvs = 0x0, m_set_signal_info = { m_item = {[0] = 0x0 } }, m_lock_type = TL_READ_DEFAULT, m_mdl_type = MDL_SHARED_READ, m_ha_rkey_mode = HA_READ_KEY_EXACT } } net = 0x203d4d00 __FUNCTION__ = "dispatch_command" __PRETTY_FUNCTION__ = "bool dispatch_command(enum_server_command, THD*, char*, uint)" error = false _db_stack_frame_ = { func = 0xcc2124 "do_command", file = 0xcc2300 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc", level = 2147483650, prev = 0x19974cf0 } #13 0x000000000077d4f5 in do_command (thd=0x203d4aa0) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 return_value = packet = 0x20429090 "\003 SELECT alias1 . `pk` AS field1 FROM D AS alias1 RIGHT JOIN F AS alias2 ON alias1 . `col_varchar_10_utf8_key` = alias2 . `col_varchar_10_latin1` WHERE alias1 . `col_int_key` >= 2 AND alias1 . `col_int_key` < ( 2 + 10 ) " packet_length = net = 0x203d4d00 command = COM_QUERY __PRETTY_FUNCTION__ = "bool do_command(THD*)" _db_stack_frame_ = { func = 0xdf8c46 "?func", file = 0xdf8c4c "?file", level = 2147483649, prev = 0x0 } #14 0x0000000000746ecf in do_handle_one_connection (thd_arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 rc = create_user = true net = thd = 0x203d4aa0 #15 0x0000000000746f90 in handle_one_connection (arg=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 thd = 0x203d4aa0 #16 0x00000000009e4ce9 in pfs_spawn_thread (arg=0x19726c80) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 typed_arg = 0x19726c80 user_arg = 0x203d4aa0 pfs = user_start_routine = 0x746f70 klass = #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 No symbol table info available. Thread 23 (LWP 1568): +bt full #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 No symbol table info available. #1 0x00000000006dd5d0 in inline_mysql_cond_timedwait (that=0x2045ba98, mutex=0x2045ba68, abstime=0x199b3650, src_file=, src_line=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 result = #2 0x00000000006dd715 in MDL_wait::timed_wait (this=0x2045ba68, owner=0x2045b930, abs_timeout=0x199b3650, set_status_on_timeout=true, wait_state_name=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 old_stage = { m_key = 46, m_name = 0xc82ec9 "Opening tables", m_flags = 541440616 } result = wait_result = __FUNCTION__ = "timed_wait" #3 0x00000000006dee2f in MDL_context::acquire_lock (this=0x2045ba68, mdl_request=0x204751b8, lock_wait_timeout=) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 ticket = 0x196f4320 __PRETTY_FUNCTION__ = "bool MDL_context::acquire_lock(MDL_request*, ulong)" lock = 0x19466980 abs_timeout = { tv_sec = 1405500879, tv_nsec = 910123300 } wait_status = #4 0x0000000000721b09 in open_table_get_mdl_lock (thd=0x2045b930, ot_ctx=0x199b3d10, mdl_request=0x204751b8, flags=, mdl_ticket=0x199b3b90) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 mdl_deadlock_handler = { = { _vptr.Internal_error_handler = 0x1415a90 , m_prev_internal_handler = 0x0 }, members of MDL_deadlock_handler: m_ot_ctx = 0x199b3d10, m_is_active = false } result = mdl_request_shared = { type = 429603088, duration = MDL_STATEMENT, next_in_list = 0xc4a19e <_db_return_+222>, prev_in_list = 0x199b3920, ticket = 0x1f8219540590, key = { m_length = 14704, m_db_name_length = 6555, m_ptr = "\000\000\000\000\220\005T\031\000\000\000\000\200\071\233\031\000\000\000\000\210f\233\031\000\000\000\000 7\233\031\000\000\000\000j\220\304\000\000\000\000\000\060\067\233\031\000\000\000\000\220\005T\031\000\000\000\000p9\233\031\000\000\000\000_\224\231\000\000\000\000\000\360\241\262\b\000\000\000\000`\223T\001\000\000\000\000\260\067\233\031\000\000\000\000\235\320m\000\000\000\000\000\002\021\000\000\000\000\000\000\360?\000\070\000\000\000\000@", '\000' , "\240\067\233\031\000\000\000\000\031\371m\000\000\000\000\000\260\067\233\031\000\000\000\000\243\000n", '\000' , "`\242\262\b\000\000\000\000\000\220m\031\000\000\000\000\210\070\233\031\000\000\000\000\340\067\233\031\000\000\000\000\017\002n\000\000\000\000\000h\272E \000\000\000\000\060\071\233\031\000\000\000\000h\272E \000\000\000\000\210\070\233\031\000\000\000\000\060\070\233\031\000\000\000\000.\354m\000\000\000\000\000\220\070\233\031\000\000\000\000\300\000\240\000\000\000\000\000h\272E \000\000\000\000h\272E \000\000\000\000\060\071\233\031", '\000' , "\200\063\341\001\000\000\000\000\260\335E \000\000\000\000\300\070\233\031\000\000\000\000F\355m\000\000\000\000\000\220\005T\031\000\000\000\000\210f\233\031\000\000\000\000p8\233\031\000\000\000\000j\220\304\000\000\000\000\000\220\070\233\031\000\000", static m_namespace_to_wait_state_name = {[0] = { m_key = 102, m_name = 0xca684d "Waiting for global read lock", m_flags = 0 }, [1] = { m_key = 103, m_name = 0xca6df8 "Waiting for schema metadata lock", m_flags = 0 }, [2] = { m_key = 104, m_name = 0xca6e20 "Waiting for table metadata lock", m_flags = 0 }, [3] = { m_key = 105, m_name = 0xca6e40 "Waiting for stored function metadata lock", m_flags = 0 }, [4] = { m_key = 106, m_name = 0xca6e70 "Waiting for stored procedure metadata lock", m_flags = 0 }, [5] = { m_key = 107, m_name = 0xca6ea0 "Waiting for trigger metadata lock", m_flags = 0 }, [6] = { m_key = 108, m_name = 0xca6ec8 "Waiting for event metadata lock", m_flags = 0 }, [7] = { m_key = 109, m_name = 0xca686a "Waiting for commit lock", m_flags = 0 }} } } __PRETTY_FUNCTION__ = "bool open_table_get_mdl_lock(THD*, Open_table_context*, MDL_request*, uint, MDL_ticket**)" #5 0x000000000072640a in open_table (thd=0x2045b930, table_list=0x20474e18, ot_ctx=0x199b3d10) at /bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 table = key = alias = 0x20474e10 "F" flags = 0 _db_stack_frame_ = { func = 0xcb0116 "open_and_process_table", file = 0xcb0248 "/bzr/5.6_val/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", level = 2147483657, prev = 0x199b3c20 } __PRETTY_FUNCTION__ = "bool open_table(THD*, TABLE_LIST*, Open_table_context*)" mdl_ticket =