Bug47183 - long semaphore wait terminates server (InnoDB) Last part of Random Query Generator output, including stack traces (debug build): (...) # 2010-09-01T09:39:55 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-09-01T09:39:55 Server crash reported at dsn dbi:mysql:host=127.0.0.1:port=10220:user=root:database=test # 2010-09-01T09:39:56 Killing periodic reporting process with pid 26327... # 2010-09-01T09:39:56 Kill GenTest::ErrorFilter(26326) # 2010-09-01T09:39:56 Server crash reported, initiating post-crash analysis... # 2010-09-01T09:39:56 datadir is /export/home/tmp/je159969/mysql-dev/bzr-randgen/randgen-testrun/var-single/master-data/ # 2010-09-01T09:39:56 binary is /export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/jbuild/install/../sql/mysqld # 2010-09-01T09:39:56 bindir is /export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/jbuild/install/../sql # 2010-09-01T09:39:56 core is /export/home/tmp/je159969/mysql-dev/bzr-randgen/randgen-testrun/var-single/master-data//core # 2010-09-01T09:40:00 For information about new features see `help changes' # 2010-09-01T09:40:00 To remove this message, put `dbxenv suppress_startup_message 7.7' in your .dbxrc # 2010-09-01T09:40:00 Reading mysqld # 2010-09-01T09:40:00 core file header read successfully # 2010-09-01T09:40:00 Reading ld.so.1 # 2010-09-01T09:40:00 Reading libthread.so.1 # 2010-09-01T09:40:00 Reading libnsl.so.1 # 2010-09-01T09:40:00 Reading libm.so.2 # 2010-09-01T09:40:00 Reading libsocket.so.1 # 2010-09-01T09:40:00 Reading libCstd.so.1 # 2010-09-01T09:40:00 Reading libCrun.so.1 # 2010-09-01T09:40:00 Reading libc.so.1 # 2010-09-01T09:40:00 t@14 (l@14) terminated by signal SEGV (Segmentation Fault) # 2010-09-01T09:40:00 0xfffffd7fff2842aa: _lwp_kill+0x000a: jae _lwp_kill+0x18 [ 0xfffffd7fff2842b8, .+0xe ] # 2010-09-01T09:40:00 Current function is my_write_core # 2010-09-01T09:40:00 328 pthread_kill(pthread_self(), sig); # 2010-09-01T09:40:00 current thread: t@14 # 2010-09-01T09:40:00 [1] _lwp_kill(0xe, 0xb, 0xffffff02de903c60, 0x0, 0x0, 0x0), at 0xfffffd7fff2842aa # 2010-09-01T09:40:00 [2] thr_kill(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff2788cd # 2010-09-01T09:40:00 =>[3] my_write_core(sig = 11), line 328 in "stacktrace.c" # 2010-09-01T09:40:00 [4] handle_segfault(sig = 11), line 2501 in "mysqld.cc" # 2010-09-01T09:40:00 [5] __sighndlr(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27b076 # 2010-09-01T09:40:00 [6] call_user_handler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26dfaf # 2010-09-01T09:40:00 [7] sigacthandler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26e1be # 2010-09-01T09:40:00 ---- called from signal handler with signal 11 (SIGSEGV) ------ # 2010-09-01T09:40:00 [8] srv_error_monitor_thread(arg = (nil)), line 2370 in "srv0srv.c" # 2010-09-01T09:40:00 [9] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [10] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@1 # 2010-09-01T09:40:00 =>[1] __pollsys(0xfffffd7fffdfbfcc, 0x2, 0x0, 0x0, 0xffffffff, 0x241bdd0), at 0xfffffd7fff283dca # 2010-09-01T09:40:00 [2] _pollsys(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c5ce # 2010-09-01T09:40:00 [3] poll(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff223c1a # 2010-09-01T09:40:00 [4] handle_connections_sockets(), line 5273 in "mysqld.cc" # 2010-09-01T09:40:00 [5] mysqld_main(argc = 41, argv = 0x241c078), line 4740 in "mysqld.cc" # 2010-09-01T09:40:00 [6] main(argc = 41, argv = 0xfffffd7fffdfc248), line 24 in "main.cc" # 2010-09-01T09:40:00 current thread: t@2 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116010, 0x2a7d), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7dfd8, mutex = 0x2a7dfb0), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7dfb0, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 0, message1 = 0xfffffd7ffeebef50, message2 = 0xfffffd7ffeebef48, type = 0xfffffd7ffeebef40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 0), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec608), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@3 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116020, 0x2a7e), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7e038, mutex = 0x2a7e010), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7e010, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 1U, message1 = 0xfffffd7ffecbff50, message2 = 0xfffffd7ffecbff48, type = 0xfffffd7ffecbff40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 1U), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec610), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@4 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116030, 0x2a7e), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7e098, mutex = 0x2a7e070), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7e070, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 2U, message1 = 0xfffffd7ffeac0f50, message2 = 0xfffffd7ffeac0f48, type = 0xfffffd7ffeac0f40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 2U), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec618), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@5 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116040, 0x2a7e), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7e0f8, mutex = 0x2a7e0d0), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7e0d0, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 3U, message1 = 0xfffffd7ffe5aef50, message2 = 0xfffffd7ffe5aef48, type = 0xfffffd7ffe5aef40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 3U), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec620), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@6 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116050, 0x2a7e), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7e158, mutex = 0x2a7e130), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7e130, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 4U, message1 = 0xfffffd7ffe3aff50, message2 = 0xfffffd7ffe3aff48, type = 0xfffffd7ffe3aff40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 4U), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec628), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@7 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116060, 0x2a7e), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7e1b8, mutex = 0x2a7e190), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7e190, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 5U, message1 = 0xfffffd7ffe1b0f50, message2 = 0xfffffd7ffe1b0f48, type = 0xfffffd7ffe1b0f40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 5U), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec630), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@8 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116070, 0x2a7e), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7e218, mutex = 0x2a7e1f0), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7e1f0, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 6U, message1 = 0xfffffd7ffdfb1f50, message2 = 0xfffffd7ffdfb1f48, type = 0xfffffd7ffdfb1f40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 6U), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec638), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@9 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116080, 0x2a7e), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7e278, mutex = 0x2a7e250), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7e250, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 7U, message1 = 0xfffffd7ffddb2f50, message2 = 0xfffffd7ffddb2f48, type = 0xfffffd7ffddb2f40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 7U), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec640), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@10 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116090, 0x2a7e), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7e2d8, mutex = 0x2a7e2b0), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7e2b0, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 8U, message1 = 0xfffffd7ffdbb3f50, message2 = 0xfffffd7ffdbb3f48, type = 0xfffffd7ffdbb3f40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 8U), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec648), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@11 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff1160a0, 0x2a7e), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2a7e338, mutex = 0x2a7e310), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2a7e310, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] os_aio_simulated_handle(global_segment = 9U, message1 = 0xfffffd7ffd9b4f50, message2 = 0xfffffd7ffd9b4f48, type = 0xfffffd7ffd9b4f40), line 4918 in "os0file.c" # 2010-09-01T09:40:00 [10] fil_aio_wait(segment = 9U), line 4465 in "fil0fil.c" # 2010-09-01T09:40:00 [11] io_handler_thread(arg = 0x23ec650), line 494 in "srv0start.c" # 2010-09-01T09:40:00 [12] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [13] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@13 # 2010-09-01T09:40:00 =>[1] __pollsys(0xfffffd7ffd5b6e80, 0x0, 0xfffffd7ffd5b6f00, 0x0, 0xfffffd7ffd5b6f00, 0x0), at 0xfffffd7fff283dca # 2010-09-01T09:40:00 [2] _pollsys(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c5ce # 2010-09-01T09:40:00 [3] pselect(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff229114 # 2010-09-01T09:40:00 [4] select(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff229628 # 2010-09-01T09:40:00 [5] os_thread_sleep(tm = 1000000U), line 274 in "os0thread.c" # 2010-09-01T09:40:00 [6] srv_lock_timeout_thread(arg = (nil)), line 2210 in "srv0srv.c" # 2010-09-01T09:40:00 [7] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [8] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@14 # 2010-09-01T09:40:00 [1] _lwp_kill(0xe, 0xb, 0xffffff02de903c60, 0x0, 0x0, 0x0), at 0xfffffd7fff2842aa # 2010-09-01T09:40:00 [2] thr_kill(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff2788cd # 2010-09-01T09:40:00 =>[3] my_write_core(sig = 11), line 328 in "stacktrace.c" # 2010-09-01T09:40:00 [4] handle_segfault(sig = 11), line 2501 in "mysqld.cc" # 2010-09-01T09:40:00 [5] __sighndlr(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27b076 # 2010-09-01T09:40:00 [6] call_user_handler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26dfaf # 2010-09-01T09:40:00 [7] sigacthandler(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26e1be # 2010-09-01T09:40:00 ---- called from signal handler with signal 11 (SIGSEGV) ------ # 2010-09-01T09:40:00 [8] srv_error_monitor_thread(arg = (nil)), line 2370 in "srv0srv.c" # 2010-09-01T09:40:00 [9] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [10] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@15 # 2010-09-01T09:40:00 =>[1] __pollsys(0xfffffd7ffd1b8e60, 0x0, 0xfffffd7ffd1b8ee0, 0x0, 0xfffffd7ffd1b8ee0, 0x0), at 0xfffffd7fff283dca # 2010-09-01T09:40:00 [2] _pollsys(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c5ce # 2010-09-01T09:40:00 [3] pselect(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff229114 # 2010-09-01T09:40:00 [4] select(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff229628 # 2010-09-01T09:40:00 [5] os_thread_sleep(tm = 5000000U), line 274 in "os0thread.c" # 2010-09-01T09:40:00 [6] srv_monitor_thread(arg = (nil)), line 2064 in "srv0srv.c" # 2010-09-01T09:40:00 [7] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [8] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@16 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff1160b0, 0x255b), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x255b3d8, mutex = 0x255b3b0), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x255b3b0, reset_sig_count = 0), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] srv_master_thread(arg = (nil)), line 3011 in "srv0srv.c" # 2010-09-01T09:40:00 [10] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [11] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@17 # 2010-09-01T09:40:00 =>[1] __sigtimedwait(0xfffffd7fff0bef98, 0xfffffd7fff0bed60, 0x0, 0x0, 0x23f29b0, 0x0), at 0xfffffd7fff28325a # 2010-09-01T09:40:00 [2] sigtimedwait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c750 # 2010-09-01T09:40:00 [3] sigwait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff26c837 # 2010-09-01T09:40:00 [4] __posix_sigwait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff256b5a # 2010-09-01T09:40:00 [5] signal_hand(arg = (nil)), line 2702 in "mysqld.cc" # 2010-09-01T09:40:00 [6] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [7] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@19 # 2010-09-01T09:40:00 =>[1] __read(0x1f, 0x392c4b0, 0x4, 0x0, 0x3926320, 0x3926320), at 0xfffffd7fff283eda # 2010-09-01T09:40:00 [2] read(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff269f21 # 2010-09-01T09:40:00 [3] vio_read(vio = 0x3926320, buf = 0x392c4b0 "^G", size = 4U), line 44 in "viosocket.c" # 2010-09-01T09:40:00 [4] my_real_read(net = 0x38eccc0, complen = 0xfffffd7fff07de78), line 831 in "net_serv.cc" # 2010-09-01T09:40:00 [5] my_net_read(net = 0x38eccc0), line 1028 in "net_serv.cc" # 2010-09-01T09:40:00 [6] do_command(thd = 0x38ecb30), line 748 in "sql_parse.cc" # 2010-09-01T09:40:00 [7] do_handle_one_connection(thd_arg = 0x38ecb30), line 1191 in "sql_connect.cc" # 2010-09-01T09:40:00 [8] handle_one_connection(arg = 0x38ecb30), line 1130 in "sql_connect.cc" # 2010-09-01T09:40:00 [9] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [10] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 current thread: t@23 # 2010-09-01T09:40:00 =>[1] __lwp_park(0x0, 0x0, 0x0, 0x1, 0xfffffd7fff116110, 0x2e2d), at 0xfffffd7fff27aff7 # 2010-09-01T09:40:00 [2] cond_sleep_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274326 # 2010-09-01T09:40:00 [3] cond_wait_queue(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274530 # 2010-09-01T09:40:00 [4] __cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274a73 # 2010-09-01T09:40:00 [5] cond_wait(0x0), at 0xfffffd7fff274acb # 2010-09-01T09:40:00 [6] pthread_cond_wait(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff274b01 # 2010-09-01T09:40:00 [7] os_cond_wait(cond = 0x2e2da58, mutex = 0x2e2da30), line 140 in "os0sync.c" # 2010-09-01T09:40:00 [8] os_event_wait_low(event = 0x2e2da30, reset_sig_count = 1LL), line 567 in "os0sync.c" # 2010-09-01T09:40:00 [9] sync_array_wait_event(arr = 0x242cc50, index = 0), line 457 in "sync0arr.c" # 2010-09-01T09:40:00 [10] rw_lock_x_lock_wait(lock = 0x2e2d948, file_name = 0x1dfb6d8 "/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/storage/innobase/btr/btr0sea.c", line = 1136U), line 530 in "sync0rw.c" # 2010-09-01T09:40:00 [11] rw_lock_x_lock_low(lock = 0x2e2d948, pass = 0, file_name = 0x1dfb6d8 "/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/storage/innobase/btr/btr0sea.c", line = 1136U), line 576 in "sync0rw.c" # 2010-09-01T09:40:00 [12] rw_lock_x_lock_func(lock = 0x2e2d948, pass = 0, file_name = 0x1dfb6d8 "/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/storage/innobase/btr/btr0sea.c", line = 1136U), line 628 in "sync0rw.c" # 2010-09-01T09:40:00 [13] pfs_rw_lock_x_lock_func(lock = 0x2e2d948, pass = 0, file_name = 0x1dfb6d8 "/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/storage/innobase/btr/btr0sea.c", line = 1136U), line 692 in "sync0rw.ic" # 2010-09-01T09:40:00 [14] btr_search_drop_page_hash_index(block = 0xfffffd7ff0e102c8), line 1136 in "btr0sea.c" # 2010-09-01T09:40:00 [15] btr_search_build_page_hash_index(index = 0x3960508, block = 0xfffffd7ff0e102c8, n_fields = 1U, n_bytes = 0, left_side = 0), line 1292 in "btr0sea.c" # 2010-09-01T09:40:00 [16] btr_search_info_update_slow(info = 0x39608c8, cursor = 0x3a22038), line 666 in "btr0sea.c" # 2010-09-01T09:40:00 [17] btr_search_info_update(index = 0x3960508, cursor = 0x3a22038), line 83 in "btr0sea.ic" # 2010-09-01T09:40:00 [18] btr_cur_search_to_nth_level(index = 0x3960508, level = 0, tuple = 0x3a22488, mode = 4U, latch_mode = 1U, cursor = 0x3a22038, has_search_latch = 0, file = 0x1d91780 "/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/storage/innobase/row/row0sel.c", line = 2901U, mtr = 0xfffffd7fff038568), line 775 in "btr0cur.c" # 2010-09-01T09:40:00 [19] btr_pcur_open_with_no_init_func(index = 0x3960508, tuple = 0x3a22488, mode = 4U, latch_mode = 1U, cursor = 0x3a22038, has_search_latch = 0, file = 0x1d91780 "/export/home/tmp/je159969/mysql-dev/bzr-repos/mysql-next-mr-opt-backporting/storage/innobase/row/row0sel.c", line = 2901U, mtr = 0xfffffd7fff038568), line 544 in "btr0pcur.ic" # 2010-09-01T09:40:00 [20] row_sel_get_clust_rec_for_mysql(prebuilt = 0x3a1eb38, sec_index = 0x3962a28, rec = 0xfffffd7ff13c8169 "c\x80", thr = 0x3b1a278, out_rec = 0xfffffd7fff038a48, offsets = 0xfffffd7fff038238, offset_heap = 0xfffffd7fff038560, mtr = 0xfffffd7fff038568), line 2901 in "row0sel.c" # 2010-09-01T09:40:00 [21] row_search_for_mysql(buf = 0x3a1ddd0 "ð", mode = 2U, prebuilt = 0x3a1eb38, match_mode = 1U, direction = 0), line 4389 in "row0sel.c" # 2010-09-01T09:40:00 [22] ha_innobase::index_read(this = 0x3a1db10, buf = 0x3a1ddd0 "ð", key_ptr = 0x39ec7b0 "", key_len = 4U, find_flag = HA_READ_KEY_EXACT), line 5695 in "ha_innodb.cc" # 2010-09-01T09:40:00 [23] handler::index_read_map(this = 0x3a1db10, buf = 0x3a1ddd0 "ð", key = 0x39ec7b0 "", keypart_map = 1U, find_flag = HA_READ_KEY_EXACT), line 1791 in "handler.h" # 2010-09-01T09:40:00 [24] handler::ha_index_read_map(this = 0x3a1db10, buf = 0x3a1ddd0 "ð", key = 0x39ec7b0 "", keypart_map = 1U, find_flag = HA_READ_KEY_EXACT), line 2223 in "handler.cc" # 2010-09-01T09:40:00 [25] join_read_always_key(tab = 0x39ec500), line 17737 in "sql_select.cc" # 2010-09-01T09:40:00 [26] sub_select(join = 0x3a3bc00, join_tab = 0x39ec500, end_of_records = false), line 16975 in "sql_select.cc" # 2010-09-01T09:40:00 [27] JOIN_CACHE::generate_full_extensions(this = 0x39edc20, rec_ptr = 0x39be68d ""), line 1951 in "sql_join_cache.cc" # 2010-09-01T09:40:00 [28] JOIN_CACHE_BNL::join_matching_records(this = 0x39edc20, skip_last = false), line 1843 in "sql_join_cache.cc" # 2010-09-01T09:40:00 [29] JOIN_CACHE::join_records(this = 0x39edc20, skip_last = false), line 1649 in "sql_join_cache.cc" # 2010-09-01T09:40:00 [30] sub_select_cache(join = 0x3a3bc00, join_tab = 0x39ec250, end_of_records = true), line 16778 in "sql_select.cc" # 2010-09-01T09:40:00 [31] sub_select(join = 0x3a3bc00, join_tab = 0x39ebfa0, end_of_records = true), line 16947 in "sql_select.cc" # 2010-09-01T09:40:00 [32] do_select(join = 0x3a3bc00, fields = (nil), table = 0x3a2d880, procedure = (nil)), line 16535 in "sql_select.cc" # 2010-09-01T09:40:00 [33] JOIN::exec(this = 0x3a3bc00), line 2767 in "sql_select.cc" # 2010-09-01T09:40:00 [34] mysql_select(thd = 0x393ef30, rref_pointer_array = 0x3940fe0, tables = 0x39a4158, wild_num = 0, fields = CLASS, conds = 0x3a21af0, og_num = 3U, order = 0x3a34588, group = 0x3a21ce8, having = 0x3a342f0, proc_param = (nil), select_options = 2147748608ULL, result = 0x3a347c0, unit = 0x39407e0, select_lex = 0x3940df8), line 3359 in "sql_select.cc" # 2010-09-01T09:40:00 [35] handle_select(thd = 0x393ef30, lex = 0x3940730, result = 0x3a347c0, setup_tables_done_option = 0), line 310 in "sql_select.cc" # 2010-09-01T09:40:00 [36] execute_sqlcom_select(thd = 0x393ef30, all_tables = 0x39a4158), line 4562 in "sql_parse.cc" # 2010-09-01T09:40:00 [37] mysql_execute_command(thd = 0x393ef30), line 2166 in "sql_parse.cc" # 2010-09-01T09:40:00 [38] mysql_parse(thd = 0x393ef30, rawbuf = 0x39a3120 "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 SUB" ..., length = 773U, parser_state = 0xfffffd7fff03cab0), line 5591 in "sql_parse.cc" # 2010-09-01T09:40:00 [39] dispatch_command(command = COM_QUERY, thd = 0x393ef30, packet = 0x3946001 " 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 S" ..., packet_length = 775U), line 1130 in "sql_parse.cc" # 2010-09-01T09:40:00 [40] do_command(thd = 0x393ef30), line 802 in "sql_parse.cc" # 2010-09-01T09:40:00 [41] do_handle_one_connection(thd_arg = 0x393ef30), line 1191 in "sql_connect.cc" # 2010-09-01T09:40:00 [42] handle_one_connection(arg = 0x393ef30), line 1130 in "sql_connect.cc" # 2010-09-01T09:40:00 [43] _thrp_setup(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27acf5 # 2010-09-01T09:40:00 [44] _lwp_start(0x0, 0x0, 0x0, 0x0, 0x0, 0x0), at 0xfffffd7fff27afb0 # 2010-09-01T09:40:00 Waiting for mysqld with pid 26322 to terminate... # 2010-09-01T09:40:00 ... waiting complete. # 2010-09-01T09:40:00 Test completed with failure status 101. # 2010-09-01T09:40:00 gentest.pl exited with exit status 101 2010-09-01T09:40:00 [26307] runall.pl will exit with exit status 101