Bug#52367 - Deadlock involving SET GLOBAL EVENT_SCHEDULER = OFF during rqg_mdl_deadlock test Full set of backtraces from gdb, linux 32-bit (nanna21). Thread 26 (process 14625): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4ed6c, mp=0x9b4ed20, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4ed20, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=0, message1=0xb7fe837c, message2=0xb7fe8378, type=0xb7fe8374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=0) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b40) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 25 (process 14626): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4edf4, mp=0x9b4eda8, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4eda8, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=1, message1=0xae6a037c, message2=0xae6a0378, type=0xae6a0374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=1) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b44) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 24 (process 14627): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4ee7c, mp=0x9b4ee30, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4ee30, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=2, message1=0xadc9f37c, message2=0xadc9f378, type=0xadc9f374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=2) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b48) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 23 (process 14628): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4ef04, mp=0x9b4eeb8, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4eeb8, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=3, message1=0xad29e37c, message2=0xad29e378, type=0xad29e374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=3) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b4c) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 22 (process 14629): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4ef8c, mp=0x9b4ef40, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4ef40, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=4, message1=0xac89d37c, message2=0xac89d378, type=0xac89d374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=4) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b50) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 21 (process 14630): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4f014, mp=0x9b4efc8, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4efc8, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=5, message1=0xabe9c37c, message2=0xabe9c378, type=0xabe9c374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=5) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b54) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 20 (process 14631): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4f09c, mp=0x9b4f050, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4f050, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=6, message1=0xab49b37c, message2=0xab49b378, type=0xab49b374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=6) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b58) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 19 (process 14632): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4f124, mp=0x9b4f0d8, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4f0d8, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=7, message1=0xaaa9a37c, message2=0xaaa9a378, type=0xaaa9a374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=7) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b5c) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 18 (process 14633): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4f1ac, mp=0x9b4f160, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4f160, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=8, message1=0xaa09937c, message2=0xaa099378, type=0xaa099374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=8) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b60) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 17 (process 14634): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9b4f234, mp=0x9b4f1e8, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x9b4f1e8, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x085727ee in os_aio_simulated_handle (global_segment=9, message1=0xa969837c, message2=0xa9698378, type=0xa9698374) at mysql-5.5.4-m3/storage/innobase/os/os0file.c:4197 #5 0x0853e020 in fil_aio_wait (segment=9) at mysql-5.5.4-m3/storage/innobase/fil/fil0fil.c:4450 #6 0x084d6781 in io_handler_thread (arg=0x8ad6b64) at mysql-5.5.4-m3/storage/innobase/srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x007f1c4e in clone () from /lib/libc.so.6 Thread 16 (process 14635): #0 0x0025f402 in __kernel_vsyscall () #1 0x007eaa31 in select () from /lib/libc.so.6 #2 0x085743c8 in os_thread_sleep (tm=1000000) at mysql-5.5.4-m3/storage/innobase/os/os0thread.c:281 #3 0x084d4cbe in srv_lock_timeout_and_monitor_thread (arg=0x0) at mysql-5.5.4-m3/storage/innobase/srv/srv0srv.c:1984 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 #5 0x007f1c4e in clone () from /lib/libc.so.6 Thread 15 (process 14636): #0 0x0025f402 in __kernel_vsyscall () #1 0x007eaa31 in select () from /lib/libc.so.6 #2 0x085743c8 in os_thread_sleep (tm=1000000) at mysql-5.5.4-m3/storage/innobase/os/os0thread.c:281 #3 0x084d52a6 in srv_error_monitor_thread (arg=0x0) at mysql-5.5.4-m3/storage/innobase/srv/srv0srv.c:2220 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 #5 0x007f1c4e in clone () from /lib/libc.so.6 Thread 14 (process 14637): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x972bff4, mp=0x972bfa8, file=0x87d2408 "mysql-5.5.4-m3/storage/innobase/os/os0sync.c", line=399) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08573b9e in os_event_wait_low (event=0x972bfa8, reset_sig_count=0) at mysql-5.5.4-m3/storage/innobase/os/os0sync.c:399 #4 0x084d5f9b in srv_master_thread (arg=0x0) at mysql-5.5.4-m3/storage/innobase/srv/srv0srv.c:2740 #5 0x0089a45b in start_thread () from /lib/libpthread.so.0 #6 0x007f1c4e in clone () from /lib/libc.so.6 Thread 13 (process 14638): #0 0x0025f402 in __kernel_vsyscall () #1 0x008a1f6e in do_sigwait () from /lib/libpthread.so.0 #2 0x008a200f in sigwait () from /lib/libpthread.so.0 #3 0x08144f2f in signal_hand (arg=0x0) at mysql-5.5.4-m3/sql/mysqld.cc:2950 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 #5 0x007f1c4e in clone () from /lib/libc.so.6 Thread 12 (process 14639): #0 0x0025f402 in __kernel_vsyscall () #1 0x008a0e1b in read () from /lib/libpthread.so.0 #2 0x086851ed in vio_read (vio=0xa016860, buf=0xa03e620 "\a", size=4) at mysql-5.5.4-m3/vio/viosocket.c:44 #3 0x0814d3af in my_real_read (net=0x9727054, complen=0xa6bd52d8) at mysql-5.5.4-m3/sql/net_serv.cc:836 #4 0x0814d89e in my_net_read (net=0x9727054) at mysql-5.5.4-m3/sql/net_serv.cc:1026 #5 0x081e401a in do_command (thd=0x9726e98) at mysql-5.5.4-m3/sql/sql_parse.cc:656 #6 0x082b1762 in do_handle_one_connection (thd_arg=0x9726e98) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #7 0x082b182d in handle_one_connection (arg=0x9726e98) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 #9 0x007f1c4e in clone () from /lib/libc.so.6 Thread 11 (process 19932): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647bc7 in safe_cond_timedwait (cond=0xa6a6ee7c, mp=0xa6a6ee38, abstime=0xa699be74, file=0x8724568 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1092) at mysql-5.5.4-m3/mysys/thr_mutex.c:278 #3 0x082bab8a in inline_mysql_cond_timedwait (that=0xa6a6ee7c, mutex=0xa6a6ee38, abstime=0xa699be74, src_file=0x8724264 "mysql-5.5.4-m3/sql/mdl.cc", src_line=883) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1092 #4 0x082bac79 in MDL_context::timed_wait (this=0xa6a6ed70, abs_timeout=0xa699be74) at mysql-5.5.4-m3/sql/mdl.cc:882 #5 0x082bc379 in MDL_context::acquire_lock_impl (this=0xa6a6ed70, mdl_request=0xa17a264, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:1555 #6 0x082bc8da in MDL_context::acquire_locks (this=0xa6a6ed70, mdl_requests=0xa699c0b8, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:1654 #7 0x083f9f37 in lock_table_names (thd=0xa6a6ed00, table_list=0xa17a070) at mysql-5.5.4-m3/sql/lock.cc:901 #8 0x081d8f07 in flush_tables (thd=0xa6a6ed00, all_tables=0xa17a070) at mysql-5.5.4-m3/sql/sql_parse.cc:1812 #9 0x081df11d in mysql_execute_command (thd=0xa6a6ed00) at mysql-5.5.4-m3/sql/sql_parse.cc:4003 #10 0x081e1b35 in mysql_parse (thd=0xa6a6ed00, inBuf=0xa179f68 "FLUSH TABLE testdb_N . t1_base1_N , testdb_N . t1_view1_N", length=58, found_semicolon=0xa699d248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #11 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa6a6ed00, packet=0xa6a18211 "FLUSH TABLE testdb_N . t1_base1_N , testdb_N . t1_view1_N ", packet_length=59) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #12 0x081e41dc in do_command (thd=0xa6a6ed00) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #13 0x082b1762 in do_handle_one_connection (thd_arg=0xa6a6ed00) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #14 0x082b182d in handle_one_connection (arg=0xa6a6ed00) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #15 0x0089a45b in start_thread () from /lib/libpthread.so.0 #16 0x007f1c4e in clone () from /lib/libc.so.6 Thread 10 (process 20293): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647bc7 in safe_cond_timedwait (cond=0xa6511a3c, mp=0xa65119f8, abstime=0xa67fd8a0, file=0x8724568 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1092) at mysql-5.5.4-m3/mysys/thr_mutex.c:278 #3 0x082bab8a in inline_mysql_cond_timedwait (that=0xa6511a3c, mutex=0xa65119f8, abstime=0xa67fd8a0, src_file=0x8724264 "mysql-5.5.4-m3/sql/mdl.cc", src_line=883) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1092 #4 0x082bac79 in MDL_context::timed_wait (this=0xa6511930, abs_timeout=0xa67fd8a0) at mysql-5.5.4-m3/sql/mdl.cc:882 #5 0x082bbe17 in MDL_context::wait_for_lock (this=0xa6511930, mdl_request=0xa06bd84, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:2022 #6 0x0818ff04 in Open_table_context::recover_from_failed_open ( this=0xa67fdcb8, thd=0xa65118c0, mdl_request=0xa06bd84, table=0xa06bb90) at mysql-5.5.4-m3/sql/sql_base.cc:3908 #7 0x08192822 in open_tables (thd=0xa65118c0, start=0xa67fe114, counter=0xa67fe088, flags=0, prelocking_strategy=0xa67fdd2c) at mysql-5.5.4-m3/sql/sql_base.cc:4697 #8 0x0819610f in open_tables (thd=0xa65118c0, tables=0xa67fe114, counter=0xa67fe088, flags=0) at mysql-5.5.4-m3/sql/mysql_priv.h:1575 #9 0x08272989 in mysql_update (thd=0xa65118c0, table_list=0xa06bb90, fields=@0xa6512da8, values=@0xa6512fc0, conds=0xa06c410, order_num=0, order=0x0, limit=1, handle_duplicates=DUP_ERROR, ignore=false, found_return=0xa67fead0, updated_return=0xa67feac8) at mysql-5.5.4-m3/sql/sql_update.cc:212 #10 0x081dbf48 in mysql_execute_command (thd=0xa65118c0) at mysql-5.5.4-m3/sql/sql_parse.cc:3123 #11 0x081e1b35 in mysql_parse (thd=0xa65118c0, inBuf=0xa06ba50 "UPDATE testdb_S . t1_base2_N SET `pk` = 0 WHERE SLEEP( 0.5 * 0.18 * 1 ) = 0 LIMIT 1", length=86, found_semicolon=0xa67ff248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #12 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa65118c0, packet=0xa6535e49 "UPDATE testdb_S . t1_base2_N SET `pk` = 0 WHERE SLEEP( 0.5 * 0.18 * 1 ) = 0 LIMIT 1", packet_length=86) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #13 0x081e41dc in do_command (thd=0xa65118c0) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #14 0x082b1762 in do_handle_one_connection (thd_arg=0xa65118c0) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #15 0x082b182d in handle_one_connection (arg=0xa65118c0) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #16 0x0089a45b in start_thread () from /lib/libpthread.so.0 #17 0x007f1c4e in clone () from /lib/libc.so.6 Thread 9 (process 20302): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647a0a in safe_cond_wait (cond=0x9fd2174, mp=0x9fd2128, file=0x87a4c14 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1064) at mysql-5.5.4-m3/mysys/thr_mutex.c:240 #3 0x08488951 in inline_mysql_cond_wait (that=0x9fd2174, mutex=0x9fd2128, src_file=0x87a4c78 "mysql-5.5.4-m3/sql/event_scheduler.cc", src_line=765) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1064 #4 0x08488ddb in Event_scheduler::cond_wait (this=0x9fd2128, thd=0xa6517880, abstime=0x0, msg=0x87a4fbb "Waiting scheduler to stop", func=0x87a5488 "stop", line=658) at mysql-5.5.4-m3/sql/event_scheduler.cc:765 #5 0x084894a0 in Event_scheduler::stop (this=0x9fd2128) at mysql-5.5.4-m3/sql/event_scheduler.cc:658 #6 0x082986c2 in Events::stop () at mysql-5.5.4-m3/sql/events.cc:1043 #7 0x082d264e in event_scheduler_update (self=0x8acbe80, thd=0xa6517880, type=OPT_GLOBAL) at mysql-5.5.4-m3/sql/sys_vars.cc:670 #8 0x0815a883 in sys_var::update (this=0x8acbe80, thd=0xa6517880, var=0xa008f30) at mysql-5.5.4-m3/sql/set_var.cc:174 #9 0x0815c4b8 in set_var::update (this=0xa008f30, thd=0xa6517880) at mysql-5.5.4-m3/sql/set_var.cc:641 #10 0x0815b217 in sql_set_variables (thd=0xa6517880, var_list=0xa6518fa4) at mysql-5.5.4-m3/sql/set_var.cc:545 #11 0x081dd450 in mysql_execute_command (thd=0xa6517880) at mysql-5.5.4-m3/sql/sql_parse.cc:3507 #12 0x081e1b35 in mysql_parse (thd=0xa6517880, inBuf=0xa008df8 "SET GLOBAL EVENT_SCHEDULER = OFF", length=32, found_semicolon=0xa69ce248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #13 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa6517880, packet=0xa657a069 "SET GLOBAL EVENT_SCHEDULER = OFF", packet_length=32) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #14 0x081e41dc in do_command (thd=0xa6517880) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #15 0x082b1762 in do_handle_one_connection (thd_arg=0xa6517880) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #16 0x082b182d in handle_one_connection (arg=0xa6517880) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #17 0x0089a45b in start_thread () from /lib/libpthread.so.0 #18 0x007f1c4e in clone () from /lib/libc.so.6 Thread 8 (process 20304): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647bc7 in safe_cond_timedwait (cond=0xa651a054, mp=0xa651a010, abstime=0xa6b407a0, file=0x8724568 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1092) at mysql-5.5.4-m3/mysys/thr_mutex.c:278 #3 0x082bab8a in inline_mysql_cond_timedwait (that=0xa651a054, mutex=0xa651a010, abstime=0xa6b407a0, src_file=0x8724264 "mysql-5.5.4-m3/sql/mdl.cc", src_line=883) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1092 #4 0x082bac79 in MDL_context::timed_wait (this=0xa6519f48, abs_timeout=0xa6b407a0) at mysql-5.5.4-m3/sql/mdl.cc:882 #5 0x082bbe17 in MDL_context::wait_for_lock (this=0xa6519f48, mdl_request=0xa0d04ac, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:2022 #6 0x0818ff04 in Open_table_context::recover_from_failed_open ( this=0xa6b40bb8, thd=0xa6519ed8, mdl_request=0xa0d04ac, table=0xa0d02b8) at mysql-5.5.4-m3/sql/sql_base.cc:3908 #7 0x08192822 in open_tables (thd=0xa6519ed8, start=0xa6b40c54, counter=0xa6b40c3c, flags=0, prelocking_strategy=0xa6b40c7c) at mysql-5.5.4-m3/sql/sql_base.cc:4697 #8 0x08192ce0 in open_and_lock_tables (thd=0xa6519ed8, tables=0xa0d02b8, derived=true, flags=0, prelocking_strategy=0xa6b40c7c) at mysql-5.5.4-m3/sql/sql_base.cc:5238 #9 0x081823ae in open_and_lock_tables (thd=0xa6519ed8, tables=0xa0d02b8, derived=true, flags=0) at mysql-5.5.4-m3/sql/mysql_priv.h:1587 #10 0x081d861c in execute_sqlcom_select (thd=0xa6519ed8, all_tables=0xa0d02b8) at mysql-5.5.4-m3/sql/sql_parse.cc:4805 #11 0x081d9c51 in mysql_execute_command (thd=0xa6519ed8) at mysql-5.5.4-m3/sql/sql_parse.cc:2325 #12 0x081e1b35 in mysql_parse (thd=0xa6519ed8, inBuf=0xa0cfeb8 "SELECT `col_int_key` , `col_int` , `pk` FROM testdb_S . t1_base2_N AS A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_N . t1_merge1_N AS B WHERE B.`pk` = 7 )", length=158, found_semicolon=0xa6b42248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #13 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa6519ed8, packet=0xa6568069 "SELECT `col_int_key` , `col_int` , `pk` FROM testdb_S . t1_base2_N AS A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_N . t1_merge1_N AS B WHERE B.`pk` = 7 ) ", packet_length=161) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #14 0x081e41dc in do_command (thd=0xa6519ed8) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #15 0x082b1762 in do_handle_one_connection (thd_arg=0xa6519ed8) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #16 0x082b182d in handle_one_connection (arg=0xa6519ed8) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #17 0x0089a45b in start_thread () from /lib/libpthread.so.0 #18 0x007f1c4e in clone () from /lib/libc.so.6 Thread 7 (process 20312): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647bc7 in safe_cond_timedwait (cond=0xa65661e4, mp=0xa65661a0, abstime=0xa69fda74, file=0x8724568 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1092) at mysql-5.5.4-m3/mysys/thr_mutex.c:278 #3 0x082bab8a in inline_mysql_cond_timedwait (that=0xa65661e4, mutex=0xa65661a0, abstime=0xa69fda74, src_file=0x8724264 "mysql-5.5.4-m3/sql/mdl.cc", src_line=883) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1092 #4 0x082bac79 in MDL_context::timed_wait (this=0xa65660d8, abs_timeout=0xa69fda74) at mysql-5.5.4-m3/sql/mdl.cc:882 #5 0x082bc379 in MDL_context::acquire_lock_impl (this=0xa65660d8, mdl_request=0xa0c859c, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:1555 #6 0x082bc8da in MDL_context::acquire_locks (this=0xa65660d8, mdl_requests=0xa69fdb08, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:1654 #7 0x0818b49f in open_table_get_mdl_lock (thd=0xa6566068, table_list=0xa0c83a8, mdl_request=0xa0c859c, ot_ctx=0xa69fe038, flags=0) at mysql-5.5.4-m3/sql/sql_base.cc:2426 #8 0x08190d2b in open_table (thd=0xa6566068, table_list=0xa0c83a8, mem_root=0xa69fe004, ot_ctx=0xa69fe038, flags=0) at mysql-5.5.4-m3/sql/sql_base.cc:2737 #9 0x08192102 in open_and_process_table (thd=0xa6566068, lex=0xa6567034, tables=0xa0c83a8, counter=0xa69fe0bc, flags=0, prelocking_strategy=0xa69fe0fc, has_prelocking_list=false, ot_ctx=0xa69fe038, new_frm_mem=0xa69fe004) at mysql-5.5.4-m3/sql/sql_base.cc:4268 #10 0x081927b7 in open_tables (thd=0xa6566068, start=0xa69fe0d4, counter=0xa69fe0bc, flags=0, prelocking_strategy=0xa69fe0fc) at mysql-5.5.4-m3/sql/sql_base.cc:4668 #11 0x08192ce0 in open_and_lock_tables (thd=0xa6566068, tables=0xa0c83a8, derived=true, flags=0, prelocking_strategy=0xa69fe0fc) at mysql-5.5.4-m3/sql/sql_base.cc:5238 #12 0x081823ae in open_and_lock_tables (thd=0xa6566068, tables=0xa0c83a8, derived=true, flags=0) at mysql-5.5.4-m3/sql/mysql_priv.h:1587 #13 0x081da8b8 in mysql_execute_command (thd=0xa6566068) at mysql-5.5.4-m3/sql/sql_parse.cc:2682 #14 0x081e1b35 in mysql_parse (thd=0xa6566068, inBuf=0xa0c81d8 "CREATE TABLE IF NOT EXISTS testdb_S . t1_base2_N AS SELECT `col_int` , `pk` , `col_int_key` FROM testdb_S . t1_base2_S A WHERE `pk` BETWEEN 0 AND 0 + 1", length=157, found_semicolon=0xa69ff248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #15 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa6566068, packet=0xa6576019 "CREATE TABLE IF NOT EXISTS testdb_S . t1_base2_N AS SELECT `col_int` , `pk` , `col_int_key` FROM testdb_S . t1_base2_S A WHERE `pk` BETWEEN 0 AND 0 + 1", packet_length=157) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #16 0x081e41dc in do_command (thd=0xa6566068) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #17 0x082b1762 in do_handle_one_connection (thd_arg=0xa6566068) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #18 0x082b182d in handle_one_connection (arg=0xa6566068) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #19 0x0089a45b in start_thread () from /lib/libpthread.so.0 #20 0x007f1c4e in clone () from /lib/libc.so.6 Thread 6 (process 20313): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647bc7 in safe_cond_timedwait (cond=0xa651bd54, mp=0xa651bd10, abstime=0xa696a7a0, file=0x8724568 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1092) at mysql-5.5.4-m3/mysys/thr_mutex.c:278 #3 0x082bab8a in inline_mysql_cond_timedwait (that=0xa651bd54, mutex=0xa651bd10, abstime=0xa696a7a0, src_file=0x8724264 "mysql-5.5.4-m3/sql/mdl.cc", src_line=883) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1092 #4 0x082bac79 in MDL_context::timed_wait (this=0xa651bc48, abs_timeout=0xa696a7a0) at mysql-5.5.4-m3/sql/mdl.cc:882 #5 0x082bbe17 in MDL_context::wait_for_lock (this=0xa651bc48, mdl_request=0xa0aaddc, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:2022 #6 0x0818ff04 in Open_table_context::recover_from_failed_open ( this=0xa696abb8, thd=0xa651bbd8, mdl_request=0xa0aaddc, table=0xa0aabe8) at mysql-5.5.4-m3/sql/sql_base.cc:3908 #7 0x08192822 in open_tables (thd=0xa651bbd8, start=0xa696ac54, counter=0xa696ac3c, flags=0, prelocking_strategy=0xa696ac7c) at mysql-5.5.4-m3/sql/sql_base.cc:4697 #8 0x08192ce0 in open_and_lock_tables (thd=0xa651bbd8, tables=0xa0aabe8, derived=true, flags=0, prelocking_strategy=0xa696ac7c) at mysql-5.5.4-m3/sql/sql_base.cc:5238 #9 0x081823ae in open_and_lock_tables (thd=0xa651bbd8, tables=0xa0aabe8, derived=true, flags=0) at mysql-5.5.4-m3/sql/mysql_priv.h:1587 #10 0x081d861c in execute_sqlcom_select (thd=0xa651bbd8, all_tables=0xa0aabe8) at mysql-5.5.4-m3/sql/sql_parse.cc:4805 #11 0x081d9c51 in mysql_execute_command (thd=0xa651bbd8) at mysql-5.5.4-m3/sql/sql_parse.cc:2325 #12 0x081e1b35 in mysql_parse (thd=0xa651bbd8, inBuf=0xa0aa7d0 "SELECT `pk` , `col_int_key` , `pk` FROM testdb_N . t1_view2_N A PROCEDURE ANALYSE( 10 , 2000 ) UNION SELECT * FROM testdb_S . t1_merge2_S AS B WHERE `pk` BETWEEN 3 AND 3 + 1", length=179, found_semicolon=0xa696c248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #13 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa651bbd8, packet=0xa65135c1 "SELECT `pk` , `col_int_key` , `pk` FROM testdb_N . t1_view2_N A PROCEDURE ANALYSE( 10 , 2000 ) UNION SELECT * FROM testdb_S . t1_merge2_S AS B WHERE `pk` BETWEEN 3 AND 3 + 1 ", packet_length=181) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #14 0x081e41dc in do_command (thd=0xa651bbd8) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #15 0x082b1762 in do_handle_one_connection (thd_arg=0xa651bbd8) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #16 0x082b182d in handle_one_connection (arg=0xa651bbd8) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #17 0x0089a45b in start_thread () from /lib/libpthread.so.0 #18 0x007f1c4e in clone () from /lib/libc.so.6 Thread 5 (process 20317): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647bc7 in safe_cond_timedwait (cond=0xa655ea34, mp=0xa655e9f0, abstime=0xa6b71a24, file=0x8724568 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1092) at mysql-5.5.4-m3/mysys/thr_mutex.c:278 #3 0x082bab8a in inline_mysql_cond_timedwait (that=0xa655ea34, mutex=0xa655e9f0, abstime=0xa6b71a24, src_file=0x8724264 "mysql-5.5.4-m3/sql/mdl.cc", src_line=883) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1092 #4 0x082bac79 in MDL_context::timed_wait (this=0xa655e928, abs_timeout=0xa6b71a24) at mysql-5.5.4-m3/sql/mdl.cc:882 #5 0x082bc379 in MDL_context::acquire_lock_impl (this=0xa655e928, mdl_request=0xa06fd5c, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:1555 #6 0x082bc8da in MDL_context::acquire_locks (this=0xa655e928, mdl_requests=0xa6b71c68, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:1654 #7 0x083f9f37 in lock_table_names (thd=0xa655e8b8, table_list=0xa06fb68) at mysql-5.5.4-m3/sql/lock.cc:901 #8 0x08275d72 in mysql_drop_view (thd=0xa655e8b8, views=0xa06fb68, drop_mode=DROP_RESTRICT) at mysql-5.5.4-m3/sql/sql_view.cc:1611 #9 0x081e0fea in mysql_execute_command (thd=0xa655e8b8) at mysql-5.5.4-m3/sql/sql_parse.cc:4590 #10 0x081e1b35 in mysql_parse (thd=0xa655e8b8, inBuf=0xa06fa80 "DROP VIEW testdb_N . t1_view2_N RESTRICT", length=42, found_semicolon=0xa6b73248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #11 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa655e8b8, packet=0xa6500661 "DROP VIEW testdb_N . t1_view2_N RESTRICT", packet_length=42) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #12 0x081e41dc in do_command (thd=0xa655e8b8) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #13 0x082b1762 in do_handle_one_connection (thd_arg=0xa655e8b8) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #14 0x082b182d in handle_one_connection (arg=0xa655e8b8) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #15 0x0089a45b in start_thread () from /lib/libpthread.so.0 #16 0x007f1c4e in clone () from /lib/libc.so.6 Thread 4 (process 20318): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647bc7 in safe_cond_timedwait (cond=0xa654e7bc, mp=0xa654e778, abstime=0xa67397a0, file=0x8724568 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1092) at mysql-5.5.4-m3/mysys/thr_mutex.c:278 #3 0x082bab8a in inline_mysql_cond_timedwait (that=0xa654e7bc, mutex=0xa654e778, abstime=0xa67397a0, src_file=0x8724264 "mysql-5.5.4-m3/sql/mdl.cc", src_line=883) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1092 #4 0x082bac79 in MDL_context::timed_wait (this=0xa654e6b0, abs_timeout=0xa67397a0) at mysql-5.5.4-m3/sql/mdl.cc:882 #5 0x082bbe17 in MDL_context::wait_for_lock (this=0xa654e6b0, mdl_request=0xa07aeac, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:2022 #6 0x0818ff04 in Open_table_context::recover_from_failed_open ( this=0xa6739bb8, thd=0xa654e640, mdl_request=0xa07aeac, table=0xa07acb8) at mysql-5.5.4-m3/sql/sql_base.cc:3908 #7 0x08192822 in open_tables (thd=0xa654e640, start=0xa6739c54, counter=0xa6739c3c, flags=0, prelocking_strategy=0xa6739c7c) at mysql-5.5.4-m3/sql/sql_base.cc:4697 #8 0x08192ce0 in open_and_lock_tables (thd=0xa654e640, tables=0xa07acb8, derived=true, flags=0, prelocking_strategy=0xa6739c7c) at mysql-5.5.4-m3/sql/sql_base.cc:5238 #9 0x081823ae in open_and_lock_tables (thd=0xa654e640, tables=0xa07acb8, derived=true, flags=0) at mysql-5.5.4-m3/sql/mysql_priv.h:1587 #10 0x081d861c in execute_sqlcom_select (thd=0xa654e640, all_tables=0xa07acb8) at mysql-5.5.4-m3/sql/sql_parse.cc:4805 #11 0x081d9c51 in mysql_execute_command (thd=0xa654e640) at mysql-5.5.4-m3/sql/sql_parse.cc:2325 #12 0x081e1b35 in mysql_parse (thd=0xa654e640, inBuf=0xa07a8b0 "SELECT `col_int_key` , `col_int` , `pk` FROM testdb_N . t1_view2_N AS A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_N . t1_merge1_N AS B WHERE B.`pk` = A.`pk` )", length=163, found_semicolon=0xa673b248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #13 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa654e640, packet=0xa65523c9 "SELECT `col_int_key` , `col_int` , `pk` FROM testdb_N . t1_view2_N AS A WHERE A.`pk` IN ( SELECT `pk` FROM testdb_N . t1_merge1_N AS B WHERE B.`pk` = A.`pk` ) ", packet_length=166) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #14 0x081e41dc in do_command (thd=0xa654e640) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #15 0x082b1762 in do_handle_one_connection (thd_arg=0xa654e640) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #16 0x082b182d in handle_one_connection (arg=0xa654e640) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #17 0x0089a45b in start_thread () from /lib/libpthread.so.0 #18 0x007f1c4e in clone () from /lib/libc.so.6 Thread 3 (process 20319): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647bc7 in safe_cond_timedwait (cond=0xa653dfe4, mp=0xa653dfa0, abstime=0xa6ba27e4, file=0x8724568 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1092) at mysql-5.5.4-m3/mysys/thr_mutex.c:278 #3 0x082bab8a in inline_mysql_cond_timedwait (that=0xa653dfe4, mutex=0xa653dfa0, abstime=0xa6ba27e4, src_file=0x8724264 "mysql-5.5.4-m3/sql/mdl.cc", src_line=883) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1092 #4 0x082bac79 in MDL_context::timed_wait (this=0xa653ded8, abs_timeout=0xa6ba27e4) at mysql-5.5.4-m3/sql/mdl.cc:882 #5 0x082bc379 in MDL_context::acquire_lock_impl (this=0xa653ded8, mdl_request=0xa0bfda4, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:1555 #6 0x082bc8da in MDL_context::acquire_locks (this=0xa653ded8, mdl_requests=0xa6ba2884, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:1654 #7 0x0818bfad in open_tables_acquire_upgradable_mdl (thd=0xa653de68, tables_start=0xa0bfbb0, tables_end=0x0, ot_ctx=0xa6ba2908) at mysql-5.5.4-m3/sql/sql_base.cc:4464 #8 0x08192752 in open_tables (thd=0xa653de68, start=0xa6ba29a4, counter=0xa6ba298c, flags=32, prelocking_strategy=0xa6ba29cc) at mysql-5.5.4-m3/sql/sql_base.cc:4641 #9 0x08192ce0 in open_and_lock_tables (thd=0xa653de68, tables=0xa0bfbb0, derived=true, flags=32, prelocking_strategy=0xa6ba29cc) at mysql-5.5.4-m3/sql/sql_base.cc:5238 #10 0x081823ae in open_and_lock_tables (thd=0xa653de68, tables=0xa0bfbb0, derived=true, flags=32) at mysql-5.5.4-m3/sql/mysql_priv.h:1587 #11 0x0825dbf1 in mysql_admin_table (thd=0xa653de68, tables=0xa0bfbb0, check_opt=0xa653f624, operator_name=0x871141b "repair", lock_type=TL_WRITE, open_for_modify=true, no_warnings_for_error=false, extra_open_options=32, prepare_func=0x8251252 , operator_func= {__pfn = 0x8344e4a , __delta = 0}, view_operator_func=0) at mysql-5.5.4-m3/sql/sql_table.cc:4680 #12 0x0825fbaf in mysql_repair_table (thd=0xa653de68, tables=0xa0bfbb0, check_opt=0xa653f624) at mysql-5.5.4-m3/sql/sql_table.cc:5156 #13 0x081db938 in mysql_execute_command (thd=0xa653de68) at mysql-5.5.4-m3/sql/sql_parse.cc:3038 #14 0x081e1b35 in mysql_parse (thd=0xa653de68, inBuf=0xa0bfac8 "REPAIR LOCAL TABLE testdb_N . t1_view2_N", length=40, found_semicolon=0xa6ba4248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #15 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa653de68, packet=0xa656c079 "", packet_length=43) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #16 0x081e41dc in do_command (thd=0xa653de68) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #17 0x082b1762 in do_handle_one_connection (thd_arg=0xa653de68) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #18 0x082b182d in handle_one_connection (arg=0xa653de68) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #19 0x0089a45b in start_thread () from /lib/libpthread.so.0 #20 0x007f1c4e in clone () from /lib/libc.so.6 Thread 2 (process 20320): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x08647bc7 in safe_cond_timedwait (cond=0xa650fa9c, mp=0xa650fa58, abstime=0xa66d78a0, file=0x8724568 "mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h", line=1092) at mysql-5.5.4-m3/mysys/thr_mutex.c:278 #3 0x082bab8a in inline_mysql_cond_timedwait (that=0xa650fa9c, mutex=0xa650fa58, abstime=0xa66d78a0, src_file=0x8724264 "mysql-5.5.4-m3/sql/mdl.cc", src_line=883) at mysql-5.5.4-m3/include/mysql/psi/mysql_thread.h:1092 #4 0x082bac79 in MDL_context::timed_wait (this=0xa650f990, abs_timeout=0xa66d78a0) at mysql-5.5.4-m3/sql/mdl.cc:882 #5 0x082bbe17 in MDL_context::wait_for_lock (this=0xa650f990, mdl_request=0xa1f7564, lock_wait_timeout=31536000) at mysql-5.5.4-m3/sql/mdl.cc:2022 #6 0x0818ff04 in Open_table_context::recover_from_failed_open ( this=0xa66d7cb8, thd=0xa650f920, mdl_request=0xa1f7564, table=0xa1f7370) at mysql-5.5.4-m3/sql/sql_base.cc:3908 #7 0x08192822 in open_tables (thd=0xa650f920, start=0xa66d8114, counter=0xa66d8088, flags=0, prelocking_strategy=0xa66d7d2c) at mysql-5.5.4-m3/sql/sql_base.cc:4697 #8 0x0819610f in open_tables (thd=0xa650f920, tables=0xa66d8114, counter=0xa66d8088, flags=0) at mysql-5.5.4-m3/sql/mysql_priv.h:1575 #9 0x08272989 in mysql_update (thd=0xa650f920, table_list=0xa1f7370, fields=@0xa6510e08, values=@0xa6511020, conds=0xa1f7c00, order_num=0, order=0x0, limit=1, handle_duplicates=DUP_ERROR, ignore=false, found_return=0xa66d8ad0, updated_return=0xa66d8ac8) at mysql-5.5.4-m3/sql/sql_update.cc:212 #10 0x081dbf48 in mysql_execute_command (thd=0xa650f920) at mysql-5.5.4-m3/sql/sql_parse.cc:3123 #11 0x081e1b35 in mysql_parse (thd=0xa650f920, inBuf=0xa1f7228 "UPDATE testdb_N . t1_view2_N SET `col_int` = 4 WHERE SLEEP( 0.5 * 0.73 * 1 ) = 0 LIMIT 1", length=91, found_semicolon=0xa66d9248) at mysql-5.5.4-m3/sql/sql_parse.cc:5872 #12 0x081e2f31 in dispatch_command (command=COM_QUERY, thd=0xa650f920, packet=0xa6539e59 "UPDATE testdb_N . t1_view2_N SET `col_int` = 4 WHERE SLEEP( 0.5 * 0.73 * 1 ) = 0 LIMIT 1", packet_length=91) at mysql-5.5.4-m3/sql/sql_parse.cc:1024 #13 0x081e41dc in do_command (thd=0xa650f920) at mysql-5.5.4-m3/sql/sql_parse.cc:710 #14 0x082b1762 in do_handle_one_connection (thd_arg=0xa650f920) at mysql-5.5.4-m3/sql/sql_connect.cc:1174 #15 0x082b182d in handle_one_connection (arg=0xa650f920) at mysql-5.5.4-m3/sql/sql_connect.cc:1113 #16 0x0089a45b in start_thread () from /lib/libpthread.so.0 #17 0x007f1c4e in clone () from /lib/libc.so.6 Thread 1 (process 14622): #0 0x0025f402 in __kernel_vsyscall () #1 0x0089f067 in pthread_kill () from /lib/libpthread.so.0 #2 0x08642251 in my_write_core (sig=11) at mysql-5.5.4-m3/mysys/stacktrace.c:326 #3 0x081457de in handle_segfault (sig=11) at mysql-5.5.4-m3/sql/mysqld.cc:2749 #4 #5 0x0025f402 in __kernel_vsyscall () #6 0x007e8033 in poll () from /lib/libc.so.6 #7 0x08146068 in handle_connections_sockets () at mysql-5.5.4-m3/sql/mysqld.cc:5360 #8 0x0814aafd in mysqld_main (argc=47, argv=0x96e5f20) at mysql-5.5.4-m3/sql/mysqld.cc:4822 #9 0x0813e8e2 in main (argc=) at mysql-5.5.4-m3/sql/main.cc:24