#0 0xffffe410 in __kernel_vsyscall () No symbol table info available. #1 0x4003b8b8 in pthread_kill () from /lib/tls/libpthread.so.0 No symbol table info available. #2 0x08408fc2 in write_core (sig=11) at stacktrace.c:240 No locals. #3 0x0827c2f0 in handle_segfault (sig=11) at mysqld.cc:2293 curr_time = 1196096690 tm = {tm_sec = 50, tm_min = 4, tm_hour = 18, tm_mday = 26, tm_mon = 10, tm_year = 107, tm_wday = 1, tm_yday = 329, tm_isdst = 0, tm_gmtoff = 3600, tm_zone = 0x8998428 "CET"} thd = (class THD *) 0x8fbb910 #4 No symbol table info available. #5 0x086a8d7c in my_mb_wc_cp932 (cs=0x88a8540, pwc=0x4177e738, s=0x0, e=0x0) at ctype-cp932.c:5363 hi = 0 #6 0x082784d5 in copy_and_convert (to=0x8ffc2a0 '�' , "h4z\025\020", to_length=0, to_cs=0x8979520, from=0x0, from_length=0, from_cs=0x88a8540, errors=0x4177e800) at sql_string.cc:804 wc = 1098377048 from_end = (const uchar *) 0x0 to_start = 0x8ffc2a0 '�' , "h4z\025\020" cnvres = 136807122 to_end = (uchar *) 0x8ffc2a0 '�' , "h4z\025\020" mb_wc = 0x86a8d73 wc_mb = 0x86bab76 error_count = 0 #7 0x082786a5 in String::copy (this=0x4177e8a8, str=0x0, arg_length=0, from_cs=0x88a8540, to_cs=0x8979520, errors=0x4177e800) at sql_string.cc:348 offset = 0 new_length = 0 #8 0x0821eba3 in Item_char_typecast::val_str (this=0x9008d00, str=0x4177e8a8) at item_timefunc.cc:2416 dummy_errors = 294 res = (String *) 0x9008d88 length = 1098377332 __PRETTY_FUNCTION__ = "virtual String* Item_char_typecast::val_str(String*)" #9 0x081d003d in Item::str_result (this=0x9008d00, tmp=0x4177e8a8) at item.h:729 No locals. #10 0x08391c92 in make_sortkey (param=0x4177ec4c, to=0x8ffc2a0 '�' , "h4z\025\020", ref_pos=0x4177e9e8 "") at filesort.cc:724 cs = (CHARSET_INFO *) 0x8979520 tmp = {Ptr = 0x8ffc2a0 '�' , "h4z\025\020", str_length = 5, Alloced_length = 5, alloced = false, str_charset = 0x8979520} fill_char = 32 ' ' diff = 10 sort_field_length = 142411559 res = (String *) 0x87d0835 item = (class Item *) 0x9008d00 maybe_null = false field = (class Field *) 0x0 sort_field = (SORT_FIELD *) 0x900a6a0 length = 141135437 __PRETTY_FUNCTION__ = "void make_sortkey(SORTPARAM*, uchar*, uchar*)" #11 0x08392bb7 in find_all_keys (param=0x4177ec4c, select=0x900a598, sort_keys=0x8ffc268, buffpek_pointers=0x4177eac4, tempfile=0x4177eb88, indexfile=0x0) at filesort.cc:553 idx = 1 ref_length = 7 killed = (volatile THD::killed_state *) 0x8fbc6a0 flag = 0 sort_form = (TABLE *) 0x8fdf880 thd = (class THD *) 0x8fbb910 ref_pos = (uchar *) 0x4177e9e8 "" save_read_set = (MY_BITMAP *) 0x8fdf900 save_write_set = (MY_BITMAP *) 0x8fdf914 _db_func_ = 0x87d09c0 "filesort" _db_file_ = 0x87d0727 "filesort.cc" _db_level_ = 9 error = 0 quick_select = 0 indexpos = 0 read_record_info = {table = 0x0, file = 0x8fddf28, forms = 0x4177e9b8, read_record = 0x86977d5 , thd = 0x0, select = 0x4, cache_records = 0, ref_length = 0, struct_length = 0, reclength = 0, rec_cache_size = 150865720, error_offset = 150865744, index = 150867256, ref_pos = 0x0, record = 0x4177e9e8 "", rec_buf = 0x8698e4d "\211�213E�211\002�U\211�203�030��, cache = 0x8fe0d38 "��\b}\b'\a}\b", cache_pos = 0x87d077b "MY", cache_end = 0xffffffff
, read_positions = 0xffffffff
, io_cache = 0x16, print_error = false, ignore_not_found_rows = false} next_pos = (uchar *) 0x0 ref_buff = "\000\000\000\000\000\000\000\b" record = 7 file = (class handler *) 0x8fe0330 _db_framep_ = (char **) 0x4177ea38 #12 0x08394841 in filesort (thd=0x8fbb910, table=0x8fdf880, sortorder=0x900a6a0, s_length=1, select=0x900a598, max_rows=18446744073709551615, sort_positions=false, examined_rows=0x4177eda0) at filesort.cc:234 buffpek = (BUFFPEK *) 0x0 selected_records_file = (IO_CACHE *) 0x0 param = {rec_length = 2, sort_length = 1, ref_length = 7, addon_length = 1, res_length = 1, keys = 13, max_rows = 18446744073709551615, examined_rows = 1, sort_form = 0x8fdf880, local_sortorder = 0x900a6a0, end = 0x900a6b8, addon_field = 0x8ffc1f8, unique_buff = 0x0, not_killable = false, tmp_buffer = 0x0, compare = 0, cmp_context = {key_compare = 0, key_compare_arg = 0x0}} tab = (TABLE_LIST *) 0x9008a78 memavl = 2097116 maxbuffer = 1098378504 sort_keys = (uchar **) 0x8ffc268 tempfile = {pos_in_file = 606172087320046520, end_of_file = 613683034985467192, read_pos = 0x4177ebb8 "(�A�rg\b�, read_end = 0x8698e6e "\211E�203}�, buffer = 0x0, request_pos = 0x401e88a0 "", write_buffer = 0xe0
, append_read_pos = 0x4177ebc4 "\024�A\020�A\f�A\020�A\f�A\b�A\a`i\b", write_pos = 0x16
, write_end = 0x8fe0d38 "��\b}\b'\a}\b", current_pos = 0x4177ed28, current_end = 0x86772b3, append_buffer_lock = {global = { __m_reserved = 201, __m_count = 1098378516, __m_owner = 0x4177ed10, __m_kind = 1098378508, __m_lock = {__status = 1098378512, __spinlock = 1098378508}}, mutex = {__m_reserved = 1098378504, __m_count = 141123591, __m_owner = 0x0, __m_kind = 150855464, __m_lock = { __status = 8786549, __spinlock = 0}}, file = 0xffffffff
, line = 4294967295, count = 150978832, thread = 0}, share = 0x0, read_function = 0x8fddf28, write_function = 0x4177ec38, type = 141129685, pre_read = 0x8fe0d38, post_read = 0, pre_close = 0x4177ec48, disk_writes = 141135437, arg = 0x8fe0d38, file_name = 0x8843c80 "exit", dir = 0x4177ec48 "h�A\002", prefix = 0x8698e6e "\211E�203}�, file = -1, seek_not_done = -1, error = 151031200, buffer_length = 1073985157, read_length = 151036680, myflags = -1, alloced_buffer = 104 'h'} buffpek_pointers = {pos_in_file = 0, end_of_file = 18446744073709551615, read_pos = 0x900e970 '�' ..., read_end = 0x4177ec5c "\001", buffer = 0x900e970 '�' ..., request_pos = 0x900e970 '�' ..., write_buffer = 0x900e970 '�' ..., append_read_pos = 0x41774000 "", write_pos = 0x900e970 '�' ..., write_end = 0x901e970 "h4z\025!@", current_pos = 0x4177eaec, current_end = 0x4177eaf0, append_buffer_lock = {global = {__m_reserved = 0, __m_count = 150867256, __m_owner = 0x8843c80, __m_kind = 1098378024, __m_lock = {__status = 141135470, __spinlock = 144399536}}, mutex = { __m_reserved = 150855464, __m_count = 1074987585, __m_owner = 0x4177eb34, __m_kind = 22, __m_lock = {__status = 1073978631, __spinlock = 1098378120}}, file = 0x4003b685 "\201�i", line = 151036680, count = 4294967295, thread = 1098378072}, share = 0x0, read_function = 0x86719c6 <_my_b_read>, write_function = 0x8673682 <_my_b_write>, type = WRITE_CACHE, pre_read = 0, post_read = 0, pre_close = 0, disk_writes = 0, arg = 0x0, file_name = 0x0, dir = 0x8ffc2e0 "/tmp", prefix = 0x8fe0750 "MY", file = -1, seek_not_done = 0, error = 0, buffer_length = 65536, read_length = 65536, myflags = 16, alloced_buffer = 1 '\001'} multi_byte_charset = false outfile = (IO_CACHE *) 0x8ffc110 _db_func_ = 0x87bcfc2 "create_sort_index" _db_file_ = 0x87bc0b4 "sql_select.cc" _db_level_ = 8 error = 1 records = 13 table_sort = {io_cache = 0x8ffc110, sort_keys = 0x8ffc268, buffpek = 0x0, buffpek_len = 0, addon_buf = 0x8ffc240 "�h4z\025\217\217\217\217\217\217\217y", addon_length = 1, addon_field = 0x8ffc1f8, unpack = 0x8394dc0 , record_pointers = 0x0, found_records = 0} min_sort_memory = 32732 _db_framep_ = (char **) 0x4177ed28 subselect = (class Item_subselect *) 0x0 #13 0x08301de1 in create_sort_index (thd=0x8fbb910, join=0x9008e40, order=0x9008da0, filesort_limit=18446744073709551615, select_limit=18446744073709551615, is_order_by=false) at sql_select.cc:13135 length = 1 examined_rows = 611299774812785976 select = (SQL_SELECT *) 0x900a598 tab = (JOIN_TAB *) 0x900a308 _db_func_ = 0x87bd6ff "JOIN::exec" _db_file_ = 0x87bc0b4 "sql_select.cc" table = (TABLE *) 0x8fdf880 _db_level_ = 7 _db_framep_ = (char **) 0x0 #14 0x0830fb49 in JOIN::exec (this=0x9008e40) at sql_select.cc:2080 _db_func_ = 0x87bd802 "mysql_select" _db_file_ = 0x87bc0b4 "sql_select.cc" _db_level_ = 6 _db_framep_ = (char **) 0x900a490 tmp_error = 1 curr_join = (JOIN *) 0x9008e40 curr_fields_list = (List *) 0x8fbca68 columns_list = (List *) 0x8fbca68 curr_all_fields = (List *) 0x9009f60 curr_tmp_table = (TABLE *) 0x0 __PRETTY_FUNCTION__ = "void JOIN::exec()" #15 0x08310240 in mysql_select (thd=0x8fbb910, rref_pointer_array=0x8fbcacc, tables=0x9008a78, wild_num=0, fields=@0x8fbca68, conds=0x0, og_num=1, order=0x9008da0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0x9008e30, unit=0x8fbc76c, select_lex=0x8fbc9d4) at sql_select.cc:2313 err = false free_join = true _db_func_ = 0x87bd818 "handle_select" _db_file_ = 0x87bc0b4 "sql_select.cc" join = (JOIN *) 0x9008e40 _db_level_ = 5 _db_framep_ = (char **) 0x0 #16 0x0831056b in handle_select (thd=0x8fbb910, lex=0x8fbc710, result=0x9008e30, setup_tables_done_option=0) at sql_select.cc:263 unit = (SELECT_LEX_UNIT *) 0x8fbc76c select_lex = (SELECT_LEX *) 0x8fbc9d4 _db_func_ = 0x8770701 "mysql_execute_command" _db_file_ = 0x876fd08 "sql_parse.cc" res = 8 _db_level_ = 4 _db_framep_ = (char **) 0x10 #17 0x0828a642 in execute_sqlcom_select (thd=0x8fbb910, all_tables=0x9008a78) at sql_parse.cc:4549 lex = (LEX *) 0x8fbc710 result = (class select_result *) 0x9008e30 res = false #18 0x0829048c in mysql_execute_command (thd=0x8fbb910) at sql_parse.cc:1886 res = false lex = (LEX *) 0x8fbc710 _db_func_ = 0x8770d78 "mysql_parse" _db_file_ = 0x876fd08 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x4177fc10 up_result = 0 need_start_waiting = false select_lex = (SELECT_LEX *) 0x8fbc9d4 first_table = (TABLE_LIST *) 0x9008a78 all_tables = (TABLE_LIST *) 0x9008a78 unit = (SELECT_LEX_UNIT *) 0x8fbc76c __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #19 0x0829912f in mysql_parse (thd=0x8fbb910, inBuf=0x9008930 "select 1 from `t1` order by cast(`c` as char(1))", length=48, found_semicolon=0x41780310) at sql_parse.cc:5462 lex = (LEX *) 0x8fbc710 lip = {m_thd = 0x8fbb910, yylineno = 1, yytoklen = 1, yylval = 0x4177f1e8, m_ptr = 0x9008961 '\217' , m_tok_start = 0x9008961 '\217' , m_tok_end = 0x9008961 '\217' , m_end_of_query = 0x9008960 "", m_tok_start_prev = 0x9008960 "", m_buf = 0x9008930 "select 1 from `t1` order by cast(`c` as char(1))", m_buf_length = 48, m_echo = true, m_cpp_buf = 0x90089a8 "select 1 from `t1` order by cast(`c` as char(1))", m_cpp_ptr = 0x90089d8 "", m_cpp_tok_start = 0x90089d8 "", m_cpp_tok_start_prev = 0x90089d8 "", m_cpp_tok_end = 0x90089d8 "", m_body_utf8 = 0x0, m_body_utf8_ptr = 0x876f995 "Query", m_cpp_utf8_processed_ptr = 0x0, next_state = MY_LEX_END, found_semicolon = 0x0, tok_bitmap = 89 'Y', ignore_space = false, stmt_prepare_mode = false, in_comment = NO_COMMENT, m_cpp_text_start = 0x90089d5 "1))", m_cpp_text_end = 0x90089d6 "))", m_underscore_cs = 0x0} err = false ---Type to continue, or q to quit--- _db_func_ = 0x8770df3 "dispatch_command" _db_file_ = 0x876fd08 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x4177fddc __PRETTY_FUNCTION__ = "void mysql_parse(THD*, const char*, uint, const char**)" #20 0x08299c44 in dispatch_command (command=COM_QUERY, thd=0x8fbb910, packet=0x90008d1 "select 1 from `t1` order by cast(`c` as char(1))", packet_length=49) at sql_parse.cc:958 packet_end = 0x9008960 "" format = 0x8770e07 "%.*b" found_semicolon = 0x0 net = (NET *) 0x8fbb988 _db_func_ = 0x884a094 "?func" _db_file_ = 0x884a09a "?file" error = false _db_level_ = 1 _db_framep_ = (char **) 0x41780348 #21 0x0829add7 in do_command (thd=0x8fbb910) at sql_parse.cc:717 packet = 0x90008d0 "\003select 1 from `t1` order by cast(`c` as char(1))" packet_length = 49 net = (NET *) 0x8fbb988 command = COM_QUERY _db_func_ = 0x884a094 "?func" _db_file_ = 0x884a09a "?file" _db_level_ = 1 _db_framep_ = (char **) 0x4afc9e #22 0x08288c45 in handle_one_connection (arg=0x8fbb910) at sql_connect.cc:1099 net = (NET *) 0x8fbb988 thd = (class THD *) 0x8fbb910 launch_time = 215 #23 0x40038297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #24 0x4018a37e in clone () from /lib/tls/libc.so.6 No symbol table info available. #25 0x41780bb0 in ?? () No symbol table info available.