(gdb) thread apply all bt Thread 31 (Thread 0xb802eb90 (LWP 22840)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a118f in Synchronize::sleep (this=0xb714a1d0) at Synchronize.cpp:123 #3 0x084ee6eb in Cache::ioThread (this=0xb7149e28) at Cache.cpp:921 #4 0x084ee8f5 in Cache::ioThread (arg=0xb7149e28) at Cache.cpp:744 #5 0x084d9dc2 in Thread::thread (this=0xb714a1d0) at Thread.cpp:167 #6 0x084d9fd7 in Thread::thread (parameter=0xb714a1d0) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 30 (Thread 0xb6d46b90 (LWP 22841)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a118f in Synchronize::sleep (this=0xb714a2b0) at Synchronize.cpp:123 #3 0x084ee6eb in Cache::ioThread (this=0xb7149e28) at Cache.cpp:921 #4 0x084ee8f5 in Cache::ioThread (arg=0xb7149e28) at Cache.cpp:744 #5 0x084d9dc2 in Thread::thread (this=0xb714a2b0) at Thread.cpp:167 #6 0x084d9fd7 in Thread::thread (parameter=0xb714a2b0) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 29 (Thread 0xb6144b90 (LWP 22842)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580ec2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a102c in Synchronize::sleep (this=0xb7152d00, milliseconds=1000, callersMutex=0x0) at Synchronize.cpp:183 #3 0x085a0e27 in Synchronize::sleep (this=0xb7152d00, milliseconds=1000) at Synchronize.cpp:136 #4 0x08505d59 in Database::ticker (this=0xb734a630) at Database.cpp:1868 #5 0x08505d8f in Database::ticker (database=0xb734a630) at Database.cpp:1857 #6 0x084d9dc2 in Thread::thread (this=0xb7152d00) at Thread.cpp:167 #7 0x084d9fd7 in Thread::thread (parameter=0xb7152d00) at Thread.cpp:146 #8 0x0057d32f in start_thread () from /lib/libpthread.so.0 #9 0x0049a27e in clone () from /lib/libc.so.6 Thread 28 (Thread 0xb5743b90 (LWP 22843)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a118f in Synchronize::sleep (this=0xb7152de0) at Synchronize.cpp:123 #3 0x0854cfcc in PageWriter::writer (this=0xb714b668) at PageWriter.cpp:171 #4 0x0854d0fb in PageWriter::writer (arg=0xb714b668) at PageWriter.cpp:160 #5 0x084d9dc2 in Thread::thread (this=0xb7152de0) at Thread.cpp:167 #6 0x084d9fd7 in Thread::thread (parameter=0xb7152de0) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 ---Type to continue, or q to quit--- Thread 27 (Thread 0xb3941b90 (LWP 22844)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a118f in Synchronize::sleep (this=0xb71531e0) at Synchronize.cpp:123 #3 0x085b477b in Gopher::gopherThread (this=0xb714b640) at Gopher.cpp:58 #4 0x085b490f in Gopher::gopherThread (arg=0xb714b640) at Gopher.cpp:37 #5 0x084d9dc2 in Thread::thread (this=0xb71531e0) at Thread.cpp:167 #6 0x084d9fd7 in Thread::thread (parameter=0xb71531e0) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 26 (Thread 0xb2f40b90 (LWP 22845)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a118f in Synchronize::sleep (this=0xb71532c0) at Synchronize.cpp:123 #3 0x085b477b in Gopher::gopherThread (this=0xb714b618) at Gopher.cpp:58 #4 0x085b490f in Gopher::gopherThread (arg=0xb714b618) at Gopher.cpp:37 #5 0x084d9dc2 in Thread::thread (this=0xb71532c0) at Thread.cpp:167 #6 0x084d9fd7 in Thread::thread (parameter=0xb71532c0) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 25 (Thread 0xb253fb90 (LWP 22846)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a118f in Synchronize::sleep (this=0xb71533a0) at Synchronize.cpp:123 #3 0x085b477b in Gopher::gopherThread (this=0xb714b5f0) at Gopher.cpp:58 #4 0x085b490f in Gopher::gopherThread (arg=0xb714b5f0) at Gopher.cpp:37 #5 0x084d9dc2 in Thread::thread (this=0xb71533a0) at Thread.cpp:167 #6 0x084d9fd7 in Thread::thread (parameter=0xb71533a0) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 24 (Thread 0xb1b3eb90 (LWP 22847)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a118f in Synchronize::sleep (this=0xb7153480) at Synchronize.cpp:123 #3 0x085b477b in Gopher::gopherThread (this=0xb714b5c8) at Gopher.cpp:58 #4 0x085b490f in Gopher::gopherThread (arg=0xb714b5c8) at Gopher.cpp:37 #5 0x084d9dc2 in Thread::thread (this=0xb7153480) at Thread.cpp:167 #6 0x084d9fd7 in Thread::thread (parameter=0xb7153480) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 ---Type to continue, or q to quit--- Thread 23 (Thread 0xb113db90 (LWP 22848)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a118f in Synchronize::sleep (this=0xb7153560) at Synchronize.cpp:123 #3 0x085b477b in Gopher::gopherThread (this=0xb714b5a0) at Gopher.cpp:58 #4 0x085b490f in Gopher::gopherThread (arg=0xb714b5a0) at Gopher.cpp:37 #5 0x084d9dc2 in Thread::thread (this=0xb7153560) at Thread.cpp:167 #6 0x084d9fd7 in Thread::thread (parameter=0xb7153560) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 22 (Thread 0xb053bb90 (LWP 22866)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a118f in Synchronize::sleep (this=0xb7175a48) at Synchronize.cpp:123 #3 0x08565087 in Scheduler::schedule (this=0xb7152230) at Scheduler.cpp:151 #4 0x085650d9 in Scheduler::schedule (lpParameter=0xb7152230) at Scheduler.cpp:158 #5 0x084d9dc2 in Thread::thread (this=0xb7175a48) at Thread.cpp:167 #6 0x084d9fd7 in Thread::thread (parameter=0xb7175a48) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 21 (Thread 0xafb3ab90 (LWP 22867)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580ec2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085a102c in Synchronize::sleep (this=0xb7178c48, milliseconds=15000, callersMutex=0x0) at Synchronize.cpp:183 #3 0x085a0e27 in Synchronize::sleep (this=0xb7178c48, milliseconds=15000) at Synchronize.cpp:136 #4 0x08565070 in Scheduler::schedule (this=0xb71522c0) at Scheduler.cpp:149 #5 0x085650d9 in Scheduler::schedule (lpParameter=0xb71522c0) at Scheduler.cpp:158 #6 0x084d9dc2 in Thread::thread (this=0xb7178c48) at Thread.cpp:167 #7 0x084d9fd7 in Thread::thread (parameter=0xb7178c48) at Thread.cpp:146 #8 0x0057d32f in start_thread () from /lib/libpthread.so.0 #9 0x0049a27e in clone () from /lib/libc.so.6 Thread 20 (Thread 0xae612b90 (LWP 22884)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0870effb in safe_cond_wait (cond=0x94aaffc, mp=0x94aafb0, file=0x88c32b6 "os/os0sync.c", line=338) at thr_mutex.c:237 #3 0x0862982a in os_event_wait (event=0x94aafb0) at os/os0sync.c:338 #4 0x08628a60 in os_aio_simulated_handle (global_segment=0, message1=0xae61236c, message2=0xae612368, type=0xae612364) at os/os0file.c:4144 #5 0x0860546a in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 #6 0x0864eb79 in io_handler_thread (arg=0x8b8b9c0) at srv/srv0start.c:434 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 ---Type to continue, or q to quit--- Thread 19 (Thread 0xadc11b90 (LWP 22885)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0870effb in safe_cond_wait (cond=0x94ab094, mp=0x94ab048, file=0x88c32b6 "os/os0sync.c", line=338) at thr_mutex.c:237 #3 0x0862982a in os_event_wait (event=0x94ab048) at os/os0sync.c:338 #4 0x08628a60 in os_aio_simulated_handle (global_segment=1, message1=0xadc1136c, message2=0xadc11368, type=0xadc11364) at os/os0file.c:4144 #5 0x0860546a in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 #6 0x0864eb79 in io_handler_thread (arg=0x8b8b9c4) at srv/srv0start.c:434 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 18 (Thread 0xad210b90 (LWP 22886)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0870effb in safe_cond_wait (cond=0x94ab12c, mp=0x94ab0e0, file=0x88c32b6 "os/os0sync.c", line=338) at thr_mutex.c:237 #3 0x0862982a in os_event_wait (event=0x94ab0e0) at os/os0sync.c:338 #4 0x08628a60 in os_aio_simulated_handle (global_segment=2, message1=0xad21036c, message2=0xad210368, type=0xad210364) at os/os0file.c:4144 #5 0x0860546a in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 #6 0x0864eb79 in io_handler_thread (arg=0x8b8b9c8) at srv/srv0start.c:434 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 17 (Thread 0xac80fb90 (LWP 22887)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0870effb in safe_cond_wait (cond=0x94ab1c4, mp=0x94ab178, file=0x88c32b6 "os/os0sync.c", line=338) at thr_mutex.c:237 #3 0x0862982a in os_event_wait (event=0x94ab178) at os/os0sync.c:338 #4 0x08628a60 in os_aio_simulated_handle (global_segment=3, message1=0xac80f36c, message2=0xac80f368, type=0xac80f364) at os/os0file.c:4144 #5 0x0860546a in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 #6 0x0864eb79 in io_handler_thread (arg=0x8b8b9cc) at srv/srv0start.c:434 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 16 (Thread 0xabe0db90 (LWP 22888)): #0 0x00110416 in __kernel_vsyscall () #1 0x004926e1 in select () from /lib/libc.so.6 #2 0x08629e94 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 #3 0x0864d722 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1905 #4 0x0057d32f in start_thread () from /lib/libpthread.so.0 #5 0x0049a27e in clone () from /lib/libc.so.6 Thread 15 (Thread 0xab40cb90 (LWP 22889)): #0 0x00110416 in __kernel_vsyscall () #1 0x004926e1 in select () from /lib/libc.so.6 #2 0x08629e94 in os_thread_sleep (tm=2000000) at os/os0thread.c:281 ---Type to continue, or q to quit--- #3 0x0864dcc8 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2131 #4 0x0057d32f in start_thread () from /lib/libpthread.so.0 #5 0x0049a27e in clone () from /lib/libc.so.6 Thread 14 (Thread 0xaa806b90 (LWP 22890)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0870effb in safe_cond_wait (cond=0x9040ecc, mp=0x9040e80, file=0x88c32b6 "os/os0sync.c", line=338) at thr_mutex.c:237 #3 0x0862982a in os_event_wait (event=0x9040e80) at os/os0sync.c:338 #4 0x0864e5c2 in srv_master_thread (arg=0x0) at srv/srv0srv.c:2620 #5 0x0057d32f in start_thread () from /lib/libpthread.so.0 #6 0x0049a27e in clone () from /lib/libc.so.6 Thread 13 (Thread 0xa9e05b90 (LWP 22891)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8867993 "sql_test.cc", line=79) at thr_mutex.c:149 #5 0x083641fc in print_cached_tables () at sql_test.cc:79 #6 0x083644a4 in mysql_print_status () at sql_test.cc:503 #7 0x082a331e in signal_hand (arg=0x0) at mysqld.cc:2864 #8 0x0057d32f in start_thread () from /lib/libpthread.so.0 #9 0x0049a27e in clone () from /lib/libc.so.6 Thread 12 (Thread 0xa9d10b90 (LWP 23423)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=2109) at thr_mutex.c:149 #5 0x082fbecd in drop_open_table (thd=0x952f898, table=0x974f758, db_name=0x963d5e0 "test", table_name=0x963d3c0 "alter2") at sql_base.cc:2109 #6 0x08342787 in select_create::abort (this=0x963dc48) at sql_insert.cc:3742 #7 0x0833f1d6 in handle_select (thd=0x952f898, lex=0x9530968, result=0x963dc48, setup_tables_done_option=0) at sql_select.cc:295 #8 0x082b5f9d in mysql_execute_command (thd=0x952f898) at sql_parse.cc:2434 #9 0x082bdfd5 in mysql_parse (thd=0x952f898, inBuf=0x963d2b0 "CREATE TABLE alter2 ENGINE = Innodb PARTITION BY HASH(t1_autoinc) PARTITIONS 2 SELECT * FROM inter1", length=99, found_semicolon=0xa9d10260) at sql_parse.cc:5782 #10 0x082bea71 in dispatch_command (command=COM_QUERY, thd=0x952f898, packet=0x95be5d1 "CREATE TABLE alter2 ENGINE = Innodb PARTITION BY HASH(t1_autoinc) PARTITIONS 2 SELECT * FROM inter1", packet_length=99) at sql_parse.cc:1059 #11 0x082bfd32 in do_command (thd=0x952f898) at sql_parse.cc:732 #12 0x082ad446 in handle_one_connection (arg=0x952f898) at sql_connect.cc:1134 #13 0x0057d32f in start_thread () from /lib/libpthread.so.0 #14 0x0049a27e in clone () from /lib/libc.so.6 ---Type to continue, or q to quit--- Thread 11 (Thread 0xa9cdfb90 (LWP 23448)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=2701) at thr_mutex.c:149 #5 0x0830009e in open_table (thd=0x9588378, table_list=0x95ba7c0, mem_root=0xa9cddfbc, refresh=0xa9cddfff, flags=0) at sql_base.cc:2701 #6 0x083015e6 in open_tables (thd=0x9588378, start=0xa9cde074, counter=0xa9cde060, flags=0) at sql_base.cc:4514 #7 0x08301de7 in open_and_lock_tables_derived (thd=0x9588378, tables=0x95ba7c0, derived=true) at sql_base.cc:4914 #8 0x082c0ae3 in open_and_lock_tables (thd=0x9588378, tables=0x95ba7c0) at mysql_priv.h:1606 #9 0x0835ef9c in mysql_delete (thd=0x9588378, table_list=0x95ba7c0, conds=0x95baaf8, order=0x9589820, limit=18446744073709551615, options=0, reset_auto_increment=false) at sql_delete.cc:55 #10 0x082b814a in mysql_execute_command (thd=0x9588378) at sql_parse.cc:3082 #11 0x082bdfd5 in mysql_parse (thd=0x9588378, inBuf=0x95ba700 "DELETE FROM view2 WHERE t1_uuid = @uuid", length=39, found_semicolon=0xa9cdf260) at sql_parse.cc:5782 #12 0x082bea71 in dispatch_command (command=COM_QUERY, thd=0x9588378, packet=0x9608f89 "DELETE FROM view2 WHERE t1_uuid = @uuid", packet_length=39) at sql_parse.cc:1059 #13 0x082bfd32 in do_command (thd=0x9588378) at sql_parse.cc:732 #14 0x082ad446 in handle_one_connection (arg=0x9588378) at sql_connect.cc:1134 #15 0x0057d32f in start_thread () from /lib/libpthread.so.0 #16 0x0049a27e in clone () from /lib/libc.so.6 Thread 10 (Thread 0xa9d41b90 (LWP 23458)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=1157) at thr_mutex.c:149 #5 0x082fb48f in close_open_tables (thd=0x94d0f70) at sql_base.cc:1157 #6 0x082fb94b in close_thread_tables (thd=0x94d0f70) at sql_base.cc:1314 #7 0x082fb9ef in close_system_tables (thd=0x94d0f70, backup=0xa9d3fd40) at sql_base.cc:8786 #8 0x0846bfe7 in db_find_routine (thd=0x94d0f70, type=3, name=0xa9d40020, sphp=0xa9d40044) at sp.cc:486 #9 0x0846c12f in sp_cache_routines_and_add_tables_aux (thd=0x94d0f70, lex=0x94d2040, start=0x95e48d0, first_no_prelock=false) at sp.cc:1690 #10 0x0846c453 in sp_cache_routines_and_add_tables_for_triggers (thd=0x94d0f70, lex=0x94d2040, table=0x95e4068) at sp.cc:1863 #11 0x0830181a in open_tables (thd=0x94d0f70, start=0xa9d401b4, counter=0xa9d401a0, flags=0) at sql_base.cc:4612 #12 0x08301de7 in open_and_lock_tables_derived (thd=0x94d0f70, tables=0x95e2a60, derived=true) at sql_base.cc:4914 #13 0x082c0ae3 in open_and_lock_tables (thd=0x94d0f70, tables=0x95e2a60) at mysql_priv.h:1606 #14 0x083490a4 in mysql_insert (thd=0x94d0f70, table_list=0x95e2a60, fields=@0x94d25e0, values_list=@0x94d2604, update_fields=@0x94d25f8, update_values=@0x94d25ec, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:615 #15 0x082b7a6a in mysql_execute_command (thd=0x94d0f70) at sql_parse.cc:2951 #16 0x082bdfd5 in mysql_parse (thd=0x94d0f70, inBuf=0x95e2998 "INSERT INTO view1 (t1_uuid) VALUES (@uuid1)", length=43, found_semicolon=0xa9d41260) at sql_parse.cc:5782 #17 0x082bea71 in dispatch_command (command=COM_QUERY, thd=0x94d0f70, packet=0x958c331 "INSERT INTO view1 (t1_uuid) VALUES (@uuid1)", packet_length=43) at sql_parse.cc:1059 ---Type to continue, or q to quit--- #18 0x082bfd32 in do_command (thd=0x94d0f70) at sql_parse.cc:732 #19 0x082ad446 in handle_one_connection (arg=0x94d0f70) at sql_connect.cc:1134 #20 0x0057d32f in start_thread () from /lib/libpthread.so.0 #21 0x0049a27e in clone () from /lib/libc.so.6 Thread 9 (Thread 0xa9da3b90 (LWP 23481)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=2109) at thr_mutex.c:149 #5 0x082fbecd in drop_open_table (thd=0x96f2158, table=0x9795440, db_name=0x95d07c0 "test", table_name=0x95d05a0 "alter1") at sql_base.cc:2109 #6 0x08342787 in select_create::abort (this=0x95d1a28) at sql_insert.cc:3742 #7 0x0833f1d6 in handle_select (thd=0x96f2158, lex=0x96f3228, result=0x95d1a28, setup_tables_done_option=0) at sql_select.cc:295 #8 0x082b5f9d in mysql_execute_command (thd=0x96f2158) at sql_parse.cc:2434 #9 0x082bdfd5 in mysql_parse (thd=0x96f2158, inBuf=0x95d04e0 "CREATE TABLE alter1 ENGINE = Innodb SELECT * FROM inter1", length=56, found_semicolon=0xa9da3260) at sql_parse.cc:5782 #10 0x082bea71 in dispatch_command (command=COM_QUERY, thd=0x96f2158, packet=0x96eb1b9 "CREATE TABLE alter1 ENGINE = Innodb SELECT * FROM inter1", packet_length=56) at sql_parse.cc:1059 #11 0x082bfd32 in do_command (thd=0x96f2158) at sql_parse.cc:732 #12 0x082ad446 in handle_one_connection (arg=0x96f2158) at sql_connect.cc:1134 #13 0x0057d32f in start_thread () from /lib/libpthread.so.0 #14 0x0049a27e in clone () from /lib/libc.so.6 Thread 8 (Thread 0xa9dd4b90 (LWP 23497)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=1157) at thr_mutex.c:149 #5 0x082fb48f in close_open_tables (thd=0x9529898) at sql_base.cc:1157 #6 0x082fb94b in close_thread_tables (thd=0x9529898) at sql_base.cc:1314 #7 0x082bf8b7 in dispatch_command (command=COM_QUERY, thd=0x9529898, packet=0x951e541 "", packet_length=48) at sql_parse.cc:1434 #8 0x082bfd32 in do_command (thd=0x9529898) at sql_parse.cc:732 #9 0x082ad446 in handle_one_connection (arg=0x9529898) at sql_connect.cc:1134 #10 0x0057d32f in start_thread () from /lib/libpthread.so.0 #11 0x0049a27e in clone () from /lib/libc.so.6 Thread 7 (Thread 0xa9d72b90 (LWP 23499)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057edb5 in _L_lock_758 () from /lib/libpthread.so.0 #3 0x0057ecce in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x9558e1c, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=392) at thr_mutex.c:149 #5 0x082fd4a8 in get_table_share (thd=0x958a0d8, table_list=0x96082c0, key=0xa9d70a2d "test", key_length=12, db_flags=8192, error=0xa9d70328) ---Type to continue, or q to quit--- at sql_base.cc:392 #6 0x082fd7f5 in get_table_share_with_create (thd=0x958a0d8, table_list=0x96082c0, key=0xa9d70a2d "test", key_length=12, db_flags=8192, error=0xa9d70328) at sql_base.cc:452 #7 0x082fdb0e in open_unireg_entry (thd=0x958a0d8, entry=0x9526888, table_list=0x96082c0, alias=0x96082b8 "inter2", cache_key=0xa9d70a2d "test", cache_key_length=12, mem_root=0xa9d70ecc, flags=0) at sql_base.cc:3824 #8 0x08300704 in open_table (thd=0x958a0d8, table_list=0x96082c0, mem_root=0xa9d70ecc, refresh=0xa9d70f0f, flags=0) at sql_base.cc:2903 #9 0x083015e6 in open_tables (thd=0x958a0d8, start=0xa9d70f84, counter=0xa9d70f70, flags=0) at sql_base.cc:4514 #10 0x08301de7 in open_and_lock_tables_derived (thd=0x958a0d8, tables=0x9606b90, derived=true) at sql_base.cc:4914 #11 0x082c0ae3 in open_and_lock_tables (thd=0x958a0d8, tables=0x9606b90) at mysql_priv.h:1606 #12 0x082b34e8 in execute_sqlcom_select (thd=0x958a0d8, all_tables=0x9606b90) at sql_parse.cc:4789 #13 0x082b51a2 in mysql_execute_command (thd=0x958a0d8) at sql_parse.cc:2018 #14 0x082bdfd5 in mysql_parse (thd=0x958a0d8, inBuf=0x9606a10 "SELECT t1_uuid FROM view2 WHERE t1_uuid = @uuid1", length=48, found_semicolon=0xa9d72260) at sql_parse.cc:5782 #15 0x082bea71 in dispatch_command (command=COM_QUERY, thd=0x958a0d8, packet=0x95cc4a9 "SELECT t1_uuid FROM view2 WHERE t1_uuid = @uuid1", packet_length=48) at sql_parse.cc:1059 #16 0x082bfd32 in do_command (thd=0x958a0d8) at sql_parse.cc:732 #17 0x082ad446 in handle_one_connection (arg=0x958a0d8) at sql_connect.cc:1134 #18 0x0057d32f in start_thread () from /lib/libpthread.so.0 #19 0x0049a27e in clone () from /lib/libc.so.6 Thread 6 (Thread 0xa9ba9b90 (LWP 23506)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=1157) at thr_mutex.c:149 #5 0x082fb48f in close_open_tables (thd=0x95d4530) at sql_base.cc:1157 #6 0x082fb94b in close_thread_tables (thd=0x95d4530) at sql_base.cc:1314 #7 0x082bf8b7 in dispatch_command (command=COM_QUERY, thd=0x95d4530, packet=0x965b269 "", packet_length=48) at sql_parse.cc:1434 #8 0x082bfd32 in do_command (thd=0x95d4530) at sql_parse.cc:732 #9 0x082ad446 in handle_one_connection (arg=0x95d4530) at sql_connect.cc:1134 #10 0x0057d32f in start_thread () from /lib/libpthread.so.0 #11 0x0049a27e in clone () from /lib/libc.so.6 Thread 5 (Thread 0xa9caeb90 (LWP 23521)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=2660) at thr_mutex.c:149 #5 0x082fff15 in open_table (thd=0x966f1b0, table_list=0x96e61c8, mem_root=0xa9cabeac, refresh=0xa9cabeef, flags=0) at sql_base.cc:2660 #6 0x083015e6 in open_tables (thd=0x966f1b0, start=0xa9cabf64, counter=0xa9cabf50, flags=0) at sql_base.cc:4514 #7 0x08301de7 in open_and_lock_tables_derived (thd=0x966f1b0, tables=0x96e61c8, derived=true) at sql_base.cc:4914 #8 0x082c0ae3 in open_and_lock_tables (thd=0x966f1b0, tables=0x96e61c8) at mysql_priv.h:1606 #9 0x0835ef9c in mysql_delete (thd=0x966f1b0, table_list=0x96e61c8, conds=0x9764d70, order=0x96e5c30, limit=18446744073709551615, options=0, ---Type to continue, or q to quit--- reset_auto_increment=false) at sql_delete.cc:55 #10 0x082b814a in mysql_execute_command (thd=0x966f1b0) at sql_parse.cc:3082 #11 0x0845f1a3 in sp_instr_stmt::exec_core (this=0x96e6960, thd=0x966f1b0, nextp=0xa9cace7c) at sp_head.cc:2886 #12 0x0845f3ff in sp_lex_keeper::reset_lex_and_exec_core (this=0x96e6988, thd=0x966f1b0, nextp=0xa9cace7c, open_tables=false, instr=0x96e6960) at sp_head.cc:2716 #13 0x08465129 in sp_instr_stmt::execute (this=0x96e6960, thd=0x966f1b0, nextp=0xa9cace7c) at sp_head.cc:2829 #14 0x0846150d in sp_head::execute (this=0x96e51a8, thd=0x966f1b0) at sp_head.cc:1239 #15 0x084626f3 in sp_head::execute_trigger (this=0x96e51a8, thd=0x966f1b0, db_name=0x9558ed4, table_name=0x9558edc, grant_info=0x96921c4) at sp_head.cc:1542 #16 0x0847083b in Table_triggers_list::process_triggers (this=0x9692158, thd=0x966f1b0, event=TRG_EVENT_INSERT, time_type=TRG_ACTION_AFTER, old_row_is_record1=true) at sql_trigger.cc:1971 #17 0x08345616 in write_record (thd=0x966f1b0, table=0x95bcc98, info=0x97009e8) at sql_insert.cc:1580 #18 0x0834597c in select_insert::send_data (this=0x97009c8, values=@0x9670600) at sql_insert.cc:3074 #19 0x0833cfc6 in JOIN::exec (this=0x9700a38) at sql_select.cc:2230 #20 0x0833a0c8 in mysql_select (thd=0x966f1b0, rref_pointer_array=0x9670670, tables=0x0, wild_num=0, fields=@0x9670600, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=3493612032, result=0x97009c8, unit=0x96702dc, select_lex=0x967056c) at sql_select.cc:2929 #21 0x0833f163 in handle_select (thd=0x966f1b0, lex=0x9670280, result=0x97009c8, setup_tables_done_option=1073741824) at sql_select.cc:289 #22 0x082b7d8f in mysql_execute_command (thd=0x966f1b0) at sql_parse.cc:3005 #23 0x082bdfd5 in mysql_parse (thd=0x966f1b0, inBuf=0x96d1268 "INSERT INTO view2 (t1_uuid) SELECT (SELECT t1_uuid FROM view1 WHERE t1_uuid = @uuid1)", length=85, found_semicolon=0xa9cae260) at sql_parse.cc:5782 #24 0x082bea71 in dispatch_command (command=COM_QUERY, thd=0x966f1b0, packet=0x96cd231 "INSERT INTO view2 (t1_uuid) SELECT (SELECT t1_uuid FROM view1 WHERE t1_uuid = @uuid1)", packet_length=85) at sql_parse.cc:1059 #25 0x082bfd32 in do_command (thd=0x966f1b0) at sql_parse.cc:732 #26 0x082ad446 in handle_one_connection (arg=0x966f1b0) at sql_connect.cc:1134 #27 0x0057d32f in start_thread () from /lib/libpthread.so.0 #28 0x0049a27e in clone () from /lib/libc.so.6 Thread 4 (Thread 0xa9c7db90 (LWP 23539)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=2701) at thr_mutex.c:149 #5 0x0830009e in open_table (thd=0x96fbef0, table_list=0xa9c7ba90, mem_root=0x96fd8c0, refresh=0xa9c7ba2f, flags=2) at sql_base.cc:2701 #6 0x08300c32 in open_system_tables_for_read (thd=0x96fbef0, table_list=0xa9c7ba90, backup=0xa9c7bd40) at sql_base.cc:8741 #7 0x0846b37c in open_proc_table_for_read (thd=0x96fbef0, backup=0xa9c7bd40) at sp.cc:248 #8 0x0846bb47 in db_find_routine (thd=0x96fbef0, type=3, name=0xa9c7c020, sphp=0xa9c7c044) at sp.cc:373 #9 0x0846c12f in sp_cache_routines_and_add_tables_aux (thd=0x96fbef0, lex=0x96fcfc0, start=0x97b7918, first_no_prelock=false) at sp.cc:1690 #10 0x0846c453 in sp_cache_routines_and_add_tables_for_triggers (thd=0x96fbef0, lex=0x96fcfc0, table=0x97b75b8) at sp.cc:1863 #11 0x0830181a in open_tables (thd=0x96fbef0, start=0xa9c7c1b4, counter=0xa9c7c1a0, flags=0) at sql_base.cc:4612 #12 0x08301de7 in open_and_lock_tables_derived (thd=0x96fbef0, tables=0x97b75b8, derived=true) at sql_base.cc:4914 #13 0x082c0ae3 in open_and_lock_tables (thd=0x96fbef0, tables=0x97b75b8) at mysql_priv.h:1606 #14 0x083490a4 in mysql_insert (thd=0x96fbef0, table_list=0x97b75b8, fields=@0x96fd560, values_list=@0x96fd584, update_fields=@0x96fd578, update_values=@0x96fd56c, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:615 #15 0x082b7a6a in mysql_execute_command (thd=0x96fbef0) at sql_parse.cc:2951 #16 0x082bdfd5 in mysql_parse (thd=0x96fbef0, inBuf=0x97b74e8 "INSERT INTO inter1 (t1_uuid) VALUES (@uuid1)", length=44, found_semicolon=0xa9c7d260) ---Type to continue, or q to quit--- at sql_parse.cc:5782 #17 0x082bea71 in dispatch_command (command=COM_QUERY, thd=0x96fbef0, packet=0x978b4c1 "INSERT INTO inter1 (t1_uuid) VALUES (@uuid1)", packet_length=44) at sql_parse.cc:1059 #18 0x082bfd32 in do_command (thd=0x96fbef0) at sql_parse.cc:732 #19 0x082ad446 in handle_one_connection (arg=0x96fbef0) at sql_connect.cc:1134 #20 0x0057d32f in start_thread () from /lib/libpthread.so.0 #21 0x0049a27e in clone () from /lib/libc.so.6 Thread 3 (Thread 0xa9c4cb90 (LWP 23558)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=2701) at thr_mutex.c:149 #5 0x0830009e in open_table (thd=0x97934b8, table_list=0x97875e8, mem_root=0xa9c4b0fc, refresh=0xa9c4b13f, flags=0) at sql_base.cc:2701 #6 0x083015e6 in open_tables (thd=0x97934b8, start=0xa9c4b1b4, counter=0xa9c4b1a0, flags=0) at sql_base.cc:4514 #7 0x08301de7 in open_and_lock_tables_derived (thd=0x97934b8, tables=0x97875e8, derived=true) at sql_base.cc:4914 #8 0x082c0ae3 in open_and_lock_tables (thd=0x97934b8, tables=0x97875e8) at mysql_priv.h:1606 #9 0x083490a4 in mysql_insert (thd=0x97934b8, table_list=0x97875e8, fields=@0x9794b28, values_list=@0x9794b4c, update_fields=@0x9794b40, update_values=@0x9794b34, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:615 #10 0x082b7a6a in mysql_execute_command (thd=0x97934b8) at sql_parse.cc:2951 #11 0x082bdfd5 in mysql_parse (thd=0x97934b8, inBuf=0x9787520 "INSERT INTO view1 (t1_uuid) VALUES (@uuid1)", length=43, found_semicolon=0xa9c4c260) at sql_parse.cc:5782 #12 0x082bea71 in dispatch_command (command=COM_QUERY, thd=0x97934b8, packet=0x97ce539 "INSERT INTO view1 (t1_uuid) VALUES (@uuid1)", packet_length=43) at sql_parse.cc:1059 #13 0x082bfd32 in do_command (thd=0x97934b8) at sql_parse.cc:732 #14 0x082ad446 in handle_one_connection (arg=0x97934b8) at sql_connect.cc:1134 #15 0x0057d32f in start_thread () from /lib/libpthread.so.0 #16 0x0049a27e in clone () from /lib/libc.so.6 Thread 2 (Thread 0xa9c1bb90 (LWP 23575)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583829 in __lll_lock_wait () from /lib/libpthread.so.0 #2 0x0057ed75 in _L_lock_87 () from /lib/libpthread.so.0 #3 0x0057e7fa in pthread_mutex_lock () from /lib/libpthread.so.0 #4 0x0870ec71 in safe_mutex_lock (mp=0x8a54360, try_lock=0 '\0', file=0x8858a6d "sql_base.cc", line=2701) at thr_mutex.c:149 #5 0x0830009e in open_table (thd=0x95c6460, table_list=0xa9c1ae70, mem_root=0xa9c1accc, refresh=0xa9c1ad0f, flags=0) at sql_base.cc:2701 #6 0x083015e6 in open_tables (thd=0x95c6460, start=0xa9c1ad84, counter=0xa9c1ad74, flags=0) at sql_base.cc:4514 #7 0x08301cd8 in open_normal_and_derived_tables (thd=0x95c6460, tables=0xa9c1ae70, flags=0) at sql_base.cc:4963 #8 0x08417a1b in mysqld_list_fields (thd=0x95c6460, table_list=0xa9c1ae70, wild=0x95c7eb0 "") at sql_show.cc:757 #9 0x082befb2 in dispatch_command (command=COM_FIELD_LIST, thd=0x95c6460, packet=0x97d2568 "", packet_length=7) at sql_parse.cc:1168 #10 0x082bfd32 in do_command (thd=0x95c6460) at sql_parse.cc:732 #11 0x082ad446 in handle_one_connection (arg=0x95c6460) at sql_connect.cc:1134 #12 0x0057d32f in start_thread () from /lib/libpthread.so.0 #13 0x0049a27e in clone () from /lib/libc.so.6 ---Type to continue, or q to quit--- Thread 1 (Thread 0xb802f6d0 (LWP 22837)): #0 0x00110416 in __kernel_vsyscall () #1 0x004926e1 in select () from /lib/libc.so.6 #2 0x082a4991 in handle_connections_sockets (arg=0x0) at mysqld.cc:5011 #3 0x082a83d0 in main (argc=33, argv=0xbf841444) at mysqld.cc:4519