(gdb) +thread apply all bt Thread 43 (LWP 18633): +bt #0 0x000000340c4db6a7 in access () from /lib64/libc.so.6 #1 0x000000000062056d in mysql_register_view (thd=0x20026a0, view=0x7ff76c004e80, mode=VIEW_CREATE_OR_REPLACE) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:942 #2 0x00000000006215ea in mysql_create_view (thd=, views=0x7ff76c004e80, mode=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:659 #3 0x00000000005a4ed1 in mysql_execute_command (thd=0x20026a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4497 #4 0x00000000005a5d30 in mysql_parse (thd=0x20026a0, rawbuf=0x7ff76c004c10 "CREATE OR REPLACE VIEW transforms.view_18624_probe AS SELECT * FROM `table1000_innodb_int_autoinc` AS X WHERE X . `col_set_binary_key` < 2 LIMIT 8 LOCK IN SHARE MODE /*Generated by THREAD_ID 20*/", length=, parser_state=0x7ff7c47dbb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #5 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x20026a0, packet=, packet_length=197) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #6 0x00000000005a8783 in do_command (thd=0x20026a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #7 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #8 0x000000000064f8ce in handle_one_connection (arg=0x20026a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #9 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #10 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 42 (LWP 18554): +bt #0 0x000000340cc0ec0d in fsync () from /lib64/libpthread.so.0 #1 0x00000000007eca55 in my_sync (fd=93, my_flags=48) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_sync.c:76 #2 0x00000000007ecbcf in my_sync_dir (dir_name=, my_flags=16) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_sync.c:142 #3 0x00000000007ecc43 in my_sync_dir_by_file (file_name=, my_flags=16) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_sync.c:182 #4 0x0000000000634a5f in mysql_create_frm (thd=0x1f72dd0, file_name=0x7ff7c954e360 "./transforms/insert_select_18553.frm", db=0x7ff7b80ef920 "", table=, create_info=, create_fields=..., keys=0, key_info=0x7ff7b80826c8, db_file=0x7ff7b8004c10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:452 #5 0x0000000000634f53 in rea_create_table (thd=0x1f72dd0, path=0x7ff7c954f290 "./transforms/insert_select_18553", db=0x7ff7b8081c70 "transforms", table_name=0x7ff7b8081c80 "insert_select_18553", create_info=0x7ff7c9550bd0, create_fields=..., keys=0, key_info=0x7ff7b80826c8, file=0x7ff7b8004c10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:519 #6 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1f72dd0, db=0x7ff7b8081c70 "transforms", table_name=0x7ff7b8081c80 "insert_select_18553", create_info=0x7ff7c9550bd0, alter_info=0x7ff7c95505e0, internal_tmp_table=155, select_field_count=1, is_trans=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #7 0x00000000005896bb in create_table_from_items (thd=0x1f72dd0, create_info=0x7ff7c9550bd0, create_table=0x7ff7b8081cd8, alter_info=0x7ff7c95505e0, items=, lock=0x7ff7c95502c8, hooks=0x7ff7c9550280) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3785 #8 0x000000000058c82f in select_create::prepare (this=0x7ff7b8082448, values=..., u=0x1f74a90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3938 #9 0x00000000005d1651 in JOIN::prepare (this=0x7ff7b8020d90, rref_pointer_array=0x1f75298, tables_init=, wild_num=, conds_init=, og_num=3087147536, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1f750b0, unit_arg=0x1f74a90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:750 #10 0x00000000005e5da4 in mysql_select (thd=0x1f72dd0, rref_pointer_array=0x1f75298, tables=0x0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7ff7b8082448, unit=0x1f74a90, select_lex=0x1f750b0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2624 #11 0x00000000005e63ae in handle_select (thd=0x1f72dd0, lex=0x1f749d0, result=0x7ff7b8082448, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #12 0x00000000005a1700 in mysql_execute_command (thd=0x1f72dd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2757 #13 0x00000000005a5d30 in mysql_parse (thd=0x1f72dd0, rawbuf=0x7ff7b8081b80 "CREATE TABLE transforms.insert_select_18553 SELECT 1", length=, parser_state=0x7ff7c9551b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #14 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1f72dd0, packet=, packet_length=53) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #15 0x00000000005a8783 in do_command (thd=0x1f72dd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #16 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #17 0x000000000064f8ce in handle_one_connection (arg=0x1f72dd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #18 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #19 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 41 (LWP 21540): +bt #0 0x000000340cc0ec0d in fsync () from /lib64/libpthread.so.0 #1 0x00000000007eca55 in my_sync (fd=95, my_flags=48) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_sync.c:76 #2 0x00000000007ecbcf in my_sync_dir (dir_name=, my_flags=16) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_sync.c:142 #3 0x00000000007ecc43 in my_sync_dir_by_file (file_name=, my_flags=16) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_sync.c:182 #4 0x0000000000634a5f in mysql_create_frm (thd=0x1fa7e10, file_name=0x7ff7c4652940 "./query018560/t1.frm", db=0x7ff754028e80 "\230\005", table=, create_info=, create_fields=..., keys=9, key_info=0x7ff754004bf0, db_file=0x7ff75402a2e8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:452 #5 0x0000000000634f53 in rea_create_table (thd=0x1fa7e10, path=0x7ff7c4653870 "./query018560/t1", db=0x7ff75400c578 "query018560", table_name=0x7ff75400c588 "t1", create_info=0x7ff7c4654310, create_fields=..., keys=9, key_info=0x7ff754004bf0, file=0x7ff75402a2e8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:519 #6 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1fa7e10, db=0x7ff75400c578 "query018560", table_name=0x7ff75400c588 "t1", create_info=0x7ff7c4654310, alter_info=0x7ff7c46543f0, internal_tmp_table=155, select_field_count=0, is_trans=0x7ff7c465452f) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #7 0x0000000000608d1c in mysql_create_like_table (thd=0x1fa7e10, table=0x7ff75400c5c0, src_table=0x7ff75400cba8, create_info=0x7ff7c4654bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4670 #8 0x00000000005a175b in mysql_execute_command (thd=0x1fa7e10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2774 #9 0x00000000005a5d30 in mysql_parse (thd=0x1fa7e10, rawbuf=0x7ff75400c470 "CREATE TABLE query018560 . t1 LIKE test . `table10_innodb_int_autoinc`", length=, parser_state=0x7ff7c4655b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #10 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1fa7e10, packet=, packet_length=70) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #11 0x00000000005a8783 in do_command (thd=0x1fa7e10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #12 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #13 0x000000000064f8ce in handle_one_connection (arg=0x1fa7e10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #14 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #15 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 40 (LWP 18607): +bt #0 0x000000340c464457 in rename () from /lib64/libc.so.6 #1 0x00000000007ebcc8 in my_rename (from=0x7ff7c92826a0 "./transforms/view_18604_probe.frm~", to=0x7ff7c92828b0 "./transforms/view_18604_probe.frm", MyFlags=16) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_rename.c:54 #2 0x00000000005277c9 in inline_mysql_file_rename (flags=16, to=0x7ff7c92828b0 "./transforms/view_18604_probe.frm", from=0x7ff7c92826a0 "./transforms/view_18604_probe.frm~", src_line=290, src_file=0xa3c550 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/parse_file.cc", key=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_file.h:1314 #3 sql_create_definition_file (dir=, file_name=, type=, base=0x7ff700000000
, parameters=0x7ff7c9282bd0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/parse_file.cc:290 #4 0x0000000000620788 in mysql_register_view (thd=0x1fc63d0, view=0x7ff78c004e30, mode=VIEW_CREATE_OR_REPLACE) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:1031 #5 0x00000000006215ea in mysql_create_view (thd=, views=0x7ff78c004e30, mode=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:659 #6 0x00000000005a4ed1 in mysql_execute_command (thd=0x1fc63d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4497 #7 0x00000000005a5d30 in mysql_parse (thd=0x1fc63d0, rawbuf=0x7ff78c004c10 "CREATE OR REPLACE VIEW transforms.view_18604_probe AS SELECT X . `pk` FROM `table10_innodb_int_autoinc` AS X LIMIT 8 FOR UPDATE /*Generated by THREAD_ID 13*/", length=, parser_state=0x7ff7c9286b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #8 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1fc63d0, packet=, packet_length=159) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #9 0x00000000005a8783 in do_command (thd=0x1fc63d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #10 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #11 0x000000000064f8ce in handle_one_connection (arg=0x1fc63d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #12 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #13 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 39 (LWP 18611): +bt #0 0x000000340cc0ec0d in fsync () from /lib64/libpthread.so.0 #1 0x00000000007eca55 in my_sync (fd=59, my_flags=48) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_sync.c:76 #2 0x00000000007ecbcf in my_sync_dir (dir_name=, my_flags=16) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_sync.c:142 #3 0x00000000007ecc43 in my_sync_dir_by_file (file_name=, my_flags=16) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/my_sync.c:182 #4 0x0000000000634a5f in mysql_create_frm (thd=0x1fcdfe0, file_name=0x7ff7c9242360 "./transforms/insert_select_18600.frm", db=0x7ff78001c430 "\350\006", table=, create_info=, create_fields=..., keys=0, key_info=0x7ff7800299a8, db_file=0x7ff78002ad60) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:452 #5 0x0000000000634f53 in rea_create_table (thd=0x1fcdfe0, path=0x7ff7c9243290 "./transforms/insert_select_18600", db=0x7ff780004e90 "transforms", table_name=0x7ff780004ea0 "insert_select_18600", create_info=0x7ff7c9244bd0, create_fields=..., keys=0, key_info=0x7ff7800299a8, file=0x7ff78002ad60) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/unireg.cc:519 #6 0x00000000006069c7 in mysql_create_table_no_lock (thd=0x1fcdfe0, db=0x7ff780004e90 "transforms", table_name=0x7ff780004ea0 "insert_select_18600", create_info=0x7ff7c9244bd0, alter_info=0x7ff7c92445e0, internal_tmp_table=155, select_field_count=17, is_trans=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:4333 #7 0x00000000005896bb in create_table_from_items (thd=0x1fcdfe0, create_info=0x7ff7c9244bd0, create_table=0x7ff780004ef8, alter_info=0x7ff7c92445e0, items=, lock=0x7ff7c92442c8, hooks=0x7ff7c9244280) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3785 #8 0x000000000058c82f in select_create::prepare (this=0x7ff7800064e8, values=..., u=0x1fcfca0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:3938 #9 0x00000000005d1651 in JOIN::prepare (this=0x7ff780024c10, rref_pointer_array=0x1fd04a8, tables_init=, wild_num=, conds_init=, og_num=2147639440, order_init=0x7ff780006040, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x1fd02c0, unit_arg=0x1fcfca0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:750 #10 0x00000000005e5da4 in mysql_select (thd=0x1fcdfe0, rref_pointer_array=0x1fd04a8, tables=0x7ff7800055d8, wild_num=1, fields=..., conds=0x7ff780005d98, og_num=3, order=0x7ff780006040, group=0x0, having=0x0, proc_param=0x0, select_options=2416184064, result=0x7ff7800064e8, unit=0x1fcfca0, select_lex=0x1fd02c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2624 #11 0x00000000005e63ae in handle_select (thd=0x1fcdfe0, lex=0x1fcfbe0, result=0x7ff7800064e8, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #12 0x00000000005a1700 in mysql_execute_command (thd=0x1fcdfe0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2757 #13 0x00000000005a5d30 in mysql_parse (thd=0x1fcdfe0, rawbuf=0x7ff780004c10 "CREATE TABLE transforms.insert_select_18600 SELECT * FROM test . `table100_innodb_int_autoinc` AS table1 WHERE table1 . `col_set_binary_key` <= table1 . `col_text_binary_key` ORDER BY table1 . `col_bit_64_key` , table1 . `col_bit_64_key` , table1 . `pk`", length=, parser_state=0x7ff7c9245b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #14 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1fcdfe0, packet=, packet_length=255) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #15 0x00000000005a8783 in do_command (thd=0x1fcdfe0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #16 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #17 0x000000000064f8ce in handle_one_connection (arg=0x1fcdfe0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #18 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #19 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 38 (LWP 17438): +bt #0 0x000000340cc0e54d in read () from /lib64/libpthread.so.0 #1 0x0000000000a2e46a in vio_read (vio=0x1f68b30, buf=0x1f6ec80 "\a", size=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/vio/viosocket.c:56 #2 0x000000000052472a in my_real_read (net=0x1ee3ed0, complen=0x7ff7c9592cc8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:834 #3 0x0000000000524a55 in my_net_read (net=0x1ee3ed0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:1033 #4 0x00000000005a8620 in do_command (thd=0x1ee3ca0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:735 #5 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #6 0x000000000064f8ce in handle_one_connection (arg=0x1ee3ca0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #7 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #8 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 37 (LWP 17284): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=3, array=0x1b63520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=5, message1=0x7ff7cc7d8db8, message2=0x7ff7cc7d8db0, type=0x7ff7cc7d8da8, space_id=0x7ff7cc7d8da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=5) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 36 (LWP 17431): +bt #0 0x000000340cc0f2a5 in sigwait () from /lib64/libpthread.so.0 #1 0x000000000051b6c1 in signal_hand (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mysqld.cc:2701 #2 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #3 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 35 (LWP 17283): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=2, array=0x1b63520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=4, message1=0x7ff7cd1d9db8, message2=0x7ff7cd1d9db0, type=0x7ff7cd1d9da8, space_id=0x7ff7cd1d9da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 34 (LWP 18562): +bt #0 0x000000340cc0e54d in read () from /lib64/libpthread.so.0 #1 0x0000000000a2e46a in vio_read (vio=0x1f7de60, buf=0x1f7e060 "\001", size=4) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/vio/viosocket.c:56 #2 0x000000000052472a in my_real_read (net=0x1f7ab00, complen=0x7ff7c9510cc8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:834 #3 0x0000000000524a55 in my_net_read (net=0x1f7ab00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/net_serv.cc:1033 #4 0x00000000005a8620 in do_command (thd=0x1f7a8d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:735 #5 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #6 0x000000000064f8ce in handle_one_connection (arg=0x1f7a8d0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #7 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #8 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 33 (LWP 17285): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=0, array=0x1b6b7a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=6, message1=0x7ff7cbdd7db8, message2=0x7ff7cbdd7db0, type=0x7ff7cbdd7da8, space_id=0x7ff7cbdd7da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=6) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 32 (LWP 17289): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=3, array=0x1b6b7a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=9, message1=0x7ff7c9fd4db8, message2=0x7ff7c9fd4db0, type=0x7ff7c9fd4da8, space_id=0x7ff7c9fd4da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=9) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 31 (LWP 18639): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c4716470, mutex=0x2019248, that=0x2019278) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x2019248, thd=0x2019140, abs_timeout=0x7ff7c4716470, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x2019248, mdl_request=0x7ff758005400, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x00000000005585f2 in open_table_get_mdl_lock (thd=0x2019140, ot_ctx=0x7ff7c47170a0, mdl_request=0x7ff758005400, flags=0, mdl_ticket=0x7ff7c4716f68) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2607 #5 0x0000000000561e08 in open_table (thd=0x2019140, table_list=0x7ff758005090, mem_root=0x7ff7c4717060, ot_ctx=0x7ff7c47170a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2940 #6 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff7c4717060, ot_ctx=0x7ff7c47170a0, has_prelocking_list=false, prelocking_strategy=0x7ff7c47174b0, flags=0, counter=0x7ff7c4717520, tables=0x7ff758005090, lex=0x201ad40, thd=0x2019140) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #7 open_tables (thd=0x2019140, start=0x7ff7c4717208, counter=0x7ff7c4717520, flags=0, prelocking_strategy=0x7ff7c47174b0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #8 0x000000000061acbe in open_tables (flags=0, counter=0x7ff7c4717520, tables=0x7ff7c4717208, thd=0x2019140) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:484 #9 mysql_update (thd=0x2019140, table_list=0x7ff758005090, fields=..., values=..., conds=0x7ff758005968, order_num=16, order=0x7ff758005bf8, limit=7, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7ff7c4718130, updated_return=0x7ff7c4718128) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_update.cc:284 #10 0x00000000005a1e0c in mysql_execute_command (thd=0x2019140) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3011 #11 0x00000000005a5d30 in mysql_parse (thd=0x2019140, rawbuf=0x7ff758004c10 "UPDATE `table1000_innodb` SET `col_int_not_null_key` = 25 WHERE `col_char_10` <= 'y' ORDER BY `col_bigint`,`col_bigint_key`,`col_bit_64`,`col_bit_64_key`,`col_set_binary`,`col_set_binary_key`,`col_set_utf8`,`col_set_utf8_key`,`col_text_binary`,`col_text_binary_key`,`col_text_utf8`,`col_text_utf8_key`,`col_varchar_255_binary`,`col_varchar_255_binary_key`,`col_varchar_255_utf8`,`col_varchar_255_utf8_key` LIMIT 7 /*Generated by THREAD_ID 23*/", length=, parser_state=0x7ff7c4718b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x2019140, packet=, packet_length=443) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x2019140) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x2019140) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 30 (LWP 17228): +bt #0 0x000000340c4df253 in poll () from /lib64/libc.so.6 #1 0x000000000051c7db in handle_connections_sockets () at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mysqld.cc:5346 #2 0x0000000000522b27 in mysqld_main (argc=46, argv=0x173f2a8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mysqld.cc:4789 #3 0x000000000051719d in main (argc=, argv=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/main.cc:25 Thread 29 (LWP 17282): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=1, array=0x1b63520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=3, message1=0x7ff7cdbdadb8, message2=0x7ff7cdbdadb0, type=0x7ff7cdbdada8, space_id=0x7ff7cdbdada0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=3) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 28 (LWP 18578): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000701cbf in inline_mysql_cond_timedwait (src_line=3809, src_file=0xad14c0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc", abstime=0x7ff7c944b850, mutex=0x1150d80 , that=0x7ff778008448) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 Interruptible_wait::wait (this=0x7ff7c944b920, cond=0x7ff778008448, mutex=0x1150d80 ) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3809 #3 0x000000000070df3d in Item_func_get_lock::val_int (this=0x7ff7a0004e60) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3912 #4 0x00000000006c4106 in Item::send (this=0x7ff7a0004e60, protocol=0x1f91860, buffer=0x7ff7c944bd00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item.cc:6002 #5 0x000000000052a49f in Protocol::send_result_set_row (this=0x1f91860, row_items=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/protocol.cc:847 #6 0x0000000000575862 in select_send::send_data (this=0x7ff7a0005008, items=...) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_class.cc:2369 #7 0x00000000005e3026 in JOIN::exec (this=0x7ff7a0005028) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:1918 #8 0x00000000005e5e13 in mysql_select (thd=0x1f91370, rref_pointer_array=0x1f93838, tables=0x0, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7ff7a0005008, unit=0x1f93030, select_lex=0x1f93650) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2645 #9 0x00000000005e63ae in handle_select (thd=0x1f91370, lex=0x1f92f70, result=0x7ff7a0005008, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #10 0x000000000059ce8e in execute_sqlcom_select (thd=0x1f91370, all_tables=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4819 #11 0x00000000005a0bcb in mysql_execute_command (thd=0x1f91370) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2322 #12 0x00000000005a5d30 in mysql_parse (thd=0x1f91370, rawbuf=0x7ff7a0004c10 "SELECT GET_LOCK('LOCK', 65535)", length=, parser_state=0x7ff7c944db10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1f91370, packet=, packet_length=31) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x1f91370) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x1f91370) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 27 (LWP 17281): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=0, array=0x1b63520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=2, message1=0x7ff7ce5dbdb8, message2=0x7ff7ce5dbdb0, type=0x7ff7ce5dbda8, space_id=0x7ff7ce5dbda0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=2) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 26 (LWP 18631): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c485bcc0, mutex=0x1ff35e8, that=0x1ff3618) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1ff35e8, thd=0x1ff34e0, abs_timeout=0x7ff7c485bcc0, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1ff35e8, mdl_request=0x7ff774005268, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1ff35e8, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x1ff34e0, tables_start=0x7ff774004d40, tables_end=, lock_wait_timeout=31536000, flags=3297099776) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x0000000000620947 in mysql_drop_view (thd=0x1ff34e0, views=0x7ff774004d40, drop_mode=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:1703 #7 0x00000000005a4f19 in mysql_execute_command (thd=0x1ff34e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4505 #8 0x00000000005a5d30 in mysql_parse (thd=0x1ff34e0, rawbuf=0x7ff774004c10 "DROP VIEW transforms.view_18618_probe", length=, parser_state=0x7ff7c485db10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #9 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1ff34e0, packet=, packet_length=37) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #10 0x00000000005a8783 in do_command (thd=0x1ff34e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #11 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #12 0x000000000064f8ce in handle_one_connection (arg=0x1ff34e0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #13 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #14 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 25 (LWP 17336): +bt #0 0x0000000000999992 in rec_validate (rec=0x7ff7d7cd254d "", offsets=0x7ff7c5320e70) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/rem/rem0rec.c:1710 #1 0x00000000008c884f in rec_fold (rec=0x7ff7d7cd254d "", offsets=0x7ff7c5320e70, n_fields=2, n_bytes=0, tree_id=5) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/include/rem0rec.ic:1647 #2 0x00000000008c9188 in btr_search_update_hash_on_delete (cursor=0x7ff7c5321570) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/btr/btr0sea.c:1771 #3 0x00000000008b862b in btr_cur_optimistic_delete (cursor=0x7ff7c5321570, mtr=0x7ff7c5321650) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/btr/btr0cur.c:3175 #4 0x00000000009a3ffc in row_purge_remove_sec_if_poss_leaf (node=, index=0x1e9b668, entry=0x7ff748000ce8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0purge.c:392 #5 0x00000000009a5d03 in row_purge_remove_sec_if_poss (entry=0x7ff748000ce8, index=0x1e9b668, node=0x1ebb318) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0purge.c:433 #6 row_purge_del_mark (node=0x1ebb318) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0purge.c:484 #7 0x00000000009a6759 in row_purge (thr=0x1ebb160, node=0x1ebb318) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0purge.c:765 #8 row_purge_step (thr=0x1ebb160) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/row/row0purge.c:805 #9 0x000000000099368d in que_thr_step (thr=0x1ebb160) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/que/que0que.c:1259 #10 que_run_threads_low (thr=0x1ebb160) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/que/que0que.c:1319 #11 que_run_threads (thr=0x1ebb160) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/que/que0que.c:1356 #12 0x00000000008857d1 in trx_purge (limit=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/trx/trx0purge.c:1220 #13 0x0000000000872d77 in srv_purge_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:4144 #14 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #15 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 24 (LWP 17335): +bt #0 0x000000340c4e14f3 in select () from /lib64/libc.so.6 #1 0x0000000000973c77 in os_thread_sleep (tm=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0thread.c:259 #2 0x0000000000877141 in srv_master_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:3466 #3 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #4 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 23 (LWP 18620): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c48dbb30, mutex=0x1fe4428, that=0x1fe4458) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1fe4428, thd=0x1fe4320, abs_timeout=0x7ff7c48dbb30, set_status_on_timeout=false, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x000000000065988c in MDL_context::acquire_lock (this=0x1fe4428, mdl_request=0x7ff77c0053f8, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2104 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1fe4428, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x1fe4320, tables_start=0x7ff77c005088, tables_end=, lock_wait_timeout=31536000, flags=3297623680) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x0000000000563f1d in open_tables (thd=0x1fe4320, start=0x7ff7c48dc0b8, counter=0x7ff7c48dc0fc, flags=0, prelocking_strategy=0x7ff7c48ddd80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4986 #7 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff77c005088, derived=false, flags=0, prelocking_strategy=0x7ff7c48ddd80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #8 0x000000000060abae in mysql_alter_table (thd=0x1fe4320, new_db=0x7ff77c0055b0 "test", new_name=0x0, create_info=0x7ff7c48de370, table_list=0x7ff77c005088, alter_info=0x7ff7c48de450, order_num=0, order=0x0, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:6001 #9 0x00000000007ce5dd in Alter_table_statement::execute (this=, thd=0x1fe4320) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_alter.cc:106 #10 0x00000000005a5445 in mysql_execute_command (thd=0x1fe4320) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4660 #11 0x00000000005a5d30 in mysql_parse (thd=0x1fe4320, rawbuf=0x7ff77c004c10 "/* GenTest::Transform::DisableIndexes */ ALTER TABLE table1000_innodb DISABLE KEYS; ALTER TABLE table1000_innodb_int DISABLE KEYS; ALTER TABLE table1000_innodb_int_autoinc DISABLE KEYS; ALTER TABLE table100_innodb DISABLE KEYS; ALTER TABLE table100_innodb_int DISABLE KEYS; ALTER TABLE table100_innodb_int_autoinc DISABLE KEYS; ALTER TABLE table10_innodb DISABLE KEYS; ALTER TABLE table10_innodb_int DISABLE KEYS; ALTER TABLE table10_innodb_int_autoinc DISABLE KEYS", length=, parser_state=0x7ff7c48dfb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1fe4320, packet=, packet_length=465) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1fe4320) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1fe4320) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 22 (LWP 17334): +bt #0 0x000000340c4e14f3 in select () from /lib64/libc.so.6 #1 0x0000000000973c77 in os_thread_sleep (tm=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0thread.c:259 #2 0x0000000000873339 in srv_LRU_dump_restore_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:3033 #3 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #4 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 21 (LWP 18650): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c4692b30, mutex=0x2028408, that=0x2028438) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x2028408, thd=0x2028300, abs_timeout=0x7ff7c4692b30, set_status_on_timeout=false, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x000000000065988c in MDL_context::acquire_lock (this=0x2028408, mdl_request=0x7ff7500053f8, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2104 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x2028408, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x2028300, tables_start=0x7ff750005088, tables_end=, lock_wait_timeout=31536000, flags=3295227520) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x0000000000563f1d in open_tables (thd=0x2028300, start=0x7ff7c46930b8, counter=0x7ff7c46930fc, flags=0, prelocking_strategy=0x7ff7c4694d80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4986 #7 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff750005088, derived=false, flags=0, prelocking_strategy=0x7ff7c4694d80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #8 0x000000000060abae in mysql_alter_table (thd=0x2028300, new_db=0x7ff7500055b0 "test", new_name=0x0, create_info=0x7ff7c4695370, table_list=0x7ff750005088, alter_info=0x7ff7c4695450, order_num=0, order=0x0, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:6001 #9 0x00000000007ce5dd in Alter_table_statement::execute (this=, thd=0x2028300) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_alter.cc:106 #10 0x00000000005a5445 in mysql_execute_command (thd=0x2028300) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4660 #11 0x00000000005a5d30 in mysql_parse (thd=0x2028300, rawbuf=0x7ff750004c10 "/* GenTest::Transform::DisableIndexes */ ALTER TABLE table1000_innodb DISABLE KEYS; ALTER TABLE table1000_innodb_int DISABLE KEYS; ALTER TABLE table1000_innodb_int_autoinc DISABLE KEYS; ALTER TABLE table100_innodb DISABLE KEYS; ALTER TABLE table100_innodb_int DISABLE KEYS; ALTER TABLE table100_innodb_int_autoinc DISABLE KEYS; ALTER TABLE table10_innodb DISABLE KEYS; ALTER TABLE table10_innodb_int DISABLE KEYS; ALTER TABLE table10_innodb_int_autoinc DISABLE KEYS", length=, parser_state=0x7ff7c4696b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x2028300, packet=, packet_length=465) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x2028300) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x2028300) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 20 (LWP 17280): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=0, array=0x1b552a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=1, message1=0x7ff7cefdcdb8, message2=0x7ff7cefdcdb0, type=0x7ff7cefdcda8, space_id=0x7ff7cefdcda0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=1) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 19 (LWP 17333): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009735ee in os_cond_wait_timed (abstime=0x7ff7c7124d60, mutex=0x19f27a0, cond=0x19f27d8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x19f27a0, time_in_usec=, reset_sig_count=1) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:716 #3 0x0000000000875e62 in srv_monitor_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:2624 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 18 (LWP 18619): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c491cb30, mutex=0x1fdcb48, that=0x1fdcb78) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1fdcb48, thd=0x1fdca40, abs_timeout=0x7ff7c491cb30, set_status_on_timeout=false, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x000000000065988c in MDL_context::acquire_lock (this=0x1fdcb48, mdl_request=0x7ff778005390, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2104 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1fdcb48, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x1fdca40, tables_start=0x7ff778005020, tables_end=, lock_wait_timeout=31536000, flags=3297889920) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x0000000000563f1d in open_tables (thd=0x1fdca40, start=0x7ff7c491d0b8, counter=0x7ff7c491d0fc, flags=0, prelocking_strategy=0x7ff7c491ed80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4986 #7 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff778005020, derived=false, flags=0, prelocking_strategy=0x7ff7c491ed80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #8 0x000000000060abae in mysql_alter_table (thd=0x1fdca40, new_db=0x7ff778005548 "test", new_name=0x0, create_info=0x7ff7c491f370, table_list=0x7ff778005020, alter_info=0x7ff7c491f450, order_num=0, order=0x0, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:6001 #9 0x00000000007ce5dd in Alter_table_statement::execute (this=, thd=0x1fdca40) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_alter.cc:106 #10 0x00000000005a5445 in mysql_execute_command (thd=0x1fdca40) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4660 #11 0x00000000005a5d30 in mysql_parse (thd=0x1fdca40, rawbuf=0x7ff778004c10 "ALTER TABLE table1000_innodb ENABLE KEYS; ALTER TABLE table1000_innodb_int ENABLE KEYS; ALTER TABLE table1000_innodb_int_autoinc ENABLE KEYS; ALTER TABLE table100_innodb ENABLE KEYS; ALTER TABLE table100_innodb_int ENABLE KEYS; ALTER TABLE table100_innodb_int_autoinc ENABLE KEYS; ALTER TABLE table10_innodb ENABLE KEYS; ALTER TABLE table10_innodb_int ENABLE KEYS; ALTER TABLE table10_innodb_int_autoinc ENABLE KEYS", length=, parser_state=0x7ff7c4920b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1fdca40, packet=, packet_length=415) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1fdca40) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1fdca40) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 17 (LWP 18577): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c948c560, mutex=0x1f89b98, that=0x1f89bc8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1f89b98, thd=0x1f89a90, abs_timeout=0x7ff7c948c560, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1f89b98, mdl_request=0x7ff7ac005108, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x00000000005585f2 in open_table_get_mdl_lock (thd=0x1f89a90, ot_ctx=0x7ff7c948d190, mdl_request=0x7ff7ac005108, flags=0, mdl_ticket=0x7ff7c948d058) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2607 #5 0x0000000000561e08 in open_table (thd=0x1f89a90, table_list=0x7ff7ac004d98, mem_root=0x7ff7c948d150, ot_ctx=0x7ff7c948d190) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2940 #6 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff7c948d150, ot_ctx=0x7ff7c948d190, has_prelocking_list=false, prelocking_strategy=0x7ff7c948d4c0, flags=0, counter=0x7ff7c948d2bc, tables=0x7ff7ac004d98, lex=0x1f8b690, thd=0x1f89a90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #7 open_tables (thd=0x1f89a90, start=0x7ff7c948d278, counter=0x7ff7c948d2bc, flags=0, prelocking_strategy=0x7ff7c948d4c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #8 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7ac004d98, derived=true, flags=0, prelocking_strategy=0x7ff7c948d4c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #9 0x0000000000591459 in open_and_lock_tables (flags=0, derived=true, tables=0x7ff7ac004d98, thd=0x1f89a90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:505 #10 mysql_insert (thd=0x1f89a90, table_list=0x7ff7ac004d98, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:740 #11 0x00000000005a21a4 in mysql_execute_command (thd=0x1f89a90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3136 #12 0x00000000005a5d30 in mysql_parse (thd=0x1f89a90, rawbuf=0x7ff7ac004c10 "INSERT INTO `table1000_innodb` ( `col_bit_64` ) VALUES ( 7 )", length=, parser_state=0x7ff7c948eb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1f89a90, packet=, packet_length=60) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x1f89a90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x1f89a90) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 16 (LWP 17286): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=1, array=0x1b6b7a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=7, message1=0x7ff7cb3d6db8, message2=0x7ff7cb3d6db0, type=0x7ff7cb3d6da8, space_id=0x7ff7cb3d6da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=7) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 15 (LWP 17279): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=0, array=0x1b47020) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=0, message1=0x7ff7dcc7edb8, message2=0x7ff7dcc7edb0, type=0x7ff7dcc7eda8, space_id=0x7ff7dcc7eda0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 14 (LWP 17331): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009735ee in os_cond_wait_timed (abstime=0x7ff7c8526d60, mutex=0x19f2720, cond=0x19f2758) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x19f2720, time_in_usec=, reset_sig_count=1) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:716 #3 0x00000000008745e8 in srv_lock_timeout_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:2774 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 13 (LWP 18615): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c9203150, mutex=0x1fd5268, that=0x1fd5298) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1fd5268, thd=0x1fd5160, abs_timeout=0x7ff7c9203150, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1fd5268, mdl_request=0x7ff784005270, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1fd5268, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x1fd5160, tables_start=0x7ff784004d48, tables_end=, lock_wait_timeout=31536000, flags=3374331024) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x000000000060a377 in mysql_rm_table (thd=0x1fd5160, tables=0x7ff784004d48, if_exists=0 '\000', drop_temporary=0 '\000') at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:1910 #7 0x00000000005a28d2 in mysql_execute_command (thd=0x1fd5160) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3328 #8 0x00000000005a5d30 in mysql_parse (thd=0x1fd5160, rawbuf=0x7ff784004c10 "DROP TABLE transforms.insert_select_18609", length=, parser_state=0x7ff7c9204b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #9 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1fd5160, packet=, packet_length=41) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #10 0x00000000005a8783 in do_command (thd=0x1fd5160) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #11 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #12 0x000000000064f8ce in handle_one_connection (arg=0x1fd5160) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #13 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #14 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 12 (LWP 17332): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009735ee in os_cond_wait_timed (abstime=0x7ff7c7b25d30, mutex=0x19f26a0, cond=0x19f26d8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x19f26a0, time_in_usec=, reset_sig_count=1) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0sync.c:716 #3 0x000000000087373f in srv_error_monitor_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0srv.c:2987 #4 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #5 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 11 (LWP 18637): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c4757560, mutex=0x2011968, that=0x2011998) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x2011968, thd=0x2011860, abs_timeout=0x7ff7c4757560, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x2011968, mdl_request=0x7ff764005450, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x00000000005585f2 in open_table_get_mdl_lock (thd=0x2011860, ot_ctx=0x7ff7c4758190, mdl_request=0x7ff764005450, flags=0, mdl_ticket=0x7ff7c4758058) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2607 #5 0x0000000000561e08 in open_table (thd=0x2011860, table_list=0x7ff7640050e0, mem_root=0x7ff7c4758150, ot_ctx=0x7ff7c4758190) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2940 #6 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff7c4758150, ot_ctx=0x7ff7c4758190, has_prelocking_list=false, prelocking_strategy=0x7ff7c47584c0, flags=0, counter=0x7ff7c47582bc, tables=0x7ff7640050e0, lex=0x2013460, thd=0x2011860) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #7 open_tables (thd=0x2011860, start=0x7ff7c4758278, counter=0x7ff7c47582bc, flags=0, prelocking_strategy=0x7ff7c47584c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #8 0x0000000000564d98 in open_and_lock_tables (thd=, tables=0x7ff7640050e0, derived=true, flags=0, prelocking_strategy=0x7ff7c47584c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5623 #9 0x0000000000591459 in open_and_lock_tables (flags=0, derived=true, tables=0x7ff7640050e0, thd=0x2011860) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:505 #10 mysql_insert (thd=0x2011860, table_list=0x7ff7640050e0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_insert.cc:740 #11 0x00000000005a21a4 in mysql_execute_command (thd=0x2011860) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3136 #12 0x00000000005a5d30 in mysql_parse (thd=0x2011860, rawbuf=0x7ff764004c10 "INSERT INTO `table1000_innodb` ( `col_set_binary_key` , `col_set_utf8` , `col_set_binary` ) VALUES ( CONVERT( 'jwmyiaashorjmejjkqkqoxctunoftvexhoogczwqyotyyvfucilcycbngpmrvifludyklfrojuounxdgxvdjgcaglltkrsphphtwvjhcycomdcosvzdynrneynziwsvfzdcftrcqljostrgotrbvdizdmredkmeysxljofroujzoosddyxmhddynnuenqui' , CHAR) , CONVERT( 'wmyiaashorjmejjkqkqoxctunoftvexhoogczwqyotyyvfucilcycbngpmrvifludyklfrojuounxdgxvdjgcaglltkrsphphtwvjhcycomdcosvzdynrneynziw' , CHAR) , REPEAT( 0xDF1 , 137 ) )", length=, parser_state=0x7ff7c4759b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x2011860, packet=, packet_length=483) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x2011860) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x2011860) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 10 (LWP 18632): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000701cbf in inline_mysql_cond_timedwait (src_line=3809, src_file=0xad14c0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc", abstime=0x7ff7c481a850, mutex=0x1150d80 , that=0x7ff778008448) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 Interruptible_wait::wait (this=0x7ff7c481a920, cond=0x7ff778008448, mutex=0x1150d80 ) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3809 #3 0x000000000070df3d in Item_func_get_lock::val_int (this=0x7ff768004e58) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3912 #4 0x00000000006c4106 in Item::send (this=0x7ff768004e58, protocol=0x1ffb2b0, buffer=0x7ff7c481ad00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item.cc:6002 #5 0x000000000052a49f in Protocol::send_result_set_row (this=0x1ffb2b0, row_items=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/protocol.cc:847 #6 0x0000000000575862 in select_send::send_data (this=0x7ff768005000, items=...) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_class.cc:2369 #7 0x00000000005e3026 in JOIN::exec (this=0x7ff768005020) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:1918 #8 0x00000000005e5e13 in mysql_select (thd=0x1ffadc0, rref_pointer_array=0x1ffd288, tables=0x0, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7ff768005000, unit=0x1ffca80, select_lex=0x1ffd0a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2645 #9 0x00000000005e63ae in handle_select (thd=0x1ffadc0, lex=0x1ffc9c0, result=0x7ff768005000, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #10 0x000000000059ce8e in execute_sqlcom_select (thd=0x1ffadc0, all_tables=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4819 #11 0x00000000005a0bcb in mysql_execute_command (thd=0x1ffadc0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2322 #12 0x00000000005a5d30 in mysql_parse (thd=0x1ffadc0, rawbuf=0x7ff768004c10 "SELECT GET_LOCK('LOCK', 65535)", length=, parser_state=0x7ff7c481cb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1ffadc0, packet=, packet_length=31) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x1ffadc0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x1ffadc0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 9 (LWP 17287): +bt #0 0x0000003fdda00614 in ?? () from /lib64/libaio.so.1 #1 0x000000000096f65c in os_aio_linux_collect (seg_size=256, segment=2, array=0x1b6b7a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4742 #2 os_aio_linux_handle (global_seg=8, message1=0x7ff7ca9d5db8, message2=0x7ff7ca9d5db0, type=0x7ff7ca9d5da8, space_id=0x7ff7ca9d5da0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/os/os0file.c:4887 #3 0x000000000091b6c3 in fil_aio_wait (segment=8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/fil/fil0fil.c:5666 #4 0x0000000000878dcf in io_handler_thread (arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/srv/srv0start.c:485 #5 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #6 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 8 (LWP 18599): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c9347cc0, mutex=0x1faf7f8, that=0x1faf828) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1faf7f8, thd=0x1faf6f0, abs_timeout=0x7ff7c9347cc0, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1faf7f8, mdl_request=0x7ff790005268, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1faf7f8, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000005616e0 in lock_table_names (thd=0x1faf6f0, tables_start=0x7ff790004d40, tables_end=, lock_wait_timeout=31536000, flags=3375661056) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4765 #6 0x0000000000620947 in mysql_drop_view (thd=0x1faf6f0, views=0x7ff790004d40, drop_mode=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_view.cc:1703 #7 0x00000000005a4f19 in mysql_execute_command (thd=0x1faf6f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4505 #8 0x00000000005a5d30 in mysql_parse (thd=0x1faf6f0, rawbuf=0x7ff790004c10 "DROP VIEW transforms.view_18595_probe", length=, parser_state=0x7ff7c9349b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #9 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1faf6f0, packet=, packet_length=37) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #10 0x00000000005a8783 in do_command (thd=0x1faf6f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #11 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #12 0x000000000064f8ce in handle_one_connection (arg=0x1faf6f0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #13 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #14 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 7 (LWP 18648): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000701cbf in inline_mysql_cond_timedwait (src_line=3809, src_file=0xad14c0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc", abstime=0x7ff7c46d5850, mutex=0x1150d80 , that=0x7ff778008448) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 Interruptible_wait::wait (this=0x7ff7c46d5920, cond=0x7ff778008448, mutex=0x1150d80 ) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3809 #3 0x000000000070df3d in Item_func_get_lock::val_int (this=0x7ff75c004e58) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3912 #4 0x00000000006c4106 in Item::send (this=0x7ff75c004e58, protocol=0x2020f10, buffer=0x7ff7c46d5d00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item.cc:6002 #5 0x000000000052a49f in Protocol::send_result_set_row (this=0x2020f10, row_items=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/protocol.cc:847 #6 0x0000000000575862 in select_send::send_data (this=0x7ff75c005000, items=...) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_class.cc:2369 #7 0x00000000005e3026 in JOIN::exec (this=0x7ff75c005020) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:1918 #8 0x00000000005e5e13 in mysql_select (thd=0x2020a20, rref_pointer_array=0x2022ee8, tables=0x0, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2148797184, result=0x7ff75c005000, unit=0x20226e0, select_lex=0x2022d00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2645 #9 0x00000000005e63ae in handle_select (thd=0x2020a20, lex=0x2022620, result=0x7ff75c005000, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #10 0x000000000059ce8e in execute_sqlcom_select (thd=0x2020a20, all_tables=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4819 #11 0x00000000005a0bcb in mysql_execute_command (thd=0x2020a20) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2322 #12 0x00000000005a5d30 in mysql_parse (thd=0x2020a20, rawbuf=0x7ff75c004c10 "SELECT GET_LOCK('LOCK', 65535)", length=, parser_state=0x7ff7c46d7b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x2020a20, packet=, packet_length=31) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x2020a20) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x2020a20) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 6 (LWP 18635): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c4796e00, mutex=0x200a088, that=0x200a0b8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x200a088, thd=0x2009f80, abs_timeout=0x7ff7c4796e00, set_status_on_timeout=false, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x000000000065988c in MDL_context::acquire_lock (this=0x200a088, mdl_request=0x7ff7c4796e70, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2104 #4 0x0000000000659b36 in MDL_context::upgrade_shared_lock_to_exclusive (this=0x200a088, mdl_ticket=0x7ff760004b60, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2283 #5 0x0000000000562f26 in wait_while_table_is_used (thd=0x2009f80, table=0x7ff76c0227e0, function=HA_EXTRA_FORCE_REOPEN) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2307 #6 0x000000000060b274 in mysql_alter_table (thd=0x2009f80, new_db=0x7ff760005548 "test", new_name=0x7ff760004fc8 "table1000_innodb", create_info=0x7ff7c4799370, table_list=0x7ff760005020, alter_info=0x7ff7c4799450, order_num=0, order=0x0, ignore=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_table.cc:6185 #7 0x00000000007ce5dd in Alter_table_statement::execute (this=, thd=0x2009f80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_alter.cc:106 #8 0x00000000005a5445 in mysql_execute_command (thd=0x2009f80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4660 #9 0x00000000005a5d30 in mysql_parse (thd=0x2009f80, rawbuf=0x7ff760004c10 "ALTER TABLE table1000_innodb ENABLE KEYS; ALTER TABLE table1000_innodb_int ENABLE KEYS; ALTER TABLE table1000_innodb_int_autoinc ENABLE KEYS; ALTER TABLE table100_innodb ENABLE KEYS; ALTER TABLE table100_innodb_int ENABLE KEYS; ALTER TABLE table100_innodb_int_autoinc ENABLE KEYS; ALTER TABLE table10_innodb ENABLE KEYS; ALTER TABLE table10_innodb_int ENABLE KEYS; ALTER TABLE table10_innodb_int_autoinc ENABLE KEYS", length=, parser_state=0x7ff7c479ab10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #10 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x2009f80, packet=, packet_length=415) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #11 0x00000000005a8783 in do_command (thd=0x2009f80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #12 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #13 0x000000000064f8ce in handle_one_connection (arg=0x2009f80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #14 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #15 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 5 (LWP 18594): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000701cbf in inline_mysql_cond_timedwait (src_line=3809, src_file=0xad14c0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc", abstime=0x7ff7c93c9850, mutex=0x1150d80 , that=0x7ff778008448) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 Interruptible_wait::wait (this=0x7ff7c93c9920, cond=0x7ff778008448, mutex=0x1150d80 ) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3809 #3 0x000000000070df3d in Item_func_get_lock::val_int (this=0x7ff798004ee0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3912 #4 0x00000000006c4106 in Item::send (this=0x7ff798004ee0, protocol=0x1fa0a20, buffer=0x7ff7c93c9d00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item.cc:6002 #5 0x000000000052a49f in Protocol::send_result_set_row (this=0x1fa0a20, row_items=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/protocol.cc:847 #6 0x0000000000575862 in select_send::send_data (this=0x7ff798005088, items=...) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_class.cc:2369 #7 0x00000000005e3026 in JOIN::exec (this=0x7ff7980050a8) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:1918 #8 0x00000000005e5e13 in mysql_select (thd=0x1fa0530, rref_pointer_array=0x1fa29f8, tables=0x0, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147781376, result=0x7ff798005088, unit=0x1fa21f0, select_lex=0x1fa2810) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2645 #9 0x00000000005e63ae in handle_select (thd=0x1fa0530, lex=0x1fa2130, result=0x7ff798005088, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #10 0x000000000059ce8e in execute_sqlcom_select (thd=0x1fa0530, all_tables=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4819 #11 0x00000000005a0bcb in mysql_execute_command (thd=0x1fa0530) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2322 #12 0x00000000005a5d30 in mysql_parse (thd=0x1fa0530, rawbuf=0x7ff798004c10 "/* GenTest::Transform::Count */ SELECT GET_LOCK('LOCK', 65535) /* TRANSFORM_OUTCOME_COUNT */", length=, parser_state=0x7ff7c93cbb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1fa0530, packet=, packet_length=93) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x1fa0530) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x1fa0530) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 4 (LWP 18601): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c9306470, mutex=0x1fb7408, that=0x1fb7438) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1fb7408, thd=0x1fb7300, abs_timeout=0x7ff7c9306470, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1fb7408, mdl_request=0x7ff794005138, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x00000000005585f2 in open_table_get_mdl_lock (thd=0x1fb7300, ot_ctx=0x7ff7c93070a0, mdl_request=0x7ff794005138, flags=0, mdl_ticket=0x7ff7c9306f68) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2607 #5 0x0000000000561e08 in open_table (thd=0x1fb7300, table_list=0x7ff794004dc8, mem_root=0x7ff7c9307060, ot_ctx=0x7ff7c93070a0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:2940 #6 0x0000000000564245 in open_and_process_table (new_frm_mem=0x7ff7c9307060, ot_ctx=0x7ff7c93070a0, has_prelocking_list=false, prelocking_strategy=0x7ff7c93074b0, flags=0, counter=0x7ff7c9307520, tables=0x7ff794004dc8, lex=0x1fb8f00, thd=0x1fb7300) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:4504 #7 open_tables (thd=0x1fb7300, start=0x7ff7c9307208, counter=0x7ff7c9307520, flags=0, prelocking_strategy=0x7ff7c93074b0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.cc:5019 #8 0x000000000061acbe in open_tables (flags=0, counter=0x7ff7c9307520, tables=0x7ff7c9307208, thd=0x1fb7300) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_base.h:484 #9 mysql_update (thd=0x1fb7300, table_list=0x7ff794004dc8, fields=..., values=..., conds=0x0, order_num=0, order=0x0, limit=7, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7ff7c9308130, updated_return=0x7ff7c9308128) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_update.cc:284 #10 0x00000000005a1e0c in mysql_execute_command (thd=0x1fb7300) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3011 #11 0x00000000005a5d30 in mysql_parse (thd=0x1fb7300, rawbuf=0x7ff794004c10 "UPDATE `table1000_innodb` SET `col_text_binary_key` = '20010112092019.030911' LIMIT 7", length=, parser_state=0x7ff7c9308b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1fb7300, packet=, packet_length=85) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1fb7300) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1fb7300) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 3 (LWP 18629): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000657a64 in inline_mysql_cond_timedwait (src_line=1191, src_file=0xa6d828 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc", abstime=0x7ff7c489ccf0, mutex=0x1febd08, that=0x1febd38) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=0x1febd08, thd=0x1febc00, abs_timeout=0x7ff7c489ccf0, set_status_on_timeout=true, wait_state_name=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:1191 #3 0x0000000000659918 in MDL_context::acquire_lock (this=0x1febd08, mdl_request=0x7ff7c489cdb0, lock_wait_timeout=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2120 #4 0x0000000000659d76 in MDL_context::acquire_locks (this=0x1febd08, mdl_requests=, lock_wait_timeout=31536000) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/mdl.cc:2214 #5 0x00000000007558f3 in lock_schema_name (thd=0x1febc00, db=0x7ff770004d30 "transforms") at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/lock.cc:789 #6 0x000000000058183f in mysql_create_db (thd=0x1febc00, db=0x7ff770004d30 "transforms", create_info=0x7ff7c489dbd0, silent=false) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_db.cc:559 #7 0x00000000005a2f55 in mysql_execute_command (thd=0x1febc00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3513 #8 0x00000000005a5d30 in mysql_parse (thd=0x1febc00, rawbuf=0x7ff770004c10 "/* GenTest::Transform::ExecuteAsView */ CREATE DATABASE IF NOT EXISTS transforms", length=, parser_state=0x7ff7c489eb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #9 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1febc00, packet=, packet_length=80) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #10 0x00000000005a8783 in do_command (thd=0x1febc00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #11 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #12 0x000000000064f8ce in handle_one_connection (arg=0x1febc00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #13 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #14 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 2 (LWP 18606): +bt #0 0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000701cbf in inline_mysql_cond_timedwait (src_line=3809, src_file=0xad14c0 "/bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc", abstime=0x7ff7c92c5850, mutex=0x1150d80 , that=0x7ff778008448) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/include/mysql/psi/mysql_thread.h:1009 #2 Interruptible_wait::wait (this=0x7ff7c92c5920, cond=0x7ff778008448, mutex=0x1150d80 ) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3809 #3 0x000000000070df3d in Item_func_get_lock::val_int (this=0x7ff788004e58) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item_func.cc:3912 #4 0x00000000006c4106 in Item::send (this=0x7ff788004e58, protocol=0x1fbecb0, buffer=0x7ff7c92c5d00) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/item.cc:6002 #5 0x000000000052a49f in Protocol::send_result_set_row (this=0x1fbecb0, row_items=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/protocol.cc:847 #6 0x0000000000575862 in select_send::send_data (this=0x7ff788005000, items=...) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_class.cc:2369 #7 0x00000000005e3026 in JOIN::exec (this=0x7ff788005020) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:1918 #8 0x00000000005e5e13 in mysql_select (thd=0x1fbe7c0, rref_pointer_array=0x1fc0c88, tables=0x0, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7ff788005000, unit=0x1fc0480, select_lex=0x1fc0aa0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:2645 #9 0x00000000005e63ae in handle_select (thd=0x1fbe7c0, lex=0x1fc03c0, result=0x7ff788005000, setup_tables_done_option=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_select.cc:313 #10 0x000000000059ce8e in execute_sqlcom_select (thd=0x1fbe7c0, all_tables=0x0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:4819 #11 0x00000000005a0bcb in mysql_execute_command (thd=0x1fbe7c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:2322 #12 0x00000000005a5d30 in mysql_parse (thd=0x1fbe7c0, rawbuf=0x7ff788004c10 "SELECT GET_LOCK('LOCK', 65535)", length=, parser_state=0x7ff7c92c7b10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #13 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1fbe7c0, packet=, packet_length=31) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #14 0x00000000005a8783 in do_command (thd=0x1fbe7c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #15 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #16 0x000000000064f8ce in handle_one_connection (arg=0x1fbe7c0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #18 0x000000340c4e890d in clone () from /lib64/libc.so.6 Thread 1 (LWP 18591): +bt #0 0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000007ef479 in my_write_core (sig=6) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/mysys/stacktrace.c:433 #2 0x00000000006b6c75 in handle_fatal_signal (sig=6) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/signal_handler.cc:250 #3 #4 0x000000340c4328a5 in raise () from /lib64/libc.so.6 #5 0x000000340c434085 in abort () from /lib64/libc.so.6 #6 0x00000000008273c3 in ha_innobase::unlock_row (this=0x7ff798015e10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/storage/innobase/handler/ha_innodb.cc:6589 #7 0x00000000006b527f in find_all_keys (param=, select=0x7ff7a4056050, sort_keys=0x7ff7a4010690, buffpek_pointers=0x7ff7c940aaa0, tempfile=0x7ff7c940abc0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/filesort.cc:654 #8 0x00000000006b5e9a in filesort (thd=0x1f98c50, table=0x7ff798015530, sortorder=0x7ff7a40561b8, s_length=16, select=0x7ff7a4056050, max_rows=140701585180304, sort_positions=true, examined_rows=0x7ff7c940b518) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/filesort.cc:248 #9 0x00000000007a8d58 in mysql_delete (thd=0x1f98c50, table_list=0x7ff7a4005120, conds=0x7ff7a4009c78, order_list=, limit=1, options=0) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_delete.cc:243 #10 0x00000000005a259e in mysql_execute_command (thd=0x1f98c50) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:3256 #11 0x00000000005a5d30 in mysql_parse (thd=0x1f98c50, rawbuf=0x7ff7a4004c10 "DELETE FROM `table10_innodb_int_autoinc` WHERE `col_bigint_key` IN ( SELECT `col_bit_64_key` FROM `table1000_innodb` WHERE `pk` = 233 ) ORDER BY `col_bigint`,`col_bigint_key`,`col_bit_64`,`col_bit_64_key`,`col_set_binary`,`col_set_binary_key`,`col_set_utf8`,`col_set_utf8_key`,`col_text_binary`,`col_text_binary_key`,`col_text_utf8`,`col_text_utf8_key`,`col_varchar_255_binary`,`col_varchar_255_binary_key`,`col_varchar_255_utf8`,`col_varchar_255_utf8_key` LIMIT 1 /*Generated by THREAD_ID 6*/", length=, parser_state=0x7ff7c940cb10) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:5889 #12 0x00000000005a70a2 in dispatch_command (command=COM_QUERY, thd=0x1f98c50, packet=, packet_length=495) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:1079 #13 0x00000000005a8783 in do_command (thd=0x1f98c50) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_parse.cc:789 #14 0x000000000064f7cf in do_handle_one_connection (thd_arg=) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1487 #15 0x000000000064f8ce in handle_one_connection (arg=0x1f98c50) at /bzr/5.5_dbg/Percona-Server-5.5.32-rel31.0/sql/sql_connect.cc:1402 #16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0 #17 0x000000340c4e890d in clone () from /lib64/libc.so.6 (gdb) +set logging off