(gdb) +thread apply all bt Thread 48 (LWP 14005): +bt #0 0x000000340cc0ec0d in fsync () from /lib64/libpthread.so.0 #1 0x0000000000a6a28d in os_file_fsync (file=8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:2285 #2 os_file_flush_func (file=8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:2386 #3 0x0000000000bbe7a3 in pfs_os_file_flush_func (src_line=5722, file=8, src_file=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/include/os0file.ic:355 #4 fil_flush (space_id=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5722 #5 0x0000000000a52e9b in log_write_up_to (lsn=, wait=, flush_to_disk=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/log/log0log.cc:1587 #6 0x0000000000b28bde in trx_flush_log_if_needed (trx=0x7f1e2c0128a8, lsn=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/trx/trx0trx.cc:1310 #7 trx_commit_complete_for_mysql (trx=0x7f1e2c0128a8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/trx/trx0trx.cc:1844 #8 0x0000000000a0592d in innobase_commit (hton=, thd=0x356fc30, commit_trx=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:3835 #9 0x00000000005bcb88 in ha_commit_low (thd=0x356fc30, all=false, run_after_commit=true) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.cc:1509 #10 0x0000000000676224 in TC_LOG_DUMMY::commit (this=, thd=, all=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/log.h:115 #11 0x00000000005bd3de in ha_commit_trans (thd=0x356fc30, all=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.cc:1452 #12 0x00000000007cf1f5 in trans_commit_stmt (thd=0x356fc30) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/transaction.cc:388 #13 0x0000000000720f64 in mysql_execute_command (thd=0x356fc30) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5218 #14 0x0000000000727818 in mysql_parse (thd=0x356fc30, rawbuf=0x3571ff8 "\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=0x356fc30, packet=0x3573bc1 "REPLACE INTO `table1_int_autoinc` ( `col_char_latin1` ) VALUES ( 0 )", packet_length=68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #16 0x0000000000729a47 in do_command (thd=0x356fc30) 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=0x356fc30) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #19 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x34a20b0) 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 47 (LWP 14019): +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=0x35ac060, buf=0x35ac250 "0", 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=0x35a8520, 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=0x35a8520) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:745 #6 net_read_packet (net=, complen=0x7f1e81debc68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:810 #7 0x000000000067c3ec in my_net_read (net=0x35a8520) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:888 #8 0x00000000007299d7 in do_command (thd=0x35a82c0) 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=0x35a82c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #11 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33bb0f0) 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 46 (LWP 13715): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f1e7d507d00, fast_mutex=0x3385320, cond=0x3385360) 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=0x3385320, time_in_usec=, reset_sig_count=66) 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 45 (LWP 14025): +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=0x7f1e7c07fbe0, mutex=0x35c06c8, that=0x35c06f8) 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=0x35c06c8, owner=0x35c0590, abs_timeout=0x7f1e7c07fbe0, 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=0x35c06c8, mdl_request=0x7f1e04005358, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x000000000067a46b in MDL_context::acquire_locks (this=0x35c06c8, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2339 #5 0x00000000006c5e2e in lock_table_names (thd=0x35c0590, tables_start=0x7f1e04004d70, tables_end=, lock_wait_timeout=, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4824 #6 0x00000000006ca2c3 in open_tables (thd=0x35c0590, start=0x7f1e7c0801a8, counter=0x7f1e7c081bb8, flags=0, prelocking_strategy=0x7f1e7c081ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5037 #7 0x000000000077f8cc in mysql_alter_table (thd=0x35c0590, new_db=0x7f1e040052d0 "drizzledump_db", new_name=0x0, create_info=0x7f1e7c082190, table_list=0x7f1e04004d70, alter_info=0x7f1e7c082270, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:7841 #8 0x0000000000892ca7 in Sql_cmd_alter_table::execute (this=, thd=0x35c0590) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317 #9 0x000000000072102b in mysql_execute_command (thd=0x35c0590) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157 #10 0x0000000000727818 in mysql_parse (thd=0x35c0590, rawbuf=0x35c2958 "\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=0x35c0590, packet=0x35c4521 " ALTER TABLE dump_table4 DROP `col_bigint` ", packet_length=43) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x35c0590) 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=0x35c0590) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33bb0f0) 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 44 (LWP 13700): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=1, array=0x2ec31d0) 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=0x7f1e867c1d98, message2=0x7f1e867c1d90, type=0x7f1e867c1d88, space_id=0x7f1e867c1d80) 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 43 (LWP 13991): +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=0x7f1e90fe6e10, mutex=0x35376d8, that=0x3537708) 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=0x35376d8, owner=0x35375a0, abs_timeout=0x7f1e90fe6e10, 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=0x35376d8, mdl_request=0x7f1e90fe6ed0, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x000000000067a46b in MDL_context::acquire_locks (this=0x35376d8, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2339 #5 0x000000000084f1b5 in lock_schema_name (thd=0x35375a0, db=0x7f1e40004d00 "drizzledump_db") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/lock.cc:797 #6 0x00000000006eeeb8 in mysql_create_db (thd=0x35375a0, db=0x7f1e40004d00 "drizzledump_db", create_info=0x7f1e90fe8a00, silent=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_db.cc:559 #7 0x0000000000724dd0 in mysql_execute_command (thd=0x35375a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:4045 #8 0x0000000000727818 in mysql_parse (thd=0x35375a0, rawbuf=0x3539968 "\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=0x35375a0, packet=0x353b531 " CREATE DATABASE drizzledump_db ", packet_length=32) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #10 0x0000000000729a47 in do_command (thd=0x35375a0) 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=0x35375a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #13 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33ae7e0) 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 42 (LWP 14015): +bt #0 0x000000340cc0ee53 in pread64 () from /lib64/libpthread.so.0 #1 0x0000000000a69fb8 in pread (__offset=0, __nbytes=1048576, __buf=0x7f1dff9f3000, __fd=134) at /usr/include/bits/unistd.h:100 #2 os_file_pread (file=134, buf=0x7f1dff9f3000, n=1048576, offset=, trx=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:2476 #3 0x0000000000a6a154 in os_file_read_no_error_handling_func (file=134, buf=0x7f1dff9f3000, offset=0, n=1048576) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:2920 #4 0x0000000000abb2be in pfs_os_file_read_no_error_handling_func (src_line=755, src_file=0xde18a0 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0merge.cc", n=1048576, offset=0, buf=0x7f1dff9f3000, file=134) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/include/os0file.ic:295 #5 row_merge_read (fd=134, offset=, buf=0x7f1dff9f3000 "\002\001\200") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0merge.cc:755 #6 0x0000000000abf696 in row_merge_insert_index_tuples (trx_id=76190, index=0x7f1e10090cb8, old_table=0x7f1e742b7c38, fd=134, block=0x7f1dff9f3000 "\002\001\200") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0merge.cc:2258 #7 0x0000000000ac413e in row_merge_build_indexes (trx=0x7f1e10007cf8, old_table=0x7f1e742b7c38, new_table=0x7f1e742b7c38, online=true, indexes=0x7f1e1008fd98, key_numbers=0x7f1e1008fda0, n_indexes=1, table=0x7f1e100aa9c0, add_cols=0x0, col_map=0x0, add_autoinc=18446744073709551615, sequence=...) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0merge.cc:3580 #8 0x0000000000a10d94 in ha_innobase::inplace_alter_table (this=0x7f1e481aa110, altered_table=0x7f1e100aa9c0, ha_alter_info=0x7f1e81e6bad0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/handler0alter.cc:3897 #9 0x000000000077dd51 in ha_inplace_alter_table (ha_alter_info=0x7f1e81e6bad0, altered_table=0x7f1e100aa9c0, this=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.h:2874 #10 mysql_inplace_alter_table (thd=0x35980e0, table_list=0x7f1e10004dd8, table=0x7f1e480fa3d0, altered_table=0x7f1e100aa9c0, ha_alter_info=0x7f1e81e6bad0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f1e81e6b7d0, alter_ctx=0x7f1e81e6a1b0) 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=0x7f1e100aa9c0 "\220\262\n\020\036\177", new_name=0x7f1e100a83b0 "\b", create_info=, table_list=0x7f1e10004dd8, alter_info=0x7f1e81e6c270, 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=0x35980e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317 #13 0x000000000072102b in mysql_execute_command (thd=0x35980e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157 #14 0x0000000000727818 in mysql_parse (thd=0x35980e0, rawbuf=0x359a4a8 "\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=0x35980e0, packet=0x359c071 " ALTER TABLE table100_int_autoinc ADD INDEX `test_idx` USING HASH (`col_int_key` , `pk` ) ", packet_length=90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #16 0x0000000000729a47 in do_command (thd=0x35980e0) 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=0x35980e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #19 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x2f9bc40) 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 41 (LWP 14029): +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=0x35d4510, buf=0x35d4700 "0", 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=0x35d09d0, 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=0x35d09d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:745 #6 net_read_packet (net=, complen=0x7f1dffffec68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:810 #7 0x000000000067c3ec in my_net_read (net=0x35d09d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:888 #8 0x00000000007299d7 in do_command (thd=0x35d0770) 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=0x35d0770) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #11 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33bb0f0) 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 40 (LWP 13997): +bt #0 0x000000340cc0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000340cc0a864 in pthread_rwlock_rdlock () from /lib64/libpthread.so.0 #2 0x0000000000c6c2b4 in read_lock_stack (cs=0x7f1e3c0009a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:424 #3 _db_enter_ (_func_=0xcb8e61 "Item_field::cleanup", _file_=0xcb9260 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/item.cc", _line_=5593, _stack_frame_=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:1247 #4 0x00000000005c98b2 in Item_field::cleanup (this=0x7f1e3c0017e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/item.cc:5593 #5 0x00000000006de251 in delete_self (this=0x7f1e3c0017e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/item.h:1589 #6 Query_arena::free_items (this=0x354f878) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_class.cc:3504 #7 0x00000000006e3cd9 in THD::cleanup_after_query (this=0x354f870) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_class.cc:2183 #8 0x000000000072743f in mysql_parse (thd=0x354f870, rawbuf=0x3551c38 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6510 #9 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x354f870, packet=0x3553801 " INSERT INTO `table1_myisam_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 `table10_myisam` WHERE 0 BETWEEN 96 AND 821166080 ORDER BY `col_bit`,`col_bit_default_null`,`col_bit_key`,`col_bit_key_default_null`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_default_null`,`col_blob_key`,`col_blob_key_default_null`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_latin1`,`col_char_latin1_default_null`,`col_char_latin1_key`,`col_char_latin1_key_default_null`,`col_char_latin1_not_null`,`col_char_latin1_not_null_key`,`col_char_utf8`,`col_char_utf8_default_null`,`col_char_utf8_key`,`col_char_utf8_key_default_null`,`col_char_utf8_not_null`,`col_char_utf8_not_null_key`,`col_decimal`,`col_decimal_default_null`,`col_decimal_key`,`col_decimal_key_default_null`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_default_null`,`col_decimal_unsigned_key`,`col_decimal_unsigned_key_default_null`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_default_null`,`col_float_key`,`col_float_key_default_null`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_default_null`,`col_float_unsigned_key`,`col_float_unsigned_key_default_null`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key` LIMIT 25 /*Generated by THREAD_ID 7*/ ", packet_length=3113) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #10 0x0000000000729a47 in do_command (thd=0x354f870) 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=0x354f870) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #13 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33ae7e0) 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 39 (LWP 13706): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=3, array=0x2ffc340) 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=0x7f1e82bbbd98, message2=0x7f1e82bbbd90, type=0x7f1e82bbbd88, space_id=0x7f1e82bbbd80) 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 38 (LWP 13703): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x2ffc340) 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=0x7f1e849bed98, message2=0x7f1e849bed90, type=0x7f1e849bed88, space_id=0x7f1e849bed80) 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 37 (LWP 13695): +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=0x2ec1148) 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 36 (LWP 13999): +bt #0 0x000000340cc0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000340cc0ae90 in pthread_rwlock_unlock () from /lib64/libpthread.so.0 #2 0x0000000000c6d2a3 in unlock_stack (cs=0x7f1e300009a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:437 #3 _db_return_ (_line_=357, _stack_frame_=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:1343 #4 0x0000000000c9e734 in vio_socket_timeout (vio=, which=, old_mode=0 '\000') at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:357 #5 0x000000000067b4c1 in my_net_set_read_timeout (net=0x3557bc0, timeout=30) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:1031 #6 0x0000000000729a35 in do_command (thd=0x3557960) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1045 #7 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 #8 0x00000000006ed727 in handle_one_connection (arg=0x3557960) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #9 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33ae7e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #10 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #11 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 35 (LWP 14007): +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=0x7f1e81f6ee10, mutex=0x3577e58, that=0x3577e88) 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=0x3577e58, owner=0x3577d20, abs_timeout=0x7f1e81f6ee10, 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=0x3577e58, mdl_request=0x7f1e81f6eed0, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x000000000067a46b in MDL_context::acquire_locks (this=0x3577e58, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2339 #5 0x000000000084f1b5 in lock_schema_name (thd=0x3577d20, db=0x7f1e20004d08 "drizzledump_db") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/lock.cc:797 #6 0x00000000006eeeb8 in mysql_create_db (thd=0x3577d20, db=0x7f1e20004d08 "drizzledump_db", create_info=0x7f1e81f70a00, silent=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_db.cc:559 #7 0x0000000000724dd0 in mysql_execute_command (thd=0x3577d20) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:4045 #8 0x0000000000727818 in mysql_parse (thd=0x3577d20, rawbuf=0x357a0e8 "\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=0x3577d20, packet=0x357bcb1 " CREATE DATABASE drizzledump_db ", packet_length=32) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #10 0x0000000000729a47 in do_command (thd=0x3577d20) 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=0x3577d20) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #13 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x34a20b0) 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 34 (LWP 13989): +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 0x00000000006c73b8 in inline_mysql_mutex_lock (src_line=2941, src_file=0xcd9740 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", that=0x14e5d00 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 open_table (thd=0x352f4b0, table_list=0x7f1e4c0051c0, ot_ctx=0x7f1e910291e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2941 #5 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f1e910291e0, has_prelocking_list=false, prelocking_strategy=0x7f1e91029300, flags=0, counter=0x3531930, tables=0x7f1e4c0051c0, lex=0x3531878, thd=0x352f4b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #6 open_tables (thd=0x352f4b0, start=0x7f1e910292c8, counter=0x3531930, flags=0, prelocking_strategy=0x7f1e91029300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #7 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f1e4c0051c0, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #8 0x000000000071eb4d in execute_sqlcom_select (thd=0x352f4b0, all_tables=0x7f1e4c0051c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #9 0x00000000007217b7 in mysql_execute_command (thd=0x352f4b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #10 0x0000000000727818 in mysql_parse (thd=0x352f4b0, rawbuf=0x3531878 "\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=0x352f4b0, packet=0x3533441 "SELECT GRANDPARENT1 . `col_char_10` AS G1 FROM C AS GRANDPARENT1 LEFT JOIN AA AS GRANDPARENT2 USING ( `col_bigint` ) WHERE ( GRANDPARENT1 . `col_int_not_null_key` , GRANDPARENT1 . `col_bigint` ) IN ( SELECT PARENT1 . `col_int_not_null_key` AS P1 , PARENT1 . `col_int_not_null_key` AS P2 FROM B AS PARENT1 LEFT JOIN C AS PARENT2 USING ( `col_int_not_null_key` ) ) AND GRANDPARENT1 . `col_bigint` IS NOT NULL", packet_length=406) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x352f4b0) 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=0x352f4b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33ae7e0) 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 33 (LWP 13713): +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 32 (LWP 13712): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6f533 in os_cond_wait (fast_mutex=0x2fbc860, cond=0x2fbc8a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2fbc860, reset_sig_count=7609) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610 #3 0x0000000000b0404c in srv_purge_coordinator_suspend (rseg_history_len=2018, slot=0x2fbc670) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:3140 #4 srv_purge_coordinator_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:3257 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 31 (LWP 13699): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x2ec31d0) 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=0x7f1e871c2d98, message2=0x7f1e871c2d90, type=0x7f1e871c2d88, space_id=0x7f1e871c2d80) 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 30 (LWP 13697): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x2fee8a0) 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=0x7f1e9a359d98, message2=0x7f1e9a359d90, type=0x7f1e9a359d88, space_id=0x7f1e9a359d80) 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 29 (LWP 14009): +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 0x00000000006c73b8 in inline_mysql_mutex_lock (src_line=2941, src_file=0xcd9740 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", that=0x14e5d00 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 open_table (thd=0x357fe10, table_list=0x7f1e24004ef0, ot_ctx=0x7f1e81f2f1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2941 #5 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f1e81f2f1e0, has_prelocking_list=false, prelocking_strategy=0x7f1e81f2f300, flags=0, counter=0x3582290, tables=0x7f1e24004ef0, lex=0x35821d8, thd=0x357fe10) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #6 open_tables (thd=0x357fe10, start=0x7f1e81f2f2c8, counter=0x3582290, flags=0, prelocking_strategy=0x7f1e81f2f300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #7 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f1e24004ef0, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #8 0x000000000071eb4d in execute_sqlcom_select (thd=0x357fe10, all_tables=0x7f1e24004ef0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #9 0x00000000007217b7 in mysql_execute_command (thd=0x357fe10) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #10 0x0000000000727818 in mysql_parse (thd=0x357fe10, rawbuf=0x35821d8 "\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=0x357fe10, packet=0x3583da1 "SELECT * FROM `data_dictionary` . CUMULATIVE_USER_STATS", packet_length=55) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x357fe10) 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=0x357fe10) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x3513180) 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 28 (LWP 14001): +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=0x7f1e82030be0, mutex=0x355fb88, that=0x355fbb8) 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=0x355fb88, owner=0x355fa50, abs_timeout=0x7f1e82030be0, 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=0x355fb88, mdl_request=0x7f1e34005328, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x000000000067a46b in MDL_context::acquire_locks (this=0x355fb88, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2339 #5 0x00000000006c5e2e in lock_table_names (thd=0x355fa50, tables_start=0x7f1e34004d68, tables_end=, lock_wait_timeout=, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4824 #6 0x00000000006ca2c3 in open_tables (thd=0x355fa50, start=0x7f1e820311a8, counter=0x7f1e82032bb8, flags=0, prelocking_strategy=0x7f1e82032ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5037 #7 0x000000000077f8cc in mysql_alter_table (thd=0x355fa50, new_db=0x7f1e340052c8 "drizzledump_db", new_name=0x0, create_info=0x7f1e82033190, table_list=0x7f1e34004d68, alter_info=0x7f1e82033270, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:7841 #8 0x0000000000892ca7 in Sql_cmd_alter_table::execute (this=, thd=0x355fa50) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317 #9 0x000000000072102b in mysql_execute_command (thd=0x355fa50) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157 #10 0x0000000000727818 in mysql_parse (thd=0x355fa50, rawbuf=0x3561e18 "\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=0x355fa50, packet=0x35639e1 " ALTER TABLE dump_table3 DROP field0 ", packet_length=37) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x355fa50) 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=0x355fa50) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33ae7e0) 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 27 (LWP 14027): +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 0x00000000006c73b8 in inline_mysql_mutex_lock (src_line=2941, src_file=0xcd9740 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", that=0x14e5d00 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 open_table (thd=0x35c8680, table_list=0x7f1df8057ab0, ot_ctx=0x7f1e7c041240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2941 #5 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f1e7c041240, has_prelocking_list=false, prelocking_strategy=0x7f1e7c041360, flags=0, counter=0x35cab00, tables=0x7f1df8057ab0, lex=0x35caa48, thd=0x35c8680) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #6 open_tables (thd=0x35c8680, start=0x7f1e7c041328, counter=0x35cab00, flags=0, prelocking_strategy=0x7f1e7c041360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #7 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f1df8005be8, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #8 0x0000000000726d57 in mysql_execute_command (thd=0x35c8680) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3183 #9 0x0000000000727818 in mysql_parse (thd=0x35c8680, rawbuf=0x35caa48 "\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=0x35c8680, packet=0x35cc611 " CREATE TABLE dump_table5 ( `pk` INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(`pk`)) SELECT t1 . `col_char_10` AS field0 , t1 . `col_char_10_key` AS field1 , t1 . `col_char_10_not_null` AS field2 , t1 . `col_char_10_not_null_key` AS field3 , t1 . `col_char_1024` AS field4 , t1 . `col_char_1024_key` AS field5 , t1 . `col_char_1024_not_null` AS field6 , t1 . `col_char_1024_not_null_key` AS field7 , t1 . `col_int` AS field8 , t1 . `col_int_key` AS field9 , t1 . `col_int_not_null` AS field10 , t1 . `col_int_not_null_key` AS field11 , t1 . `col_bigint` AS field12 , t1 . `col_bigint_key` AS field13 , t1 . `col_bigint_not_null` AS field14 , t1 . `col_bigint_not_null_key` AS field15 , t1 . `col_enum` AS field16 , t1 . `col_enum_key` AS field17 , t1 . `col_enum_not_null` AS field18 , t1 . `col_enum_not_null_key` AS field19 , t1 . `col_text` AS field20 , t1 . `col_text_key` AS field21 , t1 . `col_text_not_null` AS field22 , t1 . `col_text_not_null_key` AS field23 , t2 . `col_char_10` AS field24 , t2 . `col_char_10_key` AS field25 , t2 . `col_char_10_not_null` AS field26 , t2 . `col_char_10_not_null_key` AS field27 , t2 . `col_char_1024` AS field28 , t2 . `col_char_1024_key` AS field29 , t2 . `col_char_1024_not_null` AS field30 , t2 . `col_char_1024_not_null_key` AS field31 , t2 . `col_int` AS field32 , t2 . `col_int_key` AS field33 , t2 . `col_int_not_null` AS field34 , t2 . `col_int_not_null_key` AS field35 , t2 . `col_bigint` AS field36 , t2 . `col_bigint_key` AS field37 , t2 . `col_bigint_not_null` AS field38 , t2 . `col_bigint_not_null_key` AS field39 , t2 . `col_enum` AS field40 , t2 . `col_enum_key` AS field41 , t2 . `col_enum_not_null` AS field42 , t2 . `col_enum_not_null_key` AS field43 , t2 . `col_text` AS field44 , t2 . `col_text_key` AS field45 , t2 . `col_text_not_null` AS field46 , t2 . `col_text_not_null_key` AS field47 FROM `test`. CC AS t1 , `test`. AA AS t2 ", packet_length=1893) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #11 0x0000000000729a47 in do_command (thd=0x35c8680) 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=0x35c8680) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #14 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33bb0f0) 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 26 (LWP 13716): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f1e7cb06c90, fast_mutex=0x33b5490, cond=0x33b54d0) 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=0x33b5490, 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=0x33b52d8, 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=0x33b52d8) 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 25 (LWP 13710): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f1e8070cd30, fast_mutex=0x2fbc980, cond=0x2fbc9c0) 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=0x2fbc980, 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 24 (LWP 13705): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=2, array=0x2ffc340) 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=0x7f1e835bcd98, message2=0x7f1e835bcd90, type=0x7f1e835bcd88, space_id=0x7f1e835bcd80) 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 23 (LWP 13717): +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=0x33d6380) 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 22 (LWP 14013): +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=0x7f1e81eaabe0, mutex=0x3590128, that=0x3590158) 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=0x3590128, owner=0x358fff0, abs_timeout=0x7f1e81eaabe0, 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=0x3590128, mdl_request=0x7f1e1c005398, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x000000000067a46b in MDL_context::acquire_locks (this=0x3590128, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2339 #5 0x00000000006c5e2e in lock_table_names (thd=0x358fff0, tables_start=0x7f1e1c004d88, tables_end=, lock_wait_timeout=, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4824 #6 0x00000000006ca2c3 in open_tables (thd=0x358fff0, start=0x7f1e81eab1a8, counter=0x7f1e81eacbb8, flags=0, prelocking_strategy=0x7f1e81eacba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5037 #7 0x000000000077f8cc in mysql_alter_table (thd=0x358fff0, new_db=0x7f1e1c0052e8 "drizzledump_db", new_name=0x0, create_info=0x7f1e81ead190, table_list=0x7f1e1c004d88, alter_info=0x7f1e81ead270, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:7841 #8 0x0000000000892ca7 in Sql_cmd_alter_table::execute (this=, thd=0x358fff0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317 #9 0x000000000072102b in mysql_execute_command (thd=0x358fff0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157 #10 0x0000000000727818 in mysql_parse (thd=0x358fff0, rawbuf=0x35923b8 "\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=0x358fff0, packet=0x3593f81 " ALTER TABLE dump_table4 DROP `col_int_not_null_key` ", packet_length=53) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x358fff0) 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=0x358fff0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x2f9bc40) 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 21 (LWP 13714): +bt #0 0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6f533 in os_cond_wait (fast_mutex=0x2fbca10, cond=0x2fbca50) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2fbca10, 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 20 (LWP 14011): +bt #0 0x000000340cc0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000340cc0ae90 in pthread_rwlock_unlock () from /lib64/libpthread.so.0 #2 0x0000000000c6d2a3 in unlock_stack (cs=0x7f1e180009a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:437 #3 _db_return_ (_line_=721, _stack_frame_=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:1343 #4 0x00000000005c9712 in Item::cleanup (this=0x7f1e18048bf0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/item.cc:721 #5 0x00000000005c97da in Item_ident::cleanup (this=0x7f1e18048bf0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/item.cc:838 #6 0x00000000005c98ba in Item_field::cleanup (this=0x7f1e18048bf0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/item.cc:5594 #7 0x00000000006de251 in delete_self (this=0x7f1e18048bf0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/item.h:1589 #8 Query_arena::free_items (this=0x3587f08) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_class.cc:3504 #9 0x00000000006e3cd9 in THD::cleanup_after_query (this=0x3587f00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_class.cc:2183 #10 0x000000000072743f in mysql_parse (thd=0x3587f00, rawbuf=0x358a2c8 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6510 #11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x3587f00, packet=0x358be91 " DELETE FROM `table0_myisam_key_pk_parts_2_int_autoinc` WHERE `col_char_255` = 'g' ORDER BY `col_bit`,`col_bit_default_null`,`col_bit_key`,`col_bit_key_default_null`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_default_null`,`col_blob_key`,`col_blob_key_default_null`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_latin1`,`col_char_latin1_default_null`,`col_char_latin1_key`,`col_char_latin1_key_default_null`,`col_char_latin1_not_null`,`col_char_latin1_not_null_key`,`col_char_utf8`,`col_char_utf8_default_null`,`col_char_utf8_key`,`col_char_utf8_key_default_null`,`col_char_utf8_not_null`,`col_char_utf8_not_null_key`,`col_decimal`,`col_decimal_default_null`,`col_decimal_key`,`col_decimal_key_default_null`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_default_null`,`col_decimal_unsigned_key`,`col_decimal_unsigned_key_default_null`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_default_null`,`col_float_key`,`col_float_key_default_null`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_default_null`,`col_float_unsigned_key`,`col_float_unsigned_key_default_null`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 2 /*Generated by THREAD_ID 14*/ ", packet_length=2239) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x3587f00) 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=0x3587f00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x3513180) 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 19 (LWP 13723): +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 0x00000000006c73b8 in inline_mysql_mutex_lock (src_line=2941, src_file=0xcd9740 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", that=0x14e5d00 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 open_table (thd=0x3522f30, table_list=0x7f1e741b9ce0, ot_ctx=0x7f1e82177c60) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2941 #5 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f1e82177c60, has_prelocking_list=false, prelocking_strategy=0x7f1e82177d80, flags=0, counter=0x35253b0, tables=0x7f1e741b9ce0, lex=0x35252f8, thd=0x3522f30) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #6 open_tables (thd=0x3522f30, start=0x7f1e82177d48, counter=0x35253b0, flags=0, prelocking_strategy=0x7f1e82177d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #7 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f1e741b9ce0, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #8 0x000000000079bf6d in mysql_update (thd=0x3522f30, table_list=0x7f1e741b9ce0, fields=..., values=..., conds=0x7f1e741ba648, order_num=84, order=0x7f1e741ba908, limit=7, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f1e82179038, updated_return=0x7f1e82179040) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:251 #9 0x00000000007212cb in mysql_execute_command (thd=0x3522f30) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3511 #10 0x0000000000727818 in mysql_parse (thd=0x3522f30, rawbuf=0x35252f8 "\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=0x3522f30, packet=0x35271f1 " UPDATE `table10` SET `col_int` = 3689873408 WHERE `col_char_10` < 'c' ORDER BY `col_bit`,`col_bit_default_null`,`col_bit_key`,`col_bit_key_default_null`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_default_null`,`col_blob_key`,`col_blob_key_default_null`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_latin1`,`col_char_latin1_default_null`,`col_char_latin1_key`,`col_char_latin1_key_default_null`,`col_char_latin1_not_null`,`col_char_latin1_not_null_key`,`col_char_utf8`,`col_char_utf8_default_null`,`col_char_utf8_key`,`col_char_utf8_key_default_null`,`col_char_utf8_not_null`,`col_char_utf8_not_null_key`,`col_decimal`,`col_decimal_default_null`,`col_decimal_key`,`col_decimal_key_default_null`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_default_null`,`col_decimal_unsigned_key`,`col_decimal_unsigned_key_default_null`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_default_null`,`col_float_key`,`col_float_key_default_null`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_default_null`,`col_float_unsigned_key`,`col_float_unsigned_key_default_null`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key` LIMIT 7 /* 'foo' Generated by THREAD_ID 1*/ ", packet_length=2228) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x3522f30) 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=0x3522f30) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x3479500) 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 18 (LWP 14032): +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 0x00000000006c73b8 in inline_mysql_mutex_lock (src_line=2941, src_file=0xcd9740 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", that=0x14e5d00 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 open_table (thd=0x35d8860, table_list=0x7f1dec0055f8, ot_ctx=0x7f1dfffbc1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2941 #5 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f1dfffbc1e0, has_prelocking_list=false, prelocking_strategy=0x7f1dfffbc300, flags=0, counter=0x35dace0, tables=0x7f1dec0055f8, lex=0x35dac28, thd=0x35d8860) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #6 open_tables (thd=0x35d8860, start=0x7f1dfffbc2c8, counter=0x35dace0, flags=0, prelocking_strategy=0x7f1dfffbc300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #7 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f1dec0055f8, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #8 0x000000000071eb4d in execute_sqlcom_select (thd=0x35d8860, all_tables=0x7f1dec0055f8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #9 0x00000000007217b7 in mysql_execute_command (thd=0x35d8860) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #10 0x0000000000727818 in mysql_parse (thd=0x35d8860, rawbuf=0x35dac28 "\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=0x35d8860, packet=0x35dc7f1 " SELECT DISTINCT table1 . fbase_film_detail_id AS field1 , fbase_role_code AS field2 , genre_tag AS field3 FROM `fbase_film_series` AS table1 JOIN `fbase_film_crew` AS table2 ON table1 . fbase_film_detail_id = table2 . fbase_film_detail_id RIGHT OUTER JOIN `fbase_film_genre` AS table3 ON table1 . fbase_film_detail_id = table3 . fbase_film_detail_id WHERE ( related_film_id < 'g' ) AND ( LENGTH( fbase_role_code ) <> 50 AND sequel_flag <> FALSE OR related_film_id <= table3 . fbase_film_detail_id AND sequel_flag = 0 ) AND ( genre_tag < 'ORODI' OR related_film_id >= 'UQOJU' ) ORDER BY field1, field2, field3 LIMIT 10000", packet_length=621) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x35d8860) 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=0x35d8860) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33bb0f0) 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 17 (LWP 13711): +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 16 (LWP 13995): +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 0x00000000006c73b8 in inline_mysql_mutex_lock (src_line=2941, src_file=0xcd9740 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", that=0x14e5d00 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 open_table (thd=0x3547780, table_list=0x7f1e38006648, ot_ctx=0x7f1e820f6240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2941 #5 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f1e820f6240, has_prelocking_list=false, prelocking_strategy=0x7f1e820f6360, flags=0, counter=0x3549c00, tables=0x7f1e38006648, lex=0x3549b48, thd=0x3547780) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #6 open_tables (thd=0x3547780, start=0x7f1e820f6328, counter=0x3549c00, flags=0, prelocking_strategy=0x7f1e820f6360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #7 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f1e38006648, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #8 0x00000000007219f2 in mysql_execute_command (thd=0x3547780) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705 #9 0x0000000000727818 in mysql_parse (thd=0x3547780, rawbuf=0x3549b48 "\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=0x3547780, packet=0x354b711 " INSERT INTO `table100_myisam_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 `table10_innodb` WHERE `col_int_not_null` BETWEEN 33 AND 6 ORDER BY `col_bit`,`col_bit_default_null`,`col_bit_key`,`col_bit_key_default_null`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_default_null`,`col_blob_key`,`col_blob_key_default_null`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_latin1`,`col_char_latin1_default_null`,`col_char_latin1_key`,`col_char_latin1_key_default_null`,`col_char_latin1_not_null`,`col_char_latin1_not_null_key`,`col_char_utf8`,`col_char_utf8_default_null`,`col_char_utf8_key`,`col_char_utf8_key_default_null`,`col_char_utf8_not_null`,`col_char_utf8_not_null_key`,`col_decimal`,`col_decimal_default_null`,`col_decimal_key`,`col_decimal_key_default_null`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_default_null`,`col_decimal_unsigned_key`,`col_decimal_unsigned_key_default_null`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_default_null`,`col_float_key`,`col_float_key_default_null`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_default_null`,`col_float_unsigned_key`,`col_float_unsigned_key_default_null`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key` LIMIT 50 /*Generated by THREAD_ID 6*/ ", packet_length=3124) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #11 0x0000000000729a47 in do_command (thd=0x3547780) 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=0x3547780) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #14 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33ae7e0) 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 15 (LWP 13718): +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=0x351ebe0, buf=0x351edd0 "\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=0x3441670, 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=0x3441670) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:745 #6 net_read_packet (net=, complen=0x7f1e821bac68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:810 #7 0x000000000067c3ec in my_net_read (net=0x3441670) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:888 #8 0x00000000007299d7 in do_command (thd=0x3441410) 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=0x3441410) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #11 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x350a2d0) 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 14 (LWP 13987): +bt #0 0x000000340cc0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000340cc0ae90 in pthread_rwlock_unlock () from /lib64/libpthread.so.0 #2 0x0000000000c6d2a3 in unlock_stack (cs=0x7f1e480009a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:437 #3 _db_return_ (_line_=518, _stack_frame_=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:1343 #4 0x00000000007728df in tablename_to_filename (from=0x7f1e48005510 "dump_table4", to=0x7f1e82136460 "dump_table4", to_length=512) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:518 #5 0x0000000000772ae7 in build_table_filename (buff=0x7f1e82136700 "`i\023\202\036\177", bufflen=511, db=0x7f1e48005ab8 "drizzledump_db", table_name=0x7f1e48005510 "dump_table4", ext=0xdadda0 "", flags=, was_truncated=0x7f1e8213698f) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:568 #6 0x00000000007c2ef0 in build_table_filename (flags=0, ext=0xdadda0 "", table=, db=, bufflen=511, buff=0x7f1e82136700 "`i\023\202\036\177") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.h:159 #7 alloc_table_share (table_list=0x7f1e48005558, key=0x7f1e4800591d "drizzledump_db", key_length=27) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table.cc:334 #8 0x00000000006bd47f in get_table_share (thd=0x33b7390, table_list=0x7f1e48005558, key=0x7f1e4800591d "drizzledump_db", key_length=27, db_flags=8192, error=0x7f1e82137168, hash_value=620865332) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:483 #9 0x00000000006c6b96 in get_table_share_with_discover (hash_value=620865332, error=0x7f1e82137168, key_length=27, key=0x7f1e4800591d "drizzledump_db", table_list=0x7f1e48005558, thd=0x33b7390, db_flags=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:587 #10 open_table (thd=0x33b7390, table_list=0x7f1e48005558, ot_ctx=0x7f1e82137240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2943 #11 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f1e82137240, has_prelocking_list=false, prelocking_strategy=0x7f1e82137360, flags=0, counter=0x33b9810, tables=0x7f1e48005558, lex=0x33b9758, thd=0x33b7390) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #12 open_tables (thd=0x33b7390, start=0x7f1e82137328, counter=0x33b9810, flags=0, prelocking_strategy=0x7f1e82137360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #13 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f1e48005558, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #14 0x00000000007219f2 in mysql_execute_command (thd=0x33b7390) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705 #15 0x0000000000727818 in mysql_parse (thd=0x33b7390, rawbuf=0x33b9758 "\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=0x33b7390, packet=0x352b351 " INSERT INTO dump_table4 ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_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` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_1024` , `col_char_1024_key` , `col_char_1024_not_null` , `col_char_1024_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` , `col_text` , `col_text_key` , `col_text_not_null` , `col_text_not_null_key` FROM `test` . BB ", packet_length=1057) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #17 0x0000000000729a47 in do_command (thd=0x33b7390) 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=0x33b7390) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #20 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33ae7e0) 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 13 (LWP 13708): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f1e8110dd00, fast_mutex=0x337f750, cond=0x337f790) 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=0x337f750, time_in_usec=, reset_sig_count=78) 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 12 (LWP 13701): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=2, array=0x2ec31d0) 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=0x7f1e85dc0d98, message2=0x7f1e85dc0d90, type=0x7f1e85dc0d88, space_id=0x7f1e85dc0d80) 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 11 (LWP 13698): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x2fe0e00) 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=0x7f1e87bc3d98, message2=0x7f1e87bc3d90, type=0x7f1e87bc3d88, space_id=0x7f1e87bc3d80) 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 10 (LWP 13709): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f1e81b0ecc0, fast_mutex=0x2fbc8f0, cond=0x2fbc930) 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=0x2fbc8f0, 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 9 (LWP 13993): +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=0x7f1e90fa5a20, mutex=0x353f7c8, that=0x353f7f8) 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=0x353f7c8, owner=0x353f690, abs_timeout=0x7f1e90fa5a20, 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=0x353f7c8, mdl_request=0x7f1e90fa5ae0, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245 #4 0x000000000067a46b in MDL_context::acquire_locks (this=0x353f7c8, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2339 #5 0x000000000084f1b5 in lock_schema_name (thd=0x353f690, db=0x7f1e44004d20 "drizzledump_db") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/lock.cc:797 #6 0x00000000006f06d3 in mysql_rm_db (thd=0x353f690, db=0x7f1e44004d20 "drizzledump_db", if_exists=true, silent=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_db.cc:773 #7 0x0000000000724d44 in mysql_execute_command (thd=0x353f690) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:4068 #8 0x0000000000727818 in mysql_parse (thd=0x353f690, rawbuf=0x3541a58 "\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=0x353f690, packet=0x3543621 " DROP DATABASE IF EXISTS drizzledump_db ", packet_length=40) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #10 0x0000000000729a47 in do_command (thd=0x353f690) 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=0x353f690) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #13 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33ae7e0) 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 8 (LWP 13704): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=1, array=0x2ffc340) 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=0x7f1e83fbdd98, message2=0x7f1e83fbdd90, type=0x7f1e83fbdd88, space_id=0x7f1e83fbdd80) 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 7 (LWP 14035): +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=0x35e8a40) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #6 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x344e5f0) 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 6 (LWP 14021): +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 0x00000000006c73b8 in inline_mysql_mutex_lock (src_line=2941, src_file=0xcd9740 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc", that=0x14e5d00 ) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:690 #4 open_table (thd=0x35b03b0, table_list=0x7f1e0c005400, ot_ctx=0x7f1e7c1041e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2941 #5 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f1e7c1041e0, has_prelocking_list=false, prelocking_strategy=0x7f1e7c104300, flags=0, counter=0x35b2830, tables=0x7f1e0c005400, lex=0x35b2778, thd=0x35b03b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567 #6 open_tables (thd=0x35b03b0, start=0x7f1e7c1042c8, counter=0x35b2830, flags=0, prelocking_strategy=0x7f1e7c104300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069 #7 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=, tables=0x7f1e0c005400, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768 #8 0x000000000071eb4d in execute_sqlcom_select (thd=0x35b03b0, all_tables=0x7f1e0c005400) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278 #9 0x00000000007217b7 in mysql_execute_command (thd=0x35b03b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #10 0x0000000000727818 in mysql_parse (thd=0x35b03b0, rawbuf=0x35b2778 "\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=0x35b03b0, packet=0x35b4341 " SELECT DISTINCT mmg_t1 . `title` AS field1 , COUNT( `genre` ) FROM mlens_movie AS mmg_t1 LEFT JOIN mlens_genre AS mmg_t2 ON mmg_t1 . `id` = mmg_t2 . `mlens_movie_id` WHERE mmg_t2 . `genre` IN ( 'Mystery' , 'Mystery' ) AND ( mmg_t1 . `year` <= 1995 AND mmg_t1 . `year` <> 1980 ) AND ( mmg_t2 . `genre` BETWEEN 'LXIDO' AND 'all' ) GROUP BY field1 ORDER BY field1 ASC LIMIT 5000", packet_length=378) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #12 0x0000000000729a47 in do_command (thd=0x35b03b0) 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=0x35b03b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33bb0f0) 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 5 (LWP 14023): +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=0x35bc240, buf=0x35bc430 "P", 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=0x35b8700, 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=0x35b8700) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:745 #6 net_read_packet (net=, complen=0x7f1e7c0c4c68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:810 #7 0x000000000067c3ec in my_net_read (net=0x35b8700) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:888 #8 0x00000000007299d7 in do_command (thd=0x35b84a0) 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=0x35b84a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #11 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33bb0f0) 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 4 (LWP 13702): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=3, array=0x2ec31d0) 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=0x7f1e853bfd98, message2=0x7f1e853bfd90, type=0x7f1e853bfd88, space_id=0x7f1e853bfd80) 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 3 (LWP 14003): +bt #0 0x0000000000597a08 in pthread_rwlock_rdlock@plt () #1 0x0000000000c6d456 in read_lock_stack (cs=0x7f1e280009a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:424 #2 _db_return_ (_line_=247, _stack_frame_=0x7f1e81ff2140) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/dbug/dbug.c:1318 #3 0x000000000097dbfe in alloc_root (mem_root=0x356b168, length=264) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/mysys/my_alloc.c:247 #4 0x00000000006110e2 in Item::operator new (size=, mem_root=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/item.h:665 #5 0x00000000008092dd in MYSQLparse (yythd=0x3567b40) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_yacc.yy:13691 #6 0x0000000000718aad in parse_sql (thd=0x3567b40, parser_state=0x7f1e81ff3a90, creation_ctx=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:8451 #7 0x0000000000727360 in mysql_parse (thd=0x3567b40, rawbuf=0x3569f08 "\360R7\001", length=, parser_state=0x7f1e81ff3a90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6381 #8 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x3567b40, packet=0x356bad1 " INSERT INTO `table1_myisam` ( `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_autoinc` WHERE 0 BETWEEN 4 AND 5 ORDER BY `col_bit`,`col_bit_default_null`,`col_bit_key`,`col_bit_key_default_null`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_default_null`,`col_blob_key`,`col_blob_key_default_null`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_latin1`,`col_char_latin1_default_null`,`col_char_latin1_key`,`col_char_latin1_key_default_null`,`col_char_latin1_not_null`,`col_char_latin1_not_null_key`,`col_char_utf8`,`col_char_utf8_default_null`,`col_char_utf8_key`,`col_char_utf8_key_default_null`,`col_char_utf8_not_null`,`col_char_utf8_not_null_key`,`col_decimal`,`col_decimal_default_null`,`col_decimal_key`,`col_decimal_key_default_null`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_default_null`,`col_decimal_unsigned_key`,`col_decimal_unsigned_key_default_null`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_default_null`,`col_float_key`,`col_float_key_default_null`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_default_null`,`col_float_unsigned_key`,`col_float_unsigned_key_default_null`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 25 /*Generated by THREAD_ID 10*/ ", packet_length=3087) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #9 0x0000000000729a47 in do_command (thd=0x3567b40) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #10 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 #11 0x00000000006ed727 in handle_one_connection (arg=0x3567b40) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #12 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33ae7e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #13 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #14 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 2 (LWP 14034): +bt #0 0x00007fff57bffa01 in clock_gettime () #1 0x000000340d803e46 in clock_gettime () from /lib64/librt.so.1 #2 0x000000000072774e in mysql_parse (thd=0x35e0950, rawbuf=0x35e2d18 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6558 #3 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x35e0950, packet=0x35e48e1 " UPDATE `table0_myisam` SET `col_int_key` = 8 WHERE `col_char_255_key` > 'e' ORDER BY `col_bit`,`col_bit_default_null`,`col_bit_key`,`col_bit_key_default_null`,`col_bit_not_null`,`col_bit_not_null_key`,`col_blob`,`col_blob_default_null`,`col_blob_key`,`col_blob_key_default_null`,`col_blob_not_null`,`col_blob_not_null_key`,`col_char_latin1`,`col_char_latin1_default_null`,`col_char_latin1_key`,`col_char_latin1_key_default_null`,`col_char_latin1_not_null`,`col_char_latin1_not_null_key`,`col_char_utf8`,`col_char_utf8_default_null`,`col_char_utf8_key`,`col_char_utf8_key_default_null`,`col_char_utf8_not_null`,`col_char_utf8_not_null_key`,`col_decimal`,`col_decimal_default_null`,`col_decimal_key`,`col_decimal_key_default_null`,`col_decimal_not_null`,`col_decimal_not_null_key`,`col_decimal_unsigned`,`col_decimal_unsigned_default_null`,`col_decimal_unsigned_key`,`col_decimal_unsigned_key_default_null`,`col_decimal_unsigned_not_null`,`col_decimal_unsigned_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_float`,`col_float_default_null`,`col_float_key`,`col_float_key_default_null`,`col_float_not_null`,`col_float_not_null_key`,`col_float_unsigned`,`col_float_unsigned_default_null`,`col_float_unsigned_key`,`col_float_unsigned_key_default_null`,`col_float_unsigned_not_null`,`col_float_unsigned_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key` LIMIT 8 /*Generated by THREAD_ID 25*/ ", packet_length=2228) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #4 0x0000000000729a47 in do_command (thd=0x35e0950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #5 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 #6 0x00000000006ed727 in handle_one_connection (arg=0x35e0950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #7 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x33bb0f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #8 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #9 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 1 (LWP 14017): +bt #0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000686bde in handle_fatal_signal (sig=11) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/signal_handler.cc:251 #2 #3 0x000000340c47b6ec in free () from /lib64/libc.so.6 #4 0x0000000000983ba6 in my_free (ptr=0x8f8f8f8f8f8f8f8f) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/mysys/my_malloc.c:137 #5 0x00000000009ffd6f in ha_innobase::close (this=0x7f1e14037320) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:5387 #6 0x00000000005b48cd in handler::ha_close (this=0x7f1e14037320) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.cc:2550 #7 0x0000000000755653 in store_temporary_table_record (thd=0x33b7390, table=0x7f1e1400a9e0, tmp_table=, db=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:3990 #8 0x0000000000764b39 in fill_global_temporary_tables (thd=0x35a01d0, tables=0x7f1e14005010, cond=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:4043 #9 0x0000000000759219 in do_fill_table (join_table=, table_list=0x7f1e14005010, thd=0x35a01d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:7714 #10 get_schema_tables_result (join=0x7f1e140067e8, executed_place=PROCESSED_BY_JOIN_EXEC) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_show.cc:7815 #11 0x0000000000746425 in JOIN::prepare_result (this=0x7f1e140067e8, columns_list=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:823 #12 0x00000000006fd211 in JOIN::exec (this=0x7f1e140067e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_executor.cc:116 #13 0x00000000007492d0 in mysql_execute_select (free_join=true, select_lex=0x35a2ca8, thd=0x35a01d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1101 #14 mysql_select (thd=0x35a01d0, tables=0x7f1e14005010, wild_num=1, fields=..., conds=0x7f1e14005d78, order=, group=0x35a2da8, having=0x0, select_options=2684619520, result=0x7f1e140067c0, unit=0x35a2660, select_lex=0x35a2ca8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:1222 #15 0x0000000000749dbb in handle_select (thd=0x35a01d0, result=0x7f1e140067c0, setup_tables_done_option=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_select.cc:111 #16 0x000000000071ecdd in execute_sqlcom_select (thd=0x35a01d0, all_tables=0x7f1e14005010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5305 #17 0x00000000007217b7 in mysql_execute_command (thd=0x35a01d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762 #18 0x0000000000727818 in mysql_parse (thd=0x35a01d0, rawbuf=0x35a2598 "\360R7\001", length=, parser_state=) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477 #19 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x35a01d0, packet=0x35a4161 " SELECT * FROM INFORMATION_SCHEMA . `GLOBAL_TEMPORARY_TABLES` AS table1 WHERE ( table1 . `ENGINE` <> table1 . `SESSION_ID` OR table1 . `DATA_LENGTH` >= '2003-01-07 09:45:33.021131') ", packet_length=182) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374 #20 0x0000000000729a47 in do_command (thd=0x35a01d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049 #21 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 #22 0x00000000006ed727 in handle_one_connection (arg=0x35a01d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526 #23 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x3526e90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855 #24 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #25 0x000000340c4e890d in clone () from /lib64/libc.so.6 (gdb) +set logging off