Server [mysqld.1 - pid: 2878, winpid: 2878, exit: 256] failed during test run Server log from this test: 100324 19:02:44 [Warning] '--default-character-set' is deprecated and will be removed in a future release. Please use '--character-set-server' instead. 100324 19:02:44 [Note] Plugin 'FEDERATED' is disabled. 100324 19:02:44 [Note] Plugin 'InnoDB' is disabled. 100324 19:02:44 [Note] Plugin 'ndbcluster' is disabled. 100324 19:02:44 [Note] Event Scheduler: Loaded 0 events 100324 19:02:44 [Note] /mysql-5.1/sql/mysqld: ready for connections. Version: '5.1.46-gcov-debug-log' socket: '/mysql-5.1/mysql-test/var/tmp/mysqld.1.sock' port: 13000 Source distribution mysqld: sql_base.cc:1375: bool close_thread_table(THD*, TABLE**): Assertion `!table->file || table->file->inited == handler::NONE' failed. 100324 19:02:44 - 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 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 59976 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xac597d8 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 = 0xb6f1438c thread_stack 0x30000 /mysql-5.1/sql/mysqld(my_print_stacktrace+0x42)[0x8cbd71e] /mysql-5.1/sql/mysqld(handle_segfault+0x4a8)[0x83cf5bd] [0x3a0400] /lib/tls/i686/cmov/libc.so.6(abort+0x182)[0x1ad932] /lib/tls/i686/cmov/libc.so.6(__assert_fail+0xf8)[0x1a3648] /mysql-5.1/sql/mysqld(_Z18close_thread_tableP3THDPP8st_table+0x16e)[0x848ece7] /mysql-5.1/sql/mysqld[0x848e109] /mysql-5.1/sql/mysqld(_Z19close_thread_tablesP3THD+0x72f)[0x848e9eb] /mysql-5.1/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x37d6)[0x83f2b2f] /mysql-5.1/sql/mysqld(_Z10do_commandP3THD+0x4f6)[0x83eec2f] /mysql-5.1/sql/mysqld(handle_one_connection+0x2fe)[0x83eb29b] /lib/tls/i686/cmov/libpthread.so.0[0xf6b80e] /lib/tls/i686/cmov/libc.so.6(clone+0x5e)[0x24c8de] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xacab058 = SELECT `col_varchar_key` , MAX( `col_varchar_key` ) FROM D HAVING ( 1 , 2 ) IN ( SELECT `pk` , `col_int_key` FROM CC HAVING `col_int_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-5.1/mysql-test/var/log/main.exp2/' to '/mysql-5.1/mysql-test/var/log/main.exp2/' - found 'core' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Core generated by '/mysql-5.1/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 2881] [New Thread 2879] warning: Can't read pathname for load map: Input/output error. Core was generated by `/mysql-5.1/sql/mysqld --defaults-group-suffix=.1'. Program terminated with signal 6, Aborted. #0 0x003a0422 in __kernel_vsyscall () #0 0x003a0422 in __kernel_vsyscall () #1 0x00f70e93 in __pthread_kill (threadid=3069266800, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 #2 0x08cbd8a6 in my_write_core (sig=6) at stacktrace.c:329 #3 0x083cfad2 in handle_segfault (sig=6) at mysqld.cc:2570 #4 #5 0x003a0422 in __kernel_vsyscall () #6 0x001aa4d1 in *__GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #7 0x001ad932 in *__GI_abort () at abort.c:92 #8 0x001a3648 in *__GI___assert_fail (assertion=0x8ea0bd4 "!table->file || table->file->inited == handler::NONE", file=0x8ea0680 "sql_base.cc", line=1375, function=0x8ea3500 "bool close_thread_table(THD*, TABLE**)") at assert.c:81 #9 0x0848ece7 in close_thread_table (thd=0xac597d8, table_ptr=0xac59824) at sql_base.cc:1375 #10 0x0848e109 in close_open_tables (thd=0xac597d8) at sql_base.cc:1199 #11 0x0848e9eb in close_thread_tables (thd=0xac597d8) at sql_base.cc:1351 #12 0x083f2b2f in dispatch_command (command=COM_QUERY, thd=0xac597d8, packet=0xac9f111 "", packet_length=162) at sql_parse.cc:1628 #13 0x083eec2f in do_command (thd=0xac597d8) at sql_parse.cc:874 #14 0x083eb29b in handle_one_connection (arg=0xac597d8) at sql_connect.cc:1127 #15 0x00f6b80e in start_thread (arg=0xb6f14b70) at pthread_create.c:300 #16 0x0024c8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 Thread 3 (Thread 2879): #0 0x003a0422 in __kernel_vsyscall () #1 0x00245a71 in select () from /lib/tls/i686/cmov/libc.so.6 #2 0x083d90f5 in handle_connections_sockets (arg=0x0) at mysqld.cc:5054 #3 0x083d76bf in main (argc=8, argv=0xbfdbaaa4) at mysqld.cc:4538 Thread 2 (Thread 2881): #0 0x003a0422 in __kernel_vsyscall () #1 0x00f73d5a in do_sigwait (set=0xf7bff4, sig=) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:63 #2 0x00f73e00 in __sigwait (set=0xb6f452f0, sig=0xb6f45388) at ../nptl/sysdeps/unix/sysv/linux/../../../../../sysdeps/unix/sysv/linux/sigwait.c:100 #3 0x083d0e74 in signal_hand (arg=0x0) at mysqld.cc:2772 #4 0x00f6b80e in start_thread (arg=0xb6f45b70) at pthread_create.c:300 #5 0x0024c8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130 Thread 1 (Thread 2889): #0 0x003a0422 in __kernel_vsyscall () #1 0x00f70e93 in __pthread_kill (threadid=3069266800, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:64 #2 0x08cbd8a6 in my_write_core (sig=6) at stacktrace.c:329 #3 0x083cfad2 in handle_segfault (sig=6) at mysqld.cc:2570 #4 #5 0x003a0422 in __kernel_vsyscall () #6 0x001aa4d1 in *__GI_raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #7 0x001ad932 in *__GI_abort () at abort.c:92 #8 0x001a3648 in *__GI___assert_fail (assertion=0x8ea0bd4 "!table->file || table->file->inited == handler::NONE", file=0x8ea0680 "sql_base.cc", line=1375, function=0x8ea3500 "bool close_thread_table(THD*, TABLE**)") at assert.c:81 #9 0x0848ece7 in close_thread_table (thd=0xac597d8, table_ptr=0xac59824) at sql_base.cc:1375 #10 0x0848e109 in close_open_tables (thd=0xac597d8) at sql_base.cc:1199 #11 0x0848e9eb in close_thread_tables (thd=0xac597d8) at sql_base.cc:1351 #12 0x083f2b2f in dispatch_command (command=COM_QUERY, thd=0xac597d8, packet=0xac9f111 "", packet_length=162) at sql_parse.cc:1628 #13 0x083eec2f in do_command (thd=0xac597d8) at sql_parse.cc:874 #14 0x083eb29b in handle_one_connection (arg=0xac597d8) at sql_connect.cc:1127 #15 0x00f6b80e in start_thread (arg=0xb6f14b70) at pthread_create.c:300 #16 0x0024c8de in clone () at ../sysdeps/unix/sysv/linux/i386/clone.S:130