==22069== 1 errors in context 2 of 5: ==22069== Thread 13: ==22069== Jump to the invalid address stated on the next line ==22069== at 0x0: ??? ==22069== by 0x8276455: do_select(JOIN*, List*, st_table*, Procedure*) (sql_select.cc:10891) ==22069== by 0x8278CA4: JOIN::exec() (sql_select.cc:2209) ==22069== by 0x81B6388: subselect_single_select_engine::exec() (item_subselect.cc:1962) ==22069== by 0x81B7AAC: Item_subselect::exec() (item_subselect.cc:263) ==22069== by 0x81B5294: Item_singlerow_subselect::val_str(String*) (item_subselect.cc:581) ==22069== by 0x8152DFF: Item::save_in_field(Field*, bool) (item.cc:5115) ==22069== by 0x814D727: Item::save_in_field_no_warnings(Field*, bool) (item.cc:989) ==22069== by 0x82DDF00: get_mm_leaf(RANGE_OPT_PARAM*, Item*, Field*, st_key_part*, Item_func::Functype, Item*) (opt_range.cc:5817) ==22069== by 0x82DE57E: get_mm_parts(RANGE_OPT_PARAM*, Item*, Field*, Item_func::Functype, Item*, Item_result) (opt_range.cc:5624) ==22069== by 0x82EBE18: get_ne_mm_tree(RANGE_OPT_PARAM*, Item_func*, Field*, Item*, Item*, Item_result) (opt_range.cc:5068) ==22069== by 0x82EBEC8: get_func_mm_tree(RANGE_OPT_PARAM*, Item_func*, Field*, Item*, Item_result, bool) (opt_range.cc:5101) ==22069== Address 0x0 is not stack'd, malloc'd or (recently) free'd ==22069== 091001 15:55:23 - mysqld got exception 0xc0000005 ; 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=104857600 read_buffer_size=131072 max_used_connections=4 max_threads=151 threads_connected=3 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 432326 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x16b5d068 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... 0000000000000000 mysqld-debug.exe!??? 00000001402A718C mysqld-debug.exe!sub_select()[sql_select.cc:11134] 00000001402A6C65 mysqld-debug.exe!do_select()[sql_select.cc:10891] 000000014028CEE6 mysqld-debug.exe!JOIN::exec()[sql_select.cc:2209] 00000001402F5CF9 mysqld-debug.exe!subselect_single_select_engine::exec()[item_subselect.cc:1965] 00000001402EF02A mysqld-debug.exe!Item_subselect::exec()[item_subselect.cc:263] 00000001402F027B mysqld-debug.exe!Item_singlerow_subselect::val_str()[item_subselect.cc:581] 00000001401D48D9 mysqld-debug.exe!Item::save_in_field()[item.cc:5115] 00000001401C6A47 mysqld-debug.exe!Item::save_in_field_no_warnings()[item.cc:989] 00000001403D8CEF mysqld-debug.exe!get_mm_leaf()[opt_range.cc:5817] 00000001403D816C mysqld-debug.exe!get_mm_parts()[opt_range.cc:5624] 00000001403D7E67 mysqld-debug.exe!get_ne_mm_tree()[opt_range.cc:5068] 00000001403D7437 mysqld-debug.exe!get_func_mm_tree()[opt_range.cc:5101] 00000001403D7179 mysqld-debug.exe!get_full_func_mm_tree()[opt_range.cc:5406] 00000001403D6F01 mysqld-debug.exe!get_mm_tree()[opt_range.cc:5592] 00000001403D623E mysqld-debug.exe!get_mm_tree()[opt_range.cc:5448] 00000001403D6344 mysqld-debug.exe!get_mm_tree()[opt_range.cc:5465] 00000001403CE747 mysqld-debug.exe!SQL_SELECT::test_quick_select()[opt_range.cc:2331] 000000014028F8FE mysqld-debug.exe!get_quick_record_count()[sql_select.cc:2446] 000000014028F2FF mysqld-debug.exe!make_join_statistics()[sql_select.cc:2855] 00000001402875F3 mysqld-debug.exe!JOIN::optimize()[sql_select.cc:955] 000000014028D7F3 mysqld-debug.exe!mysql_select()[sql_select.cc:2384] 00000001402B8CC7 mysqld-debug.exe!mysql_explain_union()[sql_select.cc:16421] 00000001401F48D9 mysqld-debug.exe!execute_sqlcom_select()[sql_parse.cc:4989] 00000001401EADA4 mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:2206] 00000001401F7520 mysqld-debug.exe!mysql_parse()[sql_parse.cc:5935] 00000001401E86FF mysqld-debug.exe!dispatch_command()[sql_parse.cc:1215] 00000001401E7A57 mysqld-debug.exe!do_command()[sql_parse.cc:854] 00000001400BB6A5 mysqld-debug.exe!handle_one_connection()[sql_connect.cc:1127] 00000001405C66A5 mysqld-debug.exe!pthread_start()[my_winthread.c:85] 000000014059CB85 mysqld-debug.exe!_callthreadstart()[thread.c:295] 000000014059CB57 mysqld-debug.exe!_threadstart()[thread.c:277] 0000000077D6B6CA kernel32.dll!BaseThreadStart() Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 000000001693CF88=explain select `a_tbl600_563`.`c1` as `a_tbl600_563_c1_2819`, `a_tbl97_972`.`c3` as `a_tbl97_972_c3_4866`, `a_tbl97_972`.`c1` as `a_tbl97_972_c1_4864` from tbl600 as `a_tbl600_563`, tbl97 as `a_tbl97_972` where `a_tbl97_972`.`c4` =1 or `a_tbl600_563`.`c1` =`a_tbl97_972`.`c4` and `a_tbl97_972`.`c3` <> ( select geometrytype(`a_tbl463_410`.`c4`) as `d_a_tbl463_410_c4_2057` from tbl364 as `a_tbl364_300`, tbl463 as `a_tbl463_410` where `a_tbl463_410`.`c2` >= @@global.slave_net_timeout ) /*limit 1*/ thd->thread_id=30 thd->killed=KILL_CONNECTION The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains