[root@imsdev2 mysql-test]# ./mtr rpl.rpl_typeconv Logging: ./mtr rpl.rpl_typeconv MySQL Version 5.5.8 Checking supported features... - skipping ndbcluster - skipping SSL, mysqld not compiled with SSL Collecting tests... - adding combinations for rpl vardir: /mysql/mysql-5.5.8/mysql-test/var Checking leftover processes... - found old pid 9065 in 'mysqld.2.pid', killing it... process did not exist! - found old pid 9050 in 'mysqld.1.pid', killing it... process did not exist! Removing old var directory... Creating var directory '/mysql/mysql-5.5.8/mysql-test/var'... Installing system database... Using server port 39960 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped rpl.rpl_typeconv 'mix' [ skipped ] Doesn't support --binlog-format='mixed' worker[1] Trying to dump core for [mysqltest - pid: 17707, winpid: 17707] worker[1] Trying to dump core for [mysqld.1 - pid: 17665, winpid: 17665] worker[1] Trying to dump core for [mysqld.2 - pid: 17669, winpid: 17669] rpl.rpl_typeconv 'row' [ fail ] timeout after 900 seconds Test ended at 2011-01-26 09:43:23 Test case timeout after 900 seconds == /mysql/mysql-5.5.8/mysql-test/var/log/rpl_typeconv.log == include/stop_slave.inc RESET SLAVE; RESET MASTER; include/start_slave.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_NON_LOSSY' **** **** Resetting master and slave **** include/stop_slave.inc RESET SLAVE; RESET MASTER; include/start_slave.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY' **** **** Resetting master and slave **** include/stop_slave.inc RESET SLAVE; RESET MASTER; include/start_slave.inc SET GLOBAL SLAVE_TYPE_CONVERSIONS='ALL_LOSSY,ALL_NON_LOSSY'; **** Running tests with @@SLAVE_TYPE_CONVERSIONS = 'ALL_LOSSY,ALL_NON_LOSSY' **** == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.2.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.2.sock' (111) == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.1.sock' (111) - saving '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_typeconv-row/' to '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_typeconv-row/' - found 'core.17666' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 17992] [New Thread 17711] [New Thread 17690] [New Thread 17683] [New Thread 17682] [New Thread 17681] [New Thread 17680] [New Thread 17678] [New Thread 17677] [New Thread 17676] [New Thread 17675] [New Thread 17674] [New Thread 17673] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.1 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0xab858a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Thread 14 (Thread 17673): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0xb0087b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0xb0087b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x40b610f8, message2=0x40b610f0, type=0x40b610e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 13 (Thread 17674): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0xb008830, reset_sig_count=3) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0xb008830, reset_sig_count=3) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x415620f8, message2=0x415620f0, type=0x415620e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 17675): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0xb0088b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0xb0088b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x41f630f8, message2=0x41f630f0, type=0x41f630e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 17676): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0xb008930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0xb008930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x429640f8, message2=0x429640f0, type=0x429640e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 17677): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0xb0089b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0xb0089b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x433650f8, message2=0x433650f0, type=0x433650e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 17678): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0xb008a30, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0xb008a30, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x43d660f8, message2=0x43d660f0, type=0x43d660e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 17680): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0xae86a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0xae86a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 17681): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0xae869a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0xae869a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 17682): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0xae86aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0xae86aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 17683): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0xac00eb0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0xac00eb0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x00000000007c087a in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:3031 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 17690): #0 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #3 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 17711): #0 0x0000003c1680d91b in read () from /lib64/libpthread.so.0 #1 0x00000000004f4edb in my_real_read (net=0xb092eb8, complen=0x46fed050) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:841 #2 0x00000000004f5223 in my_net_read (net=0x23) at /root/downloads/mysql-5.5.8/sql/net_serv.cc:1038 #3 0x000000000055e7c5 in do_command (thd=0xb092cd0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:718 #4 0x00000000005e8034 in do_handle_one_connection (thd_arg=0xb092cd0) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #5 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 17992): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006d2f06 in inline_mysql_cond_timedwait (this=, thd=, timeout=0x470efe80) at /root/downloads/mysql-5.5.8/include/mysql/psi/mysql_thread.h:1009 #2 MYSQL_BIN_LOG::wait_for_update_bin_log (this=, thd=, timeout=0x470efe80) at /root/downloads/mysql-5.5.8/sql/log.cc:5309 #3 0x000000000056fe86 in mysql_binlog_send (thd=0xb171320, log_ident=0x2aaaab4c1e30 "\001", pos=4, flags=0) at /root/downloads/mysql-5.5.8/sql/sql_repl.cc:844 #4 0x000000000055dd4f in dispatch_command (command=COM_BINLOG_DUMP, thd=0xb171320, packet=0xb18a0e1 "", packet_length=) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1209 #5 0x000000000055e812 in do_command (thd=0xb171320) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #6 0x00000000005e8034 in do_handle_one_connection (thd_arg=0xb171320) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #7 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #8 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #9 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #10 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 17666): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0xab858a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () - found 'core.17670' (1/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 18017] [New Thread 17990] [New Thread 17696] [New Thread 17695] [New Thread 17694] [New Thread 17693] [New Thread 17692] [New Thread 17689] [New Thread 17688] [New Thread 17687] [New Thread 17686] [New Thread 17685] [New Thread 17684] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.2 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=58, argv=0x193c79a8) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Thread 14 (Thread 17684): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1984a810, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1984a810, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x40d1c0f8, message2=0x40d1c0f0, type=0x40d1c0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 13 (Thread 17685): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1984a890, reset_sig_count=3) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1984a890, reset_sig_count=3) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x421c50f8, message2=0x421c50f0, type=0x421c50e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 17686): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1984a910, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1984a910, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x42bc60f8, message2=0x42bc60f0, type=0x42bc60e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 17687): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1984a990, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1984a990, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x435c70f8, message2=0x435c70f0, type=0x435c70e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 17688): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1984aa10, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1984aa10, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x43fc80f8, message2=0x43fc80f0, type=0x43fc80e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 17689): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x1984aa90, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x1984aa90, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x449c90f8, message2=0x449c90f0, type=0x449c90e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 17692): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x196c8a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x196c8a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 17693): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x196c89a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x196c89a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 17694): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x196c8aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x196c8aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 17695): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x19442eb0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x19442eb0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x00000000007c087a in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:3031 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 17696): #0 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #3 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 17990): #0 0x0000003c1609a3f1 in nanosleep () from /lib64/libc.so.6 #1 0x0000003c1609a214 in sleep () from /lib64/libc.so.6 #2 0x00000000004ff965 in safe_sleep (thd=0x199c7100, sec=, thread_killed=0x4ff460 , thread_killed_arg=0x19920160) at /root/downloads/mysql-5.5.8/sql/slave.cc:2091 #3 0x0000000000508dd6 in connect_to_master (thd=0x199c7100, mysql=0x198d91b0, mi=0x19920160, reconnect=true, suppress_warnings=false) at /root/downloads/mysql-5.5.8/sql/slave.cc:4238 #4 0x0000000000509260 in safe_reconnect (thd=0x199c7100, mysql=0x198d91b0, mi=0x19920160, retry_count=0x4688f0c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:4281 #5 try_to_reconnect (thd=0x199c7100, mysql=0x198d91b0, mi=0x19920160, retry_count=0x4688f0c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:2682 #6 0x000000000050a56d in handle_slave_io (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:2937 #7 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #8 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #9 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 18017): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006d729d in inline_mysql_cond_wait (this=, thd=0x199d1210) at /root/downloads/mysql-5.5.8/include/mysql/psi/mysql_thread.h:980 #2 MYSQL_BIN_LOG::wait_for_update_relay_log (this=, thd=0x199d1210) at /root/downloads/mysql-5.5.8/sql/log.cc:5279 #3 0x0000000000503bbd in next_event (thd=0x199d1210, rli=0x19921488) at /root/downloads/mysql-5.5.8/sql/slave.cc:4664 #4 exec_relay_log_event (thd=0x199d1210, rli=0x19921488) at /root/downloads/mysql-5.5.8/sql/slave.cc:2448 #5 0x00000000005054c1 in handle_slave_sql (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:3320 #6 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #7 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #8 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 17670): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=58, argv=0x193c79a8) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Only 2 of 3 completed. mysql-test-run: *** ERROR: Not all tests completed ======================================================================================================================================= [root@imsdev2 mysql-test]# ./mtr rpl.rpl_innodb_bug28430 Logging: ./mtr rpl.rpl_innodb_bug28430 MySQL Version 5.5.8 Checking supported features... - skipping ndbcluster - skipping SSL, mysqld not compiled with SSL Collecting tests... - adding combinations for rpl vardir: /mysql/mysql-5.5.8/mysql-test/var Checking leftover processes... Removing old var directory... Creating var directory '/mysql/mysql-5.5.8/mysql-test/var'... Installing system database... Using server port 49658 ============================================================================== TEST RESULT TIME (ms) ------------------------------------------------------------ worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 worker[1] mysql-test-run: WARNING: running this script as _root_ will cause some tests to be skipped worker[1] Trying to dump core for [mysqltest - pid: 18147, winpid: 18147] worker[1] Trying to dump core for [mysqld.1 - pid: 18104, winpid: 18104] worker[1] Trying to dump core for [mysqld.2 - pid: 18108, winpid: 18108] rpl.rpl_innodb_bug28430 'mix' [ fail ] timeout after 900 seconds Test ended at 2011-01-26 10:05:14 Test case timeout after 900 seconds == /mysql/mysql-5.5.8/mysql-test/var/log/rpl_innodb_bug28430.log == DECLARE cur_user VARCHAR(255); DECLARE local_uuid VARCHAR(255); DECLARE local_time TIMESTAMP; SET local_time= NOW(); SET cur_user = CURRENT_USER(); SET local_uuid=UUID(); WHILE ins_count > 0 DO INSERT INTO test.byrange_tbl VALUES (NULL, NOW(), USER(), UUID(), ins_count,'Going to test MBR for MySQL'); SET ins_count = ins_count - 1; END WHILE; SELECT MAX(id) FROM test.byrange_tbl INTO del_count; WHILE del_count > 0 DO DELETE FROM test.byrange_tbl WHERE id = del_count; SET del_count = del_count - 2; END WHILE; END| CALL test.proc_norm(); SELECT count(*) as "Master regular" FROM test.regular_tbl; Master regular 500 == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.1.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.1.sock' (111) == /mysql/mysql-5.5.8/mysql-test/var/tmp/analyze-timeout-mysqld.2.err == mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/mysql/mysql-5.5.8/mysql-test/var/tmp/mysqld.2.sock' (111) - saving '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-mix/' to '/mysql/mysql-5.5.8/mysql-test/var/log/rpl.rpl_innodb_bug28430-mix/' - found 'core.18105' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 18158] [New Thread 18152] [New Thread 18135] [New Thread 18128] [New Thread 18127] [New Thread 18126] [New Thread 18125] [New Thread 18117] [New Thread 18116] [New Thread 18115] [New Thread 18114] [New Thread 18113] [New Thread 18112] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.1 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x197388a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Thread 14 (Thread 18112): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x19bbb7b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x19bbb7b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x422bb0f8, message2=0x422bb0f0, type=0x422bb0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 13 (Thread 18113): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x19bbb830, reset_sig_count=61) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x19bbb830, reset_sig_count=61) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x414510f8, message2=0x414510f0, type=0x414510e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 18114): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x19bbb8b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x19bbb8b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x42cbc0f8, message2=0x42cbc0f0, type=0x42cbc0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 18115): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x19bbb930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x19bbb930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x436bd0f8, message2=0x436bd0f0, type=0x436bd0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 18116): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x19bbb9b0, reset_sig_count=161) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x19bbb9b0, reset_sig_count=161) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x440be0f8, message2=0x440be0f0, type=0x440be0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 18117): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x19bbba30, reset_sig_count=152) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x19bbba30, reset_sig_count=152) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x44abf0f8, message2=0x44abf0f0, type=0x44abf0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 18125): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x19a39a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x19a39a20, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 18126): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x19a399a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x19a399a0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 18127): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x19a39aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x19a39aa0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 18128): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x0000000000806a99 in buf_flush_buffered_writes () at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:830 #6 0x00000000008083b7 in buf_flush_batch (buf_pool=0x19bd0158, flush_type=431817608, min_n=200, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1711 #7 0x00000000008087c0 in buf_flush_list (min_n=200, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1929 #8 0x00000000007c0979 in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2798 #9 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #10 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 18135): #0 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #3 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 18152): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x19be3bf0, reset_sig_count=2) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x19be3bf0, reset_sig_count=2) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x00000000007c572a in sync_array_wait_event (arr=0x197a56f0, index=0) at /root/downloads/mysql-5.5.8/storage/innobase/sync/sync0arr.c:457 #4 0x00000000007c642f in rw_lock_x_lock_low (lock=0x2aaaacabd440, pass=, file_name=0x9c1c78 "/root/downloads/mysql-5.5.8/storage/innobase/include/trx0undo.ic", line=156) at /root/downloads/mysql-5.5.8/storage/innobase/sync/sync0rw.c:529 #5 rw_lock_x_lock_func (lock=0x2aaaacabd440, pass=, file_name=0x9c1c78 "/root/downloads/mysql-5.5.8/storage/innobase/include/trx0undo.ic", line=156) at /root/downloads/mysql-5.5.8/storage/innobase/sync/sync0rw.c:628 #6 0x00000000008009c1 in buf_page_get_gen (space=0, zip_size=0, offset=366, rw_latch=2, guess=, mode=10, file=0x9c1c78 "/root/downloads/mysql-5.5.8/storage/innobase/include/trx0undo.ic", line=156, mtr=0x41777690) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0buf.c:3105 #7 0x00000000007db4e7 in trx_undo_page_get (undo=0x19d28a18, mtr=0x41777690) at /root/downloads/mysql-5.5.8/storage/innobase/include/trx0undo.ic:155 #8 trx_undo_set_state_at_finish (undo=0x19d28a18, mtr=0x41777690) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0undo.c:1819 #9 0x00000000007d938b in trx_commit_off_kernel (trx=0x197a7198) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:756 #10 0x00000000007dabd8 in trx_commit_for_mysql (trx=0x197a7198) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1565 #11 0x000000000079b026 in innobase_commit (hton=, thd=0x19cde8c0, all=false) at /root/downloads/mysql-5.5.8/storage/innobase/handler/ha_innodb.cc:2727 #12 0x000000000064e622 in ha_commit_one_phase (thd=0x19cde8c0, all=false) at /root/downloads/mysql-5.5.8/sql/handler.cc:1299 #13 0x000000000064fd5f in ha_commit_trans (thd=0x19cde8c0, all=false) at /root/downloads/mysql-5.5.8/sql/handler.cc:1237 #14 0x00000000005f3c82 in trans_commit_stmt (thd=0x19cde8c0) at /root/downloads/mysql-5.5.8/sql/transaction.cc:272 #15 0x0000000000557bbd in mysql_execute_command (thd=0x19cde8c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:4355 #16 0x000000000070ecbc in sp_instr_stmt::exec_core (this=0x19dac630, thd=0x80, nextp=0x3) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:3162 #17 0x000000000070ee24 in sp_lex_keeper::reset_lex_and_exec_core (this=0x19dac670, thd=0x19cde8c0, nextp=0x417799d8, open_tables=false, instr=0x19dac630) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:2959 #18 0x0000000000714771 in sp_instr_stmt::execute (this=0x19dac630, thd=0x19cde8c0, nextp=0x417799d8) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:3094 #19 0x0000000000712f71 in sp_head::execute (this=0x19da3270, thd=0x19cde8c0, merge_da_on_success=true) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:1420 #20 0x0000000000713745 in sp_head::execute_procedure (this=0x19da3270, thd=0x19cde8c0, args=0x19ce0d98) at /root/downloads/mysql-5.5.8/sql/sp_head.cc:2176 #21 0x0000000000557fcc in mysql_execute_command (thd=0x19cde8c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:3914 #22 0x000000000055d4be in mysql_parse (thd=0x19cde8c0, rawbuf=0x19ce9670 "CALL test.proc_bykey()", length=, parser_state=0x4177bc70) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:5496 #23 0x000000000055e4ee in dispatch_command (command=COM_QUERY, thd=0x19cde8c0, packet=, packet_length=22) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1032 #24 0x000000000055e812 in do_command (thd=0x19cde8c0) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #25 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x19cde8c0) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #26 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #27 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #28 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #29 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 18158): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000006d2f06 in inline_mysql_cond_timedwait (this=, thd=, timeout=0x47d44e80) at /root/downloads/mysql-5.5.8/include/mysql/psi/mysql_thread.h:1009 #2 MYSQL_BIN_LOG::wait_for_update_bin_log (this=, thd=, timeout=0x47d44e80) at /root/downloads/mysql-5.5.8/sql/log.cc:5309 #3 0x000000000056fe86 in mysql_binlog_send (thd=0x19d1e370, log_ident=0x2aaaab47e948 "\001", pos=4, flags=0) at /root/downloads/mysql-5.5.8/sql/sql_repl.cc:844 #4 0x000000000055dd4f in dispatch_command (command=COM_BINLOG_DUMP, thd=0x19d1e370, packet=0x19d210f1 "", packet_length=) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:1209 #5 0x000000000055e812 in do_command (thd=0x19d1e370) at /root/downloads/mysql-5.5.8/sql/sql_parse.cc:772 #6 0x00000000005e8034 in do_handle_one_connection (thd_arg=0x19d1e370) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:745 #7 0x00000000005e811a in handle_one_connection (arg=) at /root/downloads/mysql-5.5.8/sql/sql_connect.cc:684 #8 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #9 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #10 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 18105): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=48, argv=0x197388a0) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () - found 'core.18109' (1/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql/mysql-5.5.8/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New Thread 18159] [New Thread 18157] [New Thread 18136] [New Thread 18134] [New Thread 18133] [New Thread 18132] [New Thread 18131] [New Thread 18123] [New Thread 18122] [New Thread 18121] [New Thread 18120] [New Thread 18119] [New Thread 18118] Core was generated by `/mysql/mysql-5.5.8/bin/mysqld --defaults-group-suffix=.2 --defaults-file=/mysql'. Program terminated with signal 6, Aborted. #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=57, argv=0x91a8bd8) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Thread 14 (Thread 18118): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x962b830, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x962b830, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=0, message1=0x40cbd0f8, message2=0x40cbd0f0, type=0x40cbd0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=0) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 13 (Thread 18119): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x962b8b0, reset_sig_count=61) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x962b8b0, reset_sig_count=61) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=1, message1=0x416be0f8, message2=0x416be0f0, type=0x416be0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=1) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 12 (Thread 18120): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x962b930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x962b930, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=2, message1=0x420bf0f8, message2=0x420bf0f0, type=0x420bf0e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=2) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 11 (Thread 18121): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x962b9b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x962b9b0, reset_sig_count=1) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=3, message1=0x42ac00f8, message2=0x42ac00f0, type=0x42ac00e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=3) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 10 (Thread 18122): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x962ba30, reset_sig_count=160) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x962ba30, reset_sig_count=160) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=4, message1=0x434c10f8, message2=0x434c10f0, type=0x434c10e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=4) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 9 (Thread 18123): #0 0x0000003c1680aee9 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000868027 in os_cond_wait (event=0x962bab0, reset_sig_count=152) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:207 #2 os_event_wait_low (event=0x962bab0, reset_sig_count=152) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:634 #3 0x0000000000866441 in os_aio_simulated_handle (global_segment=5, message1=0x43ec20f8, message2=0x43ec20f0, type=0x43ec20e8) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:4901 #4 0x000000000082a239 in fil_aio_wait (segment=5) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4510 #5 0x00000000007c27b8 in io_handler_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0start.c:483 #6 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #7 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 8 (Thread 18131): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x94a9a40, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x94a9a40, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1d10 in srv_lock_timeout_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2247 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 7 (Thread 18132): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x94a99c0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x94a99c0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007bfca5 in srv_error_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2420 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 6 (Thread 18133): #0 0x0000003c1680b150 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000867ee5 in os_cond_wait_timed (event=0x94a9ac0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:171 #2 os_event_wait_time_low (event=0x94a9ac0, time_in_usec=, reset_sig_count=) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0sync.c:743 #3 0x00000000007c1feb in srv_monitor_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2097 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 5 (Thread 18134): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=4) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x000000000082a131 in fil_flush_file_spaces (purpose=501) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4704 #6 0x0000000000806b59 in buf_flush_buffered_writes () at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:890 #7 0x00000000008083b7 in buf_flush_batch (buf_pool=0x96401d8, flush_type=157549576, min_n=20, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1711 #8 0x00000000008087c0 in buf_flush_list (min_n=20, lsn_limit=18446744073709551615) at /root/downloads/mysql-5.5.8/storage/innobase/buf/buf0flu.c:1929 #9 0x00000000007c0a45 in srv_master_thread (arg=) at /root/downloads/mysql-5.5.8/storage/innobase/srv/srv0srv.c:2841 #10 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #11 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 4 (Thread 18136): #0 0x0000003c1680e838 in do_sigwait () from /lib64/libpthread.so.0 #1 0x0000003c1680e8dd in sigwait () from /lib64/libpthread.so.0 #2 0x00000000004ee6cb in signal_hand (arg=) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2701 #3 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #4 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #5 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 3 (Thread 18157): #0 0x0000003c1609a3f1 in nanosleep () from /lib64/libc.so.6 #1 0x0000003c1609a214 in sleep () from /lib64/libc.so.6 #2 0x00000000004ff965 in safe_sleep (thd=0x978e3b0, sec=, thread_killed=0x4ff460 , thread_killed_arg=0x9701020) at /root/downloads/mysql-5.5.8/sql/slave.cc:2091 #3 0x0000000000508dd6 in connect_to_master (thd=0x978e3b0, mysql=0x9743f50, mi=0x9701020, reconnect=true, suppress_warnings=false) at /root/downloads/mysql-5.5.8/sql/slave.cc:4238 #4 0x0000000000509260 in safe_reconnect (thd=0x978e3b0, mysql=0x9743f50, mi=0x9701020, retry_count=0x471cb0c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:4281 #5 try_to_reconnect (thd=0x978e3b0, mysql=0x9743f50, mi=0x9701020, retry_count=0x471cb0c8, suppress_warnings=false, messages=0xe6c920) at /root/downloads/mysql-5.5.8/sql/slave.cc:2682 #6 0x000000000050a56d in handle_slave_io (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:2937 #7 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #8 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #9 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 2 (Thread 18159): #0 0x0000003c1680e047 in fsync () from /lib64/libpthread.so.0 #1 0x0000000000865684 in os_file_fsync (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2033 #2 os_file_flush_func (file=9) at /root/downloads/mysql-5.5.8/storage/innobase/os/os0file.c:2131 #3 0x0000000000829d0c in pfs_os_file_flush_func (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/include/os0file.ic:381 #4 fil_flush (space_id=) at /root/downloads/mysql-5.5.8/storage/innobase/fil/fil0fil.c:4621 #5 0x00000000008587d7 in log_write_up_to (lsn=, wait=92, flush_to_disk=1) at /root/downloads/mysql-5.5.8/storage/innobase/log/log0log.c:1514 #6 0x00000000007da9bc in trx_prepare_off_kernel (trx=0x97a19c8) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1889 #7 0x00000000007daa88 in trx_prepare_for_mysql (trx=0x97a19c8) at /root/downloads/mysql-5.5.8/storage/innobase/trx/trx0trx.c:1925 #8 0x000000000079b972 in innobase_xa_prepare (hton=, thd=0x9761ee0, all=true) at /root/downloads/mysql-5.5.8/storage/innobase/handler/ha_innodb.cc:10082 #9 0x000000000064ff34 in ha_commit_trans (thd=0x9761ee0, all=) at /root/downloads/mysql-5.5.8/sql/handler.cc:1220 #10 0x00000000005f3b64 in trans_commit (thd=0x9761ee0) at /root/downloads/mysql-5.5.8/sql/transaction.cc:154 #11 0x00000000006e2860 in Xid_log_event::do_apply_event (this=0x2aaab0001520, rli=) at /root/downloads/mysql-5.5.8/sql/log_event.cc:5565 #12 0x00000000005014cd in apply_event (ev=0x2aaab0001520, thd=, rli=0x9702348) at /root/downloads/mysql-5.5.8/sql/log_event.h:1131 #13 apply_event_and_update_pos (ev=0x2aaab0001520, thd=, rli=0x9702348) at /root/downloads/mysql-5.5.8/sql/slave.cc:2342 #14 0x0000000000503df9 in exec_relay_log_event (thd=0x9761ee0, rli=0x9702348) at /root/downloads/mysql-5.5.8/sql/slave.cc:2502 #15 0x00000000005054c1 in handle_slave_sql (arg=) at /root/downloads/mysql-5.5.8/sql/slave.cc:3320 #16 0x00000000007919e7 in pfs_spawn_thread (arg=) at /root/downloads/mysql-5.5.8/storage/perfschema/pfs.cc:1015 #17 0x0000003c1680673d in start_thread () from /lib64/libpthread.so.0 #18 0x0000003c160d3f6d in clone () from /lib64/libc.so.6 Thread 1 (Thread 18109): #0 0x0000003c1680bd02 in pthread_kill () from /lib64/libpthread.so.0 #1 0x00000000004ec562 in handle_segfault (sig=6) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:2508 #2 #3 0x0000003c160cb186 in poll () from /lib64/libc.so.6 #4 0x00000000004ef304 in handle_connections_sockets () at /root/downloads/mysql-5.5.8/sql/mysqld.cc:5096 #5 0x00000000004f2f31 in mysqld_main (argc=57, argv=0x91a8bd8) at /root/downloads/mysql-5.5.8/sql/mysqld.cc:4566 #6 0x0000003c1601d994 in __libc_start_main () from /lib64/libc.so.6 #7 0x00000000004eacc9 in _start () Only 1 of 3 completed. mysql-test-run: *** ERROR: Not all tests completed [root@imsdev2 mysql-test]#