[New LWP 17895] [New LWP 17852] [New LWP 17854] [New LWP 17851] [New LWP 17855] [New LWP 17856] [New LWP 17860] [New LWP 17857] [New LWP 17890] [New LWP 17853] [New LWP 17868] [New LWP 17859] [New LWP 17858] [New LWP 17892] [New LWP 17866] [New LWP 17864] [New LWP 17869] [New LWP 17863] [New LWP 17867] [New LWP 17865] [New LWP 17871] [New LWP 17888] [New LWP 17849] [New LWP 17861] [New LWP 17907] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". Core was generated by `/data/src/5.5-bug/sql/mysqld --no-defaults --basedir=/data/src/5.5-bug --charac'. Program terminated with signal SIGSEGV, Segmentation fault. #0 __pthread_kill (threadid=, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 Thread 25 (Thread 0x7f72b8665700 (LWP 17907)): #0 0x00007f72b874747d in fdatasync () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x0000000000c07c10 in os_file_fsync (file=12, metadata=0) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:2289 #2 0x0000000000c07cfb in os_file_flush_func (file=12, metadata=0) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:2396 #3 0x0000000000b9c2d9 in pfs_os_file_flush_func (file=12, metadata=0, src_file=0xe3e5f8 "/data/src/5.5-bug/storage/xtradb/fil/fil0fil.c", src_line=5839) at /data/src/5.5-bug/storage/xtradb/include/os0file.ic:385 #4 0x0000000000bad779 in fil_flush (space_id=4294967280, metadata=0) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5839 #5 0x0000000000bedcca in log_write_up_to (lsn=39922091, wait=92, flush_to_disk=1) at /data/src/5.5-bug/storage/xtradb/log/log0log.c:1731 #6 0x0000000000b0f04b in trx_commit_off_kernel (trx=0x7f729647c278) at /data/src/5.5-bug/storage/xtradb/trx/trx0trx.c:1261 #7 0x0000000000b10a1d in trx_commit_for_mysql (trx=0x7f729647c278) at /data/src/5.5-bug/storage/xtradb/trx/trx0trx.c:1936 #8 0x0000000000abb729 in row_drop_table_for_mysql (name=0x7f729641ee78 "test/tmp542", trx=0x7f729647c278, drop_db=0, create_failed=0) at /data/src/5.5-bug/storage/xtradb/row/row0mysql.c:3648 #9 0x0000000000a89f4d in ha_innobase::delete_table (this=0x7f7296456078, name=0x7f72b8663b10 "./test/tmp542") at /data/src/5.5-bug/storage/xtradb/handler/ha_innodb.cc:8790 #10 0x00000000007b4efa in handler::ha_delete_table (this=0x7f7296456078, name=0x7f72b8663b10 "./test/tmp542") at /data/src/5.5-bug/sql/handler.cc:3723 #11 0x00000000007b2071 in ha_delete_table (thd=0x7f729e3bc060, table_type=0x7f72b7ca5560, path=0x7f72b8663b10 "./test/tmp542", db=0x7f7296427760 "test", alias=0x7f7296427158 "tmp542", generate_warning=true) at /data/src/5.5-bug/sql/handler.cc:2155 #12 0x0000000000695fc7 in mysql_rm_table_no_locks (thd=0x7f729e3bc060, tables=0x7f7296427190, if_exists=true, drop_temporary=false, drop_view=false, dont_log_query=false) at /data/src/5.5-bug/sql/sql_table.cc:2313 #13 0x0000000000695415 in mysql_rm_table (thd=0x7f729e3bc060, tables=0x7f7296427190, if_exists=1 '\001', drop_temporary=0 '\000') at /data/src/5.5-bug/sql/sql_table.cc:1953 #14 0x0000000000602263 in mysql_execute_command (thd=0x7f729e3bc060) at /data/src/5.5-bug/sql/sql_parse.cc:3176 #15 0x000000000060958a in mysql_parse (thd=0x7f729e3bc060, rawbuf=0x7f7296427078 "DROP TABLE IF EXISTS tmp542 /* QNO 37250 CON_ID 13 */", length=53, parser_state=0x7f72b8664690) at /data/src/5.5-bug/sql/sql_parse.cc:5930 #16 0x00000000005fd28d in dispatch_command (command=COM_QUERY, thd=0x7f729e3bc060, packet=0x7f729e3c1061 " DROP TABLE IF EXISTS tmp542 /* QNO 37250 CON_ID 13 */ ", packet_length=55) at /data/src/5.5-bug/sql/sql_parse.cc:1075 #17 0x00000000005fc499 in do_command (thd=0x7f729e3bc060) at /data/src/5.5-bug/sql/sql_parse.cc:793 #18 0x00000000006ff17f in do_handle_one_connection (thd_arg=0x7f729e3bc060) at /data/src/5.5-bug/sql/sql_connect.cc:1268 #19 0x00000000006fef0c in handle_one_connection (arg=0x7f729e3bc060) at /data/src/5.5-bug/sql/sql_connect.cc:1184 #20 0x00007f72b9d38494 in start_thread (arg=0x7f72b8665700) at pthread_create.c:333 #21 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 24 (Thread 0x7f729f3f6700 (LWP 17861)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff150, segment=3, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=9, message1=0x7f729f3f5e90, message2=0x7f729f3f5e88, type=0x7f729f3f5e80, space_id=0x7f729f3f5e78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=9) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa048 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f729f3f6700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 23 (Thread 0x7f72ba150780 (LWP 17849)): #0 0x00007f72b87454ed in poll () from /lib/x86_64-linux-gnu/libc.so.6 #1 0x0000000000559478 in handle_connections_sockets () at /data/src/5.5-bug/sql/mysqld.cc:5574 #2 0x0000000000558855 in mysqld_main (argc=43, argv=0x7f72b7c5f3b0) at /data/src/5.5-bug/sql/mysqld.cc:5023 #3 0x0000000000550ae6 in main (argc=43, argv=0x7ffff2cb7208) at /data/src/5.5-bug/sql/main.cc:25 Thread 22 (Thread 0x7f72ba09f700 (LWP 17888)): #0 0x00007f72b9d4120d in read () at ../sysdeps/unix/syscall-template.S:84 #1 0x0000000000cebab3 in vio_read (vio=0x7f72b7c66660, buf=0x7f729e366060 "\001", size=4) at /data/src/5.5-bug/vio/viosocket.c:72 #2 0x000000000055f6bf in my_real_read (net=0x7f729e2ae370, complen=0x7f72ba09ed80) at /data/src/5.5-bug/sql/net_serv.cc:840 #3 0x000000000055fd22 in my_net_read (net=0x7f729e2ae370) at /data/src/5.5-bug/sql/net_serv.cc:1026 #4 0x00000000005fc2cc in do_command (thd=0x7f729e2ae060) at /data/src/5.5-bug/sql/sql_parse.cc:739 #5 0x00000000006ff17f in do_handle_one_connection (thd_arg=0x7f729e2ae060) at /data/src/5.5-bug/sql/sql_connect.cc:1268 #6 0x00000000006fef0c in handle_one_connection (arg=0x7f729e2ae060) at /data/src/5.5-bug/sql/sql_connect.cc:1184 #7 0x00007f72b9d38494 in start_thread (arg=0x7f72ba09f700) at pthread_create.c:333 #8 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 21 (Thread 0x7f72ba0e8700 (LWP 17871)): #0 0x00007f72b9d4120d in read () at ../sysdeps/unix/syscall-template.S:84 #1 0x0000000000cebab3 in vio_read (vio=0x7f72b7c663e0, buf=0x7f729e387060 "\a", size=4) at /data/src/5.5-bug/vio/viosocket.c:72 #2 0x000000000055f6bf in my_real_read (net=0x7f729e275370, complen=0x7f72ba0e7d80) at /data/src/5.5-bug/sql/net_serv.cc:840 #3 0x000000000055fd22 in my_net_read (net=0x7f729e275370) at /data/src/5.5-bug/sql/net_serv.cc:1026 #4 0x00000000005fc2cc in do_command (thd=0x7f729e275060) at /data/src/5.5-bug/sql/sql_parse.cc:739 #5 0x00000000006ff17f in do_handle_one_connection (thd_arg=0x7f729e275060) at /data/src/5.5-bug/sql/sql_connect.cc:1268 #6 0x00000000006fef0c in handle_one_connection (arg=0x7f729e275060) at /data/src/5.5-bug/sql/sql_connect.cc:1184 #7 0x00007f72b9d38494 in start_thread (arg=0x7f72ba0e8700) at pthread_create.c:333 #8 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 20 (Thread 0x7f729c3fe700 (LWP 17865)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000000000cadf32 in safe_cond_timedwait (cond=0x7f72b7cbacb0, mp=0x7f72b7cbac00, abstime=0x7f729c3fde40, file=0xe56f60 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=171) at /data/src/5.5-bug/mysys/thr_mutex.c:547 #2 0x0000000000c0c8ea in os_cond_wait_timed (cond=0x7f72b7cbacb0, mutex=0x7f72b7cbac00, abstime=0x7f729c3fde40) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:171 #3 0x0000000000c0d331 in os_event_wait_time_low (event=0x7f72b7cbac00, time_in_usec=5000000, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:716 #4 0x0000000000ae26ca in srv_monitor_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:2681 #5 0x00007f72b9d38494 in start_thread (arg=0x7f729c3fe700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 19 (Thread 0x7f729a3ff700 (LWP 17867)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000000000cadf32 in safe_cond_timedwait (cond=0x7f72b7cbaeb0, mp=0x7f72b7cbae00, abstime=0x7f729a3fe6e0, file=0xe56f60 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=171) at /data/src/5.5-bug/mysys/thr_mutex.c:547 #2 0x0000000000c0c8ea in os_cond_wait_timed (cond=0x7f72b7cbaeb0, mutex=0x7f72b7cbae00, abstime=0x7f729a3fe6e0) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:171 #3 0x0000000000c0d331 in os_event_wait_time_low (event=0x7f72b7cbae00, time_in_usec=1000000, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:716 #4 0x0000000000ae3a2c in srv_master_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:3530 #5 0x00007f72b9d38494 in start_thread (arg=0x7f729a3ff700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 18 (Thread 0x7f729dbff700 (LWP 17863)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000000000cadf32 in safe_cond_timedwait (cond=0x7f72b7cbabb0, mp=0x7f72b7cbab00, abstime=0x7f729dbfee40, file=0xe56f60 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=171) at /data/src/5.5-bug/mysys/thr_mutex.c:547 #2 0x0000000000c0c8ea in os_cond_wait_timed (cond=0x7f72b7cbabb0, mutex=0x7f72b7cbab00, abstime=0x7f729dbfee40) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:171 #3 0x0000000000c0d331 in os_event_wait_time_low (event=0x7f72b7cbab00, time_in_usec=1000000, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:716 #4 0x0000000000ae2aa6 in srv_lock_timeout_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:2831 #5 0x00007f72b9d38494 in start_thread (arg=0x7f729dbff700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 17 (Thread 0x7f72ba131700 (LWP 17869)): #0 do_sigwait (set=, set@entry=0x7f72ba130e30, sig=sig@entry=0x7f72ba130ec8) at ../sysdeps/unix/sysv/linux/sigwait.c:64 #1 0x00007f72b9d41ced in __sigwait (set=0x7f72ba130e30, sig=0x7f72ba130ec8) at ../sysdeps/unix/sysv/linux/sigwait.c:96 #2 0x00000000005554df in signal_hand (arg=0x0) at /data/src/5.5-bug/sql/mysqld.cc:2995 #3 0x00007f72b9d38494 in start_thread (arg=0x7f72ba131700) at pthread_create.c:333 #4 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 16 (Thread 0x7f729cbff700 (LWP 17864)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000000000cadf32 in safe_cond_timedwait (cond=0x7f72b7cbaab0, mp=0x7f72b7cbaa00, abstime=0x7f729cbfee10, file=0xe56f60 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=171) at /data/src/5.5-bug/mysys/thr_mutex.c:547 #2 0x0000000000c0c8ea in os_cond_wait_timed (cond=0x7f72b7cbaab0, mutex=0x7f72b7cbaa00, abstime=0x7f729cbfee10) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:171 #3 0x0000000000c0d331 in os_event_wait_time_low (event=0x7f72b7cbaa00, time_in_usec=1000000, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:716 #4 0x0000000000ae3015 in srv_error_monitor_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:3045 #5 0x00007f72b9d38494 in start_thread (arg=0x7f729cbff700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 15 (Thread 0x7f729bbfd700 (LWP 17866)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000000000cadf32 in safe_cond_timedwait (cond=0x7f72b7cbaeb0, mp=0x7f72b7cbae00, abstime=0x7f729bbfce70, file=0xe56f60 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=171) at /data/src/5.5-bug/mysys/thr_mutex.c:547 #2 0x0000000000c0c8ea in os_cond_wait_timed (cond=0x7f72b7cbaeb0, mutex=0x7f72b7cbae00, abstime=0x7f729bbfce70) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:171 #3 0x0000000000c0d331 in os_event_wait_time_low (event=0x7f72b7cbae00, time_in_usec=5000000, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:716 #4 0x0000000000ae308a in srv_LRU_dump_restore_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:3091 #5 0x00007f72b9d38494 in start_thread (arg=0x7f729bbfd700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 14 (Thread 0x7f72ba00d700 (LWP 17892)): #0 my_hash_mask (hashnr=4137154198, buffmax=8, maxlength=5) at /data/src/5.5-bug/mysys/hash.c:190 #1 0x0000000000c7e2bd in my_hash_first_from_hash_value (hash=0x7f7297c1da60, hash_value=4137154198, key=0x7f7296d33910 "-\232", length=0, current_record=0x7f72ba00bafc) at /data/src/5.5-bug/mysys/hash.c:273 #2 0x0000000000c7e23a in my_hash_first (hash=0x7f7297c1da60, key=0x7f7296d33910 "-\232", length=0, current_record=0x7f72ba00bafc) at /data/src/5.5-bug/mysys/hash.c:251 #3 0x0000000000c7e157 in my_hash_search (hash=0x7f7297c1da60, key=0x7f7296d33910 "-\232", length=0) at /data/src/5.5-bug/mysys/hash.c:219 #4 0x0000000000cae501 in remove_from_locked_mutex (mp=0x7f7296d33a28, delete_mutex=0x7f7296d338a0) at /data/src/5.5-bug/mysys/thr_mutex.c:775 #5 0x0000000000c7f3e5 in my_hash_iterate (hash=0x7f729641ed78, action=0xcae46f , argument=0x7f7296d338a0) at /data/src/5.5-bug/mysys/hash.c:759 #6 0x0000000000cae25d in safe_mutex_free_deadlock_data (mp=0x7f7296d338a0) at /data/src/5.5-bug/mysys/thr_mutex.c:658 #7 0x0000000000cae183 in safe_mutex_destroy (mp=0x7f7296d338a0, file=0xded478 "/data/src/5.5-bug/storage/maria/ma_close.c", line=230) at /data/src/5.5-bug/mysys/thr_mutex.c:605 #8 0x00000000009c9450 in inline_mysql_mutex_destroy (that=0x7f7296d338a0, src_file=0xded478 "/data/src/5.5-bug/storage/maria/ma_close.c", src_line=230) at /data/src/5.5-bug/include/mysql/psi/mysql_thread.h:593 #9 0x00000000009ca110 in maria_close (info=0x7f7296c92060) at /data/src/5.5-bug/storage/maria/ma_close.c:230 #10 0x00000000009481d4 in ha_maria::close (this=0x7f7296dab878) at /data/src/5.5-bug/storage/maria/ha_maria.cc:1247 #11 0x00000000007b29f0 in handler::ha_close (this=0x7f7296dab878) at /data/src/5.5-bug/sql/handler.cc:2328 #12 0x000000000094c37d in ha_maria::drop_table (this=0x7f7296dab878, name=0x7f7296cf1fb8 "/data/logs/analyze3/tmp/#sql_45b9_1") at /data/src/5.5-bug/storage/maria/ha_maria.cc:2643 #13 0x00000000007b4f38 in handler::ha_drop_table (this=0x7f7296dab878, name=0x7f7296cf1fb8 "/data/logs/analyze3/tmp/#sql_45b9_1") at /data/src/5.5-bug/sql/handler.cc:3741 #14 0x00000000006577d7 in free_tmp_table (thd=0x7f729e377060, entry=0x7f7296cf1078) at /data/src/5.5-bug/sql/sql_select.cc:16524 #15 0x000000000059fbb8 in close_thread_tables (thd=0x7f729e377060) at /data/src/5.5-bug/sql/sql_base.cc:1519 #16 0x000000000060649c in mysql_execute_command (thd=0x7f729e377060) at /data/src/5.5-bug/sql/sql_parse.cc:4579 #17 0x000000000060958a in mysql_parse (thd=0x7f729e377060, rawbuf=0x7f7296c27078 "SELECT * FROM transforms.view_17891_merge /* TRANSFORM_OUTCOME_UNORDERED_MATCH */ /* QNO 17947 CON_ID 11 */", length=107, parser_state=0x7f72ba00c690) at /data/src/5.5-bug/sql/sql_parse.cc:5930 #18 0x00000000005fd28d in dispatch_command (command=COM_QUERY, thd=0x7f729e377060, packet=0x7f729e37c061 "", packet_length=108) at /data/src/5.5-bug/sql/sql_parse.cc:1075 #19 0x00000000005fc499 in do_command (thd=0x7f729e377060) at /data/src/5.5-bug/sql/sql_parse.cc:793 #20 0x00000000006ff17f in do_handle_one_connection (thd_arg=0x7f729e377060) at /data/src/5.5-bug/sql/sql_connect.cc:1268 #21 0x00000000006fef0c in handle_one_connection (arg=0x7f729e377060) at /data/src/5.5-bug/sql/sql_connect.cc:1184 #22 0x00007f72b9d38494 in start_thread (arg=0x7f72ba00d700) at pthread_create.c:333 #23 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 13 (Thread 0x7f72a0bf9700 (LWP 17858)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff150, segment=0, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=6, message1=0x7f72a0bf8e90, message2=0x7f72a0bf8e88, type=0x7f72a0bf8e80, space_id=0x7f72a0bf8e78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=6) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa030 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f72a0bf9700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 12 (Thread 0x7f72a03f8700 (LWP 17859)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff150, segment=1, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=7, message1=0x7f72a03f7e90, message2=0x7f72a03f7e88, type=0x7f72a03f7e80, space_id=0x7f72a03f7e78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=7) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa038 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f72a03f8700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 11 (Thread 0x7f7299bfe700 (LWP 17868)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000000000cadf32 in safe_cond_timedwait (cond=0x7f72b7cbaeb0, mp=0x7f72b7cbae00, abstime=0x7f7299bfde50, file=0xe56f60 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=171) at /data/src/5.5-bug/mysys/thr_mutex.c:547 #2 0x0000000000c0c8ea in os_cond_wait_timed (cond=0x7f72b7cbaeb0, mutex=0x7f72b7cbae00, abstime=0x7f7299bfde50) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:171 #3 0x0000000000c0d331 in os_event_wait_time_low (event=0x7f72b7cbae00, time_in_usec=798000, reset_sig_count=1) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:716 #4 0x0000000000ae5516 in srv_purge_thread (arg=0x0) at /data/src/5.5-bug/storage/xtradb/srv/srv0srv.c:4232 #5 0x00007f72b9d38494 in start_thread (arg=0x7f7299bfe700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 10 (Thread 0x7f72a33fe700 (LWP 17853)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff0b0, segment=0, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=1, message1=0x7f72a33fde90, message2=0x7f72a33fde88, type=0x7f72a33fde80, space_id=0x7f72a33fde78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=1) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa008 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f72a33fe700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 9 (Thread 0x7f72ba056700 (LWP 17890)): #0 pthread_cond_wait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:185 #1 0x0000000000cadc5f in safe_cond_wait (cond=0x7f72a4e99ab0, mp=0x7f72a4e99a00, file=0xe56f60 "/data/src/5.5-bug/storage/xtradb/os/os0sync.c", line=207) at /data/src/5.5-bug/mysys/thr_mutex.c:493 #2 0x0000000000c0c9e5 in os_cond_wait (cond=0x7f72a4e99ab0, mutex=0x7f72a4e99a00) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:207 #3 0x0000000000c0d173 in os_event_wait_low (event=0x7f72a4e99a00, reset_sig_count=3270) at /data/src/5.5-bug/storage/xtradb/os/os0sync.c:609 #4 0x0000000000aeb2bc in sync_array_wait_event (arr=0x7f72b7dfe2c0, index=0) at /data/src/5.5-bug/storage/xtradb/sync/sync0arr.c:459 #5 0x0000000000aed4f2 in rw_lock_x_lock_func (lock=0x1d086c0 , pass=0, file_name=0xe01010 "/data/src/5.5-bug/storage/xtradb/handler/ha_innodb.cc", line=8493) at /data/src/5.5-bug/storage/xtradb/sync/sync0rw.c:713 #6 0x0000000000ab1ef1 in pfs_rw_lock_x_lock_func (lock=0x1d086c0 , pass=0, file_name=0xe01010 "/data/src/5.5-bug/storage/xtradb/handler/ha_innodb.cc", line=8493) at /data/src/5.5-bug/storage/xtradb/include/sync0rw.ic:694 #7 0x0000000000ab8507 in row_mysql_lock_data_dictionary_func (trx=0x7f7297079e78, file=0xe01010 "/data/src/5.5-bug/storage/xtradb/handler/ha_innodb.cc", line=8493) at /data/src/5.5-bug/storage/xtradb/row/row0mysql.c:1849 #8 0x0000000000a89661 in ha_innobase::create (this=0x7f72971de078, name=0x7f72ba053a00 "./transforms/insert_select_17889", form=0x7f72ba052bc0, create_info=0x7f72ba054f40) at /data/src/5.5-bug/storage/xtradb/handler/ha_innodb.cc:8493 #9 0x00000000007b4f80 in handler::ha_create (this=0x7f72971de078, name=0x7f72ba053a00 "./transforms/insert_select_17889", form=0x7f72ba052bc0, info=0x7f72ba054f40) at /data/src/5.5-bug/sql/handler.cc:3755 #10 0x00000000007b5c78 in ha_create_table (thd=0x7f729e36d060, path=0x7f72ba053a00 "./transforms/insert_select_17889", db=0x7f7297027418 "transforms", table_name=0x7f7297027428 "insert_select_17889", create_info=0x7f72ba054f40, update_create_info=false) at /data/src/5.5-bug/sql/handler.cc:4084 #11 0x00000000006db83c in rea_create_table (thd=0x7f729e36d060, path=0x7f72ba053a00 "./transforms/insert_select_17889", db=0x7f7297027418 "transforms", table_name=0x7f7297027428 "insert_select_17889", create_info=0x7f72ba054f40, create_fields=..., keys=0, key_info=0x7f72971c6010, file=0x7f72970c4078) at /data/src/5.5-bug/sql/unireg.cc:503 #12 0x000000000069bf4d in mysql_create_table_no_lock (thd=0x7f729e36d060, db=0x7f7297027418 "transforms", table_name=0x7f7297027428 "insert_select_17889", create_info=0x7f72ba054f40, alter_info=0x7f72ba054ea0, internal_tmp_table=false, select_field_count=1, is_trans=0x0) at /data/src/5.5-bug/sql/sql_table.cc:4538 #13 0x00000000005eae09 in create_table_from_items (thd=0x7f729e36d060, create_info=0x7f72ba054f40, create_table=0x7f7297027480, alter_info=0x7f72ba054ea0, items=0x7f729e370b80, lock=0x7f72ba054b78, hooks=0x7f72ba054b50) at /data/src/5.5-bug/sql/sql_insert.cc:3940 #14 0x00000000005eb44e in select_create::prepare (this=0x7f72971c4dd8, values=..., u=0x7f729e370388) at /data/src/5.5-bug/sql/sql_insert.cc:4103 #15 0x000000000062f23a in JOIN::prepare (this=0x7f72971c4eb0, rref_pointer_array=0x7f729e370cf0, tables_init=0x7f7297027e48, wild_num=0, conds_init=0x0, og_num=2, order_init=0x7f7297028760, skip_order_by=false, group_init=0x0, having_init=0x7f7297028438, proc_param_init=0x0, select_lex_arg=0x7f729e370a68, unit_arg=0x7f729e370388) at /data/src/5.5-bug/sql/sql_select.cc:909 #16 0x0000000000636cc4 in mysql_select (thd=0x7f729e36d060, rref_pointer_array=0x7f729e370cf0, tables=0x7f7297027e48, wild_num=0, fields=..., conds=0x0, og_num=2, order=0x7f7297028760, group=0x0, having=0x7f7297028438, proc_param=0x0, select_options=2416216832, result=0x7f72971c4dd8, unit=0x7f729e370388, select_lex=0x7f729e370a68) at /data/src/5.5-bug/sql/sql_select.cc:3083 #17 0x000000000062d5a2 in handle_select (thd=0x7f729e36d060, lex=0x7f729e3702d8, result=0x7f72971c4dd8, setup_tables_done_option=0) at /data/src/5.5-bug/sql/sql_select.cc:319 #18 0x0000000000600b28 in mysql_execute_command (thd=0x7f729e36d060) at /data/src/5.5-bug/sql/sql_parse.cc:2621 #19 0x000000000060958a in mysql_parse (thd=0x7f729e36d060, rawbuf=0x7f7297027078 "CREATE TABLE transforms.insert_select_17889 SELECT AES_DECRYPT( `col_varchar_key`, `col_int_nokey` ) AS field1 FROM `AA` HAVING RAND() ORDER BY ISNULL( `col_datetime_key` ), ISNULL( ( @A := ( `col_va"..., length=403, parser_state=0x7f72ba055690) at /data/src/5.5-bug/sql/sql_parse.cc:5930 #20 0x00000000005fd28d in dispatch_command (command=COM_QUERY, thd=0x7f729e36d060, packet=0x7f729e372061 "CREATE TABLE transforms.insert_select_17889 SELECT AES_DECRYPT( `col_varchar_key`, `col_int_nokey` ) AS field1 FROM `AA` HAVING RAND() ORDER BY ISNULL( `col_datetime_key` ), ISNULL( ( @A := ( `col_va"..., packet_length=404) at /data/src/5.5-bug/sql/sql_parse.cc:1075 #21 0x00000000005fc499 in do_command (thd=0x7f729e36d060) at /data/src/5.5-bug/sql/sql_parse.cc:793 #22 0x00000000006ff17f in do_handle_one_connection (thd_arg=0x7f729e36d060) at /data/src/5.5-bug/sql/sql_connect.cc:1268 #23 0x00000000006fef0c in handle_one_connection (arg=0x7f729e36d060) at /data/src/5.5-bug/sql/sql_connect.cc:1184 #24 0x00007f72b9d38494 in start_thread (arg=0x7f72ba056700) at pthread_create.c:333 #25 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 8 (Thread 0x7f72a13fa700 (LWP 17857)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff100, segment=3, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=5, message1=0x7f72a13f9e90, message2=0x7f72a13f9e88, type=0x7f72a13f9e80, space_id=0x7f72a13f9e78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=5) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa028 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f72a13fa700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 7 (Thread 0x7f729fbf7700 (LWP 17860)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff150, segment=2, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=8, message1=0x7f729fbf6e90, message2=0x7f729fbf6e88, type=0x7f729fbf6e80, space_id=0x7f729fbf6e78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=8) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa040 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f729fbf7700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 6 (Thread 0x7f72a1bfb700 (LWP 17856)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff100, segment=2, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=4, message1=0x7f72a1bfae90, message2=0x7f72a1bfae88, type=0x7f72a1bfae80, space_id=0x7f72a1bfae78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=4) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa020 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f72a1bfb700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 5 (Thread 0x7f72a23fc700 (LWP 17855)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff100, segment=1, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=3, message1=0x7f72a23fbe90, message2=0x7f72a23fbe88, type=0x7f72a23fbe80, space_id=0x7f72a23fbe78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=3) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa018 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f72a23fc700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 4 (Thread 0x7f72b7bff700 (LWP 17851)): #0 pthread_cond_timedwait@@GLIBC_2.3.2 () at ../sysdeps/unix/sysv/linux/x86_64/pthread_cond_timedwait.S:225 #1 0x0000000000cadf32 in safe_cond_timedwait (cond=0x1cf5a00 , mp=0x1cf5940 , abstime=0x7f72b7bfee30, file=0xde6a70 "/data/src/5.5-bug/storage/maria/ma_servicethread.c", line=116) at /data/src/5.5-bug/mysys/thr_mutex.c:547 #2 0x0000000000983481 in inline_mysql_cond_timedwait (that=0x1cf5a00 , mutex=0x1cf5940 , abstime=0x7f72b7bfee30, src_file=0xde6a70 "/data/src/5.5-bug/storage/maria/ma_servicethread.c", src_line=116) at /data/src/5.5-bug/include/mysql/psi/mysql_thread.h:1017 #3 0x000000000098397a in my_service_thread_sleep (control=0x1391480 , sleep_time=30000000000) at /data/src/5.5-bug/storage/maria/ma_servicethread.c:115 #4 0x000000000097809c in ma_checkpoint_background (arg=0x1e) at /data/src/5.5-bug/storage/maria/ma_checkpoint.c:704 #5 0x00007f72b9d38494 in start_thread (arg=0x7f72b7bff700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 3 (Thread 0x7f72a2bfd700 (LWP 17854)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff100, segment=0, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=2, message1=0x7f72a2bfce90, message2=0x7f72a2bfce88, type=0x7f72a2bfce80, space_id=0x7f72a2bfce78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=2) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa010 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f72a2bfd700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 2 (Thread 0x7f72a3bff700 (LWP 17852)): #0 0x00007f72b9b2f6ea in ?? () from /lib/x86_64-linux-gnu/libaio.so.1 #1 0x0000000000c0a4f2 in os_aio_linux_collect (array=0x7f72ae7ff060, segment=0, seg_size=256) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4706 #2 0x0000000000c0a8e4 in os_aio_linux_handle (global_seg=0, message1=0x7f72a3bfee90, message2=0x7f72a3bfee88, type=0x7f72a3bfee80, space_id=0x7f72a3bfee78) at /data/src/5.5-bug/storage/xtradb/os/os0file.c:4852 #3 0x0000000000bad3f2 in fil_aio_wait (segment=0) at /data/src/5.5-bug/storage/xtradb/fil/fil0fil.c:5714 #4 0x0000000000ae6bac in io_handler_thread (arg=0x1cfa000 ) at /data/src/5.5-bug/storage/xtradb/srv/srv0start.c:497 #5 0x00007f72b9d38494 in start_thread (arg=0x7f72a3bff700) at pthread_create.c:333 #6 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6 Thread 1 (Thread 0x7f72b9fc4700 (LWP 17895)): #0 __pthread_kill (threadid=, signo=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:57 #1 0x0000000000ca6303 in my_write_core (sig=11) at /data/src/5.5-bug/mysys/stacktrace.c:457 #2 0x00000000007ad7b9 in handle_fatal_signal (sig=11) at /data/src/5.5-bug/sql/signal_handler.cc:262 #3 #4 0x000000000056408a in String::length (this=0x0) at /data/src/5.5-bug/sql/sql_string.h:114 #5 0x000000000068f673 in sortcmp (s=0x7f7296924f20, t=0x0, cs=0x1404d00 ) at /data/src/5.5-bug/sql/sql_string.cc:736 #6 0x00000000007dc5ae in Cached_item_str::cmp (this=0x7f7296924f00) at /data/src/5.5-bug/sql/item_buff.cc:94 #7 0x000000000066293a in test_if_group_changed (list=...) at /data/src/5.5-bug/sql/sql_select.cc:21341 #8 0x000000000065c7a3 in end_write_group (join=0x7f729695c4d0, join_tab=0x7f72969247d0, end_of_records=false) at /data/src/5.5-bug/sql/sql_select.cc:18592 #9 0x0000000000658ebd in evaluate_join_record (join=0x7f729695c4d0, join_tab=0x7f72969244b0, error=0) at /data/src/5.5-bug/sql/sql_select.cc:17276 #10 0x00000000006587ff in sub_select (join=0x7f729695c4d0, join_tab=0x7f72969244b0, end_of_records=false) at /data/src/5.5-bug/sql/sql_select.cc:17059 #11 0x000000000065806b in do_select (join=0x7f729695c4d0, fields=0x0, table=0x7f7296926078, procedure=0x0) at /data/src/5.5-bug/sql/sql_select.cc:16721 #12 0x0000000000634a89 in JOIN::exec (this=0x7f7296923328) at /data/src/5.5-bug/sql/sql_select.cc:2455 #13 0x0000000000636d7e in mysql_select (thd=0x7f729e381060, rref_pointer_array=0x7f7296916a98, tables=0x7f72969618a0, wild_num=0, fields=..., conds=0x7f7296961e90, og_num=1, order=0x0, group=0x7f7296962260, having=0x7f72969623e0, proc_param=0x0, select_options=3489925889, result=0x7f7296923290, unit=0x7f7296916130, select_lex=0x7f7296916810) at /data/src/5.5-bug/sql/sql_select.cc:3103 #14 0x000000000062d5a2 in handle_select (thd=0x7f729e381060, lex=0x7f7296916080, result=0x7f7296923290, setup_tables_done_option=1073741824) at /data/src/5.5-bug/sql/sql_select.cc:319 #15 0x0000000000601cca in mysql_execute_command (thd=0x7f729e381060) at /data/src/5.5-bug/sql/sql_parse.cc:3059 #16 0x0000000000620bef in Prepared_statement::execute (this=0x7f72968c1860, expanded_query=0x7f72b9fc2de0, open_cursor=false) at /data/src/5.5-bug/sql/sql_prepare.cc:3930 #17 0x000000000061fd03 in Prepared_statement::execute_loop (this=0x7f72968c1860, expanded_query=0x7f72b9fc2de0, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/5.5-bug/sql/sql_prepare.cc:3589 #18 0x000000000061de21 in mysql_sql_stmt_execute (thd=0x7f729e381060) at /data/src/5.5-bug/sql/sql_prepare.cc:2738 #19 0x00000000005ffd60 in mysql_execute_command (thd=0x7f729e381060) at /data/src/5.5-bug/sql/sql_parse.cc:2243 #20 0x000000000060958a in mysql_parse (thd=0x7f729e381060, rawbuf=0x7f729682725c "EXECUTE stmt; EXECUTE stmt; DEALLOCATE stmt; DROP TEMPORARY TABLE `ps` /* QNO 39107 CON_ID 12 */", length=96, parser_state=0x7f72b9fc3690) at /data/src/5.5-bug/sql/sql_parse.cc:5930 #21 0x00000000005fd4cb in dispatch_command (command=COM_QUERY, thd=0x7f729e381060, packet=0x7f729e3b7061 "", packet_length=581) at /data/src/5.5-bug/sql/sql_parse.cc:1134 #22 0x00000000005fc499 in do_command (thd=0x7f729e381060) at /data/src/5.5-bug/sql/sql_parse.cc:793 #23 0x00000000006ff17f in do_handle_one_connection (thd_arg=0x7f729e381060) at /data/src/5.5-bug/sql/sql_connect.cc:1268 #24 0x00000000006fef0c in handle_one_connection (arg=0x7f729e381060) at /data/src/5.5-bug/sql/sql_connect.cc:1184 #25 0x00007f72b9d38494 in start_thread (arg=0x7f72b9fc4700) at pthread_create.c:333 #26 0x00007f72b874e93f in clone () from /lib/x86_64-linux-gnu/libc.so.6