(gdb) run Starting program: /home/miguel/dbs/5.0/libexec/mysqld [Thread debugging using libthread_db enabled] [New Thread 1075762880 (LWP 5643)] [New Thread 1089485744 (LWP 5646)] [New Thread 1091586992 (LWP 5647)] [New Thread 1093688240 (LWP 5648)] [New Thread 1095789488 (LWP 5649)] [New Thread 1097890736 (LWP 5650)] [New Thread 1102666672 (LWP 5651)] [New Thread 1104767920 (LWP 5652)] [Thread 1097890736 (zombie) exited] [New Thread 1106869168 (LWP 5653)] 060828 21:59:37 InnoDB: Started; log sequence number 0 68958 [New Thread 1098218416 (LWP 5654)] [New Thread 1098419120 (LWP 5655)] 060828 21:59:37 [Note] /home/miguel/dbs/5.0/libexec/mysqld: ready for connections. Version: '5.0.25-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread 1130650544 (LWP 5701)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1130650544 (LWP 5701)] 0x0857d158 in mi_records_in_range (info=0x8f1f030, inx=0, min_key=0x0, max_key=0x43641c44) at mi_range.c:75 75 start_key_len= _mi_pack_key(info,inx, key_buff, Current language: auto; currently c (gdb) bt full #0 0x0857d158 in mi_records_in_range (info=0x8f1f030, inx=0, min_key=0x0, max_key=0x43641c44) at mi_range.c:75 key_buff = (uchar *) 0x8f1fad0 "" start_key_len = 1130634244 start_pos = 589214353876851784 end_pos = 644240524696214766 res = 589221161400015944 _db_func_ = 0x43641e5c "8\021ï\bOßñ\b8Id\bLId\b8Id\b" _db_file_ = 0x8f11308 "(_f\b" _db_level_ = 150071600 _db_framep_ = (char **) 0x401ea8d8 #1 0x082f58c3 in ha_myisam::records_in_range (this=0x8f1e7f8, inx=0, min_key=0x0, max_key=0x43641c44) at ha_myisam.cc:1696 No locals. #2 0x082d6c3e in check_quick_keys (param=0x43641e5c, idx=0, key_tree=0x8f0ceb0, min_key=0x4364209c "", min_key_flag=0, max_key=0x43642f9a "", max_key_flag=0) at opt_range.cc:5827 min_range = {key = 0x4364209c "", length = 0, flag = HA_READ_KEY_EXACT} max_range = {key = 0x43642f9a "", length = 32, flag = HA_READ_BEFORE_KEY} tmp = 0 keynr = 0 records = 0 tmp_min_flag = 1 tmp_max_flag = 8 min_key_length = 0 max_key_length = 32 tmp_min_key = 0x4364209c "" tmp_max_key = 0x43642fba "" #3 0x082d6f02 in check_quick_select (param=0x43641e5c, idx=0, tree=0x8f0ceb0) at opt_range.cc:5633 cpk_scan = false key = 0 _db_func_ = 0x0 _db_file_ = 0x0 records = 0 _db_level_ = 0 _db_framep_ = (char **) 0x0 key_alg = HA_KEY_ALG_UNDEF #4 0x082d71de in get_key_scans_params (param=0x43641e5c, tree=0x8f0cd58, index_read_must_be_used=false, read_time=4.9351562500000004) at opt_range.cc:3353 keynr = 0 read_index_only = false cpu_cost = 45303040212790720 found_records = 18446744073709551614 found_read_time = 7.4118135321461614e-316 key = (SEL_ARG **) 0x8f0cd5c end = (SEL_ARG **) 0x8f0cd60 key_to_read = (SEL_ARG **) 0x0 _db_func_ = 0x85ce706 "\203Ä\020\213]üÉAU\211å\203ì\b\213E\b\213@\b\205At\031\213E\b\213@\b\203ì\004j7h°½s\bPè]\212" _db_file_ = 0x43641d78 "" _db_level_ = 0 _db_framep_ = (char **) 0x0 ---Type to continue, or q to quit--- pk_is_clustered = false idx = 0 best_records = 0 read_plan = (TRP_RANGE *) 0x0 #5 0x082e08e0 in SQL_SELECT::test_quick_select (this=0x8f12518, thd=0x8ef1138, keys_to_use={map = 1}, prev_tables=0, limit=18446744073709551615, force_quick_range=false) at opt_range.cc:1992 range_trp = (TRP_RANGE *) 0x8f12280 rori_trp = (TRP_ROR_INTERSECT *) 0x8ef1158 can_build_covering = false alloc = {free = 0x8f0cd28, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 1992, block_num = 5, first_block_usage = 0, error_handler = 0x81d073a } tree = (SEL_TREE *) 0x8f0cd58 key_info = (KEY *) 0x8f1e7c4 param = {thd = 0x8ef1138, table = 0x8f1dfd8, key_parts = 0x8f0cd38, key_parts_end = 0x8f0cd4c, key = { 0x8f0cd38, 0x0 }, mem_root = 0x43643ed0, old_root = 0x8ef1158, prev_tables = 0, read_tables = 0, current_table = 1, baseflag = 341986713, max_key_part = 0, range_count = 1, keys = 1, real_keynr = {0 }, min_key = '\0' , "Xëñ\b__\a\001\000\001\001¥\000°\000d\000O\000\005\000\000\001\000\b\001", '\0' , "\004", '\0' , "ÿÿÿÿÿÿÿÿ\000\000\000\000`!dC\000\004\000\000 @áB @\000\000\000\000\000\004\000\000\000\004\000\000\210!dC*r\005@\000\004\000\000\000\000\000\000\000\004\000\000\000\000\000\000#\000\000\000ps\207\b\001\004\000\000\000\026ï\bè!dC\000\000\000\000ps\207\b @áBè!dC\225?[\b max_key = '\0' , "\001\000\000\000\210\232í\bd÷[\b\000\000\000\000\001AdC\a", '\0' , "H0dC7÷[\blªs\b\2042dCH0dC¡÷[\bB\000\000\000@0dC<0dC80dC\000\000\000\000\000\000\000\000f\030\02 0\000\000\2000dC|0dCx0dC\000\000\000\000\0205dC\000\000\000\000\000\000\000\000\004\000\000\000O«\036@O"\036@à\rñ\b\2100dCd0\005@é\003\000\000ér]\b\003\000\000\000\000\004\000"..., quick = 255, cond = 0x8f11308, fields_ bitmap = 0x8f0cd50 "\002¥¥¥¥¥¥¥\003", bitmap_size = 1, mutex = 0x0}, tmp_covered_fields = {bitmap = 0x0, bitmap_size = 141794338, mutex = 0x43643f08}, needed_reg = 0x8f12600, imerge_cost_buff = 0xdc, imerge_cost_buff_size = 0, is_ror_scan = false, n_ranges = 1} key_parts = (KEY_PART *) 0x8f0cd4c best_trp = (TABLE_READ_PLAN *) 0x0 group_trp = (TRP_GROUP_MIN_MAX *) 0x0 best_read_time = 4.9351562500000004 idx = 1 scan_time = 1.8 _db_func_ = 0x8f10d50 "" _db_file_ = 0x8f12518 "" _db_level_ = 1130643240 _db_framep_ = (char **) 0x0 #6 0x08262276 in get_quick_record_count (thd=0x8ef1138, select=0x8f12518, table=0x8f1dfd8, keys=0x8f1231c, limit=18446744073709551615) at sql_select.cc:2025 _db_func_ = 0x8f1dfd8 "dåñ\boçñ\b" _db_file_ = 0x8273d46 "\203Ä \211Eä\203}ä" error = 0 _db_level_ = 1130644104 _db_framep_ = (char **) 0x0 #7 0x08273dbd in make_join_statistics (join=0x8f11460, tables=0x0, conds=0x8f11308, keyuse_array=0x8f12180) at sql_select.cc:2373 records = 644312233328771072 ---Type to continue, or q to quit--- select = (SQL_SELECT *) 0x8f12518 const_count = 0 key = 136752539 stat_end = (JOIN_TAB *) 0x8f123f0 stat_ref = (JOIN_TAB **) 0x8f123f0 _db_func_ = 0x8f11290 "(ïg\b" _db_file_ = 0x8f11048 "\210\220e\b" table_count = 1 found_ref = 0 i = 1 const_ref = {map = 150016776} table_vector = (TABLE **) 0x8f124e8 s = (JOIN_TAB *) 0x8f12280 table = (TABLE *) 0x8f1dfd8 found_const_table_map = 0 eq_part = {map = 587039677660266497} _db_level_ = 136760655 _db_framep_ = (char **) 0x43644238 all_table_map = 1 refs = 644317146771357696 stat = (JOIN_TAB *) 0x8f12280 keyuse = (KEYUSE *) 0x0 outer_join = 0 error = 0 start_keyuse = (KEYUSE *) 0x826ce07 stat_vector = {0x8f12280, 0x0, 0x436440e8, 0x8183b96, 0x8f11168, 0x0, 0x1, 0x0, 0x1, 0x8183c04, 0x2, 0x1, 0x0, 0x0, 0x43644138, 0x819577b, 0x8f111e8, 0x8183c04, 0x43644128, 0x81839e0, 0x8f11168, 0x0, 0x43644138, 0x816ec2a, 0x436441d4, 0x0, 0x43644168, 0x819577b, 0x8f11168, 0x0, 0x43644158, 0x81b7312, 0x436441d4, 0x8f111e8, 0x43644178, 0x8195ba7, 0x8f11308, 0x0, 0x2, 0x1, 0x0, 0x0, 0x436441a8, 0x819577b, 0x8f111e8, 0x0, 0x436441b8, 0x817660d, 0x8f11290, 0x0, 0x436441a8, 0x81839e0, 0x8f11048, 0x8f11308, 0x0, 0x1, 0x1, 0x0, 0x43644238, 0x826bd26, 0x8f11308, 0x8ef1138} ref_changed = 0 #8 0x0827f099 in JOIN::optimize (this=0x8f11460) at sql_select.cc:714 _db_func_ = 0x0 _db_file_ = 0x14
_db_level_ = 0 _db_framep_ = (char **) 0x0 sel = (SELECT_LEX *) 0x8ef140c #9 0x08284acf in mysql_select (thd=0x8ef1138, rref_pointer_array=0x8ef1534, tables=0x8f10e90, wild_num=0, fields=@0x8ef1498, conds=0x8f11308, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2189707776, result=0x8f11450, unit=0x8ef11dc, select_lex=0x8ef140c) at sql_select.cc:1968 err = false free_join = true _db_func_ = 0x43644448 "" _db_file_ = 0x4364448c "\214\\\037\bX\021ï\bP\024ñ\b,DdC\202\024#\bP\024ñ\b\220\016ñ\bÜ\021ï\bP\024ñ\b8\021ï\b" join = (JOIN *) 0x8f11460 _db_level_ = 788 _db_framep_ = (char **) 0x8353b78 #10 0x08284e2d in handle_select (thd=0x8ef1138, lex=0x8ef1178, result=0x8f11450, setup_tables_done_option=0) ---Type to continue, or q to quit--- at sql_select.cc:254 unit = (SELECT_LEX_UNIT *) 0x8ef11dc select_lex = (SELECT_LEX *) 0x8ef140c _db_func_ = 0x8f11450 "(Nh\b8\021ï\bÜ\021ï\b" _db_file_ = 0x8231482 "\203Ä\020º(Nh\b\213E\b\211\020\213E\bÇ@\f" res = 8 _db_level_ = 1130644664 _db_framep_ = (char **) 0x8f11450 #11 0x08226971 in mysql_execute_command (thd=0x8ef1138) at sql_parse.cc:2573 result = (class select_result *) 0x8f11450 res = false lex = (LEX *) 0x8ef1178 _db_func_ = 0x8ef1440 "" _db_file_ = 0x8f10dd0 "" _db_level_ = 135719866 _db_framep_ = (char **) 0x43644ca8 need_start_waiting = false result = 0 select_lex = (SELECT_LEX *) 0x8ef140c first_table = (TABLE_LIST *) 0x8f10e90 all_tables = (TABLE_LIST *) 0x8f10e90 unit = (SELECT_LEX_UNIT *) 0x8ef11dc __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #12 0x0822e5d7 in mysql_parse (thd=0x8ef1138, inBuf=0x8f10d60 "SELECT 1 FROM geom WHERE foo != PointFromWKB(POINT(0,0))", length=56) at sql_parse.cc:5842 lex = (LEX *) 0x8ef1178 _db_func_ = 0x886e440 "h\177m\b" _db_file_ = 0x822ef3f "\203Ä ¡T/\207\b\205At/\203ì\bhì`i\bhá\006" _db_level_ = 1130648344 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" #13 0x0822efbe in dispatch_command (command=COM_QUERY, thd=0x8ef1138, packet=0x8f08d01 "SELECT 1 FROM geom WHERE foo != PointFromWKB(POINT(0,0))", packet_length=57) at sql_parse.cc:1766 packet_end = 0x8f10d98 "" net = (NET *) 0x8ef194c _db_func_ = 0x4
_db_file_ = 0x0 error = false _db_level_ = 16777216 _db_framep_ = (char **) 0x8ef2240 #14 0x0823033e in do_command (thd=0x8ef1138) at sql_parse.cc:1550 packet = 0x8f08d00 "\003SELECT 1 FROM geom WHERE foo != PointFromWKB(POINT(0,0))" old_timeout = 30 packet_length = 57 net = (NET *) 0x8ef194c command = COM_QUERY _db_func_ = 0x43645378 "XTdCJ\a#\b8\021ï\b\001" _db_file_ = 0x8ef235c "\200-ñ\b" _db_level_ = 150023552 ---Type to continue, or q to quit--- _db_framep_ = (char **) 0x1010 #15 0x0823074a in handle_one_connection (arg=0x8ef1138) at sql_parse.cc:1181 error = 0 net = (NET *) 0x8ef194c sctx = (Security_context *) 0x8ef2124 thd = (class THD *) 0x8ef1138 launch_time = 0 set = {__val = {0 }} #16 0x40051297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #17 0x4018c37e in clone () from /lib/tls/libc.so.6 No symbol table info available. #18 0x43645bb0 in ?? () No symbol table info available. (gdb)