5.0.48-debug-nt ---------------- mysqld-debug.exe!Gis_read_stream::get_next_word(st_lex_string * res=0x0514dbf4) Line 47 + 0x5 bytes C++ mysqld-debug.exe!Geometry::create_from_wkt(Geometry_buffer * buffer=0x0514dc70, Gis_read_stream * trs=0x0514dc38, String * wkt=0x0514dd8c, int init_stream=0x00000000) Line 171 + 0xc bytes C++ mysqld-debug.exe!Item_func_geometry_from_text::val_str(String * str=0x0514dd8c) Line 67 + 0x13 bytes C++ mysqld-debug.exe!Item::send(Protocol * protocol=0x0318b384, String * buffer=0x0514dd8c) Line 4865 + 0x11 bytes C++ mysqld-debug.exe!select_send::send_data(List & items={...}) Line 1025 + 0x1e bytes C++ mysqld-debug.exe!end_send(JOIN * join=0x03169fb8, st_join_table * join_tab=0x0316b278, int end_of_records=0x00000000) Line 11377 + 0x25 bytes C++ mysqld-debug.exe!evaluate_join_record(JOIN * join=0x03169fb8, st_join_table * join_tab=0x0316b0e8, int error=0x00000000, char * report_error=0x0318b35c) Line 10670 + 0x18 bytes C++ mysqld-debug.exe!sub_select(JOIN * join=0x03169fb8, st_join_table * join_tab=0x0316b0e8, int end_of_records=0x00000000) Line 10554 + 0x15 bytes C++ mysqld-debug.exe!do_select(JOIN * join=0x03169fb8, List * fields=0x0318c078, st_table * table=0x00000000, Procedure * procedure=0x00000000) Line 10317 + 0xf bytes C++ mysqld-debug.exe!JOIN::exec() Line 2069 + 0x19 bytes C++ mysqld-debug.exe!mysql_select(THD * thd=0x0318b090, Item * * * rref_pointer_array=0x0318c108, TABLE_LIST * tables=0x03169d60, unsigned int wild_num=0x00000000, List & fields={...}, Item * conds=0x00000000, unsigned int og_num=0x00000000, st_order * order=0x00000000, st_order * group=0x00000000, Item * having=0x00000000, st_order * proc_param=0x00000000, unsigned __int64 select_options=0x0000000080844a00, select_result * result=0x03169fa8, st_select_lex_unit * unit=0x0318bd50, st_select_lex * select_lex=0x0318bfd8) Line 2249 C++ mysqld-debug.exe!handle_select(THD * thd=0x0318b090, st_lex * lex=0x0318bcf0, select_result * result=0x03169fa8, unsigned long setup_tables_done_option=0x00000000) Line 255 + 0x9e bytes C++ mysqld-debug.exe!mysql_execute_command(THD * thd=0x0318b090) Line 2666 + 0x13 bytes C++ mysqld-debug.exe!mysql_parse(THD * thd=0x0318b090, const char * inBuf=0x03169a68, unsigned int length=0x00000030, const char * * found_semicolon=0x0514fd7c) Line 6092 + 0x9 bytes C++ mysqld-debug.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x0318b090, char * packet=0x03178051, unsigned int packet_length=0x00000031) Line 1812 + 0x1e bytes C++ mysqld-debug.exe!do_command(THD * thd=0x0318b090) Line 1586 + 0x31 bytes C++ mysqld-debug.exe!handle_one_connection(void * arg=0x0318b090) Line 1197 + 0x9 bytes C++ mysqld-debug.exe!pthread_start(void * param=0x03125de0) Line 62 + 0x9 bytes C mysqld-debug.exe!_threadstart(void * ptd=0x0316ce78) Line 196 + 0xd bytes C kernel32.dll!FlsSetValue() + 0x136 bytes Version: '5.1.23-beta-debug' socket: '/tmp/mysql.sock' port: 3306 yes 070911 17:22:54 - 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=8388572 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 = 337620 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0x8dbc488 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... Cannot determine thread, fp=0x429cb93c, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x820109b handle_segfault + 541 0x83623c3 _ZN15Gis_read_stream13get_next_wordEP19st_mysql_lex_string + 69 0x8362837 _ZN8Geometry15create_from_wktEP15Geometry_bufferP15Gis_read_streamP6Stringb + 43 0x81c5045 _ZN28Item_func_geometry_from_text7val_strEP6String + 275 0x815b917 _ZN4Item4sendEP8ProtocolP6String + 193 0x81ee857 _ZN11select_send9send_dataER4ListI4ItemE + 241 0x8274114 _Z8end_sendP4JOINP13st_join_tableb + 212 0x827208b _Z9do_selectP4JOINP4ListI4ItemEP8st_tableP9Procedure + 559 0x826105f _ZN4JOIN4execEv + 7053 0x82615be _Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select + 638 0x825c1fd _Z13handle_selectP3THDP6st_lexP13select_resultm + 365 0x8215a14 _Z21execute_sqlcom_selectP3THDP10TABLE_LIST + 772 0x820e71d _Z21mysql_execute_commandP3THD + 1645 0x8217470 _Z11mysql_parseP3THDPKcjPS2_ + 372 0x820cb80 _Z16dispatch_command19enum_server_commandP3THDPcj + 2354 0x820c242 _Z10do_commandP3THD + 600 0x820ac3d handle_one_connection + 255 0x40038aa7 _end + 931809143 0x4017ec2e _end + 933144830 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/refman/5.1/en/resolve-stack-dump.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x8deb658 = select geomfromtext(col9,col89) as a from t1 thd->thread_id=1