Version: '5.1.38-enterprise-gpl-advanced-debug' socket: '' port: 3306 MySQL Enterprise Server - Advanced Edition Debug (GPL) 090928 8:15:29 - 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=8384512 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 = 337714 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x314ecf0 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... 004FE5A2 mysqld-debug.exe!Item_func::fix_fields()[item_func.cc:171] 0048B411 mysqld-debug.exe!Item_cond::fix_fields()[item_cmpfunc.cc:3914] 00526AB8 mysqld-debug.exe!setup_conds()[sql_base.cc:7989] 006399EA mysqld-debug.exe!setup_without_group()[sql_select.cc:412] 0060F82B mysqld-debug.exe!JOIN::prepare()[sql_select.cc:501] 0066BA32 mysqld-debug.exe!subselect_single_select_engine::prepare()[item_subselect.cc:1770] 00666515 mysqld-debug.exe!Item_subselect::fix_fields()[item_subselect.cc:158] 0066B22E mysqld-debug.exe!Item_in_subselect::fix_fields()[item_subselect.cc:1628] 00482C32 mysqld-debug.exe!Item_in_optimizer::fix_fields()[item_cmpfunc.cc:1527] 0048B411 mysqld-debug.exe!Item_cond::fix_fields()[item_cmpfunc.cc:3914] 00526AB8 mysqld-debug.exe!setup_conds()[sql_base.cc:7989] 006399EA mysqld-debug.exe!setup_without_group()[sql_select.cc:412] 0060F82B mysqld-debug.exe!JOIN::prepare()[sql_select.cc:501] 00615814 mysqld-debug.exe!mysql_select()[sql_select.cc:2377] 0060F14D mysqld-debug.exe!handle_select()[sql_select.cc:268] 0059C08F mysqld-debug.exe!execute_sqlcom_select()[sql_parse.cc:5011] 0059467E mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:2206] 00696B60 mysqld-debug.exe!sp_instr_stmt::exec_core()[sp_head.cc:2905] 00695E2A mysqld-debug.exe!sp_lex_keeper::reset_lex_and_exec_core()[sp_head.cc:2734] 0069623A mysqld-debug.exe!sp_instr_stmt::execute()[sp_head.cc:2848] 00691973 mysqld-debug.exe!sp_head::execute()[sp_head.cc:1252] 00693751 mysqld-debug.exe!sp_head::execute_procedure()[sp_head.cc:1982] 005996A6 mysqld-debug.exe!mysql_execute_command()[sql_parse.cc:4352] 0059E1F1 mysqld-debug.exe!mysql_parse()[sql_parse.cc:5931] 0059268E mysqld-debug.exe!dispatch_command()[sql_parse.cc:1213] 00591D04 mysqld-debug.exe!do_command()[sql_parse.cc:854] 0049C358 mysqld-debug.exe!handle_one_connection()[sql_connect.cc:1127] 008A5C06 mysqld-debug.exe!pthread_start()[my_winthread.c:85] 00881C11 mysqld-debug.exe!_callthreadstart()[thread.c:293] 00881BB7 mysqld-debug.exe!_threadstart()[thread.c:277] 76A9D0E9 kernel32.dll!BaseThreadInitThunk() 774B19BB ntdll.dll!RtlInitializeExceptionChain() 774B198E ntdll.dll!RtlInitializeExceptionChain() Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 03188B08=SELECT f1 FROM t3 AS A WHERE A.f1 IN ( SELECT f1 FROM t3 ) thd->thread_id=1 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. Z:\mysql-advanced-gpl-5.1.38-win32\bin>