Server [mysqld.1 - pid: 4519, winpid: 4519, exit: 256] failed during test run Server log from this test: 091211 19:29:38 [Note] Plugin 'FEDERATED' is disabled. 091211 19:29:38 [Note] Plugin 'InnoDB' is disabled. 091211 19:29:38 [Note] Plugin 'ndbcluster' is disabled. 091211 19:29:38 [Note] Event Scheduler: Loaded 0 events 091211 19:29:38 [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 091211 19:29:38 - mysqld got signal 11 ; 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 = 60109 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x9cefbe0 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 = 0xb6e07f7c thread_stack 0x30c00 /mysql-6.0/sql/mysqld(my_print_stacktrace+0x42) [0x8ca1cfe] /mysql-6.0/sql/mysqld(handle_segfault+0x4e3) [0x8403661] [0x2f5400] /mysql-6.0/sql/mysqld(JOIN::exec()+0x1052) [0x8518c3e] /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) [0x851c8a0] /mysql-6.0/sql/mysqld(mysql_explain_union(THD*, st_select_lex_unit*, select_result*)+0x5d9) [0x8575500] /mysql-6.0/sql/mysqld(select_describe(JOIN*, bool, bool, bool, char const*)+0x5163) [0x8574db4] /mysql-6.0/sql/mysqld(JOIN::exec()+0x1052) [0x8518c3e] /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) [0x851c8a0] /mysql-6.0/sql/mysqld(mysql_explain_union(THD*, st_select_lex_unit*, select_result*)+0x5d9) [0x8575500] /mysql-6.0/sql/mysqld(select_describe(JOIN*, bool, bool, bool, char const*)+0x5163) [0x8574db4] /mysql-6.0/sql/mysqld [0x853eee0] /mysql-6.0/sql/mysqld(JOIN::exec()+0xacd) [0x85186b9] /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) [0x851c8a0] /mysql-6.0/sql/mysqld(mysql_explain_union(THD*, st_select_lex_unit*, select_result*)+0x5d9) [0x8575500] /mysql-6.0/sql/mysqld [0x843a11e] /mysql-6.0/sql/mysqld(mysql_execute_command(THD*)+0x1427) [0x8428960] /mysql-6.0/sql/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x545) [0x843e792] /mysql-6.0/sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x12eb) [0x8423aef] /mysql-6.0/sql/mysqld(do_command(THD*)+0x492) [0x8422313] /mysql-6.0/sql/mysqld(handle_one_connection+0x300) [0x841f884] /lib/tls/i686/cmov/libpthread.so.0 [0xcde80e] /lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0x8287ee] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x9cb88d0 = EXPLAIN SELECT table2 .`col_datetime_key` FROM C table1 JOIN CC table2 ON table1 .`col_varchar_key` WHERE ( 'i' , 'b' ) IN ( SELECT `col_varchar_nokey` , `col_varchar_key` FROM CC WHERE ( `col_varchar_key` , `col_varchar_key` ) IN ( SELECT `col_varchar_nokey` CHILD_SUBQUERY1_field1 , `col_varchar_nokey` FROM D GROUP BY child_subquery1_field1 ) ) 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 4520] [New Thread 4522] warning: Can't read pathname for load map: Input/output error. Core was generated by `/mysql-6.0/sql/mysqld --defaults-group-suffix'. Program terminated with signal 11, Segmentation fault. #0 0x002f5422 in __kernel_vsyscall () #0 0x002f5422 in __kernel_vsyscall () #1 0x00ce3e93 in __pthread_kill (threadid=3068168048, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 #2 0x08ca1f17 in my_write_core (sig=11) at stacktrace.c:309 #3 0x08403b76 in handle_segfault (sig=11) at mysqld.cc:2765 #4 #5 0x085714fe in select_describe (join=0x9da1600, need_tmp_table=true, need_order=true, distinct=false, message=0x0) at sql_select.cc:21805 #6 0x08518c3e in JOIN::exec (this=0x9da1600) at sql_select.cc:2483 #7 0x0851c8a0 in mysql_select (thd=0x9cefbe0, rref_pointer_array=0x9cbae24, tables=0x9cbb440, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x0, group=0x9cbb920, having=0x0, proc_param=0x0, select_options=2147748356, result=0x9cbbba0, unit=0x9cbaeb0, select_lex=0x9cbad20) at sql_select.cc:3135 #8 0x08575500 in mysql_explain_union (thd=0x9cefbe0, unit=0x9cbaeb0, result=0x9cbbba0) at sql_select.cc:22230 #9 0x08574db4 in select_describe (join=0x9d9c7a0, need_tmp_table=false, need_order=false, distinct=false, message=0x0) at sql_select.cc:22171 #10 0x08518c3e in JOIN::exec (this=0x9d9c7a0) at sql_select.cc:2483 #11 0x0851c8a0 in mysql_select (thd=0x9cefbe0, rref_pointer_array=0x9cb9dcc, tables=0x9cba900, wild_num=0, fields=..., conds=0x9da6b58, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748356, result=0x9cbbba0, unit=0x9cb9e60, select_lex=0x9cb9cc8) at sql_select.cc:3135 #12 0x08575500 in mysql_explain_union (thd=0x9cefbe0, unit=0x9cb9e60, result=0x9cbbba0) at sql_select.cc:22230 #13 0x08574db4 in select_describe (join=0x9d97940, need_tmp_table=false, need_order=false, distinct=false, message=0x8fb3a13 "Impossible WHERE") at sql_select.cc:22171 #14 0x0853eee0 in return_zero_rows (join=0x9d97940, result=0x9cbbba0, tables=0x9cb8d38, fields=..., send_row=false, select_options=2147748356, info=0x8fb3a13 "Impossible WHERE", having=0x0) at sql_select.cc:11029 #15 0x085186b9 in JOIN::exec (this=0x9d97940) at sql_select.cc:2445 #16 0x0851c8a0 in mysql_select (thd=0x9cefbe0, rref_pointer_array=0x9cf1144, tables=0x9cb8d38, wild_num=0, fields=..., conds=0x9cbba40, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748356, result=0x9cbbba0, unit=0x9cf0b88, select_lex=0x9cf1040) at sql_select.cc:3135 #17 0x08575500 in mysql_explain_union (thd=0x9cefbe0, unit=0x9cf0b88, result=0x9cbbba0) at sql_select.cc:22230 #18 0x0843a11e in execute_sqlcom_select (thd=0x9cefbe0, all_tables=0x9cb8d38) at sql_parse.cc:4939 #19 0x08428960 in mysql_execute_command (thd=0x9cefbe0) at sql_parse.cc:2156 #20 0x0843e792 in mysql_parse (thd=0x9cefbe0, inBuf=0x9cb88d0 "EXPLAIN \nSELECT table2 .`col_datetime_key` \nFROM C table1 JOIN CC table2 ON table1 .`col_varchar_key` \nWHERE ( 'i' , 'b' ) IN ( \nSELECT `col_varchar_nokey` , `col_varchar_key` \nFROM CC \nWHER"..., length=376, found_semicolon=0xb6e0798c) at sql_parse.cc:5975 #21 0x08423aef in dispatch_command (command=COM_QUERY, thd=0x9cefbe0, packet=0x9cbead1 "", packet_length=379) at sql_parse.cc:1076 #22 0x08422313 in do_command (thd=0x9cefbe0) at sql_parse.cc:758 #23 0x0841f884 in handle_one_connection (arg=0x9cefbe0) at sql_connect.cc:1164 #24 0x00cde80e in start_thread (arg=0xb6e08770) at pthread_create.c:300 #25 0x008287ee in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 Thread 3 (Thread 4522): #0 0x002f5422 in __kernel_vsyscall () #1 0x00ce6d5a in do_sigwait (set=0xceeff4, sig=) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:63 #2 0x00ce6e00 in __sigwait (set=0xb6e38ee4, sig=0xb6e38f7c) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:100 #3 0x08404cde in signal_hand (arg=0x0) at mysqld.cc:2967 #4 0x00cde80e in start_thread (arg=0xb6e39770) at pthread_create.c:300 #5 0x008287ee in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 Thread 2 (Thread 4520): #0 0x002f5422 in __kernel_vsyscall () #1 0x00821981 in select () from /lib/tls/i686/cmov/libc.so.6 #2 0x0840cf75 in handle_connections_sockets () at mysqld.cc:5363 #3 0x0840b8b5 in main (argc=8, argv=0xbf89ee04) at mysqld.cc:4856 Thread 1 (Thread 4532): #0 0x002f5422 in __kernel_vsyscall () #1 0x00ce3e93 in __pthread_kill (threadid=3068168048, signo=11) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 #2 0x08ca1f17 in my_write_core (sig=11) at stacktrace.c:309 #3 0x08403b76 in handle_segfault (sig=11) at mysqld.cc:2765 #4 #5 0x085714fe in select_describe (join=0x9da1600, need_tmp_table=true, need_order=true, distinct=false, message=0x0) at sql_select.cc:21805 #6 0x08518c3e in JOIN::exec (this=0x9da1600) at sql_select.cc:2483 #7 0x0851c8a0 in mysql_select (thd=0x9cefbe0, rref_pointer_array=0x9cbae24, tables=0x9cbb440, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x0, group=0x9cbb920, having=0x0, proc_param=0x0, select_options=2147748356, result=0x9cbbba0, unit=0x9cbaeb0, select_lex=0x9cbad20) at sql_select.cc:3135 #8 0x08575500 in mysql_explain_union (thd=0x9cefbe0, unit=0x9cbaeb0, result=0x9cbbba0) at sql_select.cc:22230 #9 0x08574db4 in select_describe (join=0x9d9c7a0, need_tmp_table=false, need_order=false, distinct=false, message=0x0) at sql_select.cc:22171 #10 0x08518c3e in JOIN::exec (this=0x9d9c7a0) at sql_select.cc:2483 #11 0x0851c8a0 in mysql_select (thd=0x9cefbe0, rref_pointer_array=0x9cb9dcc, tables=0x9cba900, wild_num=0, fields=..., conds=0x9da6b58, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748356, result=0x9cbbba0, unit=0x9cb9e60, select_lex=0x9cb9cc8) at sql_select.cc:3135 #12 0x08575500 in mysql_explain_union (thd=0x9cefbe0, unit=0x9cb9e60, result=0x9cbbba0) at sql_select.cc:22230 #13 0x08574db4 in select_describe (join=0x9d97940, need_tmp_table=false, need_order=false, distinct=false, message=0x8fb3a13 "Impossible WHERE") at sql_select.cc:22171 #14 0x0853eee0 in return_zero_rows (join=0x9d97940, result=0x9cbbba0, tables=0x9cb8d38, fields=..., send_row=false, select_options=2147748356, info=0x8fb3a13 "Impossible WHERE", having=0x0) at sql_select.cc:11029 #15 0x085186b9 in JOIN::exec (this=0x9d97940) at sql_select.cc:2445 #16 0x0851c8a0 in mysql_select (thd=0x9cefbe0, rref_pointer_array=0x9cf1144, tables=0x9cb8d38, wild_num=0, fields=..., conds=0x9cbba40, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748356, result=0x9cbbba0, unit=0x9cf0b88, select_lex=0x9cf1040) at sql_select.cc:3135 #17 0x08575500 in mysql_explain_union (thd=0x9cefbe0, unit=0x9cf0b88, result=0x9cbbba0) at sql_select.cc:22230 #18 0x0843a11e in execute_sqlcom_select (thd=0x9cefbe0, all_tables=0x9cb8d38) at sql_parse.cc:4939 #19 0x08428960 in mysql_execute_command (thd=0x9cefbe0) at sql_parse.cc:2156 #20 0x0843e792 in mysql_parse (thd=0x9cefbe0, inBuf=0x9cb88d0 "EXPLAIN \nSELECT table2 .`col_datetime_key` \nFROM C table1 JOIN CC table2 ON table1 .`col_varchar_key` \nWHERE ( 'i' , 'b' ) IN ( \nSELECT `col_varchar_nokey` , `col_varchar_key` \nFROM CC \nWHER"..., length=376, found_semicolon=0xb6e0798c) at sql_parse.cc:5975 #21 0x08423aef in dispatch_command (command=COM_QUERY, thd=0x9cefbe0, packet=0x9cbead1 "", packet_length=379) at sql_parse.cc:1076 #22 0x08422313 in do_command (thd=0x9cefbe0) at sql_parse.cc:758 #23 0x0841f884 in handle_one_connection (arg=0x9cefbe0) at sql_connect.cc:1164 #24 0x00cde80e in start_thread (arg=0xb6e08770) at pthread_create.c:300 #25 0x008287ee in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130