Thread 26 (process 7151): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x000000000089e961 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 #2 0x00000000008d217c in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2220 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 25 (process 7153): #0 0x000000315b00ee7b in sigwait () from /lib64/libpthread.so.0 #1 0x000000000063008c in signal_hand (arg=0x0) at mysqld.cc:2915 #2 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #3 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 24 (process 7174): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d294e in safe_cond_timedwait (cond=0x27acd38, mp=0x27accd0, abstime=0x7fd4bd36c560, file=0xb76a60 "mdl.cc", line=810) at thr_mutex.c:278 #2 0x000000000084930e in MDL_context::timed_wait (this=0x27acc68, timeout=1) at mdl.cc:810 #3 0x000000000084a431 in MDL_context::acquire_lock_impl (this=0x27acc68, mdl_request=0x7fd4bd36c620) at mdl.cc:1467 #4 0x000000000084a6a5 in MDL_context::upgrade_shared_lock_to_exclusive (this=0x27acc68, mdl_ticket=0x7fd4b0003cc0) at mdl.cc:1617 #5 0x0000000000697fb2 in wait_while_table_is_used (thd=0x27acb98, table=0x7fd4b807f0a8, function=HA_EXTRA_PREPARE_FOR_RENAME) at sql_base.cc:2148 #6 0x00000000007a282e in mysql_alter_table (thd=0x27acb98, new_db=0x27692e0 "testdb_N", new_name=0x27692f0 "t1_base1_N", create_info=0x7fd4bd36e320, table_list=0x2769338, alter_info=0x7fd4bd36edf0, order_num=0, order=0x0, ignore=false) at sql_table.cc:7272 #7 0x0000000000643c02 in mysql_execute_command (thd=0x27acb98) at sql_parse.cc:2640 #8 0x0000000000649bc2 in mysql_parse (thd=0x27acb98, inBuf=0x2769208 "ALTER TABLE testdb_N . t1_base1_N ENGINE = MEMORY", length=49, found_semicolon=0x7fd4bd36fee0) at sql_parse.cc:5586 #9 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x27acb98, packet=0x27183d9 " ALTER TABLE testdb_N . t1_base1_N ENGINE = MEMORY ", packet_length=51) at sql_parse.cc:1020 #10 0x000000000064bc3a in do_command (thd=0x27acb98) at sql_parse.cc:706 #11 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x27acb98) at sql_connect.cc:1172 #12 0x000000000063a7af in handle_one_connection (arg=0x27acb98) at sql_connect.cc:1112 #13 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #14 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 23 (process 7150): #0 0x000000315a4dea62 in select () from /lib64/libc.so.6 #1 0x000000000089e961 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 #2 0x00000000008d1c70 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1984 #3 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #4 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 22 (process 7178): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d294e in safe_cond_timedwait (cond=0x27113d8, mp=0x2711370, abstime=0x7fd4bd2eb990, file=0xb76a60 "mdl.cc", line=810) at thr_mutex.c:278 #2 0x000000000084930e in MDL_context::timed_wait (this=0x2711308, timeout=1) at mdl.cc:810 ---Type to continue, or q to quit--- #3 0x000000000084a431 in MDL_context::acquire_lock_impl (this=0x2711308, mdl_request=0x2738540) at mdl.cc:1467 #4 0x000000000084a8e1 in MDL_context::acquire_locks (this=0x2711308, mdl_requests=0x7fd4bd2ebc60) at mdl.cc:1555 #5 0x0000000000627121 in lock_table_names (thd=0x2711238, table_list=0x27381f0) at lock.cc:967 #6 0x00000000007a369f in mysql_rm_table_part2 (thd=0x2711238, tables=0x27381f0, if_exists=true, drop_temporary=false, drop_view=false, dont_log_query=false) at sql_table.cc:1903 #7 0x00000000007a43df in mysql_rm_table (thd=0x2711238, tables=0x27381f0, if_exists=1 '\001', drop_temporary=0 '\0') at sql_table.cc:1803 #8 0x0000000000645540 in mysql_execute_command (thd=0x2711238) at sql_parse.cc:3164 #9 0x0000000000649bc2 in mysql_parse (thd=0x2711238, inBuf=0x2738088 "DROP TABLE IF EXISTS testdb_N . t1_base1_N , testdb_N . t1_merge1_N CASCADE", length=78, found_semicolon=0x7fd4bd2edee0) at sql_parse.cc:5586 #10 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x2711238, packet=0x2713ea9 "DROP TABLE IF EXISTS testdb_N . t1_base1_N , testdb_N . t1_merge1_N CASCADE", packet_length=78) at sql_parse.cc:1020 #11 0x000000000064bc3a in do_command (thd=0x2711238) at sql_parse.cc:706 #12 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x2711238) at sql_connect.cc:1172 #13 0x000000000063a7af in handle_one_connection (arg=0x2711238) at sql_connect.cc:1112 #14 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #15 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 21 (process 7144): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213dde8, mp=0x213dd70, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213dd70, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=4, message1=0x7fd4c31460d0, message2=0x7fd4c31460c8, type=0x7fd4c31460c0) at os/os0file.c:4197 #4 0x00000000009247e2 in fil_aio_wait (segment=4) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe1680) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 20 (process 7146): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213df68, mp=0x213def0, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213def0, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=6, message1=0x7fd4c1d440d0, message2=0x7fd4c1d440c8, type=0x7fd4c1d440c0) at os/os0file.c:4197 #4 0x00000000009247e2 in fil_aio_wait (segment=6) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe1690) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 19 (process 7142): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213dc68, mp=0x213dbf0, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213dbf0, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=2, message1=0x7fd4c45480d0, message2=0x7fd4c45480c8, type=0x7fd4c45480c0) at os/os0file.c:4197 ---Type to continue, or q to quit--- #4 0x00000000009247e2 in fil_aio_wait (segment=2) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe1670) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 18 (process 7165): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x26d5358, mp=0x26d52f0, file=0xb76a60 "mdl.cc", line=786) at thr_mutex.c:240 #2 0x00000000008493fe in MDL_context::wait (this=0x26d5288) at mdl.cc:786 #3 0x000000000084a044 in MDL_context::wait_for_lock (this=0x26d5288, mdl_request=0x26f1af0) at mdl.cc:1858 #4 0x0000000000699eee in Open_table_context::recover_from_failed_open (this=0x7fd4bd4b2b00, thd=0x26d51b8, mdl_request=0x26f1af0, table=0x26f17a0) at sql_base.cc:3839 #5 0x000000000069c6b7 in open_tables (thd=0x26d51b8, start=0x7fd4bd4b2cd0, counter=0x7fd4bd4b2fe0, flags=0, prelocking_strategy=0x7fd4bd4b2bd0) at sql_base.cc:4538 #6 0x0000000000546b54 in open_tables (thd=0x26d51b8, tables=0x7fd4bd4b2cd0, counter=0x7fd4bd4b2fe0, flags=0) at mysql_priv.h:1549 #7 0x00000000006fc149 in mysql_update (thd=0x26d51b8, table_list=0x26f0280, fields=@0x26d7190, values=@0x26d7570, conds=0x26f0e38, order_num=0, order=0x0, limit=1, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7fd4bd4b3f10, updated_return=0x7fd4bd4b3f08) at sql_update.cc:214 #8 0x000000000064469c in mysql_execute_command (thd=0x26d51b8) at sql_parse.cc:2847 #9 0x0000000000649bc2 in mysql_parse (thd=0x26d51b8, inBuf=0x26f0108 "UPDATE testdb_N . t1_view1_N SET `pk` = 0 WHERE SLEEP( 0.5 * 0.06 * 1 ) = 0 LIMIT 1", length=86, found_semicolon=0x7fd4bd4b4ee0) at sql_parse.cc:5586 #10 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x26d51b8, packet=0x26e8079 "UPDATE testdb_N . t1_view1_N SET `pk` = 0 WHERE SLEEP( 0.5 * 0.06 * 1 ) = 0 LIMIT 1", packet_length=86) at sql_parse.cc:1020 #11 0x000000000064bc3a in do_command (thd=0x26d51b8) at sql_parse.cc:706 #12 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x26d51b8) at sql_connect.cc:1172 #13 0x000000000063a7af in handle_one_connection (arg=0x26d51b8) at sql_connect.cc:1112 #14 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #15 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 17 (process 7145): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213dea8, mp=0x213de30, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213de30, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=5, message1=0x7fd4c27450d0, message2=0x7fd4c27450c8, type=0x7fd4c27450c0) at os/os0file.c:4197 #4 0x00000000009247e2 in fil_aio_wait (segment=5) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe1688) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 16 (process 7180): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x27637e8, mp=0x2763780, file=0xb76a60 "mdl.cc", line=786) at thr_mutex.c:240 #2 0x00000000008493fe in MDL_context::wait (this=0x2763718) at mdl.cc:786 #3 0x000000000084a044 in MDL_context::wait_for_lock (this=0x2763718, mdl_request=0x7fd4b00f26a8) at mdl.cc:1858 ---Type to continue, or q to quit--- #4 0x0000000000699eee in Open_table_context::recover_from_failed_open (this=0x7fd4bd2aaee0, thd=0x2763648, mdl_request=0x7fd4b00f26a8, table=0x7fd4b00f2358) at sql_base.cc:3839 #5 0x000000000069c6b7 in open_tables (thd=0x2763648, start=0x7fd4bd2aafb0, counter=0x7fd4bd2aafec, flags=0, prelocking_strategy=0x7fd4bd2ab030) at sql_base.cc:4538 #6 0x000000000069cb79 in open_and_lock_tables_derived (thd=0x2763648, tables=0x274f008, derived=true, flags=0, prelocking_strategy=0x7fd4bd2ab030) at sql_base.cc:5109 #7 0x000000000064cc2e in open_and_lock_tables_derived (thd=0x2763648, tables=0x274f008, derived=true, flags=0) at mysql_priv.h:1561 #8 0x000000000064cc69 in open_and_lock_tables (thd=0x2763648, tables=0x274f008) at mysql_priv.h:1571 #9 0x0000000000642678 in mysql_execute_command (thd=0x2763648) at sql_parse.cc:2074 #10 0x0000000000649bc2 in mysql_parse (thd=0x2763648, inBuf=0x274e418 "DO ( SELECT COUNT(*) FROM testdb_N . t1_view1_N WHERE `pk` BETWEEN 6 AND 6 + 20 )", length=82, found_semicolon=0x7fd4bd2acee0) at sql_parse.cc:5586 #11 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x2763648, packet=0x2748dd9 "DO ( SELECT COUNT(*) FROM testdb_N . t1_view1_N WHERE `pk` BETWEEN 6 AND 6 + 20 )", packet_length=82) at sql_parse.cc:1020 #12 0x000000000064bc3a in do_command (thd=0x2763648) at sql_parse.cc:706 #13 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x2763648) at sql_connect.cc:1172 #14 0x000000000063a7af in handle_one_connection (arg=0x2763648) at sql_connect.cc:1112 #15 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #16 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 15 (process 7148): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213e0e8, mp=0x213e070, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213e070, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=8, message1=0x7fd4c09420d0, message2=0x7fd4c09420c8, type=0x7fd4c09420c0) at os/os0file.c:4197 #4 0x00000000009247e2 in fil_aio_wait (segment=8) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe16a0) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 14 (process 7154): #0 0x000000315b00df5b in read () from /lib64/libpthread.so.0 #1 0x000000000099fb39 in vio_read (vio=0x26cae58, buf=0x26d1178 "\a", size=4) at viosocket.c:44 #2 0x00000000006214fe in my_real_read (net=0x2680120, complen=0x7fd4bd4f5fc8) at net_serv.cc:836 #3 0x0000000000621b7e in my_net_read (net=0x2680120) at net_serv.cc:1026 #4 0x000000000064baa2 in do_command (thd=0x267ff38) at sql_parse.cc:652 #5 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x267ff38) at sql_connect.cc:1172 #6 0x000000000063a7af in handle_one_connection (arg=0x267ff38) at sql_connect.cc:1112 #7 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #8 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 13 (process 7152): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x1b44158, mp=0x1b440e0, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x1b440e0, reset_sig_count=0) at os/os0sync.c:399 ---Type to continue, or q to quit--- #3 0x00000000008d34ee in srv_master_thread (arg=0x0) at srv/srv0srv.c:2740 #4 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #5 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 12 (process 7169): #0 0x000000315b00b58d in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d294e in safe_cond_timedwait (cond=0x278ca18, mp=0x278c9b0, abstime=0x7fd4bd42fa80, file=0xb76a60 "mdl.cc", line=810) at thr_mutex.c:278 #2 0x000000000084930e in MDL_context::timed_wait (this=0x278c948, timeout=1) at mdl.cc:810 #3 0x000000000084a431 in MDL_context::acquire_lock_impl (this=0x278c948, mdl_request=0x27a1f40) at mdl.cc:1467 #4 0x000000000084a8e1 in MDL_context::acquire_locks (this=0x278c948, mdl_requests=0x7fd4bd42fbb0) at mdl.cc:1555 #5 0x0000000000695a4a in open_table_get_mdl_lock (thd=0x278c878, table_list=0x27a1bf0, mdl_request=0x27a1f40, ot_ctx=0x7fd4bd430210, flags=0) at sql_base.cc:2362 #6 0x000000000069ac4b in open_table (thd=0x278c878, table_list=0x27a1bf0, mem_root=0x7fd4bd4301d0, ot_ctx=0x7fd4bd430210, flags=0) at sql_base.cc:2665 #7 0x000000000069bedb in open_and_process_table (thd=0x278c878, lex=0x278e0a8, tables=0x27a1bf0, counter=0x7fd4bd431050, flags=0, prelocking_strategy=0x7fd4bd4302e0, has_prelocking_list=false, ot_ctx=0x7fd4bd430210, new_frm_mem=0x7fd4bd4301d0) at sql_base.cc:4188 #8 0x000000000069c64b in open_tables (thd=0x278c878, start=0x278e0b0, counter=0x7fd4bd431050, flags=0, prelocking_strategy=0x7fd4bd4302e0) at sql_base.cc:4509 #9 0x0000000000546b54 in open_tables (thd=0x278c878, tables=0x278e0b0, counter=0x7fd4bd431050, flags=0) at mysql_priv.h:1549 #10 0x000000000079f81d in mysql_create_like_table (thd=0x278c878, table=0x27a1bf0, src_table=0x27a2158, create_info=0x7fd4bd431320) at sql_table.cc:5201 #11 0x0000000000643484 in mysql_execute_command (thd=0x278c878) at sql_parse.cc:2480 #12 0x0000000000649bc2 in mysql_parse (thd=0x278c878, inBuf=0x27a1a88 "CREATE TABLE IF NOT EXISTS testdb_N . t1_base1_N LIKE test.table1_int_autoinc", length=78, found_semicolon=0x7fd4bd432ee0) at sql_parse.cc:5586 #13 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x278c878, packet=0x27999f9 "CREATE TABLE IF NOT EXISTS testdb_N . t1_base1_N LIKE test.table1_int_autoinc ", packet_length=79) at sql_parse.cc:1020 #14 0x000000000064bc3a in do_command (thd=0x278c878) at sql_parse.cc:706 #15 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x278c878) at sql_connect.cc:1172 #16 0x000000000063a7af in handle_one_connection (arg=0x278c878) at sql_connect.cc:1112 #17 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #18 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 11 (process 7140): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213dae8, mp=0x213da70, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213da70, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=0, message1=0x7fd4ceaf50d0, message2=0x7fd4ceaf50c8, type=0x7fd4ceaf50c0) at os/os0file.c:4197 #4 0x00000000009247e2 in fil_aio_wait (segment=0) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe1660) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 10 (process 7147): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213e028, mp=0x213dfb0, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213dfb0, reset_sig_count=0) at os/os0sync.c:399 ---Type to continue, or q to quit--- #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=7, message1=0x7fd4c13430d0, message2=0x7fd4c13430c8, type=0x7fd4c13430c0) at os/os0file.c:4197 #4 0x00000000009247e2 in fil_aio_wait (segment=7) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe1698) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 9 (process 7141): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213dba8, mp=0x213db30, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213db30, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=1, message1=0x7fd4c4f490d0, message2=0x7fd4c4f490c8, type=0x7fd4c4f490c0) at os/os0file.c:4197 #4 0x00000000009247e2 in fil_aio_wait (segment=1) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe1668) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 8 (process 7172): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x279dbd8, mp=0x279db70, file=0xb76a60 "mdl.cc", line=786) at thr_mutex.c:240 #2 0x00000000008493fe in MDL_context::wait (this=0x279db08) at mdl.cc:786 #3 0x000000000084a044 in MDL_context::wait_for_lock (this=0x279db08, mdl_request=0x7fd4b0052428) at mdl.cc:1858 #4 0x0000000000699eee in Open_table_context::recover_from_failed_open (this=0x7fd4bd3ad040, thd=0x279da38, mdl_request=0x7fd4b0052428, table=0x7fd4b00520d8) at sql_base.cc:3839 #5 0x000000000069c6b7 in open_tables (thd=0x279da38, start=0x7fd4bd3ad150, counter=0x7fd4bd3ad18c, flags=0, prelocking_strategy=0x7fd4bd3ad110) at sql_base.cc:4538 #6 0x0000000000546b54 in open_tables (thd=0x279da38, tables=0x7fd4bd3ad150, counter=0x7fd4bd3ad18c, flags=0) at mysql_priv.h:1549 #7 0x000000000069ca9e in open_normal_and_derived_tables (thd=0x279da38, tables=0x7fd4b00c41e0, flags=0) at sql_base.cc:5158 #8 0x00000000007c77d8 in mysqld_show_create (thd=0x279da38, table_list=0x7fd4b00c41e0) at sql_show.cc:644 #9 0x0000000000644021 in mysql_execute_command (thd=0x279da38) at sql_parse.cc:2741 #10 0x00000000006ed69e in Prepared_statement::execute (this=0x7fd4b00ebbe8, expanded_query=0x7fd4bd3af030, open_cursor=false) at sql_prepare.cc:3740 #11 0x00000000006f15ad in Prepared_statement::execute_loop (this=0x7fd4b00ebbe8, expanded_query=0x7fd4bd3af030, open_cursor=false, packet=0x0, packet_end=0x0) at sql_prepare.cc:3387 #12 0x00000000006f1829 in mysql_sql_stmt_execute (thd=0x279da38) at sql_prepare.cc:2578 #13 0x0000000000642622 in mysql_execute_command (thd=0x279da38) at sql_parse.cc:2065 #14 0x0000000000649bc2 in mysql_parse (thd=0x279da38, inBuf=0x278f4f8 "EXECUTE st1", length=11, found_semicolon=0x7fd4bd3b0ee0) at sql_parse.cc:5586 #15 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x279da38, packet=0x27a8b59 " EXECUTE st1 ", packet_length=13) at sql_parse.cc:1020 #16 0x000000000064bc3a in do_command (thd=0x279da38) at sql_parse.cc:706 #17 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x279da38) at sql_connect.cc:1172 #18 0x000000000063a7af in handle_one_connection (arg=0x279da38) at sql_connect.cc:1112 #19 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #20 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 7 (process 7182): ---Type to continue, or q to quit--- #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x2825948, mp=0x28258e0, file=0xb76a60 "mdl.cc", line=786) at thr_mutex.c:240 #2 0x00000000008493fe in MDL_context::wait (this=0x2825878) at mdl.cc:786 #3 0x000000000084a044 in MDL_context::wait_for_lock (this=0x2825878, mdl_request=0x7fd4b8053188) at mdl.cc:1858 #4 0x0000000000699eee in Open_table_context::recover_from_failed_open (this=0x7fd4bd269d80, thd=0x28257a8, mdl_request=0x7fd4b8053188, table=0x7fd4b8052e38) at sql_base.cc:3839 #5 0x000000000069c6b7 in open_tables (thd=0x28257a8, start=0x7fd4bd269e50, counter=0x7fd4bd269e8c, flags=0, prelocking_strategy=0x7fd4bd269ed0) at sql_base.cc:4538 #6 0x000000000069cb79 in open_and_lock_tables_derived (thd=0x28257a8, tables=0x27e5fe0, derived=true, flags=0, prelocking_strategy=0x7fd4bd269ed0) at sql_base.cc:5109 #7 0x000000000064cc2e in open_and_lock_tables_derived (thd=0x28257a8, tables=0x27e5fe0, derived=true, flags=0) at mysql_priv.h:1561 #8 0x000000000064cc69 in open_and_lock_tables (thd=0x28257a8, tables=0x27e5fe0) at mysql_priv.h:1571 #9 0x00000000007ff9d3 in mysql_create_view (thd=0x28257a8, views=0x27e5fe0, mode=VIEW_CREATE_NEW) at sql_view.cc:399 #10 0x0000000000648f49 in mysql_execute_command (thd=0x28257a8) at sql_parse.cc:4297 #11 0x0000000000649bc2 in mysql_parse (thd=0x28257a8, inBuf=0x27e5dd8 "CREATE ALGORITHM = MERGE VIEW testdb_N . t1_view1_N AS SELECT `pk` , `col_int_key` , `pk` FROM testdb_N . t1_view1_N AS A WHERE `pk` BETWEEN 1 AND 1 + 1", length=158, found_semicolon=0x7fd4bd26bee0) at sql_parse.cc:5586 #12 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x28257a8, packet=0x2828419 "CREATE ALGORITHM = MERGE VIEW testdb_N . t1_view1_N AS SELECT `pk` , `col_int_key` , `pk` FROM testdb_N . t1_view1_N AS A WHERE `pk` BETWEEN 1 AND 1 + 1", packet_length=158) at sql_parse.cc:1020 #13 0x000000000064bc3a in do_command (thd=0x28257a8) at sql_parse.cc:706 #14 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x28257a8) at sql_connect.cc:1172 #15 0x000000000063a7af in handle_one_connection (arg=0x28257a8) at sql_connect.cc:1112 #16 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #17 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 6 (process 7167): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x27b40a8, mp=0x276be10, file=0xbb2bf8 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #2 0x00000000009d002e in inline_mysql_cond_wait (that=0x27b40a8, mutex=0x276be10) at ../include/mysql/psi/mysql_thread.h:784 #3 0x00000000009cfd51 in wait_for_lock (wait=0x276bea0, data=0x2768528, in_wait_list=0 '\0') at thr_lock.c:448 #4 0x00000000009d0932 in thr_lock (data=0x2768528, owner=0x277d8a8, lock_type=TL_WRITE) at thr_lock.c:785 #5 0x00000000009d1450 in thr_multi_lock (data=0x26a9288, count=1, owner=0x277d8a8) at thr_lock.c:1054 #6 0x0000000000628752 in mysql_lock_tables (thd=0x277cb08, tables=0x27794b0, count=1, flags=0, need_reopen=0x7fd4bd471feb) at lock.cc:320 #7 0x000000000069514e in lock_tables (thd=0x277cb08, tables=0x2778908, count=1, flags=0, need_reopen=0x7fd4bd471feb) at sql_base.cc:5435 #8 0x000000000069cc02 in open_and_lock_tables_derived (thd=0x277cb08, tables=0x2778908, derived=true, flags=0, prelocking_strategy=0x7fd4bd472030) at sql_base.cc:5117 #9 0x000000000064cc2e in open_and_lock_tables_derived (thd=0x277cb08, tables=0x2778908, derived=true, flags=0) at mysql_priv.h:1561 #10 0x000000000064cc69 in open_and_lock_tables (thd=0x277cb08, tables=0x2778908) at mysql_priv.h:1571 #11 0x0000000000645202 in mysql_execute_command (thd=0x277cb08) at sql_parse.cc:3101 #12 0x0000000000649bc2 in mysql_parse (thd=0x277cb08, inBuf=0x2778258 "DELETE A FROM testdb_N . t1_base1_N AS A WHERE `pk` BETWEEN 4 AND 4 + 1", length=74, found_semicolon=0x7fd4bd473ee0) at sql_parse.cc:5586 #13 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x277cb08, packet=0x277f779 "DELETE A FROM testdb_N . t1_base1_N AS A WHERE `pk` BETWEEN 4 AND 4 + 1", packet_length=74) at sql_parse.cc:1020 #14 0x000000000064bc3a in do_command (thd=0x277cb08) at sql_parse.cc:706 ---Type to continue, or q to quit--- #15 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x277cb08) at sql_connect.cc:1172 #16 0x000000000063a7af in handle_one_connection (arg=0x277cb08) at sql_connect.cc:1112 #17 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #18 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 5 (process 7184): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x27d0218, mp=0x27d01b0, file=0xb76a60 "mdl.cc", line=786) at thr_mutex.c:240 #2 0x00000000008493fe in MDL_context::wait (this=0x27d0148) at mdl.cc:786 #3 0x000000000084a044 in MDL_context::wait_for_lock (this=0x27d0148, mdl_request=0x7fd4b80e6a68) at mdl.cc:1858 #4 0x0000000000699eee in Open_table_context::recover_from_failed_open (this=0x7fd4bd228ee0, thd=0x27d0078, mdl_request=0x7fd4b80e6a68, table=0x7fd4b80e6718) at sql_base.cc:3839 #5 0x000000000069c6b7 in open_tables (thd=0x27d0078, start=0x7fd4bd228fb0, counter=0x7fd4bd228fec, flags=0, prelocking_strategy=0x7fd4bd229030) at sql_base.cc:4538 #6 0x000000000069cb79 in open_and_lock_tables_derived (thd=0x27d0078, tables=0x275ca88, derived=true, flags=0, prelocking_strategy=0x7fd4bd229030) at sql_base.cc:5109 #7 0x000000000064cc2e in open_and_lock_tables_derived (thd=0x27d0078, tables=0x275ca88, derived=true, flags=0) at mysql_priv.h:1561 #8 0x000000000064cc69 in open_and_lock_tables (thd=0x27d0078, tables=0x275ca88) at mysql_priv.h:1571 #9 0x0000000000642678 in mysql_execute_command (thd=0x27d0078) at sql_parse.cc:2074 #10 0x0000000000649bc2 in mysql_parse (thd=0x27d0078, inBuf=0x275be98 "DO ( SELECT COUNT(*) FROM testdb_N . t1_view1_N WHERE `pk` BETWEEN 8 AND 8 + 20 )", length=82, found_semicolon=0x7fd4bd22aee0) at sql_parse.cc:5586 #11 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x27d0078, packet=0x27d2ce9 "DO ( SELECT COUNT(*) FROM testdb_N . t1_view1_N WHERE `pk` BETWEEN 8 AND 8 + 20 )", packet_length=82) at sql_parse.cc:1020 #12 0x000000000064bc3a in do_command (thd=0x27d0078) at sql_parse.cc:706 #13 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x27d0078) at sql_connect.cc:1172 #14 0x000000000063a7af in handle_one_connection (arg=0x27d0078) at sql_connect.cc:1112 #15 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #16 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 4 (process 7149): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213e1a8, mp=0x213e130, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213e130, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=9, message1=0x7fd4bff410d0, message2=0x7fd4bff410c8, type=0x7fd4bff410c0) at os/os0file.c:4197 #4 0x00000000009247e2 in fil_aio_wait (segment=9) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe16a8) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 3 (process 7143): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x213dd28, mp=0x213dcb0, file=0xb88115 "os/os0sync.c", line=399) at thr_mutex.c:240 #2 0x000000000089e230 in os_event_wait_low (event=0x213dcb0, reset_sig_count=0) at os/os0sync.c:399 #3 0x000000000089cf01 in os_aio_simulated_handle (global_segment=3, message1=0x7fd4c3b470d0, message2=0x7fd4c3b470c8, type=0x7fd4c3b470c0) ---Type to continue, or q to quit--- at os/os0file.c:4197 #4 0x00000000009247e2 in fil_aio_wait (segment=3) at fil/fil0fil.c:4450 #5 0x00000000008d3be5 in io_handler_thread (arg=0xfe1678) at srv/srv0start.c:492 #6 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #7 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 2 (process 7176): #0 0x000000315b00b309 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009d27b6 in safe_cond_wait (cond=0x2724d28, mp=0x2724cc0, file=0xb76a60 "mdl.cc", line=786) at thr_mutex.c:240 #2 0x00000000008493fe in MDL_context::wait (this=0x2724c58) at mdl.cc:786 #3 0x000000000084a044 in MDL_context::wait_for_lock (this=0x2724c58, mdl_request=0x7fd4b8086630) at mdl.cc:1858 #4 0x0000000000699eee in Open_table_context::recover_from_failed_open (this=0x7fd4bd32cbe0, thd=0x2724b88, mdl_request=0x7fd4b8086630, table=0x7fd4b80862e0) at sql_base.cc:3839 #5 0x000000000069c6b7 in open_tables (thd=0x2724b88, start=0x7fd4bd32ccb0, counter=0x7fd4bd32ccec, flags=0, prelocking_strategy=0x7fd4bd32cd30) at sql_base.cc:4538 #6 0x000000000069cb79 in open_and_lock_tables_derived (thd=0x2724b88, tables=0x27052f0, derived=true, flags=0, prelocking_strategy=0x7fd4bd32cd30) at sql_base.cc:5109 #7 0x000000000064cc2e in open_and_lock_tables_derived (thd=0x2724b88, tables=0x27052f0, derived=true, flags=0) at mysql_priv.h:1561 #8 0x000000000064cc69 in open_and_lock_tables (thd=0x2724b88, tables=0x27052f0) at mysql_priv.h:1571 #9 0x00000000006e53fa in mysql_insert (thd=0x2724b88, table_list=0x27052f0, fields=@0x2726f28, values_list=@0x2726f70, update_fields=@0x2726f58, update_values=@0x2726f40, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:648 #10 0x0000000000644b0c in mysql_execute_command (thd=0x2724b88) at sql_parse.cc:2968 #11 0x0000000000649bc2 in mysql_parse (thd=0x2724b88, inBuf=0x27051a8 "INSERT testdb_N . t1_view1_N ( `col_int_key` ) VALUES ( 6 )", length=62, found_semicolon=0x7fd4bd32eee0) at sql_parse.cc:5586 #12 0x000000000064a7db in dispatch_command (command=COM_QUERY, thd=0x2724b88, packet=0x27277f9 "INSERT testdb_N . t1_view1_N ( `col_int_key` ) VALUES ( 6 ) ", packet_length=63) at sql_parse.cc:1020 #13 0x000000000064bc3a in do_command (thd=0x2724b88) at sql_parse.cc:706 #14 0x000000000063a6f0 in do_handle_one_connection (thd_arg=0x2724b88) at sql_connect.cc:1172 #15 0x000000000063a7af in handle_one_connection (arg=0x2724b88) at sql_connect.cc:1112 #16 0x000000315b0073da in start_thread () from /lib64/libpthread.so.0 #17 0x000000315a4e627d in clone () from /lib64/libc.so.6 Thread 1 (process 7137): #0 0x000000315b00c216 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000009c7335 in my_write_core (sig=11) at stacktrace.c:326 #2 0x0000000000630d4a in handle_segfault (sig=11) at mysqld.cc:2714 #3 #4 0x000000315a4dea62 in select () from /lib64/libc.so.6 #5 0x0000000000631579 in handle_connections_sockets () at mysqld.cc:5363 #6 0x0000000000634e5e in main (argc=45, argv=0x1b19120) at mysqld.cc:4831