Server [mysqld.1 - pid: 19852, winpid: 19852, exit: 256] failed during test run Server log from this test: 100401 23:25:58 [Note] Buffered information: Performance schema enabled. 100401 23:25:58 [Note] Plugin 'FEDERATED' is disabled. 100401 23:25:58 [Note] Plugin 'InnoDB' is disabled. 100401 23:25:58 [Note] Plugin 'ndbcluster' is disabled. 100401 23:25:58 [Note] Event Scheduler: Loaded 0 events 100401 23:25:58 [Note] /mysql-6.0/sql/mysqld: ready for connections. Version: '6.0.14-alpha-gcov-debug-log' socket: '/mysql-6.0/mysql-test/var/tmp/mysqld.1.sock' port: 13000 Source distribution mysqld: sql_join_cache.cc:1883: bool JOIN_CACHE::set_match_flag_if_none(JOIN_TAB*, uchar*): Assertion `cache' failed. 100401 23:25:58 - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=1 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 60134 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xb684008 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0xb3878f0c thread_stack 0x30c00 /mysql-6.0/sql/mysqld(my_print_stacktrace+0x42) [0x8d1edf6] /mysql-6.0/sql/mysqld(handle_segfault+0x4e3) [0x8421d0d] [0x672400] /lib/tls/i686/cmov/libc.so.6(abort+0x182) [0x4f0932] /lib/tls/i686/cmov/libc.so.6(__assert_fail+0xf8) [0x4e6648] /mysql-6.0/sql/mysqld(JOIN_CACHE::set_match_flag_if_none(st_join_table*, unsigned char*)+0xcb) [0x84c8b8f] /mysql-6.0/sql/mysqld(JOIN_CACHE::join_null_complements(bool)+0x444) [0x84c9314] /mysql-6.0/sql/mysqld(JOIN_CACHE::join_records(bool)+0x394) [0x84c7fc6] /mysql-6.0/sql/mysqld(sub_select_cache(JOIN*, st_join_table*, bool)+0x10a) [0x858303f] /mysql-6.0/sql/mysqld(sub_select(JOIN*, st_join_table*, bool)+0xa3) [0x85834ad] /mysql-6.0/sql/mysqld(sub_select(JOIN*, st_join_table*, bool)+0xa3) [0x85834ad] /mysql-6.0/sql/mysqld(sub_select_cache(JOIN*, st_join_table*, bool)+0x18e) [0x85830c3] /mysql-6.0/sql/mysqld(sub_select(JOIN*, st_join_table*, bool)+0xa3) [0x85834ad] /mysql-6.0/sql/mysqld [0x8582127] /mysql-6.0/sql/mysqld(JOIN::exec()+0x400d) [0x85483c7] /mysql-6.0/sql/mysqld(mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x5aa) [0x85490d1] /mysql-6.0/sql/mysqld(handle_select(THD*, LEX*, select_result*, unsigned long)+0x2e2) [0x853944d] /mysql-6.0/sql/mysqld [0x8459ca5] /mysql-6.0/sql/mysqld(mysql_execute_command(THD*)+0x1427) [0x8448b0c] /mysql-6.0/sql/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x4ed) [0x845dd5a] /mysql-6.0/sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x12f5) [0x84439ad] /mysql-6.0/sql/mysqld(do_command(THD*)+0x492) [0x84421c7] /mysql-6.0/sql/mysqld(do_handle_one_connection(THD*)+0x2f6) [0x843e551] /mysql-6.0/sql/mysqld(handle_one_connection+0x60) [0x843e238] /mysql-6.0/sql/mysqld(pfs_spawn_thread(void*)+0x176) [0x8e7a303] /lib/tls/i686/cmov/libpthread.so.0 [0x85b80e] /lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0x58f8de] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xb5b7a88 = SELECT table2 .`col_varchar_1024_utf8_key` FROM H table2 LEFT JOIN F table3 JOIN J table4 ON table3 .`col_int_key` = table4 .`pk` LEFT JOIN O table5 ON table5 .`col_varchar_10_latin1_key` ON table2 .`col_varchar_10_latin1_key` > table3 .`col_varchar_10_latin1_key` thd->thread_id=2 thd->killed=NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file - saving '/mysql-6.0/mysql-test/var/log/main.exp1/' to '/mysql-6.0/mysql-test/var/log/main.exp1/' - found 'core' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql-6.0/sql/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 19855] [New Thread 19853] warning: Can't read pathname for load map: Input/output error. Core was generated by `/mysql-6.0/sql/mysqld --defaults-group-suffix=.1'. Program terminated with signal 6, Aborted. #0 0x00672422 in __kernel_vsyscall () #0 0x00672422 in __kernel_vsyscall () #1 0x00860e93 in __pthread_kill (threadid=3012007792, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 #2 0x08d1f00f in my_write_core (sig=6) at stacktrace.c:328 #3 0x08422222 in handle_segfault (sig=6) at mysqld.cc:2843 #4 #5 0x00672422 in __kernel_vsyscall () #6 0x004ed4d1 in *__GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #7 0x004f0932 in *__GI_abort () at abort.c:92 #8 0x004e6648 in *__GI___assert_fail (assertion=0x9052310 "cache", file=0x9052270 "sql_join_cache.cc", line=1883, function=0x9052760 "bool JOIN_CACHE::set_match_flag_if_none(JOIN_TAB*, uchar*)") at assert.c:81 #9 0x084c8b8f in JOIN_CACHE::set_match_flag_if_none (this=0xb759368, first_inner=0xb752e64, rec_ptr=0xb3807022 "") at sql_join_cache.cc:1883 #10 0x084c9314 in JOIN_CACHE::join_null_complements (this=0xb759368, skip_last=false) at sql_join_cache.cc:2079 #11 0x084c7fc6 in JOIN_CACHE::join_records (this=0xb759368, skip_last=false) at sql_join_cache.cc:1661 #12 0x0858303f in sub_select_cache (join=0xb753ad0, join_tab=0xb7531dc, end_of_records=true) at sql_select.cc:16405 #13 0x085834ad in sub_select (join=0xb753ad0, join_tab=0xb753020, end_of_records=true) at sql_select.cc:16568 #14 0x085834ad in sub_select (join=0xb753ad0, join_tab=0xb752e64, end_of_records=true) at sql_select.cc:16568 #15 0x085830c3 in sub_select_cache (join=0xb753ad0, join_tab=0xb752e64, end_of_records=true) at sql_select.cc:16407 #16 0x085834ad in sub_select (join=0xb753ad0, join_tab=0xb752ca8, end_of_records=true) at sql_select.cc:16568 #17 0x08582127 in do_select (join=0xb753ad0, fields=0xb6855a8, table=0x0, procedure=0x0) at sql_select.cc:16159 #18 0x085483c7 in JOIN::exec (this=0xb753ad0) at sql_select.cc:2987 #19 0x085490d1 in mysql_select (thd=0xb684008, rref_pointer_array=0xb685618, tables=0xb5b7e48, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0xb5b9a50, unit=0xb685054, select_lex=0xb685514) at sql_select.cc:3184 #20 0x0853944d in handle_select (thd=0xb684008, lex=0xb684ff8, result=0xb5b9a50, setup_tables_done_option=0) at sql_select.cc:304 #21 0x08459ca5 in execute_sqlcom_select (thd=0xb684008, all_tables=0xb5b7e48) at sql_parse.cc:5032 #22 0x08448b0c in mysql_execute_command (thd=0xb684008) at sql_parse.cc:2295 #23 0x0845dd5a in mysql_parse (thd=0xb684008, inBuf=0xb5b7a88 "SELECT table2 .`col_varchar_1024_utf8_key` \nFROM H table2 LEFT JOIN F table3 JOIN J table4 ON table3 .`col_int_key` = table4 .`pk` LEFT JOIN O table5 ON table5 .`col_varchar_10_latin1_key` O"..., length=276, found_semicolon=0xb3878910) at sql_parse.cc:6060 #24 0x084439ad in dispatch_command (command=COM_QUERY, thd=0xb684008, packet=0xb652eb1 "", packet_length=279) at sql_parse.cc:1091 #25 0x084421c7 in do_command (thd=0xb684008) at sql_parse.cc:775 #26 0x0843e551 in do_handle_one_connection (thd_arg=0xb684008) at sql_connect.cc:1173 #27 0x0843e238 in handle_one_connection (arg=0xb684008) at sql_connect.cc:1113 #28 0x08e7a303 in pfs_spawn_thread (arg=0xb6c5630) at pfs.cc:1011 #29 0x0085b80e in start_thread (arg=0xb3879770) at pthread_create.c:300 #30 0x0058f8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 Thread 3 (Thread 19853): #0 0x00672422 in __kernel_vsyscall () #1 0x00581c96 in *__GI___poll (fds=0x603ff4, nfds=2, timeout=-1) at ../sysdeps/unix/sysv/linux/poll.c:87 #2 0x0842bd61 in handle_connections_sockets () at mysqld.cc:5562 #3 0x0842a71b in mysqld_main (argc=47, argv=0xb300890) at mysqld.cc:5035 #4 0x084189ff in main (argc=8, argv=0xbfcc1834) at main.cc:24 Thread 2 (Thread 19855): #0 0x00672422 in __kernel_vsyscall () #1 0x00863d5a in do_sigwait (set=0x86bff4, sig=) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:63 #2 0x00863e00 in __sigwait (set=0xb38a9e94, sig=0xb38a9f2c) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:100 #3 0x08423395 in signal_hand (arg=0x0) at mysqld.cc:3046 #4 0x08e7a303 in pfs_spawn_thread (arg=0xb495210) at pfs.cc:1011 #5 0x0085b80e in start_thread (arg=0xb38aa770) at pthread_create.c:300 #6 0x0058f8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 Thread 1 (Thread 19863): #0 0x00672422 in __kernel_vsyscall () #1 0x00860e93 in __pthread_kill (threadid=3012007792, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 #2 0x08d1f00f in my_write_core (sig=6) at stacktrace.c:328 #3 0x08422222 in handle_segfault (sig=6) at mysqld.cc:2843 #4 #5 0x00672422 in __kernel_vsyscall () #6 0x004ed4d1 in *__GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #7 0x004f0932 in *__GI_abort () at abort.c:92 #8 0x004e6648 in *__GI___assert_fail (assertion=0x9052310 "cache", file=0x9052270 "sql_join_cache.cc", line=1883, function=0x9052760 "bool JOIN_CACHE::set_match_flag_if_none(JOIN_TAB*, uchar*)") at assert.c:81 #9 0x084c8b8f in JOIN_CACHE::set_match_flag_if_none (this=0xb759368, first_inner=0xb752e64, rec_ptr=0xb3807022 "") at sql_join_cache.cc:1883 #10 0x084c9314 in JOIN_CACHE::join_null_complements (this=0xb759368, skip_last=false) at sql_join_cache.cc:2079 #11 0x084c7fc6 in JOIN_CACHE::join_records (this=0xb759368, skip_last=false) at sql_join_cache.cc:1661 #12 0x0858303f in sub_select_cache (join=0xb753ad0, join_tab=0xb7531dc, end_of_records=true) at sql_select.cc:16405 #13 0x085834ad in sub_select (join=0xb753ad0, join_tab=0xb753020, end_of_records=true) at sql_select.cc:16568 #14 0x085834ad in sub_select (join=0xb753ad0, join_tab=0xb752e64, end_of_records=true) at sql_select.cc:16568 #15 0x085830c3 in sub_select_cache (join=0xb753ad0, join_tab=0xb752e64, end_of_records=true) at sql_select.cc:16407 #16 0x085834ad in sub_select (join=0xb753ad0, join_tab=0xb752ca8, end_of_records=true) at sql_select.cc:16568 #17 0x08582127 in do_select (join=0xb753ad0, fields=0xb6855a8, table=0x0, procedure=0x0) at sql_select.cc:16159 #18 0x085483c7 in JOIN::exec (this=0xb753ad0) at sql_select.cc:2987 #19 0x085490d1 in mysql_select (thd=0xb684008, rref_pointer_array=0xb685618, tables=0xb5b7e48, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0xb5b9a50, unit=0xb685054, select_lex=0xb685514) at sql_select.cc:3184 #20 0x0853944d in handle_select (thd=0xb684008, lex=0xb684ff8, result=0xb5b9a50, setup_tables_done_option=0) at sql_select.cc:304 #21 0x08459ca5 in execute_sqlcom_select (thd=0xb684008, all_tables=0xb5b7e48) at sql_parse.cc:5032 #22 0x08448b0c in mysql_execute_command (thd=0xb684008) at sql_parse.cc:2295 #23 0x0845dd5a in mysql_parse (thd=0xb684008, inBuf=0xb5b7a88 "SELECT table2 .`col_varchar_1024_utf8_key` \nFROM H table2 LEFT JOIN F table3 JOIN J table4 ON table3 .`col_int_key` = table4 .`pk` LEFT JOIN O table5 ON table5 .`col_varchar_10_latin1_key` O"..., length=276, found_semicolon=0xb3878910) at sql_parse.cc:6060 #24 0x084439ad in dispatch_command (command=COM_QUERY, thd=0xb684008, packet=0xb652eb1 "", packet_length=279) at sql_parse.cc:1091 #25 0x084421c7 in do_command (thd=0xb684008) at sql_parse.cc:775 #26 0x0843e551 in do_handle_one_connection (thd_arg=0xb684008) at sql_connect.cc:1173 #27 0x0843e238 in handle_one_connection (arg=0xb684008) at sql_connect.cc:1113 #28 0x08e7a303 in pfs_spawn_thread (arg=0xb6c5630) at pfs.cc:1011 #29 0x0085b80e in start_thread (arg=0xb3879770) at pthread_create.c:300 #30 0x0058f8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130