Thread 56 (Thread 0x7fc1847b8950 (LWP 23167)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b66f0, mp=0x33b6640, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b6640, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=0, message1=0x7fc1847b80b8, message2=0x7fc1847b80b0, type=0x7fc1847b80a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c6c0) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 55 (Thread 0x7fc182ee6950 (LWP 23168)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b6810, mp=0x33b6760, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b6760, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=1, message1=0x7fc182ee60b8, message2=0x7fc182ee60b0, type=0x7fc182ee60a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c6c8) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 54 (Thread 0x7fc1824e5950 (LWP 23169)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b6930, mp=0x33b6880, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b6880, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=2, message1=0x7fc1824e50b8, message2=0x7fc1824e50b0, type=0x7fc1824e50a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c6d0) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 53 (Thread 0x7fc181ae4950 (LWP 23170)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b6a50, mp=0x33b69a0, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b69a0, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=3, message1=0x7fc181ae40b8, message2=0x7fc181ae40b0, type=0x7fc181ae40a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c6d8) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 52 (Thread 0x7fc1810e3950 (LWP 23171)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b6b70, mp=0x33b6ac0, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b6ac0, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=4, message1=0x7fc1810e30b8, message2=0x7fc1810e30b0, type=0x7fc1810e30a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=4) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c6e0) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 51 (Thread 0x7fc1806e2950 (LWP 23172)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b6c90, mp=0x33b6be0, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b6be0, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=5, message1=0x7fc1806e20b8, message2=0x7fc1806e20b0, type=0x7fc1806e20a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=5) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c6e8) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 50 (Thread 0x7fc17fce1950 (LWP 23173)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b6db0, mp=0x33b6d00, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b6d00, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=6, message1=0x7fc17fce10b8, message2=0x7fc17fce10b0, type=0x7fc17fce10a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=6) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c6f0) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 49 (Thread 0x7fc17f2e0950 (LWP 23174)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b6ed0, mp=0x33b6e20, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b6e20, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=7, message1=0x7fc17f2e00b8, message2=0x7fc17f2e00b0, type=0x7fc17f2e00a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=7) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c6f8) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 48 (Thread 0x7fc17e8df950 (LWP 23175)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b6ff0, mp=0x33b6f40, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b6f40, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=8, message1=0x7fc17e8df0b8, message2=0x7fc17e8df0b0, type=0x7fc17e8df0a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=8) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c700) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 47 (Thread 0x7fc17dede950 (LWP 23176)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b7110, mp=0x33b7060, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b7060, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=9, message1=0x7fc17dede0b8, message2=0x7fc17dede0b0, type=0x7fc17dede0a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=9) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c708) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 46 (Thread 0x7fc17d4dd950 (LWP 23177)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b7230, mp=0x33b7180, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b7180, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=10, message1=0x7fc17d4dd0b8, message2=0x7fc17d4dd0b0, type=0x7fc17d4dd0a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=10) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c710) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 45 (Thread 0x7fc17cadc950 (LWP 23178)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b7350, mp=0x33b72a0, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b72a0, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=11, message1=0x7fc17cadc0b8, message2=0x7fc17cadc0b0, type=0x7fc17cadc0a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=11) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c718) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 44 (Thread 0x7fc17c0db950 (LWP 23179)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b7470, mp=0x33b73c0, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b73c0, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=12, message1=0x7fc17c0db0b8, message2=0x7fc17c0db0b0, type=0x7fc17c0db0a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=12) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c720) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 43 (Thread 0x7fc17b6da950 (LWP 23180)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b7590, mp=0x33b74e0, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b74e0, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=13, message1=0x7fc17b6da0b8, message2=0x7fc17b6da0b0, type=0x7fc17b6da0a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=13) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c728) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 42 (Thread 0x7fc17acd9950 (LWP 23181)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b76b0, mp=0x33b7600, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b7600, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=14, message1=0x7fc17acd90b8, message2=0x7fc17acd90b0, type=0x7fc17acd90a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=14) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c730) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 41 (Thread 0x7fc17a2d8950 (LWP 23182)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b77d0, mp=0x33b7720, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b7720, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=15, message1=0x7fc17a2d80b8, message2=0x7fc17a2d80b0, type=0x7fc17a2d80a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=15) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c738) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 40 (Thread 0x7fc1798d7950 (LWP 23183)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b78f0, mp=0x33b7840, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b7840, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=16, message1=0x7fc1798d70b8, message2=0x7fc1798d70b0, type=0x7fc1798d70a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=16) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c740) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 39 (Thread 0x7fc178ed6950 (LWP 23184)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x33b7a10, mp=0x33b7960, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x33b7960, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009cc3a2 in os_aio_simulated_handle (global_segment=17, message1=0x7fc178ed60b8, message2=0x7fc178ed60b0, type=0x7fc178ed60a8) at os/os0file.c:4252 #4 0x00000000009a8168 in fil_aio_wait (segment=17) at fil/fil0fil.c:4246 #5 0x00000000009f564e in io_handler_thread (arg=0x125c748) at srv/srv0start.c:435 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 38 (Thread 0x7fc1784d4950 (LWP 23185)): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x00000000009cde40 in os_thread_sleep (tm=1000000) at os/os0thread.c:268 #2 0x00000000009f37ec in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:2104 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 37 (Thread 0x7fc177ad3950 (LWP 23186)): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x00000000009cde40 in os_thread_sleep (tm=1000000) at os/os0thread.c:268 #2 0x00000000009f3c7a in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2307 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 36 (Thread 0x7fc176ecd950 (LWP 23187)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x2b42ee0, mp=0x2b42e30, file=0xd8ded2 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x00000000009cd732 in os_event_wait_low (event=0x2b42e30, reset_sig_count=0) at os/os0sync.c:422 #3 0x00000000009f4fbd in srv_master_thread (arg=0x0) at srv/srv0srv.c:2839 #4 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #5 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 35 (Thread 0x7fc1764cc950 (LWP 23188)): #0 0x000000315b00ee7b in sigwait () from /lib64/libpthread.so.0 #1 0x00000000006c8cc1 in signal_hand (arg=0x0) at mysqld.cc:2967 #2 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #3 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 34 (Thread 0x7fc17648b950 (LWP 23189)): #0 0x000000315b00df5b in read () from /lib64/libpthread.so.0 #1 0x0000000000bcee71 in vio_read (vio=0x3815cc8, buf=0x383e708 "\a", size=4) at viosocket.c:44 #2 0x00000000006b83a0 in my_real_read (net=0x38034f0, complen=0x7fc17648afe8) at net_serv.cc:833 #3 0x00000000006b8b8c in my_net_read (net=0x38034f0) at net_serv.cc:1023 #4 0x00000000006e6b84 in do_command (thd=0x38033d8) at sql_parse.cc:704 #5 0x00000000006d3a88 in handle_one_connection (arg=0x38033d8) at sql_connect.cc:1164 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 33 (Thread 0x7fc17644a950 (LWP 23204)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x3b85f28, mp=0x3b85e58, file=0xd28c18 "sql_insert.cc", line=2006) at thr_mutex.c:423 #2 0x000000000078af7e in delayed_get_table (thd=0x384a4c8, table_list=0x38702c0) at sql_insert.cc:2006 #3 0x000000000078e44f in open_and_lock_for_insert_delayed (thd=0x384a4c8, table_list=0x38702c0) at sql_insert.cc:523 #4 0x000000000079002a in mysql_insert (thd=0x384a4c8, table_list=0x38702c0, fields=@0x384c9c8, values_list=@0x384ca10, update_fields=@0x384c9f8, update_values=@0x384c9e0, duplic=DUP_REPLACE, ignore=false) at sql_insert.cc:630 #5 0x00000000006df195 in mysql_execute_command (thd=0x384a4c8) at sql_parse.cc:3267 #6 0x00000000006e4b41 in mysql_parse (thd=0x384a4c8, inBuf=0x3870170 "REPLACE DELAYED testdb_S . t1_all_1_S ( `int_key` ) VALUES ( 8 )", length=66, found_semicolon=0x7fc176449f00) at sql_parse.cc:5979 #7 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x384a4c8, packet=0x386c119 "REPLACE DELAYED testdb_S . t1_all_1_S ( `int_key` ) VALUES ( 8 )", packet_length=66) at sql_parse.cc:1076 #8 0x00000000006e6d1c in do_command (thd=0x384a4c8) at sql_parse.cc:758 #9 0x00000000006d3a88 in handle_one_connection (arg=0x384a4c8) at sql_connect.cc:1164 #10 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #11 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 32 (Thread 0x7fc176305950 (LWP 23210)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x12586c0, mp=0x1258600, file=0xd6b0bf "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x000000000090d25c in MDL_context::wait_for_locks (this=0x3900da0, mdl_requests=0x7fc176303200) at mdl.cc:1261 #3 0x0000000000737941 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7fc176303200, thd=0x3900cc8, table=0x399ea60) at sql_base.cc:3700 #4 0x0000000000739ecf in open_tables (thd=0x3900cc8, start=0x7fc176303290, counter=0x7fc1763032d0, flags=32, prelocking_strategy=0x7fc176304260) at sql_base.cc:4206 #5 0x000000000073a378 in open_and_lock_tables_derived (thd=0x3900cc8, tables=0x399ea60, derived=false, flags=32, prelocking_strategy=0x7fc176304260) at sql_base.cc:4763 #6 0x00000000006e03ff in mysql_execute_command (thd=0x3900cc8) at sql_parse.cc:3658 #7 0x00000000006e4b41 in mysql_parse (thd=0x3900cc8, inBuf=0x399e8d0 "LOCK TABLES testdb_S . t1_all_2_S AS e IN EXCLUSIVE MODE , testdb_N . t1_all_1_N AS r READ", length=93, found_semicolon=0x7fc176304f00) at sql_parse.cc:5979 #8 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3900cc8, packet=0x39a4179 "LOCK TABLES testdb_S . t1_all_2_S AS e IN EXCLUSIVE MODE , testdb_N . t1_all_1_N AS r READ ", packet_length=94) at sql_parse.cc:1076 #9 0x00000000006e6d1c in do_command (thd=0x3900cc8) at sql_parse.cc:758 #10 0x00000000006d3a88 in handle_one_connection (arg=0x3900cc8) at sql_connect.cc:1164 #11 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #12 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 31 (Thread 0x7fc1763c8950 (LWP 23213)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x12586c0, mp=0x1258600, file=0xd6b0bf "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x000000000090d25c in MDL_context::wait_for_locks (this=0x38e3490, mdl_requests=0x7fc1763c5130) at mdl.cc:1261 #3 0x0000000000737941 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7fc1763c5130, thd=0x38e33b8, table=0x3998480) at sql_base.cc:3700 #4 0x0000000000739ecf in open_tables (thd=0x38e33b8, start=0x7fc1763c51c0, counter=0x7fc1763c5200, flags=32, prelocking_strategy=0x7fc1763c61e0) at sql_base.cc:4206 #5 0x000000000073a378 in open_and_lock_tables_derived (thd=0x38e33b8, tables=0x3998480, derived=false, flags=32, prelocking_strategy=0x7fc1763c61e0) at sql_base.cc:4763 #6 0x000000000085978d in mysql_alter_table (thd=0x38e33b8, new_db=0x3998428 "testdb_S", new_name=0x0, create_info=0x7fc1763c6600, table_list=0x3998480, alter_info=0x7fc1763c7180, order_num=0, order=0x0, ignore=false) at sql_table.cc:6934 #7 0x00000000006de196 in mysql_execute_command (thd=0x38e33b8) at sql_parse.cc:2914 #8 0x00000000006e4b41 in mysql_parse (thd=0x38e33b8, inBuf=0x3998330 "ALTER TABLE testdb_S . t1_all_2_S CHANGE COLUMN my_column `pk` INT", length=67, found_semicolon=0x7fc1763c7f00) at sql_parse.cc:5979 #9 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x38e33b8, packet=0x39d36e9 "ALTER TABLE testdb_S . t1_all_2_S CHANGE COLUMN my_column `pk` INT", packet_length=67) at sql_parse.cc:1076 #10 0x00000000006e6d1c in do_command (thd=0x38e33b8) at sql_parse.cc:758 #11 0x00000000006d3a88 in handle_one_connection (arg=0x38e33b8) at sql_connect.cc:1164 #12 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #13 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 30 (Thread 0x7fc1762c4950 (LWP 23215)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x399a788, mp=0x3ca4098, file=0xdbf7ef "thr_lock.c", line=470) at thr_mutex.c:423 #2 0x0000000000b31a4b in wait_for_lock (wait=0x3ca4138, data=0x3f85be8, in_wait_list=0 '\0') at thr_lock.c:470 #3 0x0000000000b32677 in thr_lock (data=0x3f85be8, owner=0x38f3cd0, lock_type=TL_READ_NO_INSERT) at thr_lock.c:801 #4 0x0000000000b33162 in thr_multi_lock (data=0x39bfc88, count=1, owner=0x38f3cd0) at thr_lock.c:1059 #5 0x00000000006bffb1 in mysql_lock_tables (thd=0x38f2f58, tables=0x3a21fc8, count=1, flags=32, need_reopen=0x7fc1762c22cf) at lock.cc:321 #6 0x0000000000732bc8 in lock_tables (thd=0x38f2f58, tables=0x3a21a30, count=1, flags=32, need_reopen=0x7fc1762c22cf) at sql_base.cc:5082 #7 0x000000000073a40a in open_and_lock_tables_derived (thd=0x38f2f58, tables=0x3a21a30, derived=false, flags=32, prelocking_strategy=0x7fc1762c3260) at sql_base.cc:4771 #8 0x00000000006e03ff in mysql_execute_command (thd=0x38f2f58) at sql_parse.cc:3658 #9 0x00000000006e4b41 in mysql_parse (thd=0x38f2f58, inBuf=0x3a21900 "LOCK TABLES testdb_S . t1_all_1_S AS g READ", length=44, found_semicolon=0x7fc1762c3f00) at sql_parse.cc:5979 #10 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x38f2f58, packet=0x39f90b9 "LOCK TABLES testdb_S . t1_all_1_S AS g READ ", packet_length=45) at sql_parse.cc:1076 #11 0x00000000006e6d1c in do_command (thd=0x38f2f58) at sql_parse.cc:758 #12 0x00000000006d3a88 in handle_one_connection (arg=0x38f2f58) at sql_connect.cc:1164 #13 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #14 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 29 (Thread 0x7fc176283950 (LWP 23216)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=8212) at thr_mutex.c:225 #4 0x000000000072bf84 in mysql_notify_thread_having_shared_lock (thd=0x3aa8928, in_use=0x384a4c8) at sql_base.cc:8212 #5 0x000000000090da5a in notify_shared_lock (thd=0x3aa8928, conflicting_ticket=0x3d0c510) at mdl.cc:807 #6 0x000000000090e26e in MDL_context::acquire_exclusive_locks (this=0x3aa8a00, mdl_requests=0x7fc176280900) at mdl.cc:919 #7 0x000000000090e6f1 in MDL_context::acquire_exclusive_lock (this=0x3aa8a00, mdl_request=0x38c5e60) at mdl.cc:822 #8 0x0000000000733bd8 in open_table_get_mdl_lock (thd=0x3aa8928, table_list=0x38c5b08, mdl_request=0x38c5e60, ot_ctx=0x7fc176281030, flags=0) at sql_base.cc:2343 #9 0x0000000000738478 in open_table (thd=0x3aa8928, table_list=0x38c5b08, mem_root=0x7fc176280fc0, ot_ctx=0x7fc176281030, flags=0) at sql_base.cc:2618 #10 0x0000000000739796 in open_and_process_table (thd=0x3aa8928, lex=0x3aaa1f8, tables=0x38c5b08, counter=0x7fc176281100, flags=0, prelocking_strategy=0x7fc176281140, has_prelocking_list=false, ot_ctx=0x7fc176281030, new_frm_mem=0x7fc176280fc0) at sql_base.cc:3940 #11 0x0000000000739e83 in open_tables (thd=0x3aa8928, start=0x7fc1762810c0, counter=0x7fc176281100, flags=0, prelocking_strategy=0x7fc176281140) at sql_base.cc:4178 #12 0x000000000073a378 in open_and_lock_tables_derived (thd=0x3aa8928, tables=0x38c5b08, derived=true, flags=0, prelocking_strategy=0x7fc176281140) at sql_base.cc:4763 #13 0x00000000006e7cc8 in open_and_lock_tables_derived (thd=0x3aa8928, tables=0x38c5b08, derived=true, flags=0) at ../mysql_priv.h:1518 #14 0x00000000006e7d03 in open_and_lock_tables (thd=0x3aa8928, tables=0x38c5b08) at ../../sql/mysql_priv.h:1528 #15 0x00000000008bbbf4 in mysql_create_view (thd=0x3aa8928, views=0x38c5b08, mode=VIEW_CREATE_NEW) at sql_view.cc:402 #16 0x00000000006e3e02 in mysql_execute_command (thd=0x3aa8928) at sql_parse.cc:4692 #17 0x00000000006e4b41 in mysql_parse (thd=0x3aa8928, inBuf=0x38c57f0 "/* Sequence start */ CREATE ALGORITHM = MERGE VIEW testdb_S . t1_all_2_S AS SELECT HIGH_PRIORITY * FROM testdb_S . t1_all_1_S A NATURAL JOIN testdb_S . t1_all_1_N B WHERE `pk` BETWEEN 3 AND 3 + 1"..., length=295, found_semicolon=0x7fc176282f00) at sql_parse.cc:5979 #18 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3aa8928, packet=0x3ab3499 "/* Sequence start */ CREATE ALGORITHM = MERGE VIEW testdb_S . t1_all_2_S AS SELECT HIGH_PRIORITY * FROM testdb_S . t1_all_1_S A NATURAL JOIN testdb_S . t1_all_1_N B WHERE `pk` BETWEEN 3 AND 3 + 1"..., packet_length=295) at sql_parse.cc:1076 #19 0x00000000006e6d1c in do_command (thd=0x3aa8928) at sql_parse.cc:758 #20 0x00000000006d3a88 in handle_one_connection (arg=0x3aa8928) at sql_connect.cc:1164 #21 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #22 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 28 (Thread 0x7fc1761c0950 (LWP 23225)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=1255) at thr_mutex.c:225 #4 0x0000000000736210 in close_open_tables (thd=0x3a14fe8) at sql_base.cc:1255 #5 0x0000000000736659 in close_thread_tables (thd=0x3a14fe8) at sql_base.cc:1503 #6 0x00000000007368ac in Locked_tables_list::unlock_locked_tables (this=0x3a16820, thd=0x3a14fe8) at sql_base.cc:3131 #7 0x00000000006e014c in mysql_execute_command (thd=0x3a14fe8) at sql_parse.cc:3581 #8 0x00000000006e4b41 in mysql_parse (thd=0x3a14fe8, inBuf=0x3a1efe0 "UNLOCK TABLES", length=13, found_semicolon=0x7fc1761bff00) at sql_parse.cc:5979 #9 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3a14fe8, packet=0x398c3b9 "UNLOCK TABLES", packet_length=13) at sql_parse.cc:1076 #10 0x00000000006e6d1c in do_command (thd=0x3a14fe8) at sql_parse.cc:758 #11 0x00000000006d3a88 in handle_one_connection (arg=0x3a14fe8) at sql_connect.cc:1164 #12 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #13 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 27 (Thread 0x7fc17613e950 (LWP 23229)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b0091b0 in _L_lock_102 () from /lib64/libpthread.so.0 #2 0x000000315b008a9e in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1258600, my_flags=0, file=0xd6b0bf "mdl.cc", line=739) at thr_mutex.c:225 #4 0x000000000090d814 in MDL_context::try_acquire_shared_lock (this=0x3acb0f0, mdl_request=0x7fc1700129d0) at mdl.cc:739 #5 0x0000000000733c69 in open_table_get_mdl_lock (thd=0x3acb018, table_list=0x7fc170012678, mdl_request=0x7fc1700129d0, ot_ctx=0x7fc17613bda0, flags=0) at sql_base.cc:2361 #6 0x0000000000738478 in open_table (thd=0x3acb018, table_list=0x7fc170012678, mem_root=0x7fc17613bd30, ot_ctx=0x7fc17613bda0, flags=0) at sql_base.cc:2618 #7 0x0000000000739796 in open_and_process_table (thd=0x3acb018, lex=0x7fc170011188, tables=0x7fc170012678, counter=0x7fc17613beac, flags=0, prelocking_strategy=0x7fc17613be30, has_prelocking_list=false, ot_ctx=0x7fc17613bda0, new_frm_mem=0x7fc17613bd30) at sql_base.cc:3940 #8 0x0000000000739e83 in open_tables (thd=0x3acb018, start=0x7fc17613be70, counter=0x7fc17613beac, flags=0, prelocking_strategy=0x7fc17613be30) at sql_base.cc:4178 #9 0x00000000005d92d2 in open_tables (thd=0x3acb018, tables=0x7fc17613be70, counter=0x7fc17613beac, flags=0) at mysql_priv.h:1506 #10 0x000000000073a27a in open_normal_and_derived_tables (thd=0x3acb018, tables=0x7fc170012678, flags=0) at sql_base.cc:4817 #11 0x0000000000799731 in select_like_stmt_test_with_open (stmt=0x7fc170002778, tables=0x7fc170012678, specific_prepare=0x799234 , setup_tables_done_option=1073741824) at sql_prepare.cc:1637 #12 0x000000000079982f in mysql_test_insert_select (stmt=0x7fc170002778, tables=0x7fc170012678) at sql_prepare.cc:1873 #13 0x000000000079bf65 in check_prepared_statement (stmt=0x7fc170002778) at sql_prepare.cc:1994 #14 0x000000000079c476 in Prepared_statement::prepare (this=0x7fc170002778, packet=0x396b130 " REPLACE DELAYED testdb_S . t1_all_1_S ( `pk`,`int_key`,`int` ) SELECT HIGH_PRIORITY `pk`,`int_key`,`int` FROM ( SELECT `pk`,`int_key`,`int` FROM testdb_S . t1_all_1_S ) AS A WHERE A.`pk` IN ( SEL"..., packet_len=269) at sql_prepare.cc:3204 #15 0x000000000079d177 in mysql_sql_stmt_prepare (thd=0x3acb018) at sql_prepare.cc:2324 #16 0x00000000006dc61b in mysql_execute_command (thd=0x3acb018) at sql_parse.cc:2161 #17 0x00000000006e4b41 in mysql_parse (thd=0x3acb018, inBuf=0x396ad60 "PREPARE st1 FROM \" REPLACE DELAYED testdb_S . t1_all_1_S ( `pk`,`int_key`,`int` ) SELECT HIGH_PRIORITY `pk`,`int_key`,`int` FROM ( SELECT `pk`,`int_key`,`int` FROM testdb_S . t1_all_1_S ) AS A WHE"..., length=288, found_semicolon=0x7fc17613df00) at sql_parse.cc:5979 #18 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3acb018, packet=0x3a7fd19 "PREPARE st1 FROM \" REPLACE DELAYED testdb_S . t1_all_1_S ( `pk`,`int_key`,`int` ) SELECT HIGH_PRIORITY `pk`,`int_key`,`int` FROM ( SELECT `pk`,`int_key`,`int` FROM testdb_S . t1_all_1_S ) AS A WHE"..., packet_length=289) at sql_parse.cc:1076 #19 0x00000000006e6d1c in do_command (thd=0x3acb018) at sql_parse.cc:758 #20 0x00000000006d3a88 in handle_one_connection (arg=0x3acb018) at sql_connect.cc:1164 #21 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #22 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 26 (Thread 0x7fc17607b950 (LWP 23234)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x1248740, mp=0x1247a60, file=0xd2040c "sql_base.cc", line=1062) at thr_mutex.c:423 #2 0x000000000073ae4a in close_cached_tables (thd=0x3a726f8, tables=0x3b5cef0, have_lock=false, wait_for_refresh=true) at sql_base.cc:1062 #3 0x00000000006d6805 in reload_acl_and_cache (thd=0x3a726f8, options=4, tables=0x3b5cef0, write_to_binlog=0x7fc17607a25f) at sql_parse.cc:6966 #4 0x00000000006e1e67 in mysql_execute_command (thd=0x3a726f8) at sql_parse.cc:4084 #5 0x00000000006e4b41 in mysql_parse (thd=0x3a726f8, inBuf=0x3b5cde0 "FLUSH TABLE testdb_S . t1_all_2_S", length=33, found_semicolon=0x7fc17607af00) at sql_parse.cc:5979 #6 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3a726f8, packet=0x390fc79 "FLUSH TABLE testdb_S . t1_all_2_S ", packet_length=34) at sql_parse.cc:1076 #7 0x00000000006e6d1c in do_command (thd=0x3a726f8) at sql_parse.cc:758 #8 0x00000000006d3a88 in handle_one_connection (arg=0x3a726f8) at sql_connect.cc:1164 #9 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #10 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7fc176409950 (LWP 23236)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=940) at thr_mutex.c:225 #4 0x000000000073aa63 in close_cached_tables (thd=0x3864188, tables=0x3bc7e40, have_lock=false, wait_for_refresh=true) at sql_base.cc:940 #5 0x00000000006d6805 in reload_acl_and_cache (thd=0x3864188, options=4, tables=0x3bc7e40, write_to_binlog=0x7fc17640825f) at sql_parse.cc:6966 #6 0x00000000006e1e67 in mysql_execute_command (thd=0x3864188) at sql_parse.cc:4084 #7 0x00000000006e4b41 in mysql_parse (thd=0x3864188, inBuf=0x3bc7d30 "FLUSH TABLE testdb_S . t1_all_2_S", length=33, found_semicolon=0x7fc176408f00) at sql_parse.cc:5979 #8 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3864188, packet=0x3908a49 "FLUSH TABLE testdb_S . t1_all_2_S ", packet_length=34) at sql_parse.cc:1076 #9 0x00000000006e6d1c in do_command (thd=0x3864188) at sql_parse.cc:758 #10 0x00000000006d3a88 in handle_one_connection (arg=0x3864188) at sql_connect.cc:1164 #11 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #12 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7fc17603a950 (LWP 23238)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b0091b0 in _L_lock_102 () from /lib64/libpthread.so.0 #2 0x000000315b008a9e in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1258600, my_flags=0, file=0xd2040c "sql_base.cc", line=902) at thr_mutex.c:225 #4 0x000000000072be19 in kill_delayed_threads_for_table (share=0x38f9f30) at sql_base.cc:902 #5 0x000000000073ab2e in close_cached_tables (thd=0x3a7bd68, tables=0x7fc1700637a0, have_lock=false, wait_for_refresh=true) at sql_base.cc:966 #6 0x00000000006d6805 in reload_acl_and_cache (thd=0x3a7bd68, options=4, tables=0x7fc1700637a0, write_to_binlog=0x7fc17603925f) at sql_parse.cc:6966 #7 0x00000000006e1e67 in mysql_execute_command (thd=0x3a7bd68) at sql_parse.cc:4084 #8 0x00000000006e4b41 in mysql_parse (thd=0x3a7bd68, inBuf=0x7fc170063690 "FLUSH TABLE testdb_S . t1_all_1_S", length=33, found_semicolon=0x7fc176039f00) at sql_parse.cc:5979 #9 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3a7bd68, packet=0x3baf869 "FLUSH TABLE testdb_S . t1_all_1_S ", packet_length=34) at sql_parse.cc:1076 #10 0x00000000006e6d1c in do_command (thd=0x3a7bd68) at sql_parse.cc:758 #11 0x00000000006d3a88 in handle_one_connection (arg=0x3a7bd68) at sql_connect.cc:1164 #12 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #13 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7fc175fb8950 (LWP 23242)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=1255) at thr_mutex.c:225 #4 0x0000000000736210 in close_open_tables (thd=0x3bc3f38) at sql_base.cc:1255 #5 0x0000000000736659 in close_thread_tables (thd=0x3bc3f38) at sql_base.cc:1503 #6 0x00000000007367d7 in close_tables_for_reopen (thd=0x3bc3f38, tables=0x7fc175fb6290) at sql_base.cc:5225 #7 0x0000000000739ebb in open_tables (thd=0x3bc3f38, start=0x7fc175fb6290, counter=0x7fc175fb62d0, flags=32, prelocking_strategy=0x7fc175fb7260) at sql_base.cc:4200 #8 0x000000000073a378 in open_and_lock_tables_derived (thd=0x3bc3f38, tables=0x3b0a278, derived=false, flags=32, prelocking_strategy=0x7fc175fb7260) at sql_base.cc:4763 #9 0x00000000006e03ff in mysql_execute_command (thd=0x3bc3f38) at sql_parse.cc:3658 #10 0x00000000006e4b41 in mysql_parse (thd=0x3bc3f38, inBuf=0x3b0a0e0 "LOCK TABLES testdb_S . t1_all_1_S AS p IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_all_2_S AS x READ", length=99, found_semicolon=0x7fc175fb7f00) at sql_parse.cc:5979 #11 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3bc3f38, packet=0x3bd59a9 "LOCK TABLES testdb_S . t1_all_1_S AS p IN EXCLUSIVE MODE NOWAIT , testdb_S . t1_all_2_S AS x READ ", packet_length=100) at sql_parse.cc:1076 #12 0x00000000006e6d1c in do_command (thd=0x3bc3f38) at sql_parse.cc:758 #13 0x00000000006d3a88 in handle_one_connection (arg=0x3bc3f38) at sql_connect.cc:1164 #14 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #15 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7fc175f77950 (LWP 23244)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=2633) at thr_mutex.c:225 #4 0x0000000000738516 in open_table (thd=0x3978898, table_list=0x3e877b8, mem_root=0x7fc175f72db0, ot_ctx=0x7fc175f72e20, flags=2) at sql_base.cc:2633 #5 0x0000000000739796 in open_and_process_table (thd=0x3978898, lex=0x3a55cb8, tables=0x3e877b8, counter=0x7fc175f72f2c, flags=2, prelocking_strategy=0x7fc175f72eb0, has_prelocking_list=false, ot_ctx=0x7fc175f72e20, new_frm_mem=0x7fc175f72db0) at sql_base.cc:3940 #6 0x0000000000739e83 in open_tables (thd=0x3978898, start=0x7fc175f72ef0, counter=0x7fc175f72f2c, flags=2, prelocking_strategy=0x7fc175f72eb0) at sql_base.cc:4178 #7 0x00000000005d92d2 in open_tables (thd=0x3978898, tables=0x7fc175f72ef0, counter=0x7fc175f72f2c, flags=2) at mysql_priv.h:1506 #8 0x000000000073a27a in open_normal_and_derived_tables (thd=0x3978898, tables=0x3e877b8, flags=2) at sql_base.cc:4817 #9 0x00000000008828c9 in get_all_tables (thd=0x3978898, tables=0x3a571b0, cond=0x3e87348) at sql_show.cc:3630 #10 0x000000000086d349 in get_schema_tables_result (join=0x4045d30, executed_place=PROCESSED_BY_JOIN_EXEC) at sql_show.cc:6639 #11 0x0000000000782109 in JOIN::exec (this=0x4045d30) at sql_select.cc:2434 #12 0x000000000077e832 in mysql_select (thd=0x3978898, rref_pointer_array=0x3a565d0, tables=0x3a571b0, wild_num=0, fields=@0x3a564f0, conds=0x3bd9b88, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2953054720, result=0x3a89e38, unit=0x3a55d58, select_lex=0x3a563e8) at sql_select.cc:3120 #13 0x0000000000784273 in handle_select (thd=0x3978898, lex=0x3a55cb8, result=0x3a89e38, setup_tables_done_option=0) at sql_select.cc:307 #14 0x00000000006dac35 in execute_sqlcom_select (thd=0x3978898, all_tables=0x3a571b0) at sql_parse.cc:4965 #15 0x00000000006dc601 in mysql_execute_command (thd=0x3978898) at sql_parse.cc:2156 #16 0x00000000007986b5 in Prepared_statement::execute (this=0x3d57228, expanded_query=0x7fc175f752a0, open_cursor=false) at sql_prepare.cc:3765 #17 0x000000000079ca1d in Prepared_statement::execute_loop (this=0x3d57228, expanded_query=0x7fc175f752a0, open_cursor=false, packet=0x0, packet_end=0x0) at sql_prepare.cc:3398 #18 0x000000000079ccb4 in mysql_sql_stmt_execute (thd=0x3978898) at sql_prepare.cc:2571 #19 0x00000000006dc62c in mysql_execute_command (thd=0x3978898) at sql_parse.cc:2166 #20 0x00000000006e4b41 in mysql_parse (thd=0x3978898, inBuf=0x3bd9a00 "EXECUTE st1", length=11, found_semicolon=0x7fc175f76f00) at sql_parse.cc:5979 #21 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3978898, packet=0x397b689 " EXECUTE st1 ", packet_length=13) at sql_parse.cc:1076 #22 0x00000000006e6d1c in do_command (thd=0x3978898) at sql_parse.cc:758 #23 0x00000000006d3a88 in handle_one_connection (arg=0x3978898) at sql_connect.cc:1164 #24 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #25 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7fc175f36950 (LWP 23246)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=1255) at thr_mutex.c:225 #4 0x0000000000736210 in close_open_tables (thd=0x3cb4368) at sql_base.cc:1255 #5 0x0000000000736659 in close_thread_tables (thd=0x3cb4368) at sql_base.cc:1503 #6 0x00000000006e6953 in dispatch_command (command=COM_QUERY, thd=0x3cb4368, packet=0x3ca8729 "", packet_length=236) at sql_parse.cc:1446 #7 0x00000000006e6d1c in do_command (thd=0x3cb4368) at sql_parse.cc:758 #8 0x00000000006d3a88 in handle_one_connection (arg=0x3cb4368) at sql_connect.cc:1164 #9 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #10 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7fc175eb4950 (LWP 23249)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b0091b0 in _L_lock_102 () from /lib64/libpthread.so.0 #2 0x000000315b008a9e in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1258600, my_flags=0, file=0xd6b0bf "mdl.cc", line=1236) at thr_mutex.c:225 #4 0x000000000090d0df in MDL_context::wait_for_locks (this=0x3cb0700, mdl_requests=0x7fc175eb2200) at mdl.cc:1236 #5 0x0000000000737941 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7fc175eb2200, thd=0x3cb0628, table=0x3a28c40) at sql_base.cc:3700 #6 0x0000000000739ecf in open_tables (thd=0x3cb0628, start=0x7fc175eb2290, counter=0x7fc175eb22d0, flags=32, prelocking_strategy=0x7fc175eb3260) at sql_base.cc:4206 #7 0x000000000073a378 in open_and_lock_tables_derived (thd=0x3cb0628, tables=0x3a28c40, derived=false, flags=32, prelocking_strategy=0x7fc175eb3260) at sql_base.cc:4763 #8 0x00000000006e03ff in mysql_execute_command (thd=0x3cb0628) at sql_parse.cc:3658 #9 0x00000000006e4b41 in mysql_parse (thd=0x3cb0628, inBuf=0x3a28b10 "LOCK TABLES testdb_S . t1_all_2_S AS o READ", length=44, found_semicolon=0x7fc175eb3f00) at sql_parse.cc:5979 #10 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3cb0628, packet=0x3a66ab9 "LOCK TABLES testdb_S . t1_all_2_S AS o READ ", packet_length=45) at sql_parse.cc:1076 #11 0x00000000006e6d1c in do_command (thd=0x3cb0628) at sql_parse.cc:758 #12 0x00000000006d3a88 in handle_one_connection (arg=0x3cb0628) at sql_connect.cc:1164 #13 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #14 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7fc176201950 (LWP 23251)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x12586c0, mp=0x1258600, file=0xd6b0bf "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x000000000090d25c in MDL_context::wait_for_locks (this=0x3b29c20, mdl_requests=0x7fc1761ff200) at mdl.cc:1261 #3 0x0000000000737941 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7fc1761ff200, thd=0x3b29b48, table=0x3aed878) at sql_base.cc:3700 #4 0x0000000000739ecf in open_tables (thd=0x3b29b48, start=0x7fc1761ff290, counter=0x7fc1761ff2d0, flags=32, prelocking_strategy=0x7fc176200260) at sql_base.cc:4206 #5 0x000000000073a378 in open_and_lock_tables_derived (thd=0x3b29b48, tables=0x3aed878, derived=false, flags=32, prelocking_strategy=0x7fc176200260) at sql_base.cc:4763 #6 0x00000000006e03ff in mysql_execute_command (thd=0x3b29b48) at sql_parse.cc:3658 #7 0x00000000006e4b41 in mysql_parse (thd=0x3b29b48, inBuf=0x3aed6e0 "LOCK TABLES testdb_S . t1_all_2_S AS y READ , testdb_S . t1_all_2_S AS v IN SHARE MODE NOWAIT", length=96, found_semicolon=0x7fc176200f00) at sql_parse.cc:5979 #8 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3b29b48, packet=0x3b0e109 "LOCK TABLES testdb_S . t1_all_2_S AS y READ , testdb_S . t1_all_2_S AS v IN SHARE MODE NOWAIT", packet_length=96) at sql_parse.cc:1076 #9 0x00000000006e6d1c in do_command (thd=0x3b29b48) at sql_parse.cc:758 #10 0x00000000006d3a88 in handle_one_connection (arg=0x3b29b48) at sql_connect.cc:1164 #11 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #12 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7fc175e32950 (LWP 23254)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=1255) at thr_mutex.c:225 #4 0x0000000000736210 in close_open_tables (thd=0x3b25c88) at sql_base.cc:1255 #5 0x0000000000736659 in close_thread_tables (thd=0x3b25c88) at sql_base.cc:1503 #6 0x00000000006e6953 in dispatch_command (command=COM_QUERY, thd=0x3b25c88, packet=0x3d43439 "", packet_length=80) at sql_parse.cc:1446 #7 0x00000000006e6d1c in do_command (thd=0x3b25c88) at sql_parse.cc:758 #8 0x00000000006d3a88 in handle_one_connection (arg=0x3b25c88) at sql_connect.cc:1164 #9 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #10 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7fc175df1950 (LWP 23256)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x12586c0, mp=0x1258600, file=0xd6b0bf "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x000000000090d25c in MDL_context::wait_for_locks (this=0x3d5ef50, mdl_requests=0x7fc175dee130) at mdl.cc:1261 #3 0x0000000000737941 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7fc175dee130, thd=0x3d5ee78, table=0x3e355d8) at sql_base.cc:3700 #4 0x0000000000739ecf in open_tables (thd=0x3d5ee78, start=0x7fc175dee1c0, counter=0x7fc175dee200, flags=32, prelocking_strategy=0x7fc175def1e0) at sql_base.cc:4206 #5 0x000000000073a378 in open_and_lock_tables_derived (thd=0x3d5ee78, tables=0x3e355d8, derived=false, flags=32, prelocking_strategy=0x7fc175def1e0) at sql_base.cc:4763 #6 0x000000000085978d in mysql_alter_table (thd=0x3d5ee78, new_db=0x3e35580 "testdb_S", new_name=0x0, create_info=0x7fc175def600, table_list=0x3e355d8, alter_info=0x7fc175df0180, order_num=0, order=0x0, ignore=false) at sql_table.cc:6934 #7 0x00000000006de196 in mysql_execute_command (thd=0x3d5ee78) at sql_parse.cc:2914 #8 0x00000000006e4b41 in mysql_parse (thd=0x3d5ee78, inBuf=0x3e35480 "ALTER TABLE testdb_S . t1_all_2_S CHANGE COLUMN `int` my_column INT", length=68, found_semicolon=0x7fc175df0f00) at sql_parse.cc:5979 #9 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3d5ee78, packet=0x3d52199 "ALTER TABLE testdb_S . t1_all_2_S CHANGE COLUMN `int` my_column INT", packet_length=68) at sql_parse.cc:1076 #10 0x00000000006e6d1c in do_command (thd=0x3d5ee78) at sql_parse.cc:758 #11 0x00000000006d3a88 in handle_one_connection (arg=0x3d5ee78) at sql_connect.cc:1164 #12 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #13 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7fc175db0950 (LWP 23258)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=1255) at thr_mutex.c:225 #4 0x0000000000736210 in close_open_tables (thd=0x3db7118) at sql_base.cc:1255 #5 0x0000000000736659 in close_thread_tables (thd=0x3db7118) at sql_base.cc:1503 #6 0x00000000007367d7 in close_tables_for_reopen (thd=0x3db7118, tables=0x7fc175dae2a0) at sql_base.cc:5225 #7 0x00000000006bdb3e in try_transactional_lock (thd=0x3db7118, table_list=0x3dda9a0) at lock.cc:1543 #8 0x00000000006e0299 in mysql_execute_command (thd=0x3db7118) at sql_parse.cc:3614 #9 0x00000000006e4b41 in mysql_parse (thd=0x3db7118, inBuf=0x3dda850 "LOCK TABLES testdb_S . t1_all_1_S AS u IN SHARE MODE NOWAIT", length=60, found_semicolon=0x7fc175daff00) at sql_parse.cc:5979 #10 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3db7118, packet=0x3dcaa39 "LOCK TABLES testdb_S . t1_all_1_S AS u IN SHARE MODE NOWAIT", packet_length=60) at sql_parse.cc:1076 #11 0x00000000006e6d1c in do_command (thd=0x3db7118) at sql_parse.cc:758 #12 0x00000000006d3a88 in handle_one_connection (arg=0x3db7118) at sql_connect.cc:1164 #13 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #14 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7fc175ef5950 (LWP 23260)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=1255) at thr_mutex.c:225 #4 0x0000000000736210 in close_open_tables (thd=0x3c26918) at sql_base.cc:1255 #5 0x0000000000736659 in close_thread_tables (thd=0x3c26918) at sql_base.cc:1503 #6 0x00000000007368ac in Locked_tables_list::unlock_locked_tables (this=0x3c28150, thd=0x3c26918) at sql_base.cc:3131 #7 0x00000000006e0314 in mysql_execute_command (thd=0x3c26918) at sql_parse.cc:3637 #8 0x00000000006e4b41 in mysql_parse (thd=0x3c26918, inBuf=0x3dc6d10 "LOCK TABLES testdb_S . t1_all_1_S AS k IN SHARE MODE NOWAIT , testdb_S . t1_all_1_S AS q LOW_PRIORITY WRITE", length=109, found_semicolon=0x7fc175ef4f00) at sql_parse.cc:5979 #9 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3c26918, packet=0x3d1de49 "LOCK TABLES testdb_S . t1_all_1_S AS k IN SHARE MODE NOWAIT , testdb_S . t1_all_1_S AS q LOW_PRIORITY WRITE", packet_length=109) at sql_parse.cc:1076 #10 0x00000000006e6d1c in do_command (thd=0x3c26918) at sql_parse.cc:758 #11 0x00000000006d3a88 in handle_one_connection (arg=0x3c26918) at sql_connect.cc:1164 #12 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #13 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7fc175d6f950 (LWP 23262)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=2633) at thr_mutex.c:225 #4 0x0000000000738516 in open_table (thd=0x3e09b58, table_list=0x3c44340, mem_root=0x7fc175d6d190, ot_ctx=0x7fc175d6d200, flags=32) at sql_base.cc:2633 #5 0x0000000000739796 in open_and_process_table (thd=0x3e09b58, lex=0x3e0b428, tables=0x3c44340, counter=0x7fc175d6d2d0, flags=32, prelocking_strategy=0x7fc175d6e260, has_prelocking_list=false, ot_ctx=0x7fc175d6d200, new_frm_mem=0x7fc175d6d190) at sql_base.cc:3940 #6 0x0000000000739e83 in open_tables (thd=0x3e09b58, start=0x7fc175d6d290, counter=0x7fc175d6d2d0, flags=32, prelocking_strategy=0x7fc175d6e260) at sql_base.cc:4178 #7 0x000000000073a378 in open_and_lock_tables_derived (thd=0x3e09b58, tables=0x3c43d48, derived=false, flags=32, prelocking_strategy=0x7fc175d6e260) at sql_base.cc:4763 #8 0x00000000006e03ff in mysql_execute_command (thd=0x3e09b58) at sql_parse.cc:3658 #9 0x00000000006e4b41 in mysql_parse (thd=0x3e09b58, inBuf=0x3c43bb0 "LOCK TABLES testdb_S . t1_all_1_S AS j IN SHARE MODE NOWAIT , testdb_S . t1_all_1_N AS g WRITE", length=97, found_semicolon=0x7fc175d6ef00) at sql_parse.cc:5979 #10 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x3e09b58, packet=0x3df0fe9 "LOCK TABLES testdb_S . t1_all_1_S AS j IN SHARE MODE NOWAIT , testdb_S . t1_all_1_N AS g WRITE", packet_length=97) at sql_parse.cc:1076 #11 0x00000000006e6d1c in do_command (thd=0x3e09b58) at sql_parse.cc:758 #12 0x00000000006d3a88 in handle_one_connection (arg=0x3e09b58) at sql_connect.cc:1164 #13 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #14 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7fc17617f950 (LWP 23265)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=1255) at thr_mutex.c:225 #4 0x0000000000736210 in close_open_tables (thd=0x3a31188) at sql_base.cc:1255 #5 0x0000000000736659 in close_thread_tables (thd=0x3a31188) at sql_base.cc:1503 #6 0x00000000006e6953 in dispatch_command (command=COM_QUERY, thd=0x3a31188, packet=0x3a0d189 "", packet_length=157) at sql_parse.cc:1446 #7 0x00000000006e6d1c in do_command (thd=0x3a31188) at sql_parse.cc:758 #8 0x00000000006d3a88 in handle_one_connection (arg=0x3a31188) at sql_connect.cc:1164 #9 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #10 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7fc175d2e950 (LWP 23266)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x1248740, mp=0x1247a60, file=0xd2040c "sql_base.cc", line=1062) at thr_mutex.c:423 #2 0x000000000073ae4a in close_cached_tables (thd=0x7fc1701526a8, tables=0x3e0ca70, have_lock=false, wait_for_refresh=true) at sql_base.cc:1062 #3 0x00000000006d6805 in reload_acl_and_cache (thd=0x7fc1701526a8, options=4, tables=0x3e0ca70, write_to_binlog=0x7fc175d2d25f) at sql_parse.cc:6966 #4 0x00000000006e1e67 in mysql_execute_command (thd=0x7fc1701526a8) at sql_parse.cc:4084 #5 0x00000000006e4b41 in mysql_parse (thd=0x7fc1701526a8, inBuf=0x3e0c960 "FLUSH TABLE testdb_S . t1_all_2_S", length=33, found_semicolon=0x7fc175d2df00) at sql_parse.cc:5979 #6 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x7fc1701526a8, packet=0x7fc17015d219 "FLUSH TABLE testdb_S . t1_all_2_S ", packet_length=34) at sql_parse.cc:1076 #7 0x00000000006e6d1c in do_command (thd=0x7fc1701526a8) at sql_parse.cc:758 #8 0x00000000006d3a88 in handle_one_connection (arg=0x7fc1701526a8) at sql_connect.cc:1164 #9 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #10 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7fc175ced950 (LWP 23268)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b0109a4 in _L_cond_lock_102 () from /lib64/libpthread.so.0 #2 0x000000315b01028e in __pthread_mutex_cond_lock () from /lib64/libpthread.so.0 #3 0x000000315b00b3a4 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #4 0x0000000000b551b5 in safe_cond_wait (cond=0x12586c0, mp=0x1258600, file=0xd6b0bf "mdl.cc", line=1261) at thr_mutex.c:423 #5 0x000000000090d25c in MDL_context::wait_for_locks (this=0x7fc170125de0, mdl_requests=0x7fc175ceb190) at mdl.cc:1261 #6 0x0000000000737941 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7fc175ceb190, thd=0x7fc170125d08, table=0x3f10b48) at sql_base.cc:3700 #7 0x0000000000739ecf in open_tables (thd=0x7fc170125d08, start=0x7fc175ceb220, counter=0x7fc175ceb260, flags=0, prelocking_strategy=0x7fc175ceb2a0) at sql_base.cc:4206 #8 0x000000000073a378 in open_and_lock_tables_derived (thd=0x7fc170125d08, tables=0x3f10b48, derived=true, flags=0, prelocking_strategy=0x7fc175ceb2a0) at sql_base.cc:4763 #9 0x00000000006e7cc8 in open_and_lock_tables_derived (thd=0x7fc170125d08, tables=0x3f10b48, derived=true, flags=0) at ../mysql_priv.h:1518 #10 0x00000000006e7d03 in open_and_lock_tables (thd=0x7fc170125d08, tables=0x3f10b48) at ../../sql/mysql_priv.h:1528 #11 0x00000000006df2de in mysql_execute_command (thd=0x7fc170125d08) at sql_parse.cc:3299 #12 0x00000000006e4b41 in mysql_parse (thd=0x7fc170125d08, inBuf=0x3b37880 "INSERT INTO testdb_S . t1_all_2_S SELECT * FROM test . table0_int_autoinc ; COMMIT ; SELECT SLEEP( 0.15 * 1 ) ; DROP TABLE testdb_S . t1_all_2_S /* Sequence end */", length=163, found_semicolon=0x7fc175cecf00) at sql_parse.cc:5979 #13 0x00000000006e5979 in dispatch_command (command=COM_QUERY, thd=0x7fc170125d08, packet=0x7fc170084759 "", packet_length=307) at sql_parse.cc:1124 #14 0x00000000006e6d1c in do_command (thd=0x7fc170125d08) at sql_parse.cc:758 #15 0x00000000006d3a88 in handle_one_connection (arg=0x7fc170125d08) at sql_connect.cc:1164 #16 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #17 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7fc175e73950 (LWP 23270)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x12586c0, mp=0x1258600, file=0xd6b0bf "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x000000000090d25c in MDL_context::wait_for_locks (this=0x7fc17002f570, mdl_requests=0x7fc175e70df0) at mdl.cc:1261 #3 0x0000000000737941 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7fc175e70df0, thd=0x7fc17002f498, table=0x3c90480) at sql_base.cc:3700 #4 0x0000000000739ecf in open_tables (thd=0x7fc17002f498, start=0x7fc175e70ec0, counter=0x7fc175e70efc, flags=0, prelocking_strategy=0x7fc175e70e80) at sql_base.cc:4206 #5 0x00000000005d92d2 in open_tables (thd=0x7fc17002f498, tables=0x7fc175e70ec0, counter=0x7fc175e70efc, flags=0) at mysql_priv.h:1506 #6 0x000000000073a27a in open_normal_and_derived_tables (thd=0x7fc17002f498, tables=0x3c90480, flags=0) at sql_base.cc:4817 #7 0x0000000000799dfb in mysql_test_delete (stmt=0x38b88f8, table_list=0x3c90480) at sql_prepare.cc:1368 #8 0x000000000079be30 in check_prepared_statement (stmt=0x38b88f8) at sql_prepare.cc:1940 #9 0x000000000079c476 in Prepared_statement::prepare (this=0x38b88f8, packet=0x3d2ba58 " DELETE LOW_PRIORITY FROM testdb_S . t1_all_2_S WHERE `pk` > 5 LIMIT 1 ", packet_len=73) at sql_prepare.cc:3204 #10 0x000000000079d177 in mysql_sql_stmt_prepare (thd=0x7fc17002f498) at sql_prepare.cc:2324 #11 0x00000000006dc61b in mysql_execute_command (thd=0x7fc17002f498) at sql_parse.cc:2161 #12 0x00000000006e4b41 in mysql_parse (thd=0x7fc17002f498, inBuf=0x3d2b8d0 "PREPARE st1 FROM \" DELETE LOW_PRIORITY FROM testdb_S . t1_all_2_S WHERE `pk` > 5 LIMIT 1 \"", length=92, found_semicolon=0x7fc175e72f00) at sql_parse.cc:5979 #13 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x7fc17002f498, packet=0x7fc1701047b9 "PREPARE st1 FROM \" DELETE LOW_PRIORITY FROM testdb_S . t1_all_2_S WHERE `pk` > 5 LIMIT 1 \" ", packet_length=93) at sql_parse.cc:1076 #14 0x00000000006e6d1c in do_command (thd=0x7fc17002f498) at sql_parse.cc:758 #15 0x00000000006d3a88 in handle_one_connection (arg=0x7fc17002f498) at sql_connect.cc:1164 #16 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #17 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7fc175cac950 (LWP 23271)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=1255) at thr_mutex.c:225 #4 0x0000000000736210 in close_open_tables (thd=0x7fc1700fa9a8) at sql_base.cc:1255 #5 0x0000000000736659 in close_thread_tables (thd=0x7fc1700fa9a8) at sql_base.cc:1503 #6 0x0000000000796539 in Prepared_statement::cleanup_stmt (this=0x3cd8b48) at sql_prepare.cc:3056 #7 0x000000000079873a in Prepared_statement::execute (this=0x3cd8b48, expanded_query=0x7fc175caa2a0, open_cursor=false) at sql_prepare.cc:3785 #8 0x000000000079ca1d in Prepared_statement::execute_loop (this=0x3cd8b48, expanded_query=0x7fc175caa2a0, open_cursor=false, packet=0x0, packet_end=0x0) at sql_prepare.cc:3398 #9 0x000000000079ccb4 in mysql_sql_stmt_execute (thd=0x7fc1700fa9a8) at sql_prepare.cc:2571 #10 0x00000000006dc62c in mysql_execute_command (thd=0x7fc1700fa9a8) at sql_parse.cc:2166 #11 0x00000000006e4b41 in mysql_parse (thd=0x7fc1700fa9a8, inBuf=0x3d3d420 "EXECUTE st1", length=11, found_semicolon=0x7fc175cabf00) at sql_parse.cc:5979 #12 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x7fc1700fa9a8, packet=0x7fc1701963d9 " EXECUTE st1 ", packet_length=13) at sql_parse.cc:1076 #13 0x00000000006e6d1c in do_command (thd=0x7fc1700fa9a8) at sql_parse.cc:758 #14 0x00000000006d3a88 in handle_one_connection (arg=0x7fc1700fa9a8) at sql_connect.cc:1164 #15 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #16 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7fc176242950 (LWP 23272)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x12586c0, mp=0x1258600, file=0xd6b0bf "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x000000000090d25c in MDL_context::wait_for_locks (this=0x7fc1700e7240, mdl_requests=0x7fc1762401d0) at mdl.cc:1261 #3 0x0000000000737941 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7fc1762401d0, thd=0x7fc1700e7168, table=0x3cc8180) at sql_base.cc:3700 #4 0x0000000000739ecf in open_tables (thd=0x7fc1700e7168, start=0x7fc1762402a0, counter=0x7fc1762402d8, flags=0, prelocking_strategy=0x7fc176240260) at sql_base.cc:4206 #5 0x00000000005d92d2 in open_tables (thd=0x7fc1700e7168, tables=0x7fc1762402a0, counter=0x7fc1762402d8, flags=0) at mysql_priv.h:1506 #6 0x00000000006bdaa5 in try_transactional_lock (thd=0x7fc1700e7168, table_list=0x3cc8180) at lock.cc:1521 #7 0x00000000006e0299 in mysql_execute_command (thd=0x7fc1700e7168) at sql_parse.cc:3614 #8 0x00000000006e4b41 in mysql_parse (thd=0x7fc1700e7168, inBuf=0x3cc8040 "LOCK TABLES testdb_S . t1_all_2_S AS e IN SHARE MODE", length=53, found_semicolon=0x7fc176241f00) at sql_parse.cc:5979 #9 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x7fc1700e7168, packet=0x7fc17011a349 "LOCK TABLES testdb_S . t1_all_2_S AS e IN SHARE MODE ", packet_length=54) at sql_parse.cc:1076 #10 0x00000000006e6d1c in do_command (thd=0x7fc1700e7168) at sql_parse.cc:758 #11 0x00000000006d3a88 in handle_one_connection (arg=0x7fc1700e7168) at sql_connect.cc:1164 #12 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #13 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7fc1760fd950 (LWP 23274)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=2128) at thr_mutex.c:225 #4 0x0000000000735814 in wait_while_table_is_used (thd=0x7fc1701a8008, table=0x3d7e058, function=HA_EXTRA_PREPARE_FOR_RENAME) at sql_base.cc:2128 #5 0x000000000085e9e9 in mysql_admin_table (thd=0x7fc1701a8008, tables=0x3959318, check_opt=0x7fc1701aa6a8, operator_name=0xd4b1f5 "optimize", lock_type=TL_WRITE, open_for_modify=true, no_warnings_for_error=false, extra_open_options=0, prepare_func=0, operator_func=0x82e7a0 , view_operator_func=0) at sql_table.cc:4695 #6 0x0000000000860185 in mysql_optimize_table (thd=0x7fc1701a8008, tables=0x3959318, check_opt=0x7fc1701aa6a8) at sql_table.cc:5014 #7 0x00000000006dead8 in mysql_execute_command (thd=0x7fc1701a8008) at sql_parse.cc:3112 #8 0x00000000006e4b41 in mysql_parse (thd=0x7fc1701a8008, inBuf=0x39591e0 "OPTIMIZE NO_WRITE_TO_BINLOG TABLE testdb_S . t1_all_1_S", length=55, found_semicolon=0x7fc1760fcf00) at sql_parse.cc:5979 #9 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x7fc1701a8008, packet=0x7fc17001f7e9 "", packet_length=56) at sql_parse.cc:1076 #10 0x00000000006e6d1c in do_command (thd=0x7fc1701a8008) at sql_parse.cc:758 #11 0x00000000006d3a88 in handle_one_connection (arg=0x7fc1701a8008) at sql_connect.cc:1164 #12 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #13 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7fc176346950 (LWP 23275)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=940) at thr_mutex.c:225 #4 0x000000000073aa63 in close_cached_tables (thd=0x7fc170092788, tables=0x3ca4970, have_lock=false, wait_for_refresh=true) at sql_base.cc:940 #5 0x00000000006d6805 in reload_acl_and_cache (thd=0x7fc170092788, options=4, tables=0x3ca4970, write_to_binlog=0x7fc17634525f) at sql_parse.cc:6966 #6 0x00000000006e1e67 in mysql_execute_command (thd=0x7fc170092788) at sql_parse.cc:4084 #7 0x00000000006e4b41 in mysql_parse (thd=0x7fc170092788, inBuf=0x3ca4860 "FLUSH TABLE testdb_S . t1_all_1_S", length=33, found_semicolon=0x7fc176345f00) at sql_parse.cc:5979 #8 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x7fc170092788, packet=0x7fc170100289 "FLUSH TABLE testdb_S . t1_all_1_S ", packet_length=34) at sql_parse.cc:1076 #9 0x00000000006e6d1c in do_command (thd=0x7fc170092788) at sql_parse.cc:758 #10 0x00000000006d3a88 in handle_one_connection (arg=0x7fc170092788) at sql_connect.cc:1164 #11 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #12 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7fc1760bc950 (LWP 23277)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x12586c0, mp=0x1258600, file=0xd6b0bf "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x000000000090d25c in MDL_context::wait_for_locks (this=0x7fc17014e8c0, mdl_requests=0x7fc1760ba190) at mdl.cc:1261 #3 0x0000000000737941 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7fc1760ba190, thd=0x7fc17014e7e8, table=0x3a4bef0) at sql_base.cc:3700 #4 0x0000000000739ecf in open_tables (thd=0x7fc17014e7e8, start=0x7fc1760ba220, counter=0x7fc1760ba260, flags=0, prelocking_strategy=0x7fc1760ba2a0) at sql_base.cc:4206 #5 0x000000000073a378 in open_and_lock_tables_derived (thd=0x7fc17014e7e8, tables=0x385f800, derived=true, flags=0, prelocking_strategy=0x7fc1760ba2a0) at sql_base.cc:4763 #6 0x00000000006e7cc8 in open_and_lock_tables_derived (thd=0x7fc17014e7e8, tables=0x385f800, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x00000000006e7d03 in open_and_lock_tables (thd=0x7fc17014e7e8, tables=0x385f800) at ../../sql/mysql_priv.h:1528 #8 0x00000000006df2de in mysql_execute_command (thd=0x7fc17014e7e8) at sql_parse.cc:3299 #9 0x00000000006e4b41 in mysql_parse (thd=0x7fc17014e7e8, inBuf=0x385f5d0 "REPLACE testdb_S . t1_all_2_S ( `pk`,`int_key`,`int` ) SELECT `pk`,`int_key`,`int` FROM ( SELECT * FROM testdb_S . t1_all_1_S ) AS A WHERE `pk` BETWEEN 5 AND 5 + 1 LIMIT 1", length=177, found_semicolon=0x7fc1760bbf00) at sql_parse.cc:5979 #10 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x7fc17014e7e8, packet=0x7fc1700b2119 "REPLACE testdb_S . t1_all_2_S ( `pk`,`int_key`,`int` ) SELECT `pk`,`int_key`,`int` FROM ( SELECT * FROM testdb_S . t1_all_1_S ) AS A WHERE `pk` BETWEEN 5 AND 5 + 1 LIMIT 1", packet_length=177) at sql_parse.cc:1076 #11 0x00000000006e6d1c in do_command (thd=0x7fc17014e7e8) at sql_parse.cc:758 #12 0x00000000006d3a88 in handle_one_connection (arg=0x7fc17014e7e8) at sql_connect.cc:1164 #13 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #14 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7fc176387950 (LWP 23278)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000b551b5 in safe_cond_wait (cond=0x1248740, mp=0x1247a60, file=0xd2040c "sql_base.cc", line=1062) at thr_mutex.c:423 #2 0x000000000073ae4a in close_cached_tables (thd=0x7fc17006f698, tables=0x3db2130, have_lock=false, wait_for_refresh=true) at sql_base.cc:1062 #3 0x00000000006d6805 in reload_acl_and_cache (thd=0x7fc17006f698, options=4, tables=0x3db2130, write_to_binlog=0x7fc17638625f) at sql_parse.cc:6966 #4 0x00000000006e1e67 in mysql_execute_command (thd=0x7fc17006f698) at sql_parse.cc:4084 #5 0x00000000006e4b41 in mysql_parse (thd=0x7fc17006f698, inBuf=0x3db2020 "FLUSH TABLE testdb_S . t1_all_2_S", length=33, found_semicolon=0x7fc176386f00) at sql_parse.cc:5979 #6 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x7fc17006f698, packet=0x7fc17004aa09 "FLUSH TABLE testdb_S . t1_all_2_S ", packet_length=34) at sql_parse.cc:1076 #7 0x00000000006e6d1c in do_command (thd=0x7fc17006f698) at sql_parse.cc:758 #8 0x00000000006d3a88 in handle_one_connection (arg=0x7fc17006f698) at sql_connect.cc:1164 #9 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #10 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7fc175ff9950 (LWP 23280)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247a60, my_flags=0, file=0xd2040c "sql_base.cc", line=1255) at thr_mutex.c:225 #4 0x0000000000736210 in close_open_tables (thd=0x3b83098) at sql_base.cc:1255 #5 0x0000000000736659 in close_thread_tables (thd=0x3b83098) at sql_base.cc:1503 #6 0x000000000078db69 in handle_delayed_insert_impl (thd=0x3b83098, di=0x3b83078) at sql_insert.cc:2581 #7 0x000000000078dd57 in handle_delayed_insert (arg=0x3b83078) at sql_insert.cc:2632 #8 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #9 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fc175c6b950 (LWP 23281)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x3ccef98, my_flags=0, file=0xd4c59f "sql_show.cc", line=1897) at thr_mutex.c:225 #4 0x000000000087cbfd in mysqld_list_processes (thd=0x7fc170080a58, user=0x0, verbose=true) at sql_show.cc:1897 #5 0x00000000006dfcb0 in mysql_execute_command (thd=0x7fc170080a58) at sql_parse.cc:3478 #6 0x00000000006e4b41 in mysql_parse (thd=0x7fc170080a58, inBuf=0x3f02e80 "SHOW FULL PROCESSLIST", length=21, found_semicolon=0x7fc175c6af00) at sql_parse.cc:5979 #7 0x00000000006e57aa in dispatch_command (command=COM_QUERY, thd=0x7fc170080a58, packet=0x7fc170142ba9 "", packet_length=21) at sql_parse.cc:1076 #8 0x00000000006e6d1c in do_command (thd=0x7fc170080a58) at sql_parse.cc:758 #9 0x00000000006d3a88 in handle_one_connection (arg=0x7fc170080a58) at sql_connect.cc:1164 #10 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #11 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7fc1847b9700 (LWP 23165)): #0 0x000000315b00db14 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000315b00921c in _L_lock_1078 () from /lib64/libpthread.so.0 #2 0x000000315b0090f0 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000b54929 in safe_mutex_lock (mp=0x1247b00, my_flags=0, file=0xcb61c5 "mysql_priv.h", line=2402) at thr_mutex.c:225 #4 0x00000000006b67f8 in sql_rnd_with_mutex () at mysql_priv.h:2402 #5 0x00000000006b26e0 in THD (this=0x7fc170146be8) at sql_class.cc:585 #6 0x00000000006ca5c4 in handle_connections_sockets () at mysqld.cc:5494 #7 0x00000000006ce02a in main (argc=44, argv=0x7fff8c7ccb58) at mysqld.cc:4855