+thread apply all bt Thread 45 (LWP 12448): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x2151b20, 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=0x2151b20, reset_sig_count=363) 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=0x19fc430, index=3) 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=0x7f6978007cb8, 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=0x7f697802f550, node=0x7f697804a098) 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=0x7f697802f550) 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=0x7f697802f550) 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=0x7f697802f550) 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=0x7f6978031990) 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=0x7f6978007cb8, savept=savept@entry=0x7f69d0193350) 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=0x7f69d0193348, trx=trx@entry=0x7f6978007cb8, thr=thr@entry=0x7f6970064d28, savept=savept@entry=0x7f69d0193350) 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=0x7f6970016c20 "\377\377\377\377 ", prebuilt=0x7f6970063488) 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=0x7f6970053d00, record=0x7f6970016c20 "\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=0x7f6970053d00, buf=0x7f6970016c20 "\377\377\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=0x2260b90, table=table@entry=0x7f6970016340, info=info@entry=0x7f69d01935e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1788 #19 0x0000000000589388 in mysql_insert (thd=0x2260b90, table_list=0x7f6978004e50, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) 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=0x2260b90) 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=0x2260b90, rawbuf=, length=126, parser_state=parser_state@entry=0x7f69d0194760) 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=0x2260b90, packet=packet@entry=0x2263fc1 "INSERT IGNORE INTO `table500_innodb_compressed_int` ( `c32` , `c11` , `c21` ) VALUES ( 2556355738486177792 , '2006' , '2000' )", packet_length=packet_length@entry=126) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #23 0x00000000005a3fc3 in do_command (thd=0x2260b90) 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=0x2260b90) 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=0x2260b90) 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 44 (LWP 12446): +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=0x7f69d01d4450, mutex=0x2259b58, that=0x2259b88) 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=0x2259b58, thd=0x2259a50, abs_timeout=abs_timeout@entry=0x7f69d01d4450, 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=0x2259b58, mdl_request=0x7f6980005060, 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=0x2259b58, 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=0x2259a50, 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=0x2259a50, tables=0x7f6980004cf0, 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=0x2259a50) 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=0x2259a50, rawbuf=, length=22, parser_state=parser_state@entry=0x7f69d01d5760) 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=0x2259a50, packet=packet@entry=0x225cb81 "DROP TABLE IF EXISTS g ", 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=0x2259a50) 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=0x2259a50) 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=0x2259a50) 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 43 (LWP 12468): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1a3d380, 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=0x1a3d380, reset_sig_count=404) 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=0x19fc430, 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=0x1a3d2d8, file_name=file_name@entry=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", line=line@entry=229) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x000000000089ec6f in mutex_enter_func (line=229, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) 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=229, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 trx_allocate_for_mysql () at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c:229 #8 0x00000000008197d9 in innobase_trx_allocate (thd=thd@entry=0x22aa860) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:1832 #9 0x0000000000823a96 in ha_innobase::create (this=, name=, form=0x7f69c0a50d40, create_info=0x7f69c0a53e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:8144 #10 0x00000000006b9d5f in handler::ha_create (this=0x7f6950195fe0, name=0x7f69c0a519d0 "./test/k", form=form@entry=0x7f69c0a50d40, info=info@entry=0x7f69c0a53e50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3690 #11 0x00000000006ba6d8 in ha_create_table (thd=0x22aa860, path=, db=0x7f6950005260 "test", table_name=0x7f6950004d00 "k", create_info=0x7f69c0a53e50, update_create_info=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:4018 #12 0x00000000006335e4 in rea_create_table (thd=0x22aa860, path=0x7f69c0a519d0 "./test/k", db=0x7f6950005260 "test", table_name=0x7f6950004d00 "k", create_info=0x7f69c0a53e50, create_fields=..., keys=0, key_info=0x7f69501c4f10, file=0x7f69501c5f50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/unireg.cc:531 #13 0x00000000006054fc in mysql_create_table_no_lock (thd=0x22aa860, db=0x7f6950005260 "test", table_name=0x7f6950004d00 "k", create_info=0x7f69c0a53e50, alter_info=0x7f69c0a53920, internal_tmp_table=false, select_field_count=60, is_trans=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_table.cc:4325 #14 0x0000000000584370 in create_table_from_items (thd=0x22aa860, create_info=0x7f69c0a53e50, create_table=0x7f6950004d38, alter_info=0x7f69c0a53920, items=items@entry=0x22acc40, lock=lock@entry=0x7f69c0a53588, hooks=hooks@entry=0x7f69c0a535b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3778 #15 0x0000000000586cff in select_create::prepare (this=0x7f6950005b10, values=..., u=0x22ac510) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3930 #16 0x00000000005d4857 in JOIN::prepare (this=this@entry=0x7f6950067270, rref_pointer_array=rref_pointer_array@entry=0x22acd08, tables_init=tables_init@entry=0x7f6950005418, wild_num=wild_num@entry=1, conds_init=conds_init@entry=0x0, og_num=36359232, 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=0x22acb30, unit_arg=unit_arg@entry=0x22ac510) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:750 #17 0x00000000005dc9ce in mysql_select (thd=thd@entry=0x22aa860, rref_pointer_array=rref_pointer_array@entry=0x22acd08, tables=0x7f6950005418, 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=0x7f6950005b10, unit=unit@entry=0x22ac510, select_lex=select_lex@entry=0x22acb30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2591 #18 0x00000000005e2946 in handle_select (thd=0x22aa860, lex=0x22ac450, result=0x7f6950005b10, setup_tables_done_option=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:313 #19 0x000000000059b903 in mysql_execute_command (thd=thd@entry=0x22aa860) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2712 #20 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x22aa860, rawbuf=, length=58, parser_state=parser_state@entry=0x7f69c0a54760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #21 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x22aa860, packet=packet@entry=0x22adfa1 " CREATE TABLE k SELECT * FROM `table100_innodb_compressed`", packet_length=packet_length@entry=59) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #22 0x00000000005a3fc3 in do_command (thd=0x22aa860) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #23 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x22aa860) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #24 0x000000000064e242 in handle_one_connection (arg=0x22aa860) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #25 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #26 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 42 (LWP 12440): +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=0x7f69d0297450, mutex=0x2243208, that=0x2243238) 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=0x2243208, thd=0x2243100, abs_timeout=abs_timeout@entry=0x7f69d0297450, 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=0x2243208, mdl_request=0x7f6984005060, 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=0x2243208, 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=0x2243100, 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=0x2243100, tables=0x7f6984004cf0, 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=0x2243100) 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=0x2243100, rawbuf=, length=22, parser_state=parser_state@entry=0x7f69d0298760) 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=0x2243100, packet=packet@entry=0x2246841 "DROP TABLE IF EXISTS g ", 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=0x2243100) 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=0x2243100) 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=0x2243100) 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 41 (LWP 12460): +bt #0 _db_pargs_ (_line_=_line_@entry=184, keyword=keyword@entry=0xa96754 "enter") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/dbug/dbug.c:1225 #1 0x00000000007d2f26 in alloc_root (mem_root=0x228fe90, length=13) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/mysys/my_alloc.c:184 #2 0x00000000005723a7 in alloc (size=13, this=0x228d0f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_class.h:716 #3 THD::convert_string (this=0x228d0e0, to=0x7f69c0b55610, to_cs=0x1194a20 , from=0x7f69601aa8a0 "test", from_length=4, from_cs=0x1157080 ) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_class.cc:1947 #4 0x0000000000686ad7 in MYSQLparse (yythd=0x228d0e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_yacc.yy:12386 #5 0x00000000005a1ad8 in parse_sql (thd=0x228d0e0, parser_state=0x7f69c0b56470, creation_ctx=0x7f69601a7898) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:7622 #6 0x000000000061dfbc in mysql_make_view (thd=0x228d0e0, parser=, table=0x7f69601a5850, flags=1612347568) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_view.cc:1263 #7 0x000000000055fb11 in open_new_frm (thd=thd@entry=0x228d0e0, share=share@entry=0x7f69b42c83f0, alias=, db_stat=db_stat@entry=39, prgflag=prgflag@entry=44, ha_open_flags=, outparam=outparam@entry=0x0, table_desc=table_desc@entry=0x7f69601a5850, mem_root=mem_root@entry=0x7f69c0b573f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:9119 #8 0x00000000005607b7 in open_table (thd=thd@entry=0x228d0e0, table_list=table_list@entry=0x7f69601a5850, mem_root=mem_root@entry=0x7f69c0b573f0, ot_ctx=ot_ctx@entry=0x7f69c0b573c0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:3017 #9 0x000000000056180a in open_and_process_table (new_frm_mem=0x7f69c0b573f0, ot_ctx=0x7f69c0b573c0, has_prelocking_list=false, prelocking_strategy=0x7f69c0b57640, flags=0, counter=0x7f69c0b5748c, tables=0x7f69601a5850, lex=0x228ecd0, thd=0x228d0e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4495 #10 open_tables (thd=thd@entry=0x228d0e0, start=start@entry=0x7f69c0b57478, counter=counter@entry=0x7f69c0b5748c, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f69c0b57640) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4943 #11 0x0000000000562416 in open_and_lock_tables (thd=0x228d0e0, tables=0x7f6960004d30, derived=true, flags=0, prelocking_strategy=0x7f69c0b57640) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:5547 #12 0x0000000000588856 in open_and_lock_tables (flags=0, derived=true, tables=0x7f6960004d30, thd=0x228d0e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.h:475 #13 mysql_insert (thd=0x228d0e0, table_list=0x7f6960004d30, 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:741 #14 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x228d0e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #15 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x228d0e0, rawbuf=, length=52, parser_state=parser_state@entry=0x7f69c0b58760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #16 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x228d0e0, packet=packet@entry=0x2290821 " INSERT INTO y ( `c56` ) VALUES ( '04:38:22.042548' )", packet_length=packet_length@entry=53) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #17 0x00000000005a3fc3 in do_command (thd=0x228d0e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #18 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x228d0e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #19 0x000000000064e242 in handle_one_connection (arg=0x228d0e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #20 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #21 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 40 (LWP 12464): +bt #0 0x0000003da180ddcd in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003da1809c8c in _L_lock_1024 () from /lib64/libpthread.so.0 #2 0x0000003da1809c35 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x000000000055765f in inline_mysql_mutex_lock (src_line=1613, src_file=0xaa6410 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc", that=0x119de60 ) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/include/mysql/psi/mysql_thread.h:617 #4 close_thread_table (thd=thd@entry=0x229ba90, table_ptr=table_ptr@entry=0x229bb30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:1613 #5 0x00000000005579b4 in close_open_tables (thd=0x229ba90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:1362 #6 close_thread_tables (thd=0x229ba90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:1569 #7 0x00000000005a0df4 in mysql_execute_command (thd=thd@entry=0x229ba90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4677 #8 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x229ba90, rawbuf=, length=60, parser_state=parser_state@entry=0x7f69c0ad6760) 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=0x229ba90, packet=packet@entry=0x229eec1 " CREATE VIEW v AS SELECT * FROM `table500_innodb_default_int` ", packet_length=packet_length@entry=62) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #10 0x00000000005a3fc3 in do_command (thd=0x229ba90) 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=0x229ba90) 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=0x229ba90) 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 12458): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1a3d380, 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=0x1a3d380, reset_sig_count=404) 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=0x19fc430, index=1) 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=0x1a3d2d8, file_name=file_name@entry=0xb92d40 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/lock/lock0lock.c", line=line@entry=2546) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x000000000096bcae in mutex_enter_func (line=2546, file_name=0xb92d40 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/lock/lock0lock.c", mutex=0x1a3d2d8) 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=0x1a3d2d8, file_name=0xb92d40 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/lock/lock0lock.c", line=2546) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 0x0000000000970528 in lock_move_reorganize_page (block=block@entry=0x7f69c3d9d110, oblock=oblock@entry=0x7f69c3ecf790) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/lock/lock0lock.c:2546 #8 0x00000000008b317e in btr_page_reorganize_low (recovery=1, recovery@entry=0, block=block@entry=0x7f69c3d9d110, index=0x7f69b4138838, mtr=mtr@entry=0x7f69d004dbf0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0btr.c:1735 #9 0x00000000008b473d in btr_page_reorganize (block=block@entry=0x7f69c3d9d110, index=, mtr=mtr@entry=0x7f69d004dbf0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0btr.c:1791 #10 0x00000000008bf971 in btr_cur_insert_if_possible (cursor=cursor@entry=0x7f69900166b8, tuple=tuple@entry=0x7f695c1b22f8, n_ext=2, mtr=mtr@entry=0x7f69d004dbf0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0cur.c:1152 #11 0x00000000008cb881 in btr_cur_pessimistic_update (flags=flags@entry=10, cursor=cursor@entry=0x7f69900166b8, heap=heap@entry=0x7f69d004d818, big_rec=big_rec@entry=0x7f69d004d810, update=0x7f69b4519638, cmpl_info=0, thr=thr@entry=0x7f699003ad30, mtr=mtr@entry=0x7f69d004dbf0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0cur.c:2572 #12 0x000000000085e814 in row_upd_clust_rec (node=node@entry=0x7f69b4519530, index=index@entry=0x7f69b4138838, thr=thr@entry=0x7f699003ad30, mtr=mtr@entry=0x7f69d004dbf0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0upd.c:2028 #13 0x0000000000867e11 in row_upd_clust_step (node=node@entry=0x7f69b4519530, thr=thr@entry=0x7f699003ad30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0upd.c:2306 #14 0x0000000000868281 in row_upd (thr=0x7f699003ad30, node=0x7f69b4519530) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0upd.c:2357 #15 row_upd_step (thr=thr@entry=0x7f699003ad30) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0upd.c:2497 #16 0x000000000084374d in row_update_for_mysql (mysql_rec=, prebuilt=0x7f69b45179c8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1505 #17 0x000000000081f470 in ha_innobase::update_row (this=0x7f69b44b5410, old_row=0x7f69b44f89d8 "\200", new_row=0x7f69b44f88a0 "\200") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6402 #18 0x00000000006bbe58 in handler::ha_update_row (this=0x7f69b44b5410, old_data=0x7f69b44f89d8 "\200", new_data=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5451 #19 0x00000000006189a8 in multi_update::send_data (this=0x7f695c1af998, not_used_values=...) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_update.cc:1867 #20 0x00000000005d2e04 in end_send (join=0x7f695c1afa58, join_tab=, end_of_records=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:12768 #21 0x00000000005c5f9c in evaluate_join_record (join=join@entry=0x7f695c1afa58, join_tab=join_tab@entry=0x7f695c1ba468, error=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11942 #22 0x00000000005c617c in sub_select (join=0x7f695c1afa58, join_tab=0x7f695c1ba468, end_of_records=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11795 #23 0x00000000005c5f9c in evaluate_join_record (join=join@entry=0x7f695c1afa58, join_tab=join_tab@entry=0x7f695c1ba210, error=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11942 #24 0x00000000005c617c in sub_select (join=join@entry=0x7f695c1afa58, join_tab=join_tab@entry=0x7f695c1ba210, 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 #25 0x00000000005d01bc in do_select (join=join@entry=0x7f695c1afa58, fields=fields@entry=0x7f69d004e7f0, table=table@entry=0x0, procedure=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11560 #26 0x00000000005e22bc in JOIN::exec (this=0x7f695c1afa58) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2403 #27 0x00000000005dca3d in mysql_select (thd=0x2285870, rref_pointer_array=0x2287d18, tables=0x7f695c004e20, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f695c1af998, unit=0x2287520, select_lex=0x2287b40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2612 #28 0x000000000061b261 in mysql_multi_update (thd=0x2285870, table_list=0x7f695c004e20, fields=0x2287c50, values=0x2288038, conds=0x7f695c005cc8, options=, handle_duplicates=DUP_ERROR, ignore=false, unit=0x2287520, select_lex=0x2287b40, result=0x7f69d004e8f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_update.cc:1370 #29 0x000000000059d0cd in mysql_execute_command (thd=thd@entry=0x2285870) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3032 #30 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x2285870, rawbuf=, length=121, parser_state=parser_state@entry=0x7f69d004f760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #31 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2285870, packet=packet@entry=0x2288fb1 "UPDATE `table500_innodb_default` t1, `view_table100_innodb_dynamic` t2 SET t1.`c47` = '2003-07-21' WHERE t1.`c48` < 'x'", packet_length=packet_length@entry=121) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #32 0x00000000005a3fc3 in do_command (thd=0x2285870) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #33 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x2285870) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #34 0x000000000064e242 in handle_one_connection (arg=0x2285870) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #35 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #36 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 38 (LWP 12454): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1b75d00, 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=0x1b75d00, reset_sig_count=269, 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=0x7f698c0cec78) 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=0x7f69d00d0348, trx=trx@entry=0x7f6964007cb8, thr=thr@entry=0x7f698c0cec78, savept=savept@entry=0x7f69d00d0350) 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=0x7f698c060810 "\377\377\377\377 ", prebuilt=0x7f698c0cd3d8) 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=0x7f698c0761c0, record=0x7f698c060810 "\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=0x7f698c0761c0, buf=0x7f698c060810 "\377\377\377\377 ") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #8 0x00000000005865ef in write_record (thd=thd@entry=0x2276aa0, table=table@entry=0x7f698c0805a0, info=info@entry=0x7f69d00d05e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1788 #9 0x0000000000589388 in mysql_insert (thd=0x2276aa0, table_list=0x7f6964004e50, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) 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=0x2276aa0) 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=0x2276aa0, rawbuf=, length=128, parser_state=parser_state@entry=0x7f69d00d1760) 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=0x2276aa0, packet=packet@entry=0x2279ed1 "INSERT IGNORE INTO `table100_innodb_dynamic_int` ( `c59` , `c10` , `c53` ) VALUES ( NULL , '2005-08-14 03:47:49.005003' , NULL )", packet_length=packet_length@entry=128) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #13 0x00000000005a3fc3 in do_command (thd=0x2276aa0) 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=0x2276aa0) 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=0x2276aa0) 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 37 (LWP 12436): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1a3d380, 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=0x1a3d380, reset_sig_count=404) 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=0x19fc430, index=8) 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=0x1a3d2d8, file_name=file_name@entry=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", line=line@entry=796) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x000000000089fd74 in mutex_enter_func (line=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) 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=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 trx_start (trx=trx@entry=0x7f698c007d58, rseg_id=rseg_id@entry=18446744073709551615) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c:796 #8 0x000000000085a363 in trx_start_if_not_started (trx=0x7f698c007d58) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/trx0trx.ic:38 #9 row_search_for_mysql (buf=0x7f697c0252e0 "", mode=1, prebuilt=0x7f697c0487d8, match_mode=0, direction=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:3823 #10 0x00000000008170ea in ha_innobase::index_read (this=0x7f697c037400, buf=0x7f697c0252e0 "", key_ptr=, key_len=0, find_flag=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6834 #11 0x00000000008144dd in ha_innobase::index_first (this=0x7f697c037400, buf=0x7f697c0252e0 "") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7184 #12 0x00000000005d0da7 in join_read_first (tab=0x7f698c11c218) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:12596 #13 0x00000000005c616f in sub_select (join=join@entry=0x7f698c11a170, join_tab=join_tab@entry=0x7f698c11c218, 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:11794 #14 0x00000000005d01bc in do_select (join=join@entry=0x7f698c11a170, fields=fields@entry=0x7f698c11b7e8, table=table@entry=0x0, procedure=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11560 #15 0x00000000005e22bc in JOIN::exec (this=0x7f698c11a170) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2403 #16 0x00000000005dca3d in mysql_select (thd=thd@entry=0x2234330, rref_pointer_array=rref_pointer_array@entry=0x7f698c113938, tables=0x7f698c148f90, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=select_options@entry=2147749632, result=result@entry=0x7f698c1144b0, unit=unit@entry=0x7f698c113140, select_lex=select_lex@entry=0x7f698c113760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2612 #17 0x00000000005e2946 in handle_select (thd=0x2234330, lex=0x7f698c113080, result=0x7f698c1144b0, setup_tables_done_option=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:313 #18 0x0000000000594724 in execute_sqlcom_select (thd=thd@entry=0x2234330, all_tables=0x7f698c148f90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4774 #19 0x000000000059ab08 in mysql_execute_command (thd=0x2234330) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:2284 #20 0x00000000007844ce in sp_instr_stmt::exec_core (this=0x7f698c1494b8, thd=, nextp=0x7f69d0319534) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sp_head.cc:3211 #21 0x000000000078a839 in sp_lex_keeper::reset_lex_and_exec_core (this=this@entry=0x7f698c1494f8, thd=thd@entry=0x2234330, nextp=nextp@entry=0x7f69d0319534, open_tables=open_tables@entry=false, instr=instr@entry=0x7f698c1494b8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sp_head.cc:2988 #22 0x000000000078aee9 in sp_instr_stmt::execute (this=0x7f698c1494b8, thd=0x2234330, nextp=0x7f69d0319534) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sp_head.cc:3138 #23 0x0000000000786e32 in sp_head::execute (this=this@entry=0x7f698c112690, thd=thd@entry=0x2234330, merge_da_on_success=merge_da_on_success@entry=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sp_head.cc:1433 #24 0x00000000007886fe in sp_head::execute_procedure (this=0x7f698c112690, thd=, args=0x2236af8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sp_head.cc:2189 #25 0x000000000059fe53 in mysql_execute_command (thd=thd@entry=0x2234330) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4228 #26 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x2234330, rawbuf=rawbuf@entry=0x7f698c004c9d "CALL o(@a)", length=length@entry=10, parser_state=parser_state@entry=0x7f69d031a760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #27 0x00000000005a2bcf in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2234330, packet=packet@entry=0x2237761 "", packet_length=packet_length@entry=152) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1111 #28 0x00000000005a3fc3 in do_command (thd=0x2234330) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #29 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x2234330) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #30 0x000000000064e242 in handle_one_connection (arg=0x2234330) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #31 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #32 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 36 (LWP 12428): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x214df30, 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=0x214df30, reset_sig_count=9238) 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=0x19fc430, index=4) 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=lock@entry=0x214dde0, pass=pass@entry=0, file_name=file_name@entry=0xb8c1c0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fsp/fsp0fsp.c", line=line@entry=2888) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:700 #5 0x000000000093d81b in pfs_rw_lock_x_lock_func (lock=0x214dde0, pass=pass@entry=0, file_name=0xb8c1c0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fsp/fsp0fsp.c", line=2888) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:689 #6 0x000000000093da60 in mtr_x_lock_func (lock=0x214dde0, file=, line=, mtr=0x7f69d041c210) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/mtr0mtr.ic:271 #7 0x00000000009464fc in fseg_alloc_free_page_general (seg_header=0x7f69c8df404a "", hint=hint@entry=3257, direction=direction@entry=113 'q', has_done_reservation=has_done_reservation@entry=1, mtr=mtr@entry=0x7f69d041c210, init_mtr=init_mtr@entry=0x7f69d041c210) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fsp/fsp0fsp.c:2888 #8 0x00000000008b3b3f in btr_page_alloc_low (init_mtr=0x7f69d041c210, mtr=0x7f69d041c210, level=0, file_direction=113 'q', hint_page_no=3257, index=0x7f699c235e98) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0btr.c:993 #9 btr_page_alloc (index=index@entry=0x7f699c235e98, hint_page_no=hint_page_no@entry=3257, file_direction=file_direction@entry=113 'q', level=level@entry=0, mtr=mtr@entry=0x7f69d041c210, init_mtr=init_mtr@entry=0x7f69d041c210) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0btr.c:1028 #10 0x00000000008c9079 in btr_store_big_rec_extern_fields (index=index@entry=0x7f699c235e98, rec_block=, rec=rec@entry=0x7f69c9536012 "\200", offsets=offsets@entry=0x7f699c1501e8, big_rec_vec=big_rec_vec@entry=0x7f699c27d9c8, btr_mtr=btr_mtr@entry=0x7f69d041cac0, op=op@entry=BTR_STORE_INSERT) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0cur.c:4511 #11 0x00000000009ce5b4 in row_ins_index_entry_low (mode=mode@entry=33, index=index@entry=0x7f699c235e98, entry=entry@entry=0x7f699c22d638, n_ext=n_ext@entry=0, thr=thr@entry=0x7f699c129b08) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2237 #12 0x00000000009d1f88 in row_ins_index_entry (index=0x7f699c235e98, entry=0x7f699c22d638, n_ext=n_ext@entry=0, foreign=foreign@entry=1, thr=thr@entry=0x7f699c129b08) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0ins.c:2297 #13 0x00000000009d2cce in row_ins_index_entry_step (thr=0x7f699c129b08, node=0x7f699c129210) 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=0x7f699c129b08) 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=0x7f699c23c0f0 "\020", prebuilt=0x7f699c128268) 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=0x7f699c22b1a0, record=0x7f699c23c0f0 "\020") 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=0x7f699c22b1a0, buf=0x7f699c23c0f0 "\020") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #19 0x00000000005865ef in write_record (thd=0x22172e0, table=0x7f699c22a8c0, info=info@entry=0x7f699c0059a8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1788 #20 0x0000000000586973 in select_insert::send_data (this=0x7f699c005970, values=...) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:3458 #21 0x00000000005d2e04 in end_send (join=0x7f699c181ea0, join_tab=, end_of_records=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:12768 #22 0x00000000005c5f9c in evaluate_join_record (join=join@entry=0x7f699c181ea0, join_tab=join_tab@entry=0x7f699c187e70, error=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11942 #23 0x00000000005c6196 in sub_select (join=join@entry=0x7f699c181ea0, join_tab=join_tab@entry=0x7f699c187e70, 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:11800 #24 0x00000000005d01bc in do_select (join=join@entry=0x7f699c181ea0, fields=fields@entry=0x22196c0, table=table@entry=0x0, procedure=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11560 #25 0x00000000005e22bc in JOIN::exec (this=0x7f699c181ea0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2403 #26 0x00000000005dca3d in mysql_select (thd=thd@entry=0x22172e0, rref_pointer_array=rref_pointer_array@entry=0x2219788, tables=0x7f699c005420, wild_num=1, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=select_options@entry=3489925888, result=result@entry=0x7f699c005970, unit=unit@entry=0x2218f90, select_lex=select_lex@entry=0x22195b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2612 #27 0x00000000005e2946 in handle_select (thd=0x22172e0, lex=0x2218ed0, result=0x7f699c005970, setup_tables_done_option=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:313 #28 0x000000000059d5c6 in mysql_execute_command (thd=thd@entry=0x22172e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3166 #29 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x22172e0, rawbuf=, length=57, parser_state=parser_state@entry=0x7f69d041e760) 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=0x22172e0, packet=packet@entry=0x221aa21 " INSERT INTO g SELECT * FROM `table100_innodb_dynamic_int`", packet_length=packet_length@entry=58) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #31 0x00000000005a3fc3 in do_command (thd=0x22172e0) 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=0x22172e0) 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=0x22172e0) 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 35 (LWP 12430): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1b75c80, 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=0x1b75c80, reset_sig_count=341, 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=0x7f6948020038) 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=0x7f69d03dc2f8, trx=trx@entry=0x7f69a0007cb8, thr=thr@entry=0x7f6948020038, 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=0x7f6948030ab0 "\377\337\377\377 ", mode=2, prebuilt=0x7f694801e538, match_mode=1, direction=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:4753 #6 0x00000000008170ea in ha_innobase::index_read (this=0x7f694802c210, buf=0x7f6948030ab0 "\377\337\377\377 ", key_ptr=, key_len=3, find_flag=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6834 #7 0x00000000006bc857 in handler::index_read_map (this=0x7f694802c210, buf=0x7f6948030ab0 "\377\337\377\377 ", key=0x7f69a01fe808 "\001", keypart_map=, find_flag=HA_READ_KEY_EXACT) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.h:1649 #8 0x00000000005d1896 in join_read_always_key (tab=0x7f69a01fea50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:12446 #9 0x00000000005c616f in sub_select (join=join@entry=0x7f69a01fbc68, join_tab=join_tab@entry=0x7f69a01fea50, 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:11794 #10 0x00000000005d01bc in do_select (join=join@entry=0x7f69a01fbc68, fields=fields@entry=0x7f69d03dc7f0, table=table@entry=0x0, procedure=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11560 #11 0x00000000005e22bc in JOIN::exec (this=0x7f69a01fbc68) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2403 #12 0x00000000005dca3d in mysql_select (thd=0x221eb50, rref_pointer_array=0x2220ff8, tables=0x7f69a0004ea0, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f69a01fbba8, unit=0x2220800, select_lex=0x2220e20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2612 #13 0x000000000061b261 in mysql_multi_update (thd=0x221eb50, table_list=0x7f69a0004ea0, fields=0x2220f30, values=0x2221318, conds=0x7f69a0005d98, options=, handle_duplicates=DUP_ERROR, ignore=false, unit=0x2220800, select_lex=0x2220e20, result=0x7f69d03dc8f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_update.cc:1370 #14 0x000000000059d0cd in mysql_execute_command (thd=thd@entry=0x221eb50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3032 #15 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x221eb50, rawbuf=, length=160, parser_state=parser_state@entry=0x7f69d03dd760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #16 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x221eb50, packet=packet@entry=0x2221c81 "UPDATE LOW_PRIORITY `view_table100_innodb_dynamic_int` t1, `view_table100_innodb_dynamic_int` t2 SET t1.`c19` = 1 WHERE t1.`c11` = '2008-07-05 16:28:46.042192'", packet_length=packet_length@entry=160) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #17 0x00000000005a3fc3 in do_command (thd=0x221eb50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #18 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x221eb50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #19 0x000000000064e242 in handle_one_connection (arg=0x221eb50) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #20 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #21 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 34 (LWP 12452): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x2151b20, 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=0x2151b20, reset_sig_count=363) 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=0x19fc430, index=2) 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=0x7f6970007cb8, 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=0x7f69701738b0, node=0x7f697015f8f8) 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=0x7f69701738b0) 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=0x7f69701738b0) 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=0x7f69701738b0) 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=0x7f697017c180) 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=0x7f6970007cb8, savept=savept@entry=0x7f69d0111350) 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=0x7f69d0111348, trx=trx@entry=0x7f6970007cb8, thr=thr@entry=0x7f69701206f8, savept=savept@entry=0x7f69d0111350) 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=0x7f69700cfa10 "\377\377\377\377", prebuilt=0x7f697011ebf8) 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=0x7f69700e2d30, record=0x7f69700cfa10 "\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=0x7f69700e2d30, buf=0x7f69700cfa10 "\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=0x226f960, table=table@entry=0x7f69700abfc0, info=info@entry=0x7f69d01115e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1541 #19 0x0000000000589388 in mysql_insert (thd=0x226f960, table_list=0x7f6970004eb0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_UPDATE, 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=0x226f960) 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=0x226f960, rawbuf=, length=162, parser_state=parser_state@entry=0x7f69d0112760) 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=0x226f960, packet=packet@entry=0x2272a91 "INSERT HIGH_PRIORITY INTO `view_table100_innodb_default_int` ( `c20` ) VALUES ( 1 ) ON DUPLICATE KEY UPDATE `c14` = LOAD_FILE('/ssd/randgen/data/earth215kb.jpg')", packet_length=packet_length@entry=162) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #23 0x00000000005a3fc3 in do_command (thd=0x226f960) 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=0x226f960) 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=0x226f960) 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 33 (LWP 12456): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1a3d380, 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=0x1a3d380, reset_sig_count=404) 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=0x19fc430, index=9) 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=0x1a3d2d8, file_name=file_name@entry=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", line=line@entry=1775) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x00000000008a1bb4 in mutex_enter_func (line=1775, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) 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=1775, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 trx_commit_for_mysql (trx=0x7f6968007cb8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c:1775 #8 0x00000000008151c2 in innobase_commit_low (trx=trx@entry=0x7f6968007cb8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:3384 #9 0x00000000008157c1 in innobase_commit_ordered_low (trx=trx@entry=0x7f6968007cb8, thd=thd@entry=0x227e000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:3485 #10 0x000000000081bfce in innobase_commit (hton=0x1a3c9b0, thd=0x227e000, all=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:3611 #11 0x00000000006b4b3e in commit_one_phase_low (thd=thd@entry=0x227e000, all=all@entry=true, trans=trans@entry=0x227f668, is_real_trans=is_real_trans@entry=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:1462 #12 0x00000000006b6095 in ha_commit_one_phase (thd=thd@entry=0x227e000, all=all@entry=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:1446 #13 0x00000000006b673b in ha_commit_trans (thd=0x227e000, all=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:1333 #14 0x000000000065c0ca in trans_commit (thd=0x227e000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/transaction.cc:181 #15 0x000000000059f65c in mysql_execute_command (thd=thd@entry=0x227e000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3939 #16 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x227e000, rawbuf=, length=6, parser_state=parser_state@entry=0x7f69d0090760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #17 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x227e000, packet=packet@entry=0x2281741 "COMMIT", packet_length=packet_length@entry=6) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #18 0x00000000005a3fc3 in do_command (thd=0x227e000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #19 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x227e000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #20 0x000000000064e242 in handle_one_connection (arg=0x227e000) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #21 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #22 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 32 (LWP 12370): +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 31 (LWP 12466): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1a3d380, 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=0x1a3d380, reset_sig_count=404) 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=0x19fc430, 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=0x1a3d2d8, file_name=file_name@entry=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", line=line@entry=796) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x000000000089fd74 in mutex_enter_func (line=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) 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=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 trx_start (trx=trx@entry=0x7f694c007cb8, rseg_id=rseg_id@entry=18446744073709551615) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c:796 #8 0x0000000000842ba1 in trx_start_if_not_started (trx=0x7f694c007cb8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/trx0trx.ic:38 #9 row_insert_for_mysql (mysql_rec=0x7f69b426c180 "\377\377\377\377", prebuilt=0x7f69b4533c58) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1222 #10 0x000000000081f9fc in ha_innobase::write_row (this=0x7f69b43863c0, record=0x7f69b426c180 "\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #11 0x00000000006bbd28 in handler::ha_write_row (this=0x7f69b43863c0, buf=0x7f69b426c180 "\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #12 0x00000000005865ef in write_record (thd=thd@entry=0x22a2ff0, table=table@entry=0x7f69b442b4a0, info=info@entry=0x7f69c0a945e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1788 #13 0x0000000000589388 in mysql_insert (thd=0x22a2ff0, table_list=0x7f694c004d10, 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 #14 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x22a2ff0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #15 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x22a2ff0, rawbuf=, length=39, parser_state=parser_state@entry=0x7f69c0a95760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #16 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x22a2ff0, packet=packet@entry=0x22a6731 " INSERT INTO n ( `c36` ) VALUES ( NULL )", packet_length=packet_length@entry=40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #17 0x00000000005a3fc3 in do_command (thd=0x22a2ff0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #18 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x22a2ff0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #19 0x000000000064e242 in handle_one_connection (arg=0x22a2ff0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #20 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #21 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 30 (LWP 12369): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x2151b20, 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=0x2151b20, reset_sig_count=363) 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=0x19fc430, 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=0x2174798, 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=0x2175260, updated_extern=0x7f69bd295c28, node=0x2175418) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0purge.c:680 #9 row_purge (thr=0x2175260, node=0x2175418) 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=0x2175260) 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=0x2175260) 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=0x2175260) 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=0x2175260) 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 29 (LWP 12474): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1a3d380, 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=0x1a3d380, reset_sig_count=404) 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=0x19fc430, index=7) 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=0x1a3d2d8, file_name=file_name@entry=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", line=line@entry=796) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x000000000089fd74 in mutex_enter_func (line=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) 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=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 trx_start (trx=trx@entry=0x7f693c00bd38, rseg_id=rseg_id@entry=18446744073709551615) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c:796 #8 0x0000000000842ba1 in trx_start_if_not_started (trx=0x7f693c00bd38) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/trx0trx.ic:38 #9 row_insert_for_mysql (mysql_rec=0x7f69880096b0 "\377\377\377\377 ", prebuilt=0x7f698818a4b8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1222 #10 0x000000000081f9fc in ha_innobase::write_row (this=0x7f69880e3fb0, record=0x7f69880096b0 "\377\377\377\377 ") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #11 0x00000000006bbd28 in handler::ha_write_row (this=0x7f69880e3fb0, buf=0x7f69880096b0 "\377\377\377\377 ") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #12 0x00000000005865ef in write_record (thd=thd@entry=0x22c11b0, table=table@entry=0x7f698809a8e0, info=info@entry=0x7f69c09905e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1788 #13 0x0000000000589388 in mysql_insert (thd=0x22c11b0, table_list=0x7f693c004d18, 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 #14 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x22c11b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #15 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x22c11b0, rawbuf=, length=43, parser_state=parser_state@entry=0x7f69c0991760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #16 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x22c11b0, packet=packet@entry=0x22c48f1 " INSERT INTO q ( `c48` ) VALUES ( -4930560 )", packet_length=packet_length@entry=44) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #17 0x00000000005a3fc3 in do_command (thd=0x22c11b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #18 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x22c11b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #19 0x000000000064e242 in handle_one_connection (arg=0x22c11b0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #20 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #21 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 28 (LWP 12372): +bt #0 0x0000003da180e0ad in read () from /lib64/libpthread.so.0 #1 0x0000000000a5e9e6 in vio_read (vio=0x22055e0, buf=0x220b730 "\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=0x21806f0, complen=complen@entry=0x7f69d04a0d88) 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=0x21806f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/net_serv.cc:1033 #4 0x00000000005a3e59 in do_command (thd=0x21804c0) 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=0x21804c0) 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=0x21804c0) 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 27 (LWP 12462): +bt #0 0x0000003da180ddcd in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003da1809c8c in _L_lock_1024 () from /lib64/libpthread.so.0 #2 0x0000003da1809c35 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000005610ed in inline_mysql_mutex_lock (src_line=2969, src_file=0xaa6410 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc", that=0x119de60 ) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/include/mysql/psi/mysql_thread.h:617 #4 open_table (thd=thd@entry=0x2294950, table_list=table_list@entry=0x7f69c0b16280, mem_root=0x2297700, ot_ctx=ot_ctx@entry=0x7f69c0b161a0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:2969 #5 0x000000000056341c in open_ltable (thd=thd@entry=0x2294950, table_list=table_list@entry=0x7f69c0b16280, lock_type=TL_WRITE, lock_flags=lock_flags@entry=2048) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:5452 #6 0x00000000005638a8 in open_system_table_for_update (thd=0x2294950, one_table=0x7f69c0b16280) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:9370 #7 0x000000000077f945 in open_proc_table_for_update (thd=thd@entry=0x2294950) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sp.cc:449 #8 0x0000000000781b85 in sp_drop_routine (thd=0x2294950, type=1, name=0x7f6954004eb0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sp.cc:1255 #9 0x00000000005a0223 in mysql_execute_command (thd=thd@entry=0x2294950) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4337 #10 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x2294950, rawbuf=, length=265, parser_state=parser_state@entry=0x7f69c0b17760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #11 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2294950, packet=packet@entry=0x2297a81 "DROP FUNCTION IF EXISTS f ; CREATE FUNCTION f ( l CHAR( 2 ) ) RETURNS DATETIME DETERMINISTIC READS SQL DATA BEGIN DECLARE out1 BLOB ; SELECT `table100_innodb_compressed_int_autoinc`.`c21` INTO out1 FROM `table500_innodb_default_int` ; RETURN out1 ; END ; CALL f(@a)", packet_length=packet_length@entry=265) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #12 0x00000000005a3fc3 in do_command (thd=0x2294950) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #13 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x2294950) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #14 0x000000000064e242 in handle_one_connection (arg=0x2294950) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #15 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #16 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 26 (LWP 12367): +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 25 (LWP 12368): +bt #0 0x0000003da14ea9f3 in select () from /lib64/libc.so.6 #1 0x000000000099a1fc in os_thread_sleep (tm=tm@entry=997000) 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 24 (LWP 12444): +bt #0 0x0000003da180ddcd in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003da1809c8c in _L_lock_1024 () from /lib64/libpthread.so.0 #2 0x0000003da1809c35 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000005610ed in inline_mysql_mutex_lock (src_line=2969, src_file=0xaa6410 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc", that=0x119de60 ) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/include/mysql/psi/mysql_thread.h:617 #4 open_table (thd=thd@entry=0x22521e0, table_list=table_list@entry=0x7f697c019d80, mem_root=mem_root@entry=0x7f69d02155c0, ot_ctx=ot_ctx@entry=0x7f69d0215590) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:2969 #5 0x000000000056180a in open_and_process_table (new_frm_mem=0x7f69d02155c0, ot_ctx=0x7f69d0215590, has_prelocking_list=false, prelocking_strategy=0x7f69d0215770, flags=0, counter=0x7f69d021565c, tables=0x7f697c019d80, lex=0x2253dd0, thd=0x22521e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4495 #6 open_tables (thd=thd@entry=0x22521e0, start=start@entry=0x7f69d0215648, counter=counter@entry=0x7f69d021565c, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f69d0215770) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4943 #7 0x0000000000562416 in open_and_lock_tables (thd=0x22521e0, tables=0x7f697c004d50, derived=true, flags=0, prelocking_strategy=0x7f69d0215770) 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=0x22521e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.h:475 #9 mysql_create_view (thd=0x22521e0, views=0x7f697c004d50, 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=0x22521e0) 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=0x22521e0, rawbuf=, length=68, parser_state=parser_state@entry=0x7f69d0216760) 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=0x22521e0, packet=packet@entry=0x2255921 " CREATE VIEW o AS SELECT * FROM `view_table100_innodb_compressed_int` ", packet_length=packet_length@entry=70) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #13 0x00000000005a3fc3 in do_command (thd=0x22521e0) 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=0x22521e0) 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=0x22521e0) 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 12426): +bt #0 0x0000000000a3ba2f in _db_return_ (_line_=_line_@entry=240, _stack_frame_=_stack_frame_@entry=0x7f69d045e180) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/dbug/dbug.c:1161 #1 0x00000000007d30e3 in alloc_root (mem_root=0x22124f0, length=232) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/mysys/my_alloc.c:240 #2 0x000000000062bce7 in sql_alloc (Size=232) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/thr_malloc.cc:73 #3 0x00000000006205b3 in operator new (size=232) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/item.h:514 #4 Field_iterator_table::create_item (this=0x7f69d045e290, thd=0x220f740) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/table.cc:4406 #5 0x000000000055d99a in create_item (thd=0x220f740, this=0x7f69d045e270) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/table.h:1930 #6 insert_fields (thd=thd@entry=0x220f740, context=, db_name=0x0, table_name=0x0, it=it@entry=0x7f69d045e420, any_privileges=any_privileges@entry=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:8342 #7 0x000000000055dfdf in setup_wild (thd=0x220f740, tables=, fields=..., sum_func_list=0x7f69b454c5c8, wild_num=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:7868 #8 0x00000000005d3eb7 in JOIN::prepare (this=0x7f69b454afe0, rref_pointer_array=0x2211be8, tables_init=0x7f69b4008740, wild_num=1, conds_init=, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x2211a10, unit_arg=0x22113f0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:568 #9 0x0000000000616391 in st_select_lex_unit::prepare (this=0x22113f0, thd_arg=0x220f740, sel_result=, additional_options=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_union.cc:265 #10 0x000000000061d29e in mysql_create_view (thd=, views=0x7f69b4008078, mode=VIEW_CREATE_NEW) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_view.cc:561 #11 0x00000000005a05f2 in mysql_execute_command (thd=thd@entry=0x220f740) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:4452 #12 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x220f740, rawbuf=, length=56, parser_state=parser_state@entry=0x7f69d045f760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #13 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x220f740, packet=packet@entry=0x22131b1 " CREATE VIEW w AS SELECT * FROM `table500_innodb_dynamic` ", packet_length=packet_length@entry=58) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #14 0x00000000005a3fc3 in do_command (thd=0x220f740) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #15 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x220f740) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #16 0x000000000064e242 in handle_one_connection (arg=0x220f740) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #17 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #18 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 22 (LWP 12360): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=2, array=0x1e274e0) 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=0x7f69c1b5ae68, message2=message2@entry=0x7f69c1b5ae60, type=type@entry=0x7f69c1b5ae58, space_id=space_id@entry=0x7f69c1b5ae50) 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 21 (LWP 12432): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1a3d380, 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=0x1a3d380, reset_sig_count=404) 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=0x19fc430, index=6) 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=0x1a3d2d8, file_name=file_name@entry=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", line=line@entry=796) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x000000000089fd74 in mutex_enter_func (line=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) 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=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 trx_start (trx=trx@entry=0x7f6994018c48, rseg_id=rseg_id@entry=18446744073709551615) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c:796 #8 0x0000000000842ba1 in trx_start_if_not_started (trx=0x7f6994018c48) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/trx0trx.ic:38 #9 row_insert_for_mysql (mysql_rec=0x7f69941813f0 "\377\377\373\377", prebuilt=0x7f69941a7588) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:1222 #10 0x000000000081f9fc in ha_innobase::write_row (this=0x7f699418a810, record=0x7f69941813f0 "\377\377\373\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6075 #11 0x00000000006bbd28 in handler::ha_write_row (this=0x7f699418a810, buf=0x7f69941813f0 "\377\377\373\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:5424 #12 0x0000000000586556 in write_record (thd=thd@entry=0x2225c90, table=table@entry=0x7f6994164ba0, info=info@entry=0x7f69d039b5e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1541 #13 0x0000000000589388 in mysql_insert (thd=0x2225c90, table_list=0x7f6994004ee0, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_UPDATE, ignore=false) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:956 #14 0x000000000059d2f5 in mysql_execute_command (thd=thd@entry=0x2225c90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3091 #15 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x2225c90, rawbuf=, length=161, parser_state=parser_state@entry=0x7f69d039c760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #16 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x2225c90, packet=packet@entry=0x22290c1 "INSERT HIGH_PRIORITY INTO `view_table500_innodb_compressed_int_autoinc` ( `c45` ) VALUES ( '20090511131205.039070' ) ON DUPLICATE KEY UPDATE `c1` = '2009-05-14'", packet_length=packet_length@entry=161) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #17 0x00000000005a3fc3 in do_command (thd=0x2225c90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #18 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x2225c90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #19 0x000000000064e242 in handle_one_connection (arg=0x2225c90) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #20 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #21 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 20 (LWP 12366): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009999ed in os_cond_wait_timed (abstime=0x7f69bea98e10, mutex=0x1cae580, cond=0x1cae5b8) 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=0x1cae580, 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 19 (LWP 12361): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=3, array=0x1e274e0) 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=0x7f69c1359e68, message2=message2@entry=0x7f69c1359e60, type=type@entry=0x7f69c1359e58, space_id=space_id@entry=0x7f69c1359e50) 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 18 (LWP 12450): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1b75d80, 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=0x1b75d80, reset_sig_count=222, 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=0x7f69b4548408) 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=0x7f69d0152348, trx=trx@entry=0x7f696c007cb8, thr=thr@entry=0x7f69b4548408, savept=savept@entry=0x7f69d0152350) 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=0x7f69b4542880 "\357\377\377\377", prebuilt=0x7f69b4546958) 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=0x7f69b4540c20, record=0x7f69b4542880 "\357\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=0x7f69b4540c20, buf=0x7f69b4542880 "\357\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=0x22680f0, table=table@entry=0x7f69b4540340, info=info@entry=0x7f69d01525e0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_insert.cc:1541 #9 0x0000000000589388 in mysql_insert (thd=0x22680f0, table_list=0x7f696c004e38, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_UPDATE, 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=0x22680f0) 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=0x22680f0, rawbuf=, length=119, parser_state=parser_state@entry=0x7f69d0153760) 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=0x22680f0, packet=packet@entry=0x226b831 "INSERT INTO `view_table500_innodb_dynamic` ( `c4` ) VALUES ( 'he' ) ON DUPLICATE KEY UPDATE `c48` = '07:03:00.027681'", packet_length=packet_length@entry=119) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #13 0x00000000005a3fc3 in do_command (thd=0x22680f0) 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=0x22680f0) 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=0x22680f0) 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 17 (LWP 12359): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=1, array=0x1e274e0) 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=0x7f69c235be68, message2=message2@entry=0x7f69c235be60, type=type@entry=0x7f69c235be58, space_id=space_id@entry=0x7f69c235be50) 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 16 (LWP 12364): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009999ed in os_cond_wait_timed (abstime=0x7f69bfa9adc0, mutex=0x1cae500, cond=0x1cae538) 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=0x1cae500, 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 15 (LWP 12438): +bt #0 0x0000003da180ddcd in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x0000003da1809c8c in _L_lock_1024 () from /lib64/libpthread.so.0 #2 0x0000003da1809c35 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000005610ed in inline_mysql_mutex_lock (src_line=2969, src_file=0xaa6410 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc", that=0x119de60 ) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/include/mysql/psi/mysql_thread.h:617 #4 open_table (thd=thd@entry=0x223b890, table_list=table_list@entry=0x7f6990005498, mem_root=mem_root@entry=0x7f69d02d85c0, ot_ctx=ot_ctx@entry=0x7f69d02d8590) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:2969 #5 0x000000000056180a in open_and_process_table (new_frm_mem=0x7f69d02d85c0, ot_ctx=0x7f69d02d8590, has_prelocking_list=false, prelocking_strategy=0x7f69d02d8770, flags=0, counter=0x7f69d02d865c, tables=0x7f6990005498, lex=0x223d480, thd=0x223b890) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4495 #6 open_tables (thd=thd@entry=0x223b890, start=start@entry=0x7f69d02d8648, counter=counter@entry=0x7f69d02d865c, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0x7f69d02d8770) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.cc:4943 #7 0x0000000000562416 in open_and_lock_tables (thd=0x223b890, tables=0x7f6990004d60, derived=true, flags=0, prelocking_strategy=0x7f69d02d8770) 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=0x223b890) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_base.h:475 #9 mysql_create_view (thd=0x223b890, views=0x7f6990004d60, 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=0x223b890) 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=0x223b890, rawbuf=, length=76, parser_state=parser_state@entry=0x7f69d02d9760) 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=0x223b890, packet=packet@entry=0x223efd1 " CREATE VIEW c AS SELECT * FROM `view_table100_innodb_compressed_int_autoinc` ", packet_length=packet_length@entry=78) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #13 0x00000000005a3fc3 in do_command (thd=0x223b890) 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=0x223b890) 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=0x223b890) 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 14 (LWP 12365): +bt #0 0x0000003da180b902 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000009999ed in os_cond_wait_timed (abstime=0x7f69bf299da0, mutex=0x1cae480, cond=0x1cae4b8) 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=0x1cae480, 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 13 (LWP 12357): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=3, array=0x1e1f260) 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=0x7f69c335de68, message2=message2@entry=0x7f69c335de60, type=type@entry=0x7f69c335de58, space_id=space_id@entry=0x7f69c335de50) 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 12 (LWP 12434): +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=0x7f69d0359ff0, mutex=0x222d2f8, that=0x222d328) 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=0x222d2f8, thd=0x222d1f0, abs_timeout=abs_timeout@entry=0x7f69d0359ff0, 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=0x222d2f8, mdl_request=0x7f6998005060, 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=0x222d2f8, 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=0x222d1f0, 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=0x222d1f0, views=0x7f6998004cf0, 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=0x222d1f0) 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=0x222d1f0, rawbuf=, length=21, parser_state=parser_state@entry=0x7f69d035b760) 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=0x222d1f0, packet=packet@entry=0x2230321 " DROP VIEW IF EXISTS q ", 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=0x222d1f0) 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=0x222d1f0) 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=0x222d1f0) 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 11 (LWP 12362): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1cae680, 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=0x1cae680, reset_sig_count=260, 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 0x0000000000874cc3 in srv_redo_log_follow_thread (arg=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/srv/srv0srv.c:3076 #4 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #5 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 10 (LWP 12358): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=0, array=0x1e274e0) 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=6, message1=message1@entry=0x7f69c2b5ce68, message2=message2@entry=0x7f69c2b5ce60, type=type@entry=0x7f69c2b5ce58, space_id=space_id@entry=0x7f69c2b5ce50) 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=6) 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 9 (LWP 12472): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x1a3d380, 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=0x1a3d380, reset_sig_count=404) 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=0x19fc430, index=11) 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=0x1a3d2d8, file_name=file_name@entry=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", line=line@entry=796) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0sync.c:653 #5 0x000000000089fd74 in mutex_enter_func (line=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) 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=796, file_name=0xb79f38 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c", mutex=0x1a3d2d8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0sync.ic:251 #7 trx_start (trx=trx@entry=0x7f6948007cb8, rseg_id=rseg_id@entry=18446744073709551615) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/trx/trx0trx.c:796 #8 0x000000000085a363 in trx_start_if_not_started (trx=0x7f6948007cb8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/trx0trx.ic:38 #9 row_search_for_mysql (buf=0x7f69b43d9680 "\377\377\377\377", mode=1, prebuilt=0x7f69b43b82c8, match_mode=0, direction=0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:3823 #10 0x00000000008170ea in ha_innobase::index_read (this=0x7f69b439dbc0, buf=0x7f69b43d9680 "\377\377\377\377", key_ptr=, key_len=0, find_flag=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:6834 #11 0x00000000008144dd in ha_innobase::index_first (this=0x7f69b439dbc0, buf=0x7f69b43d9680 "\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7184 #12 0x0000000000821e43 in ha_innobase::rnd_next (this=0x7f69b439dbc0, buf=0x7f69b43d9680 "\377\377\377\377") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7281 #13 0x000000000077e613 in rr_sequential (info=0x7f69481a9a68) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/records.cc:461 #14 0x00000000005be410 in join_init_read_record (tab=0x7f69481a99e8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:12571 #15 0x00000000005c616f in sub_select (join=join@entry=0x7f69481a7640, join_tab=join_tab@entry=0x7f69481a99e8, 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:11794 #16 0x00000000005d01bc in do_select (join=join@entry=0x7f69481a7640, fields=fields@entry=0x7f69c09d17f0, table=table@entry=0x0, procedure=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11560 #17 0x00000000005e22bc in JOIN::exec (this=0x7f69481a7640) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2403 #18 0x00000000005dca3d in mysql_select (thd=0x22b9940, rref_pointer_array=0x22bbde8, tables=0x7f6948004e30, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f69481a7060, unit=0x22bb5f0, select_lex=0x22bbc10) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2612 #19 0x000000000061b261 in mysql_multi_update (thd=0x22b9940, table_list=0x7f6948004e30, fields=0x22bbd20, values=0x22bc108, conds=0x7f6948005ca0, options=, handle_duplicates=DUP_ERROR, ignore=false, unit=0x22bb5f0, select_lex=0x22bbc10, result=0x7f69c09d18f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_update.cc:1370 #20 0x000000000059d0cd in mysql_execute_command (thd=thd@entry=0x22b9940) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3032 #21 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x22b9940, rawbuf=, length=118, parser_state=parser_state@entry=0x7f69c09d2760) 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=0x22b9940, packet=packet@entry=0x22bd081 "UPDATE `view_table500_innodb_dynamic` t1, `view_table100_innodb_dynamic` t2 SET t1.`c41` = NULL WHERE t1.`c48` < 'k'", packet_length=packet_length@entry=118) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #23 0x00000000005a3fc3 in do_command (thd=0x22b9940) 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=0x22b9940) 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=0x22b9940) 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 8 (LWP 12354): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=0, array=0x1e1f260) 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=0x7f69d14e3e68, message2=message2@entry=0x7f69d14e3e60, type=type@entry=0x7f69d14e3e58, space_id=space_id@entry=0x7f69d14e3e50) 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 7 (LWP 12352): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=0, array=0x1e02db0) 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=0x7f69d32e3e68, message2=message2@entry=0x7f69d32e3e60, type=type@entry=0x7f69d32e3e58, space_id=space_id@entry=0x7f69d32e3e50) 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 6 (LWP 12355): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=1, array=0x1e1f260) 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=0x7f69d0ce2e68, message2=message2@entry=0x7f69d0ce2e60, type=type@entry=0x7f69d0ce2e58, space_id=space_id@entry=0x7f69d0ce2e50) 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 5 (LWP 12470): +bt #0 0x0000003da180b595 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000999ae5 in os_cond_wait (mutex=0x214df30, 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=0x214df30, reset_sig_count=9238) 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=0x19fc430, 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=lock@entry=0x214dde0, pass=pass@entry=0, file_name=file_name@entry=0xb8c1c0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fsp/fsp0fsp.c", line=line@entry=3573) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/sync/sync0rw.c:700 #5 0x000000000093d81b in pfs_rw_lock_x_lock_func (lock=0x214dde0, pass=pass@entry=0, file_name=0xb8c1c0 "/ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fsp/fsp0fsp.c", line=3573) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/sync0rw.ic:689 #6 0x000000000093da60 in mtr_x_lock_func (lock=0x214dde0, file=, line=, mtr=0x7f69c0a0fe40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/include/mtr0mtr.ic:271 #7 0x000000000094766e in fseg_free_step (header=header@entry=0x7f69c8e4404a "", mtr=mtr@entry=0x7f69c0a0fe40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/fsp/fsp0fsp.c:3573 #8 0x00000000008b40f3 in btr_free_but_not_root (space=space@entry=0, zip_size=zip_size@entry=0, root_page_no=root_page_no@entry=3753) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/btr/btr0btr.c:1544 #9 0x0000000000909719 in dict_drop_index_tree (rec=0x7f69c8e02090 "", mtr=mtr@entry=0x7f69c0a10740) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/dict/dict0crea.c:795 #10 0x0000000000866e66 in row_upd_clust_step (node=node@entry=0x7f69441317f8, thr=thr@entry=0x7f694414c3c8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0upd.c:2211 #11 0x0000000000868281 in row_upd (thr=0x7f694414c3c8, node=0x7f69441317f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0upd.c:2357 #12 row_upd_step (thr=thr@entry=0x7f694414c3c8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0upd.c:2497 #13 0x00000000009bd7ad in que_thr_step (thr=0x7f694414c3c8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1238 #14 que_run_threads_low (thr=0x7f694414c3c8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1319 #15 que_run_threads (thr=0x7f694414c3c8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1356 #16 0x00000000009be479 in que_eval_sql (info=info@entry=0x7f6944018178, sql=sql@entry=0xb6e0e8 "PROCEDURE DROP_TABLE_PROC () IS\nsys_foreign_id CHAR;\ntable_id CHAR;\nindex_id CHAR;\nforeign_id CHAR;\nfound INT;\nDECLARE CURSOR cur_fk IS\nSELECT ID FROM SYS_FOREIGN\nWHERE FOR_NAME = :table_name\nAND TO_BINARY(FOR_NAME)\n = TO_BINARY(:table_name)\nLOCK IN SHARE MODE;\nDECLARE CURSOR cur_idx IS\nSELECT ID FROM SYS_INDEXES\nWHERE TABLE_ID = table_id\nLOCK IN SHARE MODE;\nBEGIN\nSELECT ID INTO table_id\nFROM SYS_TABLES\nWHERE NAME = :table_name\nLOCK IN SHARE MODE;\nIF (SQL % NOTFOUND) THEN\n RETURN;\nEND IF;\nfound := 1;\nSELECT ID INTO sys_foreign_id\nFROM SYS_TABLES\nWHERE NAME = 'SYS_FOREIGN'\nLOCK IN SHARE MODE;\nIF (SQL % NOTFOUND) THEN\n found := 0;\nEND IF;\nIF (:table_name = 'SYS_FOREIGN') THEN\n found := 0;\nEND IF;\nIF (:table_name = 'SYS_FOREIGN_COLS') THEN\n found := 0;\nEND IF;\nOPEN cur_fk;\nWHILE found = 1 LOOP\n FETCH cur_fk INTO foreign_id;\n IF (SQL % NOTFOUND) THEN\n", ' ' , "found := 0;\n ELSE\n", ' ' , "DELETE FROM SYS_FOREIGN_COLS\n", ' ' , "WHERE "..., reserve_dict_mutex=reserve_dict_mutex@entry=1, trx=trx@entry=0x7f694415cab8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/que/que0que.c:1445 #17 0x0000000000846b48 in row_drop_table_for_mysql (name=, trx=0x7f694415cab8, drop_db=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0mysql.c:3446 #18 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 #19 0x00000000006b9a12 in handler::ha_delete_table (this=this@entry=0x7f69440bc840, name=name@entry=0x7f69c0a12590 "./test/a") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:3660 #20 0x00000000006b9b0b in ha_delete_table (thd=0x22b20d0, table_type=, path=0x7f69c0a12590 "./test/a", db=0x7f6944005218 "test", alias=0x7f6944004cb8 "a", generate_warning=true) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/handler.cc:2211 #21 0x000000000060084e in mysql_rm_table_no_locks (thd=thd@entry=0x22b20d0, tables=tables@entry=0x7f6944004cf0, 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 #22 0x0000000000601271 in mysql_rm_table (thd=0x22b20d0, tables=0x7f6944004cf0, 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 #23 0x000000000059da4c in mysql_execute_command (thd=thd@entry=0x22b20d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3283 #24 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x22b20d0, rawbuf=, length=22, parser_state=parser_state@entry=0x7f69c0a13760) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:5844 #25 0x00000000005a2a08 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x22b20d0, packet=packet@entry=0x22b5811 "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 #26 0x00000000005a3fc3 in do_command (thd=0x22b20d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:788 #27 0x000000000064e14c in do_handle_one_connection (thd_arg=thd_arg@entry=0x22b20d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1497 #28 0x000000000064e242 in handle_one_connection (arg=0x22b20d0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_connect.cc:1404 #29 0x0000003da1807d14 in start_thread () from /lib64/libpthread.so.0 #30 0x0000003da14f168d in clone () from /lib64/libc.so.6 Thread 4 (LWP 12356): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=2, array=0x1e1f260) 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=0x7f69c3b5ee68, message2=message2@entry=0x7f69c3b5ee60, type=type@entry=0x7f69c3b5ee58, space_id=space_id@entry=0x7f69c3b5ee50) 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 3 (LWP 12350): +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=46, argv=0x19fc288) 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 2 (LWP 12353): +bt #0 0x0000003fa1400614 in ?? () from /lib64/libaio.so.1 #1 0x0000000000996fe7 in os_aio_linux_collect (seg_size=256, segment=0, array=0x1e10fe0) 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=0x7f69d1ce4e68, message2=message2@entry=0x7f69d1ce4e60, type=type@entry=0x7f69d1ce4e58, space_id=space_id@entry=0x7f69d1ce4e50) 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 1 (LWP 12442): +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 0x000000000096e2f1 in lock_rec_add_to_queue (type_mode=type_mode@entry=1059, block=block@entry=0x7f69c3f77210, heap_no=heap_no@entry=9, index=index@entry=0x7f69b4121328, trx=trx@entry=0x7f696c007cb8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/lock/lock0lock.c:1890 #7 0x000000000096ecdd in lock_rec_convert_impl_to_expl (block=block@entry=0x7f69c3f77210, rec=rec@entry=0x7f69cb1340b6 "j \001", index=index@entry=0x7f69b4121328, offsets=offsets@entry=0x7f69d0255ae0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/lock/lock0lock.c:5295 #8 0x0000000000974e29 in lock_sec_rec_read_check_and_lock (flags=8992, flags@entry=0, block=block@entry=0x7f69c3f77210, rec=rec@entry=0x7f69cb1340b6 "j \001", index=index@entry=0x7f69b4121328, offsets=offsets@entry=0x7f69d0255ae0, mode=mode@entry=LOCK_S, gap_mode=gap_mode@entry=0, thr=thr@entry=0x7f695402bdf8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/lock/lock0lock.c:5514 #9 0x00000000008522e6 in sel_set_rec_lock (block=0x7f69c3f77210, rec=rec@entry=0x7f69cb1340b6 "j \001", index=index@entry=0x7f69b4121328, offsets=offsets@entry=0x7f69d0255ae0, mode=mode@entry=2, type=type@entry=0, thr=thr@entry=0x7f695402bdf8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:1007 #10 0x000000000085b413 in row_search_for_mysql (buf=0x7f695401b340 "\b\001\200\300\320\a", mode=1, prebuilt=0x7f695402acd8, match_mode=0, direction=1) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/row/row0sel.c:4296 #11 0x0000000000821cc9 in ha_innobase::general_fetch (this=this@entry=0x7f6954070e00, buf=buf@entry=0x7f695401b340 "\b\001\200\300\320\a", 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 #12 0x0000000000821f47 in ha_innobase::index_next (this=0x7f6954070e00, buf=0x7f695401b340 "\b\001\200\300\320\a") at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/storage/innobase/handler/ha_innodb.cc:7135 #13 0x00000000005d0e02 in join_read_next (info=0x7f69880f2c20) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:12610 #14 0x00000000005c6189 in sub_select (join=0x7f69880f0280, join_tab=0x7f69880f2ba0, end_of_records=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11799 #15 0x00000000005c5f9c in evaluate_join_record (join=join@entry=0x7f69880f0280, join_tab=join_tab@entry=0x7f69880f2948, error=) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11942 #16 0x00000000005c6196 in sub_select (join=join@entry=0x7f69880f0280, join_tab=join_tab@entry=0x7f69880f2948, 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:11800 #17 0x00000000005d01bc in do_select (join=join@entry=0x7f69880f0280, fields=fields@entry=0x7f69d02567f0, table=table@entry=0x0, procedure=0x0) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:11560 #18 0x00000000005e22bc in JOIN::exec (this=0x7f69880f0280) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2403 #19 0x00000000005dca3d in mysql_select (thd=0x224a970, rref_pointer_array=0x224ce18, tables=0x7f6988004e98, wild_num=0, fields=..., conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=1342177408, result=0x7f69880efc40, unit=0x224c620, select_lex=0x224cc40) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_select.cc:2612 #20 0x000000000061b261 in mysql_multi_update (thd=0x224a970, table_list=0x7f6988004e98, fields=0x224cd50, values=0x224d138, conds=0x7f6988005dc8, options=, handle_duplicates=DUP_ERROR, ignore=false, unit=0x224c620, select_lex=0x224cc40, result=0x7f69d02568f8) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_update.cc:1370 #21 0x000000000059d0cd in mysql_execute_command (thd=thd@entry=0x224a970) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:3032 #22 0x00000000005a1f2d in mysql_parse (thd=thd@entry=0x224a970, rawbuf=, length=166, parser_state=parser_state@entry=0x7f69d0257760) 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=0x224a970, packet=packet@entry=0x224e0b1 "UPDATE `view_table100_innodb_compressed` t1, `view_table500_innodb_dynamic` t2 SET t1.`c52` = '2006-12-26 06:31:16.023508' WHERE t1.`c57` <> '20030225203210.010119'", packet_length=packet_length@entry=166) at /ssd/QA-16274-5.5/Percona-Server-5.5.28-rel29.3/sql/sql_parse.cc:1061 #24 0x00000000005a3fc3 in do_command (thd=0x224a970) 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=0x224a970) 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=0x224a970) 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 +quit