(gdb) +thread apply all bt Thread 45 (LWP 26905): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009735ee in os_cond_wait_timed (abstime=0x7ff8242bdd60, mutex=0x1688720, cond=0x1688758) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x1688720, time_in_usec=, reset_sig_count=1) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:716 #3 0x00000000008745e8 in srv_lock_timeout_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:2774 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 44 (LWP 26906): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009735ee in os_cond_wait_timed (abstime=0x7ff8238bcd30, mutex=0x16886a0, cond=0x16886d8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x16886a0, time_in_usec=, reset_sig_count=1) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:716 #3 0x000000000087373f in srv_error_monitor_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:2987 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 43 (LWP 26914): +bt #0 0x000000340cc0f2a5 in sigwait () from /lib64/libpthread.so.0 #1 0x000000000051b6c1 in signal_hand (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mysqld.cc:2701 #2 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #3 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 42 (LWP 27444): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2b9d0, cond=0x1b2ba08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2b9d0, reset_sig_count=2742) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=2) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087ec89 in mutex_spin_wait (mutex=0x1b2b8c8, file_name=0xb260a0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c", line=767) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0sync.c:653 #5 0x00000000008f7e8a in mutex_enter_func (line=767, file_name=0xb260a0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c", mutex=0x1b2b8c8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x1b2b8c8, file_name=0xb260a0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c", line=767) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:251 #7 0x00000000009043ff in dict_table_get (table_name=0x7ff820630d80 "query126958/t1", inc_mysql_count=1, ignore_err=DICT_ERR_IGNORE_NONE) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c:767 #8 0x0000000000833b64 in ha_innobase::open (this=0x7ff7b40148c0, name=, mode=, test_if_locked=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:4750 #9 0x00000000006b9bb5 in handler::ha_open (this=0x7ff7b40148c0, table_arg=0x7ff7b40101a0, name=0x7ff7b4024a88 "./query126958/t1", mode=2, test_if_locked=2) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:2340 #10 0x0000000000625dc5 in open_table_from_share (thd=0x1cb26e0, share=, alias=, db_stat=39, prgflag=, ha_open_flags=0, outparam=0x7ff7b40101a0, is_create_table=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/table.cc:2064 #11 0x0000000000562702 in open_table (thd=0x1cb26e0, table_list=0x7ff7b40418c8, mem_root=0x7ff820631f90, ot_ctx=0x7ff820631fd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:3131 #12 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff820631f90, ot_ctx=0x7ff820631fd0, has_prelocking_list=false, prelocking_strategy=0x7ff820633d80, flags=0, counter=0x7ff8206320fc, tables=0x7ff7b40418c8, lex=0x1cb42e0, thd=0x1cb26e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #13 open_tables (thd=0x1cb26e0, start=0x7ff8206320b8, counter=0x7ff8206320fc, flags=0, prelocking_strategy=0x7ff820633d80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #14 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7b40418c8, derived=false, flags=0, prelocking_strategy=0x7ff820633d80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #15 0x000000000060abae in mysql_alter_table (thd=0x1cb26e0, new_db=0x7ff7b4041878 "query126958", new_name=0x0, create_info=0x7ff820634370, table_list=0x7ff7b40418c8, alter_info=0x7ff820634450, order_num=0, order=0x0, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:6001 #16 0x00000000007ce5dd in Alter_table_statement::execute (this=, thd=0x1cb26e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_alter.cc:106 #17 0x00000000005a5445 in mysql_execute_command (thd=0x1cb26e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4660 #18 0x00000000005a5d30 in mysql_parse (thd=0x1cb26e0, rawbuf=0x7ff7b4041780 "ALTER TABLE query126958 . `t1` DROP COLUMN `col_smallint_key`", length=, parser_state=0x7ff820635b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #19 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1cb26e0, packet=, packet_length=61) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #20 0x00000000005a8783 in do_command (thd=0x1cb26e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #21 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #22 0x000000000064f8ce in handle_one_connection (arg=0x1cb26e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #23 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #24 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 41 (LWP 26915): +bt #0 0x000000340cc0e54d in read () from /lib64/libpthread.so.0 #1 0x0000000000a2e46a in vio_read (vio=0x1bfe9e0, buf=0x1c04b30 "\a", size=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/vio/viosocket.c:56 #2 0x000000000052472a in my_real_read (net=0x1b79d80, complen=0x7ff834162cc8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:834 #3 0x0000000000524a55 in my_net_read (net=0x1b79d80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:1033 #4 0x00000000005a8620 in do_command (thd=0x1b79b50) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:735 #5 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #6 0x000000000064f8ce in handle_one_connection (arg=0x1b79b50) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #7 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #8 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 40 (LWP 26936): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1824a00, cond=0x1824a38) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1824a00, reset_sig_count=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087ec89 in mutex_spin_wait (mutex=0x18241b8, file_name=0xb23650 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/buf/buf0lru.c", line=1092) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0sync.c:653 #5 0x00000000008e1d1b in mutex_enter_func (line=1092, file_name=0xb23650 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/buf/buf0lru.c", mutex=0x18241b8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x18241b8, file_name=0xb23650 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/buf/buf0lru.c", line=1092) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:251 #7 0x00000000008e9812 in buf_LRU_search_and_free_block (buf_pool=0x18241b8, n_iterations=919) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/buf/buf0lru.c:1092 #8 0x00000000008e9c65 in buf_LRU_get_free_block (buf_pool=0x18241b8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/buf/buf0lru.c:1326 #9 0x00000000008daa79 in buf_page_create (space=1010, offset=0, zip_size=0, mtr=0x7ff83411c870) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/buf/buf0buf.c:3678 #10 0x00000000009254d7 in fsp_header_init (space=1010, size=4, mtr=0x7ff83411c870) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fsp/fsp0fsp.c:915 #11 0x00000000008f419f in dict_build_table_def_step (thr=, node=0x7ff81401cca8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0crea.c:323 #12 0x00000000008f481d in dict_create_table_step (thr=0x7ff81421c9c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0crea.c:1105 #13 0x00000000009936e5 in que_thr_step (thr=0x7ff81421c9c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/que/que0que.c:1267 #14 que_run_threads_low (thr=0x7ff81421c9c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/que/que0que.c:1319 #15 que_run_threads (thr=0x7ff81421c9c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/que/que0que.c:1356 #16 0x00000000008550de in row_create_table_for_mysql (table=0x7ff814146a58, trx=0x7ff8141497f8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:1996 #17 0x0000000000835d9a in create_table_def (flags=, path_of_temp_table=, table_name=0x7ff83411cf60 "transforms/where_subselect_26935", form=, trx=0x7ff8141497f8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:7603 #18 ha_innobase::create (this=, name=, form=, create_info=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:8212 #19 0x00000000006bf9cf in handler::ha_create (this=0x7ff81401f8c0, name=0x7ff83411f290 "./transforms/where_subselect_26935", form=0x7ff83411d4b0, info=0x7ff834120bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:3718 #20 0x00000000006bfdad in ha_create_table (thd=0x1c08c80, path=0x7ff83411f290 "./transforms/where_subselect_26935", db=0x7ff814004ce0 "transforms", table_name=0x7ff814004cf0 "where_subselect_26935", create_info=0x7ff834120bd0, update_create_info=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:4031 #21 0x0000000000634ff8 in rea_create_table (thd=0x1c08c80, path=0x7ff83411f290 "./transforms/where_subselect_26935", db=0x7ff814004ce0 "transforms", table_name=0x7ff814004cf0 "where_subselect_26935", create_info=0x7ff834120bd0, create_fields=..., keys=0, key_info=0x7ff814005738, file=0x7ff814271270) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:528 #22 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1c08c80, db=0x7ff814004ce0 "transforms", table_name=0x7ff814004cf0 "where_subselect_26935", create_info=0x7ff834120bd0, alter_info=0x7ff8341205e0, internal_tmp_table=155, select_field_count=1, is_trans=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #23 0x00000000005896bb in create_table_from_items (thd=0x1c08c80, create_info=0x7ff834120bd0, create_table=0x7ff814004d48, alter_info=0x7ff8341205e0, items=, lock=0x7ff8341202c8, hooks=0x7ff834120280) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3785 #24 0x000000000058c82f in select_create::prepare (this=0x7ff8140054b8, values=..., u=0x1c0a940) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3938 #25 0x00000000005d1651 in JOIN::prepare (this=0x7ff81416f710, rref_pointer_array=0x1c0b148, tables_init=, wild_num=, conds_init=, og_num=337054608, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1c0af60, unit_arg=0x1c0a940) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:750 #26 0x00000000005e5da4 in mysql_select (thd=0x1c08c80, rref_pointer_array=0x1c0b148, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7ff8140054b8, unit=0x1c0a940, select_lex=0x1c0af60) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2624 #27 0x00000000005e63ae in handle_select (thd=0x1c08c80, lex=0x1c0a880, result=0x7ff8140054b8, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #28 0x00000000005a1700 in mysql_execute_command (thd=0x1c08c80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2757 #29 0x00000000005a5d30 in mysql_parse (thd=0x1c08c80, rawbuf=0x7ff814004bf0 "CREATE TABLE transforms.where_subselect_26935 SELECT 1", length=, parser_state=0x7ff834121b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #30 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c08c80, packet=, packet_length=55) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #31 0x00000000005a8783 in do_command (thd=0x1c08c80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #32 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #33 0x000000000064f8ce in handle_one_connection (arg=0x1c08c80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #34 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #35 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 39 (LWP 26902): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=2, array=0x18017a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=8, message1=0x7ff825d6bdb8, message2=0x7ff825d6bdb0, type=0x7ff825d6bda8, space_id=0x7ff825d6bda0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 38 (LWP 27019): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff82469cde0, mutex=0x1c7dcb8, that=0x1c7dce8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1c7dcb8, thd=0x1c7dbb0, abs_timeout=0x7ff82469cde0, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1c7dcb8, mdl_request=0x7ff7c80059c0, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1c7dcb8, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x1c7dbb0, tables_start=0x7ff7c8004dc8, tables_end=, lock_wait_timeout=31536000, flags=610914592) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x0000000000563f1d in open_tables (thd=0x1c7dbb0, start=0x7ff82469d358, counter=0x7ff82469d39c, flags=0, prelocking_strategy=0x7ff82469d4e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4986 #7 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7c8004dc8, derived=true, flags=0, prelocking_strategy=0x7ff82469d4e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #8 0x0000000000620f4e in open_and_lock_tables (flags=0, derived=true, tables=, thd=0x1c7dbb0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:505 #9 mysql_create_view (thd=0x1c7dbb0, views=0x7ff7c8004dc8, mode=VIEW_CREATE_OR_REPLACE) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:438 #10 0x00000000005a4ed1 in mysql_execute_command (thd=0x1c7dbb0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4497 #11 0x00000000005a5d30 in mysql_parse (thd=0x1c7dbb0, rawbuf=0x7ff7c8004c10 "CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW transforms.view_27018_temptable AS SELECT `col_char_10` FROM `C`", length=, parser_state=0x7ff82469eb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c7dbb0, packet=, packet_length=107) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1c7dbb0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1c7dbb0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 37 (LWP 26898): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=2, array=0x17f9520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=4, message1=0x7ff834ba4db8, message2=0x7ff834ba4db0, type=0x7ff834ba4da8, space_id=0x7ff834ba4da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 36 (LWP 27522): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2bbd0, cond=0x1b2bc08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2bbd0, reset_sig_count=2145) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=5) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e167 in rw_lock_x_lock_func (lock=0x1161620 , pass=0, file_name=0xb0cb30 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c", line=3284) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0rw.c:700 #5 0x000000000084f82e in pfs_rw_lock_x_lock_func (line=3284, file_name=0xb0cb30 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c", pass=0, lock=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7ff7a401b168, file=0xb0cb30 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c", line=3284) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:1848 #7 0x0000000000853e23 in row_drop_table_for_mysql (name=0x7ff82056d680 "query127005/#sql2-690c-69", trx=0x7ff7a401b168, drop_db=0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:3284 #8 0x0000000000830463 in ha_innobase::delete_table (this=, name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:8504 #9 0x00000000006becda in handler::ha_delete_table (this=0x7ff7a4049840, name=0x7ff82056ee60 "./query127005/#sql2-690c-69") at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:3688 #10 0x00000000006bef12 in ha_delete_table (thd=0x1c18060, table_type=, path=0x7ff82056ee60 "./query127005/#sql2-690c-69", db=0x7ff7a403e978 "query127005", alias=0x7ff820570d40 "#sql2-690c-69", generate_warning=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:2231 #11 0x000000000060a667 in quick_rm_table (base=0x1416bc0, db=0x7ff7a403e978 "query127005", table_name=0x7ff820570d40 "#sql2-690c-69", flags=3) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:2425 #12 0x000000000060e144 in mysql_alter_table (thd=, new_db=0x7ff7a403e978 "query127005", new_name=0x7ff7a403e990 "t1", create_info=0x7ff820571370, table_list=, alter_info=0x7ff820571450, order_num=0, order=0x0, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:7030 #13 0x00000000007ce5dd in Alter_table_statement::execute (this=, thd=0x1c18060) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_alter.cc:106 #14 0x00000000005a5445 in mysql_execute_command (thd=0x1c18060) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4660 #15 0x00000000005a5d30 in mysql_parse (thd=0x1c18060, rawbuf=0x7ff7a403e880 "ALTER TABLE query127005 . `t1` DROP COLUMN `col_mediumint_key`", length=, parser_state=0x7ff820572b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #16 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c18060, packet=, packet_length=62) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #17 0x00000000005a8783 in do_command (thd=0x1c18060) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #18 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #19 0x000000000064f8ce in handle_one_connection (arg=0x1c18060) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #20 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #21 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 35 (LWP 26901): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=1, array=0x18017a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=7, message1=0x7ff82676cdb8, message2=0x7ff82676cdb0, type=0x7ff82676cda8, space_id=0x7ff82676cda0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=7) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 34 (LWP 27025): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2bbd0, cond=0x1b2bc08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2bbd0, reset_sig_count=2145) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e167 in rw_lock_x_lock_func (lock=0x1161620 , pass=0, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0rw.c:700 #5 0x000000000084f82e in pfs_rw_lock_x_lock_func (line=8208, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7ff7cc00b958, file=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:1848 #7 0x0000000000835987 in ha_innobase::create (this=, name=, form=0x7ff82465a490, create_info=0x7ff82465cbd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:8208 #8 0x00000000006bf9cf in handler::ha_create (this=0x7ff7cc017d80, name=0x7ff82465c270 "./test/trigger127024", form=0x7ff82465a490, info=0x7ff82465cbd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:3718 #9 0x00000000006bfdad in ha_create_table (thd=0x1c85490, path=0x7ff82465c270 "./test/trigger127024", db=0x7ff7cc005268 "test", table_name=0x7ff7cc004cf8 "trigger127024", create_info=0x7ff82465cbd0, update_create_info=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:4031 #10 0x0000000000634ff8 in rea_create_table (thd=0x1c85490, path=0x7ff82465c270 "./test/trigger127024", db=0x7ff7cc005268 "test", table_name=0x7ff7cc004cf8 "trigger127024", create_info=0x7ff82465cbd0, create_fields=..., keys=0, key_info=0x7ff7cc0055d8, file=0x7ff7cc00f770) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:528 #11 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1c85490, db=0x7ff7cc005268 "test", table_name=0x7ff7cc004cf8 "trigger127024", create_info=0x7ff82465cbd0, alter_info=0x7ff82465c5e0, internal_tmp_table=155, select_field_count=0, is_trans=0x7ff82465c53f) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #12 0x0000000000609023 in mysql_create_table (thd=0x1c85490, create_table=0x7ff7cc004d40, create_info=0x7ff82465cbd0, alter_info=0x7ff82465c5e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4430 #13 0x00000000005a177a in mysql_execute_command (thd=0x1c85490) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2780 #14 0x00000000005a5d30 in mysql_parse (thd=0x1c85490, rawbuf=0x7ff7cc004c10 "CREATE TABLE IF NOT EXISTS trigger127024 (f1 INTEGER)", length=, parser_state=0x7ff82465db10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #15 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c85490, packet=, packet_length=53) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #16 0x00000000005a8783 in do_command (thd=0x1c85490) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #17 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #18 0x000000000064f8ce in handle_one_connection (arg=0x1c85490) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #19 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #20 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 33 (LWP 27051): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff8205f2de0, mutex=0x1cba0c8, that=0x1cba0f8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1cba0c8, thd=0x1cb9fc0, abs_timeout=0x7ff8205f2de0, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1cba0c8, mdl_request=0x7ff7a80060f8, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1cba0c8, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x1cb9fc0, tables_start=0x7ff7a8004e60, tables_end=, lock_wait_timeout=31536000, flags=543109408) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x0000000000563f1d in open_tables (thd=0x1cb9fc0, start=0x7ff8205f3358, counter=0x7ff8205f339c, flags=0, prelocking_strategy=0x7ff8205f34e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4986 #7 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7a8004e60, derived=true, flags=0, prelocking_strategy=0x7ff8205f34e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #8 0x0000000000620f4e in open_and_lock_tables (flags=0, derived=true, tables=, thd=0x1cb9fc0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:505 #9 mysql_create_view (thd=0x1cb9fc0, views=0x7ff7a8004e60, mode=VIEW_CREATE_OR_REPLACE) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:438 #10 0x00000000005a4ed1 in mysql_execute_command (thd=0x1cb9fc0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4497 #11 0x00000000005a5d30 in mysql_parse (thd=0x1cb9fc0, rawbuf=0x7ff7a8004c10 "CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW transforms.view_27050_temptable AS SELECT * FROM `AA` WHERE `col_char_10_not_null_key` <> 'want' ORDER BY `col_bigint_key` , `pk` LIMIT 79", length=, parser_state=0x7ff8205f4b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1cb9fc0, packet=, packet_length=181) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1cb9fc0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1cb9fc0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 32 (LWP 26910): +bt #0 0x000000340c4e14f3 in select () from /lib64/libc.so.6 #1 0x0000000000973c77 in os_thread_sleep (tm=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0thread.c:259 #2 0x0000000000872db7 in srv_purge_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:4154 #3 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #4 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 31 (LWP 26892): +bt #0 0x000000340c4df253 in poll () from /lib64/libc.so.6 #1 0x000000000051c7db in handle_connections_sockets () at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mysqld.cc:5346 #2 0x0000000000522b27 in mysqld_main (argc=46, argv=0x13d52a8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mysqld.cc:4789 #3 0x000000000051719d in main (argc=, argv=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/main.cc:25 Thread 30 (LWP 26949): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2bbd0, cond=0x1b2bc08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2bbd0, reset_sig_count=2145) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=1) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e167 in rw_lock_x_lock_func (lock=0x1161620 , pass=0, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0rw.c:700 #5 0x000000000084f82e in pfs_rw_lock_x_lock_func (line=8208, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7ff7f8023b78, file=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:1848 #7 0x0000000000835987 in ha_innobase::create (this=, name=, form=0x7ff8249654b0, create_info=0x7ff824968bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:8208 #8 0x00000000006bf9cf in handler::ha_create (this=0x7ff7f800e6b0, name=0x7ff824967290 "./transforms/where_updatedelete_26948", form=0x7ff8249654b0, info=0x7ff824968bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:3718 #9 0x00000000006bfdad in ha_create_table (thd=0x1c2b230, path=0x7ff824967290 "./transforms/where_updatedelete_26948", db=0x7ff7f8004d28 "transforms", table_name=0x7ff7f8004d38 "where_updatedelete_26948", create_info=0x7ff824968bd0, update_create_info=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:4031 #10 0x0000000000634ff8 in rea_create_table (thd=0x1c2b230, path=0x7ff824967290 "./transforms/where_updatedelete_26948", db=0x7ff7f8004d28 "transforms", table_name=0x7ff7f8004d38 "where_updatedelete_26948", create_info=0x7ff824968bd0, create_fields=..., keys=0, key_info=0x7ff7f8005a00, file=0x7ff7f80088c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:528 #11 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1c2b230, db=0x7ff7f8004d28 "transforms", table_name=0x7ff7f8004d38 "where_updatedelete_26948", create_info=0x7ff824968bd0, alter_info=0x7ff8249685e0, internal_tmp_table=155, select_field_count=1, is_trans=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #12 0x00000000005896bb in create_table_from_items (thd=0x1c2b230, create_info=0x7ff824968bd0, create_table=0x7ff7f8004da0, alter_info=0x7ff8249685e0, items=, lock=0x7ff8249682c8, hooks=0x7ff824968280) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3785 #13 0x000000000058c82f in select_create::prepare (this=0x7ff7f8005730, values=..., u=0x1c2cef0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3938 #14 0x00000000005d1651 in JOIN::prepare (this=0x7ff7f801d1a0, rref_pointer_array=0x1c2d6f8, tables_init=, wild_num=, conds_init=, og_num=4160874016, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1c2d510, unit_arg=0x1c2cef0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:750 #15 0x00000000005e5da4 in mysql_select (thd=0x1c2b230, rref_pointer_array=0x1c2d6f8, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7ff7f8005730, unit=0x1c2cef0, select_lex=0x1c2d510) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2624 #16 0x00000000005e63ae in handle_select (thd=0x1c2b230, lex=0x1c2ce30, result=0x7ff7f8005730, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #17 0x00000000005a1700 in mysql_execute_command (thd=0x1c2b230) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2757 #18 0x00000000005a5d30 in mysql_parse (thd=0x1c2b230, rawbuf=0x7ff7f8004c10 "CREATE TABLE transforms.where_updatedelete_26948 SELECT GET_LOCK('LOCK', 65535)", length=, parser_state=0x7ff824969b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #19 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c2b230, packet=, packet_length=80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #20 0x00000000005a8783 in do_command (thd=0x1c2b230) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #21 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #22 0x000000000064f8ce in handle_one_connection (arg=0x1c2b230) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #23 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #24 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 29 (LWP 26938): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2b9d0, cond=0x1b2ba08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2b9d0, reset_sig_count=2742) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087ec89 in mutex_spin_wait (mutex=0x1b2b8c8, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=4454) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0sync.c:653 #5 0x0000000000832b98 in mutex_enter_func (line=4454, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", mutex=0x1b2b8c8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=4454, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", mutex=0x1b2b8c8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:251 #7 innobase_build_index_translation (table=0x7ff818077b00, ib_table=0x7ff8180538a8, share=0x7ff8180787c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:4454 #8 0x0000000000833825 in ha_innobase::open (this=0x7ff818013760, name=, mode=, test_if_locked=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:4887 #9 0x00000000006b9bb5 in handler::ha_open (this=0x7ff818013760, table_arg=0x7ff818077b00, name=0x7ff818077698 "./drizzledump_db/trigger126937", mode=2, test_if_locked=2) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:2340 #10 0x0000000000625dc5 in open_table_from_share (thd=0x1c10780, share=, alias=, db_stat=39, prgflag=, ha_open_flags=0, outparam=0x7ff818077b00, is_create_table=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/table.cc:2064 #11 0x0000000000562702 in open_table (thd=0x1c10780, table_list=0x7ff818004e40, mem_root=0x7ff8340df200, ot_ctx=0x7ff8340df240) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:3131 #12 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff8340df200, ot_ctx=0x7ff8340df240, has_prelocking_list=false, prelocking_strategy=0x7ff8340df520, flags=0, counter=0x7ff8340df36c, tables=0x7ff818004e40, lex=0x1c12380, thd=0x1c10780) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #13 open_tables (thd=0x1c10780, start=0x7ff8340df328, counter=0x7ff8340df36c, flags=0, prelocking_strategy=0x7ff8340df520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #14 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff818004e40, derived=false, flags=0, prelocking_strategy=0x7ff8340df520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #15 0x00000000005650f0 in open_n_lock_single_table (thd=0x1c10780, table_l=0x7ff818004e40, lock_type=TL_READ_NO_INSERT, flags=0, prelocking_strategy=0x7ff8340df520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5474 #16 0x000000000061339e in open_n_lock_single_table (flags=0, lock_type=TL_READ_NO_INSERT, table_l=0x7ff818004e40, thd=0x1c10780) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:494 #17 mysql_create_or_drop_trigger (thd=0x1c10780, tables=0x7ff818004e40, create=true) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_trigger.cc:530 #18 0x00000000005a4f33 in mysql_execute_command (thd=0x1c10780) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4511 #19 0x00000000005a5d30 in mysql_parse (thd=0x1c10780, rawbuf=0x7ff818004c10 "CREATE TRIGGER trigger126937 BEFORE INSERT ON trigger126937 FOR EACH ROW INSERT INTO transforms.trigger226937 SELECT 1", length=, parser_state=0x7ff8340e0b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #20 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c10780, packet=, packet_length=120) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #21 0x00000000005a8783 in do_command (thd=0x1c10780) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #22 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #23 0x000000000064f8ce in handle_one_connection (arg=0x1c10780) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #24 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #25 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 28 (LWP 27055): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2bbd0, cond=0x1b2bc08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2bbd0, reset_sig_count=2145) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=11) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e167 in rw_lock_x_lock_func (lock=0x1161620 , pass=0, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0rw.c:700 #5 0x000000000084f82e in pfs_rw_lock_x_lock_func (line=8208, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7ff7ac0b7c88, file=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:1848 #7 0x0000000000835987 in ha_innobase::create (this=, name=, form=0x7ff8205af4b0, create_info=0x7ff8205b2bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:8208 #8 0x00000000006bf9cf in handler::ha_create (this=0x7ff7ac053540, name=0x7ff8205b1290 "./transforms/insert_select_27054", form=0x7ff8205af4b0, info=0x7ff8205b2bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:3718 #9 0x00000000006bfdad in ha_create_table (thd=0x1cc18a0, path=0x7ff8205b1290 "./transforms/insert_select_27054", db=0x7ff7ac004d00 "transforms", table_name=0x7ff7ac004d10 "insert_select_27054", create_info=0x7ff8205b2bd0, update_create_info=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:4031 #10 0x0000000000634ff8 in rea_create_table (thd=0x1cc18a0, path=0x7ff8205b1290 "./transforms/insert_select_27054", db=0x7ff7ac004d00 "transforms", table_name=0x7ff7ac004d10 "insert_select_27054", create_info=0x7ff8205b2bd0, create_fields=..., keys=0, key_info=0x7ff7ac005758, file=0x7ff7ac01ed70) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:528 #11 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1cc18a0, db=0x7ff7ac004d00 "transforms", table_name=0x7ff7ac004d10 "insert_select_27054", create_info=0x7ff8205b2bd0, alter_info=0x7ff8205b25e0, internal_tmp_table=155, select_field_count=1, is_trans=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #12 0x00000000005896bb in create_table_from_items (thd=0x1cc18a0, create_info=0x7ff8205b2bd0, create_table=0x7ff7ac004d68, alter_info=0x7ff8205b25e0, items=, lock=0x7ff8205b22c8, hooks=0x7ff8205b2280) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3785 #13 0x000000000058c82f in select_create::prepare (this=0x7ff7ac0054d8, values=..., u=0x1cc3560) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3938 #14 0x00000000005d1651 in JOIN::prepare (this=0x7ff7ac01ad80, rref_pointer_array=0x1cc3d68, tables_init=, wild_num=, conds_init=, og_num=2885796352, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1cc3b80, unit_arg=0x1cc3560) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:750 #15 0x00000000005e5da4 in mysql_select (thd=0x1cc18a0, rref_pointer_array=0x1cc3d68, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7ff7ac0054d8, unit=0x1cc3560, select_lex=0x1cc3b80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2624 #16 0x00000000005e63ae in handle_select (thd=0x1cc18a0, lex=0x1cc34a0, result=0x7ff7ac0054d8, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #17 0x00000000005a1700 in mysql_execute_command (thd=0x1cc18a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2757 #18 0x00000000005a5d30 in mysql_parse (thd=0x1cc18a0, rawbuf=0x7ff7ac004c10 "CREATE TABLE transforms.insert_select_27054 SELECT 1", length=, parser_state=0x7ff8205b3b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #19 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1cc18a0, packet=, packet_length=53) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #20 0x00000000005a8783 in do_command (thd=0x1cc18a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #21 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #22 0x000000000064f8ce in handle_one_connection (arg=0x1cc18a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #23 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #24 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 27 (LWP 26908): +bt #0 0x000000340c4e14f3 in select () from /lib64/libc.so.6 #1 0x0000000000973c77 in os_thread_sleep (tm=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0thread.c:259 #2 0x0000000000873339 in srv_LRU_dump_restore_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:3033 #3 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #4 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 26 (LWP 26900): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=0, array=0x18017a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=6, message1=0x7ff82716ddb8, message2=0x7ff82716ddb0, type=0x7ff82716dda8, space_id=0x7ff82716dda0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=6) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 25 (LWP 26903): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=3, array=0x18017a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=9, message1=0x7ff82536adb8, message2=0x7ff82536adb0, type=0x7ff82536ada8, space_id=0x7ff82536ada0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=9) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 24 (LWP 27013): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff82471e370, mutex=0x1c6eaf8, that=0x1c6eb28) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1c6eaf8, thd=0x1c6e9f0, abs_timeout=0x7ff82471e370, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1c6eaf8, mdl_request=0x7ff7d0005378, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x00000000005585f2 in open_table_get_mdl_lock (thd=0x1c6e9f0, ot_ctx=0x7ff82471efa0, mdl_request=0x7ff7d0005378, flags=0, mdl_ticket=0x7ff82471ee68) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2607 #5 0x0000000000561e08 in open_table (thd=0x1c6e9f0, table_list=0x7ff7d0005008, mem_root=0x7ff82471ef60, ot_ctx=0x7ff82471efa0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2940 #6 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff82471ef60, ot_ctx=0x7ff82471efa0, has_prelocking_list=false, prelocking_strategy=0x7ff82471f510, flags=0, counter=0x7ff82471f0cc, tables=0x7ff7d0005008, lex=0x1c705f0, thd=0x1c6e9f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #7 open_tables (thd=0x1c6e9f0, start=0x7ff82471f088, counter=0x7ff82471f0cc, flags=0, prelocking_strategy=0x7ff82471f510) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #8 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7d0005008, derived=true, flags=0, prelocking_strategy=0x7ff82471f510) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #9 0x000000000059cc80 in open_and_lock_tables (flags=0, derived=true, tables=0x7ff7d0005008, thd=0x1c6e9f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:505 #10 execute_sqlcom_select (thd=0x1c6e9f0, all_tables=0x7ff7d0005008) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4776 #11 0x00000000005a0bcb in mysql_execute_command (thd=0x1c6e9f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2322 #12 0x00000000005a5d30 in mysql_parse (thd=0x1c6e9f0, rawbuf=0x7ff7d0004c10 "/* GenTest::Transform::LimitDecrease */ SELECT X . `col_enum_not_null_key` FROM `A` AS X LEFT JOIN `D` AS Y USING ( `col_char_128_not_null_key` ) WHERE X . `col_binary_5_key` BETWEEN 1 AND 6 LIMIT 1 /* TRANSFORM_OUTCOME_SINGLE_ROW */", length=, parser_state=0x7ff824720b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c6e9f0, packet=, packet_length=233) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x1c6e9f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x1c6e9f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 23 (LWP 27034): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2bbd0, cond=0x1b2bc08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2bbd0, reset_sig_count=2145) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=7) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e167 in rw_lock_x_lock_func (lock=0x1161620 , pass=0, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0rw.c:700 #5 0x000000000084f82e in pfs_rw_lock_x_lock_func (line=8208, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7ff7b800dba8, file=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:1848 #7 0x0000000000835987 in ha_innobase::create (this=, name=, form=0x7ff8206b34b0, create_info=0x7ff8206b6bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:8208 #8 0x00000000006bf9cf in handler::ha_create (this=0x7ff7b807bbd0, name=0x7ff8206b5290 "./transforms/where_updatedelete_27033", form=0x7ff8206b34b0, info=0x7ff8206b6bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:3718 #9 0x00000000006bfdad in ha_create_table (thd=0x1ca3b40, path=0x7ff8206b5290 "./transforms/where_updatedelete_27033", db=0x7ff7b8004d10 "transforms", table_name=0x7ff7b8004d20 "where_updatedelete_27033", create_info=0x7ff8206b6bd0, update_create_info=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:4031 #10 0x0000000000634ff8 in rea_create_table (thd=0x1ca3b40, path=0x7ff8206b5290 "./transforms/where_updatedelete_27033", db=0x7ff7b8004d10 "transforms", table_name=0x7ff7b8004d20 "where_updatedelete_27033", create_info=0x7ff8206b6bd0, create_fields=..., keys=0, key_info=0x7ff7b8005778, file=0x7ff7b80087d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:528 #11 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1ca3b40, db=0x7ff7b8004d10 "transforms", table_name=0x7ff7b8004d20 "where_updatedelete_27033", create_info=0x7ff8206b6bd0, alter_info=0x7ff8206b65e0, internal_tmp_table=155, select_field_count=1, is_trans=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #12 0x00000000005896bb in create_table_from_items (thd=0x1ca3b40, create_info=0x7ff8206b6bd0, create_table=0x7ff7b8004d88, alter_info=0x7ff8206b65e0, items=, lock=0x7ff8206b62c8, hooks=0x7ff8206b6280) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3785 #13 0x000000000058c82f in select_create::prepare (this=0x7ff7b80054f8, values=..., u=0x1ca5800) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3938 #14 0x00000000005d1651 in JOIN::prepare (this=0x7ff7b803c8a0, rref_pointer_array=0x1ca6008, tables_init=, wild_num=, conds_init=, og_num=3087260960, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1ca5e20, unit_arg=0x1ca5800) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:750 #15 0x00000000005e5da4 in mysql_select (thd=0x1ca3b40, rref_pointer_array=0x1ca6008, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7ff7b80054f8, unit=0x1ca5800, select_lex=0x1ca5e20) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2624 #16 0x00000000005e63ae in handle_select (thd=0x1ca3b40, lex=0x1ca5740, result=0x7ff7b80054f8, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #17 0x00000000005a1700 in mysql_execute_command (thd=0x1ca3b40) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2757 #18 0x00000000005a5d30 in mysql_parse (thd=0x1ca3b40, rawbuf=0x7ff7b8004c10 "CREATE TABLE transforms.where_updatedelete_27033 SELECT 1", length=, parser_state=0x7ff8206b7b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #19 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1ca3b40, packet=, packet_length=58) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #20 0x00000000005a8783 in do_command (thd=0x1ca3b40) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #21 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #22 0x000000000064f8ce in handle_one_connection (arg=0x1ca3b40) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #23 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #24 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 22 (LWP 27042): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff8245d9de0, mutex=0x1c9c038, that=0x1c9c068) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1c9c038, thd=0x1c9bf30, abs_timeout=0x7ff8245d9de0, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1c9c038, mdl_request=0x7ff7c4005f08, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1c9c038, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x1c9bf30, tables_start=0x7ff7c4004e98, tables_end=, lock_wait_timeout=31536000, flags=610115872) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x0000000000563f1d in open_tables (thd=0x1c9bf30, start=0x7ff8245da358, counter=0x7ff8245da39c, flags=0, prelocking_strategy=0x7ff8245da4e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4986 #7 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7c4004e98, derived=true, flags=0, prelocking_strategy=0x7ff8245da4e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #8 0x0000000000620f4e in open_and_lock_tables (flags=0, derived=true, tables=, thd=0x1c9bf30) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:505 #9 mysql_create_view (thd=0x1c9bf30, views=0x7ff7c4004e98, mode=VIEW_CREATE_OR_REPLACE) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:438 #10 0x00000000005a4ed1 in mysql_execute_command (thd=0x1c9bf30) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4497 #11 0x00000000005a5d30 in mysql_parse (thd=0x1c9bf30, rawbuf=0x7ff7c4004c10 "CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW transforms.view_27041_temptable AS SELECT X . `col_mediumint_key` FROM `DD` AS X WHERE X . `col_bigint_not_null_key` < 964362240 LIMIT 6 /*Generated by THREAD_ID 22*/", length=, parser_state=0x7ff8245dbb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c9bf30, packet=, packet_length=211) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1c9bf30) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1c9bf30) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 21 (LWP 26899): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=3, array=0x17f9520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=5, message1=0x7ff827b6edb8, message2=0x7ff827b6edb0, type=0x7ff827b6eda8, space_id=0x7ff827b6eda0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=5) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 20 (LWP 27028): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2b9d0, cond=0x1b2ba08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2b9d0, reset_sig_count=2742) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=6) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087ec89 in mutex_spin_wait (mutex=0x1b2b8c8, file_name=0xb260a0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c", line=5407) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0sync.c:653 #5 0x00000000008f7e8a in mutex_enter_func (line=5407, file_name=0xb260a0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c", mutex=0x1b2b8c8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x1b2b8c8, file_name=0xb260a0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c", line=5407) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:251 #7 0x00000000008f8d03 in dict_print_info_on_foreign_keys (create_table_format=1, file=0x17dbc70, trx=0x7ff7c0007cb8, table=0x7ff808042108) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c:5407 #8 0x0000000000834ca1 in ha_innobase::get_foreign_key_create_info (this=0x7ff80807d640) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:9835 #9 0x00000000005eefa2 in store_create_info (thd=0x1c8cd70, table_list=0x7ff7c0004cf8, packet=0x7ff82461b4d0, create_info_arg=0x0, show_database=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_show.cc:1383 #10 0x00000000005f42cf in mysqld_show_create (thd=0x1c8cd70, table_list=0x7ff7c0004cf8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_show.cc:751 #11 0x00000000005a1c84 in mysql_execute_command (thd=0x1c8cd70) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2970 #12 0x00000000005a5d30 in mysql_parse (thd=0x1c8cd70, rawbuf=0x7ff7c0004c10 "SHOW CREATE TABLE `C`", length=, parser_state=0x7ff82461cb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c8cd70, packet=, packet_length=21) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x1c8cd70) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x1c8cd70) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 19 (LWP 26907): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009735ee in os_cond_wait_timed (abstime=0x7ff822ebbd60, mutex=0x16887a0, cond=0x16887d8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x16887a0, time_in_usec=, reset_sig_count=1) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:716 #3 0x0000000000875e62 in srv_monitor_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:2624 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 18 (LWP 26897): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=1, array=0x17f9520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=3, message1=0x7ff8355a5db8, message2=0x7ff8355a5db0, type=0x7ff8355a5da8, space_id=0x7ff8355a5da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=3) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 17 (LWP 26895): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=0, array=0x17eb2a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=1, message1=0x7ff8369a7db8, message2=0x7ff8369a7db0, type=0x7ff8369a7da8, space_id=0x7ff8369a7da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=1) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 16 (LWP 27039): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff824596e00, mutex=0x1c94758, that=0x1c94788) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1c94758, thd=0x1c94650, abs_timeout=0x7ff824596e00, set_status_on_timeout=false, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x000000000065988c in MDL_context::acquire_lock (this=0x1c94758, mdl_request=0x7ff824596e70, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2104 #4 0x0000000000659b36 in MDL_context::upgrade_shared_lock_to_exclusive (this=0x1c94758, mdl_ticket=0x7ff7bc004a60, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2283 #5 0x0000000000562f26 in wait_while_table_is_used (thd=0x1c94650, table=0x7ff7d800a490, function=HA_EXTRA_FORCE_REOPEN) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2307 #6 0x000000000060b2e2 in mysql_alter_table (thd=0x1c94650, new_db=0x7ff7bc005400 "test", new_name=0x7ff7bc004ea0 "A", create_info=0x7ff824599370, table_list=0x7ff7bc004ed8, alter_info=0x7ff824599450, order_num=0, order=0x0, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:6192 #7 0x00000000007ce5dd in Alter_table_statement::execute (this=, thd=0x1c94650) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_alter.cc:106 #8 0x00000000005a5445 in mysql_execute_command (thd=0x1c94650) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4660 #9 0x00000000005a5d30 in mysql_parse (thd=0x1c94650, rawbuf=0x7ff7bc004c10 "/* GenTest::Transform::DisableIndexes */ ALTER TABLE A DISABLE KEYS; ALTER TABLE AA DISABLE KEYS; ALTER TABLE B DISABLE KEYS; ALTER TABLE BB DISABLE KEYS; ALTER TABLE C DISABLE KEYS; ALTER TABLE CC DISABLE KEYS; ALTER TABLE D DISABLE KEYS; ALTER TABLE DD DISABLE KEYS", length=, parser_state=0x7ff82459ab10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #10 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c94650, packet=, packet_length=267) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #11 0x00000000005a8783 in do_command (thd=0x1c94650) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #12 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #13 0x000000000064f8ce in handle_one_connection (arg=0x1c94650) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #14 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #15 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 15 (LWP 26982): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000701cbf in inline_mysql_cond_timedwait (src_line=3809, src_file=0xad14c0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc", abstime=0x7ff824863850, mutex=0x1150d80 , that=0x7ff7f8012668) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 Interruptible_wait::wait (this=0x7ff824863920, cond=0x7ff7f8012668, mutex=0x1150d80 ) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3809 #3 0x000000000070df3d in Item_func_get_lock::val_int (this=0x7ff7ec004f78) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3912 #4 0x00000000006c4106 in Item::send (this=0x7ff7ec004f78, protocol=0x1c49280, buffer=0x7ff824863d00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item.cc:6002 #5 0x000000000052a49f in Protocol::send_result_set_row (this=0x1c49280, row_items=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/protocol.cc:847 #6 0x0000000000575862 in select_send::send_data (this=0x7ff7ec005120, items=...) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_class.cc:2369 #7 0x00000000005e3026 in JOIN::exec (this=0x7ff7ec005140) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:1918 #8 0x00000000005e5e13 in mysql_select (thd=0x1c48d90, rref_pointer_array=0x1c4b258, tables=0x0, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147781376, result=0x7ff7ec005120, unit=0x1c4aa50, select_lex=0x1c4b070) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2645 #9 0x00000000005e63ae in handle_select (thd=0x1c48d90, lex=0x1c4a990, result=0x7ff7ec005120, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #10 0x000000000059ce8e in execute_sqlcom_select (thd=0x1c48d90, all_tables=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4819 #11 0x00000000005a0bcb in mysql_execute_command (thd=0x1c48d90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2322 #12 0x00000000005a5d30 in mysql_parse (thd=0x1c48d90, rawbuf=0x7ff7ec004cb0 "/* GenTest::Transform::Count */ SELECT GET_LOCK('LOCK', 65535) /* TRANSFORM_OUTCOME_COUNT */", length=, parser_state=0x7ff824865b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c48d90, packet=, packet_length=93) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x1c48d90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x1c48d90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 14 (LWP 27009): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff8247a0de0, mutex=0x1c5f938, that=0x1c5f968) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1c5f938, thd=0x1c5f830, abs_timeout=0x7ff8247a0de0, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1c5f938, mdl_request=0x7ff7d8005f58, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1c5f938, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x1c5f830, tables_start=0x7ff7d8004eb0, tables_end=, lock_wait_timeout=31536000, flags=611979552) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x0000000000563f1d in open_tables (thd=0x1c5f830, start=0x7ff8247a1358, counter=0x7ff8247a139c, flags=0, prelocking_strategy=0x7ff8247a14e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4986 #7 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7d8004eb0, derived=true, flags=0, prelocking_strategy=0x7ff8247a14e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #8 0x0000000000620f4e in open_and_lock_tables (flags=0, derived=true, tables=, thd=0x1c5f830) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:505 #9 mysql_create_view (thd=0x1c5f830, views=0x7ff7d8004eb0, mode=VIEW_CREATE_OR_REPLACE) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:438 #10 0x00000000005a4ed1 in mysql_execute_command (thd=0x1c5f830) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4497 #11 0x00000000005a5d30 in mysql_parse (thd=0x1c5f830, rawbuf=0x7ff7d8004c10 "CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW transforms.view_27008_temptable AS SELECT X . `col_mediumint_not_null_key` FROM `C` AS X WHERE X . `col_tinyint_not_null_key` < 2555248640 LIMIT 5 /*Generated by THREAD_ID 14*/", length=, parser_state=0x7ff8247a2b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c5f830, packet=, packet_length=221) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1c5f830) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1c5f830) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 13 (LWP 26896): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=0, array=0x17f9520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=2, message1=0x7ff835fa6db8, message2=0x7ff835fa6db0, type=0x7ff835fa6da8, space_id=0x7ff835fa6da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=2) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 12 (LWP 26909): +bt #0 0x000000340c4e14f3 in select () from /lib64/libc.so.6 #1 0x0000000000973c77 in os_thread_sleep (tm=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0thread.c:259 #2 0x0000000000877141 in srv_master_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:3466 #3 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #4 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 11 (LWP 27017): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff8246dd470, mutex=0x1c763d8, that=0x1c76408) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1c763d8, thd=0x1c762d0, abs_timeout=0x7ff8246dd470, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1c763d8, mdl_request=0x7ff7d4005b20, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x00000000005585f2 in open_table_get_mdl_lock (thd=0x1c762d0, ot_ctx=0x7ff8246de0a0, mdl_request=0x7ff7d4005b20, flags=0, mdl_ticket=0x7ff8246ddf68) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2607 #5 0x0000000000561e08 in open_table (thd=0x1c762d0, table_list=0x7ff7d40057b0, mem_root=0x7ff8246de060, ot_ctx=0x7ff8246de0a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2940 #6 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff8246de060, ot_ctx=0x7ff8246de0a0, has_prelocking_list=false, prelocking_strategy=0x7ff8246de4b0, flags=0, counter=0x7ff8246de520, tables=0x7ff7d40057b0, lex=0x1c77ed0, thd=0x1c762d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #7 open_tables (thd=0x1c762d0, start=0x7ff8246de208, counter=0x7ff8246de520, flags=0, prelocking_strategy=0x7ff8246de4b0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #8 0x000000000061acbe in open_tables (flags=0, counter=0x7ff8246de520, tables=0x7ff8246de208, thd=0x1c762d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:484 #9 mysql_update (thd=0x1c762d0, table_list=0x7ff7d40057b0, fields=..., values=..., conds=0x7ff7d4006058, order_num=65, order=0x7ff7d40062e8, limit=6, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7ff8246df130, updated_return=0x7ff8246df128) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_update.cc:284 #10 0x00000000005a1e0c in mysql_execute_command (thd=0x1c762d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3011 #11 0x00000000005a5d30 in mysql_parse (thd=0x1c762d0, rawbuf=0x7ff7d4004c10 "UPDATE `A` SET `col_int` = 5 WHERE `col_char_10` IN ('KPDUC') ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_binary_5`,`col_binary_5_key`,`col_binary_5_not_null`,`col_binary_5_not_null_key`,`col_char_10`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_char_128`,`col_char_128_key`,`col_char_128_not_null`,`col_char_128_not_null_key`,`col_date`,`col_date_key`,`col_date_not_null`,`col_date_not_null_key`,`col_datetime`,`col_datetime_key`,`col_datetime_not_null`,`col_datetime_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_mediumint`,`col_mediumint_key`,`col_mediumint_not_null`,`col_mediumint_not_null_key`,`col_smallint`,`col_smallint_key`,`col_smallint_not_null`,`col_smallint_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`col_time`,`col_time_key`,`col_time_not_null`,`col_time_not_null_key`,`col_timestamp`,`col_timestamp_key`,`col_timestamp_not_null`,`col_timestamp_not_null_key`,`col_tinyint`,`col_tinyint_key`,`col_tinyint_not_null`,`col_tinyint_not_null_key`,`col_varbinary_5`,`col_varbinary_5_key`,`col_varbinary_5_not_null`,`col_varbinary_5_not_null_key`,`col_year`,`col_year_key`,`col_year_not_null`,`col_year_not_null_key`,`pk` LIMIT 6 /*Generated by THREAD_ID 16*/", length=, parser_state=0x7ff8246dfb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c762d0, packet=, packet_length=1393) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1c762d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1c762d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 10 (LWP 26894): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=0, array=0x17dd020) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=0, message1=0x7ff8381a6db8, message2=0x7ff8381a6db0, type=0x7ff8381a6da8, space_id=0x7ff8381a6da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 9 (LWP 27047): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2bbd0, cond=0x1b2bc08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2bbd0, reset_sig_count=2145) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=9) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e167 in rw_lock_x_lock_func (lock=0x1161620 , pass=0, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0rw.c:700 #5 0x000000000084f82e in pfs_rw_lock_x_lock_func (line=8208, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7ff7b0007cb8, file=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:1848 #7 0x0000000000835987 in ha_innobase::create (this=, name=, form=0x7ff8206724b0, create_info=0x7ff820675bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:8208 #8 0x00000000006bf9cf in handler::ha_create (this=0x7ff7b000f220, name=0x7ff820674290 "./transforms/where_updatedelete_27046", form=0x7ff8206724b0, info=0x7ff820675bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:3718 #9 0x00000000006bfdad in ha_create_table (thd=0x1cab420, path=0x7ff820674290 "./transforms/where_updatedelete_27046", db=0x7ff7b0004d10 "transforms", table_name=0x7ff7b0004d20 "where_updatedelete_27046", create_info=0x7ff820675bd0, update_create_info=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:4031 #10 0x0000000000634ff8 in rea_create_table (thd=0x1cab420, path=0x7ff820674290 "./transforms/where_updatedelete_27046", db=0x7ff7b0004d10 "transforms", table_name=0x7ff7b0004d20 "where_updatedelete_27046", create_info=0x7ff820675bd0, create_fields=..., keys=0, key_info=0x7ff7b0005778, file=0x7ff7b0011000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:528 #11 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1cab420, db=0x7ff7b0004d10 "transforms", table_name=0x7ff7b0004d20 "where_updatedelete_27046", create_info=0x7ff820675bd0, alter_info=0x7ff8206755e0, internal_tmp_table=155, select_field_count=1, is_trans=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #12 0x00000000005896bb in create_table_from_items (thd=0x1cab420, create_info=0x7ff820675bd0, create_table=0x7ff7b0004d88, alter_info=0x7ff8206755e0, items=, lock=0x7ff8206752c8, hooks=0x7ff820675280) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3785 #13 0x000000000058c82f in select_create::prepare (this=0x7ff7b00054f8, values=..., u=0x1cad0e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3938 #14 0x00000000005d1651 in JOIN::prepare (this=0x7ff7b003e770, rref_pointer_array=0x1cad8e8, tables_init=, wild_num=, conds_init=, og_num=2953051120, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1cad700, unit_arg=0x1cad0e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:750 #15 0x00000000005e5da4 in mysql_select (thd=0x1cab420, rref_pointer_array=0x1cad8e8, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7ff7b00054f8, unit=0x1cad0e0, select_lex=0x1cad700) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2624 #16 0x00000000005e63ae in handle_select (thd=0x1cab420, lex=0x1cad020, result=0x7ff7b00054f8, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #17 0x00000000005a1700 in mysql_execute_command (thd=0x1cab420) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2757 #18 0x00000000005a5d30 in mysql_parse (thd=0x1cab420, rawbuf=0x7ff7b0004c10 "CREATE TABLE transforms.where_updatedelete_27046 SELECT 1", length=, parser_state=0x7ff820676b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #19 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1cab420, packet=, packet_length=58) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #20 0x00000000005a8783 in do_command (thd=0x1cab420) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #21 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #22 0x000000000064f8ce in handle_one_connection (arg=0x1cab420) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #23 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #24 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 8 (LWP 27006): +bt #0 0x000000340cc0e54d in read () from /lib64/libpthread.so.0 #1 0x0000000000a2e46a in vio_read (vio=0x1c6a6a0, buf=0x1c6a8a0 "\001", size=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/vio/viosocket.c:56 #2 0x000000000052472a in my_real_read (net=0x1c67340, complen=0x7ff824761cc8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:834 #3 0x0000000000524a55 in my_net_read (net=0x1c67340) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:1033 #4 0x00000000005a8620 in do_command (thd=0x1c67110) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:735 #5 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #6 0x000000000064f8ce in handle_one_connection (arg=0x1c67110) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #7 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #8 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 7 (LWP 26959): +bt #0 0x000000340cc0e54d in read () from /lib64/libpthread.so.0 #1 0x0000000000a2e46a in vio_read (vio=0x1c3d160, buf=0x1c3d360 "\001", size=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/vio/viosocket.c:56 #2 0x000000000052472a in my_real_read (net=0x1c39e00, complen=0x7ff8248e7cc8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:834 #3 0x0000000000524a55 in my_net_read (net=0x1c39e00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:1033 #4 0x00000000005a8620 in do_command (thd=0x1c39bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:735 #5 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #6 0x000000000064f8ce in handle_one_connection (arg=0x1c39bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #7 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #8 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 6 (LWP 26993): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff824822cf0, mutex=0x1c50778, that=0x1c507a8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1c50778, thd=0x1c50670, abs_timeout=0x7ff824822cf0, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1c50778, mdl_request=0x7ff824822db0, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1c50778, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000007558f3 in lock_schema_name (thd=0x1c50670, db=0x7ff7e0004db0 "transforms") at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/lock.cc:789 #6 0x000000000058183f in mysql_create_db (thd=0x1c50670, db=0x7ff7e0004db0 "transforms", create_info=0x7ff824823bd0, silent=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_db.cc:559 #7 0x00000000005a2f55 in mysql_execute_command (thd=0x1c50670) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3513 #8 0x00000000005a5d30 in mysql_parse (thd=0x1c50670, rawbuf=0x7ff7e0004c80 "/* GenTest::Transform::ExecuteAsInsertSelect */ CREATE DATABASE IF NOT EXISTS transforms", length=, parser_state=0x7ff824824b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #9 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c50670, packet=, packet_length=88) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #10 0x00000000005a8783 in do_command (thd=0x1c50670) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #11 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #12 0x000000000064f8ce in handle_one_connection (arg=0x1c50670) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #13 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #14 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 5 (LWP 27000): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff8247e17c0, mutex=0x1c58058, that=0x1c58088) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1c58058, thd=0x1c57f50, abs_timeout=0x7ff8247e17c0, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1c58058, mdl_request=0x7ff7e4006230, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x00000000005585f2 in open_table_get_mdl_lock (thd=0x1c57f50, ot_ctx=0x7ff8247e23f0, mdl_request=0x7ff7e4006230, flags=0, mdl_ticket=0x7ff8247e22b8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2607 #5 0x0000000000561e08 in open_table (thd=0x1c57f50, table_list=0x7ff7e4005ec0, mem_root=0x7ff8247e23b0, ot_ctx=0x7ff8247e23f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2940 #6 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff8247e23b0, ot_ctx=0x7ff8247e23f0, has_prelocking_list=false, prelocking_strategy=0x7ff8247e2550, flags=0, counter=0x7ff8247e251c, tables=0x7ff7e4005ec0, lex=0x1c59b50, thd=0x1c57f50) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #7 open_tables (thd=0x1c57f50, start=0x7ff8247e24d8, counter=0x7ff8247e251c, flags=0, prelocking_strategy=0x7ff8247e2550) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #8 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7e4005ec0, derived=true, flags=0, prelocking_strategy=0x7ff8247e2550) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #9 0x00000000005a9b0b in open_and_lock_tables (thd=, tables=, derived=, flags=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:505 #10 0x00000000005a23a8 in mysql_execute_command (thd=0x1c57f50) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3194 #11 0x00000000005a5d30 in mysql_parse (thd=0x1c57f50, rawbuf=0x7ff7e4004c80 "INSERT INTO `A` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` FROM `B` WHERE 0 BETWEEN 82 AND 1922301952 ORDER BY `col_bigint`,`col_bigint_key`,`col_bigint_not_null`,`col_bigint_not_null_key`,`col_binary_5`,`col_binary_5_key`,`col_binary_5_not_null`,`col_binary_5_not_null_key`,`col_char_10`,`col_char_10_key`,`col_char_10_not_null`,`col_char_10_not_null_key`,`col_char_128`,`col_char_128_key`,`col_char_128_not_null`,`col_char_128_not_null_key`,`col_date`,`col_date_key`,`col_date_not_null`,`col_date_not_null_key`,`col_datetime`,`col_datetime_key`,`col_datetime_not_null`,`col_datetime_not_null_key`,`col_enum`,`col_enum_key`,`col_enum_not_null`,`col_enum_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_mediumint`,`col_mediumint_key`,`col_mediumint_not_null`,`col_mediumint_not_null_key`,`col_smallint`,`col_smallint_key`,`col_smallint_not_null`,`col_smallint_not_null_key`,`col_text`,`col_text_key`,`col_text_not_null`,`col_text_not_null_key`,`col_time`,`col_time_key`,`col_time_not_null`,`col_time_not_null_key`,`col_timestamp`,`col_timestamp_key`,`col_timestamp_not_null`,`col_timestamp_not_null_key`,`col_tinyint`,`col_tinyint_key`,`col_tinyint_not_null`,`col_tinyint_not_null_key`,`col_varbinary_5`,`col_varbinary_5_key`,`col_varbinary_5_not_null`,`col_varbinary_5_not_null_key`,`col_year`,`col_year_key`,`col_year_not_null`,`col_year_not_null_key`,`pk` LIMIT 25 /*Generated by THREAD_ID 12*/", length=, parser_state=0x7ff8247e3b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c57f50, packet=, packet_length=2244) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1c57f50) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1c57f50) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 4 (LWP 26952): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2b9d0, cond=0x1b2ba08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2b9d0, reset_sig_count=2742) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=3) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087ec89 in mutex_spin_wait (mutex=0x1b2b8c8, file_name=0xb260a0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c", line=767) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0sync.c:653 #5 0x00000000008f7e8a in mutex_enter_func (line=767, file_name=0xb260a0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c", mutex=0x1b2b8c8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x1b2b8c8, file_name=0xb260a0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c", line=767) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0sync.ic:251 #7 0x00000000009043ff in dict_table_get (table_name=0x7ff824925f40 "drizzledump_db/trigger126951", inc_mysql_count=1, ignore_err=DICT_ERR_IGNORE_NONE) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/dict/dict0dict.c:767 #8 0x0000000000833b64 in ha_innobase::open (this=0x7ff7fc038100, name=, mode=, test_if_locked=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:4750 #9 0x00000000006b9bb5 in handler::ha_open (this=0x7ff7fc038100, table_arg=0x7ff7fc01c740, name=0x7ff7fc022908 "./drizzledump_db/trigger126951", mode=2, test_if_locked=2) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:2340 #10 0x0000000000625dc5 in open_table_from_share (thd=0x1c324f0, share=, alias=, db_stat=39, prgflag=, ha_open_flags=0, outparam=0x7ff7fc01c740, is_create_table=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/table.cc:2064 #11 0x0000000000562702 in open_table (thd=0x1c324f0, table_list=0x7ff7fc004d28, mem_root=0x7ff824927150, ot_ctx=0x7ff824927190) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:3131 #12 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff824927150, ot_ctx=0x7ff824927190, has_prelocking_list=false, prelocking_strategy=0x7ff8249274c0, flags=0, counter=0x7ff8249272bc, tables=0x7ff7fc004d28, lex=0x1c340f0, thd=0x1c324f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #13 open_tables (thd=0x1c324f0, start=0x7ff824927278, counter=0x7ff8249272bc, flags=0, prelocking_strategy=0x7ff8249274c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #14 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7fc004d28, derived=true, flags=0, prelocking_strategy=0x7ff8249274c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #15 0x0000000000591459 in open_and_lock_tables (flags=0, derived=true, tables=0x7ff7fc004d28, thd=0x1c324f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:505 #16 mysql_insert (thd=0x1c324f0, table_list=0x7ff7fc004d28, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:740 #17 0x00000000005a21a4 in mysql_execute_command (thd=0x1c324f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3136 #18 0x00000000005a5d30 in mysql_parse (thd=0x1c324f0, rawbuf=0x7ff7fc004c10 "INSERT INTO trigger126951 VALUES (1)", length=, parser_state=0x7ff824928b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #19 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c324f0, packet=, packet_length=36) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #20 0x00000000005a8783 in do_command (thd=0x1c324f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #21 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #22 0x000000000064f8ce in handle_one_connection (arg=0x1c324f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #23 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #24 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 3 (LWP 26946): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009736e7 in os_cond_wait (mutex=0x1b2bbd0, cond=0x1b2bc08) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1b2bbd0, reset_sig_count=2145) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:609 #3 0x000000000087d24a in sync_array_wait_event (arr=0x13d65c0, index=0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e167 in rw_lock_x_lock_func (lock=0x1161620 , pass=0, file_name=0xb0cb30 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c", line=3284) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0rw.c:700 #5 0x000000000084f82e in pfs_rw_lock_x_lock_func (line=3284, file_name=0xb0cb30 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c", pass=0, lock=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7ff80408c088, file=0xb0cb30 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c", line=3284) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:1848 #7 0x0000000000853e23 in row_drop_table_for_mysql (name=0x7ff83405b8f0 "transforms/where_updatedelete_26945", trx=0x7ff80408c088, drop_db=0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:3284 #8 0x0000000000830463 in ha_innobase::delete_table (this=, name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:8504 #9 0x00000000006becda in handler::ha_delete_table (this=0x7ff80400a640, name=0x7ff83405d190 "./transforms/where_updatedelete_26945") at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:3688 #10 0x00000000006bef12 in ha_delete_table (thd=0x1406970, table_type=, path=0x7ff83405d190 "./transforms/where_updatedelete_26945", db=0x7ff804004d08 "transforms", alias=0x7ff804004d18 "where_updatedelete_26945", generate_warning=true) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:2231 #11 0x0000000000609aef in mysql_rm_table_no_locks (thd=0x1406970, tables=0x7ff804004d80, if_exists=true, drop_temporary=false, drop_view=false, dont_log_query=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:2255 #12 0x000000000060a472 in mysql_rm_table (thd=0x1406970, tables=0x7ff804004d80, if_exists=1 '\001', drop_temporary=0 '\000') at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:1959 #13 0x00000000005a28d2 in mysql_execute_command (thd=0x1406970) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3328 #14 0x00000000005a5d30 in mysql_parse (thd=0x1406970, rawbuf=0x7ff804004c10 "DROP TABLE IF EXISTS transforms.where_updatedelete_26945", length=, parser_state=0x7ff83405eb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #15 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1406970, packet=, packet_length=56) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #16 0x00000000005a8783 in do_command (thd=0x1406970) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #17 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #18 0x000000000064f8ce in handle_one_connection (arg=0x1406970) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #19 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #20 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 2 (LWP 26963): +bt #0 0x00000000008a50d1 in ut_delay (delay=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/ut/ut0ut.c:419 #1 0x000000000087de18 in rw_lock_x_lock_func (lock=0x1161620 , pass=0, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/sync/sync0rw.c:650 #2 0x000000000084f82e in pfs_rw_lock_x_lock_func (line=8208, file_name=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/sync0rw.ic:689 #3 row_mysql_lock_data_dictionary_func (trx=0x7ff7f400ecd8, file=0xb03588 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc", line=8208) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0mysql.c:1848 #4 0x0000000000835987 in ha_innobase::create (this=, name=, form=0x7ff8248a24b0, create_info=0x7ff8248a5bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:8208 #5 0x00000000006bf9cf in handler::ha_create (this=0x7ff7f4042c40, name=0x7ff8248a4290 "./transforms/insert_select_26961", form=0x7ff8248a24b0, info=0x7ff8248a5bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:3718 #6 0x00000000006bfdad in ha_create_table (thd=0x1c414b0, path=0x7ff8248a4290 "./transforms/insert_select_26961", db=0x7ff7f4004e58 "transforms", table_name=0x7ff7f4004e68 "insert_select_26961", create_info=0x7ff8248a5bd0, update_create_info=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/handler.cc:4031 #7 0x0000000000634ff8 in rea_create_table (thd=0x1c414b0, path=0x7ff8248a4290 "./transforms/insert_select_26961", db=0x7ff7f4004e58 "transforms", table_name=0x7ff7f4004e68 "insert_select_26961", create_info=0x7ff8248a5bd0, create_fields=..., keys=0, key_info=0x7ff7f400dd78, file=0x7ff7f404e0e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:528 #8 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1c414b0, db=0x7ff7f4004e58 "transforms", table_name=0x7ff7f4004e68 "insert_select_26961", create_info=0x7ff8248a5bd0, alter_info=0x7ff8248a55e0, internal_tmp_table=155, select_field_count=2, is_trans=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #9 0x00000000005896bb in create_table_from_items (thd=0x1c414b0, create_info=0x7ff8248a5bd0, create_table=0x7ff7f4004ec0, alter_info=0x7ff8248a55e0, items=, lock=0x7ff8248a52c8, hooks=0x7ff8248a5280) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3785 #10 0x000000000058c82f in select_create::prepare (this=0x7ff7f4006800, values=..., u=0x1c43170) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3938 #11 0x00000000005d1651 in JOIN::prepare (this=0x7ff7f400c140, rref_pointer_array=0x1c43978, tables_init=, wild_num=, conds_init=, og_num=4093695424, order_init=0x7ff7f4006348, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1c43790, unit_arg=0x1c43170) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:750 #12 0x00000000005e5da4 in mysql_select (thd=0x1c414b0, rref_pointer_array=0x1c43978, tables=0x7ff7f4005698, wild_num=0, fields=..., conds=0x7ff7f4005f68, og_num=3, order=0x7ff7f4006348, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7ff7f4006800, unit=0x1c43170, select_lex=0x1c43790) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2624 #13 0x00000000005e63ae in handle_select (thd=0x1c414b0, lex=0x1c430b0, result=0x7ff7f4006800, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #14 0x00000000005a1700 in mysql_execute_command (thd=0x1c414b0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2757 #15 0x00000000005a5d30 in mysql_parse (thd=0x1c414b0, rawbuf=0x7ff7f4004c10 "CREATE TABLE transforms.insert_select_26961 SELECT `col_enum` AS c1 , `col_time` AS c2 FROM `CC` WHERE `col_time_key` NOT BETWEEN `col_date_not_null_key` AND LOCALTIMESTAMP() ORDER BY `col_year` , `col_varbinary_5` , `col_enum`", length=, parser_state=0x7ff8248a6b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #16 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c414b0, packet=, packet_length=228) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #17 0x00000000005a8783 in do_command (thd=0x1c414b0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #18 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #19 0x000000000064f8ce in handle_one_connection (arg=0x1c414b0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #20 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #21 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 1 (LWP 26943): +bt #0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000007ef479 in my_write_core (sig=6) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/stacktrace.c:433 #2 0x00000000006b6c75 in handle_fatal_signal (sig=6) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/signal_handler.cc:250 #3 #4 0x000000340c4328a5 in raise () from /lib64/libc.so.6 #5 0x000000340c434085 in abort () from /lib64/libc.so.6 #6 0x000000000083dca1 in buf_block_get_frame (block=0x7ff827b75fd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/buf0buf.ic:725 #7 i_s_innodb_buffer_pool_pages_blob_fill (thd=0x1c1f940, tables=, cond=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/i_s.cc:6776 #8 0x00000000005ebbb3 in do_fill_table (join_table=0x7ff808013da0, table_list=0x7ff808005100, thd=0x1c1f940) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_show.cc:7462 #9 get_schema_tables_result (join=0x7ff808012040, executed_place=PROCESSED_BY_JOIN_EXEC) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_show.cc:7568 #10 0x00000000005e329e in JOIN::exec (this=0x7ff808012040) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:1959 #11 0x00000000005e5e13 in mysql_select (thd=0x1c1f940, rref_pointer_array=0x1c21e08, tables=0x7ff808005100, wild_num=1, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2684619520, result=0x7ff80801c8e8, unit=0x1c21600, select_lex=0x1c21c20) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2645 #12 0x00000000005e63ae in handle_select (thd=0x1c1f940, lex=0x1c21540, result=0x7ff80801c8e8, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #13 0x000000000059ce8e in execute_sqlcom_select (thd=0x1c1f940, all_tables=0x7ff808005100) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4819 #14 0x00000000005a0bcb in mysql_execute_command (thd=0x1c1f940) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2322 #15 0x00000000005a5d30 in mysql_parse (thd=0x1c1f940, rawbuf=0x7ff808004c10 "SELECT * FROM INFORMATION_SCHEMA . `INNODB_BUFFER_POOL_PAGES_BLOB` AS table1 WHERE (NOT ( ( (NOT table1 . `next_page_no` >= table1 . `space_id` AND table1 . `compressed` >= table1 . `compressed`) AND table1 . `compressed` >= 'mp') AND table1 . `space_id` <= table1 . `next_page_no`) OR table1 . `lru_position` = table1 . `part_len`) LIMIT 2", length=, parser_state=0x7ff813ffeb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #16 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1c1f940, packet=, packet_length=342) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #17 0x00000000005a8783 in do_command (thd=0x1c1f940) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #18 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #19 0x000000000064f8ce in handle_one_connection (arg=0x1c1f940) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #20 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #21 0x000000340c4e890d in clone () from /lib64/libc.so.6 (gdb) +set logging off