usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.0.14-debug-log' socket: '/tmp/mysql.sock' port: 3306 [New Thread 163851 (LWP 2492)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 163851 (LWP 2492)] Field::offset() (this=0x0) at field.cc:194 194 return (uint) (ptr - (char*) table->record[0]); (gdb) backtrace full #0 Field::offset() (this=0x0) at field.cc:194 No locals. #1 0x081359b3 in create_tmp_table(THD*, TMP_TABLE_PARAM*, List&, st_order*, bool, bool, bool, unsigned long) (thd=0x8a72790, param=0x43c8c578, fields=@0x0, group=0x8a78048, distinct=false, save_sum_fields=false, allow_distinct_limit=false, select_options=84448256) at sql_select.cc:4060 field = (class Field *) 0x0 maybe_null = true table = (TABLE *) 0x8a68e98 i = 1 field_count = 1 reclength = 9 null_count = 1 null_pack_length = 1 hidden_null_count = 0 hidden_null_pack_length = 0 hidden_field_count = 4294967295 blob_count = 0 group_null_items = 0 using_unique_constraint = false not_all_columns = true tmpname = 0x8a693b0 "/tmp/#sql_9b0_0" path = "/tmp/#sql_9b0_0\0\0\0\0\0\0\0\020@ÿÿÿÿÿÿï\177\0\0\0\0\0\0\0@\001\0\0\0°¿ÈC\0\0\0\0\0\0\0@\0\0\0\0\0\0\020@\0\0\0\0\220'§\b\0\0\0\0\0\0\0@\0\004", '\0' , "ð?t¿ÈC\005\0\0\0\220'§\b \035§\b", '\0' , "\177\a\177\003\0\0\0\0üÀÈC\0\0\0\0<\203§\b<\203§\b \202§\b\001\0\0\0üÀÈC\004¿ÈCL\027\023\büÀÈC\034\001\0\0ô¾ÈCø¾ÈC\001\0\0\0\001\0\0\0\001\0\0\0\0\0\0\0DÁÈC"... pos = (byte *) 0x8a72551 "" ---Type to continue, or q to quit--- group_buff = (byte *) 0x8a693c0 "" null_flags = (uchar *) 0x8a72548 "ÿ" reg_field = (class Field **) 0x8a691dc from_field = (class Field **) 0x8a691f8 blob_field = (class Field **) 0x8a691e8 copy = (class Copy_field *) 0x8a72474 keyinfo = (KEY *) 0x8a69218 key_part_info = (KEY_PART_INFO *) 0x8a69240 copy_func = (class Item **) 0x8a69208 recinfo = (MI_COLUMNDEF *) 0x0 temp_pool_slot = 0 _db_func_ = 0x0 _db_file_ = 0x0 _db_level_ = 0 _db_framep_ = (char **) 0x0 li = { = {list = 0x43c8c0ec, el = 0x83df9c0, prev = 0x0, current = 0x0}, } item = (class Item *) 0x8a69218 tmp_from_field = (class Field **) 0x8a691fc #2 0x0812e08a in mysql_select(THD*, st_table_list*, List&, Item*, st_order*, st_order*, Item*, st_order*, unsigned long, select_result*) (thd=0x8a72790, tables=0x1, fields=@0x8a7293c, conds=0x0, order=0x0, group=0x8a78048, having=0x0, proc_param=0x0, select_options=84448256, result=0x8a78068) at sql_select.cc:712 tmp_table = (TABLE *) 0x0 error = -1 tmp_error = 145172368 need_tmp = true ---Type to continue, or q to quit--- hidden_group_fields = false simple_order = false simple_group = false no_order = false skip_sort_order = false select_limit = 4294967295 cond_value = COND_TRUE select = (class SQL_SELECT *) 0x0 keyuse = {buffer = 0x0, elements = 0, max_element = 0, alloc_increment = 0, size_of_element = 0} join = {join_tab = 0x8a78220, best_ref = 0x43c8bfac, map2table = 0x8a78198, table = 0x8a78218, all_tables = 0x8a78218, sort_by_table = 0x1, tables = 1, const_tables = 0, send_group_parts = 1, sort_and_group = false, first_record = false, full_join = false, group = true, no_field_update = 101, do_send_rows = true, const_table_map = 0, found_const_table_map = 0, outer_join = 0, send_records = 0, found_records = 0, examined_rows = 0, row_limit = 4294967295, positions = {{records_read = 4, table = 0x8a78078, key = 0x0}, {records_read = 0, table = 0x43c8c42c, key = 0x8a6ccb0}, { records_read = 3.5735365178364989e+18, table = 0x8a7293c, key = 0x43c8c3cd}, { records_read = 2.683862478424193e-314, table = 0x402e5ba0, key = 0x402e59fc}, {records_read = 2.3964085579736554, table = 0x0, key = 0x8a71d20}, { records_read = 3.5971602873433217e-269, table = 0x8a71d20, key = 0x43c8c1b4}, {records_read = 2.3964080810546879, table = 0x83e0ec0, key = 0x83e0ec0}, { records_read = 2.3964085579736554, table = 0x83e0ec0, key = 0x2}, { records_read = 3.5680037753252864e+18, table = 0x43c8c6be, key = 0x43c8c6bc}, {records_read = 0, table = 0x0, key = 0x2800b}, { records_read = 2.121995790970213e-312, table = 0x1f, key = 0x8a778a8}, { records_read = 5.6002151125676023e-267, table = 0x83b65d0, key = 0x8a77858}, { ---Type to continue, or q to quit--- records_read = 2.3505382537841824, table = 0x397, key = 0x43c8c23c}, { records_read = 5.1860671043670224e-269, table = 0x8a77858, key = 0x6}, { records_read = 2.3413689562065915e-313, table = 0x2, key = 0x42}, { records_read = 2.683862288702985e-314, table = 0x8a7785f, key = 0x43c8c258}, { records_read = 5.1789041356701314e-269, table = 0x8a7793e, key = 0x4}, { records_read = 2.1937316128879404e-314, table = 0x5, key = 0x8a77f90}, { records_read = 8.4879831663314175e-314, table = 0x83b5ca0, key = 0x8a77949}, { records_read = 5.1751139068632885e-269, table = 0x8a7794f, key = 0x2}, { records_read = 2.3413689569970966e-313, table = 0x2, key = 0x1}, { records_read = 8.4879831648492206e-314, table = 0x83b5a70, key = 0x8a7792b}, { records_read = 5.6922555937414391e-267, table = 0x1, key = 0x4}, { records_read = 5.687257317138539e-267, table = 0x4, key = 0x8a77ea0}, { records_read = 2.3505382537841846, table = 0xae, key = 0x43c8c2e0}, { records_read = 3.5684875604416123e+18, table = 0x8a7279c, key = 0x0}, { records_read = 3.5735365178364252e+18, table = 0x8a73831, key = 0x8a73831}, { records_read = 2.68386240727874e-314, table = 0x1ff, key = 0x43c8c32c}, { records_read = 3.5686546862090732e+18, table = 0x0, key = 0xe}, { records_read = 3.5971602873433217e-269, table = 0x8a71d20, key = 0x43c8c334}, {records_read = 2.3964080810546879, table = 0x83e0ec0, key = 0x83e0ec0}, { records_read = 2.3964085579736554, table = 0x83e0ec0, key = 0x37b}}, best_positions = {{records_read = 4, table = 0x8a78078, key = 0x0}, { records_read = 3.7009756144392869e-269, table = 0x83e0ec0, key = 0x2800b}, { records_read = 3.7003307563127491e-269, table = 0x8a77fa8, key = 0x8a72790}, { records_read = 5.6002151125679328e-267, table = 0x8a72790, key = 0x8a72790}, { records_read = 8.7077252435708057e-270, table = 0x397, key = 0x43c8c3bc}, { records_read = 3.5689713455579464e+18, table = 0xb6, key = 0x43c8c3ac}, { records_read = 3.5689361611858493e+18, table = 0x8a666d8, key = 0xd3}, { records_read = 2.3903820364361765e-313, table = 0x2000100, key = 0x0}, { ---Type to continue, or q to quit--- records_read = 3.7009756144393622e-269, table = 0x74736574, key = 0x73657400}, {records_read = 562949953423022.5, table = 0x8a66470, key = 0x8a667e0}, {records_read = 2.6838625100443944e-314, table = 0xd9, key = 0x43c8c418}, {records_read = 3.5691736556975043e+18, table = 0x21, key = 0x83a9e68}, {records_read = 0, table = 0x8a66654, key = 0x7}, { records_read = 2.3964080810546875, table = 0x8a72450, key = 0x402e59a0}, { records_read = 2.3964085579736554, table = 0x8a72450, key = 0x402e59a0}, { records_read = 2.3275075240749477, table = 0x402e59b0, key = 0x402e4f50}, { records_read = 9.2462407286240662, table = 0x402e59a0, key = 0x8a72450}, { records_read = 5.6070176626380888e-267, table = 0x8a72790, key = 0x8a71d20}, { records_read = 3.5293954994022695e-269, table = 0x3d, key = 0x43c8c480}, { records_read = 2.350538758816187, table = 0x8a72790, key = 0x8a71d20}, { records_read = 7.5318423334976486e-270, table = 0x0, key = 0x8a66470}, { records_read = 2.3505387588162581, table = 0x8a66470, key = 0xe}, { records_read = 2.6838626286201494e-314, table = 0x29, key = 0x43c8c4cc}, { records_read = 3.5735365178366116e+18, table = 0x0, key = 0x0}, { records_read = 2.1219957909652723e-314, table = 0x16b, key = 0x43c8c50c}, { records_read = 2.3964085579731811, table = 0x0, key = 0x8a666d8}, { records_read = 2.3964080810546875, table = 0x8a666d8, key = 0xd3}, { records_read = 2.3964085579731811, table = 0x8a66660, key = 0x8a66660}, { records_read = 2.3964085579736554, table = 0x8a66660, key = 0x250}, { records_read = 2.3275075240750471, table = 0x8a66670, key = 0x0}, { records_read = 3.7009756144395989e-269, table = 0x8a66660, key = 0x2800b}, { records_read = 5.4272085184932176e-267, table = 0x8a72464, key = 0x1}}, best_read = 6.7999999999999998, fields = 0x251, group_fields = { = { = {}, first = 0x83df9c0, last = 0x43c8c550, elements = 0}, }, tmp_table = 0x8a66660, thd = 0x8a72790, sum_funcs = 0x0, procedure = 0x8337850, ---Type to continue, or q to quit--- having = 0x0, select_options = 84448256, result = 0x8a78068, tmp_table_param = { = {}, copy_funcs = { = { = {}, first = 0x83df9c0, last = 0x43c8c57c, elements = 0}, }, copy_funcs_it = { = {list = 0x43c8c57c, el = 0x43c8c57c, prev = 0x0, current = 0x0}, }, copy_field = 0x8a72474, copy_field_end = 0x8a72474, group_buff = 0x8a693c0 "", items_to_copy = 0x8a69208, recinfo = 0x8a692b0, start_recinfo = 0x8a69270, keyinfo = 0x8a69218, end_write_records = 4294967295, field_count = 0, sum_func_count = 1, func_count = 2, hidden_field_count = 0, group_parts = 1, group_length = 14, group_null_parts = 1, quick_group = 1, using_indirect_summary_function = false}, lock = 0x8a72450} procedure = (class Procedure *) 0x0 all_fields = { = { = {}, first = 0x8a779e8, last = 0x8a77f80, elements = 2}, } select_distinct = false cur_sel = (SELECT_LEX *) 0x8a728cc _db_func_ = 0x43c8c43c "°Y.@PO.@dÄÈC\023~\"@ Y.@P$§\b\224ÄÈCP$§\b\220'§\b \035§\b\224ÄÈCF¥2\b=" _db_file_ = 0x43c8c11c "\001" _db_level_ = 511 _db_framep_ = (char **) 0x7 #3 0x0812c759 in handle_select(THD*, st_lex*, select_result*) (thd=0x8a72790, lex=0x8a78048, result=0x8a78068) at sql_select.cc:183 res = 145172368 select_lex = (SELECT_LEX *) 0x83bf4e8 #4 0x0811189a in mysql_execute_command() () at sql_parse.cc:1998 table = (TABLE_LIST *) 0x8a78068 ---Type to continue, or q to quit--- res = 0 thd = (class THD *) 0x8a72790 lex = (LEX *) 0x8a728c0 tables = (TABLE_LIST *) 0x8a77fa8 select_lex = (SELECT_LEX *) 0x8a728cc _db_func_ = 0x406
_db_file_ = 0x43c8c72c "" _db_level_ = 1137231664 _db_framep_ = (char **) 0x43c8c734 #5 0x08113b3f in mysql_parse(THD*, char*, unsigned) (thd=0x8a72790, inBuf=0x8a728c0 "\005", length=261) at sql_parse.cc:2943 lex = (LEX *) 0x8a728c0 _db_func_ = 0x2000
_db_file_ = 0x105
_db_level_ = 145172368 _db_framep_ = (char **) 0x43c8c994 #6 0x0810f2e7 in dispatch_command(enum_server_command, THD*, char*, unsigned) ( command=COM_QUERY, thd=0x8a72790, packet=0x8a73829 "SELECT COUNT(*), CASE INTERVAL(BirthYear, 30, 40, 50, 60) WHEN -1 THEN\n\"NULL\" WHEN 0 THEN \"Under 30\" WHEN 1 THEN \"From 30 to 39\" WHEN 2 THEN\n\"From 40 to 49\" WHEN 3 THEN \"From 50 to 59\" WHEN 4 THEN \"60"..., packet_length=261) at sql_parse.cc:1065 pos = 0x8a78048 "" net = (NET *) 0x8a7279c error = false slow_command = false _db_func_ = 0x2
_db_file_ = 0x43c8c86c "\aP\b\200" ---Type to continue, or q to quit--- _db_level_ = 0 _db_framep_ = (char **) 0x1032bd8 start_of_query = 8192 #7 0x0810ed33 in do_command(THD*) (thd=0x8a72790) at sql_parse.cc:940 packet = 0x8a73828 "\003SELECT COUNT(*), CASE INTERVAL(BirthYear, 30, 40, 50, 60) WHEN -1 THEN\n\"NULL\" WHEN 0 THEN \"Under 30\" WHEN 1 THEN \"From 30 to 39\" WHEN 2 THEN\n\"From 40 to 49\" WHEN 3 THEN \"From 50 to 59\" WHEN 4 THEN \"6"... old_timeout = 30 packet_length = 262 net = (NET *) 0x8a7279c command = COM_QUERY _db_func_ = 0x80e8020 "ÇC\034Ð\177\016\b\203Ä\020\213]ü\211ì]Ã\220U\211å\203ì\024ÿ5,\016>\bè}Uýÿ\203Ä\bÿu\bPè§)$" _db_file_ = 0x8a72ecc "\b\r§\b" _db_level_ = 4096 _db_framep_ = (char **) 0x1000 #8 0x0810e3fc in handle_one_connection (arg=0x0) at sql_parse.cc:723 error = 138147048 net = (NET *) 0x8a7279c thd = (class THD *) 0x8a72790 launch_time = 0 set = {__val = {0 }} #9 0x40029811 in pthread_start_thread () from /lib/i686/libpthread.so.0 No symbol table info available. #10 0x40029915 in pthread_start_thread_event () from /lib/i686/libpthread.so.0 No symbol table info available. (gdb)