Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/export/home/tmp/qauser/bin64_551-m2/bin/mysqld --defaults-group-suffix=.1 --de'. Program terminated with signal 11, Segmentation fault. #0 0x00000033a8c0b122 in pthread_kill () from /lib64/libpthread.so.0 Thread 17 (process 11003): #0 0x00000033a80cb0a2 in select () from /lib64/libc.so.6 #1 0x00000000005d03bd in handle_connections_sockets () at mysqld.cc:5077 #2 0x00000000005d0fe2 in main (argc=, argv=) at mysqld.cc:4564 Thread 16 (process 11008): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x16626df0, reset_sig_count=1) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=0, message1=0x422b9108, message2=0x422b9100, type=0x422b90f8) at os/os0file.c:4197 #3 0x00000000008422e7 in fil_aio_wait (segment=0) at fil/fil0fil.c:4450 #4 0x00000000007e5c1c in io_handler_thread (arg=) at srv/srv0start.c:492 #5 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #6 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 15 (process 11009): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x16626e80, reset_sig_count=17) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=1, message1=0x42cba108, message2=0x42cba100, type=0x42cba0f8) at os/os0file.c:4197 #3 0x00000000008422e7 in fil_aio_wait (segment=1) at fil/fil0fil.c:4450 #4 0x00000000007e5c1c in io_handler_thread (arg=) at srv/srv0start.c:492 #5 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #6 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 14 (process 11010): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x16626f10, reset_sig_count=1) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=2, message1=0x436bb108, message2=0x436bb100, type=0x436bb0f8) at os/os0file.c:4197 #3 0x00000000008422e7 in fil_aio_wait (segment=2) at fil/fil0fil.c:4450 #4 0x00000000007e5c1c in io_handler_thread (arg=) at srv/srv0start.c:492 #5 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #6 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 13 (process 11011): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x16626fa0, reset_sig_count=1) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=3, message1=0x440bc108, message2=0x440bc100, type=0x440bc0f8) at os/os0file.c:4197 #3 0x00000000008422e7 in fil_aio_wait (segment=3) at fil/fil0fil.c:4450 #4 0x00000000007e5c1c in io_handler_thread (arg=) at srv/srv0start.c:492 #5 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #6 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 12 (process 11012): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x16627030, reset_sig_count=47) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=4, message1=0x44abd108, message2=0x44abd100, type=0x44abd0f8) at os/os0file.c:4197 #3 0x00000000008422e7 in fil_aio_wait (segment=4) at fil/fil0fil.c:4450 #4 0x00000000007e5c1c in io_handler_thread (arg=) at srv/srv0start.c:492 #5 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #6 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 11 (process 11013): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x166270c0, reset_sig_count=51) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=5, message1=0x454be108, message2=0x454be100, type=0x454be0f8) at os/os0file.c:4197 #3 0x00000000008422e7 in fil_aio_wait (segment=5) at fil/fil0fil.c:4450 #4 0x00000000007e5c1c in io_handler_thread (arg=) at srv/srv0start.c:492 #5 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #6 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 10 (process 11022): #0 0x00000033a80cb0a2 in select () from /lib64/libc.so.6 #1 0x00000000007a83ab in os_thread_sleep (tm=) at os/os0thread.c:295 #2 0x00000000007e1acd in srv_lock_timeout_and_monitor_thread (arg=) at srv/srv0srv.c:1987 #3 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #4 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 9 (process 11023): #0 0x00000033a80cb0a2 in select () from /lib64/libc.so.6 #1 0x00000000007a83ab in os_thread_sleep (tm=) at os/os0thread.c:295 #2 0x00000000007e12b7 in srv_error_monitor_thread (arg=) at srv/srv0srv.c:2223 #3 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #4 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 8 (process 11026): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x16615ee0, reset_sig_count=62) at os/os0sync.c:399 #2 0x0000000000823bd0 in buf_flush_buffered_writes () at buf/buf0flu.c:320 #3 0x0000000000824313 in buf_flush_batch (flush_type=BUF_FLUSH_LIST, min_n=3, lsn_limit=18446744073709551615) at buf/buf0flu.c:1133 #4 0x00000000007e2af1 in srv_master_thread (arg=) at srv/srv0srv.c:2447 #5 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #6 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 7 (process 11027): #0 0x00000033a8c0dba8 in do_sigwait () from /lib64/libpthread.so.0 #1 0x00000033a8c0dc4d in sigwait () from /lib64/libpthread.so.0 #2 0x00000000005cbaeb in signal_hand (arg=) at mysqld.cc:2777 #3 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #4 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 6 (process 11617): #0 row_search_for_mysql (buf=0x167573c0 "á\r\020", mode=1, prebuilt=0x166af670, match_mode=0, direction=1) at ./include/mtr0mtr.ic:46 #1 0x0000000000779309 in ha_innobase::general_fetch (this=0x167571d0, buf=0x167573c0 "á\r\020", direction=1, match_mode=376742768) at handler/ha_innodb.cc:5316 #2 0x00000000006be99a in rr_sequential (info=0x4184c230) at records.cc:390 #3 0x000000000066721c in mysql_delete (thd=0x167c0d10, table_list=0x167ce7d8, conds=0x167d0490, order=, limit=18446744073709551614, options=0, reset_auto_increment=false) at sql_delete.cc:296 #4 0x00000000005e039c in mysql_execute_command (thd=0x167c0d10) at sql_parse.cc:3441 #5 0x00000000005e2636 in mysql_parse (thd=0x167c0d10, inBuf=0x167ce630 "DELETE FROM systest1.tb1_eng1\nWHERE (f1,f2,f3,f4) IN (SELECT f1,f2,f3,f4 FROM systest1.t1_tmp WHERE pk = 9)", length=107, found_semicolon=0x4184e060) at sql_parse.cc:6211 #6 0x00000000005e364e in dispatch_command (command=COM_QUERY, thd=0x167c0d10, packet=0x167a97b1 "DELETE FROM systest1.tb1_eng1\nWHERE (f1,f2,f3,f4) IN (SELECT f1,f2,f3,f4 FROM systest1.t1_tmp WHERE pk = 9)", packet_length=) at sql_parse.cc:1240 #7 0x00000000005e3e73 in do_command (thd=0x167c0d10) at sql_parse.cc:873 #8 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #9 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #10 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Current language: auto; currently c Thread 5 (process 11647): #0 0x00000033a8c0c888 in __lll_mutex_lock_wait () from /lib64/libpthread.so.0 #1 0x00000033a8c088a5 in _L_mutex_lock_107 () from /lib64/libpthread.so.0 #2 0x00000033a8c08333 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x0000000000672047 in MYSQL_BIN_LOG::write (this=0xd08cc0, event_info=0x46980e90) at log.cc:4281 #4 0x00000000005ba261 in THD::binlog_query (this=0x167b97e0, qtype=, query_arg=0x167d4a10 "INSERT INTO systest1.t1_tmp (f1, f2 ,f3, f4)\nSELECT f1, f2, f3, f4 FROM systest1.tb1_eng1 \nWHERE i1 = ( SELECT i1 FROM systest1.tb1_eng1 \nORDER BY i1 LIMIT 1 OFFSET 4032 )", query_len=171, is_trans=false, suppress_use=false, errcode=0) at sql_class.cc:3975 #5 0x000000000064be59 in select_insert::send_eof (this=0x167d6c90) at sql_insert.cc:3302 #6 0x000000000063113b in do_select (join=0x167d6d30, fields=0x167bb4b0, table=0x0, procedure=) at sql_select.cc:11139 #7 0x0000000000647f10 in JOIN::exec (this=0x167d6d30) at sql_select.cc:2280 #8 0x0000000000643e3a in mysql_select (thd=0x167b97e0, rref_pointer_array=, tables=, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x167d6c90, unit=0x167baf80, select_lex=0x167bb3a8) at sql_select.cc:2469 #9 0x00000000006499a4 in handle_select (thd=0x167b97e0, lex=0x167baee0, result=0x167d6c90, setup_tables_done_option=1073741824) at sql_select.cc:272 #10 0x00000000005e1c38 in mysql_execute_command (thd=0x167b97e0) at sql_parse.cc:3366 #11 0x00000000005e2636 in mysql_parse (thd=0x167b97e0, inBuf=0x167d4a10 "INSERT INTO systest1.t1_tmp (f1, f2 ,f3, f4)\nSELECT f1, f2, f3, f4 FROM systest1.tb1_eng1 \nWHERE i1 = ( SELECT i1 FROM systest1.tb1_eng1 \nORDER BY i1 LIMIT 1 OFFSET 4032 )", length=171, found_semicolon=0x46983060) at sql_parse.cc:6211 #12 0x00000000005e364e in dispatch_command (command=COM_QUERY, thd=0x167b97e0, packet=0x167bc111 "INSERT INTO systest1.t1_tmp (f1, f2 ,f3, f4)\nSELECT f1, f2, f3, f4 FROM systest1.tb1_eng1 \nWHERE i1 = ( SELECT i1 FROM systest1.tb1_eng1 \nORDER BY i1 LIMIT 1 OFFSET 4032 )", packet_length=) at sql_parse.cc:1240 #13 0x00000000005e3e73 in do_command (thd=0x167b97e0) at sql_parse.cc:873 #14 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #15 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #16 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 4 (process 11656): #0 0x00000033a8c0c888 in __lll_mutex_lock_wait () from /lib64/libpthread.so.0 #1 0x00000033a8c08911 in _L_mutex_lock_1133 () from /lib64/libpthread.so.0 #2 0x00000033a8c0886a in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00002aaaab9773e2 in ReplSemiSyncMaster::writeTranxInBinlog (this=0x2aaaaba7a540, log_file_name=0x167359a8 "master-bin.000001", log_file_pos=9561164) at semisync_master.cc:1036 #4 0x0000000000759d92 in Binlog_storage_delegate::after_flush (this=0xd100e0, thd=, log_file=, log_pos=, synced=) at rpl_handler.cc:270 #5 0x000000000067239b in MYSQL_BIN_LOG::write (this=0xd08cc0, event_info=0x4188ce90) at log.cc:4419 #6 0x00000000005ba261 in THD::binlog_query (this=0x1670dc70, qtype=, query_arg=0x1673cfb0 "INSERT INTO systest1.t1_tmp (f1, f2 ,f3, f4)\nSELECT f1, f2, f3, f4 FROM systest1.tb1_eng1 \nWHERE i1 = ( SELECT i1 FROM systest1.tb1_eng1 \nORDER BY i1 LIMIT 1 OFFSET 545 )", query_len=170, is_trans=false, suppress_use=false, errcode=0) at sql_class.cc:3975 #7 0x000000000064be59 in select_insert::send_eof (this=0x167288f0) at sql_insert.cc:3302 #8 0x000000000063113b in do_select (join=0x16728990, fields=0x1670f940, table=0x0, procedure=) at sql_select.cc:11139 #9 0x0000000000647f10 in JOIN::exec (this=0x16728990) at sql_select.cc:2280 #10 0x0000000000643e3a in mysql_select (thd=0x1670dc70, rref_pointer_array=, tables=, wild_num=0, fields=, conds=, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=0, result=0x167288f0, unit=0x1670f410, select_lex=0x1670f838) at sql_select.cc:2469 #11 0x00000000006499a4 in handle_select (thd=0x1670dc70, lex=0x1670f370, result=0x167288f0, setup_tables_done_option=1073741824) at sql_select.cc:272 #12 0x00000000005e1c38 in mysql_execute_command (thd=0x1670dc70) at sql_parse.cc:3366 #13 0x00000000005e2636 in mysql_parse (thd=0x1670dc70, inBuf=0x1673cfb0 "INSERT INTO systest1.t1_tmp (f1, f2 ,f3, f4)\nSELECT f1, f2, f3, f4 FROM systest1.tb1_eng1 \nWHERE i1 = ( SELECT i1 FROM systest1.tb1_eng1 \nORDER BY i1 LIMIT 1 OFFSET 545 )", length=170, found_semicolon=0x4188f060) at sql_parse.cc:6211 #14 0x00000000005e364e in dispatch_command (command=COM_QUERY, thd=0x1670dc70, packet=0x167ad7c1 "INSERT INTO systest1.t1_tmp (f1, f2 ,f3, f4)\nSELECT f1, f2, f3, f4 FROM systest1.tb1_eng1 \nWHERE i1 = ( SELECT i1 FROM systest1.tb1_eng1 \nORDER BY i1 LIMIT 1 OFFSET 545 )", packet_length=) at sql_parse.cc:1240 #15 0x00000000005e3e73 in do_command (thd=0x1670dc70) at sql_parse.cc:873 #16 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #17 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #18 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 3 (process 11659): #0 0x00000033a8c0c888 in __lll_mutex_lock_wait () from /lib64/libpthread.so.0 #1 0x00000033a8c08911 in _L_mutex_lock_1133 () from /lib64/libpthread.so.0 #2 0x00000033a8c0886a in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00002aaaab976d00 in ReplSemiSyncMaster::commitTrx (this=0x2aaaaba7a540, trx_wait_binlog_name=0x2aaab0056f78 "master-bin.000001", trx_wait_binlog_pos=9560634) at semisync_master.cc:632 #4 0x000000000075a95c in Trans_delegate::after_commit (this=0xd10180, thd=, all=) at rpl_handler.cc:203 #5 0x00000000006c84e9 in ha_commit_trans (thd=0x1674b1a0, all=false) at handler.cc:1222 #6 0x00000000006c8628 in ha_autocommit_or_rollback (thd=0x1674b1a0, error=0) at handler.cc:1394 #7 0x0000000000615508 in close_thread_tables (thd=0x1674b1a0) at sql_base.cc:1296 #8 0x0000000000736216 in sp_lex_keeper::reset_lex_and_exec_core (this=0x1678dc70, thd=0x1674b1a0, nextp=0x468ff288, open_tables=, instr=0x1678dc30) at sp_head.cc:2789 #9 0x0000000000736f74 in sp_instr_stmt::execute (this=0x1678dc30, thd=0x1674b1a0, nextp=0x468ff288) at sp_head.cc:2896 #10 0x000000000073452b in sp_head::execute (this=0x16779890, thd=0x1674b1a0) at sp_head.cc:1264 #11 0x00000000007359dc in sp_head::execute_procedure (this=0x16779890, thd=0x1674b1a0, args=0x1674d250) at sp_head.cc:2006 #12 0x00000000005df69f in mysql_execute_command (thd=0x1674b1a0) at sql_parse.cc:4532 #13 0x00000000005e2636 in mysql_parse (thd=0x1674b1a0, inBuf=0x16746fd0 "CALL ins_tb2_eng1 (@tmp_num, @tmp_word)", length=39, found_semicolon=0x46901060) at sql_parse.cc:6211 #14 0x00000000005e364e in dispatch_command (command=COM_QUERY, thd=0x1674b1a0, packet=0x167c36c1 "CALL ins_tb2_eng1 (@tmp_num, @tmp_word)", packet_length=) at sql_parse.cc:1240 #15 0x00000000005e3e73 in do_command (thd=0x1674b1a0) at sql_parse.cc:873 #16 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #17 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #18 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 2 (process 11665): #0 0x00000033a8c0a687 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00002aaaab97620d in ReplSemiSyncMaster::cond_timewait (this=0x2aaaaba7a540, wait_time=0x46941310) at semisync_master.cc:484 #2 0x00002aaaab976e69 in ReplSemiSyncMaster::commitTrx (this=0x2aaaaba7a540, trx_wait_binlog_name=0x1685c058 "master-bin.000001", trx_wait_binlog_pos=9560899) at semisync_master.cc:738 #3 0x000000000075a95c in Trans_delegate::after_commit (this=0xd10180, thd=, all=) at rpl_handler.cc:203 #4 0x00000000006c86a4 in ha_autocommit_or_rollback (thd=0x16750920, error=0) at handler.cc:1410 #5 0x00000000005e27a3 in dispatch_command (command=, thd=0x16750920, packet=0x16754740 "SELECT COUNT(*) = @no_of_tries FROM systest1.t1_tmp", packet_length=376774344) at sql_parse.cc:1635 #6 0x00000000005e3e73 in do_command (thd=0x16750920) at sql_parse.cc:873 #7 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #8 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #9 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 1 (process 11046): #0 0x00000033a8c0b122 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000005cc065 in handle_segfault (sig=11) at mysqld.cc:2575 #2 #3 ActiveTranx::is_tranx_end_pos (this=0x166d35a0, log_file_name=0x4180be52 "master-bin.000001", log_file_pos=9560899) at semisync_master.h:64 #4 0x00002aaaab976b3d in ReplSemiSyncMaster::updateSyncHeader (this=0x2aaaaba7a540, packet=0x2aaab0055b50 "", log_file_name=0x4180be52 "master-bin.000001", log_file_pos=9560899, server_id=2) at semisync_master.cc:992 #5 0x0000000000759ad4 in Binlog_transmit_delegate::before_send_event (this=0xd10040, thd=, flags=, packet=0x167065e0, log_file=0x4180be50 "./master-bin.000001", log_pos=9560899) at rpl_handler.cc:359 #6 0x0000000000714f93 in mysql_binlog_send (thd=0x16706190, log_ident=, pos=, flags=0) at sql_repl.cc:704 #7 0x00000000005e2dae in dispatch_command (command=, thd=0x16706190, packet=0x16709291 "", packet_length=) at sql_parse.cc:1442 #8 0x00000000005e3e73 in do_command (thd=0x16706190) at sql_parse.cc:873 #9 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #10 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #11 0x00000033a80d1b6d in clone () from /lib64/libc.so.6