Bug47183 - long semaphore wait terminates server (InnoDB) Last part of Random Query Generator output, including stack traces: (...) # 2010-08-31T16:53:44 Query: SELECT ( ( table1 . `col_int_nokey` ) * ( table1 . `col_int_nokey` ) ) AS field1 FROM ( C AS table1 STRAIGHT_JOIN ( ( C AS table2 INNER JOIN C AS table3 ON (table3 . `col_varchar_key` = table2 . `col_varchar_key` ) ) ) ON (table3 . `col_int_nokey` = table2 . `col_int_key` ) ) WHERE ( table3 . `col_int_key` != SOME ( SELECT SUBQUERY1_t1 . `col_int_nokey` AS SUBQUERY1_field1 FROM ( D AS SUBQUERY1_t1 LEFT OUTER JOIN C AS SUBQUERY1_t2 ON (SUBQUERY1_t2 . `col_int_key` = SUBQUERY1_t1 . `pk` ) ) WHERE SUBQUERY1_t2 . `col_int_nokey` > table1 . `col_int_nokey` ) ) OR ( table1 . `col_int_key` IN (96) OR table1 . `col_int_key` > 208 AND table1 . `col_int_key` < ( 208 + 224 ) ) GROUP BY field1 HAVING field1 >= 9 ORDER BY table1 . `col_date_key` , table2 .`pk` DESC failed: 2013 Lost connection to MySQL server during query # 2010-08-31T16:53:44 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10220:user=root:database=test # 2010-08-31T16:53:45 Killing periodic reporting process with pid 23177... # 2010-08-31T16:53:45 Kill GenTest::ErrorFilter(23176) # 2010-08-31T16:53:45 Server crash reported, initiating post-crash analysis... # 2010-08-31T16:53:45 datadir is /export/home/tmp/je159969/mysql-dev/bzr-randgen/randgen-testrun/var-single/master-data/ # 2010-08-31T16:53:45 binary is /export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/jbuild-optimized/install/../sql/mysqld # 2010-08-31T16:53:45 bindir is /export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/jbuild-optimized/install/../sql # 2010-08-31T16:53:45 core is /export/home/tmp/je159969/mysql-dev/bzr-randgen/randgen-testrun/var-single/master-data//core # 2010-08-31T16:53:52 For information about new features see `help changes' # 2010-08-31T16:53:52 To remove this message, put `dbxenv suppress_startup_message 7.7' in your .dbxrc # 2010-08-31T16:53:52 Reading mysqld # 2010-08-31T16:53:52 core file header read successfully # 2010-08-31T16:53:52 Reading ld.so.1 # 2010-08-31T16:53:52 Reading libthread.so.1 # 2010-08-31T16:53:52 Reading libnsl.so.1 # 2010-08-31T16:53:52 Reading libm.so.2 # 2010-08-31T16:53:52 Reading libsocket.so.1 # 2010-08-31T16:53:52 Reading libCstd.so.1 # 2010-08-31T16:53:52 Reading libCrun.so.1 # 2010-08-31T16:53:52 Reading libc.so.1 # 2010-08-31T16:53:52 t@14 (l@14) terminated by signal SEGV (Segmentation Fault) # 2010-08-31T16:53:52 0xfffffd7fff2842aa: _lwp_kill+0x000a: jae _lwp_kill+0x18 [ 0xfffffd7fff2842b8, .+0xe ] # 2010-08-31T16:53:52 Current function is my_write_core (optimized) # 2010-08-31T16:53:52 328 pthread_kill(pthread_self(), sig); # 2010-08-31T16:53:52 current thread: t@14 # 2010-08-31T16:53:52 [1] _lwp_kill(0xe, 0xb, 0xffffff077b68c1e0, 0x0, 0x0, 0x0), at 0xfffffd7fff2842aa # 2010-08-31T16:53:52 [2] thr_kill(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff2788cd # 2010-08-31T16:53:52 =>[3] my_write_core(sig = ???) (optimized), at 0x131dc89 (line ~328) in "stacktrace.c" # 2010-08-31T16:53:52 [4] handle_segfault(sig = ???) (optimized), at 0xb17dec (line ~2501) in "mysqld.cc" # 2010-08-31T16:53:52 [5] __sighndlr(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27b076 # 2010-08-31T16:53:52 [6] call_user_handler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26dfaf # 2010-08-31T16:53:52 [7] sigacthandler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26e1be # 2010-08-31T16:53:52 ---- called from signal handler with signal 11 (SIGSEGV) ------ # 2010-08-31T16:53:52 [8] srv_error_monitor_thread(arg = ???) (optimized), at 0xecaf85 (line ~2370) in "srv0srv.c" # 2010-08-31T16:53:52 [9] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [10] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@1 # 2010-08-31T16:53:52 =>[1] __pollsys(0xfffffd7fffdfbdd0, 0x2, 0x0, 0x0, 0xffffffff, 0xfffffd7fff0e0000), at 0xfffffd7fff283dca # 2010-08-31T16:53:52 [2] _pollsys(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c5ce # 2010-08-31T16:53:52 [3] poll(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff223c1a # 2010-08-31T16:53:52 [4] handle_connections_sockets() (optimized), at 0xb1b1d9 (line ~5273) in "mysqld.cc" # 2010-08-31T16:53:52 [5] mysqld_main(argc = ???, argv = ???) (optimized), at 0xb1aa56 (line ~4740) in "mysqld.cc" # 2010-08-31T16:53:52 [6] main(argc = ???, argv = ???) (optimized), at 0xb15c29 (line ~24) in "main.cc" # 2010-08-31T16:53:52 current thread: t@2 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e010, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@3 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e020, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@4 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e030, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@5 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e040, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@6 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e050, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@7 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e060, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@8 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e070, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@9 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e080, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@10 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e090, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@11 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e0a0, 0x2100), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] os_aio_simulated_handle(global_segment = ???, message1 = ???, message2 = ???, type = ???) (optimized), at 0x113318b (line ~4918) in "os0file.c" # 2010-08-31T16:53:52 [10] fil_aio_wait(segment = ???) (optimized), at 0x105e9eb (line ~4465) in "fil0fil.c" # 2010-08-31T16:53:52 [11] io_handler_thread(arg = ???) (optimized), at 0xed8d98 (line ~494) in "srv0start.c" # 2010-08-31T16:53:52 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@13 # 2010-08-31T16:53:52 =>[1] __pollsys(0xfffffd7ffd5b6e80, 0x0, 0xfffffd7ffd5b6f00, 0x0, 0xfffffd7ffd5b6f00, 0x0), at 0xfffffd7fff283dca # 2010-08-31T16:53:52 [2] _pollsys(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c5ce # 2010-08-31T16:53:52 [3] pselect(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff229114 # 2010-08-31T16:53:52 [4] select(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff229628 # 2010-08-31T16:53:52 [5] os_thread_sleep(tm = ???) (optimized), at 0x113fcc8 (line ~274) in "os0thread.c" # 2010-08-31T16:53:52 [6] srv_lock_timeout_thread(arg = ???) (optimized), at 0xecac0c (line ~2210) in "srv0srv.c" # 2010-08-31T16:53:52 [7] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [8] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@14 # 2010-08-31T16:53:52 [1] _lwp_kill(0xe, 0xb, 0xffffff077b68c1e0, 0x0, 0x0, 0x0), at 0xfffffd7fff2842aa # 2010-08-31T16:53:52 [2] thr_kill(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff2788cd # 2010-08-31T16:53:52 =>[3] my_write_core(sig = ???) (optimized), at 0x131dc89 (line ~328) in "stacktrace.c" # 2010-08-31T16:53:52 [4] handle_segfault(sig = ???) (optimized), at 0xb17dec (line ~2501) in "mysqld.cc" # 2010-08-31T16:53:52 [5] __sighndlr(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27b076 # 2010-08-31T16:53:52 [6] call_user_handler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26dfaf # 2010-08-31T16:53:52 [7] sigacthandler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26e1be # 2010-08-31T16:53:52 ---- called from signal handler with signal 11 (SIGSEGV) ------ # 2010-08-31T16:53:52 [8] srv_error_monitor_thread(arg = ???) (optimized), at 0xecaf85 (line ~2370) in "srv0srv.c" # 2010-08-31T16:53:52 [9] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [10] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@15 # 2010-08-31T16:53:52 =>[1] __pollsys(0xfffffd7ffd1b8e20, 0x0, 0xfffffd7ffd1b8ea0, 0x0, 0xfffffd7ffd1b8ea0, 0x0), at 0xfffffd7fff283dca # 2010-08-31T16:53:52 [2] _pollsys(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c5ce # 2010-08-31T16:53:52 [3] pselect(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff229114 # 2010-08-31T16:53:52 [4] select(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff229628 # 2010-08-31T16:53:52 [5] os_thread_sleep(tm = ???) (optimized), at 0x113fcc8 (line ~274) in "os0thread.c" # 2010-08-31T16:53:52 [6] srv_monitor_thread(arg = ???) (optimized), at 0xeca8aa (line ~2064) in "srv0srv.c" # 2010-08-31T16:53:52 [7] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [8] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@16 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e0b0, 0x1bdd), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] srv_master_thread(arg = ???) (optimized), at 0xecc5d8 (line ~3011) in "srv0srv.c" # 2010-08-31T16:53:52 [10] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [11] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@17 # 2010-08-31T16:53:52 =>[1] __sigtimedwait(0xfffffd7fff0befa0, 0xfffffd7fff0bee10, 0x0, 0x0, 0x1a74938, 0x0), at 0xfffffd7fff28325a # 2010-08-31T16:53:52 [2] sigtimedwait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c750 # 2010-08-31T16:53:52 [3] sigwait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c837 # 2010-08-31T16:53:52 [4] __posix_sigwait(0x0), at 0xfffffd7fff256b5a # 2010-08-31T16:53:52 [5] signal_hand(arg = ???) (optimized), at 0xb18373 (line ~2702) in "mysqld.cc" # 2010-08-31T16:53:52 [6] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [7] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@19 # 2010-08-31T16:53:52 =>[1] __read(0x1f, 0x2fae1f0, 0x4, 0x0, 0xfffffd7fff07dc60, 0xfffffd7fff07dd40), at 0xfffffd7fff283eda # 2010-08-31T16:53:52 [2] read(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff269f21 # 2010-08-31T16:53:52 [3] vio_read(vio = ???, buf = ???, size = ???) (optimized), at 0x13758ea (line ~44) in "viosocket.c" # 2010-08-31T16:53:52 [4] my_real_read(net = ???, complen = ???) (optimized), at 0xb20a89 (line ~831) in "net_serv.cc" # 2010-08-31T16:53:52 [5] my_net_read(net = ???) (optimized), at 0xb20eeb (line ~1028) in "net_serv.cc" # 2010-08-31T16:53:52 [6] do_command(thd = ???) (optimized), at 0xb750e0 (line ~748) in "sql_parse.cc" # 2010-08-31T16:53:52 [7] do_handle_one_connection(thd_arg = ???) (optimized), at 0xc0cbf4 (line ~1191) in "sql_connect.cc" # 2010-08-31T16:53:52 [8] handle_one_connection(arg = ???) (optimized), at 0xc0cad2 (line ~1130) in "sql_connect.cc" # 2010-08-31T16:53:52 [9] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [10] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 current thread: t@23 # 2010-08-31T16:53:52 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff11e110, 0x24af), at 0xfffffd7fff27aff7 # 2010-08-31T16:53:52 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-08-31T16:53:52 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-08-31T16:53:52 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-08-31T16:53:52 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-08-31T16:53:52 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-08-31T16:53:52 [7] os_cond_wait(cond = ???, mutex = ???) (optimized), at 0x113a779 (line ~140) in "os0sync.c" # 2010-08-31T16:53:52 [8] os_event_wait_low(event = ???, reset_sig_count = ???) (optimized), at 0x113b1d9 (line ~567) in "os0sync.c" # 2010-08-31T16:53:52 [9] sync_array_wait_event(arr = ???, index = ???) (optimized), at 0xee06d1 (line ~457) in "sync0arr.c" # 2010-08-31T16:53:52 [10] rw_lock_x_lock_wait(lock = ???, file_name = ???, line = ???) (optimized), at 0xee5f8b (line ~530) in "sync0rw.c" # 2010-08-31T16:53:52 [11] rw_lock_x_lock_low(lock = ???, pass = ???, file_name = ???, line = ???) (optimized), at 0xee6068 (line ~576) in "sync0rw.c" # 2010-08-31T16:53:52 [12] rw_lock_x_lock_func(lock = ???, pass = ???, file_name = ???, line = ???) (optimized), at 0xee6154 (line ~628) in "sync0rw.c" # 2010-08-31T16:53:52 [13] pfs_rw_lock_x_lock_func(lock = ???, pass = ???, file_name = ???, line = ???) (optimized), at 0xfa8a20 (line ~692) in "sync0rw.ic" # 2010-08-31T16:53:52 [14] btr_search_drop_page_hash_index(block = ???) (optimized), at 0xfb05d4 (line ~1136) in "btr0sea.c" # 2010-08-31T16:53:52 [15] btr_search_build_page_hash_index(index = ???, block = ???, n_fields = ???, n_bytes = ???, left_side = ???) (optimized), at 0xfb0c09 (line ~1292) in "btr0sea.c" # 2010-08-31T16:53:52 [16] btr_search_info_update_slow(info = ???, cursor = ???) (optimized), at 0xfafb6f (line ~666) in "btr0sea.c" # 2010-08-31T16:53:52 [17] btr_search_info_update(index = ???, cursor = ???) (optimized), at 0xf8fa4e (line ~83) in "btr0sea.ic" # 2010-08-31T16:53:52 [18] btr_cur_search_to_nth_level(index = ???, level = ???, tuple = ???, mode = ???, latch_mode = ???, cursor = ???, has_search_latch = ???, file = ???, line = ???, mtr = ???) (optimized), at 0xf912dd (line ~775) in "btr0cur.c" # 2010-08-31T16:53:52 [19] btr_pcur_open_with_no_init_func(index = ???, tuple = ???, mode = ???, latch_mode = ???, cursor = ???, has_search_latch = ???, file = ???, line = ???, mtr = ???) (optimized), at 0xe915af (line ~544) in "btr0pcur.ic" # 2010-08-31T16:53:52 [20] row_sel_get_clust_rec_for_mysql(prebuilt = ???, sec_index = ???, rec = ???, thr = ???, out_rec = ???, offsets = ???, offset_heap = ???, mtr = ???) (optimized), at 0xe95d52 (line ~2901) in "row0sel.c" # 2010-08-31T16:53:52 [21] row_search_for_mysql(buf = ???, mode = ???, prebuilt = ???, match_mode = ???, direction = ???) (optimized), at 0xe97914 (line ~4389) in "row0sel.c" # 2010-08-31T16:53:52 [22] ha_innobase::index_read(this = ???, buf = ???, key_ptr = ???, key_len = ???, find_flag = ???) (optimized), at 0xe3fe81 (line ~5695) in "ha_innodb.cc" # 2010-08-31T16:53:52 [23] handler::index_read_map(this = ???, buf = ???, key = ???, keypart_map = ???, find_flag = ???) (optimized), at 0xc74d84 (line ~1791) in "handler.h" # 2010-08-31T16:53:52 [24] handler::ha_index_read_map(this = ???, buf = ???, key = ???, keypart_map = ???, find_flag = ???) (optimized), at 0xc6ec2f (line ~2223) in "handler.cc" # 2010-08-31T16:53:52 [25] join_read_always_key(tab = ???) (optimized), at 0xbaa5e5 (line ~17737) in "sql_select.cc" # 2010-08-31T16:53:52 [26] sub_select(join = ???, join_tab = ???, end_of_records = ???) (optimized), at 0xba953b (line ~16975) in "sql_select.cc" # 2010-08-31T16:53:52 [27] JOIN_CACHE::generate_full_extensions(this = ???, rec_ptr = ???) (optimized), at 0xd2b0ed (line ~1951) in "sql_join_cache.cc" # 2010-08-31T16:53:52 [28] JOIN_CACHE_BNL::join_matching_records(this = ???, skip_last = ???) (optimized), at 0xd2aef0 (line ~1843) in "sql_join_cache.cc" # 2010-08-31T16:53:52 [29] JOIN_CACHE::join_records(this = ???, skip_last = ???) (optimized), at 0xd2ab84 (line ~1649) in "sql_join_cache.cc" # 2010-08-31T16:53:52 [30] sub_select_cache(join = ???, join_tab = ???, end_of_records = ???) (optimized), at 0xba9492 (line ~16778) in "sql_select.cc" # 2010-08-31T16:53:52 [31] sub_select(join = ???, join_tab = ???, end_of_records = ???) (optimized), at 0xba9600 (line ~16947) in "sql_select.cc" # 2010-08-31T16:53:52 [32] do_select(join = ???, fields = ???, table = ???, procedure = ???) (optimized), at 0xba902f (line ~16535) in "sql_select.cc" # 2010-08-31T16:53:52 [33] JOIN::exec(this = ???) (optimized), at 0xb92710 (line ~2767) in "sql_select.cc" # 2010-08-31T16:53:52 [34] mysql_select(thd = ???, rref_pointer_array = ???, tables = ???, wild_num = ???, fields = CLASS, conds = ???, og_num = ???, order = ???, group = ???, having = ???, proc_param = ???, select_options = ???, result = ???, unit = ???, select_lex = ???) (optimized), at 0xb93b62 (line ~3359) in "sql_select.cc" # 2010-08-31T16:53:52 [35] handle_select(thd = ???, lex = ???, result = ???, setup_tables_done_option = ???) (optimized), at 0xb8e691 (line ~310) in "sql_select.cc" # 2010-08-31T16:53:52 [36] execute_sqlcom_select(thd = ???, all_tables = ???) (optimized), at 0xb7b7e2 (line ~4562) in "sql_parse.cc" # 2010-08-31T16:53:52 [37] mysql_execute_command(thd = ???) (optimized), at 0xb7a8e1 (line ~2166) in "sql_parse.cc" # 2010-08-31T16:53:52 [38] mysql_parse(thd = ???, rawbuf = ???, length = ???, parser_state = ???) (optimized), at 0xb7cda7 (line ~5591) in "sql_parse.cc" # 2010-08-31T16:53:52 [39] dispatch_command(command = ???, thd = ???, packet = ???, packet_length = ???) (optimized), at 0xb75d3c (line ~1130) in "sql_parse.cc" # 2010-08-31T16:53:52 [40] do_command(thd = ???) (optimized), at 0xb7513c (line ~802) in "sql_parse.cc" # 2010-08-31T16:53:52 [41] do_handle_one_connection(thd_arg = ???) (optimized), at 0xc0cbf4 (line ~1191) in "sql_connect.cc" # 2010-08-31T16:53:52 [42] handle_one_connection(arg = ???) (optimized), at 0xc0cad2 (line ~1130) in "sql_connect.cc" # 2010-08-31T16:53:52 [43] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-08-31T16:53:52 [44] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-08-31T16:53:52 Waiting for mysqld with pid 23172 to terminate... # 2010-08-31T16:53:52 ... waiting complete. # 2010-08-31T16:53:52 Test completed with failure status 101. # 2010-08-31T16:53:52 gentest.pl exited with exit status 101 2010-08-31T16:53:52 [23157] runall.pl will exit with exit status 101