Thread 54 (process 17101): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b1893 in safe_cond_timedwait (cond=0x1b98980, mp=0x1b988c0, abstime=0x7f43b9e99980, file=0x151d4df "mdl.cc", line=942) at thr_mutex.c:477 #2 0x0000000000ce1b36 in MDL_context::acquire_exclusive_locks (this=0x4725450, mdl_requests=0x7f43b9e99a40) at mdl.cc:942 #3 0x0000000000ce21e5 in MDL_context::acquire_exclusive_lock (this=0x4725450, mdl_request=0x4768580) at mdl.cc:822 #4 0x00000000008d3f34 in open_table_get_mdl_lock (thd=0x4725378, table_list=0x4768228, mdl_request=0x4768580, ot_ctx=0x7f43b9e9a190, flags=32) at sql_base.cc:2343 #5 0x00000000008de51d in open_table (thd=0x4725378, table_list=0x4768228, mem_root=0x7f43b9e9a120, ot_ctx=0x7f43b9e9a190, flags=32) at sql_base.cc:2618 #6 0x00000000008e1018 in open_and_process_table (thd=0x4725378, lex=0x4726c48, tables=0x4768228, counter=0x7f43b9e9a260, flags=32, prelocking_strategy=0x7f43b9e9a2a0, has_prelocking_list=false, ot_ctx=0x7f43b9e9a190, new_frm_mem=0x7f43b9e9a120) at sql_base.cc:3940 #7 0x00000000008e1f60 in open_tables (thd=0x4725378, start=0x7f43b9e9a220, counter=0x7f43b9e9a260, flags=32, prelocking_strategy=0x7f43b9e9a2a0) at sql_base.cc:4178 #8 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4725378, tables=0x4768228, derived=true, flags=32, prelocking_strategy=0x7f43b9e9a2a0) at sql_base.cc:4763 #9 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4725378, tables=0x4768228, derived=true, flags=32) at ../mysql_priv.h:1518 #10 0x0000000000810435 in mysql_execute_command (thd=0x4725378) at sql_parse.cc:2680 #11 0x000000000082105c in mysql_parse (thd=0x4725378, inBuf=0x4768030 "CREATE TABLE IF NOT EXISTS testdb_N . t1_base1_N AS SELECT `int` , `int_key` , `pk` FROM testdb_N . t1_view1_N A WHERE `pk` BETWEEN 9 AND 9 + 1", length=149, found_semicolon=0x7f43b9e9bef0) at sql_parse.cc:5979 #12 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4725378, packet=0x47581d9 "CREATE TABLE IF NOT EXISTS testdb_N . t1_base1_N AS SELECT `int` , `int_key` , `pk` FROM testdb_N . t1_view1_N A WHERE `pk` BETWEEN 9 AND 9 + 1", packet_length=149) at sql_parse.cc:1076 #13 0x0000000000825b15 in do_command (thd=0x4725378) at sql_parse.cc:758 #14 0x00000000007fab46 in handle_one_connection (arg=0x4725378) 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 53 (process 17090): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x0000000000e95b2d in os_thread_sleep (tm=1000000) at os/os0thread.c:268 #2 0x0000000000eedaf9 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 52 (process 17117): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x48ffa00, mdl_requests=0x7f43b9c91e50) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9c91e50, thd=0x48ff928, table=0x48fb410) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x48ff928, start=0x7f43b9c91ee0, counter=0x7f43b9c91f20, flags=0, prelocking_strategy=0x7f43b9c91f60) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x48ff928, tables=0x48fb410, derived=true, flags=0, prelocking_strategy=0x7f43b9c91f60) at sql_base.cc:4763 ---Type to continue, or q to quit--- #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x48ff928, tables=0x48fb410, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x48ff928, tables=0x48fb410) at ../../sql/mysql_priv.h:1528 #8 0x0000000000996a6e in mysql_insert (thd=0x48ff928, table_list=0x48fb410, fields=@0x4901e28, values_list=@0x4901e70, update_fields=@0x4901e58, update_values=@0x4901e40, duplic=DUP_REPLACE, ignore=false) at sql_insert.cc:638 #9 0x0000000000814012 in mysql_execute_command (thd=0x48ff928) at sql_parse.cc:3267 #10 0x000000000082105c in mysql_parse (thd=0x48ff928, inBuf=0x48fb2d0 "REPLACE testdb_S . t1_base1_S ( `int_key` ) VALUES ( 7 )", length=59, found_semicolon=0x7f43b9c93ef0) at sql_parse.cc:5979 #11 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x48ff928, packet=0x4910759 "REPLACE testdb_S . t1_base1_S ( `int_key` ) VALUES ( 7 )", packet_length=59) at sql_parse.cc:1076 #12 0x0000000000825b15 in do_command (thd=0x48ff928) at sql_parse.cc:758 #13 0x00000000007fab46 in handle_one_connection (arg=0x48ff928) 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 51 (process 17125): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x49920e0, mdl_requests=0x7f43b9b8ddd0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9b8ddd0, thd=0x4992008, table=0x4966ac0) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4992008, start=0x7f43b9b8df80, counter=0x7f43b9b8e238, flags=0, prelocking_strategy=0x7f43b9b8de70) at sql_base.cc:4206 #5 0x00000000005e2ce6 in open_tables (thd=0x4992008, tables=0x7f43b9b8df80, counter=0x7f43b9b8e238, flags=0) at mysql_priv.h:1506 #6 0x00000000009c6d3a in mysql_update (thd=0x4992008, table_list=0x4966ac0, fields=@0x4994110, values=@0x4994520, conds=0x4967378, order_num=0, order=0x0, limit=5, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f43b9b8f278, updated_return=0x7f43b9b8f270) at sql_update.cc:212 #7 0x00000000008133aa in mysql_execute_command (thd=0x4992008) at sql_parse.cc:3142 #8 0x000000000082105c in mysql_parse (thd=0x4992008, inBuf=0x4966970 "UPDATE testdb_S . t1_base1_S SET `pk` = 6 WHERE `pk` > 1 LIMIT 5", length=67, found_semicolon=0x7f43b9b8fef0) at sql_parse.cc:5979 #9 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4992008, packet=0x49871f9 "UPDATE testdb_S . t1_base1_S SET `pk` = 6 WHERE `pk` > 1 LIMIT 5", packet_length=67) at sql_parse.cc:1076 #10 0x0000000000825b15 in do_command (thd=0x4992008) at sql_parse.cc:758 #11 0x00000000007fab46 in handle_one_connection (arg=0x4992008) 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 50 (process 17131): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b1893 in safe_cond_timedwait (cond=0x1b98980, mp=0x1b988c0, abstime=0x7f43b9acb110, file=0x151d4df "mdl.cc", line=1070) at thr_mutex.c:477 #2 0x0000000000ce0cb9 in MDL_ticket::upgrade_shared_lock_to_exclusive (this=0x7f43b40c3cb0) at mdl.cc:1070 #3 0x00000000008d8141 in wait_while_table_is_used (thd=0x49fae38, table=0x7f43b419aa78, function=HA_EXTRA_FORCE_REOPEN) at sql_base.cc:2135 #4 0x0000000000c7928e in mysql_create_or_drop_trigger (thd=0x49fae38, tables=0x4a15ae0, create=true) at sql_trigger.cc:474 #5 0x000000000081f26d in mysql_execute_command (thd=0x49fae38) at sql_parse.cc:4706 #6 0x000000000082105c in mysql_parse (thd=0x49fae38, inBuf=0x4a157c0 "CREATE TRIGGER testdb_N . tr1_1_N BEFORE DELETE ON t1_base1_N FOR EACH ROW BEGIN INSERT INTO testdb_S . t1_merge1_S ( `pk` , `int_key` , `pk` ) SELECT `pk` , `int_key` , `pk` FROM testdb_S . t1_te"..., length=254, found_semicolon=0x7f43b9accef0) at sql_parse.cc:5979 ---Type to continue, or q to quit--- #7 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x49fae38, packet=0x4a059a9 "CREATE TRIGGER testdb_N . tr1_1_N BEFORE DELETE ON t1_base1_N FOR EACH ROW BEGIN INSERT INTO testdb_S . t1_merge1_S ( `pk` , `int_key` , `pk` ) SELECT `pk` , `int_key` , `pk` FROM testdb_S . t1_te"..., packet_length=254) at sql_parse.cc:1076 #8 0x0000000000825b15 in do_command (thd=0x49fae38) at sql_parse.cc:758 #9 0x00000000007fab46 in handle_one_connection (arg=0x49fae38) 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 49 (process 17137): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b1893 in safe_cond_timedwait (cond=0x1b98980, mp=0x1b988c0, abstime=0x7f43b9a06fa0, file=0x151d4df "mdl.cc", line=942) at thr_mutex.c:477 #2 0x0000000000ce1b36 in MDL_context::acquire_exclusive_locks (this=0x4a67b00, mdl_requests=0x7f43b9a07060) at mdl.cc:942 #3 0x0000000000ce21e5 in MDL_context::acquire_exclusive_lock (this=0x4a67b00, mdl_request=0x4aa6fd0) at mdl.cc:822 #4 0x00000000008d3f34 in open_table_get_mdl_lock (thd=0x4a67a28, table_list=0x4aa6c78, mdl_request=0x4aa6fd0, ot_ctx=0x7f43b9a077b0, flags=0) at sql_base.cc:2343 #5 0x00000000008de51d in open_table (thd=0x4a67a28, table_list=0x4aa6c78, mem_root=0x7f43b9a07740, ot_ctx=0x7f43b9a077b0, flags=0) at sql_base.cc:2618 #6 0x00000000008e1018 in open_and_process_table (thd=0x4a67a28, lex=0x4a692f8, tables=0x4aa6c78, counter=0x7f43b9a082a4, flags=0, prelocking_strategy=0x7f43b9a07850, has_prelocking_list=false, ot_ctx=0x7f43b9a077b0, new_frm_mem=0x7f43b9a07740) at sql_base.cc:3940 #7 0x00000000008e1f60 in open_tables (thd=0x4a67a28, start=0x4a69300, counter=0x7f43b9a082a4, flags=0, prelocking_strategy=0x7f43b9a07850) at sql_base.cc:4178 #8 0x00000000005e2ce6 in open_tables (thd=0x4a67a28, tables=0x4a69300, counter=0x7f43b9a082a4, flags=0) at mysql_priv.h:1506 #9 0x0000000000b44639 in mysql_create_like_table (thd=0x4a67a28, table=0x4aa6c78, src_table=0x4aa7270, create_info=0x7f43b9a085e0) at sql_table.cc:5161 #10 0x0000000000810a8c in mysql_execute_command (thd=0x4a67a28) at sql_parse.cc:2754 #11 0x000000000082105c in mysql_parse (thd=0x4a67a28, inBuf=0x4aa6b10 "CREATE TABLE IF NOT EXISTS testdb_N . t1_base2_N LIKE test.table0_int_autoinc", length=78, found_semicolon=0x7f43b9a09ef0) at sql_parse.cc:5979 #12 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4a67a28, packet=0x4a72599 "CREATE TABLE IF NOT EXISTS testdb_N . t1_base2_N LIKE test.table0_int_autoinc ", packet_length=79) at sql_parse.cc:1076 #13 0x0000000000825b15 in do_command (thd=0x4a67a28) at sql_parse.cc:758 #14 0x00000000007fab46 in handle_one_connection (arg=0x4a67a28) 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 48 (process 17066): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x43964b0, mp=0x4396400, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4396400, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=12, message1=0x7f43bfb2d0b8, message2=0x7f43bfb2d0b0, type=0x7f43bfb2d0a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=12) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3ce0) 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 (process 17115): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 ---Type to continue, or q to quit--- #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x48e38f0, mdl_requests=0x7f43b9cd31e0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9cd31e0, thd=0x48e3818, table=0x48f93b0) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x48e3818, start=0x7f43b9cd3270, counter=0x7f43b9cd32b0, flags=32, prelocking_strategy=0x7f43b9cd4240) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x48e3818, tables=0x48f93b0, derived=false, flags=32, prelocking_strategy=0x7f43b9cd4240) at sql_base.cc:4763 #6 0x0000000000816a03 in mysql_execute_command (thd=0x48e3818) at sql_parse.cc:3658 #7 0x000000000082105c in mysql_parse (thd=0x48e3818, inBuf=0x48f9280 "LOCK TABLES testdb_N . t1_base1_N AS z WRITE", length=46, found_semicolon=0x7f43b9cd4ef0) at sql_parse.cc:5979 #8 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x48e3818, packet=0x48f1369 "LOCK TABLES testdb_N . t1_base1_N AS z WRITE", packet_length=46) at sql_parse.cc:1076 #9 0x0000000000825b15 in do_command (thd=0x48e3818) at sql_parse.cc:758 #10 0x00000000007fab46 in handle_one_connection (arg=0x48e3818) 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 46 (process 17070): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4396930, mp=0x4396880, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4396880, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=16, message1=0x7f43bd3290b8, message2=0x7f43bd3290b0, type=0x7f43bd3290a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=16) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3d00) 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 (process 17133): #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 0x00000000011b024e in safe_mutex_lock (mp=0x1ab6b60, my_flags=0, file=0x14eb1ad "sql_db.cc", line=894) at thr_mutex.c:225 #4 0x0000000000b201f6 in mysql_rm_db (thd=0x4a470c8, db=0x4a41208 "testdb_N", if_exists=true, silent=false) at sql_db.cc:894 #5 0x000000000081778a in mysql_execute_command (thd=0x4a470c8) at sql_parse.cc:3761 #6 0x000000000082105c in mysql_parse (thd=0x4a470c8, inBuf=0x4a41150 "DROP DATABASE IF EXISTS testdb_N", length=32, found_semicolon=0x7f43b9a8bef0) at sql_parse.cc:5979 #7 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4a470c8, packet=0x4a51c39 "DROP DATABASE IF EXISTS testdb_N", packet_length=32) at sql_parse.cc:1076 #8 0x0000000000825b15 in do_command (thd=0x4a470c8) at sql_parse.cc:758 #9 0x00000000007fab46 in handle_one_connection (arg=0x4a470c8) at sql_connect.cc:1164 #10 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #11 0x000000315a4e627d in clone () from /lib64/libc.so.6 ---Type to continue, or q to quit--- Thread 44 (process 17121): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b1893 in safe_cond_timedwait (cond=0x1b98980, mp=0x1b988c0, abstime=0x7f43b9c0f4f0, file=0x151d4df "mdl.cc", line=942) at thr_mutex.c:477 #2 0x0000000000ce1b36 in MDL_context::acquire_exclusive_locks (this=0x4941cc0, mdl_requests=0x7f43b9c0f5b0) at mdl.cc:942 #3 0x00000000007ca337 in lock_table_names (thd=0x4941be8, table_list=0x4960ba0) at lock.cc:976 #4 0x0000000000b4d008 in mysql_rm_table_part2 (thd=0x4941be8, tables=0x4960ba0, if_exists=true, drop_temporary=false, drop_view=true, dont_log_query=true) at sql_table.cc:1901 #5 0x0000000000b1f97b in mysql_rm_known_files (thd=0x4941be8, dirp=0x4cc22d8, db=0x4960b90 "testdb_N", org_path=0x7f43b9c0fef0 "./testdb_N/", level=0, dropped_tables=0x7f43b9c10238) at sql_db.cc:1177 #6 0x0000000000b204f8 in mysql_rm_db (thd=0x4941be8, db=0x4960b90 "testdb_N", if_exists=true, silent=false) at sql_db.cc:938 #7 0x000000000081778a in mysql_execute_command (thd=0x4941be8) at sql_parse.cc:3761 #8 0x000000000082105c in mysql_parse (thd=0x4941be8, inBuf=0x4960ae0 "DROP SCHEMA IF EXISTS testdb_N", length=30, found_semicolon=0x7f43b9c11ef0) at sql_parse.cc:5979 #9 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4941be8, packet=0x49519e9 "DROP SCHEMA IF EXISTS testdb_N", packet_length=30) at sql_parse.cc:1076 #10 0x0000000000825b15 in do_command (thd=0x4941be8) at sql_parse.cc:758 #11 0x00000000007fab46 in handle_one_connection (arg=0x4941be8) 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 43 (process 17054): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4395730, mp=0x4395680, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4395680, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=0, message1=0x7f43c820a0b8, message2=0x7f43c820a0b0, type=0x7f43c820a0a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3c80) 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 (process 17145): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4b4fc90, mdl_requests=0x7f43b9904160) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9904160, thd=0x4b4fbb8, table=0x4aca800) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4b4fbb8, start=0x7f43b99041f0, counter=0x7f43b9904230, flags=0, prelocking_strategy=0x7f43b9904270) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4b4fbb8, tables=0x4aca800, derived=true, flags=0, prelocking_strategy=0x7f43b9904270) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4b4fbb8, tables=0x4aca800, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x4b4fbb8, tables=0x4aca800) at ../../sql/mysql_priv.h:1528 #8 0x000000000080dbb6 in mysql_execute_command (thd=0x4b4fbb8) at sql_parse.cc:2175 #9 0x000000000082105c in mysql_parse (thd=0x4b4fbb8, inBuf=0x4ac9b70 "DO ( SELECT COUNT(*) FROM testdb_S . t1_base1_S WHERE `pk` BETWEEN 6 AND 6 + 20 )", ---Type to continue, or q to quit--- length=82, found_semicolon=0x7f43b9905ef0) at sql_parse.cc:5979 #10 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4b4fbb8, packet=0x4b260c9 "DO ( SELECT COUNT(*) FROM testdb_S . t1_base1_S WHERE `pk` BETWEEN 6 AND 6 + 20 )", packet_length=82) at sql_parse.cc:1076 #11 0x0000000000825b15 in do_command (thd=0x4b4fbb8) at sql_parse.cc:758 #12 0x00000000007fab46 in handle_one_connection (arg=0x4b4fbb8) 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 41 (process 17129): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x49f0aa0, mdl_requests=0x7f43b9b0bcc0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9b0bcc0, thd=0x49f09c8, table=0x49e8c30) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x49f09c8, start=0x7f43b9b0bd50, counter=0x7f43b9b0bd90, flags=0, prelocking_strategy=0x7f43b9b0bdd0) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x49f09c8, tables=0x49e8c30, derived=true, flags=0, prelocking_strategy=0x7f43b9b0bdd0) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x49f09c8, tables=0x49e8c30, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x49f09c8, tables=0x49e8c30) at ../../sql/mysql_priv.h:1528 #8 0x00000000008098a4 in execute_sqlcom_select (thd=0x49f09c8, all_tables=0x49e8c30) at sql_parse.cc:4926 #9 0x000000000080d9fa in mysql_execute_command (thd=0x49f09c8) at sql_parse.cc:2156 #10 0x000000000082105c in mysql_parse (thd=0x49f09c8, inBuf=0x49e86d0 "SELECT `int` , `pk` , `int_key` FROM testdb_S . t1_base1_S AS A NATURAL JOIN testdb_S . t1_part1_N B WHERE `pk` BETWEEN 0 AND 0 + 1 INTO OUTFILE '/tmp/gentest17128.tmp'", length=174, found_semicolon=0x7f43b9b0def0) at sql_parse.cc:5979 #11 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x49f09c8, packet=0x49dc8f9 "SELECT `int` , `pk` , `int_key` FROM testdb_S . t1_base1_S AS A NATURAL JOIN testdb_S . t1_part1_N B WHERE `pk` BETWEEN 0 AND 0 + 1 INTO OUTFILE '/tmp/gentest17128.tmp' ", packet_length=175) at sql_parse.cc:1076 #12 0x0000000000825b15 in do_command (thd=0x49f09c8) at sql_parse.cc:758 #13 0x00000000007fab46 in handle_one_connection (arg=0x49f09c8) 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 40 (process 17111): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x487e780, mdl_requests=0x7f43b9d54e50) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9d54e50, thd=0x487e6a8, table=0x4898450) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x487e6a8, start=0x7f43b9d54ee0, counter=0x7f43b9d54f20, flags=0, prelocking_strategy=0x7f43b9d54f60) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x487e6a8, tables=0x4898450, derived=true, flags=0, prelocking_strategy=0x7f43b9d54f60) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x487e6a8, tables=0x4898450, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x487e6a8, tables=0x4898450) at ../../sql/mysql_priv.h:1528 ---Type to continue, or q to quit--- #8 0x0000000000996a6e in mysql_insert (thd=0x487e6a8, table_list=0x4898450, fields=@0x4880ba8, values_list=@0x4880bf0, update_fields=@0x4880bd8, update_values=@0x4880bc0, duplic=DUP_REPLACE, ignore=false) at sql_insert.cc:638 #9 0x0000000000814012 in mysql_execute_command (thd=0x487e6a8) at sql_parse.cc:3267 #10 0x000000000082105c in mysql_parse (thd=0x487e6a8, inBuf=0x4898310 "REPLACE testdb_S . t1_base1_S ( `int_key` ) VALUES ( 0 )", length=59, found_semicolon=0x7f43b9d56ef0) at sql_parse.cc:5979 #11 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x487e6a8, packet=0x4889219 "REPLACE testdb_S . t1_base1_S ( `int_key` ) VALUES ( 0 )", packet_length=59) at sql_parse.cc:1076 #12 0x0000000000825b15 in do_command (thd=0x487e6a8) at sql_parse.cc:758 #13 0x00000000007fab46 in handle_one_connection (arg=0x487e6a8) 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 39 (process 17141): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4a383a0, mdl_requests=0x7f43b9985cc0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9985cc0, thd=0x4a382c8, table=0x4acc978) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4a382c8, start=0x7f43b9985d50, counter=0x7f43b9985d90, flags=0, prelocking_strategy=0x7f43b9985dd0) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4a382c8, tables=0x4acc978, derived=true, flags=0, prelocking_strategy=0x7f43b9985dd0) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4a382c8, tables=0x4acc978, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x4a382c8, tables=0x4acc978) at ../../sql/mysql_priv.h:1528 #8 0x00000000008098a4 in execute_sqlcom_select (thd=0x4a382c8, all_tables=0x4acc978) at sql_parse.cc:4926 #9 0x000000000080d9fa in mysql_execute_command (thd=0x4a382c8) at sql_parse.cc:2156 #10 0x000000000082105c in mysql_parse (thd=0x4a382c8, inBuf=0x4acc4a0 "SELECT HIGH_PRIORITY `pk` , `int_key` , `pk` FROM testdb_N . t1_base2_N AS A WHERE `pk` BETWEEN 4 AND 4 + 1", length=110, found_semicolon=0x7f43b9987ef0) at sql_parse.cc:5979 #11 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4a382c8, packet=0x4af7fd9 "SELECT HIGH_PRIORITY `pk` , `int_key` , `pk` FROM testdb_N . t1_base2_N AS A WHERE `pk` BETWEEN 4 AND 4 + 1 ", packet_length=113) at sql_parse.cc:1076 #12 0x0000000000825b15 in do_command (thd=0x4a382c8) at sql_parse.cc:758 #13 0x00000000007fab46 in handle_one_connection (arg=0x4a382c8) 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 38 (process 17151): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4bd7d90, mdl_requests=0x7f43b98410e0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b98410e0, thd=0x4bd7cb8, table=0x4b764b8) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4bd7cb8, start=0x7f43b9841240, counter=0x7f43b984123c, flags=0, prelocking_strategy=0x7f43b9841180) at sql_base.cc:4206 ---Type to continue, or q to quit--- #5 0x00000000005e2ce6 in open_tables (thd=0x4bd7cb8, tables=0x7f43b9841240, counter=0x7f43b984123c, flags=0) at mysql_priv.h:1506 #6 0x00000000009c1be2 in mysql_multi_update_prepare (thd=0x4bd7cb8) at sql_update.cc:1000 #7 0x0000000000813601 in mysql_execute_command (thd=0x4bd7cb8) at sql_parse.cc:3164 #8 0x000000000082105c in mysql_parse (thd=0x4bd7cb8, inBuf=0x4b76310 "UPDATE testdb_N . t1_base2_N AS A NATURAL JOIN testdb_N . t1_base2_N B SET A. `int` = 1 , B. `int` = 7", length=106, found_semicolon=0x7f43b9842ef0) at sql_parse.cc:5979 #9 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4bd7cb8, packet=0x4b722b9 "UPDATE testdb_N . t1_base2_N AS A NATURAL JOIN testdb_N . t1_base2_N B SET A. `int` = 1 , B. `int` = 7", packet_length=106) at sql_parse.cc:1076 #10 0x0000000000825b15 in do_command (thd=0x4bd7cb8) at sql_parse.cc:758 #11 0x00000000007fab46 in handle_one_connection (arg=0x4bd7cb8) 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 37 (process 17139): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4a63b00, mdl_requests=0x7f43b99c6cc0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b99c6cc0, thd=0x4a63a28, table=0x4ae3a28) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4a63a28, start=0x7f43b99c6d50, counter=0x7f43b99c6d90, flags=0, prelocking_strategy=0x7f43b99c6dd0) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4a63a28, tables=0x7f43b41dcf90, derived=true, flags=0, prelocking_strategy=0x7f43b99c6dd0) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4a63a28, tables=0x7f43b41dcf90, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x4a63a28, tables=0x7f43b41dcf90) at ../../sql/mysql_priv.h:1528 #8 0x00000000008098a4 in execute_sqlcom_select (thd=0x4a63a28, all_tables=0x7f43b41dcf90) at sql_parse.cc:4926 #9 0x000000000080d9fa in mysql_execute_command (thd=0x4a63a28) at sql_parse.cc:2156 #10 0x000000000082105c in mysql_parse (thd=0x4a63a28, inBuf=0x4ae2460 "SELECT HIGH_PRIORITY `pk` , `int` , `int_key` FROM ( SELECT * FROM testdb_S . t1_base1_S ) AS A UNION SELECT * FROM testdb_N . t1_view1_N AS B WHERE `pk` BETWEEN 1 AND 1 + 1", length=178, found_semicolon=0x7f43b99c8ef0) at sql_parse.cc:5979 #11 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4a63a28, packet=0x4ab4909 "SELECT HIGH_PRIORITY `pk` , `int` , `int_key` FROM ( SELECT * FROM testdb_S . t1_base1_S ) AS A UNION SELECT * FROM testdb_N . t1_view1_N AS B WHERE `pk` BETWEEN 1 AND 1 + 1 ", packet_length=180) at sql_parse.cc:1076 #12 0x0000000000825b15 in do_command (thd=0x4a63a28) at sql_parse.cc:758 #13 0x00000000007fab46 in handle_one_connection (arg=0x4a63a28) 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 36 (process 17123): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4963c40, mdl_requests=0x7f43b9bcf160) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9bcf160, thd=0x4963b68, table=0x49a4210) at sql_base.cc:3700 ---Type to continue, or q to quit--- #4 0x00000000008e2019 in open_tables (thd=0x4963b68, start=0x7f43b9bcf1f0, counter=0x7f43b9bcf230, flags=0, prelocking_strategy=0x7f43b9bcf270) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4963b68, tables=0x49a4210, derived=true, flags=0, prelocking_strategy=0x7f43b9bcf270) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4963b68, tables=0x49a4210, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x4963b68, tables=0x49a4210) at ../../sql/mysql_priv.h:1528 #8 0x000000000080dbb6 in mysql_execute_command (thd=0x4963b68) at sql_parse.cc:2175 #9 0x000000000082105c in mysql_parse (thd=0x4963b68, inBuf=0x49a3580 "DO ( SELECT COUNT(*) FROM testdb_S . t1_base1_S WHERE `pk` BETWEEN 7 AND 7 + 20 )", length=82, found_semicolon=0x7f43b9bd0ef0) at sql_parse.cc:5979 #10 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4963b68, packet=0x497b439 "DO ( SELECT COUNT(*) FROM testdb_S . t1_base1_S WHERE `pk` BETWEEN 7 AND 7 + 20 )", packet_length=82) at sql_parse.cc:1076 #11 0x0000000000825b15 in do_command (thd=0x4963b68) at sql_parse.cc:758 #12 0x00000000007fab46 in handle_one_connection (arg=0x4963b68) 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 35 (process 17143): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4b02000, mdl_requests=0x7f43b9945050) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9945050, thd=0x4b01f28, table=0x4b52cd0) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4b01f28, start=0x7f43b99450e0, counter=0x7f43b9945120, flags=32, prelocking_strategy=0x7f43b9945160) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4b01f28, tables=0x4b52cd0, derived=false, flags=32, prelocking_strategy=0x7f43b9945160) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4b01f28, tables=0x4b52cd0, derived=false, flags=32) at ../mysql_priv.h:1518 #7 0x00000000008e3642 in open_n_lock_single_table (thd=0x4b01f28, table_l=0x4b52cd0, lock_type=TL_WRITE_ALLOW_READ, flags=32) at sql_base.cc:4594 #8 0x0000000000c791bd in mysql_create_or_drop_trigger (thd=0x4b01f28, tables=0x4b52cd0, create=true) at sql_trigger.cc:464 #9 0x000000000081f26d in mysql_execute_command (thd=0x4b01f28) at sql_parse.cc:4706 #10 0x000000000082105c in mysql_parse (thd=0x4b01f28, inBuf=0x4b52a10 "CREATE TRIGGER testdb_N . tr1_1_N BEFORE INSERT ON t1_base1_N FOR EACH ROW BEGIN DELETE A , B FROM testdb_N . t1_part2_N AS A NATURAL JOIN testdb_S . t1_merge2_S B WHERE `pk` BETWEEN 5 AND 5 + 1 "..., length=205, found_semicolon=0x7f43b9946ef0) at sql_parse.cc:5979 #11 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4b01f28, packet=0x4a912f9 "CREATE TRIGGER testdb_N . tr1_1_N BEFORE INSERT ON t1_base1_N FOR EACH ROW BEGIN DELETE A , B FROM testdb_N . t1_part2_N AS A NATURAL JOIN testdb_S . t1_merge2_S B WHERE `pk` BETWEEN 5 AND 5 + 1 "..., packet_length=205) at sql_parse.cc:1076 #12 0x0000000000825b15 in do_command (thd=0x4b01f28) at sql_parse.cc:758 #13 0x00000000007fab46 in handle_one_connection (arg=0x4b01f28) 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 34 (process 17105): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x47cb350, mdl_requests=0x7f43b9e16740) at mdl.cc:1261 ---Type to continue, or q to quit--- #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9e16740, thd=0x47cb278, table=0x7f43b40ad2a8) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x47cb278, start=0x7f43b9e167d0, counter=0x7f43b9e16810, flags=0, prelocking_strategy=0x7f43b9e16850) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x47cb278, tables=0x7f43b40adea0, derived=true, flags=0, prelocking_strategy=0x7f43b9e16850) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x47cb278, tables=0x7f43b40adea0, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x47cb278, tables=0x7f43b40adea0) at ../../sql/mysql_priv.h:1528 #8 0x00000000008098a4 in execute_sqlcom_select (thd=0x47cb278, all_tables=0x7f43b40adea0) at sql_parse.cc:4926 #9 0x000000000080d9fa in mysql_execute_command (thd=0x47cb278) at sql_parse.cc:2156 #10 0x00000000009a845d in Prepared_statement::execute (this=0x7f43b4044328, expanded_query=0x7f43b9e18280, open_cursor=false) at sql_prepare.cc:3765 #11 0x00000000009b1972 in Prepared_statement::execute_loop (this=0x7f43b4044328, expanded_query=0x7f43b9e18280, open_cursor=false, packet=0x0, packet_end=0x0) at sql_prepare.cc:3398 #12 0x00000000009b1f7e in mysql_sql_stmt_execute (thd=0x47cb278) at sql_prepare.cc:2571 #13 0x000000000080dab1 in mysql_execute_command (thd=0x47cb278) at sql_parse.cc:2166 #14 0x000000000082105c in mysql_parse (thd=0x47cb278, inBuf=0x47e8190 "EXECUTE st1", length=11, found_semicolon=0x7f43b9e19ef0) at sql_parse.cc:5979 #15 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x47cb278, packet=0x47d6009 " EXECUTE st1 ", packet_length=13) at sql_parse.cc:1076 #16 0x0000000000825b15 in do_command (thd=0x47cb278) at sql_parse.cc:758 #17 0x00000000007fab46 in handle_one_connection (arg=0x47cb278) at sql_connect.cc:1164 #18 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #19 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 33 (process 17135): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4a43260, mdl_requests=0x7f43b9a48100) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9a48100, thd=0x4a43188, table=0x4a3c590) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4a43188, start=0x7f43b9a48190, counter=0x7f43b9a481d0, flags=32, prelocking_strategy=0x7f43b9a491c0) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4a43188, tables=0x4a3c590, derived=false, flags=32, prelocking_strategy=0x7f43b9a491c0) at sql_base.cc:4763 #6 0x0000000000b47891 in mysql_alter_table (thd=0x4a43188, new_db=0x4a3c538 "testdb_N", new_name=0x0, create_info=0x7f43b9a495e0, table_list=0x4a3c590, alter_info=0x7f43b9a4a160, order_num=0, order=0x0, ignore=false) at sql_table.cc:6934 #7 0x0000000000811ad4 in mysql_execute_command (thd=0x4a43188) at sql_parse.cc:2914 #8 0x000000000082105c in mysql_parse (thd=0x4a43188, inBuf=0x4a3c460 "ALTER TABLE testdb_N . t1_base2_N ENGINE = MyISAM", length=49, found_semicolon=0x7f43b9a4aef0) at sql_parse.cc:5979 #9 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4a43188, packet=0x4a24609 " ALTER TABLE testdb_N . t1_base2_N ENGINE = MyISAM ", packet_length=51) at sql_parse.cc:1076 #10 0x0000000000825b15 in do_command (thd=0x4a43188) at sql_parse.cc:758 #11 0x00000000007fab46 in handle_one_connection (arg=0x4a43188) 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 32 (process 17107): ---Type to continue, or q to quit--- #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x48015d0, mdl_requests=0x7f43b9dd70e0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9dd70e0, thd=0x48014f8, table=0x47efc20) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x48014f8, start=0x7f43b9dd7240, counter=0x7f43b9dd723c, flags=0, prelocking_strategy=0x7f43b9dd7180) at sql_base.cc:4206 #5 0x00000000005e2ce6 in open_tables (thd=0x48014f8, tables=0x7f43b9dd7240, counter=0x7f43b9dd723c, flags=0) at mysql_priv.h:1506 #6 0x00000000009c1be2 in mysql_multi_update_prepare (thd=0x48014f8) at sql_update.cc:1000 #7 0x0000000000813601 in mysql_execute_command (thd=0x48014f8) at sql_parse.cc:3164 #8 0x000000000082105c in mysql_parse (thd=0x48014f8, inBuf=0x47efa60 "UPDATE LOW_PRIORITY testdb_S . t1_base1_S AS A NATURAL JOIN testdb_S . t1_base2_N B SET A. `pk` = 2 , B. `int` = 2", length=117, found_semicolon=0x7f43b9dd8ef0) at sql_parse.cc:5979 #9 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x48014f8, packet=0x4815cf9 "UPDATE LOW_PRIORITY testdb_S . t1_base1_S AS A NATURAL JOIN testdb_S . t1_base2_N B SET A. `pk` = 2 , B. `int` = 2", packet_length=117) at sql_parse.cc:1076 #10 0x0000000000825b15 in do_command (thd=0x48014f8) at sql_parse.cc:758 #11 0x00000000007fab46 in handle_one_connection (arg=0x48014f8) 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 31 (process 17109): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4856610, mdl_requests=0x7f43b9d95930) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9d95930, thd=0x4856538, table=0x48748d8) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4856538, start=0x7f43b9d959c0, counter=0x7f43b9d95a00, flags=0, prelocking_strategy=0x7f43b9d95a40) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4856538, tables=0x48748d8, derived=true, flags=0, prelocking_strategy=0x7f43b9d95a40) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4856538, tables=0x48748d8, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x4856538, tables=0x48748d8) at ../../sql/mysql_priv.h:1528 #8 0x00000000009cfcc2 in mysql_delete (thd=0x4856538, table_list=0x48748d8, conds=0x48754f8, order=0x48586f0, limit=18446744073709551615, options=0, reset_auto_increment=false) at sql_delete.cc:62 #9 0x0000000000814c91 in mysql_execute_command (thd=0x4856538) at sql_parse.cc:3382 #10 0x000000000082105c in mysql_parse (thd=0x4856538, inBuf=0x4874770 "DELETE FROM testdb_S . t1_base1_S WHERE `pk` + SLEEP( 0.5 * 0.28 * 1 ) = 2", length=77, found_semicolon=0x7f43b9d97ef0) at sql_parse.cc:5979 #11 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4856538, packet=0x4862969 "DELETE FROM testdb_S . t1_base1_S WHERE `pk` + SLEEP( 0.5 * 0.28 * 1 ) = 2", packet_length=77) at sql_parse.cc:1076 #12 0x0000000000825b15 in do_command (thd=0x4856538) at sql_parse.cc:758 #13 0x00000000007fab46 in handle_one_connection (arg=0x4856538) at sql_connect.cc:1164 #14 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #15 0x000000315a4e627d in clone () from /lib64/libc.so.6 ---Type to continue, or q to quit--- Thread 30 (process 17127): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b1893 in safe_cond_timedwait (cond=0x1b98980, mp=0x1b988c0, abstime=0x7f43b9b4cdb0, file=0x151d4df "mdl.cc", line=942) at thr_mutex.c:477 #2 0x0000000000ce1b36 in MDL_context::acquire_exclusive_locks (this=0x49af580, mdl_requests=0x7f43b9b4ce70) at mdl.cc:942 #3 0x00000000007ca337 in lock_table_names (thd=0x49af4a8, table_list=0x7f43b4193a80) at lock.cc:976 #4 0x0000000000b4d008 in mysql_rm_table_part2 (thd=0x49af4a8, tables=0x7f43b4193a80, if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=false) at sql_table.cc:1901 #5 0x0000000000b4f51f in mysql_rm_table (thd=0x49af4a8, tables=0x7f43b4193a80, if_exists=0 '\0', drop_temporary=0 '\0') at sql_table.cc:1793 #6 0x0000000000815653 in mysql_execute_command (thd=0x49af4a8) at sql_parse.cc:3467 #7 0x000000000082105c in mysql_parse (thd=0x49af4a8, inBuf=0x498c3a8 "DROP TABLE testdb_S . t1_base1_S /* Sequence end */", length=51, found_semicolon=0x7f43b9b4eef0) at sql_parse.cc:5979 #8 0x0000000000822f7f in dispatch_command (command=COM_QUERY, thd=0x49af4a8, packet=0x49cabe9 "", packet_length=315) at sql_parse.cc:1124 #9 0x0000000000825b15 in do_command (thd=0x49af4a8) at sql_parse.cc:758 #10 0x00000000007fab46 in handle_one_connection (arg=0x49af4a8) 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 29 (process 17057): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4395a90, mp=0x43959e0, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x43959e0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=3, message1=0x7f43c55360b8, message2=0x7f43c55360b0, type=0x7f43c55360a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3c98) 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 28 (process 17153): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4b98990, mdl_requests=0x7f43b97ffdd0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b97ffdd0, thd=0x4b988b8, table=0x4bbf6b0) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4b988b8, start=0x7f43b97fff80, counter=0x7f43b9800238, flags=0, prelocking_strategy=0x7f43b97ffe70) at sql_base.cc:4206 #5 0x00000000005e2ce6 in open_tables (thd=0x4b988b8, tables=0x7f43b97fff80, counter=0x7f43b9800238, flags=0) at mysql_priv.h:1506 #6 0x00000000009c6d3a in mysql_update (thd=0x4b988b8, table_list=0x4bbf6b0, fields=@0x4b9a9c0, values=@0x4b9add0, conds=0x4bc02e0, order_num=0, order=0x0, limit=1, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f43b9801278, updated_return=0x7f43b9801270) at sql_update.cc:212 #7 0x00000000008133aa in mysql_execute_command (thd=0x4b988b8) at sql_parse.cc:3142 #8 0x000000000082105c in mysql_parse (thd=0x4b988b8, inBuf=0x4bbf530 "UPDATE testdb_S . t1_base1_S SET `int_key` = 0 WHERE SLEEP( 0.5 * 0.81 * 1 ) = 0 LIMIT 1", length=91, found_semicolon=0x7f43b9801ef0) at sql_parse.cc:5979 #9 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4b988b8, packet=0x4851119 "UPDATE testdb_S . t1_base1_S SET `int_key` = 0 WHERE SLEEP( 0.5 * 0.81 * 1 ) = 0 LIMIT 1", packet_length=91) at sql_parse.cc:1076 ---Type to continue, or q to quit--- #10 0x0000000000825b15 in do_command (thd=0x4b988b8) at sql_parse.cc:758 #11 0x00000000007fab46 in handle_one_connection (arg=0x4b988b8) 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 (process 17089): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x0000000000e95b2d in os_thread_sleep (tm=1000000) at os/os0thread.c:268 #2 0x0000000000eecfa2 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 26 (process 17119): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b1893 in safe_cond_timedwait (cond=0x1b98980, mp=0x1b988c0, abstime=0x7f43b9c50db0, file=0x151d4df "mdl.cc", line=942) at thr_mutex.c:477 #2 0x0000000000ce1b36 in MDL_context::acquire_exclusive_locks (this=0x491c5f0, mdl_requests=0x7f43b9c50e70) at mdl.cc:942 #3 0x00000000007ca337 in lock_table_names (thd=0x491c518, table_list=0x7f43b40c0e88) at lock.cc:976 #4 0x0000000000b4d008 in mysql_rm_table_part2 (thd=0x491c518, tables=0x7f43b40c0e88, if_exists=false, drop_temporary=false, drop_view=false, dont_log_query=false) at sql_table.cc:1901 #5 0x0000000000b4f51f in mysql_rm_table (thd=0x491c518, tables=0x7f43b40c0e88, if_exists=0 '\0', drop_temporary=0 '\0') at sql_table.cc:1793 #6 0x0000000000815653 in mysql_execute_command (thd=0x491c518) at sql_parse.cc:3467 #7 0x000000000082105c in mysql_parse (thd=0x491c518, inBuf=0x4936276 "DROP TABLE testdb_S . t1_part2_S /* Sequence end */", length=51, found_semicolon=0x7f43b9c52ef0) at sql_parse.cc:5979 #8 0x0000000000822f7f in dispatch_command (command=COM_QUERY, thd=0x491c518, packet=0x492c319 "", packet_length=201) at sql_parse.cc:1124 #9 0x0000000000825b15 in do_command (thd=0x491c518) at sql_parse.cc:758 #10 0x00000000007fab46 in handle_one_connection (arg=0x491c518) 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 25 (process 17055): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4395850, mp=0x43957a0, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x43957a0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=1, message1=0x7f43c69380b8, message2=0x7f43c69380b0, type=0x7f43c69380a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3c88) 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 24 (process 17147): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4b3d510, mdl_requests=0x7f43b98c30e0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b98c30e0, thd=0x4b3d438, table=0x4b36090) ---Type to continue, or q to quit--- at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4b3d438, start=0x7f43b98c3240, counter=0x7f43b98c323c, flags=0, prelocking_strategy=0x7f43b98c3180) at sql_base.cc:4206 #5 0x00000000005e2ce6 in open_tables (thd=0x4b3d438, tables=0x7f43b98c3240, counter=0x7f43b98c323c, flags=0) at mysql_priv.h:1506 #6 0x00000000009c1be2 in mysql_multi_update_prepare (thd=0x4b3d438) at sql_update.cc:1000 #7 0x0000000000813601 in mysql_execute_command (thd=0x4b3d438) at sql_parse.cc:3164 #8 0x000000000082105c in mysql_parse (thd=0x4b3d438, inBuf=0x4b35ee0 "UPDATE testdb_S . t1_base1_S AS A NATURAL JOIN testdb_S . t1_view2_S B SET A. `pk` = 7 , B. `int_key` = 8", length=109, found_semicolon=0x7f43b98c4ef0) at sql_parse.cc:5979 #9 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4b3d438, packet=0x4b2dfc9 "UPDATE testdb_S . t1_base1_S AS A NATURAL JOIN testdb_S . t1_view2_S B SET A. `pk` = 7 , B. `int_key` = 8", packet_length=109) at sql_parse.cc:1076 #10 0x0000000000825b15 in do_command (thd=0x4b3d438) at sql_parse.cc:758 #11 0x00000000007fab46 in handle_one_connection (arg=0x4b3d438) 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 (process 17058): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4395bb0, mp=0x4395b00, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4395b00, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=4, message1=0x7f43c4b350b8, message2=0x7f43c4b350b0, type=0x7f43c4b350a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=4) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3ca0) 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 22 (process 17056): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4395970, mp=0x43958c0, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x43958c0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=2, message1=0x7f43c5f370b8, message2=0x7f43c5f370b0, type=0x7f43c5f370a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3c90) 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 21 (process 17157): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4bdf9c0, mdl_requests=0x7f43b977e050) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b977e050, thd=0x4bdf8e8, table=0x4c110b0) at sql_base.cc:3700 ---Type to continue, or q to quit--- #4 0x00000000008e2019 in open_tables (thd=0x4bdf8e8, start=0x7f43b977e0e0, counter=0x7f43b977e120, flags=32, prelocking_strategy=0x7f43b977e160) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4bdf8e8, tables=0x4c110b0, derived=false, flags=32, prelocking_strategy=0x7f43b977e160) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4bdf8e8, tables=0x4c110b0, derived=false, flags=32) at ../mysql_priv.h:1518 #7 0x00000000008e3642 in open_n_lock_single_table (thd=0x4bdf8e8, table_l=0x4c110b0, lock_type=TL_WRITE_ALLOW_READ, flags=32) at sql_base.cc:4594 #8 0x0000000000c791bd in mysql_create_or_drop_trigger (thd=0x4bdf8e8, tables=0x4c110b0, create=true) at sql_trigger.cc:464 #9 0x000000000081f26d in mysql_execute_command (thd=0x4bdf8e8) at sql_parse.cc:4706 #10 0x000000000082105c in mysql_parse (thd=0x4bdf8e8, inBuf=0x4c10d90 "CREATE TRIGGER testdb_N . tr1_1_N AFTER INSERT ON t1_base2_N FOR EACH ROW BEGIN INSERT testdb_S . t1_view2_N ( `pk` , `int` , `int_key` ) SELECT `int` , `int_key` , `pk` FROM testdb_S . t1_vie"..., length=254, found_semicolon=0x7f43b977fef0) at sql_parse.cc:5979 #11 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4bdf8e8, packet=0x4c08cf9 "CREATE TRIGGER testdb_N . tr1_1_N AFTER INSERT ON t1_base2_N FOR EACH ROW BEGIN INSERT testdb_S . t1_view2_N ( `pk` , `int` , `int_key` ) SELECT `int` , `int_key` , `pk` FROM testdb_S . t1_vie"..., packet_length=254) at sql_parse.cc:1076 #12 0x0000000000825b15 in do_command (thd=0x4bdf8e8) at sql_parse.cc:758 #13 0x00000000007fab46 in handle_one_connection (arg=0x4bdf8e8) 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 20 (process 17059): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4395cd0, mp=0x4395c20, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4395c20, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=5, message1=0x7f43c41340b8, message2=0x7f43c41340b0, type=0x7f43c41340a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=5) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3ca8) 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 19 (process 17149): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4b441c0, mdl_requests=0x7f43b9881cc0) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9881cc0, thd=0x4b440e8, table=0x4b81488) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4b440e8, start=0x7f43b9881d50, counter=0x7f43b9881d90, flags=0, prelocking_strategy=0x7f43b9881dd0) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4b440e8, tables=0x4b81488, derived=true, flags=0, prelocking_strategy=0x7f43b9881dd0) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4b440e8, tables=0x4b81488, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x4b440e8, tables=0x4b81488) at ../../sql/mysql_priv.h:1528 #8 0x00000000008098a4 in execute_sqlcom_select (thd=0x4b440e8, all_tables=0x4b81488) at sql_parse.cc:4926 #9 0x000000000080d9fa in mysql_execute_command (thd=0x4b440e8) at sql_parse.cc:2156 #10 0x000000000082105c in mysql_parse (thd=0x4b440e8, inBuf=0x4b81290 "SELECT 1 FROM testdb_S . t1_base1_S WHERE SLEEP( 0.5 * 0.55 * 1 ) = 0 LIMIT 1", ---Type to continue, or q to quit--- length=78, found_semicolon=0x7f43b9883ef0) at sql_parse.cc:5979 #11 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4b440e8, packet=0x4b5c7c9 "SELECT 1 FROM testdb_S . t1_base1_S WHERE SLEEP( 0.5 * 0.55 * 1 ) = 0 LIMIT 1", packet_length=78) at sql_parse.cc:1076 #12 0x0000000000825b15 in do_command (thd=0x4b440e8) at sql_parse.cc:758 #13 0x00000000007fab46 in handle_one_connection (arg=0x4b440e8) 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 18 (process 17064): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4396270, mp=0x43961c0, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x43961c0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=10, message1=0x7f43c0f2f0b8, message2=0x7f43c0f2f0b0, type=0x7f43c0f2f0a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=10) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3cd0) 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 17 (process 17092): #0 0x000000315b00ee7b in sigwait () from /lib64/libpthread.so.0 #1 0x00000000007e02bb 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 16 (process 17091): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x3b21f20, mp=0x3b21e70, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x3b21e70, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000eefe17 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 15 (process 17060): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4395df0, mp=0x4395d40, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4395d40, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=6, message1=0x7f43c37330b8, message2=0x7f43c37330b0, type=0x7f43c37330a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=6) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3cb0) 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 14 (process 17155): ---Type to continue, or q to quit--- #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4bdcbd0, mdl_requests=0x7f43b97bf160) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b97bf160, thd=0x4bdcaf8, table=0x4bdad48) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4bdcaf8, start=0x7f43b97bf1f0, counter=0x7f43b97bf230, flags=0, prelocking_strategy=0x7f43b97bf270) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4bdcaf8, tables=0x4bdad48, derived=true, flags=0, prelocking_strategy=0x7f43b97bf270) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4bdcaf8, tables=0x4bdad48, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x4bdcaf8, tables=0x4bdad48) at ../../sql/mysql_priv.h:1528 #8 0x000000000081431f in mysql_execute_command (thd=0x4bdcaf8) at sql_parse.cc:3299 #9 0x000000000082105c in mysql_parse (thd=0x4bdcaf8, inBuf=0x4bdaac0 "REPLACE INTO testdb_S . t1_base1_S ( `int` , `pk` , `int_key` ) SELECT `int_key` , `pk` , `int` FROM testdb_S . t1_base2_N A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_S . t1_base1_S AS B WHER"..., length=222, found_semicolon=0x7f43b97c0ef0) at sql_parse.cc:5979 #10 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4bdcaf8, packet=0x4be7669 "REPLACE INTO testdb_S . t1_base1_S ( `int` , `pk` , `int_key` ) SELECT `int_key` , `pk` , `int` FROM testdb_S . t1_base2_N A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_S . t1_base1_S AS B WHER"..., packet_length=222) at sql_parse.cc:1076 #11 0x0000000000825b15 in do_command (thd=0x4bdcaf8) at sql_parse.cc:758 #12 0x00000000007fab46 in handle_one_connection (arg=0x4bdcaf8) 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 (process 17113): #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 0x00000000011b024e in safe_mutex_lock (mp=0x1ab6b60, my_flags=0, file=0x14eb1ad "sql_db.cc", line=793) at thr_mutex.c:225 #4 0x0000000000b217d6 in mysql_alter_db (thd=0x48b45d8, db=0x48a2140 "testdb_N", create_info=0x7f43b9d145e0) at sql_db.cc:793 #5 0x0000000000818461 in mysql_execute_command (thd=0x48b45d8) at sql_parse.cc:3835 #6 0x000000000082105c in mysql_parse (thd=0x48b45d8, inBuf=0x48a2070 "ALTER DATABASE testdb_N CHARACTER SET utf8", length=44, found_semicolon=0x7f43b9d15ef0) at sql_parse.cc:5979 #7 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x48b45d8, packet=0x48df7d9 "ALTER DATABASE testdb_N CHARACTER SET utf8", packet_length=44) at sql_parse.cc:1076 #8 0x0000000000825b15 in do_command (thd=0x48b45d8) at sql_parse.cc:758 #9 0x00000000007fab46 in handle_one_connection (arg=0x48b45d8) 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 12 (process 17065): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4396390, mp=0x43962e0, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x43962e0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=11, message1=0x7f43c052e0b8, message2=0x7f43c052e0b0, type=0x7f43c052e0a8) at os/os0file.c:4252 ---Type to continue, or q to quit--- #4 0x0000000000e3f05d in fil_aio_wait (segment=11) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3cd8) 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 11 (process 17061): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4395f10, mp=0x4395e60, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4395e60, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=7, message1=0x7f43c2d320b8, message2=0x7f43c2d320b0, type=0x7f43c2d320a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=7) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3cb8) 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 10 (process 17067): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x43965d0, mp=0x4396520, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4396520, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=13, message1=0x7f43bf12c0b8, message2=0x7f43bf12c0b0, type=0x7f43bf12c0a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=13) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3ce8) 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 9 (process 17068): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x43966f0, mp=0x4396640, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4396640, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=14, message1=0x7f43be72b0b8, message2=0x7f43be72b0b0, type=0x7f43be72b0a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=14) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3cf0) 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 8 (process 17062): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4396030, mp=0x4395f80, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4395f80, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=8, message1=0x7f43c23310b8, message2=0x7f43c23310b0, type=0x7f43c23310a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=8) at fil/fil0fil.c:4246 ---Type to continue, or q to quit--- #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3cc0) 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 7 (process 17069): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4396810, mp=0x4396760, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x4396760, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=15, message1=0x7f43bdd2a0b8, message2=0x7f43bdd2a0b0, type=0x7f43bdd2a0a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=15) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3cf8) 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 6 (process 17071): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4396a50, mp=0x43969a0, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x43969a0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=17, message1=0x7f43bc9280b8, message2=0x7f43bc9280b0, type=0x7f43bc9280a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=17) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3d08) 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 5 (process 17063): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x4396150, mp=0x43960a0, file=0x154d772 "os/os0sync.c", line=422) at thr_mutex.c:423 #2 0x0000000000e94a86 in os_event_wait_low (event=0x43960a0, reset_sig_count=0) at os/os0sync.c:422 #3 0x0000000000e921f9 in os_aio_simulated_handle (global_segment=9, message1=0x7f43c19300b8, message2=0x7f43c19300b0, type=0x7f43c19300a8) at os/os0file.c:4252 #4 0x0000000000e3f05d in fil_aio_wait (segment=9) at fil/fil0fil.c:4246 #5 0x0000000000ef0cce in io_handler_thread (arg=0x1bf3cc8) 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 4 (process 17093): #0 0x000000315b00df5b in read () from /lib64/libpthread.so.0 #1 0x00000000012a5b95 in vio_read (vio=0x45f6fe8, buf=0x4719548 "\a", size=4) at viosocket.c:44 #2 0x00000000007bcb0c in my_real_read (net=0x46ce530, complen=0x7f43b9edcfd8) at net_serv.cc:833 #3 0x00000000007bdb5b in my_net_read (net=0x46ce530) at net_serv.cc:1023 #4 0x00000000008257dd in do_command (thd=0x46ce418) at sql_parse.cc:704 #5 0x00000000007fab46 in handle_one_connection (arg=0x46ce418) at sql_connect.cc:1164 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 ---Type to continue, or q to quit--- #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 3 (process 17159): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1b98980, mp=0x1b988c0, file=0x151d4df "mdl.cc", line=1261) at thr_mutex.c:423 #2 0x0000000000cdf215 in MDL_context::wait_for_locks (this=0x4c0ce10, mdl_requests=0x7f43b973d160) at mdl.cc:1261 #3 0x00000000008dca8c in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b973d160, thd=0x4c0cd38, table=0x4bd5680) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x4c0cd38, start=0x7f43b973d1f0, counter=0x7f43b973d230, flags=0, prelocking_strategy=0x7f43b973d270) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x4c0cd38, tables=0x4bd5680, derived=true, flags=0, prelocking_strategy=0x7f43b973d270) at sql_base.cc:4763 #6 0x0000000000827dfc in open_and_lock_tables_derived (thd=0x4c0cd38, tables=0x4bd5680, derived=true, flags=0) at ../mysql_priv.h:1518 #7 0x0000000000827e85 in open_and_lock_tables (thd=0x4c0cd38, tables=0x4bd5680) at ../../sql/mysql_priv.h:1528 #8 0x0000000000814fc2 in mysql_execute_command (thd=0x4c0cd38) at sql_parse.cc:3404 #9 0x000000000082105c in mysql_parse (thd=0x4c0cd38, inBuf=0x4bd4910 "DELETE A , B FROM testdb_S . t1_base1_S AS A NATURAL JOIN testdb_S . t1_base2_S B WHERE `pk` BETWEEN 5 AND 5 + 1", length=116, found_semicolon=0x7f43b973eef0) at sql_parse.cc:5979 #10 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x4c0cd38, packet=0x4c1eb89 "DELETE A , B FROM testdb_S . t1_base1_S AS A NATURAL JOIN testdb_S . t1_base2_S B WHERE `pk` BETWEEN 5 AND 5 + 1", packet_length=116) at sql_parse.cc:1076 #11 0x0000000000825b15 in do_command (thd=0x4c0cd38) at sql_parse.cc:758 #12 0x00000000007fab46 in handle_one_connection (arg=0x4c0cd38) 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 2 (process 17103): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000011b12bf in safe_cond_wait (cond=0x1ab78e0, mp=0x1ab6c00, file=0x14b01ac "sql_base.cc", line=8353) at thr_mutex.c:423 #2 0x00000000008c0776 in tdc_wait_for_old_versions (thd=0x476f0f8, mdl_requests=0x7f43b9e591e0) at sql_base.cc:8353 #3 0x00000000008dcac6 in Open_table_context::recover_from_failed_open_table_attempt (this=0x7f43b9e591e0, thd=0x476f0f8, table=0x47c32a0) at sql_base.cc:3700 #4 0x00000000008e2019 in open_tables (thd=0x476f0f8, start=0x7f43b9e59270, counter=0x7f43b9e592b0, flags=32, prelocking_strategy=0x7f43b9e5a240) at sql_base.cc:4206 #5 0x00000000008e2bda in open_and_lock_tables_derived (thd=0x476f0f8, tables=0x47c32a0, derived=false, flags=32, prelocking_strategy=0x7f43b9e5a240) at sql_base.cc:4763 #6 0x0000000000816a03 in mysql_execute_command (thd=0x476f0f8) at sql_parse.cc:3658 #7 0x000000000082105c in mysql_parse (thd=0x476f0f8, inBuf=0x47c3170 "LOCK TABLES testdb_N . t1_base1_N AS r READ", length=44, found_semicolon=0x7f43b9e5aef0) at sql_parse.cc:5979 #8 0x0000000000822b32 in dispatch_command (command=COM_QUERY, thd=0x476f0f8, packet=0x47b3359 "LOCK TABLES testdb_N . t1_base1_N AS r READ ", packet_length=45) at sql_parse.cc:1076 #9 0x0000000000825b15 in do_command (thd=0x476f0f8) at sql_parse.cc:758 #10 0x00000000007fab46 in handle_one_connection (arg=0x476f0f8) at sql_connect.cc:1164 #11 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #12 0x000000315a4e627d in clone () from /lib64/libc.so.6 ---Type to continue, or q to quit--- Thread 1 (process 17052): #0 0x000000315b00c216 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000001164132 in my_write_core (sig=11) at stacktrace.c:309 #2 0x00000000007e232b in handle_segfault (sig=11) at mysqld.cc:2765 #3 #4 0x000000315a4dea62 in select () from /lib64/libc.so.6 #5 0x00000000007e37d4 in handle_connections_sockets () at mysqld.cc:5362 #6 0x00000000007edc36 in main (argc=42, argv=0x7fffd021d878) at mysqld.cc:4855