Thread 25 (Thread 0x7ff939f7f950 (LWP 11145)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x2654bf8, mp=0x2654b80, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x2654b80, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=0, message1=0x7ff939f7f0d0, message2=0x7ff939f7f0c8, type=0x7ff939f7f0c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=0) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3040) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7ff9303d3950 (LWP 11146)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x2654cb8, mp=0x2654c40, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x2654c40, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=1, message1=0x7ff9303d30d0, message2=0x7ff9303d30c8, type=0x7ff9303d30c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=1) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3048) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7ff92f9d2950 (LWP 11147)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x2654d78, mp=0x2654d00, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x2654d00, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=2, message1=0x7ff92f9d20d0, message2=0x7ff92f9d20c8, type=0x7ff92f9d20c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=2) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3050) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7ff92efd1950 (LWP 11148)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x2654e38, mp=0x2654dc0, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x2654dc0, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=3, message1=0x7ff92efd10d0, message2=0x7ff92efd10c8, type=0x7ff92efd10c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=3) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3058) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 ---Type to continue, or q to quit--- Thread 21 (Thread 0x7ff92e5d0950 (LWP 11149)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x2654ef8, mp=0x2654e80, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x2654e80, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=4, message1=0x7ff92e5d00d0, message2=0x7ff92e5d00c8, type=0x7ff92e5d00c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=4) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3060) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7ff92dbcf950 (LWP 11150)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x2654fb8, mp=0x2654f40, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x2654f40, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=5, message1=0x7ff92dbcf0d0, message2=0x7ff92dbcf0c8, type=0x7ff92dbcf0c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=5) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3068) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7ff92d1ce950 (LWP 11151)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x2655078, mp=0x2655000, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x2655000, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=6, message1=0x7ff92d1ce0d0, message2=0x7ff92d1ce0c8, type=0x7ff92d1ce0c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=6) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3070) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7ff92c7cd950 (LWP 11152)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x2655138, mp=0x26550c0, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x26550c0, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=7, message1=0x7ff92c7cd0d0, message2=0x7ff92c7cd0c8, type=0x7ff92c7cd0c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=7) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3078) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7ff92bdcc950 (LWP 11153)): ---Type to continue, or q to quit--- #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x26551f8, mp=0x2655180, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x2655180, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=8, message1=0x7ff92bdcc0d0, message2=0x7ff92bdcc0c8, type=0x7ff92bdcc0c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=8) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3080) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7ff92b3cb950 (LWP 11154)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x26552b8, mp=0x2655240, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x2655240, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000088ef0d in os_aio_simulated_handle (global_segment=9, message1=0x7ff92b3cb0d0, message2=0x7ff92b3cb0c8, type=0x7ff92b3cb0c0) at os/os0file.c:4197 #4 0x00000000009167ee in fil_aio_wait (segment=9) at fil/fil0fil.c:4450 #5 0x00000000008c5bf1 in io_handler_thread (arg=0xfc3088) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7ff92a9c9950 (LWP 11155)): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x000000000089096d in os_thread_sleep (tm=1000000) at os/os0thread.c:281 #2 0x00000000008c3c7c in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1984 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7ff929fc8950 (LWP 11156)): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x000000000089096d in os_thread_sleep (tm=1000000) at os/os0thread.c:281 #2 0x00000000008c4188 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2220 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7ff9293c2950 (LWP 11157)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0x205e528, mp=0x205e4b0, file=0xb712f5 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089023c in os_event_wait_low (event=0x205e4b0, reset_sig_count=0) at os/os0sync.c:399 #3 0x00000000008c54fa in srv_master_thread (arg=0x0) at srv/srv0srv.c:2740 #4 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #5 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7ff9289c1950 (LWP 11158)): #0 0x000000315b00ee7b in sigwait () from /lib64/libpthread.so.0 ---Type to continue, or q to quit--- #1 0x000000000062ebbc in signal_hand (arg=0x0) at mysqld.cc:2814 #2 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #3 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7ff9285b0950 (LWP 12112)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0xfb1e60, mp=0xfb1960, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x0000000000688003 in inline_mysql_cond_wait (that=0xfb1e60, mutex=0xfb1960) at ../include/mysql/psi/mysql_thread.h:784 #3 0x00000000006880b0 in wait_for_condition (thd=0x2e52dd8, mutex=0xfb1960, cond=0xfb1e60) at sql_base.cc:2203 #4 0x0000000000696445 in open_table (thd=0x2e52dd8, table_list=0x2d58668, mem_root=0x7ff9285add70, refresh=0x7ff9285addef, flags=0) at sql_base.cc:2870 #5 0x0000000000697676 in open_tables (thd=0x2e52dd8, start=0x7ff9285ade50, counter=0x7ff9285ade84, flags=0) at sql_base.cc:4625 #6 0x0000000000697f2e in open_and_lock_tables_derived (thd=0x2e52dd8, tables=0x2d58668, derived=true) at sql_base.cc:5031 #7 0x000000000064d17d in open_and_lock_tables (thd=0x2e52dd8, tables=0x2d58668) at mysql_priv.h:1564 #8 0x000000000063f4e5 in execute_sqlcom_select (thd=0x2e52dd8, all_tables=0x2d58668) at sql_parse.cc:4994 #9 0x0000000000641276 in mysql_execute_command (thd=0x2e52dd8) at sql_parse.cc:2123 #10 0x000000000064a299 in mysql_parse (thd=0x2e52dd8, inBuf=0x2d583a8 "SELECT * FROM testdb_N . t1_base1_N AS A UNION SELECT * FROM testdb_S . t1_base2_S AS B WHERE `pk` BETWEEN 4 AND 4 + 1", length=123, found_semicolon=0x7ff9285aff10) at sql_parse.cc:6045 #11 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2e52dd8, packet=0x2c62599 "SELECT * FROM testdb_N . t1_base1_N AS A UNION SELECT * FROM testdb_S . t1_base2_S AS B WHERE `pk` BETWEEN 4 AND 4 + 1 ", packet_length=125) at sql_parse.cc:1128 #12 0x000000000064c2fd in do_command (thd=0x2e52dd8) at sql_parse.cc:798 #13 0x00000000006391c0 in handle_one_connection (arg=0x2e52dd8) at sql_connect.cc:1163 #14 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #15 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7ff92887c950 (LWP 12181)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0xfb1e60, mp=0xfb1960, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x0000000000688003 in inline_mysql_cond_wait (that=0xfb1e60, mutex=0xfb1960) at ../include/mysql/psi/mysql_thread.h:784 #3 0x000000000069562b in close_cached_tables (thd=0x2b97048, tables=0x2c8e468, have_lock=false, wait_for_refresh=true, wait_for_placeholders=false) at sql_base.cc:997 #4 0x000000000063b459 in reload_acl_and_cache (thd=0x2b97048, options=4, tables=0x2c8e468, write_to_binlog=0x7ff92887b06f) at sql_parse.cc:7002 #5 0x0000000000646b4a in mysql_execute_command (thd=0x2b97048) at sql_parse.cc:3955 #6 0x000000000064a299 in mysql_parse (thd=0x2b97048, inBuf=0x2c8e358 "FLUSH TABLE testdb_N . t1_base1_N", length=33, found_semicolon=0x7ff92887bf10) at sql_parse.cc:6045 #7 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2b97048, packet=0x2e245c9 "FLUSH TABLE testdb_N . t1_base1_N ", packet_length=34) at sql_parse.cc:1128 #8 0x000000000064c2fd in do_command (thd=0x2b97048) at sql_parse.cc:798 #9 0x00000000006391c0 in handle_one_connection (arg=0x2b97048) at sql_connect.cc:1163 #10 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #11 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7ff928633950 (LWP 12212)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 ---Type to continue, or q to quit--- #1 0x00000000009c3a2e in safe_cond_wait (cond=0xfb1e60, mp=0xfb1960, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x0000000000688003 in inline_mysql_cond_wait (that=0xfb1e60, mutex=0xfb1960) at ../include/mysql/psi/mysql_thread.h:784 #3 0x000000000069562b in close_cached_tables (thd=0x2e3e008, tables=0x2c2b5f8, have_lock=false, wait_for_refresh=true, wait_for_placeholders=false) at sql_base.cc:997 #4 0x000000000063b459 in reload_acl_and_cache (thd=0x2e3e008, options=4, tables=0x2c2b5f8, write_to_binlog=0x7ff92863206f) at sql_parse.cc:7002 #5 0x0000000000646b4a in mysql_execute_command (thd=0x2e3e008) at sql_parse.cc:3955 #6 0x000000000064a299 in mysql_parse (thd=0x2e3e008, inBuf=0x2c2b4e8 "FLUSH TABLE testdb_S . t1_part1_N", length=33, found_semicolon=0x7ff928632f10) at sql_parse.cc:6045 #7 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2e3e008, packet=0x2d43139 "FLUSH TABLE testdb_S . t1_part1_N ", packet_length=34) at sql_parse.cc:1128 #8 0x000000000064c2fd in do_command (thd=0x2e3e008) at sql_parse.cc:798 #9 0x00000000006391c0 in handle_one_connection (arg=0x2e3e008) at sql_connect.cc:1163 #10 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #11 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7ff928980950 (LWP 12217)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0xfb1e60, mp=0xfb1960, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x0000000000688003 in inline_mysql_cond_wait (that=0xfb1e60, mutex=0xfb1960) at ../include/mysql/psi/mysql_thread.h:784 #3 0x00000000006880b0 in wait_for_condition (thd=0x2c34c78, mutex=0xfb1960, cond=0xfb1e60) at sql_base.cc:2203 #4 0x0000000000696445 in open_table (thd=0x2c34c78, table_list=0x2e9e600, mem_root=0x7ff92897dd70, refresh=0x7ff92897ddef, flags=0) at sql_base.cc:2870 #5 0x0000000000697676 in open_tables (thd=0x2c34c78, start=0x7ff92897de50, counter=0x7ff92897de84, flags=0) at sql_base.cc:4625 #6 0x0000000000697f2e in open_and_lock_tables_derived (thd=0x2c34c78, tables=0x2e9e600, derived=true) at sql_base.cc:5031 #7 0x000000000064d17d in open_and_lock_tables (thd=0x2c34c78, tables=0x2e9e600) at mysql_priv.h:1564 #8 0x000000000063f4e5 in execute_sqlcom_select (thd=0x2c34c78, all_tables=0x2e9e600) at sql_parse.cc:4994 #9 0x0000000000641276 in mysql_execute_command (thd=0x2c34c78) at sql_parse.cc:2123 #10 0x000000000064a299 in mysql_parse (thd=0x2c34c78, inBuf=0x2e9e108 "SELECT `pk` , `col_int` , `col_int_key` FROM testdb_S . t1_part1_N AS A WHERE `pk` BETWEEN 8 AND 8 + 1", length=106, found_semicolon=0x7ff92897ff10) at sql_parse.cc:6045 #11 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2c34c78, packet=0x2cf91e9 "SELECT `pk` , `col_int` , `col_int_key` FROM testdb_S . t1_part1_N AS A WHERE `pk` BETWEEN 8 AND 8 + 1 ", packet_length=109) at sql_parse.cc:1128 #12 0x000000000064c2fd in do_command (thd=0x2c34c78) at sql_parse.cc:798 #13 0x00000000006391c0 in handle_one_connection (arg=0x2c34c78) at sql_connect.cc:1163 #14 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #15 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7ff9285f1950 (LWP 12219)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0xfb1e60, mp=0xfb1960, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x0000000000688003 in inline_mysql_cond_wait (that=0xfb1e60, mutex=0xfb1960) at ../include/mysql/psi/mysql_thread.h:784 #3 0x00000000006880b0 in wait_for_condition (thd=0x2c76cf8, mutex=0xfb1960, cond=0xfb1e60) at sql_base.cc:2203 #4 0x0000000000696445 in open_table (thd=0x2c76cf8, table_list=0x2cb2168, mem_root=0x7ff9285ef210, refresh=0x7ff9285ef28f, flags=0) at sql_base.cc:2870 #5 0x0000000000697676 in open_tables (thd=0x2c76cf8, start=0x7ff9285ef2f0, counter=0x7ff9285ef324, flags=0) at sql_base.cc:4625 #6 0x0000000000697f2e in open_and_lock_tables_derived (thd=0x2c76cf8, tables=0x2cb2168, derived=true) at sql_base.cc:5031 ---Type to continue, or q to quit--- #7 0x000000000064d17d in open_and_lock_tables (thd=0x2c76cf8, tables=0x2cb2168) at mysql_priv.h:1564 #8 0x0000000000641eff in mysql_execute_command (thd=0x2c76cf8) at sql_parse.cc:2481 #9 0x000000000064a299 in mysql_parse (thd=0x2c76cf8, inBuf=0x2cb1fb8 "CREATE TABLE testdb_N . t1_base1_N AS SELECT * FROM testdb_S . t1_view2_S A WHERE `pk` BETWEEN 5 AND 5 + 1", length=112, found_semicolon=0x7ff9285f0f10) at sql_parse.cc:6045 #10 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2c76cf8, packet=0x2d5c1b9 "CREATE TABLE testdb_N . t1_base1_N AS SELECT * FROM testdb_S . t1_view2_S A WHERE `pk` BETWEEN 5 AND 5 + 1", packet_length=112) at sql_parse.cc:1128 #11 0x000000000064c2fd in do_command (thd=0x2c76cf8) at sql_parse.cc:798 #12 0x00000000006391c0 in handle_one_connection (arg=0x2c76cf8) at sql_connect.cc:1163 #13 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #14 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7ff9288fe950 (LWP 12220)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0xfb1e60, mp=0xfb1960, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x0000000000688003 in inline_mysql_cond_wait (that=0xfb1e60, mutex=0xfb1960) at ../include/mysql/psi/mysql_thread.h:784 #3 0x00000000006880b0 in wait_for_condition (thd=0x2ca8d48, mutex=0xfb1960, cond=0xfb1e60) at sql_base.cc:2203 #4 0x0000000000696445 in open_table (thd=0x2ca8d48, table_list=0x2c86988, mem_root=0x7ff9288fbc70, refresh=0x7ff9288fbcef, flags=0) at sql_base.cc:2870 #5 0x0000000000697676 in open_tables (thd=0x2ca8d48, start=0x7ff9288fbd50, counter=0x7ff9288fbd84, flags=0) at sql_base.cc:4625 #6 0x0000000000697f2e in open_and_lock_tables_derived (thd=0x2ca8d48, tables=0x2c86988, derived=true) at sql_base.cc:5031 #7 0x000000000064d17d in open_and_lock_tables (thd=0x2ca8d48, tables=0x2c86988) at mysql_priv.h:1564 #8 0x00000000006f9e7b in mysql_delete (thd=0x2ca8d48, table_list=0x2c86988, conds=0x2c86e48, order=0x2caaaf8, limit=1, options=0, reset_auto_increment=false) at sql_delete.cc:59 #9 0x00000000006442fa in mysql_execute_command (thd=0x2ca8d48) at sql_parse.cc:3217 #10 0x000000000064a299 in mysql_parse (thd=0x2ca8d48, inBuf=0x2c86848 "DELETE FROM testdb_S . t1_part1_N WHERE `pk` > 7 LIMIT 1", length=59, found_semicolon=0x7ff9288fdf10) at sql_parse.cc:6045 #11 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2ca8d48, packet=0x2c94f19 "DELETE FROM testdb_S . t1_part1_N WHERE `pk` > 7 LIMIT 1", packet_length=59) at sql_parse.cc:1128 #12 0x000000000064c2fd in do_command (thd=0x2ca8d48) at sql_parse.cc:798 #13 0x00000000006391c0 in handle_one_connection (arg=0x2ca8d48) at sql_connect.cc:1163 #14 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #15 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7ff9286b5950 (LWP 12228)): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3bc6 in safe_cond_timedwait (cond=0xfb1e60, mp=0xfb1960, abstime=0x7ff9286b2030, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=812) at thr_mutex.c:278 #2 0x0000000000688188 in inline_mysql_cond_timedwait (that=0xfb1e60, mutex=0xfb1960, abstime=0x7ff9286b2030) at ../include/mysql/psi/mysql_thread.h:812 #3 0x0000000000690edb in remove_table_from_cache (thd=0x2c56888, db=0x2c53be8 "testdb_N", table_name=0x2c53bf1 "t1_base1_N", flags=2) at sql_base.cc:8596 #4 0x0000000000790938 in wait_while_table_is_used (thd=0x2c56888, table=0x2c07c78, function=HA_EXTRA_PREPARE_FOR_RENAME) at sql_table.cc:4280 #5 0x000000000079b5f6 in mysql_alter_table (thd=0x2c56888, new_db=0x2cab7e0 "testdb_N", new_name=0x2cab7f0 "t1_base1_N", create_info=0x7ff9286b3690, table_list=0x2cab838, alter_info=0x7ff9286b3f90, order_num=0, order=0x0, ignore=false) at sql_table.cc:7358 #6 0x0000000000642aa3 in mysql_execute_command (thd=0x2c56888) at sql_parse.cc:2717 #7 0x000000000064a299 in mysql_parse (thd=0x2c56888, inBuf=0x2cab708 "ALTER TABLE testdb_N . t1_base1_N ENGINE = MyISAM", length=49, ---Type to continue, or q to quit--- found_semicolon=0x7ff9286b4f10) at sql_parse.cc:6045 #8 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2c56888, packet=0x2c42c89 " ALTER TABLE testdb_N . t1_base1_N ENGINE = MyISAM ", packet_length=51) at sql_parse.cc:1128 #9 0x000000000064c2fd in do_command (thd=0x2c56888) at sql_parse.cc:798 #10 0x00000000006391c0 in handle_one_connection (arg=0x2c56888) at sql_connect.cc:1163 #11 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #12 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7ff928674950 (LWP 12229)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0xfb1e60, mp=0xfb1960, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x0000000000688003 in inline_mysql_cond_wait (that=0xfb1e60, mutex=0xfb1960) at ../include/mysql/psi/mysql_thread.h:784 #3 0x00000000006880b0 in wait_for_condition (thd=0x2c23508, mutex=0xfb1960, cond=0xfb1e60) at sql_base.cc:2203 #4 0x0000000000624fd2 in wait_for_locked_table_names (thd=0x2c23508, table_list=0x2bd1dc0) at lock.cc:1130 #5 0x000000000062544c in lock_table_names (thd=0x2c23508, table_list=0x2bd1dc0) at lock.cc:1171 #6 0x000000000081ca0b in mysql_create_or_drop_trigger (thd=0x2c23508, tables=0x2bd1dc0, create=true) at sql_trigger.cc:458 #7 0x0000000000648e9a in mysql_execute_command (thd=0x2c23508) at sql_parse.cc:4643 #8 0x000000000064a299 in mysql_parse (thd=0x2c23508, inBuf=0x2bd19f8 "CREATE TRIGGER testdb_N . tr1_2_N BEFORE DELETE ON t1_base1_N FOR EACH ROW BEGIN REPLACE INTO testdb_N . t1_merge2_N ( `col_int` , `pk` , `col_int_key` ) SELECT `col_int_key` , `col_int` , `pk` "..., length=329, found_semicolon=0x7ff928673f10) at sql_parse.cc:6045 #9 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2c23508, packet=0x2c01c29 "CREATE TRIGGER testdb_N . tr1_2_N BEFORE DELETE ON t1_base1_N FOR EACH ROW BEGIN REPLACE INTO testdb_N . t1_merge2_N ( `col_int` , `pk` , `col_int_key` ) SELECT `col_int_key` , `col_int` , `pk` "..., packet_length=329) at sql_parse.cc:1128 #10 0x000000000064c2fd in do_command (thd=0x2c23508) at sql_parse.cc:798 #11 0x00000000006391c0 in handle_one_connection (arg=0x2c23508) at sql_connect.cc:1163 #12 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #13 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7ff92883b950 (LWP 12230)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0xfb1e60, mp=0xfb1960, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x0000000000688003 in inline_mysql_cond_wait (that=0xfb1e60, mutex=0xfb1960) at ../include/mysql/psi/mysql_thread.h:784 #3 0x00000000006880b0 in wait_for_condition (thd=0x2d4b9c8, mutex=0xfb1960, cond=0xfb1e60) at sql_base.cc:2203 #4 0x0000000000696445 in open_table (thd=0x2d4b9c8, table_list=0x2d28c08, mem_root=0x7ff928838a30, refresh=0x7ff928838aaf, flags=0) at sql_base.cc:2870 #5 0x0000000000697676 in open_tables (thd=0x2d4b9c8, start=0x7ff928838b10, counter=0x7ff928838b44, flags=0) at sql_base.cc:4625 #6 0x0000000000697f2e in open_and_lock_tables_derived (thd=0x2d4b9c8, tables=0x2d28c08, derived=true) at sql_base.cc:5031 #7 0x000000000064d17d in open_and_lock_tables (thd=0x2d4b9c8, tables=0x2d28c08) at mysql_priv.h:1564 #8 0x000000000079f152 in mysql_admin_table (thd=0x2d4b9c8, tables=0x2d28c08, check_opt=0x2d4dc30, operator_name=0xb43915 "optimize", lock_type=TL_WRITE, open_for_modify=true, no_warnings_for_error=false, extra_open_options=0, prepare_func=0, operator_func=0x773570 , view_operator_func=0) at sql_table.cc:4565 #9 0x00000000007a0f6a in mysql_optimize_table (thd=0x2d4b9c8, tables=0x2d28c08, check_opt=0x2d4dc30) at sql_table.cc:5017 #10 0x0000000000643471 in mysql_execute_command (thd=0x2d4b9c8) at sql_parse.cc:2919 #11 0x000000000064a299 in mysql_parse (thd=0x2d4b9c8, inBuf=0x2d28ae8 "OPTIMIZE LOCAL TABLE testdb_N . t1_base1_N", length=42, found_semicolon=0x7ff92883af10) at sql_parse.cc:6045 #12 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2d4b9c8, packet=0x2e7b2b9 "", packet_length=43) at sql_parse.cc:1128 ---Type to continue, or q to quit--- #13 0x000000000064c2fd in do_command (thd=0x2d4b9c8) at sql_parse.cc:798 #14 0x00000000006391c0 in handle_one_connection (arg=0x2d4b9c8) at sql_connect.cc:1163 #15 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #16 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7ff9286f6950 (LWP 12231)): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c3a2e in safe_cond_wait (cond=0xfb1e60, mp=0xfb1960, file=0xb1b088 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x0000000000688003 in inline_mysql_cond_wait (that=0xfb1e60, mutex=0xfb1960) at ../include/mysql/psi/mysql_thread.h:784 #3 0x00000000006880b0 in wait_for_condition (thd=0x2cbc718, mutex=0xfb1960, cond=0xfb1e60) at sql_base.cc:2203 #4 0x0000000000696445 in open_table (thd=0x2cbc718, table_list=0x2c60d48, mem_root=0x7ff9286f3d70, refresh=0x7ff9286f3def, flags=0) at sql_base.cc:2870 #5 0x0000000000697676 in open_tables (thd=0x2cbc718, start=0x7ff9286f3e50, counter=0x7ff9286f3e84, flags=0) at sql_base.cc:4625 #6 0x0000000000697f2e in open_and_lock_tables_derived (thd=0x2cbc718, tables=0x2be9840, derived=true) at sql_base.cc:5031 #7 0x000000000064d17d in open_and_lock_tables (thd=0x2cbc718, tables=0x2be9840) at mysql_priv.h:1564 #8 0x000000000063f4e5 in execute_sqlcom_select (thd=0x2cbc718, all_tables=0x2be9840) at sql_parse.cc:4994 #9 0x0000000000641276 in mysql_execute_command (thd=0x2cbc718) at sql_parse.cc:2123 #10 0x000000000064a299 in mysql_parse (thd=0x2cbc718, inBuf=0x2be7d18 "SELECT HIGH_PRIORITY `col_int_key` , `col_int` , `pk` FROM ( SELECT `col_int_key` , `col_int` , `pk` FROM testdb_S . t1_base1_N ) A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_N . t1_base1_N AS B "..., length=249, found_semicolon=0x7ff9286f5f10) at sql_parse.cc:6045 #11 0x000000000064aefb in dispatch_command (command=COM_QUERY, thd=0x2cbc718, packet=0x2e6a049 "SELECT HIGH_PRIORITY `col_int_key` , `col_int` , `pk` FROM ( SELECT `col_int_key` , `col_int` , `pk` FROM testdb_S . t1_base1_N ) A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_N . t1_base1_N AS B "..., packet_length=251) at sql_parse.cc:1128 #12 0x000000000064c2fd in do_command (thd=0x2cbc718) at sql_parse.cc:798 #13 0x00000000006391c0 in handle_one_connection (arg=0x2cbc718) at sql_connect.cc:1163 #14 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #15 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7ff939f806f0 (LWP 11142)): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x00000000006300b3 in handle_connections_sockets () at mysqld.cc:5098 #2 0x000000000063399b in main (argc=44, argv=0x7fff41f94468) at mysqld.cc:4587