(gdb) +thread apply all bt Thread 51 (LWP 16852): +bt #0 0x0000003fde20eec3 in pwrite64 () from /lib64/libpthread.so.0 #1 0x000000000098316a in os_file_pwrite (offset=11445760, n=512, buf=0x7f716f096e00, file=8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:2620 #2 os_file_write_func (name=0x2d07418 "./ib_logfile0", file=8, buf=0x7f716f096e00, offset=11445760, n=512) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:3111 #3 0x000000000098625b in os_aio_func (type=11, mode=24, name=0x2d07418 "./ib_logfile0", file=8, buf=0x7f716f096e00, offset=11445760, n=512, message1=0x2d07318, message2=0x2d079a8, space_id=4294967280, trx=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:4717 #4 0x0000000000a8865d in pfs_os_aio_func (src_line=5411, src_file=0xc07418 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc", trx=0x0, space_id=4294967280, message2=0x2d079a8, message1=0x2d07318, n=512, offset=11445760, buf=0x7f716f096e00, file=8, name=0x2d07418 "./ib_logfile0", mode=24, type=11) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/os0file.ic:230 #5 _fil_io (type=11, sync=, space_id=4294967280, zip_size=8, block_offset=, byte_offset=24, len=512, buf=0x7f716f096e00, message=0x2d079a8, trx=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5411 #6 0x000000000096c7f1 in log_group_write_buf (group=0x2d079a8, buf=, len=512, start_lsn=, new_data_offset=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/log/log0log.cc:1380 #7 0x000000000096faf9 in log_write_up_to (lsn=, wait=92, flush_to_disk=1) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/log/log0log.cc:1568 #8 0x0000000000a0e9b7 in trx_flush_log_if_needed (trx=0x7f70cc0783b8, lsn=816726419) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/trx/trx0trx.cc:1207 #9 trx_commit_in_memory (lsn=816726419, trx=0x7f70cc0783b8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/trx/trx0trx.cc:1350 #10 trx_commit_low (trx=0x7f70cc0783b8, mtr=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/trx/trx0trx.cc:1464 #11 0x0000000000a0ef89 in trx_commit (trx=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/trx/trx0trx.cc:1485 #12 0x0000000000a0eff2 in trx_commit_for_mysql (trx=0x7f70cc0783b8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/trx/trx0trx.cc:1713 #13 0x0000000000a7b6f8 in dict_stats_exec_sql (pinfo=, sql=0xc05d78 "PROCEDURE INDEX_STATS_SAVE_UPDATE () IS\nBEGIN\nUPDATE \"mysql/innodb_index_stats\" SET\nlast_update = :last_update,\nstat_value = :stat_value,\nsample_size = :sample_size,\nstat_description = :stat_description\nWHERE\ndatabase_name = :database_name AND\ntable_name = :table_name AND\nindex_name = :index_name AND\nstat_name = :stat_name;\nEND;") at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0stats.cc:293 #14 0x0000000000a7bd96 in dict_stats_save_index_stat (index=0x7f70cc071a60, last_update=1369854997, stat_name=0x7f7162574210 "n_diff_pfx01", stat_value=0, sample_size=0x7f70cc071bf0, stat_description=0x7f7162573e10 "c58") at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0stats.cc:2196 #15 0x0000000000a7c39b in dict_stats_save (table_orig=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0stats.cc:2366 #16 0x0000000000a7f56c in dict_stats_update (table=0x7f714c170988, stats_upd_option=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0stats.cc:2993 #17 0x00000000009c933d in row_truncate_table_for_mysql (table=0x7f714c170988, trx=0x7f70cc027448) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0mysql.cc:3650 #18 0x00000000009427f4 in ha_innobase::truncate (this=0x7f70cc069490) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc:10295 #19 0x0000000000859afc in Sql_cmd_truncate_table::handler_truncate (this=, thd=0x2f0cb10, table_ref=0x7f70cc004dc0, is_tmp_table=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_truncate.cc:235 #20 0x000000000085a218 in Sql_cmd_truncate_table::truncate_table (this=0x7f70cc005328, thd=0x2f0cb10, table_ref=0x7f70cc004dc0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_truncate.cc:467 #21 0x000000000085a30e in Sql_cmd_truncate_table::execute (this=0x7f70cc005328, thd=0x2f0cb10) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_truncate.cc:519 #22 0x00000000006de1e0 in mysql_execute_command (thd=0x2f0cb10) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #23 0x00000000006e1598 in mysql_parse (thd=0x2f0cb10, rawbuf=, length=49344152, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #24 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2f0cb10, packet=0x2f10441 " TRUNCATE `table500_innodb_default_int_autoinc` ", packet_length=48) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #25 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #26 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #27 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e8eff0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #28 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #29 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 50 (LWP 16840): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009886c3 in os_cond_wait (fast_mutex=0x2d0caa0, cond=0x2d0cae0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2d0caa0, reset_sig_count=729) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:610 #3 0x00000000009f53a4 in sync_array_wait_event (arr=0x29436c0, index=2) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0arr.cc:424 #4 0x00000000009f57d1 in rw_lock_s_lock_spin (lock=0x1319460 , pass=, file_name=0xbf2af8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0undo.cc", line=298) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0rw.cc:443 #5 0x00000000009c5633 in rw_lock_s_lock_func (line=298, file_name=0xbf2af8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0undo.cc", pass=0, lock=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/sync0rw.ic:364 #6 pfs_rw_lock_s_lock_func (line=298, file_name=0xbf2af8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0undo.cc", pass=0, lock=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/sync0rw.ic:685 #7 row_mysql_freeze_data_dictionary_func (trx=0x7f70dc007f58, file=0xbf2af8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0undo.cc", line=298) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0mysql.cc:2057 #8 0x00000000009df238 in row_undo (thr=0x7f70dc02a9e0, node=0x7f70dc009c88) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0undo.cc:298 #9 row_undo_step (thr=0x7f70dc02a9e0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0undo.cc:350 #10 0x00000000009a4dd7 in que_thr_step (thr=0x7f70dc02a9e0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/que/que0que.cc:1113 #11 que_run_threads_low (thr=0x7f70dc02a9e0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/que/que0que.cc:1177 #12 que_run_threads (thr=0x7f70dc02a9e0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/que/que0que.cc:1218 #13 0x0000000000a03b8b in trx_rollback_to_savepoint_low (trx=0x7f70dc007f58, savept=0x7f7162679130) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/trx/trx0roll.cc:109 #14 0x0000000000a03e5e in trx_rollback_to_savepoint (trx=0x7f70dc007f58, savept=0x7f7162679130) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/trx/trx0roll.cc:153 #15 0x00000000009c4fe4 in row_mysql_handle_errors (new_err=0x7f716267913c, trx=0x7f70dc007f58, thr=, savept=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0mysql.cc:625 #16 0x00000000009c83c0 in row_insert_for_mysql (mysql_rec=, prebuilt=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0mysql.cc:1324 #17 0x000000000093c108 in ha_innobase::write_row (this=0x7f70dc03ce40, record=0x7f70dc02cb70 "\377\377\373\377") at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc:6931 #18 0x00000000005adb2b in handler::ha_write_row (this=0x7f70dc03ce40, buf=0x7f70dc02cb70 "\377\377\373\377") at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/handler.cc:7414 #19 0x00000000006c1b19 in write_record (thd=0x2eee610, table=0x7f70dc01d250, info=0x7f7162679500, update=0x7f7162679480) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_insert.cc:1905 #20 0x00000000006c9297 in mysql_insert (thd=0x2eee610, table_list=0x7f70dc004d50, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_insert.cc:1054 #21 0x00000000006de0c5 in mysql_execute_command (thd=0x2eee610) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:3634 #22 0x00000000006e1598 in mysql_parse (thd=0x2eee610, rawbuf=, length=49219992, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #23 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2eee610, packet=0x2ef1f41 " INSERT INTO m ( `c56` ) VALUES ( LOAD_FILE('/ssd/randgen/data/earth11k.jpg') )", packet_length=79) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #24 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #25 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #26 0x00000000009195a9 in pfs_spawn_thread (arg=0x2df7be0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #27 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #28 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 49 (LWP 16646): +bt #0 0x0000003fddee14f3 in select () from /lib64/libc.so.6 #1 0x00000000009893bf in os_thread_sleep (tm=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0thread.cc:255 #2 0x0000000000a52031 in page_cleaner_sleep_if_needed (next_loop_time=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/buf/buf0flu.cc:2341 #3 buf_flush_page_cleaner_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/buf/buf0flu.cc:2382 #4 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 48 (LWP 16643): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000988e2b in os_cond_wait_timed (abstime=0x7f71662c1cf0, fast_mutex=0x29412a0, cond=0x29412e0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x29412a0, time_in_usec=, reset_sig_count=1) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:723 #3 0x00000000009ecc44 in srv_monitor_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0srv.cc:1822 #4 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 47 (LWP 16830): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009886c3 in os_cond_wait (fast_mutex=0x2d0caa0, cond=0x2d0cae0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2d0caa0, reset_sig_count=729) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:610 #3 0x00000000009f53a4 in sync_array_wait_event (arr=0x29436c0, index=5) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0arr.cc:424 #4 0x00000000009f5dae in rw_lock_x_lock_func (lock=0x1319460 , pass=0, file_name=0xbdabe8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc", line=9925) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0rw.cc:710 #5 0x00000000009c6f00 in pfs_rw_lock_x_lock_func (line=9925, file_name=0xbdabe8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc", lock=, pass=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/sync0rw.ic:594 #6 row_mysql_lock_data_dictionary_func (trx=0x7f70ec014b28, file=0xbdabe8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc", line=9925) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0mysql.cc:2096 #7 0x0000000000936545 in ha_innobase::create (this=, name=0x7f7169023400 "./transforms/insert_select_16829", form=0x7f71690213b0, create_info=0x7f7169024c80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc:9925 #8 0x00000000005ae2fd in ha_create_table (thd=0x2df0530, path=, db=0x7f70ec004d28 "transforms", table_name=0x7f70ec004d38 "insert_select_16829", create_info=0x7f7169024c80, update_create_info=false, is_temp_table=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/handler.cc:4830 #9 0x000000000077b512 in rea_create_table (thd=0x2df0530, path=0x7f7169023400 "./transforms/insert_select_16829", db=0x7f70ec004d28 "transforms", table_name=0x7f70ec004d38 "insert_select_16829", create_info=0x7f7169024c80, create_fields=..., keys=0, key_info=0x7f70ec006950, file=0x7f70ec008c20, no_ha_table=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/unireg.cc:526 #10 0x000000000072b717 in create_table_impl (thd=0x2df0530, db=0x7f70ec004d28 "transforms", table_name=0x7f70ec004d38 "insert_select_16829", path=0x7f7169023400 "./transforms/insert_select_16829", create_info=0x7f7169024c80, alter_info=0x7f7169024690, internal_tmp_table=false, select_field_count=1, no_ha_table=false, is_trans=0x0, key_info=0x7f7169023610, key_count=0x7f7169023618) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:4841 #11 0x000000000072bd97 in mysql_create_table_no_lock (thd=0x2df0530, db=0x7f70ec004d28 "transforms", table_name=0x7f70ec004d38 "insert_select_16829", create_info=0x7f7169024c80, alter_info=0x7f7169024690, select_field_count=1, is_trans=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:4953 #12 0x00000000006c0c74 in create_table_from_items (thd=0x2df0530, create_info=0x7f7169024c80, create_table=0x7f70ec004d90, alter_info=0x7f7169024690, items=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_insert.cc:4008 #13 0x00000000006c0de2 in select_create::prepare (this=, values=..., u=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_insert.cc:4076 #14 0x00000000006f874a in JOIN::prepare (this=0x7f70ec006360, tables_init=, wild_num=, conds_init=, og_num=3959449256, order_init=, group_init=0x0, having_init=0x0, select_lex_arg=0x2df2fc8, unit_arg=0x2df2980) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_resolver.cc:335 #15 0x00000000006ff936 in mysql_prepare_select (free_join=, select_lex=0x2df2fc8, unit=0x2df2980, result=0x7f70ec0061e8, select_options=2953054976, having=0x0, group=0x0, order=0x0, og_num=, conds=0x0, fields=..., wild_num=0, tables=0x7f70ec005568, thd=0x2df0530) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:1055 #16 mysql_select (thd=0x2df0530, tables=0x7f70ec005568, wild_num=0, fields=..., conds=0x0, order=, group=0x2df30c8, having=0x0, select_options=2953054976, result=0x7f70ec0061e8, unit=0x2df2980, select_lex=0x2df2fc8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:1178 #17 0x00000000006ffb77 in handle_select (thd=0x2df0530, result=0x7f70ec0061e8, setup_tables_done_option=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:111 #18 0x00000000006e09a6 in mysql_execute_command (thd=0x2df0530) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:3232 #19 0x00000000006e1598 in mysql_parse (thd=0x2df0530, rawbuf=, length=48179384, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #20 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2df0530, packet=0x2ed3a41 "CREATE TABLE transforms.insert_select_16829 SELECT COUNT( * ) FROM INFORMATION_SCHEMA .INNODB_CHANGED_PAGES ", packet_length=113) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #21 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #22 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #23 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e24a10) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #24 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #25 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 46 (LWP 16644): +bt #0 0x0000003fddee14f3 in select () from /lib64/libc.so.6 #1 0x00000000009893bf in os_thread_sleep (tm=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0thread.cc:255 #2 0x00000000009eef13 in srv_master_sleep () at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0srv.cc:2803 #3 srv_master_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0srv.cc:2847 #4 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 45 (LWP 16822): +bt #0 0x0000003fde20e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003fde2093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003fde209326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000696a18 in inline_mysql_mutex_lock (src_line=115, src_file=0xb63520 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h", that=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:688 #4 lock (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h:115 #5 close_thread_table (thd=0x2db43d0, table_ptr=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:1518 #6 0x0000000000696de3 in close_open_tables (thd=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:1241 #7 close_thread_tables (thd=0x2db43d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:1467 #8 0x00000000006dc5d8 in mysql_execute_command (thd=0x2db43d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5201 #9 0x00000000006e1598 in mysql_parse (thd=0x2db43d0, rawbuf=, length=47933272, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #10 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2db43d0, packet=0x2de4be1 "INSERT INTO trigger116823 VALUES (1)", packet_length=36) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #11 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #12 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #13 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e186a0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #14 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #15 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 44 (LWP 16851): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000654ffe in inline_mysql_cond_timedwait (src_line=1306, src_file=0xb5fef8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc", abstime=0x7f71625b3f90, mutex=0x2f05310, that=0x2f05348) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2f05310, owner=0x2f051d0, abs_timeout=0x7f71625b3f90, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:1306 #3 0x0000000000657119 in MDL_context::acquire_lock (this=0x2f05310, mdl_request=0x7f70c8006098, lock_wait_timeout=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2245 #4 0x000000000065752b in MDL_context::acquire_locks (this=0x2f05310, mdl_requests=, lock_wait_timeout=31536000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2339 #5 0x0000000000695e16 in lock_table_names (thd=0x2f051d0, tables_start=0x7f70c8005cf8, tables_end=, lock_wait_timeout=, flags=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4824 #6 0x0000000000699800 in open_tables (thd=0x2f051d0, start=0x7f71625b44f8, counter=0x7f71625b5e78, flags=0, prelocking_strategy=0x7f71625b5e60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5037 #7 0x000000000072eeac in mysql_alter_table (thd=0x2f051d0, new_db=0x7f70c8006258 "test", new_name=0x0, create_info=0x7f71625b6440, table_list=0x7f70c8005cf8, alter_info=0x7f71625b6520, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7856 #8 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2f051d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #9 0x00000000006de1e0 in mysql_execute_command (thd=0x2f051d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #10 0x00000000006e1598 in mysql_parse (thd=0x2f051d0, rawbuf=, length=49313112, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2f051d0, packet=0x2f08b01 "ALTER TABLE table100_innodb_compressed ENABLE KEYS; ALTER TABLE table100_innodb_compressed_int ENABLE KEYS; ALTER TABLE table100_innodb_compressed_int_autoinc ENABLE KEYS; ALTER TABLE table100_innodb_default ENABLE KEYS; ALTER TABLE table100_innodb_default_int ENABLE KEYS; ALTER TABLE table100_innodb_default_int_autoinc ENABLE KEYS; ALTER TABLE table100_innodb_dynamic ENABLE KEYS; ALTER TABLE table100_innodb_dynamic_int ENABLE KEYS; ALTER TABLE table100_innodb_dynamic_int_autoinc ENABLE KEYS; ALTER TABLE table500_innodb_compressed ENABLE KEYS; ALTER TABLE table500_innodb_compressed_int ENABLE KEYS; ALTER TABLE table500_innodb_compressed_int_autoinc ENABLE KEYS; ALTER TABLE table500_innodb_default ENABLE KEYS; ALTER TABLE table500_innodb_default_int ENABLE KEYS; ALTER TABLE table500_innodb_default_int_autoinc ENABLE KEYS; ALTER TABLE table500_innodb_dynamic ENABLE KEYS; ALTER TABLE table500_innodb_dynamic_int ENABLE KEYS; ALTER TABLE table500_innodb_dynamic_int_autoinc ENABLE KEYS; ALTER TABLE view_table100_innodb_compressed ENABLE KEYS; ALTER TABLE view_table100_innodb_compressed_int ENABLE KEYS; ALTER TABLE view_table100_innodb_compressed_int_autoinc ENABLE KEYS; ALTER TABLE view_table100_innodb_default ENABLE KEYS; ALTER TABLE view_table100_innodb_default_int ENABLE KEYS; ALTER TABLE view_table100_innodb_default_int_autoinc ENABLE KEYS; ALTER TABLE view_table100_innodb_dynamic ENABLE KEYS; ALTER TABLE view_table100_innodb_dynamic_int ENABLE KEYS; ALTER TABLE view_table100_innodb_dynamic_int_autoinc ENABLE KEYS; ALTER TABLE view_table500_innodb_compressed ENABLE KEYS; ALTER TABLE view_table500_innodb_compressed_int ENABLE KEYS; ALTER TABLE view_table500_innodb_compressed_int_autoinc ENABLE KEYS; ALTER TABLE view_table500_innodb_default ENABLE KEYS; ALTER TABLE view_table500_innodb_default_int ENABLE KEYS; ALTER TABLE view_table500_innodb_default_int_autoinc ENABLE KEYS; ALTER TABLE view_table500_innodb_dynamic ENABLE KEYS; ALTER TABLE view_table500_innodb_dynamic_int ENABLE KEYS; ALTER TABLE view_table500_innodb_dynamic_int_autoinc ENABLE KEYS", packet_length=2080) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e5df00) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 43 (LWP 16846): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009886c3 in os_cond_wait (fast_mutex=0x2d0caa0, cond=0x2d0cae0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2d0caa0, reset_sig_count=729) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:610 #3 0x00000000009f53a4 in sync_array_wait_event (arr=0x29436c0, index=6) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0arr.cc:424 #4 0x00000000009f5dae in rw_lock_x_lock_func (lock=0x1319460 , pass=0, file_name=0xbdabe8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc", line=9925) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0rw.cc:710 #5 0x00000000009c6f00 in pfs_rw_lock_x_lock_func (line=9925, file_name=0xbdabe8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc", lock=, pass=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/sync0rw.ic:594 #6 row_mysql_lock_data_dictionary_func (trx=0x7f70d401f838, file=0xbdabe8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc", line=9925) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0mysql.cc:2096 #7 0x0000000000936545 in ha_innobase::create (this=, name=0x7f71625f6400 "./transforms/insert_select_16848", form=0x7f71625f43b0, create_info=0x7f71625f7c80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc:9925 #8 0x00000000005ae2fd in ha_create_table (thd=0x2efd890, path=, db=0x7f70d4004d80 "transforms", table_name=0x7f70d4004d90 "insert_select_16848", create_info=0x7f71625f7c80, update_create_info=false, is_temp_table=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/handler.cc:4830 #9 0x000000000077b512 in rea_create_table (thd=0x2efd890, path=0x7f71625f6400 "./transforms/insert_select_16848", db=0x7f70d4004d80 "transforms", table_name=0x7f70d4004d90 "insert_select_16848", create_info=0x7f71625f7c80, create_fields=..., keys=0, key_info=0x7f70d401c1a0, file=0x7f70d401a488, no_ha_table=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/unireg.cc:526 #10 0x000000000072b717 in create_table_impl (thd=0x2efd890, db=0x7f70d4004d80 "transforms", table_name=0x7f70d4004d90 "insert_select_16848", path=0x7f71625f6400 "./transforms/insert_select_16848", create_info=0x7f71625f7c80, alter_info=0x7f71625f7690, internal_tmp_table=false, select_field_count=2, no_ha_table=false, is_trans=0x0, key_info=0x7f71625f6610, key_count=0x7f71625f6618) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:4841 #11 0x000000000072bd97 in mysql_create_table_no_lock (thd=0x2efd890, db=0x7f70d4004d80 "transforms", table_name=0x7f70d4004d90 "insert_select_16848", create_info=0x7f71625f7c80, alter_info=0x7f71625f7690, select_field_count=2, is_trans=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:4953 #12 0x00000000006c0c74 in create_table_from_items (thd=0x2efd890, create_info=0x7f71625f7c80, create_table=0x7f70d4004de8, alter_info=0x7f71625f7690, items=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_insert.cc:4008 #13 0x00000000006c0de2 in select_create::prepare (this=, values=..., u=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_insert.cc:4076 #14 0x00000000006f874a in JOIN::prepare (this=0x7f70d4006410, tables_init=, wild_num=, conds_init=, og_num=3556796248, order_init=, group_init=0x0, having_init=0x0, select_lex_arg=0x2f00328, unit_arg=0x2effce0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_resolver.cc:335 #15 0x00000000006ff936 in mysql_prepare_select (free_join=, select_lex=0x2f00328, unit=0x2effce0, result=0x7f70d4006298, select_options=2953054976, having=0x0, group=0x0, order=0x0, og_num=, conds=0x0, fields=..., wild_num=0, tables=0x7f70d4005618, thd=0x2efd890) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:1055 #16 mysql_select (thd=0x2efd890, tables=0x7f70d4005618, wild_num=0, fields=..., conds=0x0, order=, group=0x2f00428, having=0x0, select_options=2953054976, result=0x7f70d4006298, unit=0x2effce0, select_lex=0x2f00328) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:1178 #17 0x00000000006ffb77 in handle_select (thd=0x2efd890, result=0x7f70d4006298, setup_tables_done_option=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:111 #18 0x00000000006e09a6 in mysql_execute_command (thd=0x2efd890) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:3232 #19 0x00000000006e1598 in mysql_parse (thd=0x2efd890, rawbuf=, length=49282072, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #20 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2efd890, packet=0x2f011c1 "CREATE TABLE transforms.insert_select_16848 SELECT start_lsn , space_id page_id FROM INFORMATION_SCHEMA .INNODB_CHANGED_PAGES ", packet_length=131) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #21 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #22 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #23 0x00000000009195a9 in pfs_spawn_thread (arg=0x2df7be0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #24 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #25 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 42 (LWP 17003): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000059a5ef in inline_mysql_cond_wait (src_line=2652, mutex=0x12b9be0 , that=0x12bbb40 , src_file=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1162 #2 block_until_new_connection () at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mysqld.cc:2652 #3 one_thread_per_connection_end (thd=, block_pthread=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mysqld.cc:2746 #4 0x00000000006b001e in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1629 #5 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #6 0x00000000009195a9 in pfs_spawn_thread (arg=0x2d83f10) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #7 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #8 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 41 (LWP 16650): +bt #0 0x0000003fde20f2a5 in sigwait () from /lib64/libpthread.so.0 #1 0x000000000059959b in signal_hand (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mysqld.cc:3158 #2 0x00000000009195a9 in pfs_spawn_thread (arg=0x2d6ac30) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #3 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #4 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 40 (LWP 16651): +bt #0 0x0000003fddedf253 in poll () from /lib64/libc.so.6 #1 0x0000000000b44cef in vio_io_wait (vio=, event=, timeout=28800000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/vio/viosocket.c:820 #2 0x0000000000b44de3 in vio_socket_io_wait (vio=, event=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/vio/viosocket.c:68 #3 0x0000000000b45418 in vio_read (vio=0x2eaf140, buf=0x2eaf330 "\a", size=4) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/vio/viosocket.c:123 #4 0x00000000006584e3 in net_read_raw_loop (net=0x2dd2800, count=4) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/net_serv.cc:663 #5 0x0000000000658d7b in net_read_packet_header (net=0x2dd2800) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/net_serv.cc:745 #6 net_read_packet (net=, complen=0x7f7169331cb8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/net_serv.cc:810 #7 0x0000000000658fec in my_net_read (net=0x2dd2800) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/net_serv.cc:888 #8 0x00000000006e321d in do_command (thd=0x2dd2590) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:985 #9 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #10 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #11 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e9a150) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #12 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #13 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 39 (LWP 16816): +bt #0 0x0000003fde20e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003fde2093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003fde209326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x000000000077392f in inline_mysql_mutex_lock (src_line=115, src_file=0xb63520 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h", that=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:688 #4 lock (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h:115 #5 Table_cache_manager::lock_all_and_tdc (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.cc:282 #6 0x000000000069195d in tdc_remove_table (thd=0x2ea9130, remove_type=TDC_RT_REMOVE_ALL, db=, table_name=0x7f70fc004d18 "view_16818_merge", has_lock=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:9276 #7 0x000000000074e3a9 in mysql_drop_view (thd=0x2ea9130, views=, drop_mode=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_view.cc:1865 #8 0x00000000006dd53d in mysql_execute_command (thd=0x2ea9130) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:4991 #9 0x00000000006e1598 in mysql_parse (thd=0x2ea9130, rawbuf=, length=48936120, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #10 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2ea9130, packet=0x2d7cf11 "DROP VIEW transforms.view_16818_merge , transforms.view_16818_temptable", packet_length=71) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #11 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #12 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #13 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e71bd0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #14 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #15 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 38 (LWP 16833): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009886c3 in os_cond_wait (fast_mutex=0x2d0c890, cond=0x2d0c8d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2d0c890, reset_sig_count=1918) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:610 #3 0x00000000009f53a4 in sync_array_wait_event (arr=0x29436c0, index=4) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0arr.cc:424 #4 0x00000000009f6808 in mutex_spin_wait (mutex=0x2d0c7d8, file_name=0xc034a8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0dict.cc", line=478) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0sync.cc:583 #5 0x0000000000a63ee6 in mutex_enter_func (line=478, mutex=0x2d0c7d8, file_name=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/sync0sync.ic:220 #6 pfs_mutex_enter_func (mutex=0x2d0c7d8, line=478, file_name=0xc034a8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0dict.cc") at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/sync0sync.ic:251 #7 0x0000000000a64061 in dict_table_close (table=0x7f714c1a8408, dict_locked=0, try_drop=1) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0dict.cc:478 #8 0x00000000009c6955 in row_prebuilt_free (prebuilt=0x7f70e40550e8, dict_locked=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0mysql.cc:893 #9 0x0000000000939bec in ha_innobase::close (this=0x7f70e4053000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc:5393 #10 0x000000000076ad99 in closefrm (table=0x7f70e401cb40, free_share=true) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table.cc:2422 #11 0x000000000068feb6 in intern_close_table (table=0x7f70e401cb40) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:821 #12 0x00000000006965fb in close_thread_table (thd=, table_ptr=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:1525 #13 0x0000000000696de3 in close_open_tables (thd=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:1241 #14 close_thread_tables (thd=0x2edf390) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:1467 #15 0x00000000006dc5d8 in mysql_execute_command (thd=0x2edf390) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5201 #16 0x00000000006e1598 in mysql_parse (thd=0x2edf390, rawbuf=, length=49157912, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #17 0x00000000006e2b1f in dispatch_command (command=, thd=0x2edf390, packet=0x479
, packet_length=3825224656) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1445 #18 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #19 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #20 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e5df00) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #21 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #22 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 37 (LWP 16837): +bt #0 0x0000003fde20e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003fde2093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003fde209326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x000000000077392f in inline_mysql_mutex_lock (src_line=115, src_file=0xb63520 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h", that=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:688 #4 lock (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h:115 #5 Table_cache_manager::lock_all_and_tdc (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.cc:282 #6 0x000000000069195d in tdc_remove_table (thd=0x2ee6cd0, remove_type=TDC_RT_REMOVE_ALL, db=, table_name=0x7f70d8004d08 "q", has_lock=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:9276 #7 0x000000000074f63d in mysql_create_view (thd=, views=0x7f70d8004d40, mode=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_view.cc:690 #8 0x00000000006dd55f in mysql_execute_command (thd=0x2ee6cd0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:4983 #9 0x00000000006e1598 in mysql_parse (thd=0x2ee6cd0, rawbuf=, length=49188952, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #10 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2ee6cd0, packet=0x2eea601 " CREATE VIEW q AS SELECT * FROM `table100_innodb_dynamic_int_autoinc` ", packet_length=70) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #11 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #12 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #13 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e5df00) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #14 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #15 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 36 (LWP 16832): +bt #0 0x0000003fde20e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003fde2093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003fde209326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x000000000077392f in inline_mysql_mutex_lock (src_line=115, src_file=0xb63520 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h", that=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:688 #4 lock (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h:115 #5 Table_cache_manager::lock_all_and_tdc (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.cc:282 #6 0x000000000069195d in tdc_remove_table (thd=0x2ed7a50, remove_type=TDC_RT_REMOVE_ALL, db=, table_name=0x7f70e0004db8 "view_16831_temptable", has_lock=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:9276 #7 0x000000000074f63d in mysql_create_view (thd=, views=0x7f70e0004e10, mode=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_view.cc:690 #8 0x00000000006dd55f in mysql_execute_command (thd=0x2ed7a50) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:4983 #9 0x00000000006e1598 in mysql_parse (thd=0x2ed7a50, rawbuf=, length=49126872, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #10 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2ed7a50, packet=0x2edb381 "CREATE OR REPLACE ALGORITHM=TEMPTABLE VIEW transforms.view_16831_temptable AS SELECT start_lsn, end_lsn, space_id, page_id FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES LIMIT 8", packet_length=175) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #11 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #12 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #13 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e3a160) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #14 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #15 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 35 (LWP 16649): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000988e2b in os_cond_wait_timed (abstime=0x7f71630bcc90, fast_mutex=0x2d490f0, cond=0x2d49130) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x2d490f0, time_in_usec=, reset_sig_count=1) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:723 #3 0x0000000000a19832 in ib_wqueue_timedwait (wq=0x2d48f68, wait_in_usecs=5000000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/ut/ut0wqueue.cc:154 #4 0x0000000000aad483 in fts_optimize_thread (arg=0x2d48f68) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fts/fts0opt.cc:2932 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 34 (LWP 16655): +bt #0 0x0000003fddedf253 in poll () from /lib64/libc.so.6 #1 0x0000000000b44cef in vio_io_wait (vio=, event=, timeout=28800000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/vio/viosocket.c:820 #2 0x0000000000b44de3 in vio_socket_io_wait (vio=, event=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/vio/viosocket.c:68 #3 0x0000000000b45418 in vio_read (vio=0x2eb7510, buf=0x2eb7700 "(", size=4) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/vio/viosocket.c:123 #4 0x00000000006584e3 in net_read_raw_loop (net=0x2eb3700, count=4) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/net_serv.cc:663 #5 0x0000000000658d7b in net_read_packet_header (net=0x2eb3700) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/net_serv.cc:745 #6 net_read_packet (net=, complen=0x7f71692f0cb8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/net_serv.cc:810 #7 0x0000000000658fec in my_net_read (net=0x2eb3700) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/net_serv.cc:888 #8 0x00000000006e321d in do_command (thd=0x2eb3490) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:985 #9 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #10 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #11 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e9a8c0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #12 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #13 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 33 (LWP 16630): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x2967190) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=1, message1=0x7f716ed7bd98, message2=0x7f716ed7bd90, type=0x7f716ed7bd88, space_id=0x7f716ed7bd80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=1) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 32 (LWP 16638): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x29826d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=9, message1=0x7f7169d73d98, message2=0x7f7169d73d90, type=0x7f7169d73d88, space_id=0x7f7169d73d80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=9) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 31 (LWP 16637): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x29826d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=8, message1=0x7f716a774d98, message2=0x7f716a774d90, type=0x7f716a774d88, space_id=0x7f716a774d80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 30 (LWP 16648): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000988e2b in os_cond_wait_timed (abstime=0x7f7163abdd00, fast_mutex=0x2d0ab20, cond=0x2d0ab60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x2d0ab20, time_in_usec=, reset_sig_count=71) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:723 #3 0x0000000000a80617 in dict_stats_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0stats_bg.cc:349 #4 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 29 (LWP 16789): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000654ffe in inline_mysql_cond_timedwait (src_line=1306, src_file=0xb5fef8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc", abstime=0x7f712bffaf90, mutex=0x2ebb9a0, that=0x2ebb9d8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2ebb9a0, owner=0x2ebb860, abs_timeout=0x7f712bffaf90, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:1306 #3 0x0000000000657119 in MDL_context::acquire_lock (this=0x2ebb9a0, mdl_request=0x7f7124007fb0, lock_wait_timeout=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2245 #4 0x000000000065752b in MDL_context::acquire_locks (this=0x2ebb9a0, mdl_requests=, lock_wait_timeout=31536000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2339 #5 0x0000000000695e16 in lock_table_names (thd=0x2ebb860, tables_start=0x7f7124007c10, tables_end=, lock_wait_timeout=, flags=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4824 #6 0x0000000000699800 in open_tables (thd=0x2ebb860, start=0x7f712bffb4f8, counter=0x7f712bffce78, flags=0, prelocking_strategy=0x7f712bffce60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5037 #7 0x000000000072eeac in mysql_alter_table (thd=0x2ebb860, new_db=0x7f7124019130 "test", new_name=0x0, create_info=0x7f712bffd440, table_list=0x7f7124007c10, alter_info=0x7f712bffd520, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7856 #8 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2ebb860) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #9 0x00000000006de1e0 in mysql_execute_command (thd=0x2ebb860) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #10 0x00000000006e1598 in mysql_parse (thd=0x2ebb860, rawbuf=, length=49011688, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2b1f in dispatch_command (command=, thd=0x2ebb860, packet=0x532
, packet_length=603999136) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1445 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e9a150) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 28 (LWP 16639): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009886c3 in os_cond_wait (fast_mutex=0x29413c0, cond=0x2941400) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x29413c0, reset_sig_count=46) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:610 #3 0x00000000009e943c in srv_redo_log_follow_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0srv.cc:2209 #4 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 27 (LWP 16635): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x29826d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=6, message1=0x7f716bb76d98, message2=0x7f716bb76d90, type=0x7f716bb76d88, space_id=0x7f716bb76d80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=6) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 26 (LWP 16627): +bt #0 0x0000003fddedf253 in poll () from /lib64/libc.so.6 #1 0x000000000059ab7a in handle_connections_sockets () at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mysqld.cc:6311 #2 0x00000000005a2831 in mysqld_main (argc=52, argv=0x27be0e8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mysqld.cc:5726 #3 0x0000003fdde1ecdd in __libc_start_main () from /lib64/libc.so.6 #4 0x0000000000593a59 in _start () Thread 25 (LWP 16641): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000988e2b in os_cond_wait_timed (abstime=0x7f71676c3d00, fast_mutex=0x2d05890, cond=0x2d058d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x2d05890, time_in_usec=, reset_sig_count=51) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:723 #3 0x0000000000969e31 in lock_wait_timeout_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/lock/lock0wait.cc:502 #4 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 24 (LWP 16647): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009886c3 in os_cond_wait (fast_mutex=0x2941330, cond=0x2941370) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2941330, reset_sig_count=1) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:610 #3 0x0000000000a4de7c in buf_dump_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/buf/buf0dump.cc:594 #4 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 23 (LWP 16645): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009886c3 in os_cond_wait (fast_mutex=0x2d0caa0, cond=0x2d0cae0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2d0caa0, reset_sig_count=729) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:610 #3 0x00000000009f53a4 in sync_array_wait_event (arr=0x29436c0, index=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0arr.cc:424 #4 0x00000000009f57d1 in rw_lock_s_lock_spin (lock=0x1319460 , pass=, file_name=0xbf2060 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0purge.cc", line=720) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0rw.cc:443 #5 0x00000000009d45b6 in pfs_rw_lock_s_lock_func (line=720, lock=, pass=, file_name=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/sync0rw.ic:685 #6 row_purge_parse_undo_rec (thr=0x2d3d070, updated_extern=0x7f71658c0b6f, undo_rec=0x7f71480061a0 "\v~\016\004\001", node=0x2d3e708) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0purge.cc:720 #7 row_purge (thr=0x2d3d070, undo_rec=0x7f71480061a0 "\v~\016\004\001", node=0x2d3e708) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0purge.cc:858 #8 row_purge_step (thr=0x2d3d070) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0purge.cc:941 #9 0x00000000009a4df6 in que_thr_step (thr=0x2d3d070) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/que/que0que.cc:1115 #10 que_run_threads_low (thr=0x2d3d070) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/que/que0que.cc:1177 #11 que_run_threads (thr=0x2d3d070) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/que/que0que.cc:1218 #12 0x00000000009fd15b in trx_purge (n_purge_threads=1, batch_size=300, truncate=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/trx/trx0purge.cc:1251 #13 0x00000000009edaff in srv_do_purge (n_total_purged=, n_threads=1) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0srv.cc:3091 #14 srv_purge_coordinator_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0srv.cc:3268 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 22 (LWP 16632): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x2939e50) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=3, message1=0x7f716d979d98, message2=0x7f716d979d90, type=0x7f716d979d88, space_id=0x7f716d979d80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=3) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 21 (LWP 16629): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x2974c30) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=0, message1=0x7f717fd6cd98, message2=0x7f717fd6cd90, type=0x7f717fd6cd88, space_id=0x7f717fd6cd80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 20 (LWP 16862): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009886c3 in os_cond_wait (fast_mutex=0x2d0caa0, cond=0x2d0cae0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2d0caa0, reset_sig_count=729) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:610 #3 0x00000000009f53a4 in sync_array_wait_event (arr=0x29436c0, index=3) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0arr.cc:424 #4 0x00000000009f5dae in rw_lock_x_lock_func (lock=0x1319460 , pass=0, file_name=0xbe1188 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/handler0alter.cc", line=2658) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0rw.cc:710 #5 0x00000000009c6f00 in pfs_rw_lock_x_lock_func (line=2658, file_name=0xbe1188 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/handler0alter.cc", lock=, pass=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/sync0rw.ic:594 #6 row_mysql_lock_data_dictionary_func (trx=0x7f70c40429b8, file=0xbe1188 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/handler0alter.cc", line=2658) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/row/row0mysql.cc:2096 #7 0x0000000000947725 in prepare_inplace_alter_table_dict (ha_alter_info=0x7f71624f2db0, altered_table=0x7f70c402ac60, old_table=0x7f70c4036cf0, table_name=0x7f70c40442dc "t1", flags=1, flags2=16, fts_doc_id_col=18446744073709551615, add_fts_doc_id=false, add_fts_doc_id_idx=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/handler0alter.cc:2658 #8 0x000000000094a3ff in ha_innobase::prepare_inplace_alter_table (this=, altered_table=, ha_alter_info=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/handler0alter.cc:3821 #9 0x000000000072ea85 in mysql_inplace_alter_table (thd=0x2f1bd90, table_list=0x7f70c4004f38, table=0x7f70c4036cf0, altered_table=0x7f70c402ac60, ha_alter_info=0x7f71624f2db0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f71624f2b20, alter_ctx=0x7f71624f1500) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:6469 #10 0x0000000000730ee7 in mysql_alter_table (thd=, new_db=0x7f71624f3520 "", new_name=, create_info=, table_list=0x7f70c4004f38, alter_info=, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:8369 #11 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2f1bd90) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #12 0x00000000006de1e0 in mysql_execute_command (thd=0x2f1bd90) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #13 0x00000000006e1598 in mysql_parse (thd=0x2f1bd90, rawbuf=, length=49406232, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #14 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2f1bd90, packet=0x2f1f6c1 "ALTER TABLE query116787 . `t1` DROP COLUMN `c7`", packet_length=47) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #15 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #16 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #17 0x00000000009195a9 in pfs_spawn_thread (arg=0x2d83f10) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #18 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #19 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 19 (LWP 16634): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x2939e50) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=5, message1=0x7f716c577d98, message2=0x7f716c577d90, type=0x7f716c577d88, space_id=0x7f716c577d80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=5) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 18 (LWP 16866): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000059a5ef in inline_mysql_cond_wait (src_line=2652, mutex=0x12b9be0 , that=0x12bbb40 , src_file=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1162 #2 block_until_new_connection () at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mysqld.cc:2652 #3 one_thread_per_connection_end (thd=, block_pthread=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mysqld.cc:2746 #4 0x00000000006b001e in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1629 #5 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #6 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e5df00) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #7 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #8 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 17 (LWP 16642): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000988e2b in os_cond_wait_timed (abstime=0x7f7166cc2cc0, fast_mutex=0x2941210, cond=0x2941250) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x2941210, time_in_usec=, reset_sig_count=1) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:723 #3 0x00000000009ea976 in srv_error_monitor_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0srv.cc:2084 #4 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 16 (LWP 16855): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000654ffe in inline_mysql_cond_timedwait (src_line=1306, src_file=0xb5fef8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc", abstime=0x7f7162531f90, mutex=0x2f14590, that=0x2f145c8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2f14590, owner=0x2f14450, abs_timeout=0x7f7162531f90, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:1306 #3 0x0000000000657119 in MDL_context::acquire_lock (this=0x2f14590, mdl_request=0x7f70c00277d0, lock_wait_timeout=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2245 #4 0x000000000065752b in MDL_context::acquire_locks (this=0x2f14590, mdl_requests=, lock_wait_timeout=31536000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2339 #5 0x0000000000695e16 in lock_table_names (thd=0x2f14450, tables_start=0x7f70c0027430, tables_end=, lock_wait_timeout=, flags=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4824 #6 0x0000000000699800 in open_tables (thd=0x2f14450, start=0x7f71625324f8, counter=0x7f7162533e78, flags=0, prelocking_strategy=0x7f7162533e60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5037 #7 0x000000000072eeac in mysql_alter_table (thd=0x2f14450, new_db=0x7f70c0038f10 "test", new_name=0x0, create_info=0x7f7162534440, table_list=0x7f70c0027430, alter_info=0x7f7162534520, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7856 #8 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2f14450) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #9 0x00000000006de1e0 in mysql_execute_command (thd=0x2f14450) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #10 0x00000000006e1598 in mysql_parse (thd=0x2f14450, rawbuf=, length=49375192, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2b1f in dispatch_command (command=, thd=0x2f14450, packet=0x532
, packet_length=3221244880) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1445 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e5df00) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 15 (LWP 16825): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000654ffe in inline_mysql_cond_timedwait (src_line=1306, src_file=0xb5fef8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc", abstime=0x7f7169062f90, mutex=0x2de8d30, that=0x2de8d68) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2de8d30, owner=0x2de8bf0, abs_timeout=0x7f7169062f90, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:1306 #3 0x0000000000657119 in MDL_context::acquire_lock (this=0x2de8d30, mdl_request=0x7f70e8051af0, lock_wait_timeout=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2245 #4 0x000000000065752b in MDL_context::acquire_locks (this=0x2de8d30, mdl_requests=, lock_wait_timeout=31536000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2339 #5 0x0000000000695e16 in lock_table_names (thd=0x2de8bf0, tables_start=0x7f70e8051750, tables_end=, lock_wait_timeout=, flags=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4824 #6 0x0000000000699800 in open_tables (thd=0x2de8bf0, start=0x7f71690634f8, counter=0x7f7169064e78, flags=0, prelocking_strategy=0x7f7169064e60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5037 #7 0x000000000072eeac in mysql_alter_table (thd=0x2de8bf0, new_db=0x7f70e80443b0 "test", new_name=0x0, create_info=0x7f7169065440, table_list=0x7f70e8051750, alter_info=0x7f7169065520, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7856 #8 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2de8bf0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #9 0x00000000006de1e0 in mysql_execute_command (thd=0x2de8bf0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #10 0x00000000006e1598 in mysql_parse (thd=0x2de8bf0, rawbuf=, length=48148344, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2b1f in dispatch_command (command=, thd=0x2de8bf0, packet=0x532
, packet_length=3892333136) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1445 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e186a0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 14 (LWP 16844): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000654ffe in inline_mysql_cond_timedwait (src_line=1306, src_file=0xb5fef8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc", abstime=0x7f7162635f90, mutex=0x2ef6090, that=0x2ef60c8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2ef6090, owner=0x2ef5f50, abs_timeout=0x7f7162635f90, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:1306 #3 0x0000000000657119 in MDL_context::acquire_lock (this=0x2ef6090, mdl_request=0x7f70d00184f0, lock_wait_timeout=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2245 #4 0x000000000065752b in MDL_context::acquire_locks (this=0x2ef6090, mdl_requests=, lock_wait_timeout=31536000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2339 #5 0x0000000000695e16 in lock_table_names (thd=0x2ef5f50, tables_start=0x7f70d0018150, tables_end=, lock_wait_timeout=, flags=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4824 #6 0x0000000000699800 in open_tables (thd=0x2ef5f50, start=0x7f71626364f8, counter=0x7f7162637e78, flags=0, prelocking_strategy=0x7f7162637e60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5037 #7 0x000000000072eeac in mysql_alter_table (thd=0x2ef5f50, new_db=0x7f70d0050050 "test", new_name=0x0, create_info=0x7f7162638440, table_list=0x7f70d0018150, alter_info=0x7f7162638520, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7856 #8 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2ef5f50) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #9 0x00000000006de1e0 in mysql_execute_command (thd=0x2ef5f50) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #10 0x00000000006e1598 in mysql_parse (thd=0x2ef5f50, rawbuf=, length=49251032, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2b1f in dispatch_command (command=, thd=0x2ef5f50, packet=0x532
, packet_length=3489680288) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1445 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e5df00) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 13 (LWP 16801): +bt #0 0x0000003fde20e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003fde2093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003fde209326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000697ac8 in inline_mysql_mutex_lock (src_line=115, src_file=0xb63520 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h", that=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:688 #4 lock (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h:115 #5 open_table (thd=0x2dc8d90, table_list=0x7f7108004e00, ot_ctx=0x7f716926d530) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:2859 #6 0x0000000000699de2 in open_and_process_table (ot_ctx=0x7f716926d530, has_prelocking_list=false, prelocking_strategy=0x7f716926d5f0, flags=0, counter=0x2dcb1d0, tables=0x7f7108004e00, lex=0x2dcb118, thd=0x2dc8d90) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4567 #7 open_tables (thd=0x2dc8d90, start=0x7f716926d5d8, counter=0x2dcb1d0, flags=0, prelocking_strategy=0x7f716926d5f0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5069 #8 0x0000000000699eff in open_normal_and_derived_tables (thd=, tables=0x7f7108004e00, flags=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5768 #9 0x00000000006de006 in mysql_execute_command (thd=0x2dc8d90) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:3692 #10 0x00000000006e1598 in mysql_parse (thd=0x2dc8d90, rawbuf=, length=48017688, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2dc8d90, packet=0x2e2d6b1 "REPLACE INTO transforms.insert_select_16803 SELECT start_lsn, end_lsn, space_id, page_id FROM INFORMATION_SCHEMA.INNODB_CHANGED_PAGES LIMIT 2", packet_length=141) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e71bd0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 12 (LWP 16631): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x2939e50) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=2, message1=0x7f716e37ad98, message2=0x7f716e37ad90, type=0x7f716e37ad88, space_id=0x7f716e37ad80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=2) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 11 (LWP 16636): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x29826d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=7, message1=0x7f716b175d98, message2=0x7f716b175d90, type=0x7f716b175d88, space_id=0x7f716b175d80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=7) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 10 (LWP 16810): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000654ffe in inline_mysql_cond_timedwait (src_line=1306, src_file=0xb5fef8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc", abstime=0x7f71691a7f90, mutex=0x2dd87a0, that=0x2dd87d8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2dd87a0, owner=0x2dd8660, abs_timeout=0x7f71691a7f90, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:1306 #3 0x0000000000657119 in MDL_context::acquire_lock (this=0x2dd87a0, mdl_request=0x7f7104017750, lock_wait_timeout=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2245 #4 0x000000000065752b in MDL_context::acquire_locks (this=0x2dd87a0, mdl_requests=, lock_wait_timeout=31536000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2339 #5 0x0000000000695e16 in lock_table_names (thd=0x2dd8660, tables_start=0x7f71040173b0, tables_end=, lock_wait_timeout=, flags=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4824 #6 0x0000000000699800 in open_tables (thd=0x2dd8660, start=0x7f71691a84f8, counter=0x7f71691a9e78, flags=0, prelocking_strategy=0x7f71691a9e60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5037 #7 0x000000000072eeac in mysql_alter_table (thd=0x2dd8660, new_db=0x7f7104017270 "test", new_name=0x0, create_info=0x7f71691aa440, table_list=0x7f71040173b0, alter_info=0x7f71691aa520, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7856 #8 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2dd8660) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #9 0x00000000006de1e0 in mysql_execute_command (thd=0x2dd8660) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #10 0x00000000006e1598 in mysql_parse (thd=0x2dd8660, rawbuf=, length=48081384, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2b1f in dispatch_command (command=, thd=0x2dd8660, packet=0x51c
, packet_length=67128272) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1445 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e71bd0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 9 (LWP 16633): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000984c6b in os_aio_linux_collect (seg_size=256, segment=, array=0x2939e50) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5086 #2 os_aio_linux_handle (global_seg=4, message1=0x7f716cf78d98, message2=0x7f716cf78d90, type=0x7f716cf78d88, space_id=0x7f716cf78d80) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:5231 #3 0x0000000000a83d18 in fil_aio_wait (segment=4) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/fil/fil0fil.cc:5469 #4 0x00000000009ef8c8 in io_handler_thread (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/srv/srv0start.cc:479 #5 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 8 (LWP 16813): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000654ffe in inline_mysql_cond_timedwait (src_line=1306, src_file=0xb5fef8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc", abstime=0x7f71691690b0, mutex=0x2e5f6c0, that=0x2e5f6f8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2e5f6c0, owner=0x2e5f580, abs_timeout=0x7f71691690b0, set_status_on_timeout=false, wait_state_name=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:1306 #3 0x00000000006572df in MDL_context::acquire_lock (this=0x2e5f6c0, mdl_request=0x7f70f8005160, lock_wait_timeout=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2229 #4 0x000000000065752b in MDL_context::acquire_locks (this=0x2e5f6c0, mdl_requests=, lock_wait_timeout=31536000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2339 #5 0x0000000000695e16 in lock_table_names (thd=0x2e5f580, tables_start=0x7f70f8004dc0, tables_end=, lock_wait_timeout=, flags=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4824 #6 0x00000000008599d7 in Sql_cmd_truncate_table::lock_table (this=0x7f70f8005328, thd=0x2e5f580, table_ref=0x7f70f8004dc0, hton_can_recreate=0x7f716916959f) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_truncate.cc:344 #7 0x0000000000859fc6 in Sql_cmd_truncate_table::truncate_table (this=0x7f70f8005328, thd=0x2e5f580, table_ref=0x7f70f8004dc0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_truncate.cc:444 #8 0x000000000085a30e in Sql_cmd_truncate_table::execute (this=0x7f70f8005328, thd=0x2e5f580) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_truncate.cc:519 #9 0x00000000006de1e0 in mysql_execute_command (thd=0x2e5f580) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #10 0x00000000006e1598 in mysql_parse (thd=0x2e5f580, rawbuf=, length=48634120, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2e5f580, packet=0x2da4291 " TRUNCATE `table500_innodb_default_int_autoinc` ", packet_length=48) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e71bd0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 7 (LWP 16820): +bt #0 0x0000003fde20e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003fde2093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003fde209326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000697ac8 in inline_mysql_mutex_lock (src_line=115, src_file=0xb63520 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h", that=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:688 #4 lock (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h:115 #5 open_table (thd=0x2e3a1c0, table_list=0x7f70f0004f20, ot_ctx=0x7f71690e74d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:2859 #6 0x0000000000699de2 in open_and_process_table (ot_ctx=0x7f71690e74d0, has_prelocking_list=false, prelocking_strategy=0x7f71690e7590, flags=0, counter=0x2e3c600, tables=0x7f70f0004f20, lex=0x2e3c548, thd=0x2e3a1c0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4567 #7 open_tables (thd=0x2e3a1c0, start=0x7f71690e7578, counter=0x2e3c600, flags=0, prelocking_strategy=0x7f71690e7590) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5069 #8 0x0000000000699eff in open_normal_and_derived_tables (thd=, tables=0x7f70f0004f20, flags=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5768 #9 0x00000000006dae01 in execute_sqlcom_select (thd=0x2e3a1c0, all_tables=0x7f70f0004f20) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5253 #10 0x00000000006de510 in mysql_execute_command (thd=0x2e3a1c0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:2749 #11 0x00000000006e1598 in mysql_parse (thd=0x2e3a1c0, rawbuf=, length=48481608, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #12 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2e3a1c0, packet=0x2dc05d1 "SELECT * FROM `table100_innodb_compressed_int_autoinc` INTO OUTFILE '/ssd/244301/tmp/gentest16819.tmp' ", packet_length=103) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #13 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #14 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #15 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e186a0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #16 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #17 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 6 (LWP 16804): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000654ffe in inline_mysql_cond_timedwait (src_line=1306, src_file=0xb5fef8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc", abstime=0x7f7169229f90, mutex=0x2e41d00, that=0x2e41d38) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2e41d00, owner=0x2e41bc0, abs_timeout=0x7f7169229f90, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:1306 #3 0x0000000000657119 in MDL_context::acquire_lock (this=0x2e41d00, mdl_request=0x7f710c02b7b0, lock_wait_timeout=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2245 #4 0x000000000065752b in MDL_context::acquire_locks (this=0x2e41d00, mdl_requests=, lock_wait_timeout=31536000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2339 #5 0x0000000000695e16 in lock_table_names (thd=0x2e41bc0, tables_start=0x7f710c02b410, tables_end=, lock_wait_timeout=, flags=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4824 #6 0x0000000000699800 in open_tables (thd=0x2e41bc0, start=0x7f716922a4f8, counter=0x7f716922be78, flags=0, prelocking_strategy=0x7f716922be60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5037 #7 0x000000000072eeac in mysql_alter_table (thd=0x2e41bc0, new_db=0x7f710c0167c0 "test", new_name=0x0, create_info=0x7f716922c440, table_list=0x7f710c02b410, alter_info=0x7f716922c520, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7856 #8 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2e41bc0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #9 0x00000000006de1e0 in mysql_execute_command (thd=0x2e41bc0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #10 0x00000000006e1598 in mysql_parse (thd=0x2e41bc0, rawbuf=, length=48512840, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2b1f in dispatch_command (command=, thd=0x2e41bc0, packet=0x532
, packet_length=201346000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1445 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e71bd0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 5 (LWP 16807): +bt #0 0x0000003fde20b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000654ffe in inline_mysql_cond_timedwait (src_line=1306, src_file=0xb5fef8 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc", abstime=0x7f71691e8f90, mutex=0x2e33010, that=0x2e33048) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=0x2e33010, owner=0x2e32ed0, abs_timeout=0x7f71691e8f90, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:1306 #3 0x0000000000657119 in MDL_context::acquire_lock (this=0x2e33010, mdl_request=0x7f71000379b0, lock_wait_timeout=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2245 #4 0x000000000065752b in MDL_context::acquire_locks (this=0x2e33010, mdl_requests=, lock_wait_timeout=31536000) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/mdl.cc:2339 #5 0x0000000000695e16 in lock_table_names (thd=0x2e32ed0, tables_start=0x7f7100037610, tables_end=, lock_wait_timeout=, flags=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4824 #6 0x0000000000699800 in open_tables (thd=0x2e32ed0, start=0x7f71691e94f8, counter=0x7f71691eae78, flags=0, prelocking_strategy=0x7f71691eae60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5037 #7 0x000000000072eeac in mysql_alter_table (thd=0x2e32ed0, new_db=0x7f71000246f0 "test", new_name=0x0, create_info=0x7f71691eb440, table_list=0x7f7100037610, alter_info=0x7f71691eb520, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7856 #8 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2e32ed0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #9 0x00000000006de1e0 in mysql_execute_command (thd=0x2e32ed0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #10 0x00000000006e1598 in mysql_parse (thd=0x2e32ed0, rawbuf=, length=48452184, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #11 0x00000000006e2b1f in dispatch_command (command=, thd=0x2e32ed0, packet=0x532
, packet_length=19408) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1445 #12 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #13 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #14 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e71bd0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #15 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 4 (LWP 16798): +bt #0 0x0000003fde20e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003fde2093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003fde209326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x000000000077392f in inline_mysql_mutex_lock (src_line=115, src_file=0xb63520 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h", that=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:688 #4 lock (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h:115 #5 Table_cache_manager::lock_all_and_tdc (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.cc:282 #6 0x000000000069195d in tdc_remove_table (thd=0x2e0bfa0, remove_type=TDC_RT_REMOVE_NOT_OWN, db=, table_name=0x7f7110026c45 "table100_innodb_compressed", has_lock=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:9276 #7 0x0000000000691aa9 in wait_while_table_is_used (thd=0x2e0bfa0, table=0x7f711000c120, function=HA_EXTRA_FORCE_REOPEN) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:2233 #8 0x000000000072fe2a in simple_rename_or_index_change (alter_ctx=0x7f711bffb500, keys_onoff=Alter_info::DISABLE, table_list=0x7f7110005dc0, thd=0x2e0bfa0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7527 #9 mysql_alter_table (thd=0x2e0bfa0, new_db=0x7f7110006320 "test", new_name=, create_info=, table_list=0x7f7110005dc0, alter_info=, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:8027 #10 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2e0bfa0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #11 0x00000000006de1e0 in mysql_execute_command (thd=0x2e0bfa0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #12 0x00000000006e1598 in mysql_parse (thd=0x2e0bfa0, rawbuf=, length=48292648, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #13 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2e0bfa0, packet=0x2dabed1 "/* GenTest::Transform::DisableIndexes */ ALTER TABLE table100_innodb_compressed DISABLE KEYS; ALTER TABLE table100_innodb_compressed_int DISABLE KEYS; ALTER TABLE table100_innodb_compressed_int_autoinc DISABLE KEYS; ALTER TABLE table100_innodb_default DISABLE KEYS; ALTER TABLE table100_innodb_default_int DISABLE KEYS; ALTER TABLE table100_innodb_default_int_autoinc DISABLE KEYS; ALTER TABLE table100_innodb_dynamic DISABLE KEYS; ALTER TABLE table100_innodb_dynamic_int DISABLE KEYS; ALTER TABLE table100_innodb_dynamic_int_autoinc DISABLE KEYS; ALTER TABLE table500_innodb_compressed DISABLE KEYS; ALTER TABLE table500_innodb_compressed_int DISABLE KEYS; ALTER TABLE table500_innodb_compressed_int_autoinc DISABLE KEYS; ALTER TABLE table500_innodb_default DISABLE KEYS; ALTER TABLE table500_innodb_default_int DISABLE KEYS; ALTER TABLE table500_innodb_default_int_autoinc DISABLE KEYS; ALTER TABLE table500_innodb_dynamic DISABLE KEYS; ALTER TABLE table500_innodb_dynamic_int DISABLE KEYS; ALTER TABLE table500_innodb_dynamic_int_autoinc DISABLE KEYS; ALTER TABLE view_table100_innodb_compressed DISABLE KEYS; ALTER TABLE view_table100_innodb_compressed_int DISABLE KEYS; ALTER TABLE view_table100_innodb_compressed_int_autoinc DISABLE KEYS; ALTER TABLE view_table100_innodb_default DISABLE KEYS; ALTER TABLE view_table100_innodb_default_int DISABLE KEYS; ALTER TABLE view_table100_innodb_default_int_autoinc DISABLE KEYS; ALTER TABLE view_table100_innodb_dynamic DISABLE KEYS; ALTER TABLE view_table100_innodb_dynamic_int DISABLE KEYS; ALTER TABLE view_table100_innodb_dynamic_int_autoinc DISABLE KEYS; ALTER TABLE view_table500_innodb_compressed DISABLE KEYS; ALTER TABLE view_table500_innodb_compressed_int DISABLE KEYS; ALTER TABLE view_table500_innodb_compressed_int_autoinc DISABLE KEYS; ALTER TABLE view_table500_innodb_default DISABLE KEYS; ALTER TABLE view_table500_innodb_default_int DISABLE KEYS; ALTER TABLE view_table500_innodb_default_int_autoinc DISABLE KEYS; ALTER TABLE view_table500_innodb_dynamic DISABLE KEYS; ALTER TABLE view_table500_innodb_dynamic_int DISABLE KEYS; ALTER TABLE view_table500_innodb_dynamic_int_autoinc DISABLE KEYS", packet_length=2157) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #14 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #15 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #16 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e71bd0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #17 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #18 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 3 (LWP 16796): +bt #0 0x0000003fde20e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003fde2093be in _L_lock_995 () from /lib64/libpthread.so.0 #2 0x0000003fde209326 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000697ac8 in inline_mysql_mutex_lock (src_line=115, src_file=0xb63520 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h", that=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/include/mysql/psi/mysql_thread.h:688 #4 lock (this=0x12dbca0 ) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table_cache.h:115 #5 open_table (thd=0x2e11700, table_list=0x7f7114000da0, ot_ctx=0x7f71692adf90) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:2859 #6 0x0000000000699de2 in open_and_process_table (ot_ctx=0x7f71692adf90, has_prelocking_list=false, prelocking_strategy=0x7f71692ae050, flags=0, counter=0x2e13b40, tables=0x7f7114000da0, lex=0x2e13a88, thd=0x2e11700) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4567 #7 open_tables (thd=0x2e11700, start=0x7f71692ae038, counter=0x2e13b40, flags=0, prelocking_strategy=0x7f71692ae050) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5069 #8 0x0000000000699eff in open_normal_and_derived_tables (thd=, tables=0x7f7114000da0, flags=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5768 #9 0x0000000000748585 in mysql_update (thd=0x2e11700, table_list=0x7f7114000da0, fields=..., values=..., conds=0x0, order_num=1, order=0x7f7114001610, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7f71692af258, updated_return=0x7f71692af260) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_update.cc:251 #10 0x00000000006de1be in mysql_execute_command (thd=0x2e11700) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:3498 #11 0x00000000006e1598 in mysql_parse (thd=0x2e11700, rawbuf=, length=48315016, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #12 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2e11700, packet=0x2d76731 "UPDATE IGNORE `table100_innodb_dynamic` SET `c37` = NULL ORDER BY `c27` ", packet_length=74) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #13 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #14 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #15 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e71bd0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #16 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #17 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 2 (LWP 16793): +bt #0 0x0000003fde20b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009886c3 in os_cond_wait (fast_mutex=0x2d0c890, cond=0x2d0c8d0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2d0c890, reset_sig_count=1918) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0sync.cc:610 #3 0x00000000009f53a4 in sync_array_wait_event (arr=0x29436c0, index=1) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0arr.cc:424 #4 0x00000000009f6808 in mutex_spin_wait (mutex=0x2d0c7d8, file_name=0xbeb370 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/que/que0que.cc", line=1283) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/sync/sync0sync.cc:583 #5 0x00000000009a544a in pfs_mutex_enter_func (line=1283, mutex=, file_name=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/sync0sync.ic:251 #6 que_eval_sql (info=0x7f7130021a08, sql=0xc06828 "PROCEDURE FETCH_STATS () IS\nfound INT;\nDECLARE FUNCTION fetch_table_stats_step;\nDECLARE FUNCTION fetch_index_stats_step;\nDECLARE CURSOR table_stats_cur IS\n SELECT\n n_rows,\n clustered_index_size,\n sum_of_other_index_sizes\n FROM \"mysql/innodb_table_stats\"\n WHERE\n database_name = :database_name AND\n table_name = :table_name;\nDECLARE CURSOR index_stats_cur IS\n SELECT\n index_name,\n stat_name,\n stat_value,\n sample_size\n FROM \"mysql/innodb_index_stats\"\n WHERE\n database_name = :database_name AND\n table_name = :table_name;\nBEGIN\nOPEN table_stats_cur;\nFETCH table_stats_cur INTO\n fetch_table_stats_step();\nIF (SQL % NOTFOUND) THEN\n CLOSE table_stats_cur;\n RETURN;\nEND IF;\nCLOSE table_stats_cur;\nOPEN index_stats_cur;\nfound := 1;\nWHILE found = 1 LOOP\n FETCH index_stats_cur INTO\n fetch_index_stats_step();\n IF (SQL % NOTFOUND) THEN\n found := 0;\n END IF;\nEND LOOP;\nCLOSE index_stats_cur;\nEND;", reserve_dict_mutex=1, trx=0x7f7130018558) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/que/que0que.cc:1283 #7 0x0000000000a7f828 in dict_stats_fetch_from_ps (table=0x7f713005ebf8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0stats.cc:2839 #8 dict_stats_update (table=0x7f714c131c28, stats_upd_option=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/dict/dict0stats.cc:3041 #9 0x0000000000941ae9 in dict_stats_init (table=0x7f714c131c28) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/dict0stats.ic:174 #10 ha_innobase::open (this=0x7f7130051180, name=0x7f7130031388 "./test/table500_innodb_dynamic_int", mode=, test_if_locked=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/ha_innodb.cc:5134 #11 0x00000000005a9bde in handler::ha_open (this=0x7f7130051180, table_arg=, name=0x7f7130031388 "./test/table500_innodb_dynamic_int", mode=2, test_if_locked=2) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/handler.cc:2473 #12 0x000000000076a674 in open_table_from_share (thd=0x2ecb9a0, share=, alias=, db_stat=39, prgflag=, ha_open_flags=0, outparam=0x7f7130025de0, is_create_table=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/table.cc:2318 #13 0x0000000000697688 in open_table (thd=0x2ecb9a0, table_list=0x7f713004e370, ot_ctx=0x7f7123ffb3a0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:3082 #14 0x0000000000699de2 in open_and_process_table (ot_ctx=0x7f7123ffb3a0, has_prelocking_list=false, prelocking_strategy=0x7f7123ffce60, flags=0, counter=0x7f7123ffce78, tables=0x7f713004e370, lex=0x2ecdd28, thd=0x2ecb9a0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:4567 #15 open_tables (thd=0x2ecb9a0, start=0x7f7123ffb4f8, counter=0x7f7123ffce78, flags=0, prelocking_strategy=0x7f7123ffce60) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_base.cc:5069 #16 0x000000000072eeac in mysql_alter_table (thd=0x2ecb9a0, new_db=0x7f713004e8d0 "test", new_name=0x0, create_info=0x7f7123ffd440, table_list=0x7f713004e370, alter_info=0x7f7123ffd520, order_num=0, order=0x0, ignore=false) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_table.cc:7856 #17 0x0000000000818857 in Sql_cmd_alter_table::execute (this=, thd=0x2ecb9a0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_alter.cc:317 #18 0x00000000006de1e0 in mysql_execute_command (thd=0x2ecb9a0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5132 #19 0x00000000006e1598 in mysql_parse (thd=0x2ecb9a0, rawbuf=, length=49077544, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #20 0x00000000006e2b1f in dispatch_command (command=, thd=0x2ecb9a0, packet=0x4c2
, packet_length=805325728) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1445 #21 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #22 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #23 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e9a150) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #24 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #25 0x0000003fddee890d in clone () from /lib64/libc.so.6 Thread 1 (LWP 16791): +bt #0 0x0000003fde20c69c in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000661fae in handle_fatal_signal (sig=6) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/signal_handler.cc:251 #2 #3 0x0000003fdde328a5 in raise () from /lib64/libc.so.6 #4 0x0000003fdde34085 in abort () from /lib64/libc.so.6 #5 0x0000000000983648 in os_file_read_func (file=77, buf=0x7f711c015250, offset=0, n=, trx=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/os/os0file.cc:2821 #6 0x00000000009720d3 in pfs_os_file_read_func (src_line=286, src_file=0xbe5b58 "/bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/log/log0online.cc", trx=0x0, n=4096, offset=0, buf=0x7f711c015250, file=77) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/include/os0file.ic:262 #7 log_online_read_bitmap_page (bitmap_file=0x7f712bfbbb40, page=0x7f711c015250 "H\a", checksum_ok=0x7f712bfbbad8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/log/log0online.cc:286 #8 0x0000000000974fc5 in log_online_bitmap_iterator_next (i=0x7f712bfbbb20) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/log/log0online.cc:1706 #9 0x000000000094b428 in i_s_innodb_changed_pages_fill (thd=0x2ec3900, tables=, cond=0x0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/innobase/handler/i_s.cc:8207 #10 0x0000000000708a5c in do_fill_table (join_table=, table_list=0x7f711c006188, thd=0x2ec3900) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_show.cc:7682 #11 get_schema_tables_result (join=0x7f711c02ec78, executed_place=PROCESSED_BY_JOIN_EXEC) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_show.cc:7783 #12 0x00000000006fd0ed in JOIN::prepare_result (this=0x7f711c02ec78, columns_list=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:823 #13 0x00000000006bd73f in JOIN::exec (this=0x7f711c02ec78) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_executor.cc:116 #14 0x00000000007d5099 in subselect_single_select_engine::exec (this=0x7f711c006868) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/item_subselect.cc:2771 #15 0x00000000007d69d4 in Item_subselect::exec (this=0x7f711c0066f8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/item_subselect.cc:641 #16 0x00000000007d3ac5 in Item_in_subselect::val_bool (this=0x7f711c0066f8) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/item_subselect.cc:1399 #17 0x00000000005ced65 in Item_in_optimizer::val_int (this=0x7f711c02f130) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/item_cmpfunc.cc:2104 #18 0x00000000005b739c in Item::val_bool (this=0x7f711c02f130) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/item.cc:203 #19 0x00000000005ce04f in Item_func_not::val_int (this=0x7f711c0068a0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/item_cmpfunc.cc:290 #20 0x00000000006bc8e9 in evaluate_join_record (join=0x7f711c02e620, join_tab=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_executor.cc:1458 #21 0x00000000006bd101 in sub_select (join=0x7f711c02e620, join_tab=0x7f711c02ff00, end_of_records=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_executor.cc:1273 #22 0x00000000006bd90a in do_select (join=0x7f711c02e620) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_executor.cc:930 #23 JOIN::exec (this=0x7f711c02e620) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_executor.cc:191 #24 0x00000000006ff300 in mysql_execute_select (free_join=true, select_lex=0x2ec6398, thd=0x2ec3900) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:1101 #25 mysql_select (thd=0x2ec3900, tables=0x7f711c004f28, wild_num=1, fields=..., conds=0x7f711c0068a0, order=, group=0x2ec6498, having=0x0, select_options=2147781376, result=0x7f711c006ba8, unit=0x2ec5d50, select_lex=0x2ec6398) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:1222 #26 0x00000000006ffb77 in handle_select (thd=0x2ec3900, result=0x7f711c006ba8, setup_tables_done_option=0) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_select.cc:111 #27 0x00000000006daf9d in execute_sqlcom_select (thd=0x2ec3900, all_tables=0x7f711c004f28) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:5280 #28 0x00000000006de510 in mysql_execute_command (thd=0x2ec3900) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:2749 #29 0x00000000006e1598 in mysql_parse (thd=0x2ec3900, rawbuf=, length=49044616, parser_state=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:6451 #30 0x00000000006e2451 in dispatch_command (command=COM_QUERY, thd=0x2ec3900, packet=0x2ec7841 "", packet_length=174) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_parse.cc:1376 #31 0x00000000006b009f in do_handle_one_connection (thd_arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1615 #32 0x00000000006b0177 in handle_one_connection (arg=) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/sql/sql_connect.cc:1526 #33 0x00000000009195a9 in pfs_spawn_thread (arg=0x2e9a150) at /bzr/QA-5.6.11_opt/Percona-Server-5.6.11-alpha60.3/storage/perfschema/pfs.cc:1853 #34 0x0000003fde207851 in start_thread () from /lib64/libpthread.so.0 #35 0x0000003fddee890d in clone () from /lib64/libc.so.6 (gdb) +set logging off