Thread 26 (process 28893): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d388, mp=0x1b9d310, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d310, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=2, message1=0x7fba469110d0, message2=0x7fba469110c8, type=0x7fba469110c0) at os/os0file.c:4088 #4 0x0000000000918654 in fil_aio_wait (segment=2) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4050) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 25 (process 28899): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d808, mp=0x1b9d790, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d790, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=8, message1=0x7fba42d0b0d0, message2=0x7fba42d0b0c8, type=0x7fba42d0b0c0) at os/os0file.c:4088 #4 0x0000000000918654 in fil_aio_wait (segment=8) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4080) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 24 (process 28920): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x15a3798, mp=0x15a3720, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x15a3720, reset_sig_count=0) at os/os0sync.c:396 #3 0x00000000008c803c in srv_master_thread (arg=0x0) at srv/srv0srv.c:2725 #4 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #5 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 23 (process 28892): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d2c8, mp=0x1b9d250, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d250, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=1, message1=0x7fba473120d0, message2=0x7fba473120c8, type=0x7fba473120c0) at os/os0file.c:4088 #4 0x0000000000918654 in fil_aio_wait (segment=1) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4048) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 22 (process 28891): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d208, mp=0x1b9d190, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 ---Type to continue, or q to quit--- #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d190, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=0, message1=0x7fba50ebe0d0, message2=0x7fba50ebe0c8, type=0x7fba50ebe0c0) at os/os0file.c:4088 #4 0x0000000000918654 in fil_aio_wait (segment=0) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4040) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 21 (process 28919): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x00000000008935c4 in os_thread_sleep (tm=1000000) at os/os0thread.c:280 #2 0x00000000008c6cca in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2205 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 20 (process 28921): #0 0x000000315b00ee7b in sigwait () from /lib64/libpthread.so.0 #1 0x0000000000631d45 in signal_hand (arg=0x0) at mysqld.cc:2807 #2 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #3 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 19 (process 29831): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0xfc2340, mp=0xfc22c0, file=0xb61360 "mdl.cc", line=1304) at thr_mutex.c:237 #2 0x000000000083f2f3 in MDL_context::wait_for_locks (this=0x7fba38045b08, mdl_requests=0x7fba3f632e80) at mdl.cc:1304 #3 0x0000000000695155 in Open_table_context::recover_from_failed_open (this=0x7fba3f632e80, thd=0x7fba38045a38, mdl_request=0x23af3f8, table=0x23af0c8) at sql_base.cc:3786 #4 0x00000000006976bf in open_tables (thd=0x7fba38045a38, start=0x7fba3f632f00, counter=0x7fba3f632f40, flags=32, prelocking_strategy=0x7fba3f632f80) at sql_base.cc:4374 #5 0x0000000000697b68 in open_and_lock_tables_derived (thd=0x7fba38045a38, tables=0x23af0c8, derived=false, flags=32, prelocking_strategy=0x7fba3f632f80) at sql_base.cc:4950 #6 0x000000000064e876 in open_and_lock_tables_derived (thd=0x7fba38045a38, tables=0x23af0c8, derived=false, flags=32) at mysql_priv.h:1499 #7 0x0000000000697f03 in open_n_lock_single_table (thd=0x7fba38045a38, table_l=0x23af0c8, lock_type=TL_WRITE_ALLOW_READ, flags=32) at sql_base.cc:4775 #8 0x000000000081bdc8 in mysql_create_or_drop_trigger (thd=0x7fba38045a38, tables=0x23af0c8, create=true) at sql_trigger.cc:464 #9 0x000000000064ac64 in mysql_execute_command (thd=0x7fba38045a38) at sql_parse.cc:4330 #10 0x000000000064b846 in mysql_parse (thd=0x7fba38045a38, inBuf=0x23aeec8 "CREATE TRIGGER testdb_N . tr1_1_N AFTER DELETE ON t1_base2_N FOR EACH ROW BEGIN CALL testdb_S . p1_2_N ; END", length=110, found_semicolon=0x7fba3f634f10) at sql_parse.cc:5587 #11 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba38045a38, packet=0x7fba380a2079 "CREATE TRIGGER testdb_N . tr1_1_N AFTER DELETE ON t1_base2_N FOR EACH ROW BEGIN CALL testdb_S . p1_2_N ; END", packet_length=110) at sql_parse.cc:1011 #12 0x000000000064d967 in do_command (thd=0x7fba38045a38) at sql_parse.cc:695 #13 0x000000000063c275 in handle_one_connection (arg=0x7fba38045a38) at sql_connect.cc:1163 #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 18 (process 28898): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d748, mp=0x1b9d6d0, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d6d0, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=7, message1=0x7fba4370c0d0, message2=0x7fba4370c0c8, type=0x7fba4370c0c0) at os/os0file.c:4088 #4 0x0000000000918654 in fil_aio_wait (segment=7) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4078) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 17 (process 28894): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d448, mp=0x1b9d3d0, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d3d0, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=3, message1=0x7fba45f100d0, message2=0x7fba45f100c8, type=0x7fba45f100c0) at os/os0file.c:4088 #4 0x0000000000918654 in fil_aio_wait (segment=3) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4058) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 16 (process 29889): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0xfc2340, mp=0xfc22c0, file=0xb61360 "mdl.cc", line=1304) at thr_mutex.c:237 #2 0x000000000083f2f3 in MDL_context::wait_for_locks (this=0x7fba3808df98, mdl_requests=0x7fba3f7b8f10) at mdl.cc:1304 #3 0x0000000000695155 in Open_table_context::recover_from_failed_open (this=0x7fba3f7b8f10, thd=0x7fba3808dec8, mdl_request=0x22d8970, table=0x22d8640) at sql_base.cc:3786 #4 0x00000000006976bf in open_tables (thd=0x7fba3808dec8, start=0x7fba3f7b9048, counter=0x7fba3f7b9044, flags=0, prelocking_strategy=0x7fba3f7b8f90) at sql_base.cc:4374 #5 0x000000000054855c in open_tables (thd=0x7fba3808dec8, tables=0x7fba3f7b9048, counter=0x7fba3f7b9044, flags=0) at mysql_priv.h:1487 #6 0x00000000006f4b4f in mysql_multi_update_prepare (thd=0x7fba3808dec8) at sql_update.cc:992 #7 0x0000000000646204 in mysql_execute_command (thd=0x7fba3808dec8) at sql_parse.cc:2883 #8 0x000000000064b846 in mysql_parse (thd=0x7fba3808dec8, inBuf=0x22d8498 "UPDATE testdb_N . t1_base1_N AS A NATURAL JOIN testdb_N . t1_part2_N B SET A. `pk` = 6 , B. `pk` = 9", length=104, found_semicolon=0x7fba3f7baf10) at sql_parse.cc:5587 #9 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba3808dec8, packet=0x7fba38157bf9 "UPDATE testdb_N . t1_base1_N AS A NATURAL JOIN testdb_N . t1_part2_N B SET A. `pk` = 6 , B. `pk` = 9", packet_length=104) at sql_parse.cc:1011 #10 0x000000000064d967 in do_command (thd=0x7fba3808dec8) at sql_parse.cc:695 #11 0x000000000063c275 in handle_one_connection (arg=0x7fba3808dec8) at sql_connect.cc:1163 #12 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #13 0x000000315a4e627d in clone () from /lib64/libc.so.6 ---Type to continue, or q to quit--- Thread 15 (process 29890): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0xfc2340, mp=0xfc22c0, file=0xb61360 "mdl.cc", line=1304) at thr_mutex.c:237 #2 0x000000000083f2f3 in MDL_context::wait_for_locks (this=0x7fba3805fa38, mdl_requests=0x7fba3f5f09e0) at mdl.cc:1304 #3 0x0000000000695155 in Open_table_context::recover_from_failed_open (this=0x7fba3f5f09e0, thd=0x7fba3805f968, mdl_request=0x21fbc80, table=0x21fb950) at sql_base.cc:3786 #4 0x00000000006976bf in open_tables (thd=0x7fba3805f968, start=0x7fba3f5f0a60, counter=0x7fba3f5f0aa0, flags=32, prelocking_strategy=0x7fba3f5f1f00) at sql_base.cc:4374 #5 0x0000000000697b68 in open_and_lock_tables_derived (thd=0x7fba3805f968, tables=0x21fb950, derived=false, flags=32, prelocking_strategy=0x7fba3f5f1f00) at sql_base.cc:4950 #6 0x00000000007997d1 in mysql_alter_table (thd=0x7fba3805f968, new_db=0x21fb8f8 "testdb_N", new_name=0x0, create_info=0x7fba3f5f2380, table_list=0x21fb950, alter_info=0x7fba3f5f2e30, order_num=0, order=0x0, ignore=true) at sql_table.cc:6483 #7 0x000000000064562b in mysql_execute_command (thd=0x7fba3805f968) at sql_parse.cc:2631 #8 0x000000000064b846 in mysql_parse (thd=0x7fba3805f968, inBuf=0x21fb7f8 "ALTER IGNORE TABLE testdb_N . t1_base1_N COMMENT = 'UPDATED NOW()'", length=68, found_semicolon=0x7fba3f5f3f10) at sql_parse.cc:5587 #9 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba3805f968, packet=0x7fba3810b219 "ALTER IGNORE TABLE testdb_N . t1_base1_N COMMENT = 'UPDATED NOW()'", packet_length=68) at sql_parse.cc:1011 #10 0x000000000064d967 in do_command (thd=0x7fba3805f968) at sql_parse.cc:695 #11 0x000000000063c275 in handle_one_connection (arg=0x7fba3805f968) 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 14 (process 28918): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x00000000008935c4 in os_thread_sleep (tm=1000000) at os/os0thread.c:280 #2 0x00000000008c67be in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1969 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 13 (process 28895): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d508, mp=0x1b9d490, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d490, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=4, message1=0x7fba4550f0d0, message2=0x7fba4550f0c8, type=0x7fba4550f0c0) at os/os0file.c:4088 #4 0x0000000000918654 in fil_aio_wait (segment=4) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4060) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 12 (process 29875): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0xfc2340, mp=0xfc22c0, file=0xb61360 "mdl.cc", line=1304) at thr_mutex.c:237 #2 0x000000000083f2f3 in MDL_context::wait_for_locks (this=0x7fba38082ac8, mdl_requests=0x7fba3f6b4e20) at mdl.cc:1304 #3 0x0000000000695155 in Open_table_context::recover_from_failed_open (this=0x7fba3f6b4e20, thd=0x7fba380829f8, mdl_request=0x23be468, table=0x23be138) ---Type to continue, or q to quit--- at sql_base.cc:3786 #4 0x00000000006976bf in open_tables (thd=0x7fba380829f8, start=0x7fba3f6b4ea0, counter=0x7fba3f6b4ee0, flags=0, prelocking_strategy=0x7fba3f6b4f20) at sql_base.cc:4374 #5 0x0000000000697b68 in open_and_lock_tables_derived (thd=0x7fba380829f8, tables=0x23bd898, derived=true, flags=0, prelocking_strategy=0x7fba3f6b4f20) at sql_base.cc:4950 #6 0x000000000064e876 in open_and_lock_tables_derived (thd=0x7fba380829f8, tables=0x23bd898, derived=true, flags=0) at mysql_priv.h:1499 #7 0x000000000064e8b1 in open_and_lock_tables (thd=0x7fba380829f8, tables=0x23bd898) at mysql_priv.h:1509 #8 0x00000000007f6a7b in mysql_create_view (thd=0x7fba380829f8, views=0x23bd898, mode=VIEW_CREATE_NEW) at sql_view.cc:402 #9 0x000000000064abdb in mysql_execute_command (thd=0x7fba380829f8) at sql_parse.cc:4316 #10 0x000000000064b846 in mysql_parse (thd=0x7fba380829f8, inBuf=0x23bd588 "/* Sequence start */ CREATE ALGORITHM = MERGE VIEW testdb_S . t1_view1_S AS SELECT HIGH_PRIORITY `col_int_key` , `pk` , `col_int` FROM testdb_N . t1_base1_N AS A WHERE `pk` BETWEEN 5 AND 5 + 1 ; C"..., length=291, found_semicolon=0x7fba3f6b6f10) at sql_parse.cc:5587 #11 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba380829f8, packet=0x7fba3809c249 "/* Sequence start */ CREATE ALGORITHM = MERGE VIEW testdb_S . t1_view1_S AS SELECT HIGH_PRIORITY `col_int_key` , `pk` , `col_int` FROM testdb_N . t1_base1_N AS A WHERE `pk` BETWEEN 5 AND 5 + 1 ; C"..., packet_length=291) at sql_parse.cc:1011 #12 0x000000000064d967 in do_command (thd=0x7fba380829f8) at sql_parse.cc:695 #13 0x000000000063c275 in handle_one_connection (arg=0x7fba380829f8) 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 11 (process 29888): #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 0x00000000009c4e5c in safe_mutex_lock (mp=0xfb22a0, try_lock=0 '\0', file=0xb42d85 "sql_db.cc", line=646) at thr_mutex.c:149 #4 0x000000000078ba39 in mysql_create_db (thd=0x7fba380c9518, db=0x2188b60 "testdb_N", create_info=0x7fba3f737380, silent=false) at sql_db.cc:646 #5 0x0000000000647ae9 in mysql_execute_command (thd=0x7fba380c9518) at sql_parse.cc:3406 #6 0x000000000064b846 in mysql_parse (thd=0x7fba380c9518, inBuf=0x2188a68 "CREATE SCHEMA IF NOT EXISTS testdb_N DEFAULT CHARACTER SET = utf8", length=65, found_semicolon=0x7fba3f738f10) at sql_parse.cc:5587 #7 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba380c9518, packet=0x7fba380fec69 "CREATE SCHEMA IF NOT EXISTS testdb_N DEFAULT CHARACTER SET = utf8", packet_length=65) at sql_parse.cc:1011 #8 0x000000000064d967 in do_command (thd=0x7fba380c9518) at sql_parse.cc:695 #9 0x000000000063c275 in handle_one_connection (arg=0x7fba380c9518) 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 10 (process 29884): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0xfc2340, mp=0xfc22c0, file=0xb61360 "mdl.cc", line=1304) at thr_mutex.c:237 #2 0x000000000083f2f3 in MDL_context::wait_for_locks (this=0x7fba381307e8, mdl_requests=0x7fba3f5b0e80) at mdl.cc:1304 #3 0x0000000000695155 in Open_table_context::recover_from_failed_open (this=0x7fba3f5b0e80, thd=0x7fba38130718, mdl_request=0x20dfd58, table=0x20dfa28) at sql_base.cc:3786 #4 0x00000000006976bf in open_tables (thd=0x7fba38130718, start=0x7fba3f5b0f00, counter=0x7fba3f5b0f40, flags=32, prelocking_strategy=0x7fba3f5b0f80) at sql_base.cc:4374 #5 0x0000000000697b68 in open_and_lock_tables_derived (thd=0x7fba38130718, tables=0x20dfa28, derived=false, flags=32, prelocking_strategy=0x7fba3f5b0f80) ---Type to continue, or q to quit--- at sql_base.cc:4950 #6 0x000000000064e876 in open_and_lock_tables_derived (thd=0x7fba38130718, tables=0x20dfa28, derived=false, flags=32) at mysql_priv.h:1499 #7 0x0000000000697f03 in open_n_lock_single_table (thd=0x7fba38130718, table_l=0x20dfa28, lock_type=TL_WRITE_ALLOW_READ, flags=32) at sql_base.cc:4775 #8 0x000000000081bdc8 in mysql_create_or_drop_trigger (thd=0x7fba38130718, tables=0x20dfa28, create=false) at sql_trigger.cc:464 #9 0x000000000064ac8a in mysql_execute_command (thd=0x7fba38130718) at sql_parse.cc:4337 #10 0x000000000064b846 in mysql_parse (thd=0x7fba38130718, inBuf=0x20df888 "DROP TRIGGER IF EXISTS testdb_N . tr1_1_N", length=41, found_semicolon=0x7fba3f5b2f10) at sql_parse.cc:5587 #11 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba38130718, packet=0x7fba380c54d9 "DROP TRIGGER IF EXISTS testdb_N . tr1_1_N ", packet_length=42) at sql_parse.cc:1011 #12 0x000000000064d967 in do_command (thd=0x7fba38130718) at sql_parse.cc:695 #13 0x000000000063c275 in handle_one_connection (arg=0x7fba38130718) 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 9 (process 28897): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d688, mp=0x1b9d610, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d610, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=6, message1=0x7fba4410d0d0, message2=0x7fba4410d0c8, type=0x7fba4410d0c0) at os/os0file.c:4088 #4 0x0000000000918654 in fil_aio_wait (segment=6) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4070) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 8 (process 29910): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0xfc2340, mp=0xfc22c0, file=0xb61360 "mdl.cc", line=1304) at thr_mutex.c:237 #2 0x000000000083f2f3 in MDL_context::wait_for_locks (this=0x7fba38126778, mdl_requests=0x7fba3f8bce80) at mdl.cc:1304 #3 0x0000000000695155 in Open_table_context::recover_from_failed_open (this=0x7fba3f8bce80, thd=0x7fba381266a8, mdl_request=0x22097c0, table=0x2209490) at sql_base.cc:3786 #4 0x00000000006976bf in open_tables (thd=0x7fba381266a8, start=0x7fba3f8bcf00, counter=0x7fba3f8bcf40, flags=32, prelocking_strategy=0x7fba3f8bcf80) at sql_base.cc:4374 #5 0x0000000000697b68 in open_and_lock_tables_derived (thd=0x7fba381266a8, tables=0x2209490, derived=false, flags=32, prelocking_strategy=0x7fba3f8bcf80) at sql_base.cc:4950 #6 0x000000000064e876 in open_and_lock_tables_derived (thd=0x7fba381266a8, tables=0x2209490, derived=false, flags=32) at mysql_priv.h:1499 #7 0x0000000000697f03 in open_n_lock_single_table (thd=0x7fba381266a8, table_l=0x2209490, lock_type=TL_WRITE_ALLOW_READ, flags=32) at sql_base.cc:4775 #8 0x000000000081bdc8 in mysql_create_or_drop_trigger (thd=0x7fba381266a8, tables=0x2209490, create=true) at sql_trigger.cc:464 #9 0x000000000064ac64 in mysql_execute_command (thd=0x7fba381266a8) at sql_parse.cc:4330 #10 0x000000000064b846 in mysql_parse (thd=0x7fba381266a8, inBuf=0x2209208 "CREATE TRIGGER testdb_N . tr1_1_N BEFORE DELETE ON t1_base2_N FOR EACH ROW BEGIN UPDATE testdb_S . t1_temp1_S SET `col_int` = 1 WHERE SLEEP( 0.5 * 0.62 * 1 ) = 0 LIMIT 1 ; END", length=179, found_semicolon=0x7fba3f8bef10) at sql_parse.cc:5587 #11 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba381266a8, packet=0x7fba380a60b9 "CREATE TRIGGER testdb_N . tr1_1_N BEFORE DELETE ON t1_base2_N FOR EACH ROW BEGIN UPDATE testdb_S . t1_temp1_S SET `col_int` = 1 WHERE SLEEP( 0.5 * 0.62 * 1 ) = 0 LIMIT 1 ; END", packet_length=179) at sql_parse.cc:1011 ---Type to continue, or q to quit--- #12 0x000000000064d967 in do_command (thd=0x7fba381266a8) at sql_parse.cc:695 #13 0x000000000063c275 in handle_one_connection (arg=0x7fba381266a8) 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 (process 29908): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x20d7278, mp=0x20d7210, file=0xb5ba80 "event_queue.cc", line=734) at thr_mutex.c:237 #2 0x0000000000823b84 in Event_queue::cond_wait (this=0x20d7210, thd=0x22fae88, abstime=0x0, msg=0xb5c149 "Waiting on empty queue", func=0xb5c180 "get_top_for_execution_if_time", line=585) at event_queue.cc:734 #3 0x0000000000823e93 in Event_queue::get_top_for_execution_if_time (this=0x20d7210, thd=0x22fae88, event_name=0x7fba3f77a0a0) at event_queue.cc:585 #4 0x000000000081ed66 in Event_scheduler::run (this=0x20e3cc0, thd=0x22fae88) at event_scheduler.cc:463 #5 0x000000000081f301 in event_scheduler_thread (arg=0x225fc58) at event_scheduler.cc:236 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 6 (process 29882): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0xfc2340, mp=0xfc22c0, file=0xb61360 "mdl.cc", line=1304) at thr_mutex.c:237 #2 0x000000000083f2f3 in MDL_context::wait_for_locks (this=0x7fba380b14b8, mdl_requests=0x7fba3f83af80) at mdl.cc:1304 #3 0x0000000000695155 in Open_table_context::recover_from_failed_open (this=0x7fba3f83af80, thd=0x7fba380b13e8, mdl_request=0x22159e0, table=0x22156b0) at sql_base.cc:3786 #4 0x00000000006976bf in open_tables (thd=0x7fba380b13e8, start=0x7fba3f83b000, counter=0x7fba3f83b040, flags=0, prelocking_strategy=0x7fba3f83b080) at sql_base.cc:4374 #5 0x0000000000697b68 in open_and_lock_tables_derived (thd=0x7fba380b13e8, tables=0x22156b0, derived=true, flags=0, prelocking_strategy=0x7fba3f83b080) at sql_base.cc:4950 #6 0x000000000064e876 in open_and_lock_tables_derived (thd=0x7fba380b13e8, tables=0x22156b0, derived=true, flags=0) at mysql_priv.h:1499 #7 0x000000000064e8b1 in open_and_lock_tables (thd=0x7fba380b13e8, tables=0x22156b0) at mysql_priv.h:1509 #8 0x000000000064403e in mysql_execute_command (thd=0x7fba380b13e8) at sql_parse.cc:2070 #9 0x000000000064b846 in mysql_parse (thd=0x7fba380b13e8, inBuf=0x2214ad8 "DO ( SELECT COUNT(*) FROM testdb_N . t1_base1_N WHERE `pk` BETWEEN 0 AND 0 + 20 )", length=82, found_semicolon=0x7fba3f83cf10) at sql_parse.cc:5587 #10 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba380b13e8, packet=0x7fba380e3dd9 "DO ( SELECT COUNT(*) FROM testdb_N . t1_base1_N WHERE `pk` BETWEEN 0 AND 0 + 20 )", packet_length=82) at sql_parse.cc:1011 #11 0x000000000064d967 in do_command (thd=0x7fba380b13e8) at sql_parse.cc:695 #12 0x000000000063c275 in handle_one_connection (arg=0x7fba380b13e8) 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 5 (process 28896): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d5c8, mp=0x1b9d550, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d550, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=5, message1=0x7fba44b0e0d0, message2=0x7fba44b0e0c8, type=0x7fba44b0e0c0) at os/os0file.c:4088 ---Type to continue, or q to quit--- #4 0x0000000000918654 in fil_aio_wait (segment=5) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4068) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 4 (process 29911): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c5366 in safe_cond_timedwait (cond=0xfc2340, mp=0xfc22c0, abstime=0x7fba3f673370, file=0xb61360 "mdl.cc", line=961) at thr_mutex.c:275 #2 0x00000000008404b8 in MDL_context::acquire_exclusive_locks (this=0x7fba38062608, mdl_requests=0x7fba3f673420) at mdl.cc:961 #3 0x000000000062886b in lock_table_names (thd=0x7fba38062538, table_list=0x23c36a8) at lock.cc:961 #4 0x000000000079c62e in mysql_rm_table_part2 (thd=0x7fba38062538, tables=0x23c36a8, if_exists=true, drop_temporary=false, drop_view=true, dont_log_query=true) at sql_table.cc:1898 #5 0x000000000078abc4 in mysql_rm_known_files (thd=0x7fba38062538, dirp=0x2156e08, db=0x23c3698 "testdb_N", org_path=0x7fba3f673d20 "./testdb_N/", level=0, dropped_tables=0x7fba3f674048) at sql_db.cc:1166 #6 0x000000000078af9f in mysql_rm_db (thd=0x7fba38062538, db=0x23c3698 "testdb_N", if_exists=false, silent=false) at sql_db.cc:929 #7 0x0000000000647cbd in mysql_execute_command (thd=0x7fba38062538) at sql_parse.cc:3441 #8 0x000000000064b846 in mysql_parse (thd=0x7fba38062538, inBuf=0x23c35f8 "DROP SCHEMA testdb_N", length=21, found_semicolon=0x7fba3f675f10) at sql_parse.cc:5587 #9 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba38062538, packet=0x7fba380539f9 "DROP SCHEMA testdb_N", packet_length=21) at sql_parse.cc:1011 #10 0x000000000064d967 in do_command (thd=0x7fba38062538) at sql_parse.cc:695 #11 0x000000000063c275 in handle_one_connection (arg=0x7fba38062538) 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 (process 28900): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0x1b9d8c8, mp=0x1b9d850, file=0xb72ad5 "os/os0sync.c", line=396) at thr_mutex.c:237 #2 0x0000000000892e9e in os_event_wait_low (event=0x1b9d850, reset_sig_count=0) at os/os0sync.c:396 #3 0x0000000000891b84 in os_aio_simulated_handle (global_segment=9, message1=0x7fba4230a0d0, message2=0x7fba4230a0c8, type=0x7fba4230a0c0) at os/os0file.c:4088 #4 0x0000000000918654 in fil_aio_wait (segment=9) at fil/fil0fil.c:4430 #5 0x00000000008c8735 in io_handler_thread (arg=0xfc4088) at srv/srv0start.c:491 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 2 (process 29825): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009c51ce in safe_cond_wait (cond=0xfb2da0, mp=0xfb2320, file=0xb1bc8d "sql_base.cc", line=1066) at thr_mutex.c:237 #2 0x00000000006985b6 in close_cached_tables (thd=0x7fba380ed468, tables=0x2216c38, have_lock=false, wait_for_refresh=true) at sql_base.cc:1066 #3 0x000000000063ea60 in reload_acl_and_cache (thd=0x7fba380ed468, options=4, tables=0x2216c38, write_to_binlog=0x7fba3f42af1f) at sql_parse.cc:6567 #4 0x00000000006490f7 in mysql_execute_command (thd=0x7fba380ed468) at sql_parse.cc:3764 #5 0x000000000064b846 in mysql_parse (thd=0x7fba380ed468, inBuf=0x2216b28 "FLUSH TABLE testdb_N . t1_base2_N", length=33, found_semicolon=0x7fba3f42bf10) at sql_parse.cc:5587 #6 0x000000000064c496 in dispatch_command (command=COM_QUERY, thd=0x7fba380ed468, packet=0x7fba3801b239 "FLUSH TABLE testdb_N . t1_base2_N ", ---Type to continue, or q to quit--- packet_length=34) at sql_parse.cc:1011 #7 0x000000000064d967 in do_command (thd=0x7fba380ed468) at sql_parse.cc:695 #8 0x000000000063c275 in handle_one_connection (arg=0x7fba380ed468) at sql_connect.cc:1163 #9 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #10 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 1 (process 28889): #0 0x000000315b00c216 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000009b9fb1 in my_write_core (sig=11) at stacktrace.c:307 #2 0x0000000000632a03 in handle_segfault (sig=11) at mysqld.cc:2607 #3 #4 0x000000315a4dea62 in select () from /lib64/libc.so.6 #5 0x000000000063323c in handle_connections_sockets () at mysqld.cc:5071 #6 0x0000000000636a5a in main (argc=41, argv=0x7fff58ed15b8) at mysqld.cc:4560