Thread 33 (Thread 0xb7f83b90 (LWP 15196)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc7e3 in Synchronize::sleep (this=0xb70a0138) at Synchronize.cpp:123 #3 0x0845ac92 in Cache::ioThread (this=0xb709fe48) at Cache.cpp:941 #4 0x0845add1 in Cache::ioThread (arg=0xb709fe48) at Cache.cpp:762 #5 0x0844a536 in Thread::thread (this=0xb70a0138) at Thread.cpp:167 #6 0x0844a6b8 in Thread::thread (parameter=0xb70a0138) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 32 (Thread 0xb597bb90 (LWP 15197)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc7e3 in Synchronize::sleep (this=0xb70a0218) at Synchronize.cpp:123 #3 0x0845ac92 in Cache::ioThread (this=0xb709fe48) at Cache.cpp:941 #4 0x0845add1 in Cache::ioThread (arg=0xb709fe48) at Cache.cpp:762 #5 0x0844a536 in Thread::thread (this=0xb70a0218) at Thread.cpp:167 #6 0x0844a6b8 in Thread::thread (parameter=0xb70a0218) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 31 (Thread 0xb4d79b90 (LWP 15198)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580ec2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc6aa in Synchronize::sleep (this=0xb70a7398, milliseconds=1000, callersMutex=0x0) at Synchronize.cpp:181 #3 0x084dc510 in Synchronize::sleep (this=0xb70a7398, milliseconds=1000) at Synchronize.cpp:136 #4 0x0846a3ae in Database::ticker (this=0xb72a0640) at Database.cpp:1872 #5 0x0846a3df in Database::ticker (database=0xb72a0640) at Database.cpp:1861 #6 0x0844a536 in Thread::thread (this=0xb70a7398) at Thread.cpp:167 #7 0x0844a6b8 in Thread::thread (parameter=0xb70a7398) at Thread.cpp:146 #8 0x0057d32f in start_thread () from /lib/libpthread.so.0 #9 0x0049a27e in clone () from /lib/libc.so.6 Thread 30 (Thread 0xb4378b90 (LWP 15199)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc7e3 in Synchronize::sleep (this=0xb70a7478) at Synchronize.cpp:123 #3 0x0849ec23 in PageWriter::writer (this=0xb70a1480) at PageWriter.cpp:171 #4 0x0849ed0d in PageWriter::writer (arg=0xb70a1480) at PageWriter.cpp:160 #5 0x0844a536 in Thread::thread (this=0xb70a7478) at Thread.cpp:167 #6 0x0844a6b8 in Thread::thread (parameter=0xb70a7478) 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 29 (Thread 0xb2576b90 (LWP 15217)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc7e3 in Synchronize::sleep (this=0xb70a78d8) at Synchronize.cpp:123 #3 0x084ea0f0 in Gopher::gopherThread (this=0xb70a1458) at Gopher.cpp:58 #4 0x084ea283 in Gopher::gopherThread (arg=0xb70a1458) at Gopher.cpp:37 #5 0x0844a536 in Thread::thread (this=0xb70a78d8) at Thread.cpp:167 #6 0x0844a6b8 in Thread::thread (parameter=0xb70a78d8) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 28 (Thread 0xb1b75b90 (LWP 15218)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc7e3 in Synchronize::sleep (this=0xb70a79b8) at Synchronize.cpp:123 #3 0x084ea0f0 in Gopher::gopherThread (this=0xb70a1430) at Gopher.cpp:58 #4 0x084ea283 in Gopher::gopherThread (arg=0xb70a1430) at Gopher.cpp:37 #5 0x0844a536 in Thread::thread (this=0xb70a79b8) at Thread.cpp:167 #6 0x0844a6b8 in Thread::thread (parameter=0xb70a79b8) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 27 (Thread 0xb1174b90 (LWP 15219)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc7e3 in Synchronize::sleep (this=0xb70a7a98) at Synchronize.cpp:123 #3 0x084ea0f0 in Gopher::gopherThread (this=0xb70a1408) at Gopher.cpp:58 #4 0x084ea283 in Gopher::gopherThread (arg=0xb70a1408) at Gopher.cpp:37 #5 0x0844a536 in Thread::thread (this=0xb70a7a98) at Thread.cpp:167 #6 0x0844a6b8 in Thread::thread (parameter=0xb70a7a98) 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 0xb0773b90 (LWP 15220)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc7e3 in Synchronize::sleep (this=0xb70a7b78) at Synchronize.cpp:123 #3 0x084ea0f0 in Gopher::gopherThread (this=0xb70a13e0) at Gopher.cpp:58 #4 0x084ea283 in Gopher::gopherThread (arg=0xb70a13e0) at Gopher.cpp:37 #5 0x0844a536 in Thread::thread (this=0xb70a7b78) at Thread.cpp:167 #6 0x0844a6b8 in Thread::thread (parameter=0xb70a7b78) 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 25 (Thread 0xafd72b90 (LWP 15221)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc7e3 in Synchronize::sleep (this=0xb70a7c58) at Synchronize.cpp:123 #3 0x084ea0f0 in Gopher::gopherThread (this=0xb70a13b8) at Gopher.cpp:58 #4 0x084ea283 in Gopher::gopherThread (arg=0xb70a13b8) at Gopher.cpp:37 #5 0x0844a536 in Thread::thread (this=0xb70a7c58) at Thread.cpp:167 #6 0x0844a6b8 in Thread::thread (parameter=0xb70a7c58) 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 0xaf170b90 (LWP 15240)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc7e3 in Synchronize::sleep (this=0xb70c5330) at Synchronize.cpp:123 #3 0x084af8af in Scheduler::schedule (this=0xb70a66c8) at Scheduler.cpp:152 #4 0x084af8ef in Scheduler::schedule (lpParameter=0xb70a66c8) at Scheduler.cpp:159 #5 0x0844a536 in Thread::thread (this=0xb70c5330) at Thread.cpp:167 #6 0x0844a6b8 in Thread::thread (parameter=0xb70c5330) at Thread.cpp:146 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 23 (Thread 0xae76fb90 (LWP 15241)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580ec2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x084dc6aa in Synchronize::sleep (this=0xb70c8428, milliseconds=15000, callersMutex=0x0) at Synchronize.cpp:181 #3 0x084dc510 in Synchronize::sleep (this=0xb70c8428, milliseconds=15000) at Synchronize.cpp:136 #4 0x084af89f in Scheduler::schedule (this=0xb70a6760) at Scheduler.cpp:150 #5 0x084af8ef in Scheduler::schedule (lpParameter=0xb70a6760) at Scheduler.cpp:159 #6 0x0844a536 in Thread::thread (this=0xb70c8428) at Thread.cpp:167 #7 0x0844a6b8 in Thread::thread (parameter=0xb70c8428) at Thread.cpp:146 #8 0x0057d32f in start_thread () from /lib/libpthread.so.0 #9 0x0049a27e in clone () from /lib/libc.so.6 Thread 22 (Thread 0xad24fb90 (LWP 15242)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xab530f0, mp=0xab530a0, file=0x87abd99 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x08567792 in os_event_wait_low (event=0xab530a0, reset_sig_count=0) at os/os0sync.c:422 #4 0x08565987 in os_aio_simulated_handle (global_segment=0, message1=0xad24f36c, message2=0xad24f368, type=0xad24f364) at os/os0file.c:4207 #5 0x08534858 in fil_aio_wait (segment=0) at fil/fil0fil.c:4246 #6 0x08597235 in io_handler_thread (arg=0x8999be0) at srv/srv0start.c:435 #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 21 (Thread 0xac84eb90 (LWP 15243)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xab53190, mp=0xab53140, file=0x87abd99 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x08567792 in os_event_wait_low (event=0xab53140, reset_sig_count=0) at os/os0sync.c:422 #4 0x08565987 in os_aio_simulated_handle (global_segment=1, message1=0xac84e36c, message2=0xac84e368, type=0xac84e364) at os/os0file.c:4207 #5 0x08534858 in fil_aio_wait (segment=1) at fil/fil0fil.c:4246 #6 0x08597235 in io_handler_thread (arg=0x8999be4) at srv/srv0start.c:435 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 20 (Thread 0xabe4db90 (LWP 15244)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xab53230, mp=0xab531e0, file=0x87abd99 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x08567792 in os_event_wait_low (event=0xab531e0, reset_sig_count=0) at os/os0sync.c:422 #4 0x08565987 in os_aio_simulated_handle (global_segment=2, message1=0xabe4d36c, message2=0xabe4d368, type=0xabe4d364) at os/os0file.c:4207 #5 0x08534858 in fil_aio_wait (segment=2) at fil/fil0fil.c:4246 #6 0x08597235 in io_handler_thread (arg=0x8999be8) at srv/srv0start.c:435 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 19 (Thread 0xab44cb90 (LWP 15245)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xab532d0, mp=0xab53280, file=0x87abd99 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x08567792 in os_event_wait_low (event=0xab53280, reset_sig_count=0) at os/os0sync.c:422 #4 0x08565987 in os_aio_simulated_handle (global_segment=3, message1=0xab44c36c, message2=0xab44c368, type=0xab44c364) at os/os0file.c:4207 #5 0x08534858 in fil_aio_wait (segment=3) at fil/fil0fil.c:4246 #6 0x08597235 in io_handler_thread (arg=0x8999bec) at srv/srv0start.c:435 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 18 (Thread 0xaaa49b90 (LWP 15246)): #0 0x00110416 in __kernel_vsyscall () #1 0x004926e1 in select () from /lib/libc.so.6 #2 0x08567ad2 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 #3 0x08593d28 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1916 #4 0x0057d32f in start_thread () from /lib/libpthread.so.0 #5 0x0049a27e in clone () from /lib/libc.so.6 Thread 17 (Thread 0xaa048b90 (LWP 15247)): #0 0x00110416 in __kernel_vsyscall () #1 0x004926e1 in select () from /lib/libc.so.6 #2 0x08567ad2 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 ---Type to continue, or q to quit--- #3 0x085949d1 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2142 #4 0x0057d32f in start_thread () from /lib/libpthread.so.0 #5 0x0049a27e in clone () from /lib/libc.so.6 Thread 16 (Thread 0xa9442b90 (LWP 15249)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xa6a2620, mp=0xa6a25d0, file=0x87abd99 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x08567792 in os_event_wait_low (event=0xa6a25d0, reset_sig_count=0) at os/os0sync.c:422 #4 0x085936cc in srv_master_thread (arg=0x0) at srv/srv0srv.c:2631 #5 0x0057d32f in start_thread () from /lib/libpthread.so.0 #6 0x0049a27e in clone () from /lib/libc.so.6 Thread 15 (Thread 0xa7d8ab90 (LWP 15252)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580ec2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867234f in safe_cond_timedwait (cond=0x919aee0, mp=0x919ae80, abstime=0xa7d8a384, file=0x87cad79 "ma_checkpoint.c", line=705) at thr_mutex.c:289 #3 0x08640c6d in ma_checkpoint_background (arg=0x1e) at ma_checkpoint.c:705 #4 0x0057d32f in start_thread () from /lib/libpthread.so.0 #5 0x0049a27e in clone () from /lib/libc.so.6 Thread 14 (Thread 0xa800db90 (LWP 15255)): #0 0x00110416 in __kernel_vsyscall () #1 0x00584e30 in sigwait () from /lib/libpthread.so.0 #2 0x0822c9a6 in signal_hand (arg=0x0) at mysqld.cc:2864 #3 0x0057d32f in start_thread () from /lib/libpthread.so.0 #4 0x0049a27e in clone () from /lib/libc.so.6 Thread 13 (Thread 0xa7188b90 (LWP 16019)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xad026c4, mp=0xabe518c, file=0x87d35d6 "thr_lock.c", line=461) at thr_mutex.c:249 #3 0x08671880 in wait_for_lock (wait=0xabe51e0, data=0xa7023fac, in_wait_list=0 '\0') at thr_lock.c:461 #4 0x08671e11 in thr_lock (data=0xa7023fac, owner=0xa700ac6c, lock_type=TL_WRITE_ALLOW_WRITE) at thr_lock.c:749 #5 0x08671eda in thr_multi_lock (data=0xa7012508, count=2, owner=0xa700ac6c) at thr_lock.c:1007 #6 0x082265ef in mysql_lock_tables (thd=0xa700a458, tables=0xa70456a8, count=2, flags=, need_reopen=0xa7186e6b) at lock.cc:306 #7 0x08274753 in lock_tables (thd=0xa700a458, tables=0xa7083078, count=2, flags=0, need_reopen=0xa7186e6b) at sql_base.cc:4416 #8 0x0827dc74 in open_and_lock_tables_derived (thd=0xa700a458, tables=0xa7083078, derived=, flags=0) at sql_base.cc:4121 #9 0x0823ca31 in mysql_execute_command (thd=0xa700a458) at mysql_priv.h:1616 #10 0x0839f275 in sp_instr_stmt::exec_core (this=0xa70a3f98, thd=0xa700a458, nextp=0xa7187730) at sp_head.cc:2893 #11 0x0839f4c5 in sp_lex_keeper::reset_lex_and_exec_core (this=0xa70a3fc0, thd=0xa700a458, nextp=0xa7187730, open_tables=false, instr=0xa70a3f98) at sp_head.cc:2723 #12 0x083a4586 in sp_instr_stmt::execute (this=0xa70a3f98, thd=0xa700a458, nextp=0xa7187730) at sp_head.cc:2836 #13 0x083a27e1 in sp_head::execute (this=0xa70816c8, thd=0xa700a458) at sp_head.cc:1238 #14 0x083a31ee in sp_head::execute_procedure (this=0xa70816c8, thd=0xa700a458, args=0xa700bb00) at sp_head.cc:1971 ---Type to continue, or q to quit--- #15 0x0823f5c6 in mysql_execute_command (thd=0xa700a458) at sql_parse.cc:4273 #16 0x08243424 in mysql_parse (thd=0xa700a458, inBuf=0xac41818 "CALL delete_multi(@uuid)", length=24, found_semicolon=0xa7188314) at sql_parse.cc:5902 #17 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa700a458, packet=0xa702aab1 "CALL delete_multi(@uuid)", packet_length=24) at sql_parse.cc:1120 #18 0x08244e8c in do_command (thd=0xa700a458) at sql_parse.cc:807 #19 0x082350e0 in handle_one_connection (arg=0xa700a458) at sql_connect.cc:1153 #20 0x0057d32f in start_thread () from /lib/libpthread.so.0 #21 0x0049a27e in clone () from /lib/libc.so.6 Thread 12 (Thread 0xa6dcdb90 (LWP 16139)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xacc01a4, mp=0xabe518c, file=0x87d35d6 "thr_lock.c", line=461) at thr_mutex.c:249 #3 0x08671880 in wait_for_lock (wait=0xabe51e0, data=0xa70236e4, in_wait_list=0 '\0') at thr_lock.c:461 #4 0x08671e11 in thr_lock (data=0xa70236e4, owner=0xa700523c, lock_type=TL_WRITE_ALLOW_READ) at thr_lock.c:749 #5 0x08671eda in thr_multi_lock (data=0xa7061f54, count=1, owner=0xa700523c) at thr_lock.c:1007 #6 0x082265ef in mysql_lock_tables (thd=0xa7004a28, tables=0xa70552b0, count=1, flags=, need_reopen=0xa6dcb7bb) at lock.cc:306 #7 0x08274753 in lock_tables (thd=0xa7004a28, tables=0xad35da0, count=1, flags=32, need_reopen=0xa6dcb7bb) at sql_base.cc:4416 #8 0x0827dc74 in open_and_lock_tables_derived (thd=0xa7004a28, tables=0xad35da0, derived=, flags=32) at sql_base.cc:4121 #9 0x0827df00 in open_n_lock_single_table (thd=0xa7004a28, table_l=0xad35da0, lock_type=TL_WRITE_ALLOW_READ, flags=32) at sql_base.cc:3963 #10 0x08345a1f in mysql_alter_table (thd=0xa7004a28, new_db=0xad35fa0 "test", new_name=0x0, create_info=0xa6dcc858, table_list=0xad35da0, alter_info=0xa6dccd3c, order_num=0, order=0x0, ignore=false) at sql_table.cc:6458 #11 0x082412d1 in mysql_execute_command (thd=0xa7004a28) at sql_parse.cc:2762 #12 0x08243424 in mysql_parse (thd=0xa7004a28, inBuf=0xad35a98 "ALTER TABLE inter1 CHANGE t1_uuid t1_uuid VARCHAR(36)", length=53, found_semicolon=0xa6dcd314) at sql_parse.cc:5902 #13 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa7004a28, packet=0xa7006449 "ALTER TABLE inter1 CHANGE t1_uuid t1_uuid VARCHAR(36)", packet_length=53) at sql_parse.cc:1120 #14 0x08244e8c in do_command (thd=0xa7004a28) at sql_parse.cc:807 #15 0x082350e0 in handle_one_connection (arg=0xa7004a28) at sql_connect.cc:1153 #16 0x0057d32f in start_thread () from /lib/libpthread.so.0 #17 0x0049a27e in clone () from /lib/libc.so.6 Thread 11 (Thread 0xa7e03b90 (LWP 16179)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xac2048c, mp=0xabe518c, file=0x87d35d6 "thr_lock.c", line=461) at thr_mutex.c:249 #3 0x08671880 in wait_for_lock (wait=0xabe51e0, data=0xad038e4, in_wait_list=0 '\0') at thr_lock.c:461 #4 0x08671e11 in thr_lock (data=0xad038e4, owner=0xa702f2d4, lock_type=TL_WRITE_ALLOW_READ) at thr_lock.c:749 #5 0x08671eda in thr_multi_lock (data=0xad6ba4c, count=1, owner=0xa702f2d4) at thr_lock.c:1007 #6 0x082265ef in mysql_lock_tables (thd=0xa702eac0, tables=0xad71888, count=1, flags=, need_reopen=0xa7e017bb) at lock.cc:306 #7 0x08274753 in lock_tables (thd=0xa702eac0, tables=0xad6fd60, count=1, flags=32, need_reopen=0xa7e017bb) at sql_base.cc:4416 #8 0x0827dc74 in open_and_lock_tables_derived (thd=0xa702eac0, tables=0xad6fd60, derived=, flags=32) at sql_base.cc:4121 #9 0x0827df00 in open_n_lock_single_table (thd=0xa702eac0, table_l=0xad6fd60, lock_type=TL_WRITE_ALLOW_READ, flags=32) at sql_base.cc:3963 #10 0x08345a1f in mysql_alter_table (thd=0xa702eac0, new_db=0xad6ff60 "test", new_name=0x0, create_info=0xa7e02858, table_list=0xad6fd60, alter_info=0xa7e02d3c, order_num=0, order=0x0, ignore=false) at sql_table.cc:6458 #11 0x082412d1 in mysql_execute_command (thd=0xa702eac0) at sql_parse.cc:2762 ---Type to continue, or q to quit--- #12 0x08243424 in mysql_parse (thd=0xa702eac0, inBuf=0xad6fa78 "ALTER TABLE inter1 ADD KEY k1 (t1_uuid)", length=39, found_semicolon=0xa7e03314) at sql_parse.cc:5902 #13 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa702eac0, packet=0xa70304e1 "ALTER TABLE inter1 ADD KEY k1 (t1_uuid)", packet_length=39) at sql_parse.cc:1120 #14 0x08244e8c in do_command (thd=0xa702eac0) at sql_parse.cc:807 #15 0x082350e0 in handle_one_connection (arg=0xa702eac0) at sql_connect.cc:1153 #16 0x0057d32f in start_thread () from /lib/libpthread.so.0 #17 0x0049a27e in clone () from /lib/libc.so.6 Thread 10 (Thread 0xa6dfeb90 (LWP 16258)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xac17e8c, mp=0xabe518c, file=0x87d35d6 "thr_lock.c", line=461) at thr_mutex.c:249 #3 0x08671880 in wait_for_lock (wait=0xabe51e0, data=0xacf4e6c, in_wait_list=0 '\0') at thr_lock.c:461 #4 0x08671e11 in thr_lock (data=0xacf4e6c, owner=0xa701ccbc, lock_type=TL_WRITE_ALLOW_READ) at thr_lock.c:749 #5 0x08671eda in thr_multi_lock (data=0xac20744, count=1, owner=0xa701ccbc) at thr_lock.c:1007 #6 0x082265ef in mysql_lock_tables (thd=0xa701c4a8, tables=0xac955c0, count=1, flags=, need_reopen=0xa6dfc7bb) at lock.cc:306 #7 0x08274753 in lock_tables (thd=0xa701c4a8, tables=0xac626d0, count=1, flags=32, need_reopen=0xa6dfc7bb) at sql_base.cc:4416 #8 0x0827dc74 in open_and_lock_tables_derived (thd=0xa701c4a8, tables=0xac626d0, derived=, flags=32) at sql_base.cc:4121 #9 0x0827df00 in open_n_lock_single_table (thd=0xa701c4a8, table_l=0xac626d0, lock_type=TL_WRITE_ALLOW_READ, flags=32) at sql_base.cc:3963 #10 0x08345a1f in mysql_alter_table (thd=0xa701c4a8, new_db=0xac628d0 "test", new_name=0x0, create_info=0xa6dfd858, table_list=0xac626d0, alter_info=0xa6dfdd3c, order_num=0, order=0x0, ignore=false) at sql_table.cc:6458 #11 0x082412d1 in mysql_execute_command (thd=0xa701c4a8) at sql_parse.cc:2762 #12 0x08243424 in mysql_parse (thd=0xa701c4a8, inBuf=0xac623e8 "ALTER TABLE inter1 ENGINE = Innodb", length=34, found_semicolon=0xa6dfe314) at sql_parse.cc:5902 #13 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa701c4a8, packet=0xa7000469 "ALTER TABLE inter1 ENGINE = Innodb", packet_length=34) at sql_parse.cc:1120 #14 0x08244e8c in do_command (thd=0xa701c4a8) at sql_parse.cc:807 #15 0x082350e0 in handle_one_connection (arg=0xa701c4a8) at sql_connect.cc:1153 #16 0x0057d32f in start_thread () from /lib/libpthread.so.0 #17 0x0049a27e in clone () from /lib/libc.so.6 Thread 9 (Thread 0xa7fabb90 (LWP 16271)): #0 0x00110416 in __kernel_vsyscall () #1 0x00583c2b in read () from /lib/libpthread.so.0 #2 0x0864f7db in vio_read (vio=0xa70237b8, buf=0xa70344f0 "\a", size=4) at viosocket.c:44 #3 0x0822169a in my_real_read (net=0xa705eb94, complen=0xa7fab318) at net_serv.cc:811 #4 0x08221bcb in my_net_read (net=0xa705eb94) at net_serv.cc:992 #5 0x08244d0b in do_command (thd=0xa705eb00) at sql_parse.cc:753 #6 0x082350e0 in handle_one_connection (arg=0xa705eb00) at sql_connect.cc:1153 #7 0x0057d32f in start_thread () from /lib/libpthread.so.0 #8 0x0049a27e in clone () from /lib/libc.so.6 Thread 8 (Thread 0xa7e34b90 (LWP 16369)): #0 0x00110416 in __kernel_vsyscall () ---Type to continue, or q to quit--- #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0x88615a0, mp=0x8860e60, file=0x873e688 "sql_base.cc", line=7567) at thr_mutex.c:249 #3 0x0827cada in recover_from_failed_open_table_attempt (thd=0xa70165c8, table=0xac39ea0, action=OT_BACK_OFF_AND_RETRY) at sql_base.cc:7567 #4 0x0827d688 in open_tables (thd=0xa70165c8, start=0xa7e337c4, counter=0xa7e337a4, flags=0) at sql_base.cc:3697 #5 0x0827dbed in open_and_lock_tables_derived (thd=0xa70165c8, tables=0xac39998, derived=, flags=0) at sql_base.cc:4113 #6 0x0823afb6 in mysql_execute_command (thd=0xa70165c8) at mysql_priv.h:1616 #7 0x08243424 in mysql_parse (thd=0xa70165c8, inBuf=0xac39620 "CREATE TABLE IF NOT EXISTS interact_xml.inter1 ENGINE = Falcon SELECT * FROM test.inter1 LIMIT 0", length=96, found_semicolon=0xa7e34314) at sql_parse.cc:5902 #8 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa70165c8, packet=0xa7018401 "CREATE TABLE IF NOT EXISTS interact_xml.inter1 ENGINE = Falcon SELECT * FROM test.inter1 LIMIT 0", packet_length=96) at sql_parse.cc:1120 #9 0x08244e8c in do_command (thd=0xa70165c8) at sql_parse.cc:807 #10 0x082350e0 in handle_one_connection (arg=0xa70165c8) at sql_connect.cc:1153 #11 0x0057d32f in start_thread () from /lib/libpthread.so.0 #12 0x0049a27e in clone () from /lib/libc.so.6 Thread 7 (Thread 0xa7f7ab90 (LWP 16411)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0x88615a0, mp=0x8860e60, file=0x873e688 "sql_base.cc", line=7567) at thr_mutex.c:249 #3 0x0827cada in recover_from_failed_open_table_attempt (thd=0xa70f89b8, table=0xadb4368, action=OT_BACK_OFF_AND_RETRY) at sql_base.cc:7567 #4 0x0827d688 in open_tables (thd=0xa70f89b8, start=0xa7f797c4, counter=0xa7f797a4, flags=0) at sql_base.cc:3697 #5 0x0827dbed in open_and_lock_tables_derived (thd=0xa70f89b8, tables=0xacfa998, derived=, flags=0) at sql_base.cc:4113 #6 0x082414d1 in mysql_execute_command (thd=0xa70f89b8) at mysql_priv.h:1616 #7 0x08243424 in mysql_parse (thd=0xa70f89b8, inBuf=0xacfa650 "INSERT INTO view2 (t1_uuid) SELECT (SELECT t1_uuid FROM view1 WHERE t1_uuid = @uuid1)", length=85, found_semicolon=0xa7f7a314) at sql_parse.cc:5902 #8 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa70f89b8, packet=0xa70bb581 "INSERT INTO view2 (t1_uuid) SELECT (SELECT t1_uuid FROM view1 WHERE t1_uuid = @uuid1)", packet_length=85) at sql_parse.cc:1120 #9 0x08244e8c in do_command (thd=0xa70f89b8) at sql_parse.cc:807 #10 0x082350e0 in handle_one_connection (arg=0xa70f89b8) at sql_connect.cc:1153 #11 0x0057d32f in start_thread () from /lib/libpthread.so.0 #12 0x0049a27e in clone () from /lib/libc.so.6 Thread 6 (Thread 0xa7157b90 (LWP 16555)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0xa833ee0, mp=0xa833e90, file=0x87abd99 "os/os0sync.c", line=422) at thr_mutex.c:249 #3 0x08567792 in os_event_wait_low (event=0xa833e90, reset_sig_count=0) at os/os0sync.c:422 #4 0x08594dd0 in srv_suspend_mysql_thread (thr=0xadc1d6b8) at srv/srv0srv.c:1491 #5 0x0857c6cd in row_mysql_handle_errors (new_err=0xa71556fc, trx=0xadc14c68, thr=0xadc1d6b8, savept=0x0) at row/row0mysql.c:496 #6 0x0858956a in row_search_for_mysql (buf=0xad41ad8 "×æ\a", mode=1, prebuilt=0xadc1dc68, match_mode=0, direction=1) at row/row0sel.c:4455 #7 0x0850491c in ha_innobase::general_fetch (this=0xac73eb8, buf=0xad41ad8 "×æ\a", direction=1, match_mode=0) at handler/ha_innodb.cc:4420 #8 0x08504a43 in ha_innobase::rnd_next (this=0xac73eb8, buf=0xad41ad8 "×æ\a") at handler/ha_innodb.cc:4609 #9 0x083340bd in ha_partition::rnd_next (this=0xac73cb0, buf=0xad41ad8 "×æ\a") at ha_partition.cc:3297 ---Type to continue, or q to quit--- #10 0x0831d467 in rr_sequential (info=0xa7155d3c) at records.cc:385 #11 0x08348300 in mysql_alter_table (thd=0xa70895f0, new_db=0xac519b0 "test", new_name=0xac51788 "inter1", create_info=0xa7156858, table_list=0xac517b0, alter_info=0xa7156d3c, order_num=0, order=0x0, ignore=false) at sql_table.cc:7314 #12 0x082412d1 in mysql_execute_command (thd=0xa70895f0) at sql_parse.cc:2762 #13 0x08243424 in mysql_parse (thd=0xa70895f0, inBuf=0xac514c8 "ALTER TABLE inter1 DROP COLUMN filler", length=37, found_semicolon=0xa7157314) at sql_parse.cc:5902 #14 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa70895f0, packet=0xa70b1559 "ALTER TABLE inter1 DROP COLUMN filler", packet_length=37) at sql_parse.cc:1120 #15 0x08244e8c in do_command (thd=0xa70895f0) at sql_parse.cc:807 #16 0x082350e0 in handle_one_connection (arg=0xa70895f0) at sql_connect.cc:1153 #17 0x0057d32f in start_thread () from /lib/libpthread.so.0 #18 0x0049a27e in clone () from /lib/libc.so.6 Thread 5 (Thread 0xa6d9cb90 (LWP 16583)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0x88615a0, mp=0x8860e60, file=0x873e688 "sql_base.cc", line=7567) at thr_mutex.c:249 #3 0x0827cada in recover_from_failed_open_table_attempt (thd=0xa70106e8, table=0xad06f38, action=OT_BACK_OFF_AND_RETRY) at sql_base.cc:7567 #4 0x0827d688 in open_tables (thd=0xa70106e8, start=0xa6d9af44, counter=0xa6d9af30, flags=0) at sql_base.cc:3697 #5 0x0827db52 in open_normal_and_derived_tables (thd=0xa70106e8, tables=0xad06f38, flags=0) at sql_base.cc:4162 #6 0x0836270f in mysqld_show_create (thd=0xa70106e8, table_list=0xad06f38) at sql_show.cc:508 #7 0x0823bba7 in mysql_execute_command (thd=0xa70106e8) at sql_parse.cc:2873 #8 0x08243424 in mysql_parse (thd=0xa70106e8, inBuf=0xad06c60 "show create table inter1", length=24, found_semicolon=0xa6d9c314) at sql_parse.cc:5902 #9 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa70106e8, packet=0xa708b5c1 "show create table inter1", packet_length=24) at sql_parse.cc:1120 #10 0x08244e8c in do_command (thd=0xa70106e8) at sql_parse.cc:807 #11 0x082350e0 in handle_one_connection (arg=0xa70106e8) at sql_connect.cc:1153 #12 0x0057d32f in start_thread () from /lib/libpthread.so.0 #13 0x0049a27e in clone () from /lib/libc.so.6 Thread 4 (Thread 0xa7e65b90 (LWP 16619)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0x88615a0, mp=0x8860e60, file=0x873e688 "sql_base.cc", line=7567) at thr_mutex.c:249 #3 0x0827cada in recover_from_failed_open_table_attempt (thd=0xa7045d20, table=0xac2c300, action=OT_BACK_OFF_AND_RETRY) at sql_base.cc:7567 #4 0x0827d688 in open_tables (thd=0xa7045d20, start=0xa7e64364, counter=0xa7e64344, flags=0) at sql_base.cc:3697 #5 0x0827dbed in open_and_lock_tables_derived (thd=0xa7045d20, tables=0xacfa1c8, derived=, flags=0) at sql_base.cc:4113 #6 0x08238d6a in execute_sqlcom_select (thd=0xa7045d20, all_tables=0xacfa1c8) at mysql_priv.h:1616 #7 0x0823a484 in mysql_execute_command (thd=0xa7045d20) at sql_parse.cc:2153 #8 0x08243424 in mysql_parse (thd=0xa7045d20, inBuf=0xacf8530 "SELECT (SELECT t1_uuid FROM view1 AS x LIMIT 1) AS a FROM (SELECT t1_uuid FROM view2 AS y LIMIT 1) AS b WHERE 0 = (SELECT 0 FROM view1 AS z LIMIT 1) LIMIT 1", length=156, found_semicolon=0xa7e65314) at sql_parse.cc:5902 #9 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa7045d20, packet=0xa7012521 "SELECT (SELECT t1_uuid FROM view1 AS x LIMIT 1) AS a FROM (SELECT t1_uuid FROM view2 AS y LIMIT 1) AS b WHERE 0 = (SELECT 0 FROM view1 AS z LIMIT 1) LIMIT 1", packet_length=156) at sql_parse.cc:1120 #10 0x08244e8c in do_command (thd=0xa7045d20) at sql_parse.cc:807 ---Type to continue, or q to quit--- #11 0x082350e0 in handle_one_connection (arg=0xa7045d20) at sql_connect.cc:1153 #12 0x0057d32f in start_thread () from /lib/libpthread.so.0 #13 0x0049a27e in clone () from /lib/libc.so.6 Thread 3 (Thread 0xa7fdcb90 (LWP 16698)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0x88615a0, mp=0x8860e60, file=0x873e688 "sql_base.cc", line=7567) at thr_mutex.c:249 #3 0x0827cada in recover_from_failed_open_table_attempt (thd=0xa70ad588, table=0xac714e8, action=OT_BACK_OFF_AND_RETRY) at sql_base.cc:7567 #4 0x0827d688 in open_tables (thd=0xa70ad588, start=0xa7fdb7c4, counter=0xa7fdb7a4, flags=32) at sql_base.cc:3697 #5 0x0827dbed in open_and_lock_tables_derived (thd=0xa70ad588, tables=0xac714e8, derived=, flags=32) at sql_base.cc:4113 #6 0x0823d301 in mysql_execute_command (thd=0xa70ad588) at sql_parse.cc:3474 #7 0x08243424 in mysql_parse (thd=0xa70ad588, inBuf=0xac711f0 "LOCK TABLES `inter1` READ /*!32311 LOCAL */", length=43, found_semicolon=0xa7fdc314) at sql_parse.cc:5902 #8 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa70ad588, packet=0xa701e499 "LOCK TABLES `inter1` READ /*!32311 LOCAL */", packet_length=43) at sql_parse.cc:1120 #9 0x08244e8c in do_command (thd=0xa70ad588) at sql_parse.cc:807 #10 0x082350e0 in handle_one_connection (arg=0xa70ad588) at sql_connect.cc:1153 #11 0x0057d32f in start_thread () from /lib/libpthread.so.0 #12 0x0049a27e in clone () from /lib/libc.so.6 Thread 2 (Thread 0xa6d6bb90 (LWP 16704)): #0 0x00110416 in __kernel_vsyscall () #1 0x00580b95 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x0867250a in safe_cond_wait (cond=0x88615a0, mp=0x8860e60, file=0x873e688 "sql_base.cc", line=7567) at thr_mutex.c:249 #3 0x0827cada in recover_from_failed_open_table_attempt (thd=0xa7095600, table=0xacede50, action=OT_BACK_OFF_AND_RETRY) at sql_base.cc:7567 #4 0x0827d688 in open_tables (thd=0xa7095600, start=0xa6d6a654, counter=0xa6d6a634, flags=0) at sql_base.cc:3697 #5 0x0827dbed in open_and_lock_tables_derived (thd=0xa7095600, tables=0xacec618, derived=, flags=0) at sql_base.cc:4113 #6 0x082b59d4 in mysql_insert (thd=0xa7095600, table_list=0xacec618, fields=@0xa7096c9c, values_list=@0xa7096cc0, update_fields=@0xa7096cb4, update_values=@0xa7096ca8, duplic=DUP_ERROR, ignore=false) at mysql_priv.h:1616 #7 0x0824148e in mysql_execute_command (thd=0xa7095600) at sql_parse.cc:3081 #8 0x08243424 in mysql_parse (thd=0xa7095600, inBuf=0xacec320 "INSERT INTO view1 (t1_uuid) VALUES (@uuid)", length=42, found_semicolon=0xa6d6b314) at sql_parse.cc:5902 #9 0x08243d12 in dispatch_command (command=COM_QUERY, thd=0xa7095600, packet=0xa70da9a1 "INSERT INTO view1 (t1_uuid) VALUES (@uuid)", packet_length=42) at sql_parse.cc:1120 #10 0x08244e8c in do_command (thd=0xa7095600) at sql_parse.cc:807 #11 0x082350e0 in handle_one_connection (arg=0xa7095600) at sql_connect.cc:1153 #12 0x0057d32f in start_thread () from /lib/libpthread.so.0 #13 0x0049a27e in clone () from /lib/libc.so.6 Thread 1 (Thread 0xb7f846d0 (LWP 15193)): #0 0x00110416 in __kernel_vsyscall () #1 0x004926e1 in select () from /lib/libc.so.6 #2 0x0822d69a in handle_connections_sockets (arg=0x0) at mysqld.cc:5094 #3 0x08230e7b in main (argc=25165824, argv=0x0) at mysqld.cc:4602