+thread apply all bt Thread 44 (LWP 30849): +bt #0 0x0000003da180e0ad in read () from /lib64/libpthread.so.0 #1 0x0000000000a5e9e6 in vio_read (vio=0x3621dc0, buf=0x3621fb0 "%", size=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/vio/viosocket.c:56 #2 0x0000000000524070 in my_real_read (net=net@entry=0x361eaa0, complen=complen@entry=0x7f500584ed88) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:834 #3 0x0000000000524b91 in my_net_read (net=0x361eaa0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:1033 #4 0x00000000005a3e59 in do_command (thd=0x361e870) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:734 #5 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x361e870) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #6 0x000000000064e242 in handle_one_connection (arg=0x361e870) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #7 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #8 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 43 (LWP 30804): +bt #0 0x0000003da180e0ad in read () from /lib64/libpthread.so.0 #1 0x0000000000a5e9e6 in vio_read (vio=0x35cf0f0, buf=0x35cf2e0 "\016", size=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/vio/viosocket.c:56 #2 0x0000000000524070 in my_real_read (net=net@entry=0x35cbdd0, complen=complen@entry=0x7f5005b19d88) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:834 #3 0x0000000000524b91 in my_net_read (net=0x35cbdd0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:1033 #4 0x00000000005a3e59 in do_command (thd=0x35cbba0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:734 #5 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35cbba0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #6 0x000000000064e242 in handle_one_connection (arg=0x35cbba0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #7 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #8 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 42 (LWP 30825): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc710, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc710, reset_sig_count=1436) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=12) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e2d5 in mutex_spin_wait (mutex=mutex@entry=0x34bc608, file_name=file_name@entry=0xb85bf0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c", line=line@entry=762) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x000000000090fda5 in mutex_enter_func (line=762, file_name=0xb85bf0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c", mutex=0x34bc608) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (mutex=0x34bc608, file_name=0xb85bf0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c", line=762) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 0x000000000091a467 in dict_table_get (table_name=0x7f5005a11540 "tmp/#sql76d3_18_c", inc_mysql_count=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0dict.c:762 #8 0x00000000008241a1 in ha_innobase::create (this=, name=, form=, create_info=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:8248 #9 0x00000000006b9d5f in handler::ha_create (this=0x7f4f9808b590, name=0x7f5005a129d0 "/ssd/832905/current1_1/tmp/#sql76d3_18_c", form=form@entry=0x7f5005a11d40, info=info@entry=0x7f5005a14e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3690 #10 0x00000000006ba6d8 in ha_create_table (thd=0x35e9d60, path=, db=0x7f4f98005288 "test", table_name=0x7f4f98004d28 "l", create_info=0x7f5005a14e50, update_create_info=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:4018 #11 0x00000000006335e4 in rea_create_table (thd=0x35e9d60, path=0x7f5005a129d0 "/ssd/832905/current1_1/tmp/#sql76d3_18_c", db=0x7f4f98005288 "test", table_name=0x7f4f98004d28 "l", create_info=0x7f5005a14e50, create_fields=..., keys=0, key_info=0x7f4f980b1d10, file=0x7f4f980b00c8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/unireg.cc:531 #12 0x00000000006054fc in mysql_create_table_no_lock (thd=0x35e9d60, db=0x7f4f98005288 "test", table_name=0x7f4f98004d28 "l", create_info=0x7f5005a14e50, alter_info=0x7f5005a14920, internal_tmp_table=false, select_field_count=91, is_trans=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:4325 #13 0x0000000000584370 in create_table_from_items (thd=0x35e9d60, create_info=0x7f5005a14e50, create_table=0x7f4f98004d60, alter_info=0x7f5005a14920, items=items@entry=0x35ec140, lock=lock@entry=0x7f5005a14588, hooks=hooks@entry=0x7f5005a145b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3778 #14 0x0000000000586cff in select_create::prepare (this=0x7f4f980d2908, values=..., u=0x35eba10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3930 #15 0x00000000005d4857 in JOIN::prepare (this=this@entry=0x7f4f980d29e0, rref_pointer_array=rref_pointer_array@entry=0x35ec208, tables_init=tables_init@entry=0x7f4f98005470, wild_num=wild_num@entry=1, conds_init=conds_init@entry=0x0, og_num=56541504, og_num@entry=0, order_init=order_init@entry=0x0, group_init=group_init@entry=0x0, having_init=having_init@entry=0x0, proc_param_init=proc_param_init@entry=0x0, select_lex_arg=select_lex_arg@entry=0x35ec030, unit_arg=unit_arg@entry=0x35eba10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:750 #16 0x00000000005dc9ce in mysql_select (thd=thd@entry=0x35e9d60, rref_pointer_array=rref_pointer_array@entry=0x35ec208, tables=0x7f4f98005470, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=select_options@entry=2424572672, result=result@entry=0x7f4f980d2908, unit=unit@entry=0x35eba10, select_lex=select_lex@entry=0x35ec030) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2591 #17 0x00000000005e2946 in handle_select (thd=0x35e9d60, lex=0x35eb950, result=0x7f4f980d2908, setup_tables_done_option=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:313 #18 0x000000000059b903 in mysql_execute_command (thd=thd@entry=0x35e9d60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2712 #19 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35e9d60, rawbuf=, length=76, parser_state=parser_state@entry=0x7f5005a15760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #20 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35e9d60, packet=packet@entry=0x35ed4a1 " CREATE TEMPORARY TABLE l SELECT * FROM `view_table500_innodb_compressed_int`", packet_length=packet_length@entry=77) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #21 0x00000000005a3fc3 in do_command (thd=0x35e9d60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #22 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35e9d60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #23 0x000000000064e242 in handle_one_connection (arg=0x35e9d60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #24 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #25 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 41 (LWP 30437): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087d601 in rw_lock_s_lock_spin (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb9f498 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c", line=line@entry=680) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:453 #5 0x00000000008444dd in rw_lock_s_lock_func (line=680, file_name=0xb9f498 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:419 #6 pfs_rw_lock_s_lock_func (line=680, file_name=0xb9f498 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:779 #7 row_mysql_freeze_data_dictionary_func (trx=trx@entry=0x34df568, file=file@entry=0xb9f498 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c", line=line@entry=680) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1814 #8 0x00000000009d52a7 in row_purge_parse_undo_rec (thr=0x34e0030, updated_extern=0x7f5002ca9c28, node=0x34e01e8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:680 #9 row_purge (thr=0x34e0030, node=0x34e01e8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:758 #10 row_purge_step (thr=thr@entry=0x34e0030) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:805 #11 0x00000000009bdbcf in que_thr_step (thr=0x34e0030) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1259 #12 que_run_threads_low (thr=0x34e0030) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1319 #13 que_run_threads (thr=thr@entry=0x34e0030) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1356 #14 0x00000000008871d2 in trx_purge (limit=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0purge.c:1195 #15 0x000000000087845d in srv_purge_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:4037 #16 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #17 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 40 (LWP 30791): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006567cf in inline_mysql_cond_timedwait (src_line=1191, src_file=0xace6e8 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc", abstime=0x7f5014106450, mutex=0x35a7f38, that=0x35a7f68) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=this@entry=0x35a7f38, thd=0x35a7e30, abs_timeout=abs_timeout@entry=0x7f5014106450, set_status_on_timeout=set_status_on_timeout@entry=false, wait_state_name=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:1191 #3 0x00000000006580a5 in MDL_context::acquire_lock (this=this@entry=0x35a7f38, mdl_request=0x7f4fc4005060, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2100 #4 0x0000000000658305 in MDL_context::acquire_locks (this=0x35a7f38, mdl_requests=, lock_wait_timeout=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2210 #5 0x000000000055955c in lock_table_names (thd=0x35a7e30, tables_start=, tables_end=, lock_wait_timeout=31536000, flags=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4725 #6 0x0000000000601156 in mysql_rm_table (thd=0x35a7e30, tables=0x7f4fc4004cf0, if_exists=1 '\001', drop_temporary=0 '\000') at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:1901 #7 0x000000000059da4c in mysql_execute_command (thd=thd@entry=0x35a7e30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3283 #8 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35a7e30, rawbuf=, length=22, parser_state=parser_state@entry=0x7f5014107760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #9 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35a7e30, packet=packet@entry=0x35aaf61 "DROP TABLE IF EXISTS u ", packet_length=packet_length@entry=23) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #10 0x00000000005a3fc3 in do_command (thd=0x35a7e30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #11 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35a7e30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #12 0x000000000064e242 in handle_one_connection (arg=0x35a7e30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #13 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #14 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 39 (LWP 30816): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=2) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087dcfd in rw_lock_x_lock_func (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=line@entry=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:700 #5 0x00000000008446fb in pfs_rw_lock_x_lock_func (line=8156, file_name=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7f4fa402e758, file=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1851 #7 0x0000000000823aeb in ha_innobase::create (this=, name=, form=0x7f5005a53300, create_info=0x7f5005a54f50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:8156 #8 0x00000000006b9d5f in handler::ha_create (this=0x7f4fa40b91a0, name=0x7f5005a53f90 "./test/u", form=form@entry=0x7f5005a53300, info=info@entry=0x7f5005a54f50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3690 #9 0x00000000006ba6d8 in ha_create_table (thd=0x35e24f0, path=, db=0x7f4fa4005260 "test", table_name=0x7f4fa4004d00 "u", create_info=0x7f5005a54f50, update_create_info=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:4018 #10 0x00000000006335e4 in rea_create_table (thd=0x35e24f0, path=0x7f5005a53f90 "./test/u", db=0x7f4fa4005260 "test", table_name=0x7f4fa4004d00 "u", create_info=0x7f5005a54f50, create_fields=..., keys=61, key_info=0x7f4fa40fee10, file=0x7f4fa40d4020) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/unireg.cc:531 #11 0x00000000006054fc in mysql_create_table_no_lock (thd=thd@entry=0x35e24f0, db=0x7f4fa4005260 "test", table_name=0x7f4fa4004d00 "u", create_info=create_info@entry=0x7f5005a54f50, alter_info=alter_info@entry=0x7f5005a54e90, internal_tmp_table=internal_tmp_table@entry=false, select_field_count=select_field_count@entry=0, is_trans=is_trans@entry=0x7f5005a54e1b) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:4325 #12 0x0000000000607c5f in mysql_create_like_table (thd=0x35e24f0, table=0x7f4fa4004d38, src_table=0x7f4fa4005350, create_info=0x7f5005a55e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:4645 #13 0x000000000059b959 in mysql_execute_command (thd=thd@entry=0x35e24f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2729 #14 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35e24f0, rawbuf=, length=58, parser_state=parser_state@entry=0x7f5005a56760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #15 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35e24f0, packet=packet@entry=0x35e5c31 " CREATE TABLE u LIKE `table100_innodb_default_int_autoinc` ", packet_length=packet_length@entry=60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #16 0x00000000005a3fc3 in do_command (thd=0x35e24f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #17 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35e24f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #18 0x000000000064e242 in handle_one_connection (arg=0x35e24f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #19 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #20 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 38 (LWP 30440): +bt #0 0x0000003da180e0ad in read () from /lib64/libpthread.so.0 #1 0x0000000000a5e9e6 in vio_read (vio=0x3570d10, buf=0x3576e60 "\a", size=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/vio/viosocket.c:56 #2 0x0000000000524070 in my_real_read (net=net@entry=0x34eb4c0, complen=complen@entry=0x7f501424cd88) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:834 #3 0x0000000000524b91 in my_net_read (net=0x34eb4c0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:1033 #4 0x00000000005a3e59 in do_command (thd=0x34eb290) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:734 #5 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x34eb290) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #6 0x000000000064e242 in handle_one_connection (arg=0x34eb290) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #7 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #8 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 37 (LWP 30425): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=2, array=0x318a280) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=global_seg@entry=4, message1=message1@entry=0x7f501528fe68, message2=message2@entry=0x7f501528fe60, type=type@entry=0x7f501528fe58, space_id=space_id@entry=0x7f501528fe50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000938f57 in fil_aio_wait (segment=segment@entry=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 36 (LWP 30858): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=7) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087dcfd in rw_lock_x_lock_func (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=line@entry=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:700 #5 0x00000000008446fb in pfs_rw_lock_x_lock_func (line=8156, file_name=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7f4f780a1d88, file=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1851 #7 0x0000000000823aeb in ha_innobase::create (this=, name=, form=0x7f5005809d40, create_info=0x7f500580ce50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:8156 #8 0x00000000006b9d5f in handler::ha_create (this=0x7f4f780ddaf0, name=0x7f500580a9d0 "./test/s", form=form@entry=0x7f5005809d40, info=info@entry=0x7f500580ce50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3690 #9 0x00000000006ba6d8 in ha_create_table (thd=0x36260e0, path=, db=0x7f4f78005260 "test", table_name=0x7f4f78004d00 "s", create_info=0x7f500580ce50, update_create_info=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:4018 #10 0x00000000006335e4 in rea_create_table (thd=0x36260e0, path=0x7f500580a9d0 "./test/s", db=0x7f4f78005260 "test", table_name=0x7f4f78004d00 "s", create_info=0x7f500580ce50, create_fields=..., keys=0, key_info=0x7f4f78142668, file=0x7f4f78140a20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/unireg.cc:531 #11 0x00000000006054fc in mysql_create_table_no_lock (thd=0x36260e0, db=0x7f4f78005260 "test", table_name=0x7f4f78004d00 "s", create_info=0x7f500580ce50, alter_info=0x7f500580c920, internal_tmp_table=false, select_field_count=91, is_trans=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:4325 #12 0x0000000000584370 in create_table_from_items (thd=0x36260e0, create_info=0x7f500580ce50, create_table=0x7f4f78004d38, alter_info=0x7f500580c920, items=items@entry=0x36284c0, lock=lock@entry=0x7f500580c588, hooks=hooks@entry=0x7f500580c5b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3778 #13 0x0000000000586cff in select_create::prepare (this=0x7f4f78005b18, values=..., u=0x3627d90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3930 #14 0x00000000005d4857 in JOIN::prepare (this=this@entry=0x7f4f780fc880, rref_pointer_array=rref_pointer_array@entry=0x3628588, tables_init=tables_init@entry=0x7f4f78005420, wild_num=wild_num@entry=1, conds_init=conds_init@entry=0x0, og_num=56788160, og_num@entry=0, order_init=order_init@entry=0x0, group_init=group_init@entry=0x0, having_init=having_init@entry=0x0, proc_param_init=proc_param_init@entry=0x0, select_lex_arg=select_lex_arg@entry=0x36283b0, unit_arg=unit_arg@entry=0x3627d90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:750 #15 0x00000000005dc9ce in mysql_select (thd=thd@entry=0x36260e0, rref_pointer_array=rref_pointer_array@entry=0x3628588, tables=0x7f4f78005420, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=select_options@entry=2416184064, result=result@entry=0x7f4f78005b18, unit=unit@entry=0x3627d90, select_lex=select_lex@entry=0x36283b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2591 #16 0x00000000005e2946 in handle_select (thd=0x36260e0, lex=0x3627cd0, result=0x7f4f78005b18, setup_tables_done_option=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:313 #17 0x000000000059b903 in mysql_execute_command (thd=thd@entry=0x36260e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2712 #18 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x36260e0, rawbuf=, length=59, parser_state=parser_state@entry=0x7f500580d760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #19 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x36260e0, packet=packet@entry=0x3629821 " CREATE TABLE s SELECT * FROM `table500_innodb_default_int`", packet_length=packet_length@entry=60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #20 0x00000000005a3fc3 in do_command (thd=0x36260e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #21 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x36260e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #22 0x000000000064e242 in handle_one_connection (arg=0x36260e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #23 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #24 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 35 (LWP 30847): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x2ee0e20, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x2ee0e20, reset_sig_count=817, reset_sig_count@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x0000000000871ffe in srv_suspend_mysql_thread (thr=thr@entry=0x7f4fac022408) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:1857 #4 0x0000000000841b10 in row_mysql_handle_errors (new_err=new_err@entry=0x7f500588e348, trx=trx@entry=0x7f4f80013998, thr=thr@entry=0x7f4fac022408, savept=savept@entry=0x7f500588e350) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:598 #5 0x0000000000842e2c in row_insert_for_mysql (mysql_rec=0x7f4fac0489d0 "\377\377\377\377\377\377\377\377", prebuilt=0x7f4fac0202a8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1264 #6 0x000000000081f9fc in ha_innobase::write_row (this=0x7f4fac046d70, record=0x7f4fac0489d0 "\377\377\377\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #7 0x00000000006bbd28 in handler::ha_write_row (this=0x7f4fac046d70, buf=0x7f4fac0489d0 "\377\377\377\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #8 0x0000000000586556 in write_record (thd=thd@entry=0x3617000, table=table@entry=0x7f4fac015820, info=info@entry=0x7f500588e5e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1541 #9 0x0000000000589388 in mysql_insert (thd=0x3617000, table_list=0x7f4f80004da8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:956 #10 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x3617000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #11 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x3617000, rawbuf=, length=61, parser_state=parser_state@entry=0x7f500588f760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #12 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3617000, packet=packet@entry=0x361a741 "REPLACE INTO `table500_innodb_default` ( `c78` ) VALUES ( 1 )", packet_length=packet_length@entry=61) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #13 0x00000000005a3fc3 in do_command (thd=0x3617000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #14 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x3617000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #15 0x000000000064e242 in handle_one_connection (arg=0x3617000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #16 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #17 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 34 (LWP 30436): +bt #0 0x0000003da14ea9f3 in select () from /lib64/libc.so.6 #1 0x000000000099a1fc in os_thread_sleep (tm=tm@entry=991000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0thread.c:259 #2 0x00000000008758dd in srv_master_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:3366 #3 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #4 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 33 (LWP 30424): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=1, array=0x318a280) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=global_seg@entry=3, message1=message1@entry=0x7f5015a90e68, message2=message2@entry=0x7f5015a90e60, type=type@entry=0x7f5015a90e58, space_id=space_id@entry=0x7f5015a90e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000938f57 in fil_aio_wait (segment=segment@entry=3) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 32 (LWP 30829): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34b5d00, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34b5d00, reset_sig_count=459) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e2d5 in mutex_spin_wait (mutex=mutex@entry=0x31b5538, file_name=file_name@entry=0xb7fdb0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0buf.c", line=line@entry=364) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x00000000008de794 in mutex_enter_func (line=364, file_name=0xb7fdb0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0buf.c", mutex=0x31b5538) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=364, file_name=0xb7fdb0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0buf.c", mutex=0x31b5538) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 buf_pool_get_oldest_modification () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0buf.c:364 #8 0x0000000000977692 in log_close () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/log/log0log.c:537 #9 0x0000000000992af6 in mtr_log_reserve_and_write (mtr=0x7f50059d28f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/mtr/mtr0mtr.c:225 #10 mtr_commit (mtr=mtr@entry=0x7f50059d28f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/mtr/mtr0mtr.c:262 #11 0x00000000009ce6f2 in row_ins_index_entry_low (mode=mode@entry=2, index=index@entry=0x7f4ff42270b8, entry=entry@entry=0x7f4f9c01df30, n_ext=n_ext@entry=0, thr=thr@entry=0x7f4f9c018628) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2201 #12 0x00000000009d1f5b in row_ins_index_entry (index=0x7f4ff42270b8, entry=0x7f4f9c01df30, n_ext=n_ext@entry=0, foreign=foreign@entry=1, thr=thr@entry=0x7f4f9c018628) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2288 #13 0x00000000009d2cce in row_ins_index_entry_step (thr=0x7f4f9c018628, node=0x7f4f9c0179e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2373 #14 row_ins (thr=, node=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2505 #15 row_ins_step (thr=thr@entry=0x7f4f9c018628) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2622 #16 0x0000000000842df5 in row_insert_for_mysql (mysql_rec=0x7f4f9c00df80 "\337\377\377\377\377\377\377\377", prebuilt=0x7f4f9c0164c8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1255 #17 0x000000000081f9fc in ha_innobase::write_row (this=0x7f4f9c0089a0, record=0x7f4f9c00df80 "\337\377\377\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #18 0x00000000006bbd28 in handler::ha_write_row (this=0x7f4f9c0089a0, buf=0x7f4f9c00df80 "\337\377\377\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #19 0x0000000000586556 in write_record (thd=thd@entry=0x35f15d0, table=table@entry=0x7f4f9c010b90, info=info@entry=0x7f50059d35e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1541 #20 0x0000000000589388 in mysql_insert (thd=0x35f15d0, table_list=0x7f4f9c004dd0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:956 #21 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x35f15d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #22 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35f15d0, rawbuf=, length=67, parser_state=parser_state@entry=0x7f50059d4760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #23 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35f15d0, packet=packet@entry=0x35f4d11 "REPLACE INTO `view_table500_innodb_default` ( `c25` ) VALUES ( -1 )", packet_length=packet_length@entry=67) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #24 0x00000000005a3fc3 in do_command (thd=0x35f15d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #25 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35f15d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #26 0x000000000064e242 in handle_one_connection (arg=0x35f15d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #27 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #28 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 31 (LWP 30778): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006567cf in inline_mysql_cond_timedwait (src_line=1191, src_file=0xace6e8 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc", abstime=0x7f4febffcff0, mutex=0x3582c38, that=0x3582c68) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=this@entry=0x3582c38, thd=0x3582b30, abs_timeout=abs_timeout@entry=0x7f4febffcff0, set_status_on_timeout=set_status_on_timeout@entry=false, wait_state_name=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:1191 #3 0x00000000006580a5 in MDL_context::acquire_lock (this=this@entry=0x3582c38, mdl_request=0x7f4fe4005060, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2100 #4 0x0000000000658305 in MDL_context::acquire_locks (this=0x3582c38, mdl_requests=, lock_wait_timeout=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2210 #5 0x000000000055955c in lock_table_names (thd=0x3582b30, tables_start=, tables_end=, lock_wait_timeout=31536000, flags=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4725 #6 0x000000000061ebed in mysql_drop_view (thd=0x3582b30, views=0x7f4fe4004cf0, drop_mode=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_view.cc:1697 #7 0x00000000005a0643 in mysql_execute_command (thd=thd@entry=0x3582b30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4460 #8 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x3582b30, rawbuf=, length=21, parser_state=parser_state@entry=0x7f4febffe760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #9 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3582b30, packet=packet@entry=0x3586271 " DROP VIEW IF EXISTS p ", packet_length=packet_length@entry=23) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #10 0x00000000005a3fc3 in do_command (thd=0x3582b30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #11 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x3582b30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #12 0x000000000064e242 in handle_one_connection (arg=0x3582b30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #13 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #14 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 30 (LWP 30799): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x2ee0da0, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x2ee0da0, reset_sig_count=967, reset_sig_count@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x0000000000871ffe in srv_suspend_mysql_thread (thr=thr@entry=0x7f4ff462ef28) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:1857 #4 0x0000000000841b10 in row_mysql_handle_errors (new_err=new_err@entry=0x7f50140432d8, trx=trx@entry=0x7f4fb0007cb8, thr=thr@entry=0x7f4ff462ef28, savept=savept@entry=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:598 #5 0x000000000085c67d in row_search_for_mysql (buf=0x7f4ff438cdf0 "\377\377\377\377\377\377\375\377", mode=1, prebuilt=0x7f4ff462d838, match_mode=0, direction=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:4753 #6 0x0000000000821cc9 in ha_innobase::general_fetch (this=this@entry=0x7f4ff48a12c0, buf=buf@entry=0x7f4ff438cdf0 "\377\377\377\377\377\377\375\377", direction=direction@entry=1, match_mode=match_mode@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7086 #7 0x0000000000821e74 in ha_innobase::rnd_next (this=0x7f4ff48a12c0, buf=0x7f4ff438cdf0 "\377\377\377\377\377\377\375\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7289 #8 0x000000000077e613 in rr_sequential (info=0x7f4fb0115148) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/records.cc:461 #9 0x00000000005c6189 in sub_select (join=0x7f4fb0080eb0, join_tab=0x7f4fb01150c8, end_of_records=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11799 #10 0x00000000005c5f9c in evaluate_join_record (join=join@entry=0x7f4fb0080eb0, join_tab=join_tab@entry=0x7f4fb0114e70, error=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11942 #11 0x00000000005c617c in sub_select (join=join@entry=0x7f4fb0080eb0, join_tab=join_tab@entry=0x7f4fb0114e70, end_of_records=end_of_records@entry=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11795 #12 0x00000000005d01bc in do_select (join=join@entry=0x7f4fb0080eb0, fields=fields@entry=0x7f50140437f0, table=table@entry=0x0, procedure=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11560 #13 0x00000000005e22bc in JOIN::exec (this=0x7f4fb0080eb0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2403 #14 0x00000000005dca3d in mysql_select (thd=0x35bd500, rref_pointer_array=0x35bf9a8, tables=0x7f4fb0004ea8, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f4fb00060b0, unit=0x35bf1b0, select_lex=0x35bf7d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2612 #15 0x000000000061b261 in mysql_multi_update (thd=0x35bd500, table_list=0x7f4fb0004ea8, fields=0x35bf8e0, values=0x35bfcc8, conds=0x7f4fb0005f18, options=, handle_duplicates=DUP_ERROR, ignore=false, unit=0x35bf1b0, select_lex=0x35bf7d0, result=0x7f50140438f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_update.cc:1370 #16 0x000000000059d0cd in mysql_execute_command (thd=thd@entry=0x35bd500) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3032 #17 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35bd500, rawbuf=, length=163, parser_state=parser_state@entry=0x7f5014044760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #18 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35bd500, packet=packet@entry=0x35c0631 "UPDATE `table100_innodb_dynamic_int_autoinc` t1, `table100_innodb_default_int` t2 SET t1.`c10` = LOAD_FILE('/ssd/randgen/data/earth215kb.jpg') WHERE t1.`c87` = 5", packet_length=packet_length@entry=163) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #19 0x00000000005a3fc3 in do_command (thd=0x35bd500) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #20 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35bd500) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #21 0x000000000064e242 in handle_one_connection (arg=0x35bd500) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #22 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #23 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 29 (LWP 30806): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x31926c0, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x31926c0, reset_sig_count=2486, reset_sig_count@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x0000000000996d34 in os_aio_wait_until_no_pending_writes () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:3774 #4 0x00000000008e943e in buf_flush_sync_datafiles () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:699 #5 0x00000000008ea94e in buf_flush_buffered_writes () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:937 #6 0x00000000008ed264 in buf_flush_post_to_doublewrite_buf (bpage=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:999 #7 buf_flush_write_block_low (bpage=bpage@entry=0x7f5007c3ddb0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:1181 #8 0x00000000008ef2f7 in buf_flush_page (flush_type=BUF_FLUSH_LIST, bpage=0x7f5007c3ddb0, buf_pool=0x31b4f18) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:1391 #9 buf_flush_try_neighbors (n_to_flush=18446744073709551614, n_flushed=111, flush_type=BUF_FLUSH_LIST, offset=4, space=20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:1538 #10 buf_flush_page_and_try_neighbors (bpage=0x31b4e38, bpage@entry=0x7f5007c41c20, flush_type=flush_type@entry=BUF_FLUSH_LIST, n_to_flush=n_to_flush@entry=18446744073709551614, count=count@entry=0x7f5005ad66b8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:1625 #11 0x00000000008f0547 in buf_flush_flush_list_batch (lsn_limit=773583972, min_n=18446744073709551614, buf_pool=0x31b4f18) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:1765 #12 buf_flush_batch (buf_pool=buf_pool@entry=0x31b4f18, flush_type=flush_type@entry=BUF_FLUSH_LIST, min_n=min_n@entry=18446744073709551614, lsn_limit=lsn_limit@entry=773583972) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:1856 #13 0x00000000008f11a4 in buf_flush_list (min_n=, min_n@entry=18446744073709551614, lsn_limit=lsn_limit@entry=773583972) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:2073 #14 0x000000000097b2b2 in log_preflush_pool_modified_pages (new_oldest=new_oldest@entry=773583972, sync=sync@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/log/log0log.c:1770 #15 0x000000000097cded in log_checkpoint_margin () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/log/log0log.c:2274 #16 log_check_margins () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/log/log0log.c:3169 #17 0x00000000009cc834 in log_free_check () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/log0log.ic:443 #18 row_ins_index_entry_low (mode=mode@entry=2, index=index@entry=0x7f4ff4145d28, entry=entry@entry=0x7f4fa00a0ea8, n_ext=n_ext@entry=0, thr=thr@entry=0x7f4f9c08b2c0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2005 #19 0x00000000009d1f5b in row_ins_index_entry (index=0x7f4ff4145d28, entry=0x7f4fa00a0ea8, n_ext=n_ext@entry=0, foreign=foreign@entry=1, thr=thr@entry=0x7f4f9c08b2c0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2288 #20 0x00000000009d2cce in row_ins_index_entry_step (thr=0x7f4f9c08b2c0, node=0x7f4f9c08a660) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2373 #21 row_ins (thr=, node=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2505 #22 row_ins_step (thr=thr@entry=0x7f4f9c08b2c0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2622 #23 0x0000000000842df5 in row_insert_for_mysql (mysql_rec=0x7f4f9c0860f0 "\377\377\377\377\375\377\377\377", prebuilt=0x7f4f9c088eb8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1255 #24 0x000000000081f9fc in ha_innobase::write_row (this=0x7f4f9c07e660, record=0x7f4f9c0860f0 "\377\377\377\377\375\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #25 0x00000000006bbd28 in handler::ha_write_row (this=0x7f4f9c07e660, buf=0x7f4f9c0860f0 "\377\377\377\377\375\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #26 0x0000000000586556 in write_record (thd=thd@entry=0x35d3410, table=table@entry=0x7f4f9c085810, info=info@entry=0x7f5005ad75e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1541 #27 0x0000000000589388 in mysql_insert (thd=0x35d3410, table_list=0x7f4fac004e48, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:956 #28 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x35d3410) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #29 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35d3410, rawbuf=, length=89, parser_state=parser_state@entry=0x7f5005ad8760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #30 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35d3410, packet=packet@entry=0x35d6b51 "REPLACE INTO `view_table100_innodb_dynamic_int_autoinc` ( `c84` ) VALUES ( '2008-08-13' )", packet_length=packet_length@entry=89) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #31 0x00000000005a3fc3 in do_command (thd=0x35d3410) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #32 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35d3410) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #33 0x000000000064e242 in handle_one_connection (arg=0x35d3410) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #34 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #35 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 28 (LWP 30844): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=9) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087dcfd in rw_lock_x_lock_func (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=line@entry=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:700 #5 0x00000000008446fb in pfs_rw_lock_x_lock_func (line=8156, file_name=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7f4f8c11efb8, file=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1851 #7 0x0000000000823aeb in ha_innobase::create (this=, name=, form=0x7f50058ccd40, create_info=0x7f50058cfe50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:8156 #8 0x00000000006b9d5f in handler::ha_create (this=0x7f4f8c0db460, name=0x7f50058cd9d0 "./test/t", form=form@entry=0x7f50058ccd40, info=info@entry=0x7f50058cfe50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3690 #9 0x00000000006ba6d8 in ha_create_table (thd=0x360f790, path=, db=0x7f4f8c005268 "test", table_name=0x7f4f8c004d08 "t", create_info=0x7f50058cfe50, update_create_info=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:4018 #10 0x00000000006335e4 in rea_create_table (thd=0x360f790, path=0x7f50058cd9d0 "./test/t", db=0x7f4f8c005268 "test", table_name=0x7f4f8c004d08 "t", create_info=0x7f50058cfe50, create_fields=..., keys=0, key_info=0x7f4f8c13bc20, file=0x7f4f8c199a30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/unireg.cc:531 #11 0x00000000006054fc in mysql_create_table_no_lock (thd=0x360f790, db=0x7f4f8c005268 "test", table_name=0x7f4f8c004d08 "t", create_info=0x7f50058cfe50, alter_info=0x7f50058cf920, internal_tmp_table=false, select_field_count=90, is_trans=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:4325 #12 0x0000000000584370 in create_table_from_items (thd=0x360f790, create_info=0x7f50058cfe50, create_table=0x7f4f8c004d40, alter_info=0x7f50058cf920, items=items@entry=0x3611b70, lock=lock@entry=0x7f50058cf588, hooks=hooks@entry=0x7f50058cf5b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3778 #13 0x0000000000586cff in select_create::prepare (this=0x7f4f8c1c8310, values=..., u=0x3611440) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3930 #14 0x00000000005d4857 in JOIN::prepare (this=this@entry=0x7f4f8c1c83e8, rref_pointer_array=rref_pointer_array@entry=0x3611c38, tables_init=tables_init@entry=0x7f4f8c005428, wild_num=wild_num@entry=1, conds_init=conds_init@entry=0x0, og_num=56695664, og_num@entry=0, order_init=order_init@entry=0x0, group_init=group_init@entry=0x0, having_init=having_init@entry=0x0, proc_param_init=proc_param_init@entry=0x0, select_lex_arg=select_lex_arg@entry=0x3611a60, unit_arg=unit_arg@entry=0x3611440) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:750 #15 0x00000000005dc9ce in mysql_select (thd=thd@entry=0x360f790, rref_pointer_array=rref_pointer_array@entry=0x3611c38, tables=0x7f4f8c005428, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=select_options@entry=2416184064, result=result@entry=0x7f4f8c1c8310, unit=unit@entry=0x3611440, select_lex=select_lex@entry=0x3611a60) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2591 #16 0x00000000005e2946 in handle_select (thd=0x360f790, lex=0x3611380, result=0x7f4f8c1c8310, setup_tables_done_option=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:313 #17 0x000000000059b903 in mysql_execute_command (thd=thd@entry=0x360f790) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2712 #18 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x360f790, rawbuf=, length=60, parser_state=parser_state@entry=0x7f50058d0760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #19 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x360f790, packet=packet@entry=0x3612ed1 " CREATE TABLE t SELECT * FROM `view_table100_innodb_dynamic`", packet_length=packet_length@entry=61) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #20 0x00000000005a3fc3 in do_command (thd=0x360f790) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #21 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x360f790) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #22 0x000000000064e242 in handle_one_connection (arg=0x360f790) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #23 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #24 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 27 (LWP 30421): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=0, array=0x316ddd0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=global_seg@entry=0, message1=message1@entry=0x7f5017991e68, message2=message2@entry=0x7f5017991e60, type=type@entry=0x7f5017991e58, space_id=space_id@entry=0x7f5017991e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000938f57 in fil_aio_wait (segment=segment@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 26 (LWP 30432): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009999ed in os_cond_wait_timed (abstime=0x7f50054aedc0, mutex=0x3019520, cond=0x3019558) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x3019520, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:716 #3 0x0000000000873ded in srv_lock_timeout_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:2694 #4 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 25 (LWP 30430): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=3, array=0x3192500) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=global_seg@entry=9, message1=message1@entry=0x7f500635be68, message2=message2@entry=0x7f500635be60, type=type@entry=0x7f500635be58, space_id=space_id@entry=0x7f500635be50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000938f57 in fil_aio_wait (segment=segment@entry=9) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 24 (LWP 30794): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x2ee0d20, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x2ee0d20, reset_sig_count=1204, reset_sig_count@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x0000000000871ffe in srv_suspend_mysql_thread (thr=thr@entry=0x7f4fa4099dd0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:1857 #4 0x0000000000841b10 in row_mysql_handle_errors (new_err=new_err@entry=0x7f50140c5398, trx=trx@entry=0x7f4fb8007cb8, thr=thr@entry=0x7f4fa4099dd0, savept=savept@entry=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:598 #5 0x000000000085c67d in row_search_for_mysql (buf=0x7f4fa4042c30 "\377\377\377\377\377\377\377\377", mode=1, prebuilt=0x7f4fa40979c8, match_mode=0, direction=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:4753 #6 0x0000000000821cc9 in ha_innobase::general_fetch (this=this@entry=0x7f4fa404f7a0, buf=buf@entry=0x7f4fa4042c30 "\377\377\377\377\377\377\377\377", direction=direction@entry=1, match_mode=match_mode@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7086 #7 0x0000000000821e74 in ha_innobase::rnd_next (this=0x7f4fa404f7a0, buf=0x7f4fa4042c30 "\377\377\377\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7289 #8 0x000000000077e613 in rr_sequential (info=0x7f50140c5590) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/records.cc:461 #9 0x0000000000619f85 in mysql_update (thd=0x35aef70, table_list=0x7f4fb8004e40, fields=..., values=..., conds=0x7f4fb80056c0, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=true, found_return=0x7f50140c58f0, updated_return=0x7f50140c58f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_update.cc:653 #10 0x000000000059cf48 in mysql_execute_command (thd=thd@entry=0x35aef70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2966 #11 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35aef70, rawbuf=, length=100, parser_state=parser_state@entry=0x7f50140c6760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #12 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35aef70, packet=packet@entry=0x35b20a1 "UPDATE IGNORE `table500_innodb_default_int_autoinc` SET `c45` = 0 WHERE `c71` < 4623789442425946112 ", packet_length=packet_length@entry=102) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #13 0x00000000005a3fc3 in do_command (thd=0x35aef70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #14 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35aef70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #15 0x000000000064e242 in handle_one_connection (arg=0x35aef70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #16 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #17 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 23 (LWP 30427): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34b5d00, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34b5d00, reset_sig_count=459) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=3) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087e2d5 in mutex_spin_wait (mutex=mutex@entry=0x31b5538, file_name=file_name@entry=0xb82448 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c", line=line@entry=524) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x00000000008ebb8a in mutex_enter_func (line=524, file_name=0xb82448 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c", mutex=0x31b5538) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:222 #6 pfs_mutex_enter_func (line=524, file_name=0xb82448 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c", mutex=0x31b5538) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 buf_flush_remove (bpage=0x7f5007e55c70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:524 #8 0x00000000008ec4a8 in buf_flush_write_complete (bpage=bpage@entry=0x7f5007e55c70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0flu.c:659 #9 0x00000000008e3918 in buf_page_io_complete (bpage=0x7f5007e55c70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0buf.c:4186 #10 0x0000000000939116 in fil_aio_wait (segment=segment@entry=6) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5611 #11 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #12 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #13 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 22 (LWP 30419): +bt #0 0x0000003da14e8bdf in poll () from /lib64/libc.so.6 #1 0x0000000000520ee2 in handle_connections_sockets () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mysqld.cc:5383 #2 0x0000000000522d60 in mysqld_main (argc=55, argv=0x2d67288) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mysqld.cc:4822 #3 0x0000000000518aa5 in main (argc=, argv=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/main.cc:25 Thread 21 (LWP 30426): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=3, array=0x318a280) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=global_seg@entry=5, message1=message1@entry=0x7f5014a8ee68, message2=message2@entry=0x7f5014a8ee60, type=type@entry=0x7f5014a8ee58, space_id=space_id@entry=0x7f5014a8ee50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000938f57 in fil_aio_wait (segment=segment@entry=5) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 20 (LWP 30429): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=2, array=0x3192500) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=global_seg@entry=8, message1=message1@entry=0x7f5006b5ce68, message2=message2@entry=0x7f5006b5ce60, type=type@entry=0x7f5006b5ce58, space_id=space_id@entry=0x7f5006b5ce50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000938f57 in fil_aio_wait (segment=segment@entry=8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 19 (LWP 30438): +bt #0 0x0000003da180ed70 in sigwait () from /lib64/libpthread.so.0 #1 0x000000000051b7cc in signal_hand (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mysqld.cc:2748 #2 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #3 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 18 (LWP 30773): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=11) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087d601 in rw_lock_s_lock_spin (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", line=line@entry=296) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:453 #5 0x00000000008444dd in rw_lock_s_lock_func (line=296, file_name=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:419 #6 pfs_rw_lock_s_lock_func (line=296, file_name=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:779 #7 row_mysql_freeze_data_dictionary_func (trx=trx@entry=0x7f4ff43a1d78, file=file@entry=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", line=line@entry=296) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1814 #8 0x00000000009d72ee in row_undo (thr=0x7f4ff4747520, node=0x7f4ff4695ab8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c:296 #9 row_undo_step (thr=thr@entry=0x7f4ff4747520) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c:348 #10 0x00000000009bdbb9 in que_thr_step (thr=0x7f4ff4747520) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1257 #11 que_run_threads_low (thr=0x7f4ff4747520) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1319 #12 que_run_threads (thr=thr@entry=0x7f4ff48433d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1356 #13 0x00000000008958f7 in trx_general_rollback_for_mysql (trx=trx@entry=0x7f4ff43a1d78, savept=savept@entry=0x7f501420a350) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0roll.c:97 #14 0x0000000000841b02 in row_mysql_handle_errors (new_err=new_err@entry=0x7f501420a348, trx=trx@entry=0x7f4ff43a1d78, thr=thr@entry=0x7f4f88013520, savept=savept@entry=0x7f501420a350) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:593 #15 0x0000000000842e2c in row_insert_for_mysql (mysql_rec=0x7f4f8803c3f0 "\377\377\377\377\377\376\377\377", prebuilt=0x7f4f88011118) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1264 #16 0x000000000081f9fc in ha_innobase::write_row (this=0x7f4f8802b280, record=0x7f4f8803c3f0 "\377\377\377\377\377\376\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #17 0x00000000006bbd28 in handler::ha_write_row (this=0x7f4f8802b280, buf=0x7f4f8803c3f0 "\377\377\377\377\377\376\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #18 0x00000000005865ef in write_record (thd=thd@entry=0x357af90, table=table@entry=0x7f4f8801e5a0, info=info@entry=0x7f501420a5e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1788 #19 0x0000000000589388 in mysql_insert (thd=0x357af90, table_list=0x7f4ff459f560, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:956 #20 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x357af90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #21 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x357af90, rawbuf=, length=37, parser_state=parser_state@entry=0x7f501420b760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #22 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x357af90, packet=packet@entry=0x357ea01 " INSERT INTO l ( `c68` ) VALUES ( -1 )", packet_length=packet_length@entry=38) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #23 0x00000000005a3fc3 in do_command (thd=0x357af90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #24 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x357af90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #25 0x000000000064e242 in handle_one_connection (arg=0x357af90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #26 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #27 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 17 (LWP 30423): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=0, array=0x318a280) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=global_seg@entry=2, message1=message1@entry=0x7f5016291e68, message2=message2@entry=0x7f5016291e60, type=type@entry=0x7f5016291e58, space_id=space_id@entry=0x7f5016291e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000938f57 in fil_aio_wait (segment=segment@entry=2) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 16 (LWP 30841): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x2ee0ca0, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x2ee0ca0, reset_sig_count=1438, reset_sig_count@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x0000000000871ffe in srv_suspend_mysql_thread (thr=thr@entry=0x7f4fc81d54f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:1857 #4 0x0000000000841b10 in row_mysql_handle_errors (new_err=new_err@entry=0x7f5005910398, trx=trx@entry=0x7f4f88007cb8, thr=thr@entry=0x7f4fc81d54f8, savept=savept@entry=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:598 #5 0x000000000085c67d in row_search_for_mysql (buf=0x7f4fc8145040 "\377\377\357\377\377\377\377\377", mode=1, prebuilt=0x7f4fc81d3e08, match_mode=0, direction=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:4753 #6 0x0000000000821cc9 in ha_innobase::general_fetch (this=this@entry=0x7f4fc81bc220, buf=buf@entry=0x7f4fc8145040 "\377\377\357\377\377\377\377\377", direction=direction@entry=1, match_mode=match_mode@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7086 #7 0x0000000000821e74 in ha_innobase::rnd_next (this=0x7f4fc81bc220, buf=0x7f4fc8145040 "\377\377\357\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7289 #8 0x000000000077e613 in rr_sequential (info=0x7f5005910590) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/records.cc:461 #9 0x0000000000619f85 in mysql_update (thd=0x3607f20, table_list=0x7f4f88004e48, fields=..., values=..., conds=0x7f4f88005680, order_num=, order=0x0, limit=18446744073709551615, handle_duplicates=DUP_ERROR, ignore=false, found_return=0x7f50059108f0, updated_return=0x7f50059108f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_update.cc:653 #10 0x000000000059cf48 in mysql_execute_command (thd=thd@entry=0x3607f20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2966 #11 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x3607f20, rawbuf=, length=106, parser_state=parser_state@entry=0x7f5005911760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #12 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3607f20, packet=packet@entry=0x360b661 "UPDATE `table100_innodb_default_int_autoinc` SET `c31` = '20020610231824.026195' WHERE `c54` IS NOT NULL ", packet_length=packet_length@entry=108) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #13 0x00000000005a3fc3 in do_command (thd=0x3607f20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #14 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x3607f20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #15 0x000000000064e242 in handle_one_connection (arg=0x3607f20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #16 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #17 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 15 (LWP 30428): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=1, array=0x3192500) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=global_seg@entry=7, message1=message1@entry=0x7f500735de68, message2=message2@entry=0x7f500735de60, type=type@entry=0x7f500735de58, space_id=space_id@entry=0x7f500735de50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000938f57 in fil_aio_wait (segment=segment@entry=7) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 14 (LWP 30434): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009999ed in os_cond_wait_timed (abstime=0x7f50044ace10, mutex=0x30195a0, cond=0x30195d8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x30195a0, time_in_usec=time_in_usec@entry=5000000, reset_sig_count=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:716 #3 0x0000000000873ae4 in srv_monitor_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:2544 #4 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 13 (LWP 30422): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=0, array=0x317c000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4681 #2 os_aio_linux_handle (global_seg=global_seg@entry=1, message1=message1@entry=0x7f5016a92e68, message2=message2@entry=0x7f5016a92e60, type=type@entry=0x7f5016a92e58, space_id=space_id@entry=0x7f5016a92e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0file.c:4826 #3 0x0000000000938f57 in fil_aio_wait (segment=segment@entry=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:5559 #4 0x0000000000878a9a in io_handler_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0start.c:485 #5 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #6 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 12 (LWP 30832): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006567cf in inline_mysql_cond_timedwait (src_line=1191, src_file=0xace6e8 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc", abstime=0x7f5005992130, mutex=0x35f8f48, that=0x35f8f78) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=this@entry=0x35f8f48, thd=0x35f8e40, abs_timeout=abs_timeout@entry=0x7f5005992130, set_status_on_timeout=set_status_on_timeout@entry=false, wait_state_name=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:1191 #3 0x00000000006580a5 in MDL_context::acquire_lock (this=this@entry=0x35f8f48, mdl_request=0x7f4f900050a8, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2100 #4 0x0000000000658305 in MDL_context::acquire_locks (this=0x35f8f48, mdl_requests=, lock_wait_timeout=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2210 #5 0x000000000055955c in lock_table_names (thd=thd@entry=0x35f8e40, tables_start=, tables_end=, lock_wait_timeout=31536000, flags=flags@entry=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4725 #6 0x00000000005614e5 in open_tables (thd=thd@entry=0x35f8e40, start=start@entry=0x7f5005992648, counter=counter@entry=0x7f500599265c, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f5005992770) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4910 #7 0x0000000000562416 in open_and_lock_tables (thd=0x35f8e40, tables=0x7f4f90004d38, derived=true, flags=0, prelocking_strategy=0x7f5005992770) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:5547 #8 0x000000000061cf7d in open_and_lock_tables (flags=0, derived=true, tables=, thd=0x35f8e40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.h:475 #9 mysql_create_view (thd=0x35f8e40, views=0x7f4f90004d38, mode=VIEW_CREATE_NEW) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_view.cc:438 #10 0x00000000005a05f2 in mysql_execute_command (thd=thd@entry=0x35f8e40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4452 #11 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35f8e40, rawbuf=, length=56, parser_state=parser_state@entry=0x7f5005993760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #12 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35f8e40, packet=packet@entry=0x35fc581 " CREATE VIEW u AS SELECT * FROM `table100_innodb_default` ", packet_length=packet_length@entry=58) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #13 0x00000000005a3fc3 in do_command (thd=0x35f8e40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #14 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35f8e40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #15 0x000000000064e242 in handle_one_connection (arg=0x35f8e40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #16 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #17 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 11 (LWP 30789): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006567cf in inline_mysql_cond_timedwait (src_line=1191, src_file=0xace6e8 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc", abstime=0x7f5014147450, mutex=0x35a0df8, that=0x35a0e28) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=this@entry=0x35a0df8, thd=0x35a0cf0, abs_timeout=abs_timeout@entry=0x7f5014147450, set_status_on_timeout=set_status_on_timeout@entry=false, wait_state_name=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:1191 #3 0x00000000006580a5 in MDL_context::acquire_lock (this=this@entry=0x35a0df8, mdl_request=0x7f4fc0005060, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2100 #4 0x0000000000658305 in MDL_context::acquire_locks (this=0x35a0df8, mdl_requests=, lock_wait_timeout=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2210 #5 0x000000000055955c in lock_table_names (thd=0x35a0cf0, tables_start=, tables_end=, lock_wait_timeout=31536000, flags=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4725 #6 0x0000000000601156 in mysql_rm_table (thd=0x35a0cf0, tables=0x7f4fc0004cf0, if_exists=1 '\001', drop_temporary=0 '\000') at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:1901 #7 0x000000000059da4c in mysql_execute_command (thd=thd@entry=0x35a0cf0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3283 #8 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35a0cf0, rawbuf=, length=22, parser_state=parser_state@entry=0x7f5014148760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #9 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35a0cf0, packet=packet@entry=0x35a3e21 "DROP TABLE IF EXISTS k ", packet_length=packet_length@entry=23) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #10 0x00000000005a3fc3 in do_command (thd=0x35a0cf0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #11 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35a0cf0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #12 0x000000000064e242 in handle_one_connection (arg=0x35a0cf0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #13 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #14 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 10 (LWP 30433): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009999ed in os_cond_wait_timed (abstime=0x7f5004cadda0, mutex=0x30194a0, cond=0x30194d8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x30194a0, time_in_usec=time_in_usec@entry=1000000, reset_sig_count=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:716 #3 0x00000000008749e8 in srv_error_monitor_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:2907 #4 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 9 (LWP 30797): +bt #0 handler::end_bulk_insert (this=0x7f4fc80f5490) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.h:2210 #1 0x0000000000589449 in ha_end_bulk_insert (this=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.h:1488 #2 mysql_insert (thd=0x35b60b0, table_list=0x7f4fbc004d18, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:987 #3 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x35b60b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #4 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35b60b0, rawbuf=, length=40, parser_state=parser_state@entry=0x7f5014085760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #5 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35b60b0, packet=packet@entry=0x35b93d1 " INSERT INTO d ( `c1` ) VALUES ( 'want' )", packet_length=packet_length@entry=41) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #6 0x00000000005a3fc3 in do_command (thd=0x35b60b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #7 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35b60b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #8 0x000000000064e242 in handle_one_connection (arg=0x35b60b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #9 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #10 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 8 (LWP 30839): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=5) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087dcfd in rw_lock_x_lock_func (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=line@entry=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:700 #5 0x00000000008446fb in pfs_rw_lock_x_lock_func (line=8156, file_name=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7f4f94121048, file=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1851 #7 0x0000000000823aeb in ha_innobase::create (this=, name=, form=0x7f500594ed40, create_info=0x7f5005951e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:8156 #8 0x00000000006b9d5f in handler::ha_create (this=0x7f4f9411bce0, name=0x7f500594f9d0 "/ssd/832905/current1_1/tmp/#sql76d3_1b_8", form=form@entry=0x7f500594ed40, info=info@entry=0x7f5005951e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3690 #9 0x00000000006ba6d8 in ha_create_table (thd=0x36006b0, path=, db=0x7f4f94005270 "test", table_name=0x7f4f94004d10 "n", create_info=0x7f5005951e50, update_create_info=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:4018 #10 0x00000000006335e4 in rea_create_table (thd=0x36006b0, path=0x7f500594f9d0 "/ssd/832905/current1_1/tmp/#sql76d3_1b_8", db=0x7f4f94005270 "test", table_name=0x7f4f94004d10 "n", create_info=0x7f5005951e50, create_fields=..., keys=0, key_info=0x7f4f940cb300, file=0x7f4f941646c0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/unireg.cc:531 #11 0x00000000006054fc in mysql_create_table_no_lock (thd=0x36006b0, db=0x7f4f94005270 "test", table_name=0x7f4f94004d10 "n", create_info=0x7f5005951e50, alter_info=0x7f5005951920, internal_tmp_table=false, select_field_count=90, is_trans=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:4325 #12 0x0000000000584370 in create_table_from_items (thd=0x36006b0, create_info=0x7f5005951e50, create_table=0x7f4f94004d48, alter_info=0x7f5005951920, items=items@entry=0x3602a90, lock=lock@entry=0x7f5005951588, hooks=hooks@entry=0x7f50059515b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3778 #13 0x0000000000586cff in select_create::prepare (this=0x7f4f94005960, values=..., u=0x3602360) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3930 #14 0x00000000005d4857 in JOIN::prepare (this=this@entry=0x7f4f941248b0, rref_pointer_array=rref_pointer_array@entry=0x3602b58, tables_init=tables_init@entry=0x7f4f94005410, wild_num=wild_num@entry=1, conds_init=conds_init@entry=0x0, og_num=56634000, og_num@entry=0, order_init=order_init@entry=0x0, group_init=group_init@entry=0x0, having_init=having_init@entry=0x0, proc_param_init=proc_param_init@entry=0x0, select_lex_arg=select_lex_arg@entry=0x3602980, unit_arg=unit_arg@entry=0x3602360) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:750 #15 0x00000000005dc9ce in mysql_select (thd=thd@entry=0x36006b0, rref_pointer_array=rref_pointer_array@entry=0x3602b58, tables=0x7f4f94005410, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=select_options@entry=2424572672, result=result@entry=0x7f4f94005960, unit=unit@entry=0x3602360, select_lex=select_lex@entry=0x3602980) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2591 #16 0x00000000005e2946 in handle_select (thd=0x36006b0, lex=0x36022a0, result=0x7f4f94005960, setup_tables_done_option=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:313 #17 0x000000000059b903 in mysql_execute_command (thd=thd@entry=0x36006b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2712 #18 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x36006b0, rawbuf=, length=64, parser_state=parser_state@entry=0x7f5005952760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #19 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x36006b0, packet=packet@entry=0x3603df1 " CREATE TEMPORARY TABLE n SELECT * FROM `table500_innodb_default`", packet_length=packet_length@entry=65) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #20 0x00000000005a3fc3 in do_command (thd=0x36006b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #21 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x36006b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #22 0x000000000064e242 in handle_one_connection (arg=0x36006b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #23 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #24 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 7 (LWP 30435): +bt #0 0x0000003da14ea9f3 in select () from /lib64/libc.so.6 #1 0x000000000099a1fc in os_thread_sleep (tm=tm@entry=5000000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0thread.c:259 #2 0x0000000000874a48 in srv_LRU_dump_restore_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:2953 #3 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #4 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 6 (LWP 30863): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=6) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087dcfd in rw_lock_x_lock_func (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=line@entry=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:700 #5 0x00000000008446fb in pfs_rw_lock_x_lock_func (line=8156, file_name=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:689 #6 row_mysql_lock_data_dictionary_func (trx=0x7f4f7c0944a8, file=0xb62970 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc", line=8156) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1851 #7 0x0000000000823aeb in ha_innobase::create (this=, name=, form=0x7f50057c8d40, create_info=0x7f50057cbe50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:8156 #8 0x00000000006b9d5f in handler::ha_create (this=0x7f4f7c0ad8c0, name=0x7f50057c99d0 "./test/p", form=form@entry=0x7f50057c8d40, info=info@entry=0x7f50057cbe50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3690 #9 0x00000000006ba6d8 in ha_create_table (thd=0x362d950, path=, db=0x7f4f7c005270 "test", table_name=0x7f4f7c004d10 "p", create_info=0x7f50057cbe50, update_create_info=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:4018 #10 0x00000000006335e4 in rea_create_table (thd=0x362d950, path=0x7f50057c99d0 "./test/p", db=0x7f4f7c005270 "test", table_name=0x7f4f7c004d10 "p", create_info=0x7f50057cbe50, create_fields=..., keys=0, key_info=0x7f4f7c0d4de0, file=0x7f4f7c0d3198) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/unireg.cc:531 #11 0x00000000006054fc in mysql_create_table_no_lock (thd=0x362d950, db=0x7f4f7c005270 "test", table_name=0x7f4f7c004d10 "p", create_info=0x7f50057cbe50, alter_info=0x7f50057cb920, internal_tmp_table=false, select_field_count=91, is_trans=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:4325 #12 0x0000000000584370 in create_table_from_items (thd=0x362d950, create_info=0x7f50057cbe50, create_table=0x7f4f7c004d48, alter_info=0x7f50057cb920, items=items@entry=0x362fd30, lock=lock@entry=0x7f50057cb588, hooks=hooks@entry=0x7f50057cb5b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3778 #13 0x0000000000586cff in select_create::prepare (this=0x7f4f7c005b50, values=..., u=0x362f600) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3930 #14 0x00000000005d4857 in JOIN::prepare (this=this@entry=0x7f4f7c0aff00, rref_pointer_array=rref_pointer_array@entry=0x362fdf8, tables_init=tables_init@entry=0x7f4f7c005458, wild_num=wild_num@entry=1, conds_init=conds_init@entry=0x0, og_num=56818992, og_num@entry=0, order_init=order_init@entry=0x0, group_init=group_init@entry=0x0, having_init=having_init@entry=0x0, proc_param_init=proc_param_init@entry=0x0, select_lex_arg=select_lex_arg@entry=0x362fc20, unit_arg=unit_arg@entry=0x362f600) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:750 #15 0x00000000005dc9ce in mysql_select (thd=thd@entry=0x362d950, rref_pointer_array=rref_pointer_array@entry=0x362fdf8, tables=0x7f4f7c005458, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=select_options@entry=2416184064, result=result@entry=0x7f4f7c005b50, unit=unit@entry=0x362f600, select_lex=select_lex@entry=0x362fc20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2591 #16 0x00000000005e2946 in handle_select (thd=0x362d950, lex=0x362f540, result=0x7f4f7c005b50, setup_tables_done_option=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:313 #17 0x000000000059b903 in mysql_execute_command (thd=thd@entry=0x362d950) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2712 #18 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x362d950, rawbuf=, length=67, parser_state=parser_state@entry=0x7f50057cc760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #19 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x362d950, packet=packet@entry=0x3631091 " CREATE TABLE p SELECT * FROM `table500_innodb_default_int_autoinc`", packet_length=packet_length@entry=68) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #20 0x00000000005a3fc3 in do_command (thd=0x362d950) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #21 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x362d950) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #22 0x000000000064e242 in handle_one_connection (arg=0x362d950) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #23 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #24 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 5 (LWP 30810): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006567cf in inline_mysql_cond_timedwait (src_line=1191, src_file=0xace6e8 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc", abstime=0x7f5005a96450, mutex=0x35dad88, that=0x35dadb8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/include/mysql/psi/mysql_thread.h:1009 #2 MDL_wait::timed_wait (this=this@entry=0x35dad88, thd=0x35dac80, abs_timeout=abs_timeout@entry=0x7f5005a96450, set_status_on_timeout=set_status_on_timeout@entry=false, wait_state_name=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:1191 #3 0x00000000006580a5 in MDL_context::acquire_lock (this=this@entry=0x35dad88, mdl_request=0x7f4fa0005060, lock_wait_timeout=lock_wait_timeout@entry=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2100 #4 0x0000000000658305 in MDL_context::acquire_locks (this=0x35dad88, mdl_requests=, lock_wait_timeout=31536000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/mdl.cc:2210 #5 0x000000000055955c in lock_table_names (thd=0x35dac80, tables_start=, tables_end=, lock_wait_timeout=31536000, flags=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4725 #6 0x0000000000601156 in mysql_rm_table (thd=0x35dac80, tables=0x7f4fa0004cf0, if_exists=1 '\001', drop_temporary=0 '\000') at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:1901 #7 0x000000000059da4c in mysql_execute_command (thd=thd@entry=0x35dac80) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3283 #8 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35dac80, rawbuf=, length=22, parser_state=parser_state@entry=0x7f5005a97760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #9 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35dac80, packet=packet@entry=0x35de3c1 "DROP TABLE IF EXISTS u ", packet_length=packet_length@entry=23) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #10 0x00000000005a3fc3 in do_command (thd=0x35dac80) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #11 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35dac80) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #12 0x000000000064e242 in handle_one_connection (arg=0x35dac80) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #13 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #14 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 4 (LWP 30801): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087d601 in rw_lock_s_lock_spin (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", line=line@entry=296) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:453 #5 0x00000000008444dd in rw_lock_s_lock_func (line=296, file_name=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:419 #6 pfs_rw_lock_s_lock_func (line=296, file_name=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:779 #7 row_mysql_freeze_data_dictionary_func (trx=trx@entry=0x7f4fb4007cb8, file=file@entry=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", line=line@entry=296) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1814 #8 0x00000000009d72ee in row_undo (thr=0x7f4fb40c8010, node=0x7f4fb41127e8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c:296 #9 row_undo_step (thr=thr@entry=0x7f4fb40c8010) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c:348 #10 0x00000000009bdbb9 in que_thr_step (thr=0x7f4fb40c8010) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1257 #11 que_run_threads_low (thr=0x7f4fb40c8010) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1319 #12 que_run_threads (thr=thr@entry=0x7f4fb40aa750) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1356 #13 0x00000000008958f7 in trx_general_rollback_for_mysql (trx=trx@entry=0x7f4fb4007cb8, savept=savept@entry=0x7f5005b59350) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0roll.c:97 #14 0x0000000000841b02 in row_mysql_handle_errors (new_err=new_err@entry=0x7f5005b59348, trx=trx@entry=0x7f4fb4007cb8, thr=thr@entry=0x7f4f94055178, savept=savept@entry=0x7f5005b59350) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:593 #15 0x0000000000842e2c in row_insert_for_mysql (mysql_rec=0x7f4f780639c0 "\377\377\377\377\377\377\375\377", prebuilt=0x7f4f7804f0f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1264 #16 0x000000000081f9fc in ha_innobase::write_row (this=0x7f4f78061d60, record=0x7f4f780639c0 "\377\377\377\377\377\377\375\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #17 0x00000000006bbd28 in handler::ha_write_row (this=0x7f4f78061d60, buf=0x7f4f780639c0 "\377\377\377\377\377\377\375\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #18 0x00000000005865ef in write_record (thd=thd@entry=0x35c4640, table=table@entry=0x7f4f78030a10, info=info@entry=0x7f5005b595e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1788 #19 0x0000000000589388 in mysql_insert (thd=0x35c4640, table_list=0x7f4fb4004d30, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:956 #20 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x35c4640) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #21 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x35c4640, rawbuf=, length=52, parser_state=parser_state@entry=0x7f5005b5a760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #22 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x35c4640, packet=packet@entry=0x35c7a71 " INSERT INTO k ( `c66` ) VALUES ( '03:30:08.010107' )", packet_length=packet_length@entry=53) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #23 0x00000000005a3fc3 in do_command (thd=0x35c4640) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #24 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x35c4640) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #25 0x000000000064e242 in handle_one_connection (arg=0x35c4640) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #26 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #27 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 3 (LWP 30785): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087d601 in rw_lock_s_lock_spin (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", line=line@entry=296) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:453 #5 0x00000000008444dd in rw_lock_s_lock_func (line=296, file_name=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:419 #6 pfs_rw_lock_s_lock_func (line=296, file_name=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:779 #7 row_mysql_freeze_data_dictionary_func (trx=trx@entry=0x7f4fc8023ca8, file=file@entry=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", line=line@entry=296) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1814 #8 0x00000000009d72ee in row_undo (thr=0x7f4fc80e4f70, node=0x7f4fc81eb2a8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c:296 #9 row_undo_step (thr=thr@entry=0x7f4fc80e4f70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c:348 #10 0x00000000009bdbb9 in que_thr_step (thr=0x7f4fc80e4f70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1257 #11 que_run_threads_low (thr=0x7f4fc80e4f70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1319 #12 que_run_threads (thr=thr@entry=0x7f4fc80b9af0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1356 #13 0x00000000008958f7 in trx_general_rollback_for_mysql (trx=trx@entry=0x7f4fc8023ca8, savept=savept@entry=0x7f4fd3ffd350) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0roll.c:97 #14 0x0000000000841b02 in row_mysql_handle_errors (new_err=new_err@entry=0x7f4fd3ffd348, trx=trx@entry=0x7f4fc8023ca8, thr=thr@entry=0x7f4fd810ad50, savept=savept@entry=0x7f4fd3ffd350) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:593 #15 0x0000000000842e2c in row_insert_for_mysql (mysql_rec=0x7f4fd8151070 "\377\377\377\377\377\377\377\377", prebuilt=0x7f4fd8108948) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1264 #16 0x000000000081f9fc in ha_innobase::write_row (this=0x7f4fd80c1800, record=0x7f4fd8151070 "\377\377\377\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #17 0x00000000006bbd28 in handler::ha_write_row (this=0x7f4fd80c1800, buf=0x7f4fd8151070 "\377\377\377\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #18 0x0000000000586556 in write_record (thd=thd@entry=0x3599480, table=table@entry=0x7f4fd812ff80, info=info@entry=0x7f4fd3ffd5e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1541 #19 0x0000000000589388 in mysql_insert (thd=0x3599480, table_list=0x7f4fc8004e98, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:956 #20 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x3599480) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #21 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x3599480, rawbuf=, length=125, parser_state=parser_state@entry=0x7f4fd3ffe760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #22 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3599480, packet=packet@entry=0x359cbc1 "REPLACE INTO `view_table100_innodb_compressed_int_autoinc` ( `c87` ) VALUES ( LOAD_FILE('/ssd/randgen/data/earth579kb.jpg') )", packet_length=packet_length@entry=125) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #23 0x00000000005a3fc3 in do_command (thd=0x3599480) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #24 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x3599480) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #25 0x000000000064e242 in handle_one_connection (arg=0x3599480) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #26 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #27 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 2 (LWP 30783): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x34bc910, cond=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=event@entry=0x34bc910, reset_sig_count=2088) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/os/os0sync.c:609 #3 0x000000000087c9ce in sync_array_wait_event (arr=0x2d67450, index=4) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0arr.c:458 #4 0x000000000087d601 in rw_lock_s_lock_spin (lock=0x11c8a60 , pass=pass@entry=0, file_name=file_name@entry=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", line=line@entry=296) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:453 #5 0x00000000008444dd in rw_lock_s_lock_func (line=296, file_name=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:419 #6 pfs_rw_lock_s_lock_func (line=296, file_name=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", pass=0, lock=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:779 #7 row_mysql_freeze_data_dictionary_func (trx=trx@entry=0x7f4fcc007f68, file=file@entry=0xb9f628 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c", line=line@entry=296) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1814 #8 0x00000000009d72ee in row_undo (thr=0x7f4fcc0a51e0, node=0x7f4fcc077648) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c:296 #9 row_undo_step (thr=thr@entry=0x7f4fcc0a51e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0undo.c:348 #10 0x00000000009bdbb9 in que_thr_step (thr=0x7f4fcc0a51e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1257 #11 que_run_threads_low (thr=0x7f4fcc0a51e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1319 #12 que_run_threads (thr=thr@entry=0x7f4fcc078240) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1356 #13 0x00000000008958f7 in trx_general_rollback_for_mysql (trx=trx@entry=0x7f4fcc007f68, savept=savept@entry=0x7f5014188350) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0roll.c:97 #14 0x0000000000841b02 in row_mysql_handle_errors (new_err=new_err@entry=0x7f5014188348, trx=trx@entry=0x7f4fcc007f68, thr=thr@entry=0x7f4ff48c5390, savept=savept@entry=0x7f5014188350) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:593 #15 0x0000000000842e2c in row_insert_for_mysql (mysql_rec=0x7f4ff489ed10 "\377\377\377\377\377\377\377\377", prebuilt=0x7f4ff48c31e8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1264 #16 0x000000000081f9fc in ha_innobase::write_row (this=0x7f4ff48bb620, record=0x7f4ff489ed10 "\377\377\377\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #17 0x00000000006bbd28 in handler::ha_write_row (this=0x7f4ff48bb620, buf=0x7f4ff489ed10 "\377\377\377\377\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #18 0x0000000000586556 in write_record (thd=thd@entry=0x3591c10, table=table@entry=0x7f4ff48bad40, info=info@entry=0x7f50141885e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1541 #19 0x0000000000589388 in mysql_insert (thd=0x3591c10, table_list=0x7f4fcc004e38, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_REPLACE, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:956 #20 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x3591c10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #21 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x3591c10, rawbuf=, length=83, parser_state=parser_state@entry=0x7f5014189760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #22 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x3591c10, packet=packet@entry=0x3595351 "REPLACE INTO `view_table100_innodb_default_int_autoinc` ( `c89` ) VALUES ( '2000' )", packet_length=packet_length@entry=83) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #23 0x00000000005a3fc3 in do_command (thd=0x3591c10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #24 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x3591c10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #25 0x000000000064e242 in handle_one_connection (arg=0x3591c10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #26 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #27 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 1 (LWP 30781): +bt #0 0x0000003da180c60c in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000007dea38 in my_write_core (sig=6) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/mysys/stacktrace.c:433 #2 0x00000000006b3104 in handle_fatal_signal (sig=6) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/signal_handler.cc:249 #3 #4 0x0000003da1435935 in raise () from /lib64/libc.so.6 #5 0x0000003da14370e8 in abort () from /lib64/libc.so.6 #6 0x00000000008fe034 in buf_flush_try_yield (processed=, bpage=0x7f5007cb2340, buf_pool=0x31b4f18) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0lru.c:459 #7 buf_flush_or_remove_pages (id=1076, buf_pool=0x31b4f18) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0lru.c:575 #8 buf_flush_dirty_pages (id=, buf_pool=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0lru.c:606 #9 buf_LRU_flush_or_remove_pages (id=id@entry=1076, buf_remove=buf_remove@entry=BUF_REMOVE_FLUSH_NO_WRITE) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/buf/buf0lru.c:804 #10 0x0000000000934980 in fil_delete_tablespace (id=id@entry=1076, evict_all=0, evict_all@entry=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fil/fil0fil.c:2398 #11 0x0000000000846d2f in row_drop_table_for_mysql (name=0x7f4fd817ef98 "test/a", trx=0x7f4fd80de048, drop_db=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:3577 #12 0x000000000081ce25 in ha_innobase::delete_table (this=, name=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:8451 #13 0x00000000006b9a12 in handler::ha_delete_table (this=this@entry=0x7f4fd8126710, name=name@entry=0x7f50141c9590 "./test/a") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3660 #14 0x00000000006b9b0b in ha_delete_table (thd=0x358a3a0, table_type=, path=0x7f50141c9590 "./test/a", db=0x7f4fd8005218 "test", alias=0x7f4fd8004cb8 "a", generate_warning=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:2211 #15 0x000000000060084e in mysql_rm_table_no_locks (thd=thd@entry=0x358a3a0, tables=tables@entry=0x7f4fd8004cf0, if_exists=if_exists@entry=true, drop_temporary=drop_temporary@entry=false, drop_view=drop_view@entry=false, dont_log_query=dont_log_query@entry=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:2246 #16 0x0000000000601271 in mysql_rm_table (thd=0x358a3a0, tables=0x7f4fd8004cf0, if_exists=1 '\001', drop_temporary=0 '\000') at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:1950 #17 0x000000000059da4c in mysql_execute_command (thd=thd@entry=0x358a3a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3283 #18 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x358a3a0, rawbuf=, length=22, parser_state=parser_state@entry=0x7f50141ca760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #19 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x358a3a0, packet=packet@entry=0x358dae1 "DROP TABLE IF EXISTS a ", packet_length=packet_length@entry=23) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #20 0x00000000005a3fc3 in do_command (thd=0x358a3a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #21 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x358a3a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #22 0x000000000064e242 in handle_one_connection (arg=0x358a3a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #23 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #24 0x0000003da14f168d in clone () from /lib64/libc.so.6 +quit