(gdb) +thread apply all bt Thread 50 (LWP 1543): +bt #0 0x000000362fa0ee53 in pread64 () from /lib64/libpthread.so.0 #1 0x0000000000a44e07 in pread (__offset=6971392, __nbytes=8192, __buf=0x7f412e52c000, __fd=38) at /usr/include/bits/unistd.h:100 #2 os_file_pread (file=file@entry=38, buf=buf@entry=0x7f412e52c000, n=n@entry=8192, offset=offset@entry=6971392, trx=trx@entry=0x7f409c02f308) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2468 #3 0x0000000000a468f0 in os_file_read_func (file=38, buf=0x7f412e52c000, offset=6971392, n=8192, trx=0x7f409c02f308) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2785 #4 0x0000000000bd5f55 in pfs_os_aio_func (src_file=0xe25698 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc", src_line=5573, trx=0x7f409c02f308, space_id=56, message2=0x7f40a8036fa0, message1=0x7f409808f6b8, n=8192, offset=6971392, buf=0x7f412e52c000, file=38, name=0x7f40980de758 "./test/table100_innodb_compressed_key_pk_parts_2_int#P#p1.ibd", mode=24, type=10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/os0file.ic:230 #5 _fil_io (type=type@entry=10, sync=sync@entry=true, space_id=space_id@entry=56, zip_size=zip_size@entry=8192, block_offset=, block_offset@entry=851, byte_offset=byte_offset@entry=0, len=len@entry=8192, buf=0x7f412e52c000, message=message@entry=0x7f40a8036fa0, trx=trx@entry=0x7f409c02f308) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5573 #6 0x0000000000b9374e in buf_read_page_low (err=err@entry=0x7f41228892ec, sync=sync@entry=true, mode=0, mode@entry=132, space=space@entry=56, zip_size=zip_size@entry=8192, unzip=unzip@entry=0, tablespace_version=59, offset=offset@entry=851, trx=trx@entry=0x7f409c02f308) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:232 #7 0x0000000000b94d63 in buf_read_page (space=space@entry=56, zip_size=zip_size@entry=8192, offset=offset@entry=851, trx=trx@entry=0x7f409c02f308) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:462 #8 0x0000000000b6f8b4 in buf_page_get_zip (space=space@entry=56, zip_size=zip_size@entry=8192, offset=offset@entry=851) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0buf.cc:2064 #9 0x0000000000b57cc4 in btr_copy_zblob_prefix (offset=12, page_no=851, space_id=56, zip_size=8192, len=8192, buf=0x7f40a8066e9b "") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5486 #10 btr_copy_externally_stored_field_prefix_low (buf=buf@entry=0x7f40a8066b48 "\377\330\377", , len=len@entry=65535, zip_size=zip_size@entry=8192, space_id=space_id@entry=56, page_no=, offset=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5616 #11 0x0000000000b58110 in btr_copy_externally_stored_field (len=len@entry=0x7f41228895a8, data=data@entry=0x7f412e4d43de "", zip_size=zip_size@entry=8192, local_len=0, local_len@entry=20, heap=heap@entry=0x7f40a80869d0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5729 #12 0x0000000000b581dd in btr_rec_copy_externally_stored_field (rec=rec@entry=0x7f412e4d4381 "\200", offsets=offsets@entry=0x7f4122889770, zip_size=8192, no=no@entry=12, len=len@entry=0x7f41228895a8, heap=heap@entry=0x7f40a80869d0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5779 #13 0x00000000005bf391 in row_sel_store_mysql_field_func (mysql_rec=mysql_rec@entry=0x7f409c037130 "\026", prebuilt=prebuilt@entry=0x7f409c03c2f8, rec=rec@entry=0x7f412e4d4381 "\200", index=index@entry=0x7f409808fc58, offsets=offsets@entry=0x7f4122889770, field_no=field_no@entry=12, templ=templ@entry=0x7f40a8081418) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2823 #14 0x00000000005bf669 in row_sel_store_mysql_rec (mysql_rec=mysql_rec@entry=0x7f409c037130 "\026", prebuilt=prebuilt@entry=0x7f409c03c2f8, rec=rec@entry=0x7f412e4d4381 "\200", rec_clust=rec_clust@entry=0, index=index@entry=0x7f409808fc58, offsets=0x7f4122889770) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2953 #15 0x0000000000ad04b9 in row_search_for_mysql (buf=buf@entry=0x7f409c037130 "\026", mode=1, mode@entry=0, prebuilt=0x7f409c03c2f8, match_mode=match_mode@entry=0, direction=direction@entry=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:4872 #16 0x00000000009e80d0 in ha_innobase::general_fetch (this=this@entry=0x7f409c035400, buf=buf@entry=0x7f409c037130 "\026", direction=direction@entry=1, match_mode=match_mode@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8333 #17 0x00000000009e8452 in ha_innobase::rnd_next (this=0x7f409c035400, buf=0x7f409c037130 "\026") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8559 #18 0x00000000005e413f in handler::ha_rnd_next (this=this@entry=0x7f409c035400, buf=buf@entry=0x7f409c037130 "\026") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2716 #19 0x0000000000c7b92a in ha_partition::rnd_next (this=0x7f409c0050f0, buf=0x7f409c037130 "\026") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/ha_partition.cc:4689 #20 0x00000000005e40fa in handler::ha_rnd_next (this=0x7f409c0050f0, buf=0x7f409c037130 "\026") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2716 #21 0x000000000087ca3c in rr_sequential (info=0x7f40a8034788) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/records.cc:478 #22 0x000000000070cad9 in sub_select (join=0x7f40a8005e60, join_tab=0x7f40a80346f8, end_of_records=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1256 #23 0x000000000070b257 in do_select (join=0x7f40a8005e60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:930 #24 JOIN::exec (this=0x7f40a8005e60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:191 #25 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x3a8f768, thd=0x3a8cc20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101 #26 mysql_select (thd=thd@entry=0x3a8cc20, tables=0x7f40a80057a8, wild_num=1, fields=..., conds=0x0, order=order@entry=0x3a8f930, group=group@entry=0x3a8f868, having=0x0, select_options=3489925888, result=result@entry=0x7f40a8005d20, unit=0x3a8f120, select_lex=select_lex@entry=0x3a8f768) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222 #27 0x000000000075d14d in handle_select (thd=thd@entry=0x3a8cc20, result=result@entry=0x7f40a8005d20, setup_tables_done_option=setup_tables_done_option@entry=1073741824) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:111 #28 0x0000000000735a55 in mysql_execute_command (thd=thd@entry=0x3a8cc20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3857 #29 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3a8cc20, rawbuf=, length=, parser_state=parser_state@entry=0x7f412288b550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #30 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3a8cc20, packet=packet@entry=0x3a90c61 " INSERT INTO b SELECT * FROM `table100_innodb_compressed_key_pk_parts_2_int` ", packet_length=packet_length@entry=77) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #31 0x00000000007387ab in do_command (thd=thd@entry=0x3a8cc20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #32 0x00000000007d76e7 in threadpool_process_request (thd=0x3a8cc20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #33 0x00000000007d891f in handle_event (connection=0x39cfe80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #34 worker_main (param=param@entry=0x153ce00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #35 0x00000000009bbd73 in pfs_spawn_thread (arg=0x39e6ed0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #36 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #37 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 49 (LWP 1549): +bt #0 0x000000362fa0ee53 in pread64 () from /lib64/libpthread.so.0 #1 0x0000000000a44e07 in pread (__offset=8568832, __nbytes=16384, __buf=0x7f412cdfc000, __fd=4) at /usr/include/bits/unistd.h:100 #2 os_file_pread (file=file@entry=4, buf=buf@entry=0x7f412cdfc000, n=n@entry=16384, offset=offset@entry=8568832, trx=trx@entry=0x7f4084044048) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2468 #3 0x0000000000a468f0 in os_file_read_func (file=4, buf=0x7f412cdfc000, offset=8568832, n=16384, trx=0x7f4084044048) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2785 #4 0x0000000000bd5f55 in pfs_os_aio_func (src_file=0xe25698 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc", src_line=5573, trx=0x7f4084044048, space_id=0, message2=0x7f4129ff0ba0, message1=0x38a4218, n=16384, offset=8568832, buf=0x7f412cdfc000, file=4, name=0x38a4328 "./ibdata1", mode=24, type=10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/os0file.ic:230 #5 _fil_io (type=type@entry=10, sync=sync@entry=true, space_id=space_id@entry=0, zip_size=zip_size@entry=0, block_offset=, block_offset@entry=523, byte_offset=byte_offset@entry=0, len=16384, buf=0x7f412cdfc000, message=message@entry=0x7f4129ff0ba0, trx=trx@entry=0x7f4084044048) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5573 #6 0x0000000000b938f9 in buf_read_page_low (err=err@entry=0x7f4122701f2c, sync=sync@entry=true, mode=0, mode@entry=132, space=space@entry=0, zip_size=zip_size@entry=0, unzip=unzip@entry=0, tablespace_version=1, offset=offset@entry=523, trx=trx@entry=0x7f4084044048) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:239 #7 0x0000000000b94d63 in buf_read_page (space=space@entry=0, zip_size=zip_size@entry=0, offset=offset@entry=523, trx=trx@entry=0x7f4084044048) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:462 #8 0x0000000000b75038 in buf_page_get_gen (space=space@entry=0, zip_size=, offset=offset@entry=523, rw_latch=rw_latch@entry=2, guess=, guess@entry=0x0, mode=mode@entry=10, file=file@entry=0xe28840 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/fut0fut.ic", line=line@entry=51, mtr=mtr@entry=0x7f4122702350) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0buf.cc:2616 #9 0x0000000000be70de in fut_get_ptr (rw_latch=2, mtr=0x7f4122702350, addr=..., zip_size=, space=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/fut0fut.ic:51 #10 flst_add_first (base=base@entry=0x7f412c92802e "", node=node@entry=0x7f412c1e4078 "", mtr=mtr@entry=0x7f4122702350) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fut/fut0lst.cc:147 #11 0x0000000000b04e2e in trx_purge_add_update_undo_to_history (trx=trx@entry=0x7f409008c628, undo_page=undo_page@entry=0x7f412c1e4000 "", mtr=mtr@entry=0x7f4122702350) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/trx/trx0purge.cc:258 #12 0x0000000000b28b93 in trx_undo_update_cleanup (trx=trx@entry=0x7f409008c628, undo_page=0x7f412c1e4000 "", mtr=mtr@entry=0x7f4122702350) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/trx/trx0undo.cc:1936 #13 0x0000000000b1fcf8 in trx_write_serialisation_history (mtr=0x7f4122702350, trx=0x7f409008c628) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/trx/trx0trx.cc:1167 #14 trx_commit_low (trx=0x7f409008c628, mtr=0x7f4122702350) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/trx/trx0trx.cc:1543 #15 0x0000000000b21a26 in trx_commit (trx=trx@entry=0x7f409008c628) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/trx/trx0trx.cc:1590 #16 0x0000000000b21abe in trx_commit_for_mysql (trx=trx@entry=0x7f409008c628) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/trx/trx0trx.cc:1818 #17 0x0000000000bbe070 in dict_stats_exec_sql (sql=0xe23660 "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;", pinfo=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0stats.cc:301 #18 dict_stats_exec_sql (pinfo=, sql=0xe23660 "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/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0stats.cc:276 #19 0x0000000000bbe4c7 in dict_stats_save_index_stat (index=index@entry=0x7f409009d4a8, last_update=last_update@entry=1386840148, stat_name=stat_name@entry=0x7f4122702fc0 "n_diff_pfx01", stat_value=0, sample_size=0x7f409009d6c8, stat_description=stat_description@entry=0x7f4122703170 "c27") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0stats.cc:2185 #20 0x0000000000bc215c in dict_stats_save (table_orig=table_orig@entry=0x7f406c04c878) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0stats.cc:2355 #21 0x0000000000bc62c8 in dict_stats_update (table=table@entry=0x7f406c04c878, stats_upd_option=stats_upd_option@entry=DICT_STATS_EMPTY_TABLE) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0stats.cc:2988 #22 0x0000000000ab3c83 in row_truncate_table_for_mysql (table=0x7f406c04c878, trx=0x7f4084044048) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0mysql.cc:3652 #23 0x00000000009e0e2f in ha_innobase::truncate (this=0x7f40900987e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:10504 #24 0x00000000008c7280 in Sql_cmd_truncate_table::handler_truncate (this=this@entry=0x7f40900055f8, thd=thd@entry=0x3aa4d10, table_ref=table_ref@entry=0x7f4090005090, is_tmp_table=is_tmp_table@entry=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_truncate.cc:235 #25 0x00000000008c7a7d in Sql_cmd_truncate_table::truncate_table (this=this@entry=0x7f40900055f8, thd=thd@entry=0x3aa4d10, table_ref=table_ref@entry=0x7f4090005090) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_truncate.cc:467 #26 0x00000000008c7ea3 in Sql_cmd_truncate_table::execute (this=0x7f40900055f8, thd=0x3aa4d10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_truncate.cc:519 #27 0x0000000000731411 in mysql_execute_command (thd=thd@entry=0x3aa4d10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5287 #28 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3aa4d10, rawbuf=, length=, parser_state=parser_state@entry=0x7f4122705550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #29 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3aa4d10, packet=packet@entry=0x3aa8d51 " TRUNCATE `table500_innodb_default_int_autoinc` ", packet_length=packet_length@entry=48) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #30 0x00000000007387ab in do_command (thd=thd@entry=0x3aa4d10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #31 0x00000000007d76e7 in threadpool_process_request (thd=0x3aa4d10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #32 0x00000000007d891f in handle_event (connection=0x3a56c10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #33 worker_main (param=param@entry=0x153d400 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #34 0x00000000009bbd73 in pfs_spawn_thread (arg=0x39bd3c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #35 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #36 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 48 (LWP 1557): +bt #0 0x000000362fa0ee53 in pread64 () from /lib64/libpthread.so.0 #1 0x0000000000a44e07 in pread (__offset=87195648, __nbytes=16384, __buf=0x7f41321f0000, __fd=57) at /usr/include/bits/unistd.h:100 #2 os_file_pread (file=file@entry=57, buf=buf@entry=0x7f41321f0000, n=n@entry=16384, offset=offset@entry=87195648, trx=trx@entry=0x7f40800365a8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2468 #3 0x0000000000a468f0 in os_file_read_func (file=57, buf=0x7f41321f0000, offset=87195648, n=16384, trx=0x7f40800365a8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2785 #4 0x0000000000bd5f55 in pfs_os_aio_func (src_file=0xe25698 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc", src_line=5573, trx=0x7f40800365a8, space_id=49, message2=0x7f412a396b48, message1=0x7f40e004e628, n=16384, offset=87195648, buf=0x7f41321f0000, file=57, name=0x7f40e00065a8 "./test/table500_innodb_dynamic_int.ibd", mode=24, type=10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/os0file.ic:230 #5 _fil_io (type=type@entry=10, sync=sync@entry=true, space_id=space_id@entry=49, zip_size=zip_size@entry=0, block_offset=, block_offset@entry=5322, byte_offset=byte_offset@entry=0, len=16384, buf=0x7f41321f0000, message=message@entry=0x7f412a396b48, trx=trx@entry=0x7f40800365a8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5573 #6 0x0000000000b938f9 in buf_read_page_low (err=err@entry=0x7f412051e24c, sync=sync@entry=true, mode=0, mode@entry=132, space=space@entry=49, zip_size=zip_size@entry=0, unzip=unzip@entry=0, tablespace_version=52, offset=offset@entry=5322, trx=trx@entry=0x7f40800365a8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:239 #7 0x0000000000b94d63 in buf_read_page (space=space@entry=49, zip_size=zip_size@entry=0, offset=offset@entry=5322, trx=trx@entry=0x7f40800365a8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:462 #8 0x0000000000b75038 in buf_page_get_gen (space=space@entry=49, zip_size=zip_size@entry=0, offset=offset@entry=5322, rw_latch=rw_latch@entry=1, guess=, guess@entry=0x0, mode=mode@entry=10, file=file@entry=0xe17168 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc", line=line@entry=5407, mtr=mtr@entry=0x7f412051e400) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0buf.cc:2616 #9 0x0000000000b494a1 in btr_copy_blob_prefix (buf=buf@entry=0x7f40740b1e78 "\377\330\377", , len=len@entry=65535, space_id=space_id@entry=49, page_no=5322, page_no@entry=5318, offset=offset@entry=38) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5407 #10 0x0000000000b57bf7 in btr_copy_externally_stored_field_prefix_low (buf=buf@entry=0x7f40740b1e78 "\377\330\377", , len=len@entry=65535, zip_size=zip_size@entry=0, space_id=space_id@entry=49, page_no=5318, offset=38) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5619 #11 0x0000000000b58110 in btr_copy_externally_stored_field (len=len@entry=0x7f412051ead8, data=data@entry=0x7f412da900db "", zip_size=zip_size@entry=0, local_len=0, local_len@entry=20, heap=heap@entry=0x7f4074041680) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5729 #12 0x0000000000b581dd in btr_rec_copy_externally_stored_field (rec=rec@entry=0x7f412da90096 "\200", offsets=offsets@entry=0x7f412051eca0, zip_size=0, no=no@entry=13, len=len@entry=0x7f412051ead8, heap=heap@entry=0x7f4074041680) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5779 #13 0x00000000005bf391 in row_sel_store_mysql_field_func (mysql_rec=mysql_rec@entry=0x7f407404ee40 "\020\002\034", prebuilt=prebuilt@entry=0x7f407403e3a8, rec=rec@entry=0x7f412da90096 "\200", index=index@entry=0x7f40e004ed48, offsets=offsets@entry=0x7f412051eca0, field_no=field_no@entry=13, templ=templ@entry=0x7f40740300b8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2823 #14 0x00000000005bf669 in row_sel_store_mysql_rec (mysql_rec=mysql_rec@entry=0x7f407404ee40 "\020\002\034", prebuilt=prebuilt@entry=0x7f407403e3a8, rec=rec@entry=0x7f412da90096 "\200", rec_clust=rec_clust@entry=0, index=index@entry=0x7f40e004ed48, offsets=0x7f412051eca0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2953 #15 0x0000000000ad04b9 in row_search_for_mysql (buf=buf@entry=0x7f407404ee40 "\020\002\034", mode=1, mode@entry=0, prebuilt=0x7f407403e3a8, match_mode=match_mode@entry=0, direction=direction@entry=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:4872 #16 0x00000000009e80d0 in ha_innobase::general_fetch (this=this@entry=0x7f4074031b90, buf=buf@entry=0x7f407404ee40 "\020\002\034", direction=direction@entry=1, match_mode=match_mode@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8333 #17 0x00000000009e8452 in ha_innobase::rnd_next (this=0x7f4074031b90, buf=0x7f407404ee40 "\020\002\034") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8559 #18 0x00000000005e40fa in handler::ha_rnd_next (this=this@entry=0x7f4074031b90, buf=0x7f407404ee40 "\020\002\034") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2716 #19 0x0000000000833826 in find_all_keys (found_rows=0x7f4120520198, pq=0x0, tempfile=0x7f412051fa70, buffpek_pointers=0x7f412051fb90, fs_info=0x7f412051f980, select=0x0, param=0x7f412051f9f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/filesort.cc:768 #20 filesort (thd=thd@entry=0x3ab4db0, table=table@entry=0x7f407404e550, filesort=0x7f407404e680, filesort@entry=0x7f4120520300, sort_positions=240, sort_positions@entry=true, examined_rows=examined_rows@entry=0x7f4120520190, found_rows=found_rows@entry=0x7f4120520198) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/filesort.cc:340 #21 0x00000000007a1b78 in mysql_update (thd=thd@entry=0x3ab4db0, table_list=0x7f4074005178, fields=..., values=..., conds=0x0, order_num=0, order=0x7f4074005a58, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=found_return@entry=0x7f41205205d0, updated_return=updated_return@entry=0x7f41205205d8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_update.cc:572 #22 0x0000000000732fef in mysql_execute_command (thd=thd@entry=0x3ab4db0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3641 #23 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3ab4db0, rawbuf=, length=, parser_state=parser_state@entry=0x7f4120521550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #24 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3ab4db0, packet=packet@entry=0x3ab8df1 "UPDATE `table500_innodb_dynamic_int` SET `c2` = '2004-06-19 19:28:57.046603' ORDER BY `c16` ", packet_length=packet_length@entry=95) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #25 0x00000000007387ab in do_command (thd=thd@entry=0x3ab4db0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #26 0x00000000007d76e7 in threadpool_process_request (thd=0x3ab4db0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #27 0x00000000007d891f in handle_event (connection=0x3a5f190) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #28 worker_main (param=param@entry=0x153c800 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #29 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f4080004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #30 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #31 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 47 (LWP 1546): +bt #0 0x000000362fa0ee53 in pread64 () from /lib64/libpthread.so.0 #1 0x0000000000a44e07 in pread (__offset=74620928, __nbytes=8192, __buf=0x7f412e5c6000, __fd=70) at /usr/include/bits/unistd.h:100 #2 os_file_pread (file=file@entry=70, buf=buf@entry=0x7f412e5c6000, n=n@entry=8192, offset=offset@entry=74620928, trx=trx@entry=0x7f409403ce38) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2468 #3 0x0000000000a468f0 in os_file_read_func (file=70, buf=0x7f412e5c6000, offset=74620928, n=8192, trx=0x7f409403ce38) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2785 #4 0x0000000000bd5f55 in pfs_os_aio_func (src_file=0xe25698 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc", src_line=5573, trx=0x7f409403ce38, space_id=31, message2=0x7f4094047980, message1=0x7f40d86a9628, n=8192, offset=74620928, buf=0x7f412e5c6000, file=70, name=0x7f40db3365e8 "./test/table500_innodb_compressed_int.ibd", mode=24, type=10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/os0file.ic:230 #5 _fil_io (type=type@entry=10, sync=sync@entry=true, space_id=space_id@entry=31, zip_size=zip_size@entry=8192, block_offset=, block_offset@entry=9109, byte_offset=byte_offset@entry=0, len=len@entry=8192, buf=0x7f412e5c6000, message=message@entry=0x7f4094047980, trx=trx@entry=0x7f409403ce38) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5573 #6 0x0000000000b9374e in buf_read_page_low (err=err@entry=0x7f41227c62ac, sync=sync@entry=true, mode=0, mode@entry=132, space=space@entry=31, zip_size=zip_size@entry=8192, unzip=unzip@entry=0, tablespace_version=34, offset=offset@entry=9109, trx=trx@entry=0x7f409403ce38) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:232 #7 0x0000000000b94d63 in buf_read_page (space=space@entry=31, zip_size=zip_size@entry=8192, offset=offset@entry=9109, trx=trx@entry=0x7f409403ce38) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:462 #8 0x0000000000b6f8b4 in buf_page_get_zip (space=space@entry=31, zip_size=zip_size@entry=8192, offset=offset@entry=9109) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0buf.cc:2064 #9 0x0000000000b57cc4 in btr_copy_zblob_prefix (offset=12, page_no=9109, space_id=31, zip_size=8192, len=8192, buf=0x7f409407c44d "") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5486 #10 btr_copy_externally_stored_field_prefix_low (buf=buf@entry=0x7f409407a0b8 "\032", len=len@entry=65535, zip_size=zip_size@entry=8192, space_id=space_id@entry=31, page_no=, offset=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5616 #11 0x0000000000b58110 in btr_copy_externally_stored_field (len=len@entry=0x7f41227c6568, data=data@entry=0x7f412c6ff4b7 "", zip_size=zip_size@entry=8192, local_len=0, local_len@entry=20, heap=heap@entry=0x7f4094036e90) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5729 #12 0x0000000000b581dd in btr_rec_copy_externally_stored_field (rec=rec@entry=0x7f412c6fea77 "\200", offsets=offsets@entry=0x7f41227c6730, zip_size=8192, no=no@entry=19, len=len@entry=0x7f41227c6568, heap=heap@entry=0x7f4094036e90) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5779 #13 0x00000000005bf391 in row_sel_store_mysql_field_func (mysql_rec=mysql_rec@entry=0x7f4094007ec0 "\030\060\022\377\377\070\240\006\224@\177", prebuilt=prebuilt@entry=0x7f4094001bb8, rec=rec@entry=0x7f412c6fea77 "\200", index=index@entry=0x7f40db35ee38, offsets=offsets@entry=0x7f41227c6730, field_no=field_no@entry=19, templ=templ@entry=0x7f4094036520) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2823 #14 0x00000000005bf669 in row_sel_store_mysql_rec (mysql_rec=mysql_rec@entry=0x7f4094007ec0 "\030\060\022\377\377\070\240\006\224@\177", prebuilt=prebuilt@entry=0x7f4094001bb8, rec=rec@entry=0x7f412c6fea77 "\200", rec_clust=rec_clust@entry=0, index=index@entry=0x7f40db35ee38, offsets=0x7f41227c6730) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2953 #15 0x0000000000ad04b9 in row_search_for_mysql (buf=buf@entry=0x7f4094007ec0 "\030\060\022\377\377\070\240\006\224@\177", mode=1, mode@entry=0, prebuilt=0x7f4094001bb8, match_mode=match_mode@entry=0, direction=direction@entry=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:4872 #16 0x00000000009e80d0 in ha_innobase::general_fetch (this=this@entry=0x7f40940308b0, buf=buf@entry=0x7f4094007ec0 "\030\060\022\377\377\070\240\006\224@\177", direction=direction@entry=1, match_mode=match_mode@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8333 #17 0x00000000009e8452 in ha_innobase::rnd_next (this=0x7f40940308b0, buf=0x7f4094007ec0 "\030\060\022\377\377\070\240\006\224@\177") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8559 #18 0x00000000005e40fa in handler::ha_rnd_next (this=0x7f40940308b0, buf=0x7f4094007ec0 "\030\060\022\377\377\070\240\006\224@\177") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2716 #19 0x000000000087ca3c in rr_sequential (info=0x7f4094004d40) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/records.cc:478 #20 0x000000000070cad9 in sub_select (join=0x7f4068006350, join_tab=0x7f4094004cb0, end_of_records=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1256 #21 0x000000000070c79c in evaluate_join_record (join=join@entry=0x7f4068006350, join_tab=join_tab@entry=0x7f40940049b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1598 #22 0x000000000070cb1f in sub_select (join=0x7f4068006350, join_tab=0x7f40940049b0, end_of_records=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1273 #23 0x000000000070b257 in do_select (join=0x7f4068006350) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:930 #24 JOIN::exec (this=0x7f4068006350) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:191 #25 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x3ad8028, thd=0x3ad54e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101 #26 mysql_select (thd=thd@entry=0x3ad54e0, tables=tables@entry=0x7f40680050b0, wild_num=0, fields=..., conds=conds@entry=0x7f40680060d8, order=order@entry=0x0, group=group@entry=0x0, having=having@entry=0x0, select_options=select_options@entry=1342177408, result=0x7f4068006280, unit=unit@entry=0x3ad79e0, select_lex=select_lex@entry=0x3ad8028) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222 #27 0x00000000007a3683 in mysql_multi_update (thd=thd@entry=0x3ad54e0, table_list=0x7f40680050b0, fields=fields@entry=0x3ad8148, values=values@entry=0x3ad8588, conds=0x7f40680060d8, options=0, handle_duplicates=DUP_ERROR, ignore=false, unit=unit@entry=0x3ad79e0, select_lex=select_lex@entry=0x3ad8028, result=result@entry=0x7f41227c75d8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_update.cc:1527 #28 0x0000000000733f52 in mysql_execute_command (thd=thd@entry=0x3ad54e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3707 #29 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3ad54e0, rawbuf=, length=, parser_state=parser_state@entry=0x7f41227c8550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #30 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3ad54e0, packet=packet@entry=0x3ad8f01 "UPDATE `table500_innodb_compressed_int` t1, `table100_innodb_dynamic_key_pk_parts_2_int` t2 SET t1.`c18` = '06:45:13.012503' WHERE t1.`c23` <> '20080714170020.055051'", packet_length=packet_length@entry=168) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #31 0x00000000007387ab in do_command (thd=thd@entry=0x3ad54e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #32 0x00000000007d76e7 in threadpool_process_request (thd=0x3ad54e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #33 0x00000000007d891f in handle_event (connection=0x39d05c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #34 worker_main (param=param@entry=0x153d000 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #35 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f40a0004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #36 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #37 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 46 (LWP 1548): +bt #0 0x000000362fa0ee53 in pread64 () from /lib64/libpthread.so.0 #1 0x0000000000a44e07 in pread (__offset=20242432, __nbytes=8192, __buf=0x7f412f862000, __fd=80) at /usr/include/bits/unistd.h:100 #2 os_file_pread (file=file@entry=80, buf=buf@entry=0x7f412f862000, n=n@entry=8192, offset=offset@entry=20242432, trx=trx@entry=0x7f406003b988) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2468 #3 0x0000000000a468f0 in os_file_read_func (file=80, buf=0x7f412f862000, offset=20242432, n=8192, trx=0x7f406003b988) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2785 #4 0x0000000000bd5f55 in pfs_os_aio_func (src_file=0xe25698 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc", src_line=5573, trx=0x7f406003b988, space_id=39, message2=0x7f408c0c5500, message1=0x7f40d40a74d8, n=8192, offset=20242432, buf=0x7f412f862000, file=80, name=0x7f40d418bac8 "./test/table500_innodb_compressed_key_pk_parts_2_int#P#p1.ibd", mode=24, type=10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/os0file.ic:230 #5 _fil_io (type=type@entry=10, sync=sync@entry=true, space_id=space_id@entry=39, zip_size=zip_size@entry=8192, block_offset=, block_offset@entry=2471, byte_offset=byte_offset@entry=0, len=len@entry=8192, buf=0x7f412f862000, message=message@entry=0x7f408c0c5500, trx=trx@entry=0x7f406003b988) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5573 #6 0x0000000000b9374e in buf_read_page_low (err=err@entry=0x7f412274428c, sync=sync@entry=true, mode=0, mode@entry=132, space=space@entry=39, zip_size=zip_size@entry=8192, unzip=unzip@entry=0, tablespace_version=42, offset=offset@entry=2471, trx=trx@entry=0x7f406003b988) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:232 #7 0x0000000000b94d63 in buf_read_page (space=space@entry=39, zip_size=zip_size@entry=8192, offset=offset@entry=2471, trx=trx@entry=0x7f406003b988) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:462 #8 0x0000000000b6f8b4 in buf_page_get_zip (space=space@entry=39, zip_size=zip_size@entry=8192, offset=offset@entry=2471) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0buf.cc:2064 #9 0x0000000000b57cc4 in btr_copy_zblob_prefix (offset=12, page_no=2471, space_id=39, zip_size=8192, len=8192, buf=0x7f408c0c5e07 "") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5486 #10 btr_copy_externally_stored_field_prefix_low (buf=buf@entry=0x7f408c0c7918 "\377\330\377", , len=len@entry=65535, zip_size=zip_size@entry=8192, space_id=space_id@entry=39, page_no=, offset=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5616 #11 0x0000000000b58110 in btr_copy_externally_stored_field (len=len@entry=0x7f4122744548, data=data@entry=0x7f4131c982a3 "", zip_size=zip_size@entry=8192, local_len=0, local_len@entry=20, heap=heap@entry=0x7f408c0b5e20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5729 #12 0x0000000000b581dd in btr_rec_copy_externally_stored_field (rec=rec@entry=0x7f4131c98210 "\200", offsets=offsets@entry=0x7f4122744710, zip_size=8192, no=no@entry=36, len=len@entry=0x7f4122744548, heap=heap@entry=0x7f408c0b5e20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5779 #13 0x00000000005bf391 in row_sel_store_mysql_field_func (mysql_rec=mysql_rec@entry=0x7f408c037c90 "\r0\200", prebuilt=prebuilt@entry=0x7f408c03d628, rec=rec@entry=0x7f4131c98210 "\200", index=index@entry=0x7f40b4714aa8, offsets=offsets@entry=0x7f4122744710, field_no=field_no@entry=36, templ=templ@entry=0x7f408c0bf718) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2823 #14 0x00000000005bf669 in row_sel_store_mysql_rec (mysql_rec=mysql_rec@entry=0x7f408c037c90 "\r0\200", prebuilt=prebuilt@entry=0x7f408c03d628, rec=rec@entry=0x7f4131c98210 "\200", rec_clust=rec_clust@entry=0, index=index@entry=0x7f40b4714aa8, offsets=0x7f4122744710) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2953 #15 0x0000000000ad04b9 in row_search_for_mysql (buf=buf@entry=0x7f408c037c90 "\r0\200", mode=1, mode@entry=0, prebuilt=0x7f408c03d628, match_mode=match_mode@entry=0, direction=direction@entry=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:4872 #16 0x00000000009e80d0 in ha_innobase::general_fetch (this=this@entry=0x7f408c035f60, buf=buf@entry=0x7f408c037c90 "\r0\200", direction=direction@entry=1, match_mode=match_mode@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8333 #17 0x00000000009e8452 in ha_innobase::rnd_next (this=0x7f408c035f60, buf=0x7f408c037c90 "\r0\200") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8559 #18 0x00000000005e413f in handler::ha_rnd_next (this=this@entry=0x7f408c035f60, buf=buf@entry=0x7f408c037c90 "\r0\200") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2716 #19 0x0000000000c7b92a in ha_partition::rnd_next (this=0x7f408c032b60, buf=0x7f408c037c90 "\r0\200") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/ha_partition.cc:4689 #20 0x00000000005e40fa in handler::ha_rnd_next (this=0x7f408c032b60, buf=0x7f408c037c90 "\r0\200") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2716 #21 0x000000000087ca3c in rr_sequential (info=0x7f408c0427c8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/records.cc:478 #22 0x000000000070cad9 in sub_select (join=0x7f4060005ba0, join_tab=0x7f408c042738, end_of_records=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1256 #23 0x000000000070b257 in do_select (join=0x7f4060005ba0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:930 #24 JOIN::exec (this=0x7f4060005ba0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:191 #25 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x3adfa58, thd=0x3adcf10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101 #26 mysql_select (thd=thd@entry=0x3adcf10, tables=0x7f40600051a0, wild_num=1, fields=..., conds=0x0, order=order@entry=0x3adfc20, group=group@entry=0x3adfb58, having=0x0, select_options=2147748608, result=result@entry=0x7f4060005790, unit=0x3adf410, select_lex=select_lex@entry=0x3adfa58) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222 #27 0x000000000075d14d in handle_select (thd=thd@entry=0x3adcf10, result=0x7f4060005790, setup_tables_done_option=setup_tables_done_option@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:111 #28 0x00000000005abd2a in execute_sqlcom_select (thd=thd@entry=0x3adcf10, all_tables=0x7f40600051a0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5473 #29 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x3adcf10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886 #30 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3adcf10, rawbuf=, length=, parser_state=parser_state@entry=0x7f4122746550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #31 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3adcf10, packet=packet@entry=0x3ae0f51 "SELECT * FROM `table500_innodb_compressed_key_pk_parts_2_int` INTO OUTFILE '/ssd//125715/tmp/gentest1580.tmp' ", packet_length=packet_length@entry=110) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #32 0x00000000007387ab in do_command (thd=thd@entry=0x3adcf10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #33 0x00000000007d76e7 in threadpool_process_request (thd=0x3adcf10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #34 0x00000000007d891f in handle_event (connection=0x3a163b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #35 worker_main (param=param@entry=0x153d200 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #36 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f4098004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #37 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #38 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 45 (LWP 1545): +bt #0 0x000000362fa0ee53 in pread64 () from /lib64/libpthread.so.0 #1 0x0000000000a44e07 in pread (__offset=21192704, __nbytes=8192, __buf=0x7f412dab6000, __fd=85) at /usr/include/bits/unistd.h:100 #2 os_file_pread (file=file@entry=85, buf=buf@entry=0x7f412dab6000, n=n@entry=8192, offset=offset@entry=21192704, trx=trx@entry=0x7f4094032728) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2468 #3 0x0000000000a468f0 in os_file_read_func (file=85, buf=0x7f412dab6000, offset=21192704, n=8192, trx=0x7f4094032728) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:2785 #4 0x0000000000bd5f55 in pfs_os_aio_func (src_file=0xe25698 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc", src_line=5573, trx=0x7f4094032728, space_id=44, message2=0x7f40a00a06d0, message1=0x7f40d77e7258, n=8192, offset=21192704, buf=0x7f412dab6000, file=85, name=0x7f40d4171bd8 "./test/table500_innodb_compressed_key_pk_parts_2_int_autoinc#P#p0.ibd", mode=24, type=10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/os0file.ic:230 #5 _fil_io (type=type@entry=10, sync=sync@entry=true, space_id=space_id@entry=44, zip_size=zip_size@entry=8192, block_offset=, block_offset@entry=2587, byte_offset=byte_offset@entry=0, len=len@entry=8192, buf=0x7f412dab6000, message=message@entry=0x7f40a00a06d0, trx=trx@entry=0x7f4094032728) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5573 #6 0x0000000000b9374e in buf_read_page_low (err=err@entry=0x7f412280728c, sync=sync@entry=true, mode=0, mode@entry=132, space=space@entry=44, zip_size=zip_size@entry=8192, unzip=unzip@entry=0, tablespace_version=47, offset=offset@entry=2587, trx=trx@entry=0x7f4094032728) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:232 #7 0x0000000000b94d63 in buf_read_page (space=space@entry=44, zip_size=zip_size@entry=8192, offset=offset@entry=2587, trx=trx@entry=0x7f4094032728) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0rea.cc:462 #8 0x0000000000b6f8b4 in buf_page_get_zip (space=space@entry=44, zip_size=zip_size@entry=8192, offset=offset@entry=2587) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0buf.cc:2064 #9 0x0000000000b57cc4 in btr_copy_zblob_prefix (offset=12, page_no=2587, space_id=44, zip_size=8192, len=8192, buf=0x7f40a00a104b "") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5486 #10 btr_copy_externally_stored_field_prefix_low (buf=buf@entry=0x7f40a007d628 "\377\330\377", , len=len@entry=65535, zip_size=zip_size@entry=8192, space_id=space_id@entry=44, page_no=, offset=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5616 #11 0x0000000000b58110 in btr_copy_externally_stored_field (len=len@entry=0x7f4122807548, data=data@entry=0x7f412dbc4c31 "", zip_size=zip_size@entry=8192, local_len=0, local_len@entry=20, heap=heap@entry=0x7f40a00c45e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5729 #12 0x0000000000b581dd in btr_rec_copy_externally_stored_field (rec=rec@entry=0x7f412dbc4b93 "\200", offsets=offsets@entry=0x7f4122807710, zip_size=8192, no=no@entry=12, len=len@entry=0x7f4122807548, heap=heap@entry=0x7f40a00c45e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:5779 #13 0x00000000005bf391 in row_sel_store_mysql_field_func (mysql_rec=mysql_rec@entry=0x7f40a0034f10 " \"\204vwrpwzvqucvkpuhtlgjfltncoqvzahhutcybjqxrzihyebxoywopphaaontemogrkrxjiqoboircmkcsyosozeuqpqbuayjyzkkuhbziidfiqzyqxijidnuyosozeuqpqbuayjyzkkuhbkkuhbziidfiqzyqxijidnusnicxwtxqgjpclolgzasigyesgpypfbusnicxwtxqgjpclolgzasigyesgpypfbuoipvzkgsswhavu\004", prebuilt=prebuilt@entry=0x7f40a0038868, rec=rec@entry=0x7f412dbc4b93 "\200", index=index@entry=0x7f40b4714058, offsets=offsets@entry=0x7f4122807710, field_no=field_no@entry=12, templ=templ@entry=0x7f40a003aa10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2823 #14 0x00000000005bf669 in row_sel_store_mysql_rec (mysql_rec=mysql_rec@entry=0x7f40a0034f10 " \"\204vwrpwzvqucvkpuhtlgjfltncoqvzahhutcybjqxrzihyebxoywopphaaontemogrkrxjiqoboircmkcsyosozeuqpqbuayjyzkkuhbziidfiqzyqxijidnuyosozeuqpqbuayjyzkkuhbkkuhbziidfiqzyqxijidnusnicxwtxqgjpclolgzasigyesgpypfbusnicxwtxqgjpclolgzasigyesgpypfbuoipvzkgsswhavu\004", prebuilt=prebuilt@entry=0x7f40a0038868, rec=rec@entry=0x7f412dbc4b93 "\200", rec_clust=rec_clust@entry=0, index=index@entry=0x7f40b4714058, offsets=0x7f4122807710) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2953 #15 0x0000000000ad04b9 in row_search_for_mysql (buf=buf@entry=0x7f40a0034f10 " \"\204vwrpwzvqucvkpuhtlgjfltncoqvzahhutcybjqxrzihyebxoywopphaaontemogrkrxjiqoboircmkcsyosozeuqpqbuayjyzkkuhbziidfiqzyqxijidnuyosozeuqpqbuayjyzkkuhbkkuhbziidfiqzyqxijidnusnicxwtxqgjpclolgzasigyesgpypfbusnicxwtxqgjpclolgzasigyesgpypfbuoipvzkgsswhavu\004", mode=1, mode@entry=0, prebuilt=0x7f40a0038868, match_mode=match_mode@entry=0, direction=direction@entry=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:4872 #16 0x00000000009e80d0 in ha_innobase::general_fetch (this=this@entry=0x7f40a0007f10, buf=buf@entry=0x7f40a0034f10 " \"\204vwrpwzvqucvkpuhtlgjfltncoqvzahhutcybjqxrzihyebxoywopphaaontemogrkrxjiqoboircmkcsyosozeuqpqbuayjyzkkuhbziidfiqzyqxijidnuyosozeuqpqbuayjyzkkuhbkkuhbziidfiqzyqxijidnusnicxwtxqgjpclolgzasigyesgpypfbusnicxwtxqgjpclolgzasigyesgpypfbuoipvzkgsswhavu\004", direction=direction@entry=1, match_mode=match_mode@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8333 #17 0x00000000009e8452 in ha_innobase::rnd_next (this=0x7f40a0007f10, buf=0x7f40a0034f10 " \"\204vwrpwzvqucvkpuhtlgjfltncoqvzahhutcybjqxrzihyebxoywopphaaontemogrkrxjiqoboircmkcsyosozeuqpqbuayjyzkkuhbziidfiqzyqxijidnuyosozeuqpqbuayjyzkkuhbkkuhbziidfiqzyqxijidnusnicxwtxqgjpclolgzasigyesgpypfbusnicxwtxqgjpclolgzasigyesgpypfbuoipvzkgsswhavu\004") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:8559 #18 0x00000000005e413f in handler::ha_rnd_next (this=this@entry=0x7f40a0007f10, buf=buf@entry=0x7f40a0034f10 " \"\204vwrpwzvqucvkpuhtlgjfltncoqvzahhutcybjqxrzihyebxoywopphaaontemogrkrxjiqoboircmkcsyosozeuqpqbuayjyzkkuhbziidfiqzyqxijidnuyosozeuqpqbuayjyzkkuhbkkuhbziidfiqzyqxijidnusnicxwtxqgjpclolgzasigyesgpypfbusnicxwtxqgjpclolgzasigyesgpypfbuoipvzkgsswhavu\004") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2716 #19 0x0000000000c7b92a in ha_partition::rnd_next (this=0x7f40a003efa0, buf=0x7f40a0034f10 " \"\204vwrpwzvqucvkpuhtlgjfltncoqvzahhutcybjqxrzihyebxoywopphaaontemogrkrxjiqoboircmkcsyosozeuqpqbuayjyzkkuhbziidfiqzyqxijidnuyosozeuqpqbuayjyzkkuhbkkuhbziidfiqzyqxijidnusnicxwtxqgjpclolgzasigyesgpypfbusnicxwtxqgjpclolgzasigyesgpypfbuoipvzkgsswhavu\004") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/ha_partition.cc:4689 #20 0x00000000005e40fa in handler::ha_rnd_next (this=0x7f40a003efa0, buf=0x7f40a0034f10 " \"\204vwrpwzvqucvkpuhtlgjfltncoqvzahhutcybjqxrzihyebxoywopphaaontemogrkrxjiqoboircmkcsyosozeuqpqbuayjyzkkuhbziidfiqzyqxijidnuyosozeuqpqbuayjyzkkuhbkkuhbziidfiqzyqxijidnusnicxwtxqgjpclolgzasigyesgpypfbusnicxwtxqgjpclolgzasigyesgpypfbuoipvzkgsswhavu\004") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2716 #21 0x000000000087ca3c in rr_sequential (info=0x7f40a00b0650) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/records.cc:478 #22 0x000000000070cad9 in sub_select (join=0x7f40a0005c88, join_tab=0x7f40a00b05c0, end_of_records=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1256 #23 0x000000000070b257 in do_select (join=0x7f40a0005c88) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:930 #24 JOIN::exec (this=0x7f40a0005c88) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:191 #25 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x3a977b8, thd=0x3a94c70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101 #26 mysql_select (thd=thd@entry=0x3a94c70, tables=0x7f40a0005288, wild_num=1, fields=..., conds=0x0, order=order@entry=0x3a97980, group=group@entry=0x3a978b8, having=0x0, select_options=2147748608, result=result@entry=0x7f40a0005878, unit=0x3a97170, select_lex=select_lex@entry=0x3a977b8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222 #27 0x000000000075d14d in handle_select (thd=thd@entry=0x3a94c70, result=0x7f40a0005878, setup_tables_done_option=setup_tables_done_option@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:111 #28 0x00000000005abd2a in execute_sqlcom_select (thd=thd@entry=0x3a94c70, all_tables=0x7f40a0005288) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5473 #29 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x3a94c70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886 #30 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3a94c70, rawbuf=, length=, parser_state=parser_state@entry=0x7f4122809550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #31 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3a94c70, packet=packet@entry=0x3a98cb1 "SELECT * FROM `table500_innodb_compressed_key_pk_parts_2_int_autoinc` INTO OUTFILE '/ssd//125715/tmp/gentest1561.tmp' ", packet_length=packet_length@entry=118) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #32 0x00000000007387ab in do_command (thd=thd@entry=0x3a94c70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #33 0x00000000007d76e7 in threadpool_process_request (thd=0x3a94c70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #34 0x00000000007d891f in handle_event (connection=0x39f9f20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #35 worker_main (param=param@entry=0x153d000 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #36 0x00000000009bbd73 in pfs_spawn_thread (arg=0x3a12c30) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #37 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #38 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 44 (LWP 1160): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f40f35fdcc0, fast_mutex=0x38a9640, cond=0x38a9680) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x38a9640, time_in_usec=time_in_usec@entry=10000000, reset_sig_count=46, reset_sig_count@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:723 #3 0x0000000000bc7beb in dict_stats_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0stats_bg.cc:349 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 43 (LWP 1157): +bt #0 0x000000362fa0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4af68 in os_cond_wait (fast_mutex=0x3294230, cond=0x3294270) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x3294230, reset_sig_count=5098, reset_sig_count@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:610 #3 0x0000000000aedc4c in srv_worker_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:3100 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 42 (LWP 1155): +bt #0 0x000000362fa0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4af68 in os_cond_wait (fast_mutex=0x32941a0, cond=0x32941e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x32941a0, reset_sig_count=8033, reset_sig_count@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:610 #3 0x0000000000aedc4c in srv_worker_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:3100 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 41 (LWP 1550): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006985f6 in inline_mysql_cond_timedwait (src_file=0xce8d08 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc", src_line=1306, abstime=0x7f41226c2f40, mutex=0x3ae5098, that=0x3ae50c8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=this@entry=0x3ae5098, owner=0x3ae4f60, abs_timeout=abs_timeout@entry=0x7f41226c2f40, set_status_on_timeout=set_status_on_timeout@entry=false, wait_state_name=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:1306 #3 0x0000000000699e6a in MDL_context::acquire_lock (this=this@entry=0x3ae5098, mdl_request=0x7f405c0053f8, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2229 #4 0x000000000069a22b in MDL_context::acquire_locks (this=this@entry=0x3ae5098, mdl_requests=mdl_requests@entry=0x7f41226c3070, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2339 #5 0x00000000006dba38 in lock_table_names (thd=thd@entry=0x3ae4f60, tables_start=tables_start@entry=0x7f405c005058, tables_end=tables_end@entry=0x0, lock_wait_timeout=31536000, flags=flags@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:4853 #6 0x00000000008c77a1 in Sql_cmd_truncate_table::lock_table (this=this@entry=0x7f405c0055c0, thd=thd@entry=0x3ae4f60, table_ref=table_ref@entry=0x7f405c005058, hton_can_recreate=hton_can_recreate@entry=0x7f41226c338f) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_truncate.cc:344 #7 0x00000000008c7a58 in Sql_cmd_truncate_table::truncate_table (this=this@entry=0x7f405c0055c0, thd=thd@entry=0x3ae4f60, table_ref=table_ref@entry=0x7f405c005058) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_truncate.cc:444 #8 0x00000000008c7ea3 in Sql_cmd_truncate_table::execute (this=0x7f405c0055c0, thd=0x3ae4f60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_truncate.cc:519 #9 0x0000000000731411 in mysql_execute_command (thd=thd@entry=0x3ae4f60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5287 #10 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3ae4f60, rawbuf=, length=, parser_state=parser_state@entry=0x7f41226c4550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #11 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3ae4f60, packet=packet@entry=0x3ae91c1 " TRUNCATE `table500_innodb_compressed_key_pk_parts_2_int_autoinc` ", packet_length=packet_length@entry=66) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #12 0x00000000007387ab in do_command (thd=thd@entry=0x3ae4f60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #13 0x00000000007d76e7 in threadpool_process_request (thd=0x3ae4f60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #14 0x00000000007d891f in handle_event (connection=0x3a651d0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #15 worker_main (param=param@entry=0x153d400 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #16 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f4090004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #17 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 40 (LWP 1551): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=18, native_events=native_events@entry=0x7f4122680b60, maxevents=maxevents@entry=1024, timeout_ms=timeout_ms@entry=-1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:283 #2 0x00000000007d7fc2 in listener (thread_group=thread_group@entry=0x153c600 , current_thread=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:645 #3 0x00000000007d848c in get_event (current_thread=current_thread@entry=0x7f4122683d10, thread_group=thread_group@entry=0x153c600 , abstime=abstime@entry=0x7f4122683c70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1095 #4 0x00000000007d88da in worker_main (param=param@entry=0x153c600 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1517 #5 0x00000000009bbd73 in pfs_spawn_thread (arg=0x3a330f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #6 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #7 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 39 (LWP 1854): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007d8672 in inline_mysql_cond_timedwait (src_file=0xd26fa0 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc", src_line=1133, abstime=0x7f41202d8c70, mutex=0x153c800 , that=0x7f41202d8d30) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 inline_mysql_cond_timedwait (src_file=0xd26fa0 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc", src_line=1133, abstime=0x7f41202d8c70, mutex=0x153c800 , that=0x7f41202d8d30) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1064 #3 get_event (current_thread=current_thread@entry=0x7f41202d8d10, thread_group=thread_group@entry=0x153c800 , abstime=abstime@entry=0x7f41202d8c70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1133 #4 0x00000000007d88da in worker_main (param=param@entry=0x153c800 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1517 #5 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f4074052320) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #6 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #7 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 38 (LWP 1162): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007d91e6 in inline_mysql_cond_timedwait (src_file=0xd26fa0 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc", src_line=507, abstime=0x7f40f21fbd00, mutex=0x153c420 , that=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 inline_mysql_cond_timedwait (src_file=0xd26fa0 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc", src_line=507, abstime=0x7f40f21fbd00, mutex=0x153c420 , that=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:490 #3 timer_thread (param=param@entry=0x153c420 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:507 #4 0x00000000009bbd73 in pfs_spawn_thread (arg=0x3928d90) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 37 (LWP 1153): +bt #0 0x000000362f2e1533 in select () from /lib64/libc.so.6 #1 0x0000000000a4bc3f in os_thread_sleep (tm=tm@entry=1000000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0thread.cc:279 #2 0x0000000000aed2ed in srv_master_sleep () at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:2898 #3 srv_master_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:2946 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 36 (LWP 1154): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f410b5fdc90, fast_mutex=0x3293530, cond=0x3293570) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x3293530, time_in_usec=time_in_usec@entry=10000, reset_sig_count=reset_sig_count@entry=3117) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:723 #3 0x0000000000aef075 in srv_purge_coordinator_suspend (rseg_history_len=422, slot=0x32940b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:3259 #4 srv_purge_coordinator_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:3375 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 35 (LWP 1542): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006985f6 in inline_mysql_cond_timedwait (src_file=0xce8d08 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc", src_line=1306, abstime=0x7f41228caf40, mutex=0x3a84d08, that=0x3a84d38) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=this@entry=0x3a84d08, owner=0x3a84bd0, abs_timeout=abs_timeout@entry=0x7f41228caf40, set_status_on_timeout=set_status_on_timeout@entry=false, wait_state_name=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:1306 #3 0x0000000000699e6a in MDL_context::acquire_lock (this=this@entry=0x3a84d08, mdl_request=0x7f40dc00cdf8, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2229 #4 0x000000000069a22b in MDL_context::acquire_locks (this=this@entry=0x3a84d08, mdl_requests=mdl_requests@entry=0x7f41228cb070, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2339 #5 0x00000000006dba38 in lock_table_names (thd=thd@entry=0x3a84bd0, tables_start=tables_start@entry=0x7f40dc00ca58, tables_end=tables_end@entry=0x0, lock_wait_timeout=31536000, flags=flags@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:4853 #6 0x00000000008c77a1 in Sql_cmd_truncate_table::lock_table (this=this@entry=0x7f40dc00cfc0, thd=thd@entry=0x3a84bd0, table_ref=table_ref@entry=0x7f40dc00ca58, hton_can_recreate=hton_can_recreate@entry=0x7f41228cb38f) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_truncate.cc:344 #7 0x00000000008c7a58 in Sql_cmd_truncate_table::truncate_table (this=this@entry=0x7f40dc00cfc0, thd=thd@entry=0x3a84bd0, table_ref=table_ref@entry=0x7f40dc00ca58) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_truncate.cc:444 #8 0x00000000008c7ea3 in Sql_cmd_truncate_table::execute (this=0x7f40dc00cfc0, thd=0x3a84bd0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_truncate.cc:519 #9 0x0000000000731411 in mysql_execute_command (thd=thd@entry=0x3a84bd0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5287 #10 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3a84bd0, rawbuf=, length=, parser_state=parser_state@entry=0x7f41228cc550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #11 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3a84bd0, packet=packet@entry=0x3a88c11 " TRUNCATE `table500_innodb_compressed_int` ", packet_length=packet_length@entry=43) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #12 0x00000000007387ab in do_command (thd=thd@entry=0x3a84bd0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #13 0x00000000007d76e7 in threadpool_process_request (thd=0x3a84bd0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #14 0x00000000007d891f in handle_event (connection=0x39a00c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #15 worker_main (param=param@entry=0x153cc00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #16 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f40dc00c5e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #17 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 34 (LWP 1541): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=21, native_events=native_events@entry=0x7f41229cdb60, maxevents=maxevents@entry=1024, timeout_ms=timeout_ms@entry=-1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:283 #2 0x00000000007d7fc2 in listener (thread_group=thread_group@entry=0x153cc00 , current_thread=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:645 #3 0x00000000007d848c in get_event (current_thread=current_thread@entry=0x7f41229d0d10, thread_group=thread_group@entry=0x153cc00 , abstime=abstime@entry=0x7f41229d0c70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1095 #4 0x00000000007d88da in worker_main (param=param@entry=0x153cc00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1517 #5 0x00000000009bbd73 in pfs_spawn_thread (arg=0x399e9b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #6 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #7 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 33 (LWP 1158): +bt #0 0x000000362f2e1533 in select () from /lib64/libc.so.6 #1 0x0000000000a4bc3f in os_thread_sleep (tm=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0thread.cc:279 #2 0x0000000000b83b25 in page_cleaner_sleep_if_needed (next_loop_time=1386840148670) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0flu.cc:2549 #3 buf_flush_page_cleaner_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0flu.cc:2674 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 32 (LWP 1126): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=3, array=0x3292950) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=5, message1=message1@entry=0x7f4125c16d80, message2=message2@entry=0x7f4125c16d88, type=type@entry=0x7f4125c16d90, space_id=space_id@entry=0x7f4125c16d98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=5) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 31 (LWP 1152): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f4120f63d20, fast_mutex=0x32943e0, cond=0x3294420) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x32943e0, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:723 #3 0x0000000000aeb0ec in srv_monitor_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:1911 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 30 (LWP 1151): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f4121964c90, fast_mutex=0x3294350, cond=0x3294390) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x3294350, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:723 #3 0x0000000000aeb7da in srv_error_monitor_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:2173 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 29 (LWP 1169): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007d8672 in inline_mysql_cond_timedwait (src_file=0xd26fa0 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc", src_line=1133, abstime=0x7f412294ec70, mutex=0x153ca00 , that=0x7f412294ed30) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 inline_mysql_cond_timedwait (src_file=0xd26fa0 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc", src_line=1133, abstime=0x7f412294ec70, mutex=0x153ca00 , that=0x7f412294ed30) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1064 #3 get_event (current_thread=current_thread@entry=0x7f412294ed10, thread_group=thread_group@entry=0x153ca00 , abstime=abstime@entry=0x7f412294ec70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1133 #4 0x00000000007d88da in worker_main (param=param@entry=0x153ca00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1517 #5 0x00000000009bbd73 in pfs_spawn_thread (arg=0x3a330f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #6 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #7 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 28 (LWP 1156): +bt #0 0x000000362fa0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4af68 in os_cond_wait (fast_mutex=0x32942c0, cond=0x3294300) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x32942c0, reset_sig_count=2210, reset_sig_count@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:610 #3 0x0000000000aedc4c in srv_worker_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:3100 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 27 (LWP 1163): +bt #0 0x000000362fa0f2a5 in sigwait () from /lib64/libpthread.so.0 #1 0x00000000005cd5db in signal_hand (arg=arg@entry=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mysqld.cc:3257 #2 0x00000000009bbd73 in pfs_spawn_thread (arg=0x392b540) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #3 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #4 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 26 (LWP 1127): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=0, array=0x32d47f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=6, message1=message1@entry=0x7f4125215d80, message2=message2@entry=0x7f4125215d88, type=type@entry=0x7f4125215d90, space_id=space_id@entry=0x7f4125215d98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=6) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 25 (LWP 1128): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=1, array=0x32d47f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=7, message1=message1@entry=0x7f4124814d80, message2=message2@entry=0x7f4124814d88, type=type@entry=0x7f4124814d90, space_id=space_id@entry=0x7f4124814d98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=7) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 24 (LWP 1544): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=22, native_events=native_events@entry=0x7f4122847b60, maxevents=maxevents@entry=1024, timeout_ms=timeout_ms@entry=-1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:283 #2 0x00000000007d7fc2 in listener (thread_group=thread_group@entry=0x153ce00 , current_thread=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:645 #3 0x00000000007d848c in get_event (current_thread=current_thread@entry=0x7f412284ad10, thread_group=thread_group@entry=0x153ce00 , abstime=abstime@entry=0x7f412284ac70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1095 #4 0x00000000007d88da in worker_main (param=param@entry=0x153ce00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1517 #5 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f40a8004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #6 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #7 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 23 (LWP 1130): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=3, array=0x32d47f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=9, message1=message1@entry=0x7f4123412d80, message2=message2@entry=0x7f4123412d88, type=type@entry=0x7f4123412d90, space_id=space_id@entry=0x7f4123412d98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=9) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 22 (LWP 1165): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006985f6 in inline_mysql_cond_timedwait (src_file=0xce8d08 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc", src_line=1306, abstime=0x7f412298db70, mutex=0x3a73f98, that=0x3a73fc8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=this@entry=0x3a73f98, owner=0x3a73e60, abs_timeout=abs_timeout@entry=0x7f412298db70, set_status_on_timeout=set_status_on_timeout@entry=true, wait_state_name=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:1306 #3 0x0000000000699c69 in MDL_context::acquire_lock (this=this@entry=0x3a73f98, mdl_request=mdl_request@entry=0x7f4080005af8, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2245 #4 0x00000000006d5145 in open_table_get_mdl_lock (thd=thd@entry=0x3a73e60, ot_ctx=ot_ctx@entry=0x7f412298e3f0, mdl_request=mdl_request@entry=0x7f4080005af8, flags=, flags@entry=0, mdl_ticket=mdl_ticket@entry=0x7f412298de80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:2527 #5 0x00000000006d9ee0 in open_table (thd=thd@entry=0x3a73e60, table_list=table_list@entry=0x7f4080005758, ot_ctx=ot_ctx@entry=0x7f412298e3f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:2820 #6 0x00000000006e3a78 in open_and_process_table (ot_ctx=0x7f412298e3f0, has_prelocking_list=false, prelocking_strategy=0x7f412298e480, flags=0, counter=0x3a76350, tables=0x7f4080005758, lex=0x3a76298, thd=0x3a73e60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:4592 #7 open_tables (thd=thd@entry=0x3a73e60, start=start@entry=0x7f412298e478, counter=0x3a76350, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f412298e480) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:5099 #8 0x00000000006e4574 in open_normal_and_derived_tables (thd=thd@entry=0x3a73e60, tables=tables@entry=0x7f4080005758, flags=flags@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:5799 #9 0x00000000005abc54 in execute_sqlcom_select (thd=thd@entry=0x3a73e60, all_tables=0x7f4080005758) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5446 #10 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x3a73e60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886 #11 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3a73e60, rawbuf=, length=, parser_state=parser_state@entry=0x7f412298f550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #12 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3a73e60, packet=packet@entry=0x3a781d1 "SELECT `c33` < `c0`, `c14`, `c24` FROM `table500_innodb_compressed_int` WHERE `c11` IS NOT NULL ORDER BY `c22` ", packet_length=packet_length@entry=111) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #13 0x00000000007387ab in do_command (thd=thd@entry=0x3a73e60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #14 0x00000000007d76e7 in threadpool_process_request (thd=0x3a73e60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #15 0x00000000007d891f in handle_event (connection=0x3986960) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #16 worker_main (param=param@entry=0x153c800 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #17 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f40dc004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #18 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #19 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 21 (LWP 1150): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f41223eec80, fast_mutex=0x38a2aa0, cond=0x38a2ae0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=event@entry=0x38a2aa0, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=reset_sig_count@entry=2) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:723 #3 0x0000000000a21aac in lock_wait_timeout_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/lock/lock0wait.cc:503 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 20 (LWP 1125): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=2, array=0x3292950) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=4, message1=message1@entry=0x7f4126617d80, message2=message2@entry=0x7f4126617d88, type=type@entry=0x7f4126617d90, space_id=space_id@entry=0x7f4126617d98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=4) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 19 (LWP 1124): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=1, array=0x3292950) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=3, message1=message1@entry=0x7f4127018d80, message2=message2@entry=0x7f4127018d88, type=type@entry=0x7f4127018d90, space_id=space_id@entry=0x7f4127018d98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=3) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 18 (LWP 1547): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=24, native_events=native_events@entry=0x7f4122784b60, maxevents=maxevents@entry=1024, timeout_ms=timeout_ms@entry=-1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:283 #2 0x00000000007d7fc2 in listener (thread_group=thread_group@entry=0x153d200 , current_thread=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:645 #3 0x00000000007d848c in get_event (current_thread=current_thread@entry=0x7f4122787d10, thread_group=thread_group@entry=0x153d200 , abstime=abstime@entry=0x7f4122787c70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1095 #4 0x00000000007d88da in worker_main (param=param@entry=0x153d200 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1517 #5 0x00000000009bbd73 in pfs_spawn_thread (arg=0x3a37780) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #6 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #7 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 17 (LWP 1583): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006985f6 in inline_mysql_cond_timedwait (src_file=0xce8d08 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc", src_line=1306, abstime=0x7f4120398a40, mutex=0x3a9cdf8, that=0x3a9ce28) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=this@entry=0x3a9cdf8, owner=owner@entry=0x3a9ccc0, abs_timeout=abs_timeout@entry=0x7f4120398a40, set_status_on_timeout=set_status_on_timeout@entry=true, wait_state_name=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:1306 #3 0x00000000007c8c1a in TABLE_SHARE::wait_for_old_version (this=this@entry=0x7f407c010620, thd=thd@entry=0x3a9ccc0, abstime=abstime@entry=0x7f4120398a40, deadlock_weight=deadlock_weight@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/table.cc:3594 #4 0x00000000006da12f in tdc_wait_for_old_version (deadlock_weight=0, wait_timeout=, table_name=0x7f4098005570 "table500_innodb_compressed", db=, thd=0x3a9ccc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:2565 #5 open_table (thd=thd@entry=0x3a9ccc0, table_list=table_list@entry=0x7f4098005608, ot_ctx=ot_ctx@entry=0x7f4120398f80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:3069 #6 0x00000000006e3a78 in open_and_process_table (ot_ctx=0x7f4120398f80, has_prelocking_list=false, prelocking_strategy=0x7f4120399250, flags=0, counter=0x7f412039902c, tables=0x7f4098005608, lex=0x3a9f0f8, thd=0x3a9ccc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:4592 #7 open_tables (thd=thd@entry=0x3a9ccc0, start=0x3a9f108, counter=counter@entry=0x7f412039902c, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f4120399250) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:5099 #8 0x000000000078800a in open_tables (flags=0, counter=0x7f412039902c, tables=, thd=0x3a9ccc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.h:456 #9 mysql_create_like_table (thd=thd@entry=0x3a9ccc0, table=table@entry=0x7f4098004fe8, src_table=src_table@entry=0x7f4098005608, create_info=create_info@entry=0x7f412039abf0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:5265 #10 0x0000000000735b24 in mysql_execute_command (thd=thd@entry=0x3a9ccc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3389 #11 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3a9ccc0, rawbuf=, length=, parser_state=parser_state@entry=0x7f412039b550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #12 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3a9ccc0, packet=packet@entry=0x3aa0d01 " CREATE TABLE d LIKE `table500_innodb_compressed` ", packet_length=packet_length@entry=51) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #13 0x00000000007387ab in do_command (thd=thd@entry=0x3a9ccc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #14 0x00000000007d76e7 in threadpool_process_request (thd=0x3a9ccc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #15 0x00000000007d891f in handle_event (connection=0x3a10490) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #16 worker_main (param=param@entry=0x153d200 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #17 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f40e4000a10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #18 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #19 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 16 (LWP 1121): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=0, array=0x32c6d50) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=0, message1=message1@entry=0x7f4128e1bd80, message2=message2@entry=0x7f4128e1bd88, type=type@entry=0x7f4128e1bd90, space_id=space_id@entry=0x7f4128e1bd98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 15 (LWP 1161): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f40f2bfccb0, fast_mutex=0x38d2a20, cond=0x38d2a60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:177 #2 os_event_wait_time_low (event=0x38d2a20, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=reset_sig_count@entry=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:723 #3 0x0000000000b2f877 in ib_wqueue_timedwait (wq=wq@entry=0x38cb8d8, wait_in_usecs=wait_in_usecs@entry=5000000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/ut/ut0wqueue.cc:154 #4 0x0000000000bff547 in fts_optimize_thread (arg=0x38cb8d8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fts/fts0opt.cc:2972 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 14 (LWP 1129): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=2, array=0x32d47f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=8, message1=message1@entry=0x7f4123e13d80, message2=message2@entry=0x7f4123e13d88, type=type@entry=0x7f4123e13d90, space_id=space_id@entry=0x7f4123e13d98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 13 (LWP 1120): +bt #0 0x000000362f233b17 in sigwaitinfo () from /lib64/libc.so.6 #1 0x000000000097008b in timer_notify_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/mysys/posix_timers.c:78 #2 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #3 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 12 (LWP 1579): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=23, native_events=native_events@entry=0x7f412041ab60, maxevents=maxevents@entry=1024, timeout_ms=timeout_ms@entry=-1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:283 #2 0x00000000007d7fc2 in listener (thread_group=thread_group@entry=0x153d000 , current_thread=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:645 #3 0x00000000007d848c in get_event (current_thread=current_thread@entry=0x7f412041dd10, thread_group=thread_group@entry=0x153d000 , abstime=abstime@entry=0x7f412041dc70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1095 #4 0x00000000007d88da in worker_main (param=param@entry=0x153d000 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1517 #5 0x00000000009bbd73 in pfs_spawn_thread (arg=0x3ad10d0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #6 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #7 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 11 (LWP 1123): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=0, array=0x3292950) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=2, message1=message1@entry=0x7f4127a19d80, message2=message2@entry=0x7f4127a19d88, type=type@entry=0x7f4127a19d90, space_id=space_id@entry=0x7f4127a19d98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=2) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 10 (LWP 1170): +bt #0 0x000000362fa0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4af68 in os_cond_wait (fast_mutex=0x38b72a0, cond=0x38b72e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=event@entry=0x38b72a0, reset_sig_count=170) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:610 #3 0x0000000000af6439 in sync_array_wait_event (arr=0x32929f0, index=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0arr.cc:433 #4 0x0000000000afb49d in mutex_spin_wait (_mutex=0x38b7198, high_priority=false, file_name=file_name@entry=0xe1ff88 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0dict.cc", line=line@entry=479) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0sync.cc:670 #5 0x0000000000ba1534 in mutex_enter_func (mutex=, line=line@entry=479, priority=DEFAULT_PRIO, file_name=0xe1ff88 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0dict.cc") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0sync.ic:316 #6 0x0000000000ba1608 in pfs_mutex_enter_func (mutex=0x38b7198, line=line@entry=479, priority=DEFAULT_PRIO, file_name=0xe1ff88 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0dict.cc") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0sync.ic:382 #7 0x0000000000ba35d1 in dict_table_close (table=0x7f407c0662f8, dict_locked=dict_locked@entry=0, try_drop=try_drop@entry=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0dict.cc:479 #8 0x0000000000aaadd5 in row_prebuilt_free (prebuilt=0x7f40d8bb98a8, dict_locked=dict_locked@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0mysql.cc:894 #9 0x00000000009d657a in ha_innobase::close (this=0x7f4078005258) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:5600 #10 0x00000000005e3719 in handler::ha_close (this=this@entry=0x7f4078005258) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2599 #11 0x000000000076cb17 in store_temporary_table_record (thd=thd@entry=0x3aacd60, table=0x7f40da4134a0, db=, tmp_table=0x7f407c09e6e0, tmp_table=0x7f407c09e6e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_show.cc:3993 #12 0x000000000076cdce in fill_global_temporary_tables (thd=thd@entry=0x3a7cb80, tables=tables@entry=0x7f40da15a578, cond=cond@entry=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_show.cc:4049 #13 0x000000000076cfc7 in fill_temporary_tables (thd=thd@entry=0x3a7cb80, tables=tables@entry=0x7f40da15a578, cond=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_show.cc:4082 #14 0x0000000000775889 in do_fill_table (join_table=0x7f40da423678, table_list=0x7f40da15a578, thd=0x3a7cb80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_show.cc:7727 #15 get_schema_tables_result (join=join@entry=0x7f40da15b988, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_show.cc:7828 #16 0x000000000075360d in JOIN::prepare_result (this=this@entry=0x7f40da15b988, columns_list=columns_list@entry=0x7f412290c230) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:824 #17 0x000000000070b0d8 in JOIN::exec (this=0x7f40da15b988) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:116 #18 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x3a7f6c8, thd=0x3a7cb80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101 #19 mysql_select (thd=thd@entry=0x3a7cb80, tables=0x7f40da15a578, wild_num=1, fields=..., conds=0x0, order=order@entry=0x3a7f890, group=group@entry=0x3a7f7c8, having=0x0, select_options=2684619520, result=result@entry=0x7f40da15b960, unit=0x3a7f080, select_lex=select_lex@entry=0x3a7f6c8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222 #20 0x000000000075d14d in handle_select (thd=thd@entry=0x3a7cb80, result=0x7f40da15b960, setup_tables_done_option=setup_tables_done_option@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:111 #21 0x00000000005abd2a in execute_sqlcom_select (thd=thd@entry=0x3a7cb80, all_tables=0x7f40da15a578) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5473 #22 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x3a7cb80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886 #23 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3a7cb80, rawbuf=, length=, parser_state=parser_state@entry=0x7f412290d550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #24 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3a7cb80, packet=packet@entry=0x3a80bc1 "SELECT * FROM INFORMATION_SCHEMA.TEMPORARY_TABLES LIMIT 9", packet_length=packet_length@entry=57) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #25 0x00000000007387ab in do_command (thd=thd@entry=0x3a7cb80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #26 0x00000000007d76e7 in threadpool_process_request (thd=0x3a7cb80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #27 0x00000000007d891f in handle_event (connection=0x3a442c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #28 worker_main (param=param@entry=0x153ca00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #29 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f40d4004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #30 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #31 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 9 (LWP 1585): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006985f6 in inline_mysql_cond_timedwait (src_file=0xce8d08 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc", src_line=1306, abstime=0x7f4120318430, mutex=0x3abcf38, that=0x3abcf68) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=this@entry=0x3abcf38, owner=owner@entry=0x3abce00, abs_timeout=abs_timeout@entry=0x7f4120318430, set_status_on_timeout=set_status_on_timeout@entry=true, wait_state_name=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:1306 #3 0x00000000007c8c1a in TABLE_SHARE::wait_for_old_version (this=0x7f407c010620, thd=thd@entry=0x3abce00, abstime=abstime@entry=0x7f4120318430, deadlock_weight=deadlock_weight@entry=100) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/table.cc:3594 #4 0x00000000006e2754 in close_cached_tables (thd=thd@entry=0x3abce00, tables=tables@entry=0x0, wait_for_refresh=wait_for_refresh@entry=true, timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:1040 #5 0x000000000074c6bb in reload_acl_and_cache (thd=thd@entry=0x3abce00, options=4, tables=tables@entry=0x0, write_to_binlog=write_to_binlog@entry=0x7f41203185d8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_reload.cc:275 #6 0x000000000073148e in mysql_execute_command (thd=thd@entry=0x3abce00) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:4537 #7 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3abce00, rawbuf=, length=, parser_state=parser_state@entry=0x7f4120319550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #8 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3abce00, packet=packet@entry=0x3ac0e41 "FLUSH TABLES", packet_length=packet_length@entry=12) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #9 0x00000000007387ab in do_command (thd=thd@entry=0x3abce00) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #10 0x00000000007d76e7 in threadpool_process_request (thd=0x3abce00) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #11 0x00000000007d891f in handle_event (connection=0x39f30f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #12 worker_main (param=param@entry=0x153ca00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #13 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f40e4000ed0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #14 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #15 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 8 (LWP 1159): +bt #0 0x000000362fa0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4af68 in os_cond_wait (fast_mutex=0x3294470, cond=0x32944b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x3294470, reset_sig_count=1, reset_sig_count@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:610 #3 0x0000000000b7b77c in buf_dump_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/buf/buf0dump.cc:594 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 7 (LWP 1122): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=0, array=0x32b92b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5081 #2 os_aio_linux_handle (global_seg=global_seg@entry=1, message1=message1@entry=0x7f412841ad80, message2=message2@entry=0x7f412841ad88, type=type@entry=0x7f412841ad90, space_id=space_id@entry=0x7f412841ad98) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0file.cc:5226 #3 0x0000000000bd5837 in fil_aio_wait (segment=segment@entry=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/fil/fil0fil.cc:5631 #4 0x0000000000af0f38 in io_handler_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0start.cc:490 #5 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 6 (LWP 1582): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=25, native_events=native_events@entry=0x7f41203d9b60, maxevents=maxevents@entry=1024, timeout_ms=timeout_ms@entry=-1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:283 #2 0x00000000007d7fc2 in listener (thread_group=thread_group@entry=0x153d400 , current_thread=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:645 #3 0x00000000007d848c in get_event (current_thread=current_thread@entry=0x7f41203dcd10, thread_group=thread_group@entry=0x153d400 , abstime=abstime@entry=0x7f41203dcc70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1095 #4 0x00000000007d88da in worker_main (param=param@entry=0x153d400 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1517 #5 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f40e4000a10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #6 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #7 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 5 (LWP 1118): +bt #0 0x000000362f2df293 in poll () from /lib64/libc.so.6 #1 0x00000000005cf8b2 in handle_connections_sockets () at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mysqld.cc:6395 #2 0x00000000005d628e in mysqld_main (argc=74, argv=0x3195228) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mysqld.cc:5804 #3 0x000000362f21ecdd in __libc_start_main () from /lib64/libc.so.6 #4 0x00000000005ca161 in _start () Thread 4 (LWP 1569): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006985f6 in inline_mysql_cond_timedwait (src_file=0xce8d08 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc", src_line=1306, abstime=0x7f412049db10, mutex=0x3ac4f88, that=0x3ac4fb8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=this@entry=0x3ac4f88, owner=0x3ac4e50, abs_timeout=abs_timeout@entry=0x7f412049db10, set_status_on_timeout=set_status_on_timeout@entry=true, wait_state_name=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:1306 #3 0x0000000000699c69 in MDL_context::acquire_lock (this=this@entry=0x3ac4f88, mdl_request=mdl_request@entry=0x7f406c005430, lock_wait_timeout=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2245 #4 0x00000000006d5145 in open_table_get_mdl_lock (thd=thd@entry=0x3ac4e50, ot_ctx=ot_ctx@entry=0x7f412049e390, mdl_request=mdl_request@entry=0x7f406c005430, flags=, flags@entry=0, mdl_ticket=mdl_ticket@entry=0x7f412049de20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:2527 #5 0x00000000006d9ee0 in open_table (thd=thd@entry=0x3ac4e50, table_list=table_list@entry=0x7f406c005090, ot_ctx=ot_ctx@entry=0x7f412049e390) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:2820 #6 0x00000000006e3a78 in open_and_process_table (ot_ctx=0x7f412049e390, has_prelocking_list=false, prelocking_strategy=0x7f412049e420, flags=0, counter=0x3ac7340, tables=0x7f406c005090, lex=0x3ac7288, thd=0x3ac4e50) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:4592 #7 open_tables (thd=thd@entry=0x3ac4e50, start=start@entry=0x7f412049e418, counter=0x3ac7340, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f412049e420) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:5099 #8 0x00000000006e4574 in open_normal_and_derived_tables (thd=thd@entry=0x3ac4e50, tables=tables@entry=0x7f406c005090, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:5799 #9 0x00000000007a2f6f in mysql_multi_update_prepare (thd=thd@entry=0x3ac4e50) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_update.cc:1340 #10 0x000000000073160e in mysql_execute_command (thd=thd@entry=0x3ac4e50) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3660 #11 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3ac4e50, rawbuf=, length=, parser_state=parser_state@entry=0x7f412049f550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #12 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3ac4e50, packet=packet@entry=0x3ac91c1 "UPDATE LOW_PRIORITY `table500_innodb_default_int` t1, `table500_innodb_default_int_autoinc` t2 SET t1.`c4` = '2001-05-04 11:29:11.031620' WHERE t1.`pk` = 0", packet_length=packet_length@entry=156) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #13 0x00000000007387ab in do_command (thd=thd@entry=0x3ac4e50) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #14 0x00000000007d76e7 in threadpool_process_request (thd=0x3ac4e50) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #15 0x00000000007d891f in handle_event (connection=0x3928a40) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #16 worker_main (param=param@entry=0x153cc00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #17 0x00000000009bbd73 in pfs_spawn_thread (arg=0x3a77dd0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #18 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #19 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 3 (LWP 1577): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006985f6 in inline_mysql_cond_timedwait (src_file=0xce8d08 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc", src_line=1306, abstime=0x7f412045d430, mutex=0x3acd468, that=0x3acd498) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 MDL_wait::timed_wait (this=this@entry=0x3acd468, owner=owner@entry=0x3acd330, abs_timeout=abs_timeout@entry=0x7f412045d430, set_status_on_timeout=set_status_on_timeout@entry=true, wait_state_name=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:1306 #3 0x00000000007c8c1a in TABLE_SHARE::wait_for_old_version (this=0x7f4058046650, thd=thd@entry=0x3acd330, abstime=abstime@entry=0x7f412045d430, deadlock_weight=deadlock_weight@entry=100) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/table.cc:3594 #4 0x00000000006e2754 in close_cached_tables (thd=thd@entry=0x3acd330, tables=tables@entry=0x7f4070005018, wait_for_refresh=wait_for_refresh@entry=true, timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:1040 #5 0x000000000074c6bb in reload_acl_and_cache (thd=thd@entry=0x3acd330, options=4, tables=tables@entry=0x7f4070005018, write_to_binlog=write_to_binlog@entry=0x7f412045d5d8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_reload.cc:275 #6 0x000000000073148e in mysql_execute_command (thd=thd@entry=0x3acd330) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:4537 #7 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3acd330, rawbuf=, length=, parser_state=parser_state@entry=0x7f412045e550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #8 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3acd330, packet=packet@entry=0x3ad1371 "FLUSH TABLE `table100_innodb_dynamic_key_pk_parts_2_int`", packet_length=packet_length@entry=56) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #9 0x00000000007387ab in do_command (thd=thd@entry=0x3acd330) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #10 0x00000000007d76e7 in threadpool_process_request (thd=0x3acd330) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #11 0x00000000007d891f in handle_event (connection=0x39ba560) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #12 worker_main (param=param@entry=0x153ce00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #13 0x00000000009bbd73 in pfs_spawn_thread (arg=0x3ac8e10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #14 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #15 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 2 (LWP 1566): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=19, native_events=native_events@entry=0x7f41204ddb60, maxevents=maxevents@entry=1024, timeout_ms=timeout_ms@entry=-1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:283 #2 0x00000000007d7fc2 in listener (thread_group=thread_group@entry=0x153c800 , current_thread=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:645 #3 0x00000000007d848c in get_event (current_thread=current_thread@entry=0x7f41204e0d10, thread_group=thread_group@entry=0x153c800 , abstime=abstime@entry=0x7f41204e0c70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1095 #4 0x00000000007d88da in worker_main (param=param@entry=0x153c800 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1517 #5 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f4074004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #6 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #7 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 1 (LWP 1552): +bt #0 0x000000362fa0c69c in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000006a649f in handle_fatal_signal (sig=6) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/signal_handler.cc:254 #2 #3 0x000000362f2328e5 in raise () from /lib64/libc.so.6 #4 0x000000362f2340c5 in abort () from /lib64/libc.so.6 #5 0x000000362f22ba0e in __assert_fail_base () from /lib64/libc.so.6 #6 0x000000362f22bad0 in __assert_fail () from /lib64/libc.so.6 #7 0x00000000005e35ec in ha_thd (this=0x7f407c0011f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2468 #8 handler::ha_thd (this=0x7f407c0011f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2466 #9 0x00000000005edc31 in handler::mark_trx_read_write (this=0x7f407c0011f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:4124 #10 0x00000000005eb218 in handler::ha_write_row (this=0x7f407c0011f0, buf=0x7f407c002f20 "\001") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:7469 #11 0x00000000005ad762 in copy_data_between_tables (from=from@entry=0x7f407c1ad7f0, to=to@entry=0x7f407c09e6e0, create=..., ignore=ignore@entry=false, order_num=order_num@entry=0, order=order@entry=0x0, copied=copied@entry=0x7f412263f4c0, deleted=deleted@entry=0x7f412263f4c8, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=alter_ctx@entry=0x7f41226400c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:9025 #12 0x000000000078b744 in mysql_alter_table (thd=thd@entry=0x3aacd60, new_db=new_db@entry=0x0, new_name=0x7f407c09e6e0 "\260\357\t|@\177", new_name@entry=0x0, create_info=create_info@entry=0x7f4122640cb0, table_list=table_list@entry=0x7f4088005058, alter_info=0x7f407c09e6e0, alter_info@entry=0x7f4122640bf0, order_num=order_num@entry=0, order=order@entry=0x0, ignore=ignore@entry=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:8553 #13 0x000000000078c9bf in mysql_recreate_table (thd=thd@entry=0x3aacd60, table_list=table_list@entry=0x7f4088005058) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:9144 #14 0x0000000000884dfd in mysql_admin_table(THD *, TABLE_LIST *, HA_CHECK_OPT *, const char *, thr_lock_type, bool, bool, uint, int (*)(THD *, TABLE_LIST *, HA_CHECK_OPT *), struct {...}, int (*)(THD *, TABLE_LIST *)) (thd=thd@entry=0x3aacd60, tables=tables@entry=0x7f4088005058, check_opt=0x3aaff70, operator_name=operator_name@entry=0xd94c0a "optimize", lock_type=lock_type@entry=TL_WRITE, open_for_modify=false, open_for_modify@entry=true, repair_table_use_frm=repair_table_use_frm@entry=false, extra_open_options=extra_open_options@entry=0, prepare_func=prepare_func@entry=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x5e6cd0 , view_operator_func=view_operator_func@entry=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_admin.cc:783 #15 0x000000000088575c in Sql_cmd_optimize_table::execute (this=, thd=0x3aacd60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_admin.cc:1109 #16 0x0000000000731411 in mysql_execute_command (thd=thd@entry=0x3aacd60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5287 #17 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x3aacd60, rawbuf=, length=, parser_state=parser_state@entry=0x7f4122642550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #18 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3aacd60, packet=packet@entry=0x3ab0da1 "", packet_length=packet_length@entry=43) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #19 0x00000000007387ab in do_command (thd=thd@entry=0x3aacd60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #20 0x00000000007d76e7 in threadpool_process_request (thd=0x3aacd60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #21 0x00000000007d891f in handle_event (connection=0x39b9f80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #22 worker_main (param=param@entry=0x153c600 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #23 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f4088004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #24 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #25 0x000000362f2e894d in clone () from /lib64/libc.so.6 (gdb) +set logging off