Thread 26 (process 2011): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad614a4, mp=0xad61458, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad61458, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=0, message1=0xb7f24380, message2=0xb7f2437c, type=0xb7f24378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=0) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292c0) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 25 (process 2012): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad6152c, mp=0xad614e0, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad614e0, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=1, message1=0xae5dc380, message2=0xae5dc37c, type=0xae5dc378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=1) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292c4) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 24 (process 2013): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad615b4, mp=0xad61568, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad61568, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=2, message1=0xadbdb380, message2=0xadbdb37c, type=0xadbdb378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=2) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292c8) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 23 (process 2014): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad6163c, mp=0xad615f0, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad615f0, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=3, message1=0xad1da380, message2=0xad1da37c, type=0xad1da378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=3) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292cc) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 22 (process 2015): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad616c4, mp=0xad61678, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad61678, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=4, message1=0xac7d9380, message2=0xac7d937c, type=0xac7d9378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=4) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292d0) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 21 (process 2016): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad6174c, mp=0xad61700, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad61700, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=5, message1=0xabdd8380, message2=0xabdd837c, type=0xabdd8378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=5) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292d4) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 20 (process 2017): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad617d4, mp=0xad61788, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad61788, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=6, message1=0xab3d7380, message2=0xab3d737c, type=0xab3d7378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=6) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292d8) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 19 (process 2018): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad6185c, mp=0xad61810, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad61810, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=7, message1=0xaa9d6380, message2=0xaa9d637c, type=0xaa9d6378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=7) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292dc) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 18 (process 2019): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad618e4, mp=0xad61898, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad61898, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=8, message1=0xa9fd5380, message2=0xa9fd537c, type=0xa9fd5378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=8) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292e0) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 17 (process 2020): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xad6196c, mp=0xad61920, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xad61920, reset_sig_count=0) at os/os0sync.c:399 #4 0x08499861 in os_aio_simulated_handle (global_segment=9, message1=0xa95d4380, message2=0xa95d437c, type=0xa95d4378) at os/os0file.c:4197 #5 0x0853db33 in fil_aio_wait (segment=9) at fil/fil0fil.c:4450 #6 0x084db9a9 in io_handler_thread (arg=0x89292e4) at srv/srv0start.c:492 #7 0x0089a45b in start_thread () from /lib/libpthread.so.0 #8 0x001e0c4e in clone () from /lib/libc.so.6 Thread 16 (process 2021): #0 0x00738402 in __kernel_vsyscall () #1 0x001d9a31 in select () from /lib/libc.so.6 #2 0x0849b0b4 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 #3 0x084da134 in srv_lock_timeout_and_monitor_thread (arg=0x0) at srv/srv0srv.c:1984 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 #5 0x001e0c4e in clone () from /lib/libc.so.6 Thread 15 (process 2022): #0 0x00738402 in __kernel_vsyscall () #1 0x001d9a31 in select () from /lib/libc.so.6 #2 0x0849b0b4 in os_thread_sleep (tm=1000000) at os/os0thread.c:281 #3 0x084da6b7 in srv_error_monitor_thread (arg=0x0) at srv/srv0srv.c:2220 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 #5 0x001e0c4e in clone () from /lib/libc.so.6 Thread 14 (process 2023): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xa93e564, mp=0xa93e518, file=0x8777a04 "os/os0sync.c", line=399) at thr_mutex.c:240 #3 0x0849a9eb in os_event_wait_low (event=0xa93e518, reset_sig_count=0) at os/os0sync.c:399 #4 0x084db27d in srv_master_thread (arg=0x0) at srv/srv0srv.c:2740 #5 0x0089a45b in start_thread () from /lib/libpthread.so.0 #6 0x001e0c4e in clone () from /lib/libc.so.6 Thread 13 (process 2024): #0 0x00738402 in __kernel_vsyscall () #1 0x008a1f6e in do_sigwait () from /lib/libpthread.so.0 #2 0x008a200f in sigwait () from /lib/libpthread.so.0 #3 0x08247685 in signal_hand (arg=0x0) at mysqld.cc:2928 #4 0x0089a45b in start_thread () from /lib/libpthread.so.0 #5 0x001e0c4e in clone () from /lib/libc.so.6 Thread 12 (process 2026): #0 0x00738402 in __kernel_vsyscall () #1 0x008a0e1b in read () from /lib/libpthread.so.0 #2 0x085b82cf in vio_read (vio=0xb1f0330, buf=0xb22dc60 "\a", size=4) at viosocket.c:44 #3 0x08238773 in my_real_read (net=0xa939c94, complen=0xa6b112ec) at net_serv.cc:836 #4 0x08238c3a in my_net_read (net=0xa939c94) at net_serv.cc:1026 #5 0x08262218 in do_command (thd=0xa939b68) at sql_parse.cc:655 #6 0x08250fcc in do_handle_one_connection (thd_arg=0xa939b68) at sql_connect.cc:1174 #7 0x08251079 in handle_one_connection (arg=0xa939b68) at sql_connect.cc:1113 #8 0x0089a45b in start_thread () from /lib/libpthread.so.0 #9 0x001e0c4e in clone () from /lib/libc.so.6 Thread 11 (process 2038): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e63bd in safe_cond_timedwait (cond=0xb237d84, mp=0xb237d40, abstime=0xa6adee70, file=0x8769958 "../include/mysql/psi/mysql_thread.h", line=812) at thr_mutex.c:278 #3 0x0844ef6e in inline_mysql_cond_timedwait (that=0xb237d84, mutex=0xb237d40, abstime=0xa6adee70) at ../include/mysql/psi/mysql_thread.h:812 #4 0x0844f02a in MDL_context::timed_wait (this=0xb237d08, timeout=1) at mdl.cc:810 #5 0x084502e3 in MDL_context::acquire_lock_impl (this=0xb237d08, mdl_request=0xa6adeef8) at mdl.cc:1467 #6 0x0845057d in MDL_context::upgrade_shared_lock_to_exclusive (this=0xb237d08, mdl_ticket=0xb2b33e8) at mdl.cc:1617 #7 0x082adeb3 in wait_while_table_is_used (thd=0xb237c98, table=0xa691f3d0, function=HA_EXTRA_FORCE_REOPEN) at sql_base.cc:2151 #8 0x0842bda7 in mysql_create_or_drop_trigger (thd=0xb237c98, tables=0xb241ad0, create=true) at sql_trigger.cc:477 #9 0x0825f384 in mysql_execute_command (thd=0xb237c98) at sql_parse.cc:4312 #10 0x0825fe61 in mysql_parse (thd=0xb237c98, inBuf=0xb241930 "CREATE TRIGGER trigger_1 AFTER INSERT ON table10_innodb FOR EACH ROW UPDATE table_3 SET `col_int_key` = 1", length=106, found_semicolon=0xa6ae0258) at sql_parse.cc:5589 #11 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb237c98, packet=0xb239901 " CREATE TRIGGER trigger_1 AFTER INSERT ON table10_innodb FOR EACH ROW UPDATE table_3 SET `col_int_key` = 1", packet_length=108) at sql_parse.cc:1023 #12 0x082623c4 in do_command (thd=0xb237c98) at sql_parse.cc:709 #13 0x08250fcc in do_handle_one_connection (thd_arg=0xb237c98) at sql_connect.cc:1174 #14 0x08251079 in handle_one_connection (arg=0xb237c98) at sql_connect.cc:1113 #15 0x0089a45b in start_thread () from /lib/libpthread.so.0 #16 0x001e0c4e in clone () from /lib/libc.so.6 Thread 10 (process 2040): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e63bd in safe_cond_timedwait (cond=0xb2829c4, mp=0xb282980, abstime=0xa6aad970, file=0x8769958 "../include/mysql/psi/mysql_thread.h", line=812) at thr_mutex.c:278 #3 0x0844ef6e in inline_mysql_cond_timedwait (that=0xb2829c4, mutex=0xb282980, abstime=0xa6aad970) at ../include/mysql/psi/mysql_thread.h:812 #4 0x0844f02a in MDL_context::timed_wait (this=0xb282948, timeout=1) at mdl.cc:810 #5 0x084502e3 in MDL_context::acquire_lock_impl (this=0xb282948, mdl_request=0xb2848ec) at mdl.cc:1467 #6 0x084507c3 in MDL_context::acquire_locks (this=0xb282948, mdl_requests=0xa6aada3c) at mdl.cc:1555 #7 0x082abf50 in open_table_get_mdl_lock (thd=0xb2828d8, table_list=0xb2846f8, mdl_request=0xb2848ec, ot_ctx=0xa6aadf60, flags=0) at sql_base.cc:2365 #8 0x082b0af4 in open_table (thd=0xb2828d8, table_list=0xb2846f8, mem_root=0xa6aadf2c, ot_ctx=0xa6aadf60, flags=0) at sql_base.cc:2668 #9 0x082b1ca8 in open_and_process_table (thd=0xb2828d8, lex=0xb283818, tables=0xb2846f8, counter=0xa6aadfdc, flags=0, prelocking_strategy=0xa6aae020, has_prelocking_list=false, ot_ctx=0xa6aadf60, new_frm_mem=0xa6aadf2c) at sql_base.cc:4195 #10 0x082b2290 in open_tables (thd=0xb2828d8, start=0xa6aadff4, counter=0xa6aadfdc, flags=0, prelocking_strategy=0xa6aae020) at sql_base.cc:4516 #11 0x082b2785 in open_and_lock_tables_derived (thd=0xb2828d8, tables=0xb2846f8, derived=true, flags=0, prelocking_strategy=0xa6aae020) at sql_base.cc:5116 #12 0x08263886 in open_and_lock_tables_derived (thd=0xb2828d8, tables=0xb2846f8, derived=true, flags=0) at mysql_priv.h:1572 #13 0x082638c4 in open_and_lock_tables (thd=0xb2828d8, tables=0xb2846f8) at mysql_priv.h:1582 #14 0x08407d4f in mysql_create_view (thd=0xb2828d8, views=0xb2846f8, mode=VIEW_CREATE_NEW) at sql_view.cc:399 #15 0x0825f2e9 in mysql_execute_command (thd=0xb2828d8) at sql_parse.cc:4298 #16 0x0825fe61 in mysql_parse (thd=0xb2828d8, inBuf=0xb284550 "CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 1912320 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM `table10_innodb`", length=154, found_semicolon=0xa6aaf258) at sql_parse.cc:5589 #17 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb2828d8, packet=0xb288279 " CREATE ALGORITHM = UNDEFINED VIEW view_1 AS SELECT /* QUERY_ID: 1912320 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 0 AS `col_int_key` FROM `table10_innodb` ", packet_length=156) at sql_parse.cc:1023 #18 0x082623c4 in do_command (thd=0xb2828d8) at sql_parse.cc:709 #19 0x08250fcc in do_handle_one_connection (thd_arg=0xb2828d8) at sql_connect.cc:1174 #20 0x08251079 in handle_one_connection (arg=0xb2828d8) at sql_connect.cc:1113 #21 0x0089a45b in start_thread () from /lib/libpthread.so.0 #22 0x001e0c4e in clone () from /lib/libc.so.6 Thread 9 (process 2042): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xb290384, mp=0xb290340, file=0x8769958 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #3 0x0844f0c8 in inline_mysql_cond_wait (that=0xb290384, mutex=0xb290340) at ../include/mysql/psi/mysql_thread.h:784 #4 0x0844f14b in MDL_context::wait (this=0xb290308) at mdl.cc:786 #5 0x0844fe8f in MDL_context::wait_for_lock (this=0xb290308, mdl_request=0xb2ca9d4) at mdl.cc:1858 #6 0x082afd65 in Open_table_context::recover_from_failed_open (this=0xa6a7cc10, thd=0xb290298, mdl_request=0xb2ca9d4, table=0xb2ca7e0) at sql_base.cc:3846 #7 0x082b22fb in open_tables (thd=0xb290298, start=0xa6a7cca4, counter=0xa6a7cc8c, flags=0, prelocking_strategy=0xa6a7ccd0) at sql_base.cc:4545 #8 0x082b2785 in open_and_lock_tables_derived (thd=0xb290298, tables=0xb2ca7e0, derived=true, flags=0, prelocking_strategy=0xa6a7ccd0) at sql_base.cc:5116 #9 0x08263886 in open_and_lock_tables_derived (thd=0xb290298, tables=0xb2ca7e0, derived=true, flags=0) at mysql_priv.h:1572 #10 0x082638c4 in open_and_lock_tables (thd=0xb290298, tables=0xb2ca7e0) at mysql_priv.h:1582 #11 0x08257254 in execute_sqlcom_select (thd=0xb290298, all_tables=0xb2ca7e0) at sql_parse.cc:4521 #12 0x082583ee in mysql_execute_command (thd=0xb290298) at sql_parse.cc:2060 #13 0x0825fe61 in mysql_parse (thd=0xb290298, inBuf=0xb2c9988 "SELECT /* QUERY_ID: 10226944 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 9 ) AS `col_int_key` FROM table_2 WHERE func_2 ( 1 ) < func_2 ( `col_int_key` )", length=160, found_semicolon=0xa6a7e258) at sql_parse.cc:5589 #14 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb290298, packet=0xb2c1959 "SELECT /* QUERY_ID: 10226944 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_1 ( 9 ) AS `col_int_key` FROM table_2 WHERE func_2 ( 1 ) < func_2 ( `col_int_key` )", packet_length=160) at sql_parse.cc:1023 #15 0x082623c4 in do_command (thd=0xb290298) at sql_parse.cc:709 #16 0x08250fcc in do_handle_one_connection (thd_arg=0xb290298) at sql_connect.cc:1174 #17 0x08251079 in handle_one_connection (arg=0xb290298) at sql_connect.cc:1113 #18 0x0089a45b in start_thread () from /lib/libpthread.so.0 #19 0x001e0c4e in clone () from /lib/libc.so.6 Thread 8 (process 2044): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xb2ad914, mp=0xb2ad8d0, file=0x8769958 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #3 0x0844f0c8 in inline_mysql_cond_wait (that=0xb2ad914, mutex=0xb2ad8d0) at ../include/mysql/psi/mysql_thread.h:784 #4 0x0844f14b in MDL_context::wait (this=0xb2ad898) at mdl.cc:786 #5 0x0844fe8f in MDL_context::wait_for_lock (this=0xb2ad898, mdl_request=0xb2d3e14) at mdl.cc:1858 #6 0x082afd65 in Open_table_context::recover_from_failed_open (this=0xa6a4bc10, thd=0xb2ad828, mdl_request=0xb2d3e14, table=0xb2d3c20) at sql_base.cc:3846 #7 0x082b22fb in open_tables (thd=0xb2ad828, start=0xa6a4bca4, counter=0xa6a4bc8c, flags=0, prelocking_strategy=0xa6a4bcd0) at sql_base.cc:4545 #8 0x082b2785 in open_and_lock_tables_derived (thd=0xb2ad828, tables=0xb2d3c20, derived=true, flags=0, prelocking_strategy=0xa6a4bcd0) at sql_base.cc:5116 #9 0x08263886 in open_and_lock_tables_derived (thd=0xb2ad828, tables=0xb2d3c20, derived=true, flags=0) at mysql_priv.h:1572 #10 0x082638c4 in open_and_lock_tables (thd=0xb2ad828, tables=0xb2d3c20) at mysql_priv.h:1582 #11 0x08257254 in execute_sqlcom_select (thd=0xb2ad828, all_tables=0xb2d3c20) at sql_parse.cc:4521 #12 0x082583ee in mysql_execute_command (thd=0xb2ad828) at sql_parse.cc:2060 #13 0x0825fe61 in mysql_parse (thd=0xb2ad828, inBuf=0xb2d39c0 "SELECT /* QUERY_ID: 13917696 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM table10_innodb WHERE `col_int_key` <> `col_int_key`", length=147, found_semicolon=0xa6a4d258) at sql_parse.cc:5589 #14 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb2ad828, packet=0xb2cb991 "SELECT /* QUERY_ID: 13917696 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ 3 AS `col_int_key` FROM table10_innodb WHERE `col_int_key` <> `col_int_key`", packet_length=147) at sql_parse.cc:1023 #15 0x082623c4 in do_command (thd=0xb2ad828) at sql_parse.cc:709 #16 0x08250fcc in do_handle_one_connection (thd_arg=0xb2ad828) at sql_connect.cc:1174 #17 0x08251079 in handle_one_connection (arg=0xb2ad828) at sql_connect.cc:1113 #18 0x0089a45b in start_thread () from /lib/libpthread.so.0 #19 0x001e0c4e in clone () from /lib/libc.so.6 Thread 7 (process 2046): #0 0x00738402 in __kernel_vsyscall () #1 0x0089dc42 in pthread_rwlock_wrlock () from /lib/libpthread.so.0 #2 0x084512be in MDL_context::stop_waiting (this=0xb33da90) at mdl.h:671 #3 0x0844feb0 in MDL_context::wait_for_lock (this=0xb33da90, mdl_request=0xb3479ac) at mdl.cc:1860 #4 0x082afd65 in Open_table_context::recover_from_failed_open (this=0xa68fe080, thd=0xb33da20, mdl_request=0xb3479ac, table=0xb3477b8) at sql_base.cc:3846 #5 0x082b22fb in open_tables (thd=0xb33da20, start=0xa68fe114, counter=0xa68fe0fc, flags=0, prelocking_strategy=0xa68fe140) at sql_base.cc:4545 #6 0x082b2785 in open_and_lock_tables_derived (thd=0xb33da20, tables=0xb3477b8, derived=true, flags=0, prelocking_strategy=0xa68fe140) at sql_base.cc:5116 #7 0x08263886 in open_and_lock_tables_derived (thd=0xb33da20, tables=0xb3477b8, derived=true, flags=0) at mysql_priv.h:1572 #8 0x082638c4 in open_and_lock_tables (thd=0xb33da20, tables=0xb3477b8) at mysql_priv.h:1582 #9 0x0825ac11 in mysql_execute_command (thd=0xb33da20) at sql_parse.cc:3010 #10 0x0825fe61 in mysql_parse (thd=0xb33da20, inBuf=0xb3476b8 "INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0", length=63, found_semicolon=0xa68ff258) at sql_parse.cc:5589 #11 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb33da20, packet=0xb33f689 " INSERT INTO table11_innodb SELECT * FROM table11_innodb LIMIT 0", packet_length=64) at sql_parse.cc:1023 #12 0x082623c4 in do_command (thd=0xb33da20) at sql_parse.cc:709 #13 0x08250fcc in do_handle_one_connection (thd_arg=0xb33da20) at sql_connect.cc:1174 #14 0x08251079 in handle_one_connection (arg=0xb33da20) at sql_connect.cc:1113 #15 0x0089a45b in start_thread () from /lib/libpthread.so.0 #16 0x001e0c4e in clone () from /lib/libc.so.6 Thread 6 (process 2048): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xb2ab94c, mp=0xb2ab908, file=0x8769958 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #3 0x0844f0c8 in inline_mysql_cond_wait (that=0xb2ab94c, mutex=0xb2ab908) at ../include/mysql/psi/mysql_thread.h:784 #4 0x0844f14b in MDL_context::wait (this=0xb2ab8d0) at mdl.cc:786 #5 0x0844fe8f in MDL_context::wait_for_lock (this=0xb2ab8d0, mdl_request=0xb2aa22c) at mdl.cc:1858 #6 0x082afd65 in Open_table_context::recover_from_failed_open (this=0xa68ccc10, thd=0xb2ab860, mdl_request=0xb2aa22c, table=0xb2aa038) at sql_base.cc:3846 #7 0x082b22fb in open_tables (thd=0xb2ab860, start=0xa68ccca4, counter=0xa68ccc8c, flags=0, prelocking_strategy=0xa68cccd0) at sql_base.cc:4545 #8 0x082b2785 in open_and_lock_tables_derived (thd=0xb2ab860, tables=0xb2aa038, derived=true, flags=0, prelocking_strategy=0xa68cccd0) at sql_base.cc:5116 #9 0x08263886 in open_and_lock_tables_derived (thd=0xb2ab860, tables=0xb2aa038, derived=true, flags=0) at mysql_priv.h:1572 #10 0x082638c4 in open_and_lock_tables (thd=0xb2ab860, tables=0xb2aa038) at mysql_priv.h:1582 #11 0x08257254 in execute_sqlcom_select (thd=0xb2ab860, all_tables=0xb2aa038) at sql_parse.cc:4521 #12 0x082583ee in mysql_execute_command (thd=0xb2ab860) at sql_parse.cc:2060 #13 0x0825fe61 in mysql_parse (thd=0xb2ab860, inBuf=0xb2a9170 "SELECT /* QUERY_ID: 6333440 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM table_2 WHERE func_1 ( func_2 ( 0 ) ) <> `col_int_key`", length=172, found_semicolon=0xa68ce258) at sql_parse.cc:5589 #14 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb2ab860, packet=0xb3b3311 "SELECT /* QUERY_ID: 6333440 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( `col_int_key` ) AS `col_int_key` FROM table_2 WHERE func_1 ( func_2 ( 0 ) ) <> `col_int_key`", packet_length=172) at sql_parse.cc:1023 #15 0x082623c4 in do_command (thd=0xb2ab860) at sql_parse.cc:709 #16 0x08250fcc in do_handle_one_connection (thd_arg=0xb2ab860) at sql_connect.cc:1174 #17 0x08251079 in handle_one_connection (arg=0xb2ab860) at sql_connect.cc:1113 #18 0x0089a45b in start_thread () from /lib/libpthread.so.0 #19 0x001e0c4e in clone () from /lib/libc.so.6 Thread 5 (process 2050): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xb3a14f4, mp=0xb3a14b0, file=0x8769958 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #3 0x0844f0c8 in inline_mysql_cond_wait (that=0xb3a14f4, mutex=0xb3a14b0) at ../include/mysql/psi/mysql_thread.h:784 #4 0x0844f14b in MDL_context::wait (this=0xb3a1478) at mdl.cc:786 #5 0x0844fe8f in MDL_context::wait_for_lock (this=0xb3a1478, mdl_request=0xb4231f4) at mdl.cc:1858 #6 0x082afd65 in Open_table_context::recover_from_failed_open (this=0xa689bd30, thd=0xb3a1408, mdl_request=0xb4231f4, table=0xb423000) at sql_base.cc:3846 #7 0x082b22fb in open_tables (thd=0xb3a1408, start=0xa689c174, counter=0xa689c0e8, flags=0, prelocking_strategy=0xa689bd90) at sql_base.cc:4545 #8 0x08169827 in open_tables (thd=0xb3a1408, tables=0xa689c174, counter=0xa689c0e8, flags=0) at mysql_priv.h:1560 #9 0x0830b78c in mysql_update (thd=0xb3a1408, table_list=0xb423000, fields=@0xb3a2864, values=@0xb3a2a7c, conds=0x0, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0xa689caf8, updated_return=0xa689caf0) at sql_update.cc:215 #10 0x0825a61c in mysql_execute_command (thd=0xb3a1408) at sql_parse.cc:2858 #11 0x0825fe61 in mysql_parse (thd=0xb3a1408, inBuf=0xb422f40 "UPDATE table_2 SET `col_int_key` = 4", length=36, found_semicolon=0xa689d258) at sql_parse.cc:5589 #12 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb3a1408, packet=0xb3ad2f9 " UPDATE table_2 SET `col_int_key` = 4", packet_length=37) at sql_parse.cc:1023 #13 0x082623c4 in do_command (thd=0xb3a1408) at sql_parse.cc:709 #14 0x08250fcc in do_handle_one_connection (thd_arg=0xb3a1408) at sql_connect.cc:1174 #15 0x08251079 in handle_one_connection (arg=0xb3a1408) at sql_connect.cc:1113 #16 0x0089a45b in start_thread () from /lib/libpthread.so.0 #17 0x001e0c4e in clone () from /lib/libc.so.6 Thread 4 (process 2052): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e4dc in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e63bd in safe_cond_timedwait (cond=0xb475e44, mp=0xb475e00, abstime=0xa686aab0, file=0x8769958 "../include/mysql/psi/mysql_thread.h", line=812) at thr_mutex.c:278 #3 0x0844ef6e in inline_mysql_cond_timedwait (that=0xb475e44, mutex=0xb475e00, abstime=0xa686aab0) at ../include/mysql/psi/mysql_thread.h:812 #4 0x0844f02a in MDL_context::timed_wait (this=0xb475dc8, timeout=1) at mdl.cc:810 #5 0x084502e3 in MDL_context::acquire_lock_impl (this=0xb475dc8, mdl_request=0xb29511c) at mdl.cc:1467 #6 0x084507c3 in MDL_context::acquire_locks (this=0xb475dc8, mdl_requests=0xa686ab7c) at mdl.cc:1555 #7 0x082abf50 in open_table_get_mdl_lock (thd=0xb475d58, table_list=0xb294f28, mdl_request=0xb29511c, ot_ctx=0xa686b0a0, flags=0) at sql_base.cc:2365 #8 0x082b0af4 in open_table (thd=0xb475d58, table_list=0xb294f28, mem_root=0xa686b06c, ot_ctx=0xa686b0a0, flags=0) at sql_base.cc:2668 #9 0x082b1ca8 in open_and_process_table (thd=0xb475d58, lex=0xb476c98, tables=0xb294f28, counter=0xa686b11c, flags=0, prelocking_strategy=0xa686b160, has_prelocking_list=false, ot_ctx=0xa686b0a0, new_frm_mem=0xa686b06c) at sql_base.cc:4195 #10 0x082b2290 in open_tables (thd=0xb475d58, start=0xa686b134, counter=0xa686b11c, flags=0, prelocking_strategy=0xa686b160) at sql_base.cc:4516 #11 0x082b2785 in open_and_lock_tables_derived (thd=0xb475d58, tables=0xb294f28, derived=true, flags=0, prelocking_strategy=0xa686b160) at sql_base.cc:5116 #12 0x08263886 in open_and_lock_tables_derived (thd=0xb475d58, tables=0xb294f28, derived=true, flags=0) at mysql_priv.h:1572 #13 0x08259013 in mysql_execute_command (thd=0xb475d58) at sql_parse.cc:2417 #14 0x0825fe61 in mysql_parse (thd=0xb475d58, inBuf=0xb294d38 "CREATE TABLE table_2 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) SELECT /* QUERY_ID: 2670592 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 4 ) AS `col_int_key` FROM `table10_innodb`", length=190, found_semicolon=0xa686c258) at sql_parse.cc:5589 #15 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb475d58, packet=0xb3a9021 " CREATE TABLE table_2 ( `col_int_key` INTEGER, KEY (`col_int_key`) ) SELECT /* QUERY_ID: 2670592 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_3 ( 4 ) AS `col_int_key` FROM `table10_innodb` ", packet_length=192) at sql_parse.cc:1023 #16 0x082623c4 in do_command (thd=0xb475d58) at sql_parse.cc:709 #17 0x08250fcc in do_handle_one_connection (thd_arg=0xb475d58) at sql_connect.cc:1174 #18 0x08251079 in handle_one_connection (arg=0xb475d58) at sql_connect.cc:1113 #19 0x0089a45b in start_thread () from /lib/libpthread.so.0 #20 0x001e0c4e in clone () from /lib/libc.so.6 Thread 3 (process 2054): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xb473e94, mp=0xb473e50, file=0x8769958 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #3 0x0844f0c8 in inline_mysql_cond_wait (that=0xb473e94, mutex=0xb473e50) at ../include/mysql/psi/mysql_thread.h:784 #4 0x0844f14b in MDL_context::wait (this=0xb473e18) at mdl.cc:786 #5 0x0844fe8f in MDL_context::wait_for_lock (this=0xb473e18, mdl_request=0xb36f7c4) at mdl.cc:1858 #6 0x082afd65 in Open_table_context::recover_from_failed_open (this=0xa6839d30, thd=0xb473da8, mdl_request=0xb36f7c4, table=0xb36f5d0) at sql_base.cc:3846 #7 0x082b22fb in open_tables (thd=0xb473da8, start=0xa683a174, counter=0xa683a0e8, flags=0, prelocking_strategy=0xa6839d90) at sql_base.cc:4545 #8 0x08169827 in open_tables (thd=0xb473da8, tables=0xa683a174, counter=0xa683a0e8, flags=0) at mysql_priv.h:1560 #9 0x0830b78c in mysql_update (thd=0xb473da8, table_list=0xb36f5d0, fields=@0xb475204, values=@0xb47541c, conds=0x0, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0xa683aaf8, updated_return=0xa683aaf0) at sql_update.cc:215 #10 0x0825a61c in mysql_execute_command (thd=0xb473da8) at sql_parse.cc:2858 #11 0x0825fe61 in mysql_parse (thd=0xb473da8, inBuf=0xb36f510 "UPDATE table_2 SET `col_int_key` = 1", length=36, found_semicolon=0xa683b258) at sql_parse.cc:5589 #12 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb473da8, packet=0xb3674e1 " UPDATE table_2 SET `col_int_key` = 1", packet_length=37) at sql_parse.cc:1023 #13 0x082623c4 in do_command (thd=0xb473da8) at sql_parse.cc:709 #14 0x08250fcc in do_handle_one_connection (thd_arg=0xb473da8) at sql_connect.cc:1174 #15 0x08251079 in handle_one_connection (arg=0xb473da8) at sql_connect.cc:1113 #16 0x0089a45b in start_thread () from /lib/libpthread.so.0 #17 0x001e0c4e in clone () from /lib/libc.so.6 Thread 2 (process 2056): #0 0x00738402 in __kernel_vsyscall () #1 0x0089e256 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib/libpthread.so.0 #2 0x085e6222 in safe_cond_wait (cond=0xb2a5cec, mp=0xb2a5ca8, file=0x8769958 "../include/mysql/psi/mysql_thread.h", line=784) at thr_mutex.c:240 #3 0x0844f0c8 in inline_mysql_cond_wait (that=0xb2a5cec, mutex=0xb2a5ca8) at ../include/mysql/psi/mysql_thread.h:784 #4 0x0844f14b in MDL_context::wait (this=0xb2a5c70) at mdl.cc:786 #5 0x0844fe8f in MDL_context::wait_for_lock (this=0xb2a5c70, mdl_request=0xb413fdc) at mdl.cc:1858 #6 0x082afd65 in Open_table_context::recover_from_failed_open (this=0xa66fdc10, thd=0xb2a5c00, mdl_request=0xb413fdc, table=0xb413de8) at sql_base.cc:3846 #7 0x082b22fb in open_tables (thd=0xb2a5c00, start=0xa66fdca4, counter=0xa66fdc8c, flags=0, prelocking_strategy=0xa66fdcd0) at sql_base.cc:4545 #8 0x082b2785 in open_and_lock_tables_derived (thd=0xb2a5c00, tables=0xb413de8, derived=true, flags=0, prelocking_strategy=0xa66fdcd0) at sql_base.cc:5116 #9 0x08263886 in open_and_lock_tables_derived (thd=0xb2a5c00, tables=0xb413de8, derived=true, flags=0) at mysql_priv.h:1572 #10 0x082638c4 in open_and_lock_tables (thd=0xb2a5c00, tables=0xb413de8) at mysql_priv.h:1582 #11 0x08257254 in execute_sqlcom_select (thd=0xb2a5c00, all_tables=0xb413de8) at sql_parse.cc:4521 #12 0x082583ee in mysql_execute_command (thd=0xb2a5c00) at sql_parse.cc:2060 #13 0x0825fe61 in mysql_parse (thd=0xb2a5c00, inBuf=0xb412ff0 "SELECT /* QUERY_ID: 1294592 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 1 ) AS `col_int_key` FROM table_2", length=113, found_semicolon=0xa66ff258) at sql_parse.cc:5589 #14 0x08261186 in dispatch_command (command=COM_QUERY, thd=0xb2a5c00, packet=0xb298c81 "SELECT /* QUERY_ID: 1294592 */ /* RESULTSET_SAME_DATA_IN_EVERY_ROW */ func_2 ( 1 ) AS `col_int_key` FROM table_2 ", packet_length=114) at sql_parse.cc:1023 #15 0x082623c4 in do_command (thd=0xb2a5c00) at sql_parse.cc:709 #16 0x08250fcc in do_handle_one_connection (thd_arg=0xb2a5c00) at sql_connect.cc:1174 #17 0x08251079 in handle_one_connection (arg=0xb2a5c00) at sql_connect.cc:1113 #18 0x0089a45b in start_thread () from /lib/libpthread.so.0 #19 0x001e0c4e in clone () from /lib/libc.so.6 Thread 1 (process 2008): #0 0x00738402 in __kernel_vsyscall () #1 0x0089f067 in pthread_kill () from /lib/libpthread.so.0 #2 0x085dbec2 in my_write_core (sig=11) at stacktrace.c:326 #3 0x08247e51 in handle_segfault (sig=11) at mysqld.cc:2727 #4 #5 0x00738402 in __kernel_vsyscall () #6 0x001d9a31 in select () from /lib/libc.so.6 #7 0x08248672 in handle_connections_sockets () at mysqld.cc:5380 #8 0x0824bba2 in main (argc=51, argv=0xa8fbd10) at mysqld.cc:4859