(gdb) +thread apply all bt Thread 67 (LWP 30928): +bt #0 0x000000362fa0ec0d in fsync () from /lib64/libpthread.so.0 #1 0x0000000000966486 in my_sync (fd=fd@entry=113, my_flags=my_flags@entry=48) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/mysys/my_sync.c:76 #2 0x0000000000966673 in my_sync_dir (dir_name=dir_name@entry=0x7f386c1eb9f0 "./query030866/", my_flags=my_flags@entry=16) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/mysys/my_sync.c:146 #3 0x0000000000966722 in my_sync_dir_by_file (file_name=, my_flags=16) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/mysys/my_sync.c:186 #4 0x00000000007d6e61 in mysql_create_frm (thd=thd@entry=0x2ce2190, file_name=file_name@entry=0x7f386c1ecc10 "./query030866/t1.frm", db=db@entry=0x7f37b403e9a8 "query030866", table=table@entry=0x7f37b403e9b8 "t1", create_info=create_info@entry=0x7f386c1ee170, create_fields=..., keys=keys@entry=6, key_info=key_info@entry=0x7f37b4040380, db_file=db_file@entry=0x7f37b402b5c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/unireg.cc:446 #5 0x00000000007d6f6f in rea_create_table (thd=thd@entry=0x2ce2190, path=path@entry=0x7f386c1eddb0 "./query030866/t1", db=db@entry=0x7f37b403e9a8 "query030866", table_name=table_name@entry=0x7f37b403e9b8 "t1", create_info=create_info@entry=0x7f386c1ee170, create_fields=..., keys=6, key_info=0x7f37b4040380, file=file@entry=0x7f37b402b5c0, no_ha_table=no_ha_table@entry=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/unireg.cc:512 #6 0x00000000007853f4 in create_table_impl (thd=thd@entry=0x2ce2190, db=db@entry=0x7f37b403e9a8 "query030866", table_name=table_name@entry=0x7f37b403e9b8 "t1", path=path@entry=0x7f386c1eddb0 "./query030866/t1", create_info=create_info@entry=0x7f386c1ee170, alter_info=alter_info@entry=0x7f386c1ee0b0, internal_tmp_table=internal_tmp_table@entry=false, select_field_count=select_field_count@entry=0, no_ha_table=no_ha_table@entry=false, is_trans=is_trans@entry=0x7f386c1ee02b, key_info=0x7f386c1edda8, key_count=key_count@entry=0x7f386c1edda4) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:4867 #7 0x0000000000785a2a in mysql_create_table_no_lock (thd=thd@entry=0x2ce2190, db=0x7f37b403e9a8 "query030866", table_name=0x7f37b403e9b8 "t1", create_info=create_info@entry=0x7f386c1ee170, alter_info=alter_info@entry=0x7f386c1ee0b0, select_field_count=select_field_count@entry=0, is_trans=is_trans@entry=0x7f386c1ee02b) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:4977 #8 0x00000000007881a7 in mysql_create_like_table (thd=thd@entry=0x2ce2190, table=table@entry=0x7f37b403e9f0, src_table=src_table@entry=0x7f37b403ef98, create_info=create_info@entry=0x7f386c1efbf0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:5310 #9 0x0000000000735b24 in mysql_execute_command (thd=thd@entry=0x2ce2190) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3389 #10 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2ce2190, rawbuf=, length=, parser_state=parser_state@entry=0x7f386c1f0550) 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=0x2ce2190, packet=packet@entry=0x2cc5d31 "CREATE TABLE query030866 . t1 LIKE test . `CC`", packet_length=packet_length@entry=46) 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=0x2ce2190) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #13 0x00000000007d76e7 in threadpool_process_request (thd=0x2ce2190) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #14 0x00000000007d891f in handle_event (connection=0x2bd4ef0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #15 worker_main (param=param@entry=0x153d000 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #16 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f384c000a10) 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 66 (LWP 30931): +bt #0 0x000000362fa0ec0d in fsync () from /lib64/libpthread.so.0 #1 0x0000000000966486 in my_sync (fd=104, my_flags=16) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/mysys/my_sync.c:76 #2 0x00000000007d6e35 in inline_mysql_file_sync (src_file=0xd26a18 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/unireg.cc", src_line=445, flags=16, fd=104) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_file.h:1452 #3 mysql_create_frm (thd=thd@entry=0x2d3b970, file_name=file_name@entry=0x7f386c1ad0d0 "./test/trigger130899.frm", db=db@entry=0x7f37d0005400 "test", table=table@entry=0x7f37d0004e58 "trigger130899", create_info=create_info@entry=0x7f386c1aebf0, create_fields=..., keys=keys@entry=0, key_info=key_info@entry=0x7f37d0005728, db_file=db_file@entry=0x7f37b8001d80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/unireg.cc:445 #4 0x00000000007d6f6f in rea_create_table (thd=thd@entry=0x2d3b970, path=path@entry=0x7f386c1ae270 "./test/trigger130899", db=db@entry=0x7f37d0005400 "test", table_name=table_name@entry=0x7f37d0004e58 "trigger130899", create_info=create_info@entry=0x7f386c1aebf0, create_fields=..., keys=0, key_info=0x7f37d0005728, file=file@entry=0x7f37b8001d80, no_ha_table=no_ha_table@entry=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/unireg.cc:512 #5 0x00000000007853f4 in create_table_impl (thd=thd@entry=0x2d3b970, db=db@entry=0x7f37d0005400 "test", table_name=table_name@entry=0x7f37d0004e58 "trigger130899", path=path@entry=0x7f386c1ae270 "./test/trigger130899", create_info=create_info@entry=0x7f386c1aebf0, alter_info=alter_info@entry=0x7f386c1ae690, internal_tmp_table=internal_tmp_table@entry=false, select_field_count=select_field_count@entry=0, no_ha_table=no_ha_table@entry=false, is_trans=is_trans@entry=0x7f386c1ae4db, key_info=0x7f386c1ae268, key_count=key_count@entry=0x7f386c1ae264) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:4867 #6 0x0000000000785a2a in mysql_create_table_no_lock (thd=thd@entry=0x2d3b970, db=0x7f37d0005400 "test", table_name=0x7f37d0004e58 "trigger130899", create_info=create_info@entry=0x7f386c1aebf0, alter_info=alter_info@entry=0x7f386c1ae690, select_field_count=select_field_count@entry=0, is_trans=is_trans@entry=0x7f386c1ae4db) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:4977 #7 0x0000000000785b66 in mysql_create_table (thd=thd@entry=0x2d3b970, create_table=create_table@entry=0x7f37d0004ea0, create_info=create_info@entry=0x7f386c1aebf0, alter_info=alter_info@entry=0x7f386c1ae690) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:5027 #8 0x0000000000735db0 in mysql_execute_command (thd=thd@entry=0x2d3b970) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3395 #9 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2d3b970, rawbuf=, length=, parser_state=parser_state@entry=0x7f386c1af550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #10 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2d3b970, packet=packet@entry=0x2d3f391 "CREATE TABLE IF NOT EXISTS trigger130899 (f1 INTEGER)", packet_length=packet_length@entry=53) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #11 0x00000000007387ab in do_command (thd=thd@entry=0x2d3b970) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #12 0x00000000007d76e7 in threadpool_process_request (thd=0x2d3b970) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #13 0x00000000007d891f in handle_event (connection=0x2c2abc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #14 worker_main (param=param@entry=0x153d200 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #15 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f384c000d70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #16 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 65 (LWP 30914): +bt #0 0x000000362fa0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000362fa0a864 in pthread_rwlock_rdlock () from /lib64/libpthread.so.0 #2 0x0000000000c85640 in read_lock_stack (cs=, cs=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/dbug/dbug.c:418 #3 read_lock_stack (cs=0x7f37fc004dc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/dbug/dbug.c:1298 #4 _db_return_ (_line_=_line_@entry=80, _stack_frame_=_stack_frame_@entry=0x7f386c2b1f20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/dbug/dbug.c:1312 #5 0x00000000009cdd74 in heap_write (info=0x7f37c4033ea0, record=0x7f37c403cae8 "\375\001r", '\217' , "\377") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/heap/hp_write.c:80 #6 0x00000000009c78aa in ha_heap::write_row (this=0x7f37c40373f0, buf=0x7f37c403cae8 "\375\001r", '\217' , "\377") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/heap/ha_heap.cc:241 #7 0x00000000005eb2e7 in handler::ha_write_row (this=0x7f37c40373f0, buf=0x7f37c403cae8 "\375\001r", '\217' , "\377") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:7471 #8 0x000000000079c7a4 in send_data (values=..., this=0x7f37fc00d740) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_union.cc:97 #9 select_union::send_data (this=0x7f37fc00d740, values=...) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_union.cc:85 #10 0x0000000000710610 in end_send (join=0x7f37fc00d800, join_tab=0x7f37c403fef8, end_of_records=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:2775 #11 0x000000000070c79c in evaluate_join_record (join=join@entry=0x7f37fc00d800, join_tab=join_tab@entry=0x7f37c403fbf8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1598 #12 0x000000000070cb1f in sub_select (join=0x7f37fc00d800, join_tab=0x7f37c403fbf8, end_of_records=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1273 #13 0x000000000070b257 in do_select (join=0x7f37fc00d800) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:930 #14 JOIN::exec (this=0x7f37fc00d800) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:191 #15 0x000000000079d863 in st_select_lex_unit::exec (this=this@entry=0x2d0cca0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_union.cc:715 #16 0x000000000079eb28 in mysql_union (thd=thd@entry=0x2d0a7a0, lex=lex@entry=0x2d0cbd8, result=result@entry=0x7f37fc00d718, unit=unit@entry=0x2d0cca0, setup_tables_done_option=setup_tables_done_option@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_union.cc:65 #17 0x000000000075cff7 in handle_select (thd=thd@entry=0x2d0a7a0, result=0x7f37fc00d718, 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:92 #18 0x00000000005abd2a in execute_sqlcom_select (thd=thd@entry=0x2d0a7a0, all_tables=0x7f37fc00c3d0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5473 #19 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x2d0a7a0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886 #20 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2d0a7a0, rawbuf=, length=, parser_state=parser_state@entry=0x7f386c2b3550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #21 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2d0a7a0, packet=packet@entry=0x2d0eb11 "( SELECT `col_varchar_key` FROM `C` ) UNION ALL ( SELECT `col_varchar_key` FROM `C` ) /* TRANSFORM_OUTCOME_SUPERSET */", packet_length=packet_length@entry=118) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #22 0x00000000007387ab in do_command (thd=thd@entry=0x2d0a7a0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #23 0x00000000007d76e7 in threadpool_process_request (thd=0x2d0a7a0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #24 0x00000000007d891f in handle_event (connection=0x2be6d10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #25 worker_main (param=param@entry=0x153d400 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #26 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f384c000d70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #27 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #28 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 64 (LWP 30898): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=17, native_events=native_events@entry=0x7f3874075b60, 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=0x7f3874078d10, thread_group=thread_group@entry=0x153cc00 , abstime=abstime@entry=0x7f3874078c70) 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=0x7f384c000a10) 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 63 (LWP 30847): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=14, native_events=native_events@entry=0x7f38741bab60, 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=0x7f38741bdd10, thread_group=thread_group@entry=0x153c600 , abstime=abstime@entry=0x7f38741bdc70) 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=0x7f37f4004bc0) 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 62 (LWP 30937): +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=0x7f386c0e92c0, mutex=0x2ca18f8, that=0x2ca1928) 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=0x2ca18f8, owner=0x2ca17c0, abs_timeout=abs_timeout@entry=0x7f386c0e92c0, 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=0x2ca18f8, mdl_request=mdl_request@entry=0x7f386c0e93a0, 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 0x000000000069a4c4 in MDL_context::upgrade_shared_lock (this=this@entry=0x2ca18f8, mdl_ticket=0x7f37a4033810, new_type=new_type@entry=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2410 #5 0x00000000006e1e32 in wait_while_table_is_used (thd=thd@entry=0x2ca17c0, table=table@entry=0x7f37a402feb0, function=function@entry=HA_EXTRA_FORCE_REOPEN) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:2226 #6 0x0000000000789e64 in simple_rename_or_index_change (alter_ctx=0x7f386c0ea2c0, keys_onoff=Alter_info::ENABLE, table_list=0x7f37a403d128, thd=0x2ca17c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:7573 #7 mysql_alter_table (thd=thd@entry=0x2ca17c0, new_db=, new_name=0x7f37a4033810 "PK>\001", create_info=create_info@entry=0x7f386c0eaed0, table_list=table_list@entry=0x7f37a403d128, alter_info=alter_info@entry=0x7f386c0eae10, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:8074 #8 0x0000000000886a78 in Sql_cmd_alter_table::execute (this=, thd=0x2ca17c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_alter.cc:317 #9 0x0000000000731411 in mysql_execute_command (thd=thd@entry=0x2ca17c0) 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=0x2ca17c0, rawbuf=rawbuf@entry=0x7f37f4004f3e "ALTER TABLE C ENABLE KEYS; ALTER TABLE CC ENABLE KEYS; ALTER TABLE D ENABLE KEYS; ALTER TABLE DD ENABLE KEYS; ALTER TABLE E ENABLE KEYS", length=length@entry=135, parser_state=parser_state@entry=0x7f386c0ec550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #11 0x0000000000737b8e in dispatch_command (command=, command@entry=COM_QUERY, thd=thd@entry=0x2ca17c0, packet=0x4
, packet@entry=0x2ca5801 "", packet_length=packet_length@entry=245) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1513 #12 0x00000000007387ab in do_command (thd=thd@entry=0x2ca17c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #13 0x00000000007d76e7 in threadpool_process_request (thd=0x2ca17c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #14 0x00000000007d891f in handle_event (connection=0x2bcf7e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #15 worker_main (param=param@entry=0x153c600 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #16 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f37f40472c0) 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 61 (LWP 31564): +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=0x7f3859ff3c70, mutex=0x153c800 , that=0x7f3859ff3d30) 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=0x7f3859ff3c70, mutex=0x153c800 , that=0x7f3859ff3d30) 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=0x7f3859ff3d10, thread_group=thread_group@entry=0x153c800 , abstime=abstime@entry=0x7f3859ff3c70) 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=0x7f37bc0356f0) 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 60 (LWP 30851): +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=0x7f387417cc70, mutex=0x153c800 , that=0x7f387417cd30) 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=0x7f387417cc70, mutex=0x153c800 , that=0x7f387417cd30) 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=0x7f387417cd10, thread_group=thread_group@entry=0x153c800 , abstime=abstime@entry=0x7f387417cc70) 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=0x7f384400c5e0) 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 59 (LWP 30867): +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=0x7f38740fac70, mutex=0x153ce00 , that=0x7f38740fad30) 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=0x7f38740fac70, mutex=0x153ce00 , that=0x7f38740fad30) 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=0x7f38740fad10, thread_group=thread_group@entry=0x153ce00 , abstime=abstime@entry=0x7f38740fac70) 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=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=0x2c6e5e0) 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 58 (LWP 31012): +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=0x7f385a0f7c70, mutex=0x153cc00 , that=0x7f385a0f7d30) 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=0x7f385a0f7c70, mutex=0x153cc00 , that=0x7f385a0f7d30) 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=0x7f385a0f7d10, thread_group=thread_group@entry=0x153cc00 , abstime=abstime@entry=0x7f385a0f7c70) 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=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=0x2d1eb10) 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 57 (LWP 31017): +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=0x7f385a075c70, mutex=0x153d200 , that=0x7f385a075d30) 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=0x7f385a075c70, mutex=0x153d200 , that=0x7f385a075d30) 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=0x7f385a075d10, thread_group=thread_group@entry=0x153d200 , abstime=abstime@entry=0x7f385a075c70) 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=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=0x7f37b8001950) 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 56 (LWP 30744): +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=54, argv=0x2394188) 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 55 (LWP 30822): +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=0x7f3875d242c0, mutex=0x2c89808, that=0x2c89838) 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=0x2c89808, owner=0x2c896d0, abs_timeout=abs_timeout@entry=0x7f3875d242c0, 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=0x2c89808, mdl_request=mdl_request@entry=0x7f3875d243a0, 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 0x000000000069a4c4 in MDL_context::upgrade_shared_lock (this=this@entry=0x2c89808, mdl_ticket=0x7f381c03c1c0, new_type=new_type@entry=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2410 #5 0x00000000006e1e32 in wait_while_table_is_used (thd=thd@entry=0x2c896d0, table=table@entry=0x7f381c0385d0, function=function@entry=HA_EXTRA_FORCE_REOPEN) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:2226 #6 0x0000000000789e64 in simple_rename_or_index_change (alter_ctx=0x7f3875d252c0, keys_onoff=Alter_info::DISABLE, table_list=0x7f381c039208, thd=0x2c896d0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:7573 #7 mysql_alter_table (thd=thd@entry=0x2c896d0, new_db=, new_name=0x7f381c03c1c0 "PK>\001", create_info=create_info@entry=0x7f3875d25ed0, table_list=table_list@entry=0x7f381c039208, alter_info=alter_info@entry=0x7f3875d25e10, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:8074 #8 0x0000000000886a78 in Sql_cmd_alter_table::execute (this=, thd=0x2c896d0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_alter.cc:317 #9 0x0000000000731411 in mysql_execute_command (thd=thd@entry=0x2c896d0) 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=0x2c896d0, rawbuf=rawbuf@entry=0x7f381c004fdd "ALTER TABLE E DISABLE KEYS", length=length@entry=26, parser_state=parser_state@entry=0x7f3875d27550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #11 0x0000000000737b8e in dispatch_command (command=, command@entry=COM_QUERY, thd=thd@entry=0x2c896d0, packet=0x4
, packet@entry=0x2c8d711 "", packet_length=packet_length@entry=295) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1513 #12 0x00000000007387ab in do_command (thd=thd@entry=0x2c896d0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #13 0x00000000007d76e7 in threadpool_process_request (thd=0x2c896d0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #14 0x00000000007d891f in handle_event (connection=0x2c55d50) 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=0x2c17490) 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 54 (LWP 30774): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f386fffec90, fast_mutex=0x24952e0, cond=0x2495320) 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=0x24952e0, 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 53 (LWP 30779): +bt #0 0x000000362fa0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4af68 in os_cond_wait (fast_mutex=0x24921a0, cond=0x24921e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x24921a0, 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 52 (LWP 30781): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f385b5fdcb0, fast_mutex=0x2ac86e0, cond=0x2ac8720) 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=0x2ac86e0, 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=0x2ac32f8, 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=0x2ac32f8) 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 51 (LWP 30783): +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=0x2b30b70) 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 50 (LWP 30749): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=0, array=0x24b8cf0) 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=0x7f387b875d80, message2=message2@entry=0x7f387b875d88, type=type@entry=0x7f387b875d90, space_id=space_id@entry=0x7f387b875d98) 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 49 (LWP 30754): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=0, array=0x24d4250) 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=0x7f3878670d80, message2=message2@entry=0x7f3878670d88, type=type@entry=0x7f3878670d90, space_id=space_id@entry=0x7f3878670d98) 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 48 (LWP 30757): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=3, array=0x24d4250) 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=0x7f387686dd80, message2=message2@entry=0x7f387686dd88, type=type@entry=0x7f387686dd90, space_id=space_id@entry=0x7f387686dd98) 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 47 (LWP 30758): +bt #0 0x000000362fa0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4af68 in os_cond_wait (fast_mutex=0x2492230, cond=0x2492270) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:214 #2 os_event_wait_low (event=0x2492230, reset_sig_count=11, reset_sig_count@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/os/os0sync.cc:610 #3 0x0000000000aec5ee in srv_redo_log_follow_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:2298 #4 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 46 (LWP 30776): +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 45 (LWP 30782): +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=0x7f385abfcd00, 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=0x7f385abfcd00, 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=0x2b2e3c0) 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 44 (LWP 30790): +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=0x7f3875d68c70, mutex=0x153ca00 , that=0x7f3875d68d30) 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=0x7f3875d68c70, mutex=0x153ca00 , that=0x7f3875d68d30) 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=0x7f3875d68d10, thread_group=thread_group@entry=0x153ca00 , abstime=abstime@entry=0x7f3875d68c70) 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=0x7f383c004bc0) 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 43 (LWP 30837): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=20, native_events=native_events@entry=0x7f3875b5db60, 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=0x7f3875b60d10, thread_group=thread_group@entry=0x153d200 , abstime=abstime@entry=0x7f3875b60c70) 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=0x7f3804004bc0) 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 42 (LWP 30785): +bt #0 mach_read_from_1 (b=0x7f3883b16c14 "") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/mach0data.ic:55 #1 rec_get_bit_field_1 (shift=0, mask=15, offs=5, rec=0x7f3883b16c19 "") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/rem0rec.ic:169 #2 rec_get_n_owned_new (rec=0x7f3883b16c19 "") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/rem0rec.ic:549 #3 page_rec_find_owner_rec (rec=0x7f3883b16c19 "") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/page0page.ic:930 #4 0x0000000000a51389 in page_cur_insert_rec_low (current_rec=0x7f3883b16bfc "", index=0x7f37ec039958, rec=, offsets=, mtr=0x7f3875de88b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/page/page0cur.cc:1131 #5 0x0000000000b52990 in page_cur_tuple_insert (cursor=0x7f3875de8518, tuple=0x7f37ec03c2d8, index=0x7f37ec039958, offsets=0x7f3875de84f0, heap=, n_ext=, mtr=0x7f3875de88b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/page0cur.ic:280 #6 0x0000000000b54e61 in btr_cur_optimistic_insert (flags=flags@entry=0, cursor=cursor@entry=0x7f3875de8510, offsets=offsets@entry=0x7f3875de84f0, heap=heap@entry=0x7f3875de8500, entry=entry@entry=0x7f37ec03c2d8, rec=rec@entry=0x7f3875de8508, big_rec=big_rec@entry=0x7f3875de84f8, n_ext=n_ext@entry=0, thr=thr@entry=0x7f37ec037df8, mtr=mtr@entry=0x7f3875de88b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/btr/btr0cur.cc:1530 #7 0x0000000000a9b2b2 in row_ins_clust_index_entry_low (flags=flags@entry=0, mode=, mode@entry=2, index=index@entry=0x7f37ec039958, n_uniq=n_uniq@entry=0, entry=entry@entry=0x7f37ec03c2d8, n_ext=n_ext@entry=0, thr=thr@entry=0x7f37ec037df8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0ins.cc:2501 #8 0x0000000000a9c2a6 in row_ins_clust_index_entry (index=0x7f37ec039958, entry=0x7f37ec03c2d8, thr=thr@entry=0x7f37ec037df8, n_ext=n_ext@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0ins.cc:2905 #9 0x0000000000a9c96b in row_ins_index_entry (thr=0x7f37ec037df8, entry=, index=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0ins.cc:2999 #10 row_ins_index_entry_step (thr=0x7f37ec037df8, node=0x7f37ec037bb8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0ins.cc:3076 #11 row_ins (thr=0x7f37ec037df8, node=0x7f37ec037bb8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0ins.cc:3216 #12 row_ins_step (thr=thr@entry=0x7f37ec037df8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0ins.cc:3341 #13 0x0000000000aab405 in row_insert_for_mysql (mysql_rec=mysql_rec@entry=0x7f37ec038da0 "\371\b", prebuilt=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0mysql.cc:1313 #14 0x00000000009e67e8 in ha_innobase::write_row (this=0x7f37ec008600, record=0x7f37ec038da0 "\371\b") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:7130 #15 0x00000000005eb265 in handler::ha_write_row (this=0x7f37ec008600, buf=0x7f37ec038da0 "\371\b") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:7471 #16 0x0000000000717ccd in write_record (thd=0x2d12b20, table=0x7f37ec03cf80, info=info@entry=0x7f37ec0060e8, update=update@entry=0x7f37ec006160) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_insert.cc:1668 #17 0x0000000000718549 in select_insert::send_data (this=0x7f37ec0060a0, values=...) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_insert.cc:3721 #18 0x0000000000710610 in end_send (join=0x7f37ec0061e0, join_tab=0x7f384804c1c8, end_of_records=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:2775 #19 0x000000000070c79c in evaluate_join_record (join=join@entry=0x7f37ec0061e0, join_tab=join_tab@entry=0x7f384804bec8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1598 #20 0x000000000070cb1f in sub_select (join=0x7f37ec0061e0, join_tab=0x7f384804bec8, end_of_records=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1273 #21 0x000000000070b257 in do_select (join=0x7f37ec0061e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:930 #22 JOIN::exec (this=0x7f37ec0061e0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:191 #23 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x2d15668, thd=0x2d12b20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101 #24 mysql_select (thd=thd@entry=0x2d12b20, tables=0x7f37ec005b28, wild_num=0, fields=..., conds=0x0, order=order@entry=0x2d15830, group=group@entry=0x2d15768, having=0x0, select_options=3489925888, result=result@entry=0x7f37ec0060a0, unit=0x2d15020, select_lex=select_lex@entry=0x2d15668) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222 #25 0x000000000075d14d in handle_select (thd=thd@entry=0x2d12b20, result=result@entry=0x7f37ec0060a0, 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 #26 0x0000000000735a55 in mysql_execute_command (thd=thd@entry=0x2d12b20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3857 #27 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2d12b20, rawbuf=, length=, parser_state=parser_state@entry=0x7f3875dea550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #28 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2d12b20, packet=packet@entry=0x2d16b61 "REPLACE INTO transforms.insert_select_30893 SELECT `col_int_nokey` % 10 AS `col_int_nokey` , `col_int_key` % 10 AS `col_int_key` FROM `E`", packet_length=packet_length@entry=137) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #29 0x00000000007387ab in do_command (thd=thd@entry=0x2d12b20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #30 0x00000000007d76e7 in threadpool_process_request (thd=0x2d12b20) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #31 0x00000000007d891f in handle_event (connection=0x2c8d4b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #32 worker_main (param=param@entry=0x153c800 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #33 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f3844004bc0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #34 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #35 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 41 (LWP 30755): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=1, array=0x24d4250) 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=0x7f3877c6fd80, message2=message2@entry=0x7f3877c6fd88, type=type@entry=0x7f3877c6fd90, space_id=space_id@entry=0x7f3877c6fd98) 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 40 (LWP 30862): +bt #0 0x000000362fa0e054 in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x000000362fa0a864 in pthread_rwlock_rdlock () from /lib64/libpthread.so.0 #2 0x0000000000c84728 in read_lock_stack (cs=, cs=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/dbug/dbug.c:418 #3 read_lock_stack (cs=0x7f37f0000af0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/dbug/dbug.c:1228 #4 _db_enter_ (_func_=0xdc1227 "alloc_root", _file_=0xdc11a0 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/mysys/my_alloc.c", _line_=190, _stack_frame_=0x7f3874139b10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/dbug/dbug.c:1241 #5 0x000000000095d5c3 in alloc_root (mem_root=0x2cdd800, length=264) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/mysys/my_alloc.c:190 #6 0x000000000060daa9 in Item::operator new (size=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/item.h:663 #7 0x00000000007cafa6 in Field_iterator_table_ref::get_or_create_column_ref (this=this@entry=0x7f3874139d30, thd=thd@entry=0x2cda140, parent_table_ref=parent_table_ref@entry=0x7f37f0005670) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/table.cc:5056 #8 0x00000000006d5e42 in mark_common_columns (found_using_fields=, using_fields=0x7f37f00061e8, table_ref_2=0x7f37f0005c38, table_ref_1=0x7f37f0005670, thd=0x2cda140) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:7663 #9 store_top_level_join_columns (thd=thd@entry=0x2cda140, table_ref=table_ref@entry=0x7f37f0006230, left_neighbor=left_neighbor@entry=0x0, right_neighbor=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:8067 #10 0x00000000006dff79 in setup_natural_join_row_types (context=0x2cdccd8, from_clause=0x2cdce08, thd=0x2cda140) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:8169 #11 setup_tables (thd=thd@entry=0x2cda140, context=0x2cdccd8, from_clause=0x2cdce08, tables=tables@entry=0x7f37f0005670, leaves=leaves@entry=0x7f387413a068, select_insert=select_insert@entry=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:8496 #12 0x00000000006e01b7 in setup_tables_and_check_access (thd=0x2cda140, context=, from_clause=, tables=0x7f37f0005670, leaves=0x2cdce48, select_insert=select_insert@entry=false, want_access_first=want_access_first@entry=1, want_access=want_access@entry=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:8542 #13 0x000000000074eea0 in JOIN::prepare (this=this@entry=0x7f37f00521d0, tables_init=tables_init@entry=0x7f37f0005670, wild_num=wild_num@entry=0, conds_init=conds_init@entry=0x0, og_num=og_num@entry=0, order_init=order_init@entry=0x0, group_init=group_init@entry=0x0, having_init=having_init@entry=0x0, select_lex_arg=select_lex_arg@entry=0x2cdcc88, unit_arg=unit_arg@entry=0x2cdc640) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_resolver.cc:128 #14 0x000000000075ce87 in mysql_prepare_select (free_join=, select_lex=0x2cdcc88, unit=0x2cdc640, result=0x7f37f0006b20, select_options=2416740864, having=0x0, group=0x0, order=0x0, og_num=0, conds=0x0, fields=..., wild_num=0, tables=0x7f37f0005670, thd=0x2cda140) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1055 #15 mysql_select (thd=thd@entry=0x2cda140, tables=0x7f37f0005670, wild_num=0, fields=..., conds=0x0, order=order@entry=0x2cdce50, group=group@entry=0x2cdcd88, having=0x0, select_options=2416740864, result=result@entry=0x7f37f0006b20, unit=0x2cdc640, select_lex=select_lex@entry=0x2cdcc88) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1178 #16 0x000000000075d14d in handle_select (thd=thd@entry=0x2cda140, result=result@entry=0x7f37f0006b20, 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 #17 0x00000000007354bd in mysql_execute_command (thd=thd@entry=0x2cda140) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3375 #18 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2cda140, rawbuf=, length=, parser_state=parser_state@entry=0x7f387413b550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #19 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2cda140, packet=packet@entry=0x2cddb61 "CREATE TABLE transforms.insert_select_30878 SELECT X . `pk` FROM `A` AS X LEFT JOIN `AA` AS Y USING ( `col_int_key` ) LIMIT 5 /*Generated by THREAD_ID 14*/ ", packet_length=packet_length@entry=157) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #20 0x00000000007387ab in do_command (thd=thd@entry=0x2cda140) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #21 0x00000000007d76e7 in threadpool_process_request (thd=0x2cda140) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #22 0x00000000007d891f in handle_event (connection=0x2b96780) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #23 worker_main (param=param@entry=0x153ca00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #24 0x00000000009bbd73 in pfs_spawn_thread (arg=0x2cad5b0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #25 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #26 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 39 (LWP 30872): +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=0x7f38740b7bd0, mutex=0x2cca078, that=0x2cca0a8) 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=0x2cca078, owner=0x2cc9f40, abs_timeout=abs_timeout@entry=0x7f38740b7bd0, 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=0x2cca078, mdl_request=mdl_request@entry=0x7f37e801cc88, 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=0x2cc9f40, ot_ctx=ot_ctx@entry=0x7f38740b8450, mdl_request=mdl_request@entry=0x7f37e801cc88, flags=, flags@entry=0, mdl_ticket=mdl_ticket@entry=0x7f38740b7ee0) 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=0x2cc9f40, table_list=table_list@entry=0x7f37e801c8e8, ot_ctx=ot_ctx@entry=0x7f38740b8450) 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=0x7f38740b8450, has_prelocking_list=false, prelocking_strategy=0x7f38740b84e0, flags=0, counter=0x2ccc430, tables=0x7f37e801c8e8, lex=0x2ccc378, thd=0x2cc9f40) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:4592 #7 open_tables (thd=thd@entry=0x2cc9f40, start=start@entry=0x7f38740b84d8, counter=0x2ccc430, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f38740b84e0) 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=0x2cc9f40, tables=0x7f37e80052e0, flags=flags@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:5799 #9 0x00000000007352be in mysql_execute_command (thd=thd@entry=0x2cc9f40) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:3313 #10 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2cc9f40, rawbuf=, length=, parser_state=parser_state@entry=0x7f38740b9550) 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=0x2cc9f40, packet=packet@entry=0x2ccdf81 "CREATE TABLE transforms.insert_select_30871 SELECT DISTINCT alias1 . `col_date_key` AS field1 , alias2 . `col_varchar_key` AS field2 , COUNT( DISTINCT alias1 . `col_int_key` ) AS field3 , alias2 . `col_varchar_key` AS field4 , alias2 . `col_varchar_key` AS field5 , alias1 . `col_varchar_nokey` AS field6 , alias2 . `col_int_nokey` AS field7 , alias2 . `col_datetime_key` AS field8 FROM ( C AS alias1 , ( CC AS alias2 , C AS alias3 ) ) GROUP BY field1, field2, field4, field5, field6, field7, field8 ORDER BY field1, field2, field3, field4, field5, field6, field7, field8, field5", packet_length=packet_length@entry=581) 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=0x2cc9f40) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #13 0x00000000007d76e7 in threadpool_process_request (thd=0x2cc9f40) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #14 0x00000000007d891f in handle_event (connection=0x2c1aca0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #15 worker_main (param=param@entry=0x153d200 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #16 0x00000000009bbd73 in pfs_spawn_thread (arg=0x2cc5c90) 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 38 (LWP 30777): +bt #0 0x000000362f2cf3e7 in sched_yield () from /lib64/libc.so.6 #1 0x0000000000afb549 in mutex_spin_wait (_mutex=_mutex@entry=0x15706a0 , high_priority=high_priority@entry=false, file_name=file_name@entry=0xe103a8 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0sync.cc", line=line@entry=1183) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0sync.cc:587 #2 0x0000000000afa387 in mutex_enter_func (file_name=0xe103a8 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0sync.cc", line=1183, mutex=0x15706a0 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0sync.ic:271 #3 pfs_mutex_enter_func (file_name=0xe103a8 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0sync.cc", line=1183, mutex=0x15706a0 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0sync.ic:348 #4 sync_thread_add_level (latch=latch@entry=0x1577140 , level=1010, relock=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0sync.cc:1183 #5 0x0000000000af78df in rw_lock_add_debug_info (lock=lock@entry=0x1577140 , pass=pass@entry=0, lock_type=lock_type@entry=352, file_name=file_name@entry=0xe05a98 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0purge.cc", line=line@entry=720) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0rw.cc:991 #6 0x0000000000ac1272 in rw_lock_s_lock_low (pass=0, file_name=0xe05a98 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0purge.cc", line=720, lock=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0rw.ic:373 #7 rw_lock_s_lock_low (pass=0, file_name=0xe05a98 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0purge.cc", line=720, lock=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0purge.cc:911 #8 rw_lock_s_lock_func (lock=, pass=0, file_name=0xe05a98 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0purge.cc", line=720) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0rw.ic:415 #9 pfs_rw_lock_s_lock_func (lock=, pass=0, file_name=0xe05a98 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0purge.cc", line=720) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0rw.ic:1033 #10 row_purge_parse_undo_rec (thr=0x2ae6100, updated_extern=0x7f386e1fba77, undo_rec=0x7f385c059060 "2\330\016\203g\200\255", node=0x2ae62b8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0purge.cc:720 #11 row_purge (thr=0x2ae6100, undo_rec=0x7f385c059060 "2\330\016\203g\200\255", node=0x2ae62b8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0purge.cc:859 #12 row_purge_step (thr=thr@entry=0x2ae6100) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0purge.cc:942 #13 0x0000000000a75e97 in que_thr_step (thr=0x2ae6100) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/que/que0que.cc:1115 #14 que_run_threads_low (thr=0x2ae6100) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/que/que0que.cc:1177 #15 que_run_threads (thr=0x2ae6100) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/que/que0que.cc:1218 #16 0x0000000000b05cad in trx_purge (n_purge_threads=n_purge_threads@entry=1, batch_size=300, truncate=truncate@entry=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/trx/trx0purge.cc:1251 #17 0x0000000000aeeca2 in srv_do_purge (n_total_purged=, n_threads=1) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:3206 #18 srv_purge_coordinator_thread (arg=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/srv/srv0srv.cc:3388 #19 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #20 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 37 (LWP 30753): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=3, array=0x24944d0) 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=0x7f3879071d80, message2=message2@entry=0x7f3879071d88, type=type@entry=0x7f3879071d90, space_id=space_id@entry=0x7f3879071d98) 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 36 (LWP 30932): +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=0x7f386c16cb70, mutex=0x2cd2228, that=0x2cd2258) 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=0x2cd2228, owner=0x2cd20f0, abs_timeout=abs_timeout@entry=0x7f386c16cb70, 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=0x2cd2228, mdl_request=mdl_request@entry=0x7f37ac02f360, 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=0x2cd20f0, ot_ctx=ot_ctx@entry=0x7f386c16d3f0, mdl_request=mdl_request@entry=0x7f37ac02f360, flags=, flags@entry=0, mdl_ticket=mdl_ticket@entry=0x7f386c16ce80) 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=0x2cd20f0, table_list=table_list@entry=0x7f37ac02efc0, ot_ctx=ot_ctx@entry=0x7f386c16d3f0) 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=0x7f386c16d3f0, has_prelocking_list=false, prelocking_strategy=0x7f386c16d480, flags=0, counter=0x2cd45e0, tables=0x7f37ac02efc0, lex=0x2cd4528, thd=0x2cd20f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:4592 #7 open_tables (thd=thd@entry=0x2cd20f0, start=start@entry=0x7f386c16d478, counter=0x2cd45e0, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f386c16d480) 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=0x2cd20f0, tables=tables@entry=0x7f37fc005178, 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=0x2cd20f0, all_tables=0x7f37fc005178) 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=0x2cd20f0) 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=0x2cd20f0, rawbuf=, length=, parser_state=parser_state@entry=0x7f386c16e550) 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=0x2cd20f0, packet=packet@entry=0x2cd6131 "SELECT * FROM transforms.view_30873_temptable /* TRANSFORM_OUTCOME_UNORDERED_MATCH */", packet_length=packet_length@entry=85) 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=0x2cd20f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #14 0x00000000007d76e7 in threadpool_process_request (thd=0x2cd20f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #15 0x00000000007d891f in handle_event (connection=0x2c4ceb0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #16 worker_main (param=param@entry=0x153d400 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #17 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f384c000a10) 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 35 (LWP 30778): +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=1386398457808) 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 34 (LWP 30752): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=2, array=0x24944d0) 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=0x7f3879a72d80, message2=message2@entry=0x7f3879a72d88, type=type@entry=0x7f3879a72d90, space_id=space_id@entry=0x7f3879a72d98) 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 33 (LWP 30938): +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=0x7f386c0abc70, mutex=0x153d000 , that=0x7f386c0abd30) 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=0x7f386c0abc70, mutex=0x153d000 , that=0x7f386c0abd30) 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=0x7f386c0abd10, thread_group=thread_group@entry=0x153d000 , abstime=abstime@entry=0x7f386c0abc70) 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=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=0x2cfdff0) 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 32 (LWP 30775): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f386f5fdd20, fast_mutex=0x2495370, cond=0x24953b0) 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=0x2495370, 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 31 (LWP 30751): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=1, array=0x24944d0) 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=0x7f387a473d80, message2=message2@entry=0x7f387a473d88, type=type@entry=0x7f387a473d90, space_id=space_id@entry=0x7f387a473d98) 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 30 (LWP 30912): +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=0x7f386c3322c0, mutex=0x2c817b8, that=0x2c817e8) 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=0x2c817b8, owner=0x2c81680, abs_timeout=abs_timeout@entry=0x7f386c3322c0, 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=0x2c817b8, mdl_request=mdl_request@entry=0x7f386c3323a0, 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 0x000000000069a4c4 in MDL_context::upgrade_shared_lock (this=this@entry=0x2c817b8, mdl_ticket=0x7f37cc00e8a0, new_type=new_type@entry=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2410 #5 0x00000000006e1e32 in wait_while_table_is_used (thd=thd@entry=0x2c81680, table=table@entry=0x7f37cc03e150, function=function@entry=HA_EXTRA_FORCE_REOPEN) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:2226 #6 0x0000000000789e64 in simple_rename_or_index_change (alter_ctx=0x7f386c3332c0, keys_onoff=Alter_info::ENABLE, table_list=0x7f37cc04aac8, thd=0x2c81680) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:7573 #7 mysql_alter_table (thd=thd@entry=0x2c81680, new_db=, new_name=0x7f37cc00e8a0 "PK>\001", create_info=create_info@entry=0x7f386c333ed0, table_list=table_list@entry=0x7f37cc04aac8, alter_info=alter_info@entry=0x7f386c333e10, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:8074 #8 0x0000000000886a78 in Sql_cmd_alter_table::execute (this=, thd=0x2c81680) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_alter.cc:317 #9 0x0000000000731411 in mysql_execute_command (thd=thd@entry=0x2c81680) 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=0x2c81680, rawbuf=rawbuf@entry=0x7f384006b905 "ALTER TABLE D ENABLE KEYS; ALTER TABLE DD ENABLE KEYS; ALTER TABLE E ENABLE KEYS", length=length@entry=80, parser_state=parser_state@entry=0x7f386c335550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #11 0x0000000000737b8e in dispatch_command (command=, command@entry=COM_QUERY, thd=thd@entry=0x2c81680, packet=0x4
, packet@entry=0x2c856c1 "", packet_length=packet_length@entry=245) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1513 #12 0x00000000007387ab in do_command (thd=thd@entry=0x2c81680) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #13 0x00000000007d76e7 in threadpool_process_request (thd=0x2c81680) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #14 0x00000000007d891f in handle_event (connection=0x2c20900) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #15 worker_main (param=param@entry=0x153ca00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #16 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f384c000d70) 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 29 (LWP 30773): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f3874bbec80, fast_mutex=0x2a994c0, cond=0x2a99500) 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=0x2a994c0, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=reset_sig_count@entry=22) 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 28 (LWP 30823): +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=0x7f3875ce6c70, mutex=0x153cc00 , that=0x7f3875ce6d30) 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=0x7f3875ce6c70, mutex=0x153cc00 , that=0x7f3875ce6d30) 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=0x7f3875ce6d10, thread_group=thread_group@entry=0x153cc00 , abstime=abstime@entry=0x7f3875ce6c70) 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=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=0x7f381c004bc0) 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 27 (LWP 30784): +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=0x7f3875e2bc70, mutex=0x153c800 , that=0x7f3875e2bd30) 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=0x7f3875e2bc70, mutex=0x153c800 , that=0x7f3875e2bd30) 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=0x7f3875e2bd10, thread_group=thread_group@entry=0x153c800 , abstime=abstime@entry=0x7f3875e2bc70) 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=0x2beb7a0) 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 26 (LWP 30748): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=0, array=0x24c6790) 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=0x7f387c276d80, message2=message2@entry=0x7f387c276d88, type=type@entry=0x7f387c276d90, space_id=space_id@entry=0x7f387c276d98) 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 25 (LWP 30750): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=0, array=0x24944d0) 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=0x7f387ae74d80, message2=message2@entry=0x7f387ae74d88, type=type@entry=0x7f387ae74d90, space_id=space_id@entry=0x7f387ae74d98) 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 24 (LWP 30756): +bt #0 0x0000003636a00614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000a477ac in os_aio_linux_collect (seg_size=256, segment=2, array=0x24d4250) 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=0x7f387726ed80, message2=message2@entry=0x7f387726ed88, type=type@entry=0x7f387726ed90, space_id=space_id@entry=0x7f387726ed98) 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 23 (LWP 30913): +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=0x7f386c2f4c70, mutex=0x153d200 , that=0x7f386c2f4d30) 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=0x7f386c2f4c70, mutex=0x153d200 , that=0x7f386c2f4d30) 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=0x7f386c2f4d10, thread_group=thread_group@entry=0x153d200 , abstime=abstime@entry=0x7f386c2f4c70) 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=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=0x7f384c000a10) 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 22 (LWP 30918): +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=0x7f386c22efb0, mutex=0x2ca9948, that=0x2ca9978) 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=0x2ca9948, owner=0x2ca9810, abs_timeout=abs_timeout@entry=0x7f386c22efb0, 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=0x2ca9948, mdl_request=0x7f386c22f260, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2245 #4 0x000000000069a22b in MDL_context::acquire_locks (this=this@entry=0x2ca9948, mdl_requests=mdl_requests@entry=0x7f386c22f0a0, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2339 #5 0x000000000084aa55 in lock_schema_name (thd=thd@entry=0x2ca9810, db=db@entry=0x7f384803f940 "transforms") at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/lock.cc:797 #6 0x0000000000704a0b in mysql_create_db (thd=thd@entry=0x2ca9810, db=db@entry=0x7f384803f940 "transforms", create_info=create_info@entry=0x7f386c230bf0, silent=silent@entry=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_db.cc:559 #7 0x000000000073255e in mysql_execute_command (thd=thd@entry=0x2ca9810) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:4175 #8 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2ca9810, rawbuf=, length=, parser_state=parser_state@entry=0x7f386c231550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #9 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2ca9810, packet=packet@entry=0x2cad851 "/* GenTest::Transform::ExecuteAsView */ CREATE DATABASE IF NOT EXISTS transforms", packet_length=packet_length@entry=80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #10 0x00000000007387ab in do_command (thd=thd@entry=0x2ca9810) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #11 0x00000000007d76e7 in threadpool_process_request (thd=0x2ca9810) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #12 0x00000000007d891f in handle_event (connection=0x2b9cee0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #13 worker_main (param=param@entry=0x153c800 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #14 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f384c000d70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #15 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #16 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 21 (LWP 31002): +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=0x7f385a179c70, mutex=0x153d400 , that=0x7f385a179d30) 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=0x7f385a179c70, mutex=0x153d400 , that=0x7f385a179d30) 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=0x7f385a179d10, thread_group=thread_group@entry=0x153d400 , abstime=abstime@entry=0x7f385a179c70) 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=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=0x2d5ee80) 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 20 (LWP 30955): +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=0x7f386c06ac70, mutex=0x153d200 , that=0x7f386c06ad30) 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=0x7f386c06ac70, mutex=0x153d200 , that=0x7f386c06ad30) 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=0x7f386c06ad10, thread_group=thread_group@entry=0x153d200 , abstime=abstime@entry=0x7f386c06ac70) 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=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=0x7f37b802df00) 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 19 (LWP 30936): +bt #0 0x000000362f2e8f43 in epoll_wait () from /lib64/libc.so.6 #1 0x00000000007d7f29 in io_poll_wait (pollfd=18, native_events=native_events@entry=0x7f386c12ab60, 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=0x7f386c12dd10, thread_group=thread_group@entry=0x153ce00 , abstime=abstime@entry=0x7f386c12dc70) 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=0x7f381400a170) 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 18 (LWP 31306): +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=0x7f3859fb2c70, mutex=0x153d400 , that=0x7f3859fb2d30) 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=0x7f3859fb2c70, mutex=0x153d400 , that=0x7f3859fb2d30) 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=0x7f3859fb2d10, thread_group=thread_group@entry=0x153d400 , abstime=abstime@entry=0x7f3859fb2c70) 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=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=0x2d063c0) 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 30747): +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 16 (LWP 30780): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000a4b0a5 in os_cond_wait_timed (abstime=0x7f385bffecc0, fast_mutex=0x2a9f850, cond=0x2a9f890) 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=0x2a9f850, time_in_usec=time_in_usec@entry=10000000, reset_sig_count=43, 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 15 (LWP 30982): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000064611d in inline_mysql_cond_timedwait (src_file=0xcdb2f0 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/item_func.cc", src_line=4212, abstime=0x7f385a1f9cd0, mutex=0x151a960 , that=0x7f37e4039c08) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 Interruptible_wait::wait (this=this@entry=0x7f385a1f9d70, cond=cond@entry=0x7f37e4039c08, mutex=mutex@entry=0x151a960 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/item_func.cc:4212 #3 0x000000000064665f in Item_func_get_lock::val_int (this=0x7f381c00c358) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/item_func.cc:4315 #4 0x00000000005f1b3c in Item::send (this=0x7f381c00c358, protocol=0x2cb1d90, buffer=0x7f385a1f9e60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/item.cc:6846 #5 0x00000000006a0f01 in Protocol::send_result_set_row (this=this@entry=0x2cb1d90, row_items=row_items@entry=0x2cb44c8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/protocol.cc:847 #6 0x00000000006fbe83 in select_send::send_data (this=0x7f381c00c540, items=...) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_class.cc:2686 #7 0x000000000070b6fd in JOIN::exec (this=0x7f381c00c568) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:148 #8 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x2cb43a8, thd=0x2cb1860) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101 #9 mysql_select (thd=thd@entry=0x2cb1860, tables=0x0, wild_num=0, fields=..., conds=0x0, order=order@entry=0x2cb4570, group=group@entry=0x2cb44a8, having=0x0, select_options=2147748608, result=result@entry=0x7f381c00c540, unit=0x2cb3d60, select_lex=select_lex@entry=0x2cb43a8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222 #10 0x000000000075d14d in handle_select (thd=thd@entry=0x2cb1860, result=0x7f381c00c540, 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 #11 0x00000000005abd2a in execute_sqlcom_select (thd=thd@entry=0x2cb1860, all_tables=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5473 #12 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x2cb1860) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886 #13 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2cb1860, rawbuf=, length=, parser_state=parser_state@entry=0x7f385a1fb550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #14 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2cb1860, packet=packet@entry=0x2cb58a1 "", packet_length=packet_length@entry=31) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #15 0x00000000007387ab in do_command (thd=thd@entry=0x2cb1860) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #16 0x00000000007d76e7 in threadpool_process_request (thd=0x2cb1860) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #17 0x00000000007d891f in handle_event (connection=0x2c68a60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #18 worker_main (param=param@entry=0x153cc00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #19 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f384c000d70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #20 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #21 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 14 (LWP 30907): +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=0x7f386c3b7c70, mutex=0x153d000 , that=0x7f386c3b7d30) 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=0x7f386c3b7c70, mutex=0x153d000 , that=0x7f386c3b7d30) 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=0x7f386c3b7d10, thread_group=thread_group@entry=0x153d000 , abstime=abstime@entry=0x7f386c3b7c70) 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=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=0x7f384c000d70) 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 13 (LWP 30906): +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=0x7f386c3f8c70, mutex=0x153ce00 , that=0x7f386c3f8d30) 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=0x7f386c3f8c70, mutex=0x153ce00 , that=0x7f386c3f8d30) 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=0x7f386c3f8d10, thread_group=thread_group@entry=0x153ce00 , abstime=abstime@entry=0x7f386c3f8c70) 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=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=0x7f384c000a10) 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 12 (LWP 31008): +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=0x7f385a138c70, mutex=0x153ca00 , that=0x7f385a138d30) 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=0x7f385a138c70, mutex=0x153ca00 , that=0x7f385a138d30) 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=0x7f385a138d10, thread_group=thread_group@entry=0x153ca00 , abstime=abstime@entry=0x7f385a138c70) 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=0x7f37f00390b0) 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 30911): +bt #0 0x000000362fa0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000064611d in inline_mysql_cond_timedwait (src_file=0xcdb2f0 "/bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/item_func.cc", src_line=4212, abstime=0x7f386c374cd0, mutex=0x151a960 , that=0x7f37e4039c08) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/include/mysql/psi/mysql_thread.h:1199 #2 Interruptible_wait::wait (this=this@entry=0x7f386c374d70, cond=cond@entry=0x7f37e4039c08, mutex=mutex@entry=0x151a960 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/item_func.cc:4212 #3 0x000000000064665f in Item_func_get_lock::val_int (this=0x7f384400cbc8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/item_func.cc:4315 #4 0x00000000005f1b3c in Item::send (this=0x7f384400cbc8, protocol=0x2c78e90, buffer=0x7f386c374e60) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/item.cc:6846 #5 0x00000000006a0f01 in Protocol::send_result_set_row (this=this@entry=0x2c78e90, row_items=row_items@entry=0x2c7b5c8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/protocol.cc:847 #6 0x00000000006fbe83 in select_send::send_data (this=0x7f384400cdb0, items=...) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_class.cc:2686 #7 0x000000000070b6fd in JOIN::exec (this=0x7f384400cdd8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:148 #8 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x2c7b4a8, thd=0x2c78960) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101 #9 mysql_select (thd=thd@entry=0x2c78960, tables=0x0, wild_num=0, fields=..., conds=0x0, order=order@entry=0x2c7b670, group=group@entry=0x2c7b5a8, having=0x0, select_options=2147781376, result=result@entry=0x7f384400cdb0, unit=0x2c7ae60, select_lex=select_lex@entry=0x2c7b4a8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222 #10 0x000000000075d14d in handle_select (thd=thd@entry=0x2c78960, result=0x7f384400cdb0, 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 #11 0x00000000005abd2a in execute_sqlcom_select (thd=thd@entry=0x2c78960, all_tables=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5473 #12 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x2c78960) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886 #13 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2c78960, rawbuf=, length=, parser_state=parser_state@entry=0x7f386c376550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #14 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2c78960, packet=packet@entry=0x2c7ccd1 "", packet_length=packet_length@entry=93) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #15 0x00000000007387ab in do_command (thd=thd@entry=0x2c78960) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #16 0x00000000007d76e7 in threadpool_process_request (thd=0x2c78960) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #17 0x00000000007d891f in handle_event (connection=0x2be4740) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #18 worker_main (param=param@entry=0x153c800 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #19 0x00000000009bbd73 in pfs_spawn_thread (arg=0x7f384c000a10) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #20 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #21 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 10 (LWP 31405): +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=0x7f3859f71c70, mutex=0x153ca00 , that=0x7f3859f71d30) 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=0x7f3859f71c70, mutex=0x153ca00 , that=0x7f3859f71d30) 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=0x7f3859f71d10, thread_group=thread_group@entry=0x153ca00 , abstime=abstime@entry=0x7f3859f71c70) 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=0x7f37f0011200) 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 9 (LWP 30917): +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=0x7f386c272c70, mutex=0x153c600 , that=0x7f386c272d30) 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=0x7f386c272c70, mutex=0x153c600 , that=0x7f386c272d30) 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=0x7f386c272d10, thread_group=thread_group@entry=0x153c600 , abstime=abstime@entry=0x7f386c272c70) 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=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=0x7f384c000a10) 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 8 (LWP 30839): +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=0x7f3875adec70, mutex=0x153d400 , that=0x7f3875aded30) 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=0x7f3875adec70, mutex=0x153d400 , that=0x7f3875aded30) 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=0x7f3875aded10, thread_group=thread_group@entry=0x153d400 , abstime=abstime@entry=0x7f3875adec70) 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=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=0x7f37fc004bc0) 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 7 (LWP 30834): +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=0x7f3875c23c70, mutex=0x153d000 , that=0x7f3875c23d30) 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=0x7f3875c23c70, mutex=0x153d000 , that=0x7f3875c23d30) 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=0x7f3875c23d10, thread_group=thread_group@entry=0x153d000 , abstime=abstime@entry=0x7f3875c23c70) 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=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=0x2c3c000) 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 6 (LWP 30838): +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=0x7f3875b1fc70, mutex=0x153d400 , that=0x7f3875b1fd30) 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=0x7f3875b1fc70, mutex=0x153d400 , that=0x7f3875b1fd30) 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=0x7f3875b1fd10, thread_group=thread_group@entry=0x153d400 , abstime=abstime@entry=0x7f3875b1fc70) 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=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=0x2bc1f30) 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 30833): +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=0x7f3875c64c70, mutex=0x153ce00 , that=0x7f3875c64d30) 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=0x7f3875c64c70, mutex=0x153ce00 , that=0x7f3875c64d30) 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=0x7f3875c64d10, thread_group=thread_group@entry=0x153ce00 , abstime=abstime@entry=0x7f3875c64c70) 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=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=0x7f3814004bc0) 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 4 (LWP 30835): +bt #0 mutex_get_waiters (mutex=0x1568260 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0sync.ic:153 #1 mutex_exit_func (mutex=0x1568260 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0sync.ic:187 #2 pfs_mutex_exit_func (mutex=0x1568260 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0sync.ic:458 #3 rw_lock_debug_mutex_exit () at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0rw.cc:949 #4 0x0000000000af7f9d in rw_lock_remove_debug_info (lock=lock@entry=0x7f387d4f84a0, pass=pass@entry=0, lock_type=lock_type@entry=352) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/sync/sync0rw.cc:1026 #5 0x0000000000a420df in rw_lock_s_unlock_func (pass=0, lock=0x7f387d4f84a0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0rw.ic:574 #6 pfs_rw_lock_s_unlock_func (pass=0, lock=0x7f387d4f84a0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/sync0rw.ic:1213 #7 buf_page_release (rw_latch=1, block=0x7f387d4f8278) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/buf0buf.ic:1356 #8 mtr_memo_slot_release_func (mtr=mtr@entry=0x7f3875bdfcb0, slot=slot@entry=0x7f3875bdfcc8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/mtr/mtr0mtr.cc:82 #9 0x0000000000a4377c in mtr_memo_pop_all (mtr=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/mtr/mtr0mtr.cc:133 #10 mtr_commit (mtr=mtr@entry=0x7f3875bdfcb0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/mtr/mtr0mtr.cc:326 #11 0x0000000000acc84e in row_sel (node=node@entry=0x7f381003f020, thr=thr@entry=0x7f3810040ef8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:1890 #12 0x0000000000ace18b in row_sel_step (thr=thr@entry=0x7f3810040ef8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/row/row0sel.cc:2123 #13 0x0000000000a7595f in que_thr_step (thr=0x7f3810040ef8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/que/que0que.cc:1093 #14 que_run_threads_low (thr=0x7f3810040ef8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/que/que0que.cc:1177 #15 que_run_threads (thr=0x7f3810040ef8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/que/que0que.cc:1218 #16 0x0000000000a7658c in que_eval_sql (info=info@entry=0x7f3810007778, sql=sql@entry=0xe24650 "PROCEDURE FETCH_STATS () IS\nfound INT;\nDECLARE FUNCTION fetch_table_stats_step;\nDECLARE FUNCTION fetch_index_stats_step;\nDECLARE CURSOR table_stats_cur IS\n SELECT\n n_rows,\n clustered_index_size,\n sum_of_other_index_sizes\n FROM \"mysql/innodb_table_stats\"\n WHERE\n database_name = :database_name AND\n table_name = :table_name;\nDECLARE CURSOR index_stats_cur IS\n SELECT\n index_name,\n stat_name,\n stat_value,\n sample_size\n FROM \"mysql/innodb_index_stats\"\n WHERE\n database_name = :database_name AND\n table_name = :table_name;\nBEGIN\nOPEN table_stats_cur;\nFETCH table_stats_cur INTO\n fetch_table_stats_step();\nIF (SQL % NOTFOUND) THEN\n CLOSE table_stats_cur;\n RETURN;\nEND IF;\nCLOSE table_stats_cur;\nOPEN index_stats_cur;\nfound := 1;\nWHILE found = 1 LOOP\n FETCH index_stats_cur INTO\n fetch_index_stats_step();\n IF (SQL % NOTFOUND) THEN\n found := 0;\n END IF;\nEND LOOP;\nCLOSE index_stats_cur;\nEND;", reserve_dict_mutex=reserve_dict_mutex@entry=1, trx=trx@entry=0x7f381004f588) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/que/que0que.cc:1301 #17 0x0000000000bc64ce in dict_stats_fetch_from_ps (table=0x7f381004dc68) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0stats.cc:2828 #18 dict_stats_update (table=table@entry=0x7f383c03a068, stats_upd_option=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/dict/dict0stats.cc:3034 #19 0x00000000009e459c in dict_stats_init (table=0x7f383c03a068) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/include/dict0stats.ic:174 #20 ha_innobase::open (this=0x7f3810035ac0, name=0x7f3810044f90 "./test/B", mode=, test_if_locked=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/innobase/handler/ha_innodb.cc:5340 #21 0x00000000005e380a in handler::ha_open (this=0x7f3810035ac0, table_arg=table_arg@entry=0x7f3810038600, name=0x7f3810044f90 "./test/B", mode=mode@entry=2, test_if_locked=2) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2527 #22 0x00000000007c401c in open_table_from_share (thd=thd@entry=0x2d335f0, share=, alias=, db_stat=db_stat@entry=39, prgflag=prgflag@entry=44, ha_open_flags=0, outparam=outparam@entry=0x7f3810038600, is_create_table=is_create_table@entry=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/table.cc:2332 #23 0x00000000006da87e in open_table (thd=thd@entry=0x2d335f0, table_list=table_list@entry=0x7f381002f290, ot_ctx=ot_ctx@entry=0x7f3875be13f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:3107 #24 0x00000000006e3a78 in open_and_process_table (ot_ctx=0x7f3875be13f0, has_prelocking_list=false, prelocking_strategy=0x7f3875be1480, flags=0, counter=0x2d35ae0, tables=0x7f381002f290, lex=0x2d35a28, thd=0x2d335f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:4592 #25 open_tables (thd=thd@entry=0x2d335f0, start=start@entry=0x7f3875be1478, counter=0x2d35ae0, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f3875be1480) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:5099 #26 0x00000000006e4574 in open_normal_and_derived_tables (thd=thd@entry=0x2d335f0, tables=tables@entry=0x7f38100304c0, flags=flags@entry=0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:5799 #27 0x00000000005abc54 in execute_sqlcom_select (thd=thd@entry=0x2d335f0, all_tables=0x7f38100304c0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5446 #28 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x2d335f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886 #29 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2d335f0, rawbuf=, length=, parser_state=parser_state@entry=0x7f3875be2550) 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=0x2d335f0, packet=packet@entry=0x2d37961 "/* GenTest::Transform::ExecuteAsDerived */ SELECT * FROM ( SELECT X . `col_time_key` FROM `D` AS X LEFT JOIN `B` AS Y USING ( `col_time_key` ) LIMIT 8 /*Generated by THREAD_ID 23*/ ) AS DERIVED_TABLE /* TRANSFORM_OUTCOME_UNORDERED_MATCH */", packet_length=packet_length@entry=242) 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=0x2d335f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #32 0x00000000007d76e7 in threadpool_process_request (thd=0x2d335f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #33 0x00000000007d891f in handle_event (connection=0x2c24110) 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=0x7f380c004bc0) 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 3 (LWP 30789): +bt #0 0x0000000000c832fb in DoTrace (cs=cs@entry=0x7f37f0004c00) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/dbug/dbug.c:1863 #1 0x0000000000c845fc in DoTrace (cs=0x7f37f0004c00) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/dbug/dbug.c:1865 #2 _db_enter_ (_func_=, _file_=, _line_=189, _stack_frame_=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/dbug/dbug.c:1251 #3 0x000000000087cef7 in init_read_record (info=info@entry=0x7f383c06cf40, thd=0x2d1ab70, table=0x7f383c004ed0, select=0x7f383c06d1b0, use_record_cache=use_record_cache@entry=1, print_error=print_error@entry=true, disable_rr_cache=disable_rr_cache@entry=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/records.cc:189 #4 0x000000000070f067 in join_init_read_record (tab=0x7f383c06ceb0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:2388 #5 0x000000000070ca95 in sub_select (join=0x7f383c00b400, join_tab=0x7f383c06ceb0, end_of_records=) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:1253 #6 0x000000000070b257 in do_select (join=0x7f383c00b400) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:930 #7 JOIN::exec (this=0x7f383c00b400) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_executor.cc:191 #8 0x000000000075cd15 in mysql_execute_select (free_join=true, select_lex=0x2d1d6b8, thd=0x2d1ab70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1101 #9 mysql_select (thd=thd@entry=0x2d1ab70, tables=0x7f37f000c218, wild_num=1, fields=..., conds=0x0, order=order@entry=0x2d1d880, group=group@entry=0x2d1d7b8, having=0x0, select_options=2147781376, result=result@entry=0x7f383c00b3d8, unit=0x2d1d070, select_lex=select_lex@entry=0x2d1d6b8) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_select.cc:1222 #10 0x000000000075d14d in handle_select (thd=thd@entry=0x2d1ab70, result=0x7f383c00b3d8, 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 #11 0x00000000005abd2a in execute_sqlcom_select (thd=thd@entry=0x2d1ab70, all_tables=0x7f37f000c218) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5473 #12 0x000000000073318b in mysql_execute_command (thd=thd@entry=0x2d1ab70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:2886 #13 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2d1ab70, rawbuf=, length=, parser_state=parser_state@entry=0x7f3875da9550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #14 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2d1ab70, packet=packet@entry=0x2d1eee1 "", packet_length=packet_length@entry=85) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #15 0x00000000007387ab in do_command (thd=thd@entry=0x2d1ab70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #16 0x00000000007d76e7 in threadpool_process_request (thd=0x2d1ab70) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #17 0x00000000007d891f in handle_event (connection=0x2bec4a0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #18 worker_main (param=param@entry=0x153ca00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #19 0x00000000009bbd73 in pfs_spawn_thread (arg=0x2c06680) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #20 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #21 0x000000362f2e894d in clone () from /lib64/libc.so.6 Thread 2 (LWP 30836): +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=0x7f3875b9e2c0, mutex=0x2d02558, that=0x2d02588) 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=0x2d02558, owner=0x2d02420, abs_timeout=abs_timeout@entry=0x7f3875b9e2c0, 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=0x2d02558, mdl_request=mdl_request@entry=0x7f3875b9e3a0, 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 0x000000000069a4c4 in MDL_context::upgrade_shared_lock (this=this@entry=0x2d02558, mdl_ticket=0x7f3804040400, new_type=new_type@entry=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/mdl.cc:2410 #5 0x00000000006e1e32 in wait_while_table_is_used (thd=thd@entry=0x2d02420, table=table@entry=0x7f3804006e90, function=function@entry=HA_EXTRA_FORCE_REOPEN) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_base.cc:2226 #6 0x0000000000789e64 in simple_rename_or_index_change (alter_ctx=0x7f3875b9f2c0, keys_onoff=Alter_info::DISABLE, table_list=0x7f38040057c0, thd=0x2d02420) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:7573 #7 mysql_alter_table (thd=thd@entry=0x2d02420, new_db=, new_name=0x7f3804040400 "PK>\001", create_info=create_info@entry=0x7f3875b9fed0, table_list=table_list@entry=0x7f38040057c0, alter_info=alter_info@entry=0x7f3875b9fe10, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:8074 #8 0x0000000000886a78 in Sql_cmd_alter_table::execute (this=, thd=0x2d02420) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_alter.cc:317 #9 0x0000000000731411 in mysql_execute_command (thd=thd@entry=0x2d02420) 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=0x2d02420, rawbuf=rawbuf@entry=0x7f37e800c027 "ALTER TABLE CC DISABLE KEYS; ALTER TABLE D DISABLE KEYS; ALTER TABLE DD DISABLE KEYS; ALTER TABLE E DISABLE KEYS", length=length@entry=112, parser_state=parser_state@entry=0x7f3875ba1550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #11 0x0000000000737b8e in dispatch_command (command=, command@entry=COM_QUERY, thd=thd@entry=0x2d02420, packet=0x4
, packet@entry=0x2d06791 "", packet_length=packet_length@entry=295) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1513 #12 0x00000000007387ab in do_command (thd=thd@entry=0x2d02420) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #13 0x00000000007d76e7 in threadpool_process_request (thd=0x2d02420) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #14 0x00000000007d891f in handle_event (connection=0x2bdcf80) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #15 worker_main (param=param@entry=0x153d200 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #16 0x00000000009bbd73 in pfs_spawn_thread (arg=0x2bb9c20) 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 1 (LWP 30832): +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=0x7f3814044240) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:2468 #8 handler::ha_thd (this=0x7f3814044240) 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=0x7f3814044240) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/handler.cc:4124 #10 0x00000000005eb218 in handler::ha_write_row (this=0x7f3814044240, buf=0x7f3814009440 ) 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=0x7f381404b0b0, to=to@entry=0x7f381404f540, create=..., ignore=ignore@entry=false, order_num=order_num@entry=0, order=order@entry=0x0, copied=copied@entry=0x7f3875ca26c0, deleted=deleted@entry=0x7f3875ca26c8, keys_onoff=Alter_info::LEAVE_AS_IS, alter_ctx=alter_ctx@entry=0x7f3875ca32c0) 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=0x2cc1ef0, new_db=, new_name=0x7f381404f540 "\020\376\004\024\070\177", create_info=create_info@entry=0x7f3875ca3ed0, table_list=table_list@entry=0x7f3814004ff8, alter_info=0x7f381404f540, alter_info@entry=0x7f3875ca3e10, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_table.cc:8553 #13 0x0000000000886a78 in Sql_cmd_alter_table::execute (this=, thd=0x2cc1ef0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_alter.cc:317 #14 0x0000000000731411 in mysql_execute_command (thd=thd@entry=0x2cc1ef0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:5287 #15 0x0000000000736c38 in mysql_parse (thd=thd@entry=0x2cc1ef0, rawbuf=, length=, parser_state=parser_state@entry=0x7f3875ca5550) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:6647 #16 0x0000000000737991 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2cc1ef0, packet=packet@entry=0x2c9d5b1 "ALTER TABLE query030879 . `t1` DROP COLUMN `pk`", packet_length=packet_length@entry=47) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1438 #17 0x00000000007387ab in do_command (thd=thd@entry=0x2cc1ef0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/sql_parse.cc:1051 #18 0x00000000007d76e7 in threadpool_process_request (thd=0x2cc1ef0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_common.cc:313 #19 0x00000000007d891f in handle_event (connection=0x2c408f0) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1468 #20 worker_main (param=param@entry=0x153ce00 ) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/sql/threadpool_unix.cc:1521 #21 0x00000000009bbd73 in pfs_spawn_thread (arg=0x2c37910) at /bzr/5.6_dbg/Percona-Server-5.6.14-rel62.0/storage/perfschema/pfs.cc:1858 #22 0x000000362fa07851 in start_thread () from /lib64/libpthread.so.0 #23 0x000000362f2e894d in clone () from /lib64/libc.so.6 (gdb) +set logging off