(gdb) +thread apply all bt Thread 48 (LWP 22463): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f022862f780, mutex=0x298bfb8, that=0x298bfe8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x298bfb8, owner=0x298be80, abs_timeout=0x7f022862f780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x298bfb8, mdl_request=0x7f01c8005c48, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x298be80, ot_ctx=0x7f02286301e0, mdl_request=0x7f01c8005c48, flags=, mdl_ticket=0x7f02286300e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x298be80, table_list=0x7f01c80058a8, ot_ctx=0x7f02286301e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f02286301e0, has_prelocking_list=false, prelocking_strategy=0x7f0228630300, flags=0, counter=0x298e300, tables=0x7f01c80058a8, lex=0x298e248, thd=0x298be80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x298be80, start=0x7f02286302c8, counter=0x298e300, flags=0, prelocking_strategy=0x7f0228630300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01c80052d8, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000071eb4d in execute_sqlcom_select (thd=0x298be80, all_tables=0x7f01c80052d8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #10 0x00000000007217b7 in mysql_execute_command (thd=0x298be80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #11 0x0000000000727818 in mysql_parse (thd=0x298be80, rawbuf=0x298e248 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x298be80, packet=0x298fe11 " SELECT table1 . `col_decimal_unsigned_not_null` AS field1 FROM table1_int AS table1 LEFT JOIN table1_int_autoinc AS table2 ON table1 . `col_int` = table2 . `pk` WHERE table2 . `col_int_key` > 9 AND table2 . `col_int_key` <= ( 2 + 75 ) AND table2 . `col_int` > 3 AND table2 . `col_int` < ( 0 + 10 ) AND table2 . `col_int` > 8 AND table2 . `col_int` < ( 7 + 6 ) AND table1 . `col_int_key` > 2 AND table1 . `col_int_key` < ( 2 + 6 ) AND table2 . `pk` > 6 AND table2 . `pk` < ( 2 + 1 ) AND table2 . `col_int` IN (2) ", packet_length=524) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #13 0x0000000000729a47 in do_command (thd=0x298be80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #14 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #15 0x00000000006ed727 in handle_one_connection (arg=0x298be80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 47 (LWP 22434): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6f533 in os_cond_wait (fast_mutex=0x27a0fd0, cond=0x27a1010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x27a0fd0, reset_sig_count=134) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610 #3 0x0000000000b0ba31 in sync_array_wait_event (arr=0x23d69f0, index=2) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/sync/sync0arr.cc:424 #4 0x0000000000b0d9ec in mutex_spin_wait (mutex=0x27a0ee8, file_name=0xdc8958 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/handler0alter.cc", line=3919) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/sync/sync0sync.cc:583 #5 0x0000000000a10d1d in pfs_mutex_enter_func (line=3919, mutex=0x27a0ee8, file_name=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/include/sync0sync.ic:251 #6 ha_innobase::inplace_alter_table (this=0x7f01bc022a20, altered_table=0x7f02182e8330, ha_alter_info=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/handler0alter.cc:3919 #7 0x0000000000c55e0a in ha_inplace_alter_table (ha_alter_info=0x7f0228733ad0, altered_table=0x7f02182e8330, this=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.h:2874 #8 ha_partition::inplace_alter_table (this=0x7f01bc02bd90, altered_table=0x7f02182e8330, ha_alter_info=0x7f0228733ad0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:7953 #9 0x000000000077dd51 in ha_inplace_alter_table (ha_alter_info=0x7f0228733ad0, altered_table=0x7f02182e8330, this=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.h:2874 #10 mysql_inplace_alter_table (thd=0x293b0a0, table_list=0x7f02180d1fa8, table=0x7f01bc03c220, altered_table=0x7f02182e8330, ha_alter_info=0x7f0228733ad0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f02287337d0, alter_ctx=0x7f02287321b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:6485 #11 0x00000000007839b7 in mysql_alter_table (thd=, new_db=0x7f02182e8330 "", new_name=0x7f021828a6f0 "\f", create_info=, table_list=0x7f02180d1fa8, alter_info=0x7f0228734270, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8354 #12 0x0000000000892ca7 in Sql_cmd_alter_table::execute (this=, thd=0x293b0a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317 #13 0x000000000072102b in mysql_execute_command (thd=0x293b0a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157 #14 0x0000000000727818 in mysql_parse (thd=0x293b0a0, rawbuf=0x293d468 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #15 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x293b0a0, packet=0x293f361 " ALTER TABLE table0_key_pk_parts_2_int ADD INDEX `test_idx` USING BTREE (`pk`, `col_int_key`, `col_int` ) ", packet_length=106) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #16 0x0000000000729a47 in do_command (thd=0x293b0a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #17 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #18 0x00000000006ed727 in handle_one_connection (arg=0x293b0a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #19 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #20 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #21 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 46 (LWP 22485): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02224b6780, mutex=0x29e9af8, that=0x29e9b28) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x29e9af8, owner=0x29e99c0, abs_timeout=0x7f02224b6780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x29e9af8, mdl_request=0x7f01a4005408, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x29e99c0, ot_ctx=0x7f02224b71e0, mdl_request=0x7f01a4005408, flags=, mdl_ticket=0x7f02224b70e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x29e99c0, table_list=0x7f01a4005068, ot_ctx=0x7f02224b71e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f02224b71e0, has_prelocking_list=false, prelocking_strategy=0x7f02224b7300, flags=0, counter=0x29ebe40, tables=0x7f01a4005068, lex=0x29ebd88, thd=0x29e99c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x29e99c0, start=0x7f02224b72c8, counter=0x29ebe40, flags=0, prelocking_strategy=0x7f02224b7300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01a4005068, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000071eb4d in execute_sqlcom_select (thd=0x29e99c0, all_tables=0x7f01a4005068) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #10 0x00000000007217b7 in mysql_execute_command (thd=0x29e99c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #11 0x0000000000727818 in mysql_parse (thd=0x29e99c0, rawbuf=0x29ebd88 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29e99c0, packet=0x29ed951 " SELECT DISTINCT table2 . `pk` AS field1 FROM table10_key_pk_parts_2_int AS table1 LEFT OUTER JOIN table1_int_autoinc AS table2 ON table1 . `col_varchar_1024_key` = table2 . `col_varchar_1024_key` WHERE table2 . `pk` IN (2, 95, 3, 2) ORDER BY field1 ", packet_length=256) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #13 0x0000000000729a47 in do_command (thd=0x29e99c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #14 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #15 0x00000000006ed727 in handle_one_connection (arg=0x29e99c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x295f640) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 45 (LWP 22471): +bt #0 0x000000340cc0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000340cc093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x000000340cc09326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000006c8f10 in inline_mysql_mutex_lock (src_line=115, src_file=0xcda4b0 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table_cache.h", that=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 lock (this=0x1502c20 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table_cache.h:115 #5 close_thread_table (thd=0x295f870, table_ptr=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1518 #6 0x00000000006c96e3 in close_open_tables (thd=0x295f870) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1241 #7 close_thread_tables (thd=0x295f870) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1467 #8 0x0000000000720e61 in mysql_execute_command (thd=0x295f870) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5226 #9 0x0000000000727818 in mysql_parse (thd=0x295f870, rawbuf=0x2961c38 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #10 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x295f870, packet=0x2a29da1 "", packet_length=58) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #11 0x0000000000729a47 in do_command (thd=0x295f870) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #12 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #13 0x00000000006ed727 in handle_one_connection (arg=0x295f870) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #14 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x293f000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #15 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #16 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 44 (LWP 22473): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f022852b0a0, mutex=0x29b84e8, that=0x29b8518) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x29b84e8, owner=0x29b83b0, abs_timeout=0x7f022852b0a0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x29b84e8, mdl_request=0x7f01bc005b88, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x29b83b0, ot_ctx=0x7f022852bb00, mdl_request=0x7f01bc005b88, flags=, mdl_ticket=0x7f022852ba08) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x29b83b0, table_list=0x7f01bc0057e8, ot_ctx=0x7f022852bb00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f022852bb00, has_prelocking_list=false, prelocking_strategy=0x7f022852bc20, flags=0, counter=0x29ba830, tables=0x7f01bc0057e8, lex=0x29ba778, thd=0x29b83b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x29b83b0, start=0x7f022852bbe8, counter=0x29ba830, flags=0, prelocking_strategy=0x7f022852bc20) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01bc0057e8, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000089b016 in mysql_delete (thd=0x29b83b0, table_list=0x7f01bc0057e8, conds=0x7f01bc005f78, order_list=0x29bb050, limit=3, options=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_delete.cc:72 #10 0x0000000000721953 in mysql_execute_command (thd=0x29b83b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3773 #11 0x0000000000727818 in mysql_parse (thd=0x29b83b0, rawbuf=0x29ba778 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29b83b0, packet=0x29bc341 " DELETE FROM `table0_int` WHERE `col_decimal_not_null_key` < 3716808704 ORDER BY `col_bit`,`col_bit_key`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_key`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_255_latin1`,`col_char_255_latin1_key`,`col_char_255_latin1_not_null`,`col_char_255_latin1_not_null_key`,`col_char_255_utf8`,`col_char_255_utf8_key`,`col_char_255_utf8_not_null`,`col_char_255_utf8_not_null_key`,`col_decimal`,`col_decimal_key`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_key`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_key`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_key`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_key`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_key`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_key`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_key`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_key`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 3 ", packet_length=1370) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #13 0x0000000000729a47 in do_command (thd=0x29b83b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #14 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #15 0x00000000006ed727 in handle_one_connection (arg=0x29b83b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x23ad470) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 43 (LWP 22465): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02283e3cf0, mutex=0x29940a8, that=0x29940d8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x29940a8, owner=0x2993f70, abs_timeout=0x7f02283e3cf0, set_status_on_timeout=false, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679f1f in MDL_context::acquire_lock (this=0x29940a8, mdl_request=0x7f02283e3d70, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2229 #4 0x000000000067a18a in MDL_context::upgrade_shared_lock (this=0x29940a8, mdl_ticket=0x7f01cc028330, new_type=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2411 #5 0x00000000006bccf0 in wait_while_table_is_used (thd=0x2993f70, table=0x7f01e801a860, function=HA_EXTRA_PREPARE_FOR_RENAME) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2226 #6 0x000000000077dd69 in mysql_inplace_alter_table (thd=0x2993f70, table_list=0x7f01cc004dc8, table=0x7f01e801a860, altered_table=0x7f01cc02fbf0, ha_alter_info=0x7f02283e5ad0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f02283e57d0, alter_ctx=0x7f02283e41b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:6492 #7 0x00000000007839b7 in mysql_alter_table (thd=, new_db=0x7f01cc02fbf0 "\300\004\003\314\001\177", new_name=0x7f01cc0092a0 "\f", create_info=, table_list=0x7f01cc004dc8, alter_info=0x7f02283e6270, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8354 #8 0x0000000000892ca7 in Sql_cmd_alter_table::execute (this=, thd=0x2993f70) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317 #9 0x000000000072102b in mysql_execute_command (thd=0x2993f70) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157 #10 0x0000000000727818 in mysql_parse (thd=0x2993f70, rawbuf=0x2996338 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x2993f70, packet=0x2997f01 " ALTER TABLE table0_int ADD INDEX `test_idx` USING BTREE (`col_int_key` , `pk` , `col_int` ) ", packet_length=93) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x2993f70) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #13 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #14 0x00000000006ed727 in handle_one_connection (arg=0x2993f70) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 42 (LWP 22430): +bt #0 0x000000340c4df253 in poll () from /lib64/libc.so.6 #1 0x0000000000c9e846 in vio_io_wait (vio=, event=VIO_IO_EVENT_READ, timeout=28800000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:820 #2 0x0000000000c9ece3 in vio_socket_io_wait (vio=, event=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:68 #3 0x0000000000c9f680 in vio_read (vio=0x2936d50, buf=0x2936f40 "\a", size=4) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:123 #4 0x000000000067b583 in net_read_raw_loop (net=0x2859dc0, count=4) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:663 #5 0x000000000067c0e1 in net_read_packet_header (net=0x2859dc0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:745 #6 net_read_packet (net=, complen=0x7f0228776c68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:810 #7 0x000000000067c3ec in my_net_read (net=0x2859dc0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:888 #8 0x00000000007299d7 in do_command (thd=0x2859b60) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:983 #9 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #10 0x00000000006ed727 in handle_one_connection (arg=0x2859b60) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #11 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28ba270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #12 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #13 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 41 (LWP 22427): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f0223ac3d00, fast_mutex=0x279f5d0, cond=0x279f610) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x279f5d0, time_in_usec=, reset_sig_count=24) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 #3 0x0000000000bb82e7 in dict_stats_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0stats_bg.cc:349 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 40 (LWP 22461): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02286707e0, mutex=0x2983ec8, that=0x2983ef8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2983ec8, owner=0x2983d90, abs_timeout=0x7f02286707e0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x2983ec8, mdl_request=0x7f01d4006318, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x2983d90, ot_ctx=0x7f0228671240, mdl_request=0x7f01d4006318, flags=, mdl_ticket=0x7f0228671148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x2983d90, table_list=0x7f01d4005f78, ot_ctx=0x7f0228671240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f0228671240, has_prelocking_list=false, prelocking_strategy=0x7f0228671360, flags=0, counter=0x2986210, tables=0x7f01d4005f78, lex=0x2986158, thd=0x2983d90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x2983d90, start=0x7f0228671328, counter=0x2986210, flags=0, prelocking_strategy=0x7f0228671360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01d4005f78, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x00000000007219f2 in mysql_execute_command (thd=0x2983d90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705 #10 0x0000000000727818 in mysql_parse (thd=0x2983d90, rawbuf=0x2986158 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x2983d90, packet=0x2987d21 "INSERT INTO `table10_key_pk_parts_2_int` ( `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 `table0_key_pk_parts_2_int_autoinc` WHERE 0 BETWEEN 242 AND 3027501056 ORDER BY `col_bit`,`col_bit_key`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_key`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_255_latin1`,`col_char_255_latin1_key`,`col_char_255_latin1_not_null`,`col_char_255_latin1_not_null_key`,`col_char_255_utf8`,`col_char_255_utf8_key`,`col_char_255_utf8_not_null`,`col_char_255_utf8_not_null_key`,`col_decimal`,`col_decimal_key`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_key`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_key`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_key`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_key`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_key`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_key`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_key`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_key`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 10 /*Generated by THREAD_ID 11*/", packet_length=2296) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x2983d90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #13 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #14 0x00000000006ed727 in handle_one_connection (arg=0x2983d90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 39 (LWP 22424): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6f533 in os_cond_wait (fast_mutex=0x27a0fd0, cond=0x27a1010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x27a0fd0, reset_sig_count=134) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610 #3 0x0000000000b0ba31 in sync_array_wait_event (arr=0x23d69f0, index=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/sync/sync0arr.cc:424 #4 0x0000000000b0d9ec in mutex_spin_wait (mutex=0x27a0ee8, file_name=0xe00808 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc", line=479) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/sync/sync0sync.cc:583 #5 0x0000000000b9a8e0 in pfs_mutex_enter_func (mutex=0x27a0ee8, line=479, file_name=0xe00808 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/include/sync0sync.ic:251 #6 0x0000000000b9aaf1 in dict_table_close (table=0x7f02181ad1f8, dict_locked=0, try_drop=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc:479 #7 0x0000000000add26c in row_purge_record_func (node=0x27c45d8, undo_rec=, thr=, updated_extern=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0purge.cc:829 #8 0x0000000000added0 in row_purge (thr=0x27c2f00, undo_rec=0x7f021003e470 "4\333\fV&", node=0x27c45d8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0purge.cc:862 #9 row_purge_step (thr=0x27c2f00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0purge.cc:942 #10 0x0000000000a977f8 in que_thr_step (thr=0x27c2f00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/que/que0que.cc:1115 #11 que_run_threads_low (thr=0x27c2f00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/que/que0que.cc:1177 #12 0x0000000000a97e30 in que_run_threads (thr=0x27c2f00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/que/que0que.cc:1218 #13 0x0000000000b16ca3 in trx_purge (n_purge_threads=1, batch_size=300, truncate=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/trx/trx0purge.cc:1251 #14 0x0000000000b03e11 in srv_do_purge (n_total_purged=, n_threads=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:3091 #15 srv_purge_coordinator_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:3268 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 38 (LWP 22425): +bt #0 0x000000340c4e14f3 in select () from /lib64/libc.so.6 #1 0x0000000000a6f8bf in os_thread_sleep (tm=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0thread.cc:255 #2 0x0000000000b8174a in page_cleaner_sleep_if_needed (next_loop_time=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0flu.cc:2377 #3 buf_flush_page_cleaner_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0flu.cc:2418 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 37 (LWP 22422): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f0226cc8d30, fast_mutex=0x23d77a0, cond=0x23d77e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x23d77a0, time_in_usec=, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 #3 0x0000000000b032bc in srv_monitor_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:1822 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 36 (LWP 22469): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02285ad780, mutex=0x29a4288, that=0x29a42b8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x29a4288, owner=0x29a4150, abs_timeout=0x7f02285ad780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x29a4288, mdl_request=0x7f01c40056a8, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x29a4150, ot_ctx=0x7f02285ae1e0, mdl_request=0x7f01c40056a8, flags=, mdl_ticket=0x7f02285ae0e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x29a4150, table_list=0x7f01c4005308, ot_ctx=0x7f02285ae1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f02285ae1e0, has_prelocking_list=false, prelocking_strategy=0x7f02285ae300, flags=0, counter=0x29a65d0, tables=0x7f01c4005308, lex=0x29a6518, thd=0x29a4150) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x29a4150, start=0x7f02285ae2c8, counter=0x29a65d0, flags=0, prelocking_strategy=0x7f02285ae300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01c4005308, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000071eb4d in execute_sqlcom_select (thd=0x29a4150, all_tables=0x7f01c4005308) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #10 0x00000000007217b7 in mysql_execute_command (thd=0x29a4150) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #11 0x0000000000727818 in mysql_parse (thd=0x29a4150, rawbuf=0x29a6518 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29a4150, packet=0x29a80e1 " SELECT alias1 . `col_decimal_unsigned_not_null` AS field1 , alias2 . `col_set_utf8_key` AS field2 FROM table1_key_pk_parts_2_int AS alias1 LEFT JOIN table1_key_pk_parts_2_int AS alias2 ON alias1 . `col_varchar_10_latin1_key` = alias2 . `col_varchar_10_utf8_key` WHERE alias1 . `col_int_key` IN (8) OR alias2 . `pk` BETWEEN 7 AND (7 + 100 ) ", packet_length=349) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #13 0x0000000000729a47 in do_command (thd=0x29a4150) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #14 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #15 0x00000000006ed727 in handle_one_connection (arg=0x29a4150) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x292b2c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 35 (LWP 22421): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f02276c9cc0, fast_mutex=0x23d7710, cond=0x23d7750) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x23d7710, time_in_usec=, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 #3 0x0000000000b01ec1 in srv_error_monitor_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:2084 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 34 (LWP 22449): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f01f3ffad40, mutex=0x2953928, that=0x2953958) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2953928, owner=0x29537f0, abs_timeout=0x7f01f3ffad40, set_status_on_timeout=false, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679f1f in MDL_context::acquire_lock (this=0x2953928, mdl_request=0x7f01f3ffadc0, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2229 #4 0x000000000067a18a in MDL_context::upgrade_shared_lock (this=0x2953928, mdl_ticket=0x7f01e805a400, new_type=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2411 #5 0x000000000077e070 in mysql_inplace_alter_table (thd=0x29537f0, table_list=0x7f01e8004e28, table=0x7f01e8017640, altered_table=0x7f01e80525f0, ha_alter_info=0x7f01f3ffcad0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f01f3ffc7d0, alter_ctx=0x7f01f3ffb1b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:6400 #6 0x00000000007839b7 in mysql_alter_table (thd=, new_db=0x7f01e80525f0 "\300.\005\350\001\177", new_name=0x7f01e801fb50 "\f", create_info=, table_list=0x7f01e8004e28, alter_info=0x7f01f3ffd270, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8354 #7 0x0000000000892ca7 in Sql_cmd_alter_table::execute (this=, thd=0x29537f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317 #8 0x000000000072102b in mysql_execute_command (thd=0x29537f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157 #9 0x0000000000727818 in mysql_parse (thd=0x29537f0, rawbuf=0x2955bb8 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #10 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29537f0, packet=0x2957781 " ALTER TABLE table10_key_pk_parts_2_int_autoinc ADD INDEX `test_idx` USING BTREE (`col_int_key` , `pk` , `col_int` ) ", packet_length=117) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #11 0x0000000000729a47 in do_command (thd=0x29537f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #12 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #13 0x00000000006ed727 in handle_one_connection (arg=0x29537f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #14 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #15 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #16 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 33 (LWP 22420): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f02280cad00, fast_mutex=0x2798fe0, cond=0x2799020) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x2798fe0, time_in_usec=, reset_sig_count=46) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 #3 0x0000000000a4c871 in lock_wait_timeout_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/lock/lock0wait.cc:503 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 32 (LWP 22415): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x2415bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=6, message1=0x7f022af7ad98, message2=0x7f022af7ad90, type=0x7f022af7ad88, space_id=0x7f022af7ad80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=6) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 31 (LWP 22429): +bt #0 0x000000340cc0f2a5 in sigwait () from /lib64/libpthread.so.0 #1 0x00000000005a1edb in signal_hand (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:3159 #2 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x27f0770) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #3 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #4 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 30 (LWP 22467): +bt #0 0x000000340cc0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000340cc093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x000000340cc09326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000006c8f10 in inline_mysql_mutex_lock (src_line=115, src_file=0xcda4b0 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table_cache.h", that=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 lock (this=0x1502c20 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table_cache.h:115 #5 close_thread_table (thd=0x299c060, table_ptr=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1518 #6 0x00000000006c96e3 in close_open_tables (thd=0x299c060) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1241 #7 close_thread_tables (thd=0x299c060) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1467 #8 0x0000000000720e61 in mysql_execute_command (thd=0x299c060) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5226 #9 0x0000000000727818 in mysql_parse (thd=0x299c060, rawbuf=0x299e428 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #10 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x299c060, packet=0x2a37db1 "", packet_length=46) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #11 0x0000000000729a47 in do_command (thd=0x299c060) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #12 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #13 0x00000000006ed727 in handle_one_connection (arg=0x299c060) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #14 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #15 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #16 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 29 (LWP 22414): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=3, array=0x23d6950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=5, message1=0x7f022b97bd98, message2=0x7f022b97bd90, type=0x7f022b97bd88, space_id=0x7f022b97bd80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=5) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 28 (LWP 22423): +bt #0 0x000000340c4e14f3 in select () from /lib64/libc.so.6 #1 0x0000000000a6f8bf in os_thread_sleep (tm=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0thread.cc:255 #2 0x0000000000b0131b in srv_master_sleep () at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:2803 #3 srv_master_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:2847 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 27 (LWP 22413): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=2, array=0x23d6950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=4, message1=0x7f022c37cd98, message2=0x7f022c37cd90, type=0x7f022c37cd88, space_id=0x7f022c37cd80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=4) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 26 (LWP 22418): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=3, array=0x2415bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=9, message1=0x7f0229177d98, message2=0x7f0229177d90, type=0x7f0229177d88, space_id=0x7f0229177d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=9) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 25 (LWP 22428): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f02230c2c90, fast_mutex=0x27cf840, cond=0x27cf880) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x27cf840, time_in_usec=, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723 #3 0x0000000000b38cc0 in ib_wqueue_timedwait (wq=0x27cf688, wait_in_usecs=5000000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/ut/ut0wqueue.cc:154 #4 0x0000000000bebe50 in fts_optimize_thread (arg=0x27cf688) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fts/fts0opt.cc:2932 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 24 (LWP 22407): +bt #0 0x000000340c4df253 in poll () from /lib64/libc.so.6 #1 0x00000000005a37ca in handle_connections_sockets () at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:6243 #2 0x00000000005aac1b in mysqld_main (argc=48, argv=0x22d9148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:5658 #3 0x000000340c41ecdd in __libc_start_main () from /lib64/libc.so.6 #4 0x000000000059b851 in _start () Thread 23 (LWP 22412): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=1, array=0x23d6950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=3, message1=0x7f022cd7dd98, message2=0x7f022cd7dd90, type=0x7f022cd7dd88, space_id=0x7f022cd7dd80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=3) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 22 (LWP 22411): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x23d6950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=2, message1=0x7f022d77ed98, message2=0x7f022d77ed90, type=0x7f022d77ed88, space_id=0x7f022d77ed80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=2) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 21 (LWP 22489): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f022267e780, mutex=0x29f9cd8, that=0x29f9d08) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x29f9cd8, owner=0x29f9ba0, abs_timeout=0x7f022267e780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x29f9cd8, mdl_request=0x7f019c005a78, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x29f9ba0, ot_ctx=0x7f022267f1e0, mdl_request=0x7f019c005a78, flags=, mdl_ticket=0x7f022267f0e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x29f9ba0, table_list=0x7f019c0056d8, ot_ctx=0x7f022267f1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f022267f1e0, has_prelocking_list=false, prelocking_strategy=0x7f022267f300, flags=0, counter=0x29fc020, tables=0x7f019c0056d8, lex=0x29fbf68, thd=0x29f9ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x29f9ba0, start=0x7f022267f2c8, counter=0x29fc020, flags=0, prelocking_strategy=0x7f022267f300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f019c0056d8, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000071eb4d in execute_sqlcom_select (thd=0x29f9ba0, all_tables=0x7f019c0056d8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #10 0x00000000007217b7 in mysql_execute_command (thd=0x29f9ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #11 0x0000000000727818 in mysql_parse (thd=0x29f9ba0, rawbuf=0x29fbf68 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29f9ba0, packet=0x29fdb31 " SELECT alias2 . `col_float_unsigned` AS field1 , alias2 . `col_set_latin1_key` AS field2 , alias2 . `col_char_255_utf8_not_null_key` AS field3 FROM table10_key_pk_parts_2_int AS alias1 RIGHT JOIN table10_key_pk_parts_2_int_autoinc AS alias2 ON alias1 . `col_int_key` = alias2 . `col_int_key` WHERE alias2 . `col_int` IS NOT NULL OR alias2 . `col_int` > 9 AND alias2 . `col_int` < ( 0 + 8 ) AND alias2 . `col_int` >= 4 AND alias2 . `col_int` < ( 9 + 5 ) OR alias2 . `col_int` IS NULL AND alias1 . `pk` >= 7 AND alias1 . `pk` <= ( 3 + 6 ) AND alias2 . `col_int_key` BETWEEN 9 AND (9 + 2 ) OR alias2 . `col_int` <> 5 ORDER BY field2 ", packet_length=642) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #13 0x0000000000729a47 in do_command (thd=0x29f9ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #14 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #15 0x00000000006ed727 in handle_one_connection (arg=0x29f9ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x295f640) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 20 (LWP 22410): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x23fa670) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=1, message1=0x7f022e17fd98, message2=0x7f022e17fd90, type=0x7f022e17fd88, space_id=0x7f022e17fd80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 19 (LWP 22426): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6f533 in os_cond_wait (fast_mutex=0x23d7830, cond=0x23d7870) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x23d7830, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610 #3 0x0000000000b7c8ac in buf_dump_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0dump.cc:594 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 18 (LWP 22490): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000005a32ef in inline_mysql_cond_wait (src_line=2653, mutex=0x14e0440 , that=0x14e23c0 , src_file=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1162 #2 block_until_new_connection () at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:2653 #3 one_thread_per_connection_end (thd=, block_pthread=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:2747 #4 0x00000000006ed5be in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1629 #5 0x00000000006ed727 in handle_one_connection (arg=0x2a01c90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #6 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x295f640) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #7 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #8 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 17 (LWP 22417): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=2, array=0x2415bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=8, message1=0x7f0229b78d98, message2=0x7f0229b78d90, type=0x7f0229b78d88, space_id=0x7f0229b78d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 16 (LWP 22483): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02283a4780, mutex=0x29e1a08, that=0x29e1a38) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x29e1a08, owner=0x29e18d0, abs_timeout=0x7f02283a4780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x29e1a08, mdl_request=0x7f01a00065c8, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x29e18d0, ot_ctx=0x7f02283a51e0, mdl_request=0x7f01a00065c8, flags=, mdl_ticket=0x7f02283a50e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x29e18d0, table_list=0x7f01a0006228, ot_ctx=0x7f02283a51e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f02283a51e0, has_prelocking_list=false, prelocking_strategy=0x7f02283a5300, flags=0, counter=0x29e3d50, tables=0x7f01a0006228, lex=0x29e3c98, thd=0x29e18d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x29e18d0, start=0x7f02283a52c8, counter=0x29e3d50, flags=0, prelocking_strategy=0x7f02283a5300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01a0006228, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000071eb4d in execute_sqlcom_select (thd=0x29e18d0, all_tables=0x7f01a0006228) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #10 0x00000000007217b7 in mysql_execute_command (thd=0x29e18d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #11 0x0000000000727818 in mysql_parse (thd=0x29e18d0, rawbuf=0x29e3c98 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29e18d0, packet=0x29e5861 "SELECT MIN( `col_float_not_null_key` ) FROM `table10_key_pk_parts_2_int` FORCE KEY ( PRIMARY , `col_int_unsigned_key` , `col_char_255_latin1_not_null_key` , `col_char_255_utf8_not_null_key` , `col_char_255_latin1_not_null_key` ) WHERE ( `col_decimal_unsigned_not_null_key` BETWEEN '2000-05-02 01:44:00.009449' AND '2009-03-28 14:46:46.059290' AND `col_set_utf8_key` BETWEEN '2009-08-22 08:07:04.003348' AND '2005-02-01 22:41:43.054446' ) AND ( ( `col_set_utf8_key` IN ( '2009-07-03 15:09:37.021230' , '20070613001314.065310' , '2005-07-07 14:06:03.011083' , '20090412202803.061430' ) AND `col_set_utf8_key` NOT IN ( '2005-12-04 15:46:08.020704' , '20010904222015.000033' , '0000-00-00 00:00:00' , '2005-08-16 08:55:23.021600' , '2002-12-12 16:23:47.063869' ) ) AND ( `col_set_utf8_not_null_key` IS NULL AND `col_int_key` NOT IN ( '2001-09-06 20:36:03.013085' , '0000-00-00 00:00:00' , '0000-00-00 00:00:00' ) ) AND ( `col_int_key` IS NULL AND `col_set_utf8_not_null_key` IN ( '0000-00-00 00:00:00' , '20060903162658.060807' , '2003-11-15 02:29:34.023193' , '20071121214439.034165' , '2004-05-27 23:35:46.028739' , '0000-00-00 00:00:00' , '2006-06-20 18:18:54.042912' , '0000-00-00 00:00:00' , '2003-05-09 20:46:30.054071' ) ) ) AND ( `col_enum_latin1_key` BETWEEN '2002-10-23 14:25:55.048640' AND '2007-10-17 04:42:59.054164' OR ( `col_int_key` > '2001-03-22 04:20:32.038115' ) ) AND ( ( `col_blob_key` IS NULL AND `col_blob_not_null_key` BETWEEN '2009-10-20 08:36:55.016750' AND '2000-04-09 19:06:22.034099' ) AND ( `col_int_not_null_key` BETWEEN '2000-08-16 15:15:58.064102' AND '0000-00-00 00:00:00' AND `col_char_255_latin1_not_null_key` BETWEEN '20090728153224.053458' AND '2002-07-12 05:58:13.022908' ) OR ( `col_blob_key` IN ( '20030617184841.039030' , '2009-01-04 02:05:01.038542' , '20020610231549.025818' ) AND ( `col_blob_key` = '20041109140937.014588' ) ) )", packet_length=1869) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #13 0x0000000000729a47 in do_command (thd=0x29e18d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #14 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #15 0x00000000006ed727 in handle_one_connection (arg=0x29e18d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x295f640) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 15 (LWP 22481): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02284277e0, mutex=0x29d9918, that=0x29d9948) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x29d9918, owner=0x29d97e0, abs_timeout=0x7f02284277e0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x29d9918, mdl_request=0x7f01ac046008, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x29d97e0, ot_ctx=0x7f0228428240, mdl_request=0x7f01ac046008, flags=, mdl_ticket=0x7f0228428148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x29d97e0, table_list=0x7f01ac045c68, ot_ctx=0x7f0228428240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f0228428240, has_prelocking_list=false, prelocking_strategy=0x7f0228428360, flags=0, counter=0x29dbc60, tables=0x7f01ac045c68, lex=0x29dbba8, thd=0x29d97e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x29d97e0, start=0x7f0228428328, counter=0x29dbc60, flags=0, prelocking_strategy=0x7f0228428360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01ac005f98, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x00000000007219f2 in mysql_execute_command (thd=0x29d97e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705 #10 0x0000000000727818 in mysql_parse (thd=0x29d97e0, rawbuf=0x29dbba8 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29d97e0, packet=0x29dd771 " INSERT INTO `table10_key_pk_parts_2_int_autoinc` ( `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 `table1_int_autoinc` WHERE `col_bigint_key` BETWEEN 6 AND 8 ORDER BY `col_bit`,`col_bit_key`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_key`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_255_latin1`,`col_char_255_latin1_key`,`col_char_255_latin1_not_null`,`col_char_255_latin1_not_null_key`,`col_char_255_utf8`,`col_char_255_utf8_key`,`col_char_255_utf8_not_null`,`col_char_255_utf8_not_null_key`,`col_decimal`,`col_decimal_key`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_key`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_key`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_key`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_key`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_key`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_key`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_key`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_key`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 25 /*Generated by THREAD_ID 21*/ ", packet_length=2295) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x29d97e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #13 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #14 0x00000000006ed727 in handle_one_connection (arg=0x29d97e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x295f640) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 14 (LWP 22479): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f0228468200, mutex=0x29d1828, that=0x29d1858) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x29d1828, owner=0x29d16f0, abs_timeout=0x7f0228468200, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x29d1828, mdl_request=0x7f01a8005c28, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x29d16f0, ot_ctx=0x7f0228468c60, mdl_request=0x7f01a8005c28, flags=, mdl_ticket=0x7f0228468b68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x29d16f0, table_list=0x7f01a8005888, ot_ctx=0x7f0228468c60) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f0228468c60, has_prelocking_list=false, prelocking_strategy=0x7f0228468d80, flags=0, counter=0x29d3b70, tables=0x7f01a8005888, lex=0x29d3ab8, thd=0x29d16f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x29d16f0, start=0x7f0228468d48, counter=0x29d3b70, flags=0, prelocking_strategy=0x7f0228468d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01a8005888, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000079bf6d in mysql_update (thd=0x29d16f0, table_list=0x7f01a8005888, fields=..., values=..., conds=0x7f01a80061f8, order_num=57, order=0x7f01a8006608, limit=5, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f022846a038, updated_return=0x7f022846a040) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:251 #10 0x00000000007212cb in mysql_execute_command (thd=0x29d16f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3511 #11 0x0000000000727818 in mysql_parse (thd=0x29d16f0, rawbuf=0x29d3ab8 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29d16f0, packet=0x2a01c91 " UPDATE `table10_key_pk_parts_2_int` SET `col_bigint` = 4 WHERE 0 BETWEEN 1 AND 5 ORDER BY `col_bit`,`col_bit_key`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_key`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_255_latin1`,`col_char_255_latin1_key`,`col_char_255_latin1_not_null`,`col_char_255_latin1_not_null_key`,`col_char_255_utf8`,`col_char_255_utf8_key`,`col_char_255_utf8_not_null`,`col_char_255_utf8_not_null_key`,`col_decimal`,`col_decimal_key`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_key`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_key`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_key`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_key`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_key`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_key`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_key`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_key`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 5 /*Generated by THREAD_ID 20*/ ", packet_length=1410) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #13 0x0000000000729a47 in do_command (thd=0x29d16f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #14 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #15 0x00000000006ed727 in handle_one_connection (arg=0x29d16f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x295f640) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 13 (LWP 22409): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x2408110) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=0, message1=0x7f02408e9d98, message2=0x7f02408e9d90, type=0x7f02408e9d88, space_id=0x7f02408e9d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 12 (LWP 22487): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02226bf780, mutex=0x29f1be8, that=0x29f1c18) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x29f1be8, owner=0x29f1ab0, abs_timeout=0x7f02226bf780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x29f1be8, mdl_request=0x7f0198005f38, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x29f1ab0, ot_ctx=0x7f02226c01e0, mdl_request=0x7f0198005f38, flags=, mdl_ticket=0x7f02226c00e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x29f1ab0, table_list=0x7f0198005b98, ot_ctx=0x7f02226c01e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f02226c01e0, has_prelocking_list=false, prelocking_strategy=0x7f02226c0300, flags=0, counter=0x29f3f30, tables=0x7f0198005b98, lex=0x29f3e78, thd=0x29f1ab0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x29f1ab0, start=0x7f02226c02c8, counter=0x29f3f30, flags=0, prelocking_strategy=0x7f02226c0300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01980055c8, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000071eb4d in execute_sqlcom_select (thd=0x29f1ab0, all_tables=0x7f01980055c8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #10 0x00000000007217b7 in mysql_execute_command (thd=0x29f1ab0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #11 0x0000000000727818 in mysql_parse (thd=0x29f1ab0, rawbuf=0x29f3e78 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29f1ab0, packet=0x29f5a41 " SELECT table2 . `col_int_key` AS field1 , MIN( table1 . `col_int_key` ) AS field2 , table1 . `col_blob_key` AS field3 FROM table0_key_pk_parts_2_int_autoinc AS table1 LEFT JOIN table1_int_autoinc AS table2 ON table1 . `col_varchar_1024_latin1_key` = table2 . `col_varchar_10_latin1_key` WHERE table1 . `col_int` IS NULL OR table1 . `col_int_key` IN ( 5 ) GROUP BY field1, field3", packet_length=388) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #13 0x0000000000729a47 in do_command (thd=0x29f1ab0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #14 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #15 0x00000000006ed727 in handle_one_connection (arg=0x29f1ab0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x295f640) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 11 (LWP 22416): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=1, array=0x2415bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089 #2 os_aio_linux_handle (global_seg=7, message1=0x7f022a579d98, message2=0x7f022a579d90, type=0x7f022a579d88, space_id=0x7f022a579d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234 #3 0x0000000000bbdc67 in fil_aio_wait (segment=7) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575 #4 0x0000000000b055e8 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 10 (LWP 22453): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02375a24e0, mutex=0x2963b08, that=0x2963b38) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2963b08, owner=0x29639d0, abs_timeout=0x7f02375a24e0, set_status_on_timeout=false, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679f1f in MDL_context::acquire_lock (this=0x2963b08, mdl_request=0x7f02375a2560, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2229 #4 0x000000000067a18a in MDL_context::upgrade_shared_lock (this=0x2963b08, mdl_ticket=0x7f01e400e750, new_type=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2411 #5 0x000000000077e070 in mysql_inplace_alter_table (thd=0x29639d0, table_list=0x7f01e4004de8, table=0x7f019c01a660, altered_table=0x7f01e404a5b0, ha_alter_info=0x7f02375a4270, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f02375a3f70, alter_ctx=0x7f02375a2950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:6400 #6 0x00000000007839b7 in mysql_alter_table (thd=, new_db=0x7f01e404a5b0 "\200\256\004\344\001\177", new_name=0x7f0100000000
, create_info=, table_list=0x7f01e4004de8, alter_info=0x7f02375a4410, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8354 #7 0x0000000000724f83 in mysql_execute_command (thd=0x29639d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3310 #8 0x0000000000727818 in mysql_parse (thd=0x29639d0, rawbuf=0x2965d98 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #9 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29639d0, packet=0x2967961 " DROP INDEX `test_idx` ON table10_key_pk_parts_2_int", packet_length=52) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #10 0x0000000000729a47 in do_command (thd=0x29639d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #11 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #12 0x00000000006ed727 in handle_one_connection (arg=0x29639d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #13 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #14 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #15 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 9 (LWP 22475): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6f533 in os_cond_wait (fast_mutex=0x7f01e802db80, cond=0x7f01e802dbc0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x7f01e802db80, reset_sig_count=18) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610 #3 0x0000000000a4c13e in lock_wait_suspend_thread (thr=0x7f01d8045bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/lock/lock0wait.cc:322 #4 0x0000000000ac5c57 in row_mysql_handle_errors (new_err=0x7f02284ea90c, trx=0x7f01b0013c88, thr=, savept=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0mysql.cc:631 #5 0x0000000000ae7f81 in row_search_for_mysql (buf=, mode=, prebuilt=0x7f01d8044ae8, match_mode=0, direction=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0sel.cc:5034 #6 0x00000000009fdac2 in ha_innobase::index_read (this=0x7f01d8015290, buf=0x7f01d80472c0 "\377\377\377\377\200", key_ptr=, key_len=0, find_flag=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:7848 #7 0x00000000009f77d0 in ha_innobase::index_first (this=0x7f01d8015290, buf=0x7f01d80472c0 "\377\377\377\377\200") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:8245 #8 0x00000000009fee2f in ha_innobase::rnd_next (this=0x7f01d8015290, buf=0x7f01d80472c0 "\377\377\377\377\200") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:8342 #9 0x00000000005b4647 in handler::ha_rnd_next (this=0x7f01d8015290, buf=0x7f01d80472c0 "\377\377\377\377\200") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.cc:2667 #10 0x0000000000c57fbd in ha_partition::rnd_next (this=0x7f01d80304b0, buf=0x7f01d80472c0 "\377\377\377\377\200") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:4659 #11 0x00000000005b45fa in handler::ha_rnd_next (this=0x7f01d80304b0, buf=0x7f01d80472c0 "\377\377\377\377\200") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.cc:2667 #12 0x000000000088722c in rr_sequential (info=0x7f02284eb230) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/records.cc:478 #13 0x000000000089badf in mysql_delete (thd=0x29c04a0, table_list=0x7f01b0004e70, conds=0x7f01b0005600, order_list=, limit=3, options=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_delete.cc:354 #14 0x0000000000721953 in mysql_execute_command (thd=0x29c04a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3773 #15 0x0000000000727818 in mysql_parse (thd=0x29c04a0, rawbuf=0x29c2868 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #16 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29c04a0, packet=0x29c4431 "DELETE FROM `table10_key_pk_parts_2_int_autoinc` WHERE `col_enum_latin1_not_null_key` < 0 LIMIT 3", packet_length=97) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #17 0x0000000000729a47 in do_command (thd=0x29c04a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #18 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #19 0x00000000006ed727 in handle_one_connection (arg=0x29c04a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #20 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x294f440) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #21 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #22 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 8 (LWP 22447): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6f533 in os_cond_wait (fast_mutex=0x27a0fd0, cond=0x27a1010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x27a0fd0, reset_sig_count=134) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610 #3 0x0000000000b0ba31 in sync_array_wait_event (arr=0x23d69f0, index=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/sync/sync0arr.cc:424 #4 0x0000000000b0d9ec in mutex_spin_wait (mutex=0x27a0ee8, file_name=0xe00808 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc", line=479) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/sync/sync0sync.cc:583 #5 0x0000000000b9a8e0 in pfs_mutex_enter_func (mutex=0x27a0ee8, line=479, file_name=0xe00808 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/include/sync0sync.ic:251 #6 0x0000000000b9aaf1 in dict_table_close (table=0x7f02180909d8, dict_locked=0, try_drop=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc:479 #7 0x0000000000ac6ebb in row_prebuilt_free (prebuilt=0x7f01d4052dc8, dict_locked=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0mysql.cc:894 #8 0x00000000009ffd54 in ha_innobase::close (this=0x7f01d40407b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:5383 #9 0x00000000005b48cd in handler::ha_close (this=0x7f01d40407b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.cc:2550 #10 0x00000000007c2e19 in closefrm (table=0x7f01d4014220, free_share=true) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table.cc:2422 #11 0x00000000006c2c47 in intern_close_table (table=0x7f01d4014220) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:821 #12 0x00000000006c8a75 in close_thread_table (thd=, table_ptr=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1525 #13 0x00000000006cbd19 in close_all_tables_for_name (thd=0x294b700, share=, remove_from_locked_tables=false, skip_table=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1301 #14 0x000000000077de08 in mysql_inplace_alter_table (thd=0x294b700, table_list=0x7f01ec004dc8, table=, altered_table=0x7f01ec1cb5b0, ha_alter_info=0x7f023c0bc270, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f023c0bbf70, alter_ctx=0x7f023c0ba950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:6519 #15 0x00000000007839b7 in mysql_alter_table (thd=, new_db=0x7f01ec1cb5b0 "\200\276\034\354\001\177", new_name=0x7f0100000000
, create_info=, table_list=0x7f01ec004dc8, alter_info=0x7f023c0bc410, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8354 #16 0x0000000000724f83 in mysql_execute_command (thd=0x294b700) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3310 #17 0x0000000000727818 in mysql_parse (thd=0x294b700, rawbuf=0x294dac8 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #18 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x294b700, packet=0x2a09d81 " DROP INDEX `test_idx` ON table1_int_autoinc", packet_length=44) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #19 0x0000000000729a47 in do_command (thd=0x294b700) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #20 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #21 0x00000000006ed727 in handle_one_connection (arg=0x294b700) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #22 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #23 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #24 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 7 (LWP 22459): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02286b17e0, mutex=0x297bdd8, that=0x297be08) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x297bdd8, owner=0x297bca0, abs_timeout=0x7f02286b17e0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x297bdd8, mdl_request=0x7f01d00062b0, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x297bca0, ot_ctx=0x7f02286b2240, mdl_request=0x7f01d00062b0, flags=, mdl_ticket=0x7f02286b2148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x297bca0, table_list=0x7f01d0005f10, ot_ctx=0x7f02286b2240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f02286b2240, has_prelocking_list=false, prelocking_strategy=0x7f02286b2360, flags=0, counter=0x297e120, tables=0x7f01d0005f10, lex=0x297e068, thd=0x297bca0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x297bca0, start=0x7f02286b2328, counter=0x297e120, flags=0, prelocking_strategy=0x7f02286b2360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01d0005f10, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x00000000007219f2 in mysql_execute_command (thd=0x297bca0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705 #10 0x0000000000727818 in mysql_parse (thd=0x297bca0, rawbuf=0x297e068 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x297bca0, packet=0x297fc31 "INSERT INTO `table1_int_autoinc` ( `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 `table0_int` WHERE 0 BETWEEN 160 AND 2571304960 ORDER BY `col_bit`,`col_bit_key`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_key`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_255_latin1`,`col_char_255_latin1_key`,`col_char_255_latin1_not_null`,`col_char_255_latin1_not_null_key`,`col_char_255_utf8`,`col_char_255_utf8_key`,`col_char_255_utf8_not_null`,`col_char_255_utf8_not_null_key`,`col_decimal`,`col_decimal_key`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_key`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_key`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_key`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_key`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_key`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_key`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_key`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_key`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 10 /*Generated by THREAD_ID 10*/", packet_length=2265) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x297bca0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #13 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #14 0x00000000006ed727 in handle_one_connection (arg=0x297bca0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 6 (LWP 22477): +bt #0 0x000000340c4df253 in poll () from /lib64/libc.so.6 #1 0x0000000000c9e846 in vio_io_wait (vio=, event=VIO_IO_EVENT_WRITE, timeout=60000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:820 #2 0x0000000000c9ecc8 in vio_socket_io_wait (vio=, event=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:68 #3 0x0000000000c9f4f3 in vio_write (vio=0x29affe0, buf=0x7f01b40b75cc "\034", size=5770) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:201 #4 0x000000000067b749 in net_write_raw_loop (count=5770, buf=0x7f01b40b75cc "\034", net=0x29ac4a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:494 #5 net_write_packet (net=0x29ac4a0, packet=0x7f01b409ca5c "\342w\304\355O\253\231'\212\312B-\364\350&>hm\223\204\004\002@$\226r\001 3\266\t\256\237\027\017\335ȑIˊ+\266\060\baU\003ҬV\321\064\026\002\060\001yp\347\003\234z\017\363Q\366\266\306i\226%\030\311\003\065l\323V\306Kɭ\236xY#\005\023#!\275\300>\365\365I(F\221\304\366ct\256\236\367\272\302%\270̈r_\031\003\277\365\317\366\255\265\245\351v:>\226\004\221FY\300c\270r@\347s\223\375\252\067\245\064\223aa\363rA\025\244C;\335\306\bQ\354\277_z\252\365\347X\245\313\315\006\234\276#\313\344Vo\345Q\300\"\271\344\345\226T\272,\251\034\376!u\303\062˦iLc\336vI =\227\324\017j\241\336\352rݢY\332+s\370٘\235\304{\223\350*1\367\274\244d\263\061\344\216\354}\205d3[A\031\267i\030;\220&*;.yA\376}\315uG\034`\251\025\273\061\236\342K}\311m+*\366i\024\220\\\377", length=115194) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:630 #6 0x000000000067be09 in my_net_write (net=0x29ac4a0, packet=0x7f01b4098a60 "\001\060\333appkdzakrpxatwyltvmvfbqpjmprkzgdhiiuplshmrtrnymatsukdetjrspmkofpczpmfkzhpbqzlkdurcovzmfubqydtmsixzqttiivinrugziirhcuxccfaslbjjlyuxlzznxvpgebcwvrjucyfimtililccpgguozxxshxpqhxvoyoczvxylaydutbwsnxoiqtqansoqnwnbwoxrctroxfua\001b\001\065", len=131574) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:319 #7 0x000000000067f9e4 in Protocol::write (this=0x29ac770) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/protocol.cc:821 #8 0x00000000006df65e in select_send::send_data (this=0x7f01b40059b8, items=...) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_class.cc:2702 #9 0x00000000006f5fb8 in end_send (join=0x7f01b40059e0, join_tab=0x7f01b405d170, end_of_records=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:2774 #10 0x00000000006f75da in evaluate_join_record (join=0x7f01b40059e0, join_tab=0x7f01b405ce70) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:1597 #11 0x00000000006fbcd6 in sub_select (join=0x7f01b40059e0, join_tab=0x7f01b405ce70, end_of_records=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:1272 #12 0x00000000006fd38b in do_select (join=0x7f01b40059e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:930 #13 JOIN::exec (this=0x7f01b40059e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:191 #14 0x00000000007492d0 in mysql_execute_select (free_join=true, select_lex=0x29aed18, thd=0x29ac240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1101 #15 mysql_select (thd=0x29ac240, tables=0x7f01b4004fe8, wild_num=1, fields=..., conds=0x7f01b4005770, order=, group=0x29aee18, having=0x0, select_options=2147781376, result=0x7f01b40059b8, unit=0x29ae6d0, select_lex=0x29aed18) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1222 #16 0x0000000000749dbb in handle_select (thd=0x29ac240, result=0x7f01b40059b8, setup_tables_done_option=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:111 #17 0x000000000071ecdd in execute_sqlcom_select (thd=0x29ac240, all_tables=0x7f01b4004fe8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5305 #18 0x00000000007217b7 in mysql_execute_command (thd=0x29ac240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #19 0x0000000000727818 in mysql_parse (thd=0x29ac240, rawbuf=0x29ae608 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #20 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x29ac240, packet=0x29b01d1 "\001\002?\001\060\333appkdzakrpxatwyltvmvfbqpjmprkzgdhiiuplshmrtrnymatsukdetjrspmkofpczpmfkzhpbqzlkdurcovzmfubqydtmsixzqttiivinrugziirhcuxccfaslbjjlyuxlzznxvpgebcwvrjucyfimtililccpgguozxxshxpqhxvoyoczvxylaydutbwsnxoiqtqansoqnwnbwoxrctroxfua\001b\001\065", packet_length=152) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #21 0x0000000000729a47 in do_command (thd=0x29ac240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #22 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #23 0x00000000006ed727 in handle_one_connection (arg=0x29ac240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #24 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x2957530) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #25 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #26 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 5 (LWP 22457): +bt #0 0x000000340cc0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000340cc093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x000000340cc09326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000006c6aac in inline_mysql_mutex_lock (src_line=115, src_file=0xcda4b0 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table_cache.h", that=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 lock (this=0x1502c20 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table_cache.h:115 #5 open_table (thd=0x2973bb0, table_list=0x7f01dc029a18, ot_ctx=0x7f02286f2c90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2859 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f02286f2c90, has_prelocking_list=false, prelocking_strategy=0x7f02286f2db0, flags=512, counter=0x7f01dc0287f0, tables=0x7f01dc029a18, lex=0x7f01dc028738, thd=0x2973bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x2973bb0, start=0x7f02286f2d78, counter=0x7f01dc0287f0, flags=512, prelocking_strategy=0x7f02286f2db0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01dc029a18, flags=512) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000073655b in select_like_stmt_test_with_open (stmt=0x7f01dc0209a0, tables=0x7f01dc029a18, specific_prepare=0x7350e0 , setup_tables_done_option=1073741824) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_prepare.cc:1722 #10 0x000000000073726a in mysql_test_insert_select (tables=0x7f01dc029a18, stmt=0x7f01dc0209a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_prepare.cc:1977 #11 check_prepared_statement (stmt=0x7f01dc0209a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_prepare.cc:2122 #12 0x0000000000738fd8 in Prepared_statement::prepare (this=0x7f01dc0209a0, packet=0x2973bb8 "\340#;\001", packet_len=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_prepare.cc:3689 #13 0x000000000073b197 in mysql_sql_stmt_prepare (thd=0x2973bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_prepare.cc:2519 #14 0x0000000000722b89 in mysql_execute_command (thd=0x2973bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2767 #15 0x0000000000727818 in mysql_parse (thd=0x2973bb0, rawbuf=0x2975f78 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #16 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x2973bb0, packet=0x29c8591 " /*any*/ /* QUERY_IS_REPLICATION_SAFE */ PREPARE st1 FROM \" INSERT HIGH_PRIORITY INTO test1 . t1_temp_trans_22456 /* t1_15_myisam v1_trans_unsafe_for_sbr_22456 */ ( `col_bit`,`col_bit_key`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_key`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_255_latin1`,`col_char_255_latin1_key`,`col_char_255_latin1_not_null`,`col_char_255_latin1_not_null_key`,`col_char_255_utf8`,`col_char_255_utf8_key`,`col_char_255_utf8_not_null`,`col_char_255_utf8_not_null_key`,`col_decimal`,`col_decimal_key`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_key`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_key`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_key`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_key`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_key`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_key`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_key`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_key`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` ) SELECT `col_bit`,`col_bit_key`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_key`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_255_latin1`,`col_char_255_latin1_key`,`col_char_255_latin1_not_null`,`col_char_255_latin1_not_null_key`,`col_char_255_utf8`,`col_char_255_utf8_key`,`col_char_255_utf8_not_null`,`col_char_255_utf8_not_null_key`,`col_decimal`,`col_decimal_key`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_key`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_key`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_key`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_key`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_key`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_key`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_key`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_key`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` FROM ( SELECT `col_bit`,`col_bit_key`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_key`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_255_latin1`,`col_char_255_latin1_key`,`col_char_255_latin1_not_null`,`col_char_255_latin1_not_null_key`,`col_char_255_utf8`,`col_char_255_utf8_key`,`col_char_255_utf8_not_null`,`col_char_255_utf8_not_null_key`,`col_decimal`,`col_decimal_key`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_key`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_key`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_key`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_key`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_key`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_key`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_key`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_key`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` FROM test2 . t1_base_trans_22456 /* v2_nontrans_unsafe_for"..., packet_length=4437) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #17 0x0000000000729a47 in do_command (thd=0x2973bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #18 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #19 0x00000000006ed727 in handle_one_connection (arg=0x2973bb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #20 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #21 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #22 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 4 (LWP 22455): +bt #0 0x000000340cc0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000340cc093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x000000340cc09326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000006c8f10 in inline_mysql_mutex_lock (src_line=115, src_file=0xcda4b0 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table_cache.h", that=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 lock (this=0x1502c20 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table_cache.h:115 #5 close_thread_table (thd=0x296bac0, table_ptr=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1518 #6 0x00000000006c96e3 in close_open_tables (thd=0x296bac0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1241 #7 close_thread_tables (thd=0x296bac0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1467 #8 0x0000000000720e61 in mysql_execute_command (thd=0x296bac0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5226 #9 0x0000000000727818 in mysql_parse (thd=0x296bac0, rawbuf=0x296de88 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #10 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x296bac0, packet=0x296fa51 "", packet_length=332) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #11 0x0000000000729a47 in do_command (thd=0x296bac0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #12 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #13 0x00000000006ed727 in handle_one_connection (arg=0x296bac0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #14 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #15 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #16 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 3 (LWP 22445): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f023c0fc0a0, mutex=0x2943748, that=0x2943778) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2943748, owner=0x2943610, abs_timeout=0x7f023c0fc0a0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x2943748, mdl_request=0x7f01f8005190, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x2943610, ot_ctx=0x7f023c0fcb00, mdl_request=0x7f01f8005190, flags=, mdl_ticket=0x7f023c0fca08) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x2943610, table_list=0x7f01f8004df0, ot_ctx=0x7f023c0fcb00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f023c0fcb00, has_prelocking_list=false, prelocking_strategy=0x7f023c0fcc20, flags=0, counter=0x2945a90, tables=0x7f01f8004df0, lex=0x29459d8, thd=0x2943610) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x2943610, start=0x7f023c0fcbe8, counter=0x2945a90, flags=0, prelocking_strategy=0x7f023c0fcc20) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01f8004df0, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x000000000089b016 in mysql_delete (thd=0x2943610, table_list=0x7f01f8004df0, conds=0x0, order_list=0x29462b0, limit=4, options=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_delete.cc:72 #10 0x0000000000721953 in mysql_execute_command (thd=0x2943610) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3773 #11 0x0000000000727818 in mysql_parse (thd=0x2943610, rawbuf=0x29459d8 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x2943610, packet=0x29475a1 "DELETE FROM `table1_int_autoinc` ORDER BY `col_bit_not_null_key` LIMIT 4", packet_length=72) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #13 0x0000000000729a47 in do_command (thd=0x2943610) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #14 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #15 0x00000000006ed727 in handle_one_connection (arg=0x2943610) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 2 (LWP 22451): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f02375e47e0, mutex=0x295ba18, that=0x295ba48) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x295ba18, owner=0x295b8e0, abs_timeout=0x7f02375e47e0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306 #3 0x0000000000679d3c in MDL_context::acquire_lock (this=0x295ba18, mdl_request=0x7f01e001e048, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x295b8e0, ot_ctx=0x7f02375e5240, mdl_request=0x7f01e001e048, flags=, mdl_ticket=0x7f02375e5148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527 #5 0x00000000006c668a in open_table (thd=0x295b8e0, table_list=0x7f01e001dca8, ot_ctx=0x7f02375e5240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819 #6 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f02375e5240, has_prelocking_list=false, prelocking_strategy=0x7f02375e5360, flags=0, counter=0x295dd60, tables=0x7f01e001dca8, lex=0x295dca8, thd=0x295b8e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #7 open_tables (thd=0x295b8e0, start=0x7f02375e5328, counter=0x295dd60, flags=0, prelocking_strategy=0x7f02375e5360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #8 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f01e0005ea0, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #9 0x00000000007219f2 in mysql_execute_command (thd=0x295b8e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705 #10 0x0000000000727818 in mysql_parse (thd=0x295b8e0, rawbuf=0x295dca8 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x295b8e0, packet=0x2a19d91 " INSERT INTO `table0_int` ( `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 `table1_int_autoinc` ORDER BY `col_bit`,`col_bit_key`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_key`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_255_latin1`,`col_char_255_latin1_key`,`col_char_255_latin1_not_null`,`col_char_255_latin1_not_null_key`,`col_char_255_utf8`,`col_char_255_utf8_key`,`col_char_255_utf8_not_null`,`col_char_255_utf8_not_null_key`,`col_decimal`,`col_decimal_key`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_key`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_key`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_key`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_key`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_key`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_key`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_key`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_key`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_key`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 25 /*Generated by THREAD_ID 6*/ ", packet_length=2231) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x295b8e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #13 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #14 0x00000000006ed727 in handle_one_connection (arg=0x295b8e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 1 (LWP 22443): +bt #0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000686bde in handle_fatal_signal (sig=6) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/signal_handler.cc:251 #2 #3 0x000000340c4328a5 in raise () from /lib64/libc.so.6 #4 0x000000340c434085 in abort () from /lib64/libc.so.6 #5 0x0000000000b9d44e in dict_table_check_for_dup_indexes (table=, check=CHECK_ABORTED_OK) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc:5917 #6 0x0000000000a192c2 in ha_innobase::prepare_inplace_alter_table (this=0x7f01f8033280, altered_table=0x7f01f407f070, ha_alter_info=0x7f023c13dad0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/handler0alter.cc:3304 #7 0x0000000000c58686 in ha_partition::prepare_inplace_alter_table (this=0x7f01f804da70, altered_table=0x7f01f407f070, ha_alter_info=0x7f023c13dad0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:7920 #8 0x000000000077dc9b in mysql_inplace_alter_table (thd=0x23a9710, table_list=0x7f01f4004e08, table=0x7f01f80811f0, altered_table=0x7f01f407f070, ha_alter_info=0x7f023c13dad0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f023c13d7d0, alter_ctx=0x7f023c13c1b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:6454 #9 0x00000000007839b7 in mysql_alter_table (thd=, new_db=0x7f01f407f070 "@\371\a\364\001\177", new_name=0x7f01f4035390 "\f", create_info=, table_list=0x7f01f4004e08, alter_info=0x7f023c13e270, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8354 #10 0x0000000000892ca7 in Sql_cmd_alter_table::execute (this=, thd=0x23a9710) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317 #11 0x000000000072102b in mysql_execute_command (thd=0x23a9710) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157 #12 0x0000000000727818 in mysql_parse (thd=0x23a9710, rawbuf=0x23abad8 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #13 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x23a9710, packet=0x23ad6a1 " ALTER TABLE table1_key_pk_parts_2_int ADD INDEX `test_idx` USING BTREE (`col_int_key` , `col_int`, `pk` ) ", packet_length=107) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #14 0x0000000000729a47 in do_command (thd=0x23a9710) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #15 0x00000000006ed63f in do_handle_one_connection (thd_arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615 #16 0x00000000006ed727 in handle_one_connection (arg=0x23a9710) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #17 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x28e5720) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #18 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #19 0x000000340c4e890d in clone () from /lib64/libc.so.6 (gdb) +set logging off