(gdb) +thread apply all bt

Thread 48 (LWP 2122):
+bt
#0  0x000000340cc0ec0d in fsync () from /lib64/libpthread.so.0
#1  0x0000000000a6a28d in os_file_fsync (file=8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:2285
#2  os_file_flush_func (file=8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:2386
#3  0x0000000000bbe7a3 in pfs_os_file_flush_func (src_line=5722, file=8, src_file=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/include/os0file.ic:355
#4  fil_flush (space_id=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5722
#5  0x0000000000a52e9b in log_write_up_to (lsn=<optimized out>, wait=<optimized out>, flush_to_disk=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/log/log0log.cc:1587
#6  0x0000000000b2c8e7 in trx_flush_log_if_needed (trx=0x7f872803fac8, lsn=5552169) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/trx/trx0trx.cc:1310
#7  trx_commit_in_memory (trx=0x7f872803fac8, lsn=5552169) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/trx/trx0trx.cc:1453
#8  0x0000000000b2e278 in trx_commit_low (trx=0x7f872803fac8, mtr=0x7f8799944d00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/trx/trx0trx.cc:1567
#9  0x0000000000b2e616 in trx_commit (trx=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/trx/trx0trx.cc:1588
#10 0x0000000000b2e6ab in trx_commit_for_mysql (trx=0x7f872803fac8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/trx/trx0trx.cc:1816
#11 0x0000000000aca758 in row_rename_table_for_mysql (old_name=<optimized out>, new_name=<optimized out>, trx=0x7f872803fac8, commit=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/row/row0mysql.cc:5068
#12 0x0000000000a07f30 in innobase_rename_table (to=0x7f87999461e0 "./test/#sql2-7fd-1a#P#p0", from=0x7f87999463e0 "./test/table100_key_pk_parts_2_int_autoinc#P#p0", trx=0x7f872803fac8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:10572
#13 ha_innobase::rename_table (this=<optimized out>, from=0x7f87999463e0 "./test/table100_key_pk_parts_2_int_autoinc#P#p0", to=0x7f87999461e0 "./test/#sql2-7fd-1a#P#p0") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:10690
#14 0x0000000000c65585 in ha_partition::del_ren_table (this=0x7f87280493d0, from=0x7f8799946d20 "./test/table100_key_pk_parts_2_int_autoinc", to=0x7f8799946b10 "./test/#sql2-7fd-1a") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:2276
#15 0x0000000000c6587b in ha_partition::rename_table (this=0x7f87280493d0, from=0x7f8799946d20 "./test/table100_key_pk_parts_2_int_autoinc", to=0x7f8799946b10 "./test/#sql2-7fd-1a") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:578
#16 0x000000000077476f in mysql_rename_table (base=<optimized out>, old_db=0x7f8728005410 "test", old_name=0x7f8728004df0 "table100_key_pk_parts_2_int_autoinc", new_db=0x7f8728005410 "test", new_name=0x7f8799948b40 "#sql2-7fd-1a", flags=2) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:5139
#17 0x000000000078305c in mysql_alter_table (thd=<optimized out>, new_db=0x7f8799948980 "\340jN\001", new_name=0x7f87280159b0 "h\a", create_info=<optimized out>, table_list=0x7f8728004eb0, alter_info=0x7f8799949270, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8591
#18 0x0000000000892ca7 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x1bf5210) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_alter.cc:317
#19 0x000000000072102b in mysql_execute_command (thd=0x1bf5210) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5157
#20 0x0000000000727818 in mysql_parse (thd=0x1bf5210, rawbuf=0x1bf75d8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#21 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1bf5210, packet=0x1bf8b91 "ALTER TABLE `table100_key_pk_parts_2_int_autoinc` MODIFY `col_set_latin1_not_null` DATETIME NULL AFTER `col_char_64_utf8_key`", packet_length=125) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#22 0x0000000000729a47 in do_command (thd=0x1bf5210) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#23 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#24 0x00000000006ed727 in handle_one_connection (arg=0x1bf5210) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#25 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1a40870) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#26 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#27 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 47 (LWP 2055):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=1, array=0x1690cb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=7, message1=0x7f87a1884d98, message2=0x7f87a1884d90, type=0x7f87a1884d88, space_id=0x7f87a1884d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=7) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 46 (LWP 2068):
+bt
#0  0x000000340cc0f2a5 in sigwait () from /lib64/libpthread.so.0
#1  0x00000000005a1edb in signal_hand (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:3159
#2  0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1a6c100) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#3  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#4  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 45 (LWP 2082):
+bt
#0  0x000000340c4cf3a7 in sched_yield () from /lib64/libc.so.6
#1  0x0000000000b0da09 in mutex_spin_wait (mutex=0x1a1b758, file_name=0xe00808 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc", line=955) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/sync/sync0sync.cc:514
#2  0x0000000000b9a8e0 in pfs_mutex_enter_func (mutex=0x1a1b758, line=955, file_name=0xe00808 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/include/sync0sync.ic:251
#3  0x0000000000b9ae01 in dict_table_open_on_name (table_name=0x7f879f97b5b0 "test/table0_int_autoinc", dict_locked=0, try_drop=1, ignore_err=DICT_ERR_IGNORE_NONE) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc:955
#4  0x0000000000a0bfa4 in ha_innobase::open (this=0x7f8770023620, name=0x7f8740022540 "./test/table0_int_autoinc", mode=<optimized out>, test_if_locked=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:4996
#5  0x00000000005b76fa in handler::ha_open (this=0x7f8770023620, table_arg=<optimized out>, name=0x7f8740022540 "./test/table0_int_autoinc", mode=2, test_if_locked=2) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.cc:2478
#6  0x00000000007c24cc in open_table_from_share (thd=0x1b0f6f0, share=<optimized out>, alias=<optimized out>, db_stat=39, prgflag=<optimized out>, ha_open_flags=0, outparam=0x7f877001b7c0, is_create_table=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table.cc:2318
#7  0x00000000006c6fb4 in open_table (thd=0x1b0f6f0, table_list=0x7f87700081f0, ot_ctx=0x7f879f97c1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:3082
#8  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f97c1e0, has_prelocking_list=false, prelocking_strategy=0x7f879f97c300, flags=0, counter=0x1b11b70, tables=0x7f87700081f0, lex=0x1b11ab8, thd=0x1b0f6f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#9  open_tables (thd=0x1b0f6f0, start=0x7f879f97c2c8, counter=0x1b11b70, flags=0, prelocking_strategy=0x7f879f97c300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#10 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8770007c90, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#11 0x000000000071eb4d in execute_sqlcom_select (thd=0x1b0f6f0, all_tables=0x7f8770007c90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278
#12 0x00000000007217b7 in mysql_execute_command (thd=0x1b0f6f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#13 0x0000000000727818 in mysql_parse (thd=0x1b0f6f0, rawbuf=0x1b11ab8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#14 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1b0f6f0, packet=0x1b14e41 " SELECT MIN( table2 . `col_varchar_10_latin1` ) AS field1 , table1 . `col_enum_utf8_not_null_key` AS field2 , table2 . `col_datetime_key_default_null` AS field3 , table1 . `col_set_utf8_key` AS field4 , table1 . `col_int_not_null_key` AS field5 , table2 . `col_set_utf8_key_default_null` AS field6 , table1 . `col_char_64_latin1_not_null_key` AS field7 , table3 . `col_datetime_key_default_null` AS field8 , table1 . `col_char_64_latin1_not_null_key` AS field9 , table2 . `col_char_64_utf8_key_default_null` AS field10 FROM   table2_int_autoinc AS table1  RIGHT JOIN table0_int_autoinc AS table2 ON  table1 . `col_int_key` =  table2 . `col_int_key`   LEFT JOIN table2_int_autoinc AS table3 ON  table1 . `col_int_key` =  table3 . `col_int_key`  WHERE  table1 . `pk` IS NULL AND   table1 . `pk` >= 7 AND table1 . `pk` <= ( 7 + 4 ) OR  table1 . `col_varchar_1024_utf8_key` IN ('p') OR table1 . `col_varchar_1024_utf8_key` LIKE ( 'DPZUB' ) OR  table1 . `col_varchar_10_utf8_key` >= 'a' AND table1 . `col_varchar_10_utf8_key` <= 'w' AND   table1 . `col_int_key` IN ( 9, 3 ) OR  table1 . `pk` >= table2 . `col_int` AND table1 . `pk` <> 4 OR table1 . `pk` > 7 AND table1 . `pk` <= ( 7 + 5 ) OR  table1 . `col_varchar_10_latin1_key` > 'i' AND table1 . `col_varchar_10_latin1_key` <= 'z'  GROUP BY field2, field3, field4, field5, field6, field7, field8, field9, field10 ORDER BY field1, field2, field3, field4, field5, field6, field7, field8, field9, field10 ASC", packet_length=1453) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#15 0x0000000000729a47 in do_command (thd=0x1b0f6f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#16 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#17 0x00000000006ed727 in handle_one_connection (arg=0x1b0f6f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#18 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#19 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#20 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 44 (LWP 2069):
+bt
#0  0x000000340c4df253 in poll () from /lib64/libc.so.6
#1  0x0000000000c9e846 in vio_io_wait (vio=<optimized out>, event=VIO_IO_EVENT_READ, timeout=28800000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:820
#2  0x0000000000c9ece3 in vio_socket_io_wait (vio=<optimized out>, event=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:68
#3  0x0000000000c9f680 in vio_read (vio=0x1bb3050, buf=0x1bb3240 "\a", size=4) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:123
#4  0x000000000067b583 in net_read_raw_loop (net=0x1ad5f30, count=4) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:663
#5  0x000000000067c0e1 in net_read_packet_header (net=0x1ad5f30) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:745
#6  net_read_packet (net=<optimized out>, complen=0x7f879fa40c68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:810
#7  0x000000000067c3ec in my_net_read (net=0x1ad5f30) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:888
#8  0x00000000007299d7 in do_command (thd=0x1ad5cd0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:983
#9  0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#10 0x00000000006ed727 in handle_one_connection (arg=0x1ad5cd0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#11 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1b9e760) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#12 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#13 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 43 (LWP 2116):
+bt
#0  0x000000340c4df253 in poll () from /lib64/libc.so.6
#1  0x0000000000c9e846 in vio_io_wait (vio=<optimized out>, event=VIO_IO_EVENT_READ, timeout=28800000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:820
#2  0x0000000000c9ece3 in vio_socket_io_wait (vio=<optimized out>, event=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:68
#3  0x0000000000c9f680 in vio_read (vio=0x1b5ebe0, buf=0x1be1ee0 ".", size=4) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/vio/viosocket.c:123
#4  0x000000000067b583 in net_read_raw_loop (net=0x1bde7c0, count=4) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:663
#5  0x000000000067c0e1 in net_read_packet_header (net=0x1bde7c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:745
#6  net_read_packet (net=<optimized out>, complen=0x7f879f6b2c68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:810
#7  0x000000000067c3ec in my_net_read (net=0x1bde7c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/net_serv.cc:888
#8  0x00000000007299d7 in do_command (thd=0x1bde560) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:983
#9  0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#10 0x00000000006ed727 in handle_one_connection (arg=0x1bde560) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#11 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#12 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#13 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 42 (LWP 2084):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f9394e0, mutex=0x1acc468, that=0x1acc498) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1acc468, owner=0x1acc330, abs_timeout=0x7f879f9394e0, set_status_on_timeout=false, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679f1f in MDL_context::acquire_lock (this=0x1acc468, mdl_request=0x7f879f939560, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2229
#4  0x000000000067a18a in MDL_context::upgrade_shared_lock (this=0x1acc468, mdl_ticket=0x7f876401a920, new_type=MDL_EXCLUSIVE, lock_wait_timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2411
#5  0x000000000077e070 in mysql_inplace_alter_table (thd=0x1acc330, table_list=0x7f8764004e08, table=0x7f876402d680, altered_table=0x7f8764047480, ha_alter_info=0x7f879f93b270, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f879f93af70, alter_ctx=0x7f879f939950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:6400
#6  0x00000000007839b7 in mysql_alter_table (thd=<optimized out>, new_db=0x7f8764047480 "P}\004d\207\177", new_name=0x7f8700000000 <Address 0x7f8700000000 out of bounds>, create_info=<optimized out>, table_list=0x7f8764004e08, alter_info=0x7f879f93b410, order_num=0, order=0x0, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_table.cc:8354
#7  0x0000000000724f83 in mysql_execute_command (thd=0x1acc330) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3310
#8  0x0000000000727818 in mysql_parse (thd=0x1acc330, rawbuf=0x1ace6f8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#9  0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1acc330, packet=0x1b366d1 " DROP INDEX `test_idx` ON table10_key_pk_parts_2_int_autoinc", packet_length=60) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#10 0x0000000000729a47 in do_command (thd=0x1acc330) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#11 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#12 0x00000000006ed727 in handle_one_connection (arg=0x1acc330) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#13 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#14 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#15 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 41 (LWP 2107):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f7b4780, mutex=0x1b3d7f8, that=0x1b3d828) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1b3d7f8, owner=0x1b3d6c0, abs_timeout=0x7f879f7b4780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1b3d7f8, mdl_request=0x7f874c024e78, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1b3d6c0, ot_ctx=0x7f879f7b51e0, mdl_request=0x7f874c024e78, flags=<optimized out>, mdl_ticket=0x7f879f7b50e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1b3d6c0, table_list=0x7f874c024ad8, ot_ctx=0x7f879f7b51e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f7b51e0, has_prelocking_list=false, prelocking_strategy=0x7f879f7b5300, flags=0, counter=0x1b3fb40, tables=0x7f874c024ad8, lex=0x1b3fa88, thd=0x1b3d6c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1b3d6c0, start=0x7f879f7b52c8, counter=0x1b3fb40, flags=0, prelocking_strategy=0x7f879f7b5300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f874c0053c0, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000071eb4d in execute_sqlcom_select (thd=0x1b3d6c0, all_tables=0x7f874c0053c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278
#10 0x00000000007217b7 in mysql_execute_command (thd=0x1b3d6c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#11 0x0000000000727818 in mysql_parse (thd=0x1b3d6c0, rawbuf=0x1b3fa88 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1b3d6c0, packet=0x1ac3b71 "  SELECT alias1 . `col_int_unsigned_key` AS field1 FROM   table1_int_autoinc AS alias1  LEFT JOIN table10_int_autoinc AS alias2 ON  alias1 . `col_varchar_1024_latin1` =  alias2 . `col_varchar_1024_latin1_key`   LEFT JOIN   table2_key_pk_parts_2_int_autoinc AS alias3  LEFT JOIN table0_int_autoinc AS alias4 ON  alias3 . `col_varchar_1024_latin1_key` =  alias4 . `col_varchar_1024_latin1_key`   LEFT JOIN table10_key_pk_parts_2_int_autoinc AS alias5 ON  alias3 . `col_int` =  alias5 . `pk`  ON  alias2 . `col_int_key` =  alias3 . `pk`  WHERE  alias4 . `pk` >= 9 AND alias4 . `pk` <= ( 9 + 1 ) OR alias4 . `pk` IS NULL AND  alias5 . `col_int_key` IS NULL ", packet_length=653) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1b3d6c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1b3d6c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 40 (LWP 2105):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f7f5470, mutex=0x1a7f048, that=0x1a7f078) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1a7f048, owner=0x1a7ef10, abs_timeout=0x7f879f7f5470, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1a7f048, mdl_request=0x7f8748005220, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1a7ef10, ot_ctx=0x7f879f7f5ed0, mdl_request=0x7f8748005220, flags=<optimized out>, mdl_ticket=0x7f879f7f5dd8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1a7ef10, table_list=0x7f8748004e80, ot_ctx=0x7f879f7f5ed0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f7f5ed0, has_prelocking_list=false, prelocking_strategy=0x7f879f7f5ff0, flags=0, counter=0x1a81390, tables=0x7f8748004e80, lex=0x1a812d8, thd=0x1a7ef10) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1a7ef10, start=0x7f879f7f5fb8, counter=0x1a81390, flags=0, prelocking_strategy=0x7f879f7f5ff0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8748004e80, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000070ab54 in mysql_insert (thd=0x1a7ef10, table_list=0x7f8748004e80, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_insert.cc:703
#10 0x0000000000723de9 in mysql_execute_command (thd=0x1a7ef10) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3647
#11 0x0000000000727818 in mysql_parse (thd=0x1a7ef10, rawbuf=0x1a812d8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1a7ef10, packet=0x1ab7921 " INSERT INTO `table10_key_pk_parts_2_int_autoinc` ( `col_int_nokey` , `col_int_key` ) VALUES ( 230 , 139 ) ", packet_length=107) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1a7ef10) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1a7ef10) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 39 (LWP 2099):
+bt
#0  0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000a6f533 in os_cond_wait (fast_mutex=0x1a1b840, cond=0x1a1b880) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214
#2  os_event_wait_low (event=0x1a1b840, reset_sig_count=52) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610
#3  0x0000000000b0ba31 in sync_array_wait_event (arr=0x1652120, index=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/sync/sync0arr.cc:424
#4  0x0000000000b0d9ec in mutex_spin_wait (mutex=0x1a1b758, file_name=0xe00808 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc", line=955) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/sync/sync0sync.cc:583
#5  0x0000000000b9a8e0 in pfs_mutex_enter_func (mutex=0x1a1b758, line=955, file_name=0xe00808 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc") at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/include/sync0sync.ic:251
#6  0x0000000000b9ae01 in dict_table_open_on_name (table_name=0x7f8763ffc030 "test/table0_int_autoinc", dict_locked=0, try_drop=1, ignore_err=DICT_ERR_IGNORE_NONE) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0dict.cc:955
#7  0x0000000000a0bfa4 in ha_innobase::open (this=0x7f875801a520, name=0x7f8740022540 "./test/table0_int_autoinc", mode=<optimized out>, test_if_locked=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/handler/ha_innodb.cc:4996
#8  0x00000000005b76fa in handler::ha_open (this=0x7f875801a520, table_arg=<optimized out>, name=0x7f8740022540 "./test/table0_int_autoinc", mode=2, test_if_locked=2) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.cc:2478
#9  0x00000000007c24cc in open_table_from_share (thd=0x1b63010, share=<optimized out>, alias=<optimized out>, db_stat=39, prgflag=<optimized out>, ha_open_flags=0, outparam=0x7f87580470d0, is_create_table=false) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table.cc:2318
#10 0x00000000006c6fb4 in open_table (thd=0x1b63010, table_list=0x7f8758004e48, ot_ctx=0x7f8763ffcc60) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:3082
#11 0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f8763ffcc60, has_prelocking_list=false, prelocking_strategy=0x7f8763ffcd80, flags=0, counter=0x1b65490, tables=0x7f8758004e48, lex=0x1b653d8, thd=0x1b63010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#12 open_tables (thd=0x1b63010, start=0x7f8763ffcd48, counter=0x1b65490, flags=0, prelocking_strategy=0x7f8763ffcd80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#13 0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8758004e48, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#14 0x000000000079bf6d in mysql_update (thd=0x1b63010, table_list=0x7f8758004e48, fields=..., values=..., conds=0x7f8758005860, order_num=0, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f8763ffe038, updated_return=0x7f8763ffe040) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:251
#15 0x00000000007212cb in mysql_execute_command (thd=0x1b63010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3511
#16 0x0000000000727818 in mysql_parse (thd=0x1b63010, rawbuf=0x1b653d8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#17 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1b63010, packet=0x1b704d1 "UPDATE `table0_int_autoinc` SET `col_char_64_latin1_not_null` = 6 WHERE `col_char_64_utf8_not_null` <= 'fdffmenkbptynh'", packet_length=119) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#18 0x0000000000729a47 in do_command (thd=0x1b63010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#19 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#20 0x00000000006ed727 in handle_one_connection (arg=0x1b63010) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#21 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#22 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#23 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 38 (LWP 2051):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=1, array=0x1652080) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=3, message1=0x7f87a4088d98, message2=0x7f87a4088d90, type=0x7f87a4088d88, space_id=0x7f87a4088d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=3) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 37 (LWP 2066):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f879adced00, fast_mutex=0x1a19e40, cond=0x1a19e80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177
#2  os_event_wait_time_low (event=0x1a19e40, time_in_usec=<optimized out>, reset_sig_count=10) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723
#3  0x0000000000bb82e7 in dict_stats_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/dict/dict0stats_bg.cc:349
#4  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#5  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 36 (LWP 2109):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f773780, mutex=0x1bc79e8, that=0x1bc7a18) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1bc79e8, owner=0x1bc78b0, abs_timeout=0x7f879f773780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1bc79e8, mdl_request=0x7f8740005cc8, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1bc78b0, ot_ctx=0x7f879f7741e0, mdl_request=0x7f8740005cc8, flags=<optimized out>, mdl_ticket=0x7f879f7740e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1bc78b0, table_list=0x7f8740005928, ot_ctx=0x7f879f7741e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f7741e0, has_prelocking_list=false, prelocking_strategy=0x7f879f774300, flags=0, counter=0x1bc9d30, tables=0x7f8740005928, lex=0x1bc9c78, thd=0x1bc78b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1bc78b0, start=0x7f879f7742c8, counter=0x1bc9d30, flags=0, prelocking_strategy=0x7f879f774300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8740005348, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000071eb4d in execute_sqlcom_select (thd=0x1bc78b0, all_tables=0x7f8740005348) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278
#10 0x00000000007217b7 in mysql_execute_command (thd=0x1bc78b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#11 0x0000000000727818 in mysql_parse (thd=0x1bc78b0, rawbuf=0x1bc9c78 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1bc78b0, packet=0x1bcb231 "  SELECT table1 . `col_enum_utf8_not_null_key` AS field1 FROM  table0_int_autoinc AS table1  LEFT JOIN table100_key_pk_parts_2_int_autoinc AS table2 ON  table1 . `col_int_key` =  table2 . `col_int`  WHERE  table2 . `pk` > 7 AND table2 . `pk` <= ( 8 + 3 ) OR  table1 . `col_int` >= 8 AND table1 . `col_int` < ( 8 + 2 ) AND  table1 . `col_int_key` >= 9 AND table1 . `col_int_key` <= ( 8 + 0 ) OR table1 . `col_int_key` >= 8 AND table1 . `col_int_key` < ( 8 + 2 ) OR  table1 . `col_int_key` <> 2 AND table1 . `col_int_key` IS NOT NULL OR table1 . `col_int_key` < 1 ORDER BY field1 ASC ", packet_length=582) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1bc78b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1bc78b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 35 (LWP 2052):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=2, array=0x1652080) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=4, message1=0x7f87a3687d98, message2=0x7f87a3687d90, type=0x7f87a3687d88, space_id=0x7f87a3687d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=4) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 34 (LWP 2064):
+bt
#0  0x000000340c4e14f3 in select () from /lib64/libc.so.6
#1  0x0000000000a6f8bf in os_thread_sleep (tm=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0thread.cc:255
#2  0x0000000000b8174a in page_cleaner_sleep_if_needed (next_loop_time=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0flu.cc:2377
#3  buf_flush_page_cleaner_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0flu.cc:2418
#4  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#5  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 33 (LWP 2114):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f6f1780, mutex=0x1bd6d08, that=0x1bd6d38) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1bd6d08, owner=0x1bd6bd0, abs_timeout=0x7f879f6f1780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1bd6d08, mdl_request=0x7f87380055b8, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1bd6bd0, ot_ctx=0x7f879f6f21e0, mdl_request=0x7f87380055b8, flags=<optimized out>, mdl_ticket=0x7f879f6f20e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1bd6bd0, table_list=0x7f8738005218, ot_ctx=0x7f879f6f21e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f6f21e0, has_prelocking_list=false, prelocking_strategy=0x7f879f6f2300, flags=0, counter=0x1bd9050, tables=0x7f8738005218, lex=0x1bd8f98, thd=0x1bd6bd0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1bd6bd0, start=0x7f879f6f22c8, counter=0x1bd9050, flags=0, prelocking_strategy=0x7f879f6f2300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8738005218, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000071eb4d in execute_sqlcom_select (thd=0x1bd6bd0, all_tables=0x7f8738005218) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278
#10 0x00000000007217b7 in mysql_execute_command (thd=0x1bd6bd0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#11 0x0000000000727818 in mysql_parse (thd=0x1bd6bd0, rawbuf=0x1bd8f98 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1bd6bd0, packet=0x1bda551 " SELECT `col_int_key` AS c1 FROM `table100_key_pk_parts_2_int_autoinc` WHERE CAST( LAST_DAY( '0000-00-00 00:00:00' ) AS TIME ) IS NULL OR EXTRACT( DAY_MICROSECOND FROM LEAST( `col_char_64_latin1_key` , '2002-08-02' , CONVERT_TZ( '2006-12-04' , 'leap/Europe/Moscow' , 'leap/Europe/Moscow' ) , `col_set_latin1_not_null_key` , TIMESTAMP( '2004-02-18' , '12:30:40.009964' ) ) ) IS NOT NULL", packet_length=385) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1bd6bd0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1bd6bd0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 32 (LWP 2062):
+bt
#0  0x000000340c4e14f3 in select () from /lib64/libc.so.6
#1  0x0000000000a6f8bf in os_thread_sleep (tm=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0thread.cc:255
#2  0x0000000000b0131b in srv_master_sleep () at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:2803
#3  srv_master_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:2847
#4  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#5  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 31 (LWP 2050):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x1652080) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=2, message1=0x7f87a4a89d98, message2=0x7f87a4a89d90, type=0x7f87a4a89d88, space_id=0x7f87a4a89d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=2) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 30 (LWP 2118):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f87999ca780, mutex=0x1be6028, that=0x1be6058) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1be6028, owner=0x1be5ef0, abs_timeout=0x7f87999ca780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1be6028, mdl_request=0x7f873001a6d8, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1be5ef0, ot_ctx=0x7f87999cb1e0, mdl_request=0x7f873001a6d8, flags=<optimized out>, mdl_ticket=0x7f87999cb0e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1be5ef0, table_list=0x7f873001a338, ot_ctx=0x7f87999cb1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f87999cb1e0, has_prelocking_list=false, prelocking_strategy=0x7f87999cb300, flags=0, counter=0x1be8370, tables=0x7f873001a338, lex=0x1be82b8, thd=0x1be5ef0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1be5ef0, start=0x7f87999cb2c8, counter=0x1be8370, flags=0, prelocking_strategy=0x7f87999cb300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8730005970, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000071eb4d in execute_sqlcom_select (thd=0x1be5ef0, all_tables=0x7f8730005970) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278
#10 0x00000000007217b7 in mysql_execute_command (thd=0x1be5ef0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#11 0x0000000000727818 in mysql_parse (thd=0x1be5ef0, rawbuf=0x1be82b8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1be5ef0, packet=0x1be9871 "  SELECT table1 . `col_datetime_key` AS field1 , table2 . `col_set_utf8_key_default_null` AS field2 FROM   table0_int_autoinc AS table1  LEFT JOIN table2_int_autoinc AS table2 ON  table1 . `col_varchar_10_utf8_key` =  table2 . `col_varchar_10_utf8_key`   RIGHT JOIN  table0_int_autoinc AS table3  LEFT OUTER JOIN  table1_int_autoinc AS table4  RIGHT JOIN  table10_key_pk_parts_2_int_autoinc AS table5  LEFT OUTER JOIN  table100_key_pk_parts_2_int_autoinc AS table6  RIGHT JOIN table10_int_autoinc AS table7 ON  table6 . `col_int_key` =  table7 . `col_int_key`  ON  table5 . `col_int` =  table6 . `pk`  ON  table4 . `col_int_key` =  table6 . `col_int_key`  ON  table3 . `col_varchar_1024_utf8_key` =  table6 . `col_varchar_1024_utf8_key`  ON  table2 . `col_int_key` =  table7 . `col_int_key`  WHERE  table1 . `col_int_key` >= 1 AND table1 . `col_int_key` <= ( 7 + 1 ) OR table1 . `col_int_key` > 1 AND table1 . `col_int_key` < ( 0 + 1 ) AND  table3 . `col_varchar_1024_utf8_key` IS NULL OR table3 . `col_varchar_1024_utf8_key` > 'z' AND table3 . `col_varchar_1024_utf8_key` <= 'z' AND  table1 . `pk` > 4 AND table1 . `pk` < ( 1 + 8 ) OR table1 . `pk` BETWEEN 1 AND (1 + 7 ) ", packet_length=1173) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1be5ef0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1be5ef0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 29 (LWP 2101):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f877780, mutex=0x1b69cd8, that=0x1b69d08) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1b69cd8, owner=0x1b69ba0, abs_timeout=0x7f879f877780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1b69cd8, mdl_request=0x7f8750005530, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1b69ba0, ot_ctx=0x7f879f8781e0, mdl_request=0x7f8750005530, flags=<optimized out>, mdl_ticket=0x7f879f8780e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1b69ba0, table_list=0x7f8750005190, ot_ctx=0x7f879f8781e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f8781e0, has_prelocking_list=false, prelocking_strategy=0x7f879f878300, flags=0, counter=0x1b6c020, tables=0x7f8750005190, lex=0x1b6bf68, thd=0x1b69ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1b69ba0, start=0x7f879f8782c8, counter=0x1b6c020, flags=0, prelocking_strategy=0x7f879f878300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8750005190, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000071eb4d in execute_sqlcom_select (thd=0x1b69ba0, all_tables=0x7f8750005190) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278
#10 0x00000000007217b7 in mysql_execute_command (thd=0x1b69ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#11 0x0000000000727818 in mysql_parse (thd=0x1b69ba0, rawbuf=0x1b6bf68 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1b69ba0, packet=0x1aae431 "  SELECT table2 . `col_set_latin1` AS field1 FROM   table100_key_pk_parts_2_int_autoinc AS table1  LEFT JOIN table100_int_autoinc AS table2 ON  table1 . `pk` =  table2 . `col_int_key`   LEFT JOIN table0_int_autoinc AS table3 ON  table1 . `col_varchar_10_utf8_key` =  table3 . `col_varchar_1024_utf8_key`  WHERE  table1 . `col_varchar_10_utf8_key` IS NOT NULL ORDER BY field1 ", packet_length=375) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1b69ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1b69ba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 28 (LWP 2120):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f8799989780, mutex=0x1bed9b8, that=0x1bed9e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1bed9b8, owner=0x1bed880, abs_timeout=0x7f8799989780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1bed9b8, mdl_request=0x7f8734005b18, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1bed880, ot_ctx=0x7f879998a1e0, mdl_request=0x7f8734005b18, flags=<optimized out>, mdl_ticket=0x7f879998a0e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1bed880, table_list=0x7f8734005778, ot_ctx=0x7f879998a1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879998a1e0, has_prelocking_list=false, prelocking_strategy=0x7f879998a300, flags=0, counter=0x1befd00, tables=0x7f8734005778, lex=0x1befc48, thd=0x1bed880) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1bed880, start=0x7f879998a2c8, counter=0x1befd00, flags=0, prelocking_strategy=0x7f879998a300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8734005778, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000071eb4d in execute_sqlcom_select (thd=0x1bed880, all_tables=0x7f8734005778) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278
#10 0x00000000007217b7 in mysql_execute_command (thd=0x1bed880) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#11 0x0000000000727818 in mysql_parse (thd=0x1bed880, rawbuf=0x1befc48 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1bed880, packet=0x1bf1201 "  SELECT alias2 . `col_char_64_utf8_default_null` AS field1 , alias1 . `col_enum_utf8_not_null_key` AS field2 FROM   table100_key_pk_parts_2_int_autoinc AS alias1  LEFT JOIN  table10_key_pk_parts_2_int_autoinc AS alias2  LEFT JOIN table2_key_pk_parts_2_int_autoinc AS alias3 ON  alias2 . `col_int` =  alias3 . `pk`  ON  alias1 . `col_int_key` =  alias2 . `col_int`   RIGHT JOIN table0_int_autoinc AS alias4 ON  alias3 . `col_int` =  alias4 . `pk`  WHERE  alias4 . `col_varchar_1024_latin1_key` > 'j' AND alias4 . `col_varchar_1024_latin1_key` <= 'u' AND  alias4 . `col_int_key` > 0 AND alias4 . `col_int_key` <= ( 0 + 6 ) AND  alias4 . `pk` >= 0 AND alias4 . `pk` <= ( 0 + 1 ) AND  alias1 . `col_int_key` <> 35 AND alias1 . `col_int_key` NOT IN (2, 7) AND  alias3 . `col_varchar_10_latin1_key` >= 'to' AND alias3 . `col_varchar_10_latin1_key` < 'h' ORDER BY field2 , field2 , field1 ASC , field2 ", packet_length=896) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1bed880) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1bed880) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1a9ab20) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 27 (LWP 2060):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f879e9d4cc0, fast_mutex=0x164f850, cond=0x164f890) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177
#2  os_event_wait_time_low (event=0x164f850, time_in_usec=<optimized out>, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723
#3  0x0000000000b01ec1 in srv_error_monitor_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:2084
#4  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#5  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 26 (LWP 2097):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f8b87e0, mutex=0x1ba8768, that=0x1ba8798) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1ba8768, owner=0x1ba8630, abs_timeout=0x7f879f8b87e0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1ba8768, mdl_request=0x7f875c006460, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1ba8630, ot_ctx=0x7f879f8b9240, mdl_request=0x7f875c006460, flags=<optimized out>, mdl_ticket=0x7f879f8b9148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1ba8630, table_list=0x7f875c0060c0, ot_ctx=0x7f879f8b9240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f8b9240, has_prelocking_list=false, prelocking_strategy=0x7f879f8b9360, flags=0, counter=0x1baaab0, tables=0x7f875c0060c0, lex=0x1baa9f8, thd=0x1ba8630) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1ba8630, start=0x7f879f8b9328, counter=0x1baaab0, flags=0, prelocking_strategy=0x7f879f8b9360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f875c0060c0, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x00000000007219f2 in mysql_execute_command (thd=0x1ba8630) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705
#10 0x0000000000727818 in mysql_parse (thd=0x1ba8630, rawbuf=0x1baa9f8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1ba8630, packet=0x1adbda1 "INSERT INTO `table100_key_pk_parts_2_int_autoinc` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` FROM `table2_key_pk_parts_2_int_autoinc` WHERE `col_bigint_key` BETWEEN 25 AND 6 ORDER BY `col_char_64_latin1`,`col_char_64_latin1_default_null`,`col_char_64_latin1_key`,`col_char_64_latin1_key_default_null`,`col_char_64_latin1_not_null`,`col_char_64_latin1_not_null_key`,`col_char_64_utf8`,`col_char_64_utf8_default_null`,`col_char_64_utf8_key`,`col_char_64_utf8_key_default_null`,`col_char_64_utf8_not_null`,`col_char_64_utf8_not_null_key`,`col_datetime`,`col_datetime_default_null`,`col_datetime_key`,`col_datetime_key_default_null`,`col_datetime_not_null`,`col_datetime_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 25 /*Generated by THREAD_ID 6*/", packet_length=2437) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#12 0x0000000000729a47 in do_command (thd=0x1ba8630) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#13 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#14 0x00000000006ed727 in handle_one_connection (arg=0x1ba8630) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#17 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 25 (LWP 2132):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f87998042a0, mutex=0x1c1b318, that=0x1c1b348) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1c1b318, owner=0x1c1b1e0, abs_timeout=0x7f87998042a0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x00000000007c5124 in TABLE_SHARE::wait_for_old_version (this=0x7f876402a300, thd=0x1c1b1e0, abstime=0x7f87998042a0, deadlock_weight=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table.cc:3580
#4  0x00000000006cc35e in close_cached_tables (thd=0x1c1b1e0, tables=0x0, wait_for_refresh=true, timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1040
#5  0x000000000073e662 in reload_acl_and_cache (thd=0x1c1b1e0, options=4, tables=0x0, write_to_binlog=0x7f8799805040) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_reload.cc:275
#6  0x00000000007233f4 in mysql_execute_command (thd=0x1c1b1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:4407
#7  0x0000000000727818 in mysql_parse (thd=0x1c1b1e0, rawbuf=0x1c1d5a8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#8  0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1c1b1e0, packet=0x1c1eb61 "FLUSH TABLES", packet_length=12) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#9  0x0000000000729a47 in do_command (thd=0x1c1b1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#10 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#11 0x00000000006ed727 in handle_one_connection (arg=0x1c1b1e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#12 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1b3d4d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#13 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#14 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 24 (LWP 2054):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x1690cb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=6, message1=0x7f87a2285d98, message2=0x7f87a2285d90, type=0x7f87a2285d88, space_id=0x7f87a2285d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=6) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 23 (LWP 2112):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f732200, mutex=0x1bcf378, that=0x1bcf3a8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1bcf378, owner=0x1bcf240, abs_timeout=0x7f879f732200, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1bcf378, mdl_request=0x7f8744005d58, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1bcf240, ot_ctx=0x7f879f732c60, mdl_request=0x7f8744005d58, flags=<optimized out>, mdl_ticket=0x7f879f732b68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1bcf240, table_list=0x7f87440059b8, ot_ctx=0x7f879f732c60) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f732c60, has_prelocking_list=false, prelocking_strategy=0x7f879f732d80, flags=0, counter=0x1bd16c0, tables=0x7f87440059b8, lex=0x1bd1608, thd=0x1bcf240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1bcf240, start=0x7f879f732d48, counter=0x1bd16c0, flags=0, prelocking_strategy=0x7f879f732d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f87440059b8, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000079bf6d in mysql_update (thd=0x1bcf240, table_list=0x7f87440059b8, fields=..., values=..., conds=0x7f87440063e0, order_num=55, order=0x7f8744006820, limit=8, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f879f734038, updated_return=0x7f879f734040) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:251
#10 0x00000000007212cb in mysql_execute_command (thd=0x1bcf240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3511
#11 0x0000000000727818 in mysql_parse (thd=0x1bcf240, rawbuf=0x1bd1608 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1bcf240, packet=0x1bd2bc1 "UPDATE `table100_key_pk_parts_2_int_autoinc` SET `col_bigint` = 0 WHERE `col_int_not_null_key` BETWEEN 10 AND 4 ORDER BY `col_char_64_latin1`,`col_char_64_latin1_default_null`,`col_char_64_latin1_key`,`col_char_64_latin1_key_default_null`,`col_char_64_latin1_not_null`,`col_char_64_latin1_not_null_key`,`col_char_64_utf8`,`col_char_64_utf8_default_null`,`col_char_64_utf8_key`,`col_char_64_utf8_key_default_null`,`col_char_64_utf8_not_null`,`col_char_64_utf8_not_null_key`,`col_datetime`,`col_datetime_default_null`,`col_datetime_key`,`col_datetime_key_default_null`,`col_datetime_not_null`,`col_datetime_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 8", packet_length=1537) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1bcf240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1bcf240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 22 (LWP 2056):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=2, array=0x1690cb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=8, message1=0x7f87a0e83d98, message2=0x7f87a0e83d90, type=0x7f87a0e83d88, space_id=0x7f87a0e83d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 21 (LWP 2065):
+bt
#0  0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000a6f533 in os_cond_wait (fast_mutex=0x164f970, cond=0x164f9b0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:214
#2  os_event_wait_low (event=0x164f970, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:610
#3  0x0000000000b7c8ac in buf_dump_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/buf/buf0dump.cc:594
#4  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#5  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 20 (LWP 2063):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f879cbd1cd0, fast_mutex=0x164f7c0, cond=0x164f800) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177
#2  os_event_wait_time_low (event=0x164f7c0, time_in_usec=<optimized out>, reset_sig_count=1265) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723
#3  0x0000000000b04129 in srv_purge_coordinator_suspend (rseg_history_len=1158, slot=0x164f5d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:3144
#4  srv_purge_coordinator_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:3257
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 19 (LWP 2045):
+bt
#0  0x000000340c4df253 in poll () from /lib64/libc.so.6
#1  0x00000000005a37ca in handle_connections_sockets () at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:6243
#2  0x00000000005aac1b in mysqld_main (argc=48, argv=0x1555148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:5658
#3  0x000000340c41ecdd in __libc_start_main () from /lib64/libc.so.6
#4  0x000000000059b851 in _start ()

Thread 18 (LWP 2103):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f8367e0, mutex=0x1aa6948, that=0x1aa6978) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1aa6948, owner=0x1aa6810, abs_timeout=0x7f879f8367e0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1aa6948, mdl_request=0x7f8754006520, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1aa6810, ot_ctx=0x7f879f837240, mdl_request=0x7f8754006520, flags=<optimized out>, mdl_ticket=0x7f879f837148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1aa6810, table_list=0x7f8754006180, ot_ctx=0x7f879f837240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f837240, has_prelocking_list=false, prelocking_strategy=0x7f879f837360, flags=0, counter=0x1aa8c90, tables=0x7f8754006180, lex=0x1aa8bd8, thd=0x1aa6810) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1aa6810, start=0x7f879f837328, counter=0x1aa8c90, flags=0, prelocking_strategy=0x7f879f837360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8754006180, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x00000000007219f2 in mysql_execute_command (thd=0x1aa6810) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705
#10 0x0000000000727818 in mysql_parse (thd=0x1aa6810, rawbuf=0x1aa8bd8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1aa6810, packet=0x1bad041 " INSERT INTO `table100_key_pk_parts_2_int_autoinc` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` FROM `table0_key_pk_parts_2_int_autoinc` WHERE `col_enum_latin1_key` IN ( SELECT `col_enum_latin1_not_null_key` FROM `table10_key_pk_parts_2_int_autoinc` WHERE `pk` = 43515904 ) ORDER BY `col_char_64_latin1`,`col_char_64_latin1_default_null`,`col_char_64_latin1_key`,`col_char_64_latin1_key_default_null`,`col_char_64_latin1_not_null`,`col_char_64_latin1_not_null_key`,`col_char_64_utf8`,`col_char_64_utf8_default_null`,`col_char_64_utf8_key`,`col_char_64_utf8_key_default_null`,`col_char_64_utf8_not_null`,`col_char_64_utf8_not_null_key`,`col_datetime`,`col_datetime_default_null`,`col_datetime_key`,`col_datetime_key_default_null`,`col_datetime_not_null`,`col_datetime_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 50 /*Generated by THREAD_ID 9*/ ", packet_length=2536) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#12 0x0000000000729a47 in do_command (thd=0x1aa6810) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#13 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#14 0x00000000006ed727 in handle_one_connection (arg=0x1aa6810) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#17 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 17 (LWP 2053):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=3, array=0x1652080) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=5, message1=0x7f87a2c86d98, message2=0x7f87a2c86d90, type=0x7f87a2c86d88, space_id=0x7f87a2c86d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=5) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 16 (LWP 2061):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f879dfd3d30, fast_mutex=0x164f8e0, cond=0x164f920) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177
#2  os_event_wait_time_low (event=0x164f8e0, time_in_usec=<optimized out>, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723
#3  0x0000000000b032bc in srv_monitor_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0srv.cc:1822
#4  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#5  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 15 (LWP 2080):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f9bc7e0, mutex=0x1bbf8f8, that=0x1bbf928) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1bbf8f8, owner=0x1bbf7c0, abs_timeout=0x7f879f9bc7e0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1bbf8f8, mdl_request=0x7f876c006438, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1bbf7c0, ot_ctx=0x7f879f9bd240, mdl_request=0x7f876c006438, flags=<optimized out>, mdl_ticket=0x7f879f9bd148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1bbf7c0, table_list=0x7f876c006098, ot_ctx=0x7f879f9bd240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f879f9bd240, has_prelocking_list=false, prelocking_strategy=0x7f879f9bd360, flags=0, counter=0x1bc1c40, tables=0x7f876c006098, lex=0x1bc1b88, thd=0x1bbf7c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1bbf7c0, start=0x7f879f9bd328, counter=0x1bc1c40, flags=0, prelocking_strategy=0x7f879f9bd360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f876c006098, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x00000000007219f2 in mysql_execute_command (thd=0x1bbf7c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705
#10 0x0000000000727818 in mysql_parse (thd=0x1bbf7c0, rawbuf=0x1bc1b88 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1bbf7c0, packet=0x1bc3751 " REPLACE INTO `table100_key_pk_parts_2_int_autoinc` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` FROM `table2_int_autoinc` WHERE `col_char_10_not_null` >= 'n' ORDER BY `col_char_64_latin1`,`col_char_64_latin1_default_null`,`col_char_64_latin1_key`,`col_char_64_latin1_key_default_null`,`col_char_64_latin1_not_null`,`col_char_64_latin1_not_null_key`,`col_char_64_utf8`,`col_char_64_utf8_default_null`,`col_char_64_utf8_key`,`col_char_64_utf8_key_default_null`,`col_char_64_utf8_not_null`,`col_char_64_utf8_not_null_key`,`col_datetime`,`col_datetime_default_null`,`col_datetime_key`,`col_datetime_key_default_null`,`col_datetime_not_null`,`col_datetime_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 25 /*Generated by THREAD_ID 2*/ ", packet_length=2421) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#12 0x0000000000729a47 in do_command (thd=0x1bbf7c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#13 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#14 0x00000000006ed727 in handle_one_connection (arg=0x1bbf7c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1b921f0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#17 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 14 (LWP 2130):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f87998447e0, mutex=0x1c13988, that=0x1c139b8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1c13988, owner=0x1c13850, abs_timeout=0x7f87998447e0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1c13988, mdl_request=0x7f8718006438, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1c13850, ot_ctx=0x7f8799845240, mdl_request=0x7f8718006438, flags=<optimized out>, mdl_ticket=0x7f8799845148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1c13850, table_list=0x7f8718006098, ot_ctx=0x7f8799845240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f8799845240, has_prelocking_list=false, prelocking_strategy=0x7f8799845360, flags=0, counter=0x1c15cd0, tables=0x7f8718006098, lex=0x1c15c18, thd=0x1c13850) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1c13850, start=0x7f8799845328, counter=0x1c15cd0, flags=0, prelocking_strategy=0x7f8799845360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8718006098, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x00000000007219f2 in mysql_execute_command (thd=0x1c13850) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705
#10 0x0000000000727818 in mysql_parse (thd=0x1c13850, rawbuf=0x1c15c18 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1c13850, packet=0x1c171d1 " INSERT INTO `table100_key_pk_parts_2_int_autoinc` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` FROM `table10_int_autoinc` WHERE 0 BETWEEN 155 AND 2881683456 ORDER BY `col_char_64_latin1`,`col_char_64_latin1_default_null`,`col_char_64_latin1_key`,`col_char_64_latin1_key_default_null`,`col_char_64_latin1_not_null`,`col_char_64_latin1_not_null_key`,`col_char_64_utf8`,`col_char_64_utf8_default_null`,`col_char_64_utf8_key`,`col_char_64_utf8_key_default_null`,`col_char_64_utf8_not_null`,`col_char_64_utf8_not_null_key`,`col_datetime`,`col_datetime_default_null`,`col_datetime_key`,`col_datetime_key_default_null`,`col_datetime_not_null`,`col_datetime_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 10 /*Generated by THREAD_ID 22*/ ", packet_length=2421) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#12 0x0000000000729a47 in do_command (thd=0x1c13850) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#13 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#14 0x00000000006ed727 in handle_one_connection (arg=0x1c13850) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1a7e1d0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#17 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 13 (LWP 2067):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f879a3cdc90, fast_mutex=0x1a4a8d0, cond=0x1a4a910) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177
#2  os_event_wait_time_low (event=0x1a4a8d0, time_in_usec=<optimized out>, reset_sig_count=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723
#3  0x0000000000b38cc0 in ib_wqueue_timedwait (wq=0x1a4a718, wait_in_usecs=5000000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/ut/ut0wqueue.cc:154
#4  0x0000000000bebe50 in fts_optimize_thread (arg=0x1a4a718) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fts/fts0opt.cc:2932
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 12 (LWP 2049):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x1675770) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=1, message1=0x7f87a548ad98, message2=0x7f87a548ad90, type=0x7f87a548ad88, space_id=0x7f87a548ad80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=1) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 11 (LWP 2138):
+bt
#0  0x000000340cc0b43c in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00000000005a32ef in inline_mysql_cond_wait (src_line=2653, mutex=0x14e0440 <LOCK_thread_count>, that=0x14e23c0 <COND_thread_cache>, src_file=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1162
#2  block_until_new_connection () at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:2653
#3  one_thread_per_connection_end (thd=<optimized out>, block_pthread=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mysqld.cc:2747
#4  0x00000000006ed5be in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1629
#5  0x00000000006ed727 in handle_one_connection (arg=0x1c31e90) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#6  0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1b09e40) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#7  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#8  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 10 (LWP 2057):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=3, array=0x1690cb0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=9, message1=0x7f87a0482d98, message2=0x7f87a0482d90, type=0x7f87a0482d88, space_id=0x7f87a0482d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=9) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 9 (LWP 2059):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000a6eacb in os_cond_wait_timed (abstime=0x7f879f3d5d00, fast_mutex=0x1a140c0, cond=0x1a14100) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:177
#2  os_event_wait_time_low (event=0x1a140c0, time_in_usec=<optimized out>, reset_sig_count=6) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0sync.cc:723
#3  0x0000000000a4c871 in lock_wait_timeout_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/lock/lock0wait.cc:503
#4  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#5  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 8 (LWP 2128):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f87998857e0, mutex=0x1c0bff8, that=0x1c0c028) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1c0bff8, owner=0x1c0bec0, abs_timeout=0x7f87998857e0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1c0bff8, mdl_request=0x7f8724006468, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1c0bec0, ot_ctx=0x7f8799886240, mdl_request=0x7f8724006468, flags=<optimized out>, mdl_ticket=0x7f8799886148) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1c0bec0, table_list=0x7f87240060c8, ot_ctx=0x7f8799886240) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f8799886240, has_prelocking_list=false, prelocking_strategy=0x7f8799886360, flags=0, counter=0x1c0e340, tables=0x7f87240060c8, lex=0x1c0e288, thd=0x1c0bec0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1c0bec0, start=0x7f8799886328, counter=0x1c0e340, flags=0, prelocking_strategy=0x7f8799886360) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f87240060c8, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x00000000007219f2 in mysql_execute_command (thd=0x1c0bec0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3705
#10 0x0000000000727818 in mysql_parse (thd=0x1c0bec0, rawbuf=0x1c0e288 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#11 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1c0bec0, packet=0x1c0f841 " REPLACE INTO `table10_key_pk_parts_2_int_autoinc` ( `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` ) SELECT `col_char_10` , `col_char_10_key` , `col_char_10_not_null` , `col_char_10_not_null_key` , `col_char_255` , `col_char_255_key` , `col_char_255_not_null` , `col_char_255_not_null_key` , `col_int` , `col_int_key` , `col_int_not_null` , `col_int_not_null_key` , `col_bigint` , `col_bigint_key` , `col_bigint_not_null` , `col_bigint_not_null_key` , `col_enum` , `col_enum_key` , `col_enum_not_null` , `col_enum_not_null_key` FROM `table10_key_pk_parts_2_int_autoinc` WHERE `col_char_255_not_null_key` != 'TZMMW' ORDER BY `col_char_64_latin1`,`col_char_64_latin1_default_null`,`col_char_64_latin1_key`,`col_char_64_latin1_key_default_null`,`col_char_64_latin1_not_null`,`col_char_64_latin1_not_null_key`,`col_char_64_utf8`,`col_char_64_utf8_default_null`,`col_char_64_utf8_key`,`col_char_64_utf8_key_default_null`,`col_char_64_utf8_not_null`,`col_char_64_utf8_not_null_key`,`col_datetime`,`col_datetime_default_null`,`col_datetime_key`,`col_datetime_key_default_null`,`col_datetime_not_null`,`col_datetime_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 100 /*Generated by THREAD_ID 21*/ ", packet_length=2447) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#12 0x0000000000729a47 in do_command (thd=0x1c0bec0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#13 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#14 0x00000000006ed727 in handle_one_connection (arg=0x1c0bec0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#15 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1a9cda0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#16 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#17 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 7 (LWP 2073):
+bt
#0  0x000000340c4ac66a in times () from /lib64/libc.so.6
#1  0x0000000000c6a121 in my_timer_ticks () at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/mysys/my_rdtsc.c:357
#2  0x00000000009e0ec7 in end_statement_v1 (locker=0x1bb8e50, stmt_da=0x1bbaa00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:4746
#3  0x0000000000727cb4 in inline_mysql_end_statement (stmt_da=0x1bbaa00, locker=0x1bb8e50) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_statement.h:223
#4  dispatch_command (command=<optimized out>, thd=0x1bb73a0, packet=<optimized out>, packet_length=56) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1789
#5  0x0000000000729a47 in do_command (thd=0x1bb73a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#6  0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#7  0x00000000006ed727 in handle_one_connection (arg=0x1bb73a0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#8  0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1afb330) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#9  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#10 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 6 (LWP 2047):
+bt
#0  0x0000003fdda00614 in ?? () from /lib64/libaio.so.1
#1  0x0000000000a68f83 in os_aio_linux_collect (seg_size=256, segment=0, array=0x1683210) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5089
#2  os_aio_linux_handle (global_seg=0, message1=0x7f87b7bd7d98, message2=0x7f87b7bd7d90, type=0x7f87b7bd7d88, space_id=0x7f87b7bd7d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/os/os0file.cc:5234
#3  0x0000000000bbdc67 in fil_aio_wait (segment=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/fil/fil0fil.cc:5575
#4  0x0000000000b055e8 in io_handler_thread (arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/innobase/srv/srv0start.cc:479
#5  0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#6  0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 5 (LWP 2094):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f879f8fa2a0, mutex=0x1bbb798, that=0x1bbb7c8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1bbb798, owner=0x1bbb660, abs_timeout=0x7f879f8fa2a0, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x00000000007c5124 in TABLE_SHARE::wait_for_old_version (this=0x7f876402a300, thd=0x1bbb660, abstime=0x7f879f8fa2a0, deadlock_weight=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/table.cc:3580
#4  0x00000000006cc35e in close_cached_tables (thd=0x1bbb660, tables=0x0, wait_for_refresh=true, timeout=31536000) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:1040
#5  0x000000000073e662 in reload_acl_and_cache (thd=0x1bbb660, options=4, tables=0x0, write_to_binlog=0x7f879f8fb040) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_reload.cc:275
#6  0x00000000007233f4 in mysql_execute_command (thd=0x1bbb660) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:4407
#7  0x0000000000727818 in mysql_parse (thd=0x1bbb660, rawbuf=0x1bbda28 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#8  0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1bbb660, packet=0x1b30e41 "FLUSH TABLES", packet_length=12) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#9  0x0000000000729a47 in do_command (thd=0x1bbb660) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#10 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#11 0x00000000006ed727 in handle_one_connection (arg=0x1bbb660) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#12 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1acc270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#13 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#14 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 4 (LWP 2126):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f87998c6200, mutex=0x1c04668, that=0x1c04698) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1c04668, owner=0x1c04530, abs_timeout=0x7f87998c6200, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1c04668, mdl_request=0x7f8720005d68, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1c04530, ot_ctx=0x7f87998c6c60, mdl_request=0x7f8720005d68, flags=<optimized out>, mdl_ticket=0x7f87998c6b68) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1c04530, table_list=0x7f87200059c8, ot_ctx=0x7f87998c6c60) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f87998c6c60, has_prelocking_list=false, prelocking_strategy=0x7f87998c6d80, flags=0, counter=0x1c069b0, tables=0x7f87200059c8, lex=0x1c068f8, thd=0x1c04530) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1c04530, start=0x7f87998c6d48, counter=0x1c069b0, flags=0, prelocking_strategy=0x7f87998c6d80) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f87200059c8, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000079bf6d in mysql_update (thd=0x1c04530, table_list=0x7f87200059c8, fields=..., values=..., conds=0x7f8720006338, order_num=55, order=0x7f8720006778, limit=7, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f87998c8038, updated_return=0x7f87998c8040) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:251
#10 0x00000000007212cb in mysql_execute_command (thd=0x1c04530) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3511
#11 0x0000000000727818 in mysql_parse (thd=0x1c04530, rawbuf=0x1c068f8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1c04530, packet=0x1c07eb1 " UPDATE `table100_key_pk_parts_2_int_autoinc` SET `col_bigint` = 7 WHERE 0 BETWEEN 4 AND 5 ORDER BY `col_char_64_latin1`,`col_char_64_latin1_default_null`,`col_char_64_latin1_key`,`col_char_64_latin1_key_default_null`,`col_char_64_latin1_not_null`,`col_char_64_latin1_not_null_key`,`col_char_64_utf8`,`col_char_64_utf8_default_null`,`col_char_64_utf8_key`,`col_char_64_utf8_key_default_null`,`col_char_64_utf8_not_null`,`col_char_64_utf8_not_null_key`,`col_datetime`,`col_datetime_default_null`,`col_datetime_key`,`col_datetime_key_default_null`,`col_datetime_not_null`,`col_datetime_not_null_key`,`col_enum_latin1`,`col_enum_latin1_default_null`,`col_enum_latin1_key`,`col_enum_latin1_key_default_null`,`col_enum_latin1_not_null`,`col_enum_latin1_not_null_key`,`col_enum_utf8`,`col_enum_utf8_default_null`,`col_enum_utf8_key`,`col_enum_utf8_key_default_null`,`col_enum_utf8_not_null`,`col_enum_utf8_not_null_key`,`col_int`,`col_int_default_null`,`col_int_key`,`col_int_key_default_null`,`col_int_not_null`,`col_int_not_null_key`,`col_int_unsigned`,`col_int_unsigned_default_null`,`col_int_unsigned_key`,`col_int_unsigned_key_default_null`,`col_int_unsigned_not_null`,`col_int_unsigned_not_null_key`,`col_set_latin1`,`col_set_latin1_default_null`,`col_set_latin1_key`,`col_set_latin1_key_default_null`,`col_set_latin1_not_null`,`col_set_latin1_not_null_key`,`col_set_utf8`,`col_set_utf8_default_null`,`col_set_utf8_key`,`col_set_utf8_key_default_null`,`col_set_utf8_not_null`,`col_set_utf8_not_null_key`,`pk` LIMIT 7 /*Generated by THREAD_ID 20*/ ", packet_length=1547) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1c04530) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1c04530) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1a8ea20) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 3 (LWP 2134):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f87997c2780, mutex=0x1c22ca8, that=0x1c22cd8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1c22ca8, owner=0x1c22b70, abs_timeout=0x7f87997c2780, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1c22ca8, mdl_request=0x7f8710005a40, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1c22b70, ot_ctx=0x7f87997c31e0, mdl_request=0x7f8710005a40, flags=<optimized out>, mdl_ticket=0x7f87997c30e8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1c22b70, table_list=0x7f87100056a0, ot_ctx=0x7f87997c31e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f87997c31e0, has_prelocking_list=false, prelocking_strategy=0x7f87997c3300, flags=0, counter=0x1c24ff0, tables=0x7f87100056a0, lex=0x1c24f38, thd=0x1c22b70) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1c22b70, start=0x7f87997c32c8, counter=0x1c24ff0, flags=0, prelocking_strategy=0x7f87997c3300) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f87100050c0, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000071eb4d in execute_sqlcom_select (thd=0x1c22b70, all_tables=0x7f87100050c0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:5278
#10 0x00000000007217b7 in mysql_execute_command (thd=0x1c22b70) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:2762
#11 0x0000000000727818 in mysql_parse (thd=0x1c22b70, rawbuf=0x1c24f38 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1c22b70, packet=0x1c264f1 "  SELECT alias1 . `pk` AS field1 FROM  table2_int_autoinc AS alias1  LEFT OUTER JOIN table100_key_pk_parts_2_int_autoinc AS alias2 ON  alias1 . `pk` =  alias2 . `col_int_key`  WHERE  alias2 . `col_varchar_1024_utf8` > 'j' AND alias2 . `col_varchar_1024_utf8` < 'z' ORDER BY field1 DESC LIMIT 1000 OFFSET 5 ", packet_length=306) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1c22b70) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1c22b70) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1a6c950) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 2 (LWP 2137):
+bt
#0  0x000000340cc0b7bb in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x0000000000677db6 in inline_mysql_cond_timedwait (src_line=1306, src_file=0xccff10 "/bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc", abstime=0x7f8799781680, mutex=0x1c2a638, that=0x1c2a668) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/include/mysql/psi/mysql_thread.h:1199
#2  MDL_wait::timed_wait (this=0x1c2a638, owner=0x1c2a500, abs_timeout=0x7f8799781680, set_status_on_timeout=true, wait_state_name=0x0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:1306
#3  0x0000000000679d3c in MDL_context::acquire_lock (this=0x1c2a638, mdl_request=0x7f87140052e0, lock_wait_timeout=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/mdl.cc:2245
#4  0x00000000006bc7b3 in open_table_get_mdl_lock (thd=0x1c2a500, ot_ctx=0x7f87997820e0, mdl_request=0x7f87140052e0, flags=<optimized out>, mdl_ticket=0x7f8799781fe8) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2527
#5  0x00000000006c668a in open_table (thd=0x1c2a500, table_list=0x7f8714004f40, ot_ctx=0x7f87997820e0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:2819
#6  0x00000000006ca9ec in open_and_process_table (ot_ctx=0x7f87997820e0, has_prelocking_list=false, prelocking_strategy=0x7f8799782200, flags=0, counter=0x1c2c980, tables=0x7f8714004f40, lex=0x1c2c8c8, thd=0x1c2a500) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:4567
#7  open_tables (thd=0x1c2a500, start=0x7f87997821c8, counter=0x1c2c980, flags=0, prelocking_strategy=0x7f8799782200) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5069
#8  0x00000000006cb6f9 in open_normal_and_derived_tables (thd=<optimized out>, tables=0x7f8714004f40, flags=0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_base.cc:5768
#9  0x000000000079b1f2 in mysql_multi_update_prepare (thd=0x1c2a500) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:1330
#10 0x0000000000721319 in mysql_execute_command (thd=0x1c2a500) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3530
#11 0x0000000000727818 in mysql_parse (thd=0x1c2a500, rawbuf=0x1c2c8c8 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#12 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1c2a500, packet=0x1c2de81 "UPDATE LOW_PRIORITY `table10_key_pk_parts_2_int_autoinc` t1, `table1_int_autoinc` t2 SET t1.`col_set_latin1_not_null` = -15762598695796736 WHERE t1.`col_datetime_key_default_null` > '2004-02-23 07:44:12.041061'", packet_length=210) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#13 0x0000000000729a47 in do_command (thd=0x1c2a500) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#14 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#15 0x00000000006ed727 in handle_one_connection (arg=0x1c2a500) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#16 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1b56030) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#17 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#18 0x000000340c4e890d in clone () from /lib64/libc.so.6

Thread 1 (LWP 2124):
+bt
#0  0x000000340cc0c69c in pthread_kill () from /lib64/libpthread.so.0
#1  0x0000000000686bde in handle_fatal_signal (sig=6) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/signal_handler.cc:251
#2  <signal handler called>
#3  0x000000340c4328a5 in raise () from /lib64/libc.so.6
#4  0x000000340c434085 in abort () from /lib64/libc.so.6
#5  0x000000340c42ba1e in __assert_fail_base () from /lib64/libc.so.6
#6  0x000000340c42bae0 in __assert_fail () from /lib64/libc.so.6
#7  0x0000000000c5a472 in ha_partition::init_record_priority_queue (this=0x7f872c021b00) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:4843
#8  0x0000000000c5a561 in ha_partition::index_init (this=0x7f872c021b00, inx=0, sorted=true) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/ha_partition.cc:4949
#9  0x00000000005b4aee in handler::ha_index_init (this=0x7f872c021b00, idx=0, sorted=true) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/handler.cc:2573
#10 0x00000000008688c4 in QUICK_RANGE_SELECT::reset (this=0x7f872c01fd40) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/opt_range.cc:10369
#11 0x000000000079cb38 in mysql_update (thd=0x1bfcba0, table_list=0x7f872c004e18, fields=..., values=..., conds=0x0, order_num=268435455, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f8799909038, updated_return=0x7f8799909040) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_update.cc:695
#12 0x00000000007212cb in mysql_execute_command (thd=0x1bfcba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:3511
#13 0x0000000000727818 in mysql_parse (thd=0x1bfcba0, rawbuf=0x1bfef68 "\360R7\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:6477
#14 0x000000000072871f in dispatch_command (command=COM_QUERY, thd=0x1bfcba0, packet=0x1c00521 " UPDATE table0_key_pk_parts_2_int_autoinc SET `col_int_not_null`=`col_int_not_null`+(@val) WHERE pk=@updpk ", packet_length=107) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1374
#15 0x0000000000729a47 in do_command (thd=0x1bfcba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_parse.cc:1049
#16 0x00000000006ed63f in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1615
#17 0x00000000006ed727 in handle_one_connection (arg=0x1bfcba0) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/sql/sql_connect.cc:1526
#18 0x00000000009dd6c9 in pfs_spawn_thread (arg=0x1aa0270) at /bzr/5.6_dbg/Percona-Server-5.6.12-rc60.4/storage/perfschema/pfs.cc:1855
#19 0x000000340cc07851 in start_thread () from /lib64/libpthread.so.0
#20 0x000000340c4e890d in clone () from /lib64/libc.so.6
(gdb) +set logging off