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 7503): #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 7508): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x1575ddf0, reset_sig_count=1) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=0, message1=0x41b07108, message2=0x41b07100, type=0x41b070f8) 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 7509): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x1575de80, reset_sig_count=43) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=1, message1=0x42508108, message2=0x42508100, type=0x425080f8) 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 7510): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x1575df10, reset_sig_count=1) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=2, message1=0x42f09108, message2=0x42f09100, type=0x42f090f8) 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 7511): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x1575dfa0, reset_sig_count=1) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=3, message1=0x4390a108, message2=0x4390a100, type=0x4390a0f8) 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 7512): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x1575e030, reset_sig_count=290) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=4, message1=0x4430b108, message2=0x4430b100, type=0x4430b0f8) 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 7513): #0 0x00000033a8c0a496 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000007a786d in os_event_wait_low (event=0x1575e0c0, reset_sig_count=248) at os/os0sync.c:399 #2 0x00000000007a5403 in os_aio_simulated_handle (global_segment=5, message1=0x44d0c108, message2=0x44d0c100, type=0x44d0c0f8) 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 7520): #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 7521): #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 7524): #0 0x00000033a80cb0a2 in select () from /lib64/libc.so.6 #1 0x00000000007a83ab in os_thread_sleep (tm=) at os/os0thread.c:295 #2 0x00000000007e2e7a in srv_master_thread (arg=) at srv/srv0srv.c:2374 #3 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #4 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 7 (process 7526): #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 10324): #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=0x2aaaac042a68 "master-bin.000001", log_file_pos=41333092) 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 0x00000000006735e2 in MYSQL_BIN_LOG::write (this=0xd08cc0, thd=0x2aaaac03fc10, cache=0x158f8d60, commit_event=0x40ea0e50, incident=false) at log.cc:4836 #6 0x000000000067376b in binlog_end_trans (thd=0x2aaaac03fc10, trx_data=0x158f8d60, end_ev=0x40ea0e50, all=) at log.cc:1452 #7 0x0000000000673e44 in MYSQL_BIN_LOG::log_xid (this=, thd=0x2aaaac03fc10, xid=325939) at log.cc:5910 #8 0x00000000006c85a9 in ha_commit_trans (thd=0x2aaaac03fc10, all=false) at handler.cc:1208 #9 0x00000000006c8628 in ha_autocommit_or_rollback (thd=0x2aaaac03fc10, error=0) at handler.cc:1394 #10 0x0000000000615508 in close_thread_tables (thd=0x2aaaac03fc10) at sql_base.cc:1296 #11 0x0000000000736216 in sp_lex_keeper::reset_lex_and_exec_core (this=0x1591daf0, thd=0x2aaaac03fc10, nextp=0x40ea1288, open_tables=, instr=0x1591dab0) at sp_head.cc:2789 #12 0x0000000000736f74 in sp_instr_stmt::execute (this=0x1591dab0, thd=0x2aaaac03fc10, nextp=0x40ea1288) at sp_head.cc:2896 #13 0x000000000073452b in sp_head::execute (this=0x158ec0c0, thd=0x2aaaac03fc10) at sp_head.cc:1264 #14 0x00000000007359dc in sp_head::execute_procedure (this=0x158ec0c0, thd=0x2aaaac03fc10, args=0x2aaaac041cc0) at sp_head.cc:2006 #15 0x00000000005df69f in mysql_execute_command (thd=0x2aaaac03fc10) at sql_parse.cc:4532 #16 0x00000000005e2636 in mysql_parse (thd=0x2aaaac03fc10, inBuf=0x158df9e0 "CALL ins_tb2_eng1 (@tmp_num, @tmp_word)", length=39, found_semicolon=0x40ea3060) at sql_parse.cc:6211 #17 0x00000000005e364e in dispatch_command (command=COM_QUERY, thd=0x2aaaac03fc10, packet=0x2aaaac009471 "CALL ins_tb2_eng1 (@tmp_num, @tmp_word)", packet_length=) at sql_parse.cc:1240 #18 0x00000000005e3e73 in do_command (thd=0x2aaaac03fc10) at sql_parse.cc:873 #19 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #20 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #21 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 5 (process 10339): #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 0x000000000067287f in MYSQL_BIN_LOG::unlog (this=0xd08cc0, cookie=, xid=) at log.cc:4518 #4 0x00000000006c8566 in ha_commit_trans (thd=0x2aaaac003940, all=false) at handler.cc:1220 #5 0x00000000006c8628 in ha_autocommit_or_rollback (thd=0x2aaaac003940, error=0) at handler.cc:1394 #6 0x0000000000615508 in close_thread_tables (thd=0x2aaaac003940) at sql_base.cc:1296 #7 0x0000000000736216 in sp_lex_keeper::reset_lex_and_exec_core (this=0x2aaab4076340, thd=0x2aaaac003940, nextp=0x40e60288, open_tables=, instr=0x2aaab4076300) at sp_head.cc:2789 #8 0x0000000000736f74 in sp_instr_stmt::execute (this=0x2aaab4076300, thd=0x2aaaac003940, nextp=0x40e60288) at sp_head.cc:2896 #9 0x000000000073452b in sp_head::execute (this=0x2aaab4046460, thd=0x2aaaac003940) at sp_head.cc:1264 #10 0x00000000007359dc in sp_head::execute_procedure (this=0x2aaab4046460, thd=0x2aaaac003940, args=0x2aaaac0059f0) at sp_head.cc:2006 #11 0x00000000005df69f in mysql_execute_command (thd=0x2aaaac003940) at sql_parse.cc:4532 #12 0x00000000005e2636 in mysql_parse (thd=0x2aaaac003940, inBuf=0x15844c80 "CALL ins_tb2_eng1 (@tmp_num, @tmp_word)", length=39, found_semicolon=0x40e62060) at sql_parse.cc:6211 #13 0x00000000005e364e in dispatch_command (command=COM_QUERY, thd=0x2aaaac003940, packet=0x2aaaac013dc1 "CALL ins_tb2_eng1 (@tmp_num, @tmp_word)", packet_length=) at sql_parse.cc:1240 #14 0x00000000005e3e73 in do_command (thd=0x2aaaac003940) at sql_parse.cc:873 #15 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #16 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #17 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 4 (process 10342): #0 0x00000000007d2f5a in sel_set_rec_lock (block=0x2aaaaae29570, rec=0x2aaaab14d63b "\200", index=, offsets=, mode=, type=, thr=0x158c3be0) at row/row0sel.c:975 #1 0x00000000007d59be in row_search_for_mysql (buf=, mode=1, prebuilt=0x158b3af0, match_mode=0, direction=1) at row/row0sel.c:4041 #2 0x0000000000779309 in ha_innobase::general_fetch (this=0x1584af90, buf=0x1584b180 "áU\016", direction=1, match_mode=3) at handler/ha_innodb.cc:5316 #3 0x00000000006be99a in rr_sequential (info=0x40e1f230) at records.cc:390 #4 0x000000000066721c in mysql_delete (thd=0x2aaaac017dd0, table_list=0x1590e9c8, conds=0x15910680, order=, limit=18446744073709551615, options=0, reset_auto_increment=false) at sql_delete.cc:296 #5 0x00000000005e039c in mysql_execute_command (thd=0x2aaaac017dd0) at sql_parse.cc:3441 #6 0x00000000005e2636 in mysql_parse (thd=0x2aaaac017dd0, inBuf=0x1590e820 "DELETE FROM systest1.tb1_eng1\nWHERE (f1,f2,f3,f4) IN (SELECT f1,f2,f3,f4 FROM systest1.t1_tmp WHERE pk = 23)", length=108, found_semicolon=0x40e21060) at sql_parse.cc:6211 #7 0x00000000005e364e in dispatch_command (command=COM_QUERY, thd=0x2aaaac017dd0, packet=0x2aaaac01a701 "DELETE FROM systest1.tb1_eng1\nWHERE (f1,f2,f3,f4) IN (SELECT f1,f2,f3,f4 FROM systest1.t1_tmp WHERE pk = 23)", packet_length=) at sql_parse.cc:1240 #8 0x00000000005e3e73 in do_command (thd=0x2aaaac017dd0) 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 Current language: auto; currently c Thread 3 (process 10351): #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=0x40ee3310) at semisync_master.cc:484 #2 0x00002aaaab976e69 in ReplSemiSyncMaster::commitTrx (this=0x2aaaaba7a540, trx_wait_binlog_name=0x158f8948 "master-bin.000001", trx_wait_binlog_pos=41332626) 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=0x2aaaac00d480, error=0) at handler.cc:1410 #5 0x00000000005e27a3 in dispatch_command (command=, thd=0x2aaaac00d480, packet=0x158e40e0 "SELECT COUNT(*) = @no_of_tries FROM systest1.t1_tmp", packet_length=2885741096) at sql_parse.cc:1635 #6 0x00000000005e3e73 in do_command (thd=0x2aaaac00d480) 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 2 (process 10354): #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 0x000000000077c764 in innobase_xa_prepare (hton=, thd=0x2aaaac046a90, all=false) at handler/ha_innodb.cc:9189 #4 0x00000000006c82ec in ha_commit_trans (thd=0x2aaaac046a90, all=false) at handler.cc:1200 #5 0x00000000006c8628 in ha_autocommit_or_rollback (thd=0x2aaaac046a90, error=0) at handler.cc:1394 #6 0x0000000000615508 in close_thread_tables (thd=0x2aaaac046a90) at sql_base.cc:1296 #7 0x0000000000736216 in sp_lex_keeper::reset_lex_and_exec_core (this=0x158890c0, thd=0x2aaaac046a90, nextp=0x4618e288, open_tables=, instr=0x15889080) at sp_head.cc:2789 #8 0x0000000000736f74 in sp_instr_stmt::execute (this=0x15889080, thd=0x2aaaac046a90, nextp=0x4618e288) at sp_head.cc:2896 #9 0x000000000073452b in sp_head::execute (this=0x15878310, thd=0x2aaaac046a90) at sp_head.cc:1264 #10 0x00000000007359dc in sp_head::execute_procedure (this=0x15878310, thd=0x2aaaac046a90, args=0x2aaaac048b40) at sp_head.cc:2006 #11 0x00000000005df69f in mysql_execute_command (thd=0x2aaaac046a90) at sql_parse.cc:4532 #12 0x00000000005e2636 in mysql_parse (thd=0x2aaaac046a90, inBuf=0x158ae0c0 "CALL ins_tb2_eng1 (@tmp_num, @tmp_word)", length=39, found_semicolon=0x46190060) at sql_parse.cc:6211 #13 0x00000000005e364e in dispatch_command (command=COM_QUERY, thd=0x2aaaac046a90, packet=0x2aaaac0493c1 "CALL ins_tb2_eng1 (@tmp_num, @tmp_word)", packet_length=) at sql_parse.cc:1240 #14 0x00000000005e3e73 in do_command (thd=0x2aaaac046a90) at sql_parse.cc:873 #15 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #16 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #17 0x00000033a80d1b6d in clone () from /lib64/libc.so.6 Thread 1 (process 7541): #0 0x00000033a8c0b122 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000005cc065 in handle_segfault (sig=11) at mysqld.cc:2575 #2 #3 ActiveTranx::clear_active_tranx_nodes (this=0x1580a5a0, log_file_name=0x461cfab0 "master-bin.000001", log_file_pos=41332626) at semisync_master.h:64 #4 0x00002aaaab9775e8 in ReplSemiSyncMaster::reportReplyBinlog (this=0x2aaaaba7a540, server_id=, log_file_name=0x461cfab0 "master-bin.000001", log_file_pos=41332626) at semisync_master.cc:577 #5 0x00002aaaab977912 in ReplSemiSyncMaster::readSlaveReply (this=0x2aaaaba7a540, net=0x1583d280, server_id=2, event_buf=) at semisync_master.cc:1188 #6 0x00002aaaab977ee7 in repl_semi_after_send_event (param=0x461cfdb0, event_buf=0x2aaab0038140 "", len=) at semisync_master_plugin.cc:134 #7 0x0000000000759938 in Binlog_transmit_delegate::after_send_event (this=0xd10040, thd=, flags=, packet=0x1583d5e0) at rpl_handler.cc:373 #8 0x0000000000714fe5 in mysql_binlog_send (thd=0x1583d190, log_ident=, pos=, flags=0) at sql_repl.cc:730 #9 0x00000000005e2dae in dispatch_command (command=, thd=0x1583d190, packet=0x15840291 "\222¯v\002", packet_length=) at sql_parse.cc:1442 #10 0x00000000005e3e73 in do_command (thd=0x1583d190) at sql_parse.cc:873 #11 0x00000000005d616e in handle_one_connection (arg=) at sql_connect.cc:1154 #12 0x00000033a8c062f7 in start_thread () from /lib64/libpthread.so.0 #13 0x00000033a80d1b6d in clone () from /lib64/libc.so.6