mysqld: sql_select.cc:11782: int join_read_key(JOIN_TAB*): Assertion `tab->ref.has_record' failed. 091112 3:12:18 - 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 = 59975 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xb0a1f58 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 = 0xb747e3a4 thread_stack 0x30000 mysql-5.1/sql/mysqld(my_print_stacktrace+0x63)[0x91075bc] mysql-5.1/sql/mysqld(handle_segfault+0x5e4)[0x847b9b4] [0xb7fbd400] /lib/tls/i686/cmov/libc.so.6(abort+0x188)[0xb7dd2098] /lib/tls/i686/cmov/libc.so.6(__assert_fail+0xee)[0xb7dc95ce] mysql-5.1/sql/mysqld[0x86104ed] mysql-5.1/sql/mysqld(_Z10sub_selectP4JOINP13st_join_tableb+0x212)[0x860b28c] mysql-5.1/sql/mysqld[0x863b876] mysql-5.1/sql/mysqld(_ZN4JOIN4execEv+0x5768)[0x86699c0] mysql-5.1/sql/mysqld(_ZN30subselect_single_select_engine4execEv+0xfd8)[0x839a5c2] mysql-5.1/sql/mysqld(_ZN14Item_subselect4execEv+0x129)[0x83a87db] mysql-5.1/sql/mysqld(_ZN17Item_in_subselect8val_boolEv+0xa4)[0x8395236] mysql-5.1/sql/mysqld(_ZN4Item15val_bool_resultEv+0x43)[0x825b601] mysql-5.1/sql/mysqld(_ZN17Item_in_optimizer7val_intEv+0x59f)[0x82e6011] mysql-5.1/sql/mysqld(_ZN4Item8val_boolEv+0xa7)[0x822d5e1] mysql-5.1/sql/mysqld(_ZN13Item_func_not7val_intEv+0xa5)[0x82e6507] mysql-5.1/sql/mysqld(_ZN10SQL_SELECT11skip_recordEv+0x58)[0x866af84] mysql-5.1/sql/mysqld[0x881cb83] mysql-5.1/sql/mysqld(_Z8filesortP3THDP8st_tableP13st_sort_fieldjP10SQL_SELECTybPy+0x1108)[0x881ea0f] mysql-5.1/sql/mysqld[0x861e2a4] mysql-5.1/sql/mysqld(_ZN4JOIN4execEv+0x5070)[0x86692c8] mysql-5.1/sql/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x803)[0x865ad51] mysql-5.1/sql/mysqld(_Z13handle_selectP3THDP6st_lexP13select_resultm+0x3eb)[0x866a10c] mysql-5.1/sql/mysqld[0x84ae6b5] mysql-5.1/sql/mysqld(_Z21mysql_execute_commandP3THD+0x1b60)[0x84b47c6] mysql-5.1/sql/mysqld(_Z11mysql_parseP3THDPKcjPS2_+0x969)[0x84d31cc] mysql-5.1/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x23f5)[0x84d5c81] mysql-5.1/sql/mysqld(_Z10do_commandP3THD+0x654)[0x84d9c6b] mysql-5.1/sql/mysqld(handle_one_connection+0x3ba)[0x849b826] /lib/tls/i686/cmov/libpthread.so.0[0xb7f9a4ff] /lib/tls/i686/cmov/libc.so.6(clone+0x5e)[0xb7e8949e] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0xb0d2b10 = SELECT `int_key` FROM C WHERE `int_key` != ALL ( SELECT SUBQUERY3_t1 .`pk` FROM CC SUBQUERY3_t1 JOIN C SUBQUERY3_t2 ON SUBQUERY3_t2 .`int_key` ) ORDER BY `pk` 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). -------------------------- 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. [New process 4062] [New process 4048] [New process 4046] #0 0xb7fbd430 in __kernel_vsyscall () #0 0xb7fbd430 in __kernel_vsyscall () #1 0xb7f9f1c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0910782b in my_write_core (sig=6) at stacktrace.c:310 #3 0x0847c068 in handle_segfault (sig=6) at mysqld.cc:2570 #4 #5 0xb7fbd430 in __kernel_vsyscall () #6 0xb7dd06d0 in raise () from /lib/tls/i686/cmov/libc.so.6 #7 0xb7dd2098 in abort () from /lib/tls/i686/cmov/libc.so.6 #8 0xb7dc95ce in __assert_fail () from /lib/tls/i686/cmov/libc.so.6 #9 0x086104ed in join_read_key (tab=0xb0dff28) at sql_select.cc:11782 #10 0x0860b28c in sub_select (join=0xb0e0758, join_tab=0xb0dff28, end_of_records=false) at sql_select.cc:11247 #11 0x0863b876 in do_select (join=0xb0e0758, fields=0xb0d30c4, table=0x0, procedure=0x0) at sql_select.cc:11004 #12 0x086699c0 in JOIN::exec (this=0xb0e0758) at sql_select.cc:2255 #13 0x0839a5c2 in subselect_single_select_engine::exec (this=0xb0d3ce8) at item_subselect.cc:1968 #14 0x083a87db in Item_subselect::exec (this=0xb0d3c38) at item_subselect.cc:261 #15 0x08395236 in Item_in_subselect::val_bool (this=0xb0d3c38) at item_subselect.cc:861 #16 0x0825b601 in Item::val_bool_result (this=0xb0d3c38) at item.h:738 #17 0x082e6011 in Item_in_optimizer::val_int (this=0xb0d3fd0) at item_cmpfunc.cc:1703 #18 0x0822d5e1 in Item::val_bool (this=0xb0d3fd0) at item.cc:184 #19 0x082e6507 in Item_func_not::val_int (this=0xb0d3d10) at item_cmpfunc.cc:284 #20 0x0866af84 in SQL_SELECT::skip_record (this=0xb0d4920) at opt_range.h:711 #21 0x0881cb83 in find_all_keys (param=0xb747c66c, select=0xb0d4920, sort_keys=0xb0f3950, buffpek_pointers=0xb747c73c, tempfile=0xb747c800, indexfile=0x0) at filesort.cc:607 #22 0x0881ea0f in filesort (thd=0xb0a1f58, table=0xb0f56a8, sortorder=0xb0d4a28, s_length=1, select=0xb0d4920, max_rows=18446744073709551615, sort_positions=false, examined_rows=0xb747c948) at filesort.cc:243 #23 0x0861e2a4 in create_sort_index (thd=0xb0a1f58, join=0xb0de770, order=0xb0d3e28, filesort_limit=18446744073709551615, select_limit=18446744073709551615, is_order_by=false) at sql_select.cc:13653 #24 0x086692c8 in JOIN::exec (this=0xb0de770) at sql_select.cc:2198 #25 0x0865ad51 in mysql_select (thd=0xb0a1f58, rref_pointer_array=0xb0a33f4, tables=0xb0d2d98, wild_num=0, fields=@0xb0a3390, conds=0xb0d3d10, og_num=1, order=0xb0d3e28, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb0d3ec8, unit=0xb0a308c, select_lex=0xb0a32fc) at sql_select.cc:2444 #26 0x0866a10c in handle_select (thd=0xb0a1f58, lex=0xb0a3030, result=0xb0d3ec8, setup_tables_done_option=0) at sql_select.cc:269 #27 0x084ae6b5 in execute_sqlcom_select (thd=0xb0a1f58, all_tables=0xb0d2d98) at sql_parse.cc:5051 #28 0x084b47c6 in mysql_execute_command (thd=0xb0a1f58) at sql_parse.cc:2246 #29 0x084d31cc in mysql_parse (thd=0xb0a1f58, inBuf=0xb0d2b10 "SELECT `int_key` \nFROM C \nWHERE `int_key` != ALL ( \nSELECT SUBQUERY3_t1 .`pk` \nFROM CC SUBQUERY3_t1 JOIN C SUBQUERY3_t2 ON SUBQUERY3_t2 .`int_key` ) \nORDER BY `pk`", length=174, found_semicolon=0xb747e050) at sql_parse.cc:5970 #30 0x084d5c81 in dispatch_command (command=COM_QUERY, thd=0xb0a1f58, packet=0xb0c6c81 "SELECT `int_key` \nFROM C \nWHERE `int_key` != ALL ( \nSELECT SUBQUERY3_t1 .`pk` \nFROM CC SUBQUERY3_t1 JOIN C SUBQUERY3_t2 ON SUBQUERY3_t2 .`int_key` ) \nORDER BY `pk` ", packet_length=177) at sql_parse.cc:1231 #31 0x084d9c6b in do_command (thd=0xb0a1f58) at sql_parse.cc:872 #32 0x0849b826 in handle_one_connection (arg=0xb0a1f58) at sql_connect.cc:1127 #33 0xb7f9a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #34 0xb7e8949e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 3 (process 4046): #0 0xb7fbd430 in __kernel_vsyscall () #1 0xb7e817b1 in select () from /lib/tls/i686/cmov/libc.so.6 #2 0x0847de08 in handle_connections_sockets (arg=0x0) at mysqld.cc:5054 #3 0x0848be95 in main (argc=8, argv=0xbfad9b64) at mysqld.cc:4538 Thread 2 (process 4048): #0 0xb7fbd430 in __kernel_vsyscall () #1 0xb7fa2300 in sigwait () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x084791d6 in signal_hand (arg=0x0) at mysqld.cc:2772 #3 0xb7f9a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #4 0xb7e8949e in clone () from /lib/tls/i686/cmov/libc.so.6 Thread 1 (process 4062): #0 0xb7fbd430 in __kernel_vsyscall () #1 0xb7f9f1c8 in pthread_kill () from /lib/tls/i686/cmov/libpthread.so.0 #2 0x0910782b in my_write_core (sig=6) at stacktrace.c:310 #3 0x0847c068 in handle_segfault (sig=6) at mysqld.cc:2570 #4 #5 0xb7fbd430 in __kernel_vsyscall () #6 0xb7dd06d0 in raise () from /lib/tls/i686/cmov/libc.so.6 #7 0xb7dd2098 in abort () from /lib/tls/i686/cmov/libc.so.6 #8 0xb7dc95ce in __assert_fail () from /lib/tls/i686/cmov/libc.so.6 #9 0x086104ed in join_read_key (tab=0xb0dff28) at sql_select.cc:11782 #10 0x0860b28c in sub_select (join=0xb0e0758, join_tab=0xb0dff28, end_of_records=false) at sql_select.cc:11247 #11 0x0863b876 in do_select (join=0xb0e0758, fields=0xb0d30c4, table=0x0, procedure=0x0) at sql_select.cc:11004 #12 0x086699c0 in JOIN::exec (this=0xb0e0758) at sql_select.cc:2255 #13 0x0839a5c2 in subselect_single_select_engine::exec (this=0xb0d3ce8) at item_subselect.cc:1968 #14 0x083a87db in Item_subselect::exec (this=0xb0d3c38) at item_subselect.cc:261 #15 0x08395236 in Item_in_subselect::val_bool (this=0xb0d3c38) at item_subselect.cc:861 #16 0x0825b601 in Item::val_bool_result (this=0xb0d3c38) at item.h:738 #17 0x082e6011 in Item_in_optimizer::val_int (this=0xb0d3fd0) at item_cmpfunc.cc:1703 #18 0x0822d5e1 in Item::val_bool (this=0xb0d3fd0) at item.cc:184 #19 0x082e6507 in Item_func_not::val_int (this=0xb0d3d10) at item_cmpfunc.cc:284 #20 0x0866af84 in SQL_SELECT::skip_record (this=0xb0d4920) at opt_range.h:711 #21 0x0881cb83 in find_all_keys (param=0xb747c66c, select=0xb0d4920, sort_keys=0xb0f3950, buffpek_pointers=0xb747c73c, tempfile=0xb747c800, indexfile=0x0) at filesort.cc:607 #22 0x0881ea0f in filesort (thd=0xb0a1f58, table=0xb0f56a8, sortorder=0xb0d4a28, s_length=1, select=0xb0d4920, max_rows=18446744073709551615, sort_positions=false, examined_rows=0xb747c948) at filesort.cc:243 #23 0x0861e2a4 in create_sort_index (thd=0xb0a1f58, join=0xb0de770, order=0xb0d3e28, filesort_limit=18446744073709551615, select_limit=18446744073709551615, is_order_by=false) at sql_select.cc:13653 #24 0x086692c8 in JOIN::exec (this=0xb0de770) at sql_select.cc:2198 #25 0x0865ad51 in mysql_select (thd=0xb0a1f58, rref_pointer_array=0xb0a33f4, tables=0xb0d2d98, wild_num=0, fields=@0xb0a3390, conds=0xb0d3d10, og_num=1, order=0xb0d3e28, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb0d3ec8, unit=0xb0a308c, select_lex=0xb0a32fc) at sql_select.cc:2444 #26 0x0866a10c in handle_select (thd=0xb0a1f58, lex=0xb0a3030, result=0xb0d3ec8, setup_tables_done_option=0) at sql_select.cc:269 #27 0x084ae6b5 in execute_sqlcom_select (thd=0xb0a1f58, all_tables=0xb0d2d98) at sql_parse.cc:5051 #28 0x084b47c6 in mysql_execute_command (thd=0xb0a1f58) at sql_parse.cc:2246 #29 0x084d31cc in mysql_parse (thd=0xb0a1f58, inBuf=0xb0d2b10 "SELECT `int_key` \nFROM C \nWHERE `int_key` != ALL ( \nSELECT SUBQUERY3_t1 .`pk` \nFROM CC SUBQUERY3_t1 JOIN C SUBQUERY3_t2 ON SUBQUERY3_t2 .`int_key` ) \nORDER BY `pk`", length=174, found_semicolon=0xb747e050) at sql_parse.cc:5970 #30 0x084d5c81 in dispatch_command (command=COM_QUERY, thd=0xb0a1f58, packet=0xb0c6c81 "SELECT `int_key` \nFROM C \nWHERE `int_key` != ALL ( \nSELECT SUBQUERY3_t1 .`pk` \nFROM CC SUBQUERY3_t1 JOIN C SUBQUERY3_t2 ON SUBQUERY3_t2 .`int_key` ) \nORDER BY `pk` ", packet_length=177) at sql_parse.cc:1231 #31 0x084d9c6b in do_command (thd=0xb0a1f58) at sql_parse.cc:872 #32 0x0849b826 in handle_one_connection (arg=0xb0a1f58) at sql_connect.cc:1127 #33 0xb7f9a4ff in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #34 0xb7e8949e in clone () from /lib/tls/i686/cmov/libc.so.6