060705 11:28:37 [Note] /home/miguel/dbs/5.0/libexec/mysqld: ready for connections. Version: '5.0.23-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread 1130646448 (LWP 6019)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 1130646448 (LWP 6019)] 0x08268e10 in count_field_types (param=0x8f4d3d0, fields=@0x8f42274, reset_with_sum_func=false) at sql_select.cc:12604 12604 if (sum_item->args[0]->real_item()->type() == Item::FIELD_ITEM) (gdb) bt full #0 0x08268e10 in count_field_types (param=0x8f4d3d0, fields=@0x8f42274, reset_with_sum_func=false) at sql_select.cc:12604 i = 0 sum_item = (class Item_sum *) 0x8f197d0 type = SUM_FUNC_ITEM li = { = {list = 0x8f42274, el = 0x8f43fd0, prev = 0x8f43fc8, current = 0x8f43fd0}, } field = (class Item *) 0x8f197d0 #1 0x08287960 in JOIN::exec (this=0x8f41530) at sql_select.cc:1562 _db_func_ = 0x4
_db_file_ = 0x0 _db_level_ = 150044792 _db_framep_ = (char **) 0x0 tmp_error = 0 curr_join = (JOIN *) 0x8f4c750 curr_fields_list = (List *) 0x8f42298 columns_list = (List *) 0x8f18100 curr_all_fields = (List *) 0x8f42274 curr_tmp_table = (TABLE *) 0x8f144c0 __PRETTY_FUNCTION__ = "void JOIN::exec()" #2 0x081dde73 in subselect_single_select_engine::exec (this=0x8f19008) at item_subselect.cc:1592 _db_func_ = 0x20
_db_file_ = 0x20000
_db_level_ = 141846592 _db_framep_ = (char **) 0x857a3b6 save_where = 0x86e23dc "order clause" save_select = (SELECT_LEX *) 0x8ef847c #3 0x081d9ff3 in Item_subselect::exec (this=0x8f18f78) at item_subselect.cc:199 res = 0 #4 0x081dacc1 in Item_singlerow_subselect::val_str (this=0x8f18f78, str=0x8f42c40) at item_subselect.cc:479 No locals. #5 0x0817f71c in Item_copy_string::copy (this=0x8f42c38) at item.cc:2819 res = (String *) 0x86e1524 #6 0x0827f7f8 in copy_fields (param=0x8f413c0) at sql_select.cc:12966 ptr = (Copy_field *) 0x8f429cc end = (Copy_field *) 0x8f429cc it = { = {list = 0x8f413c4, el = 0x8f426d0, prev = 0x0, current = 0x0}, } item = (class Item_copy_string *) 0x8f42c38 #7 0x0827fd62 in end_send_group (join=0x8f40740, join_tab=0x8f42600, end_of_records=false) at sql_select.cc:10622 idx = -1 _db_func_ = 0x8f42600 "ÈÕg\b" ---Type to continue, or q to quit--- _db_file_ = 0x8289a05 "\203Ä\020\tÐ\205Àu\006ÆEÿ\001ë\004ÆEÿ" ok_code = NESTED_LOOP_OK _db_level_ = 1130639816 _db_framep_ = (char **) 0x0 #8 0x0827e4cc in flush_cached_records (join=0x8f40740, join_tab=0x8f42490, skip_last=false) at sql_select.cc:9921 i = 1 select = (SQL_SELECT *) 0x8f42830 rc = NESTED_LOOP_OK error = 0 info = (READ_RECORD *) 0x8f424cc #9 0x0827e5b4 in sub_select_cache (join=0x8f40740, join_tab=0x8f42490, end_of_records=true) at sql_select.cc:9484 rc = NESTED_LOOP_ERROR #10 0x082758cd in sub_select (join=0x8f40740, join_tab=0x8f42320, end_of_records=true) at sql_select.cc:9623 error = -1 rc = NESTED_LOOP_OK report_error = (my_bool *) 0x8ef8c1c "" info = (READ_RECORD *) 0x8f4235c #11 0x08275d29 in do_select (join=0x8f40740, fields=0x8f414c0, table=0x0, procedure=0x0) at sql_select.cc:9424 join_tab = (JOIN_TAB *) 0x8f42320 _db_func_ = 0x8f414c0 "À&ô\bØ&ô\b\003" _db_file_ = 0x8ef8c44 "Hxi\b°\201ï\b´\214ï\bÈ\214ï\b\001" rc = 0 error = NESTED_LOOP_OK _db_level_ = 136299319 _db_framep_ = (char **) 0x436432f8 #12 0x08288309 in JOIN::exec (this=0x8f40740) at sql_select.cc:1738 _db_func_ = 0x0 _db_file_ = 0x0 _db_level_ = 149914748 _db_framep_ = (char **) 0x8f40740 tmp_error = 0 curr_join = (JOIN *) 0x8f40740 curr_fields_list = (List *) 0x8f414c0 columns_list = (List *) 0x8ef8504 curr_all_fields = (List *) 0x8f4149c curr_tmp_table = (TABLE *) 0x0 __PRETTY_FUNCTION__ = "void JOIN::exec()" #13 0x082885f3 in mysql_select (thd=0x8ef81b0, rref_pointer_array=0x8ef85a0, tables=0x8f190a0, wild_num=0, fields=@0x8ef8504, conds=0x8f19548, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2156153344, result=0x8f19698, ---Type to continue, or q to quit--- unit=0x8ef8254, select_lex=0x8ef847c) at sql_select.cc:1902 err = false free_join = true _db_func_ = 0x43643448 "" _db_file_ = 0x4364348c "0­\037\bÐ\201ï\b\230\226ñ\b¸4dC´a#\b\230\226ñ\b \220ñ\bT\202ï\b\230\226ñ\b°\201ï\b" join = (JOIN *) 0x8f40740 _db_level_ = 788 _db_framep_ = (char **) 0x83540ba #14 0x082888ba in handle_select (thd=0x8ef81b0, lex=0x8ef81f0, result=0x8f19698, setup_tables_done_option=0) at sql_select.cc:250 unit = (SELECT_LEX_UNIT *) 0x8ef8254 select_lex = (SELECT_LEX *) 0x8ef847c _db_func_ = 0x8f19698 "hgi\b°\201ï\bT\202ï\b\001" _db_file_ = 0x82361b4 "\203Ä\020ºhgi\b\213E\b\211\020\213E\bÇ@\f" res = 8 _db_level_ = 1130640568 _db_framep_ = (char **) 0x8f19698 #15 0x0822b712 in mysql_execute_command (thd=0x8ef81b0) at sql_parse.cc:2512 result = (class select_result *) 0x8f19698 res = false lex = (LEX *) 0x8ef81f0 _db_func_ = 0x85d0022 "\203Ä\020ÉÃU\211å\203ì\b\203}\f" _db_file_ = 0x8878adc "Ü\212\207\b" _db_level_ = 149914796 _db_framep_ = (char **) 0x8f17ed0 result = 0 select_lex = (SELECT_LEX *) 0x8ef847c first_table = (TABLE_LIST *) 0x8f190a0 all_tables = (TABLE_LIST *) 0x8f190a0 unit = (SELECT_LEX_UNIT *) 0x8ef8254 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #16 0x082332cf in mysql_parse (thd=0x8ef81b0, inBuf=0x8f17dc8 "select\n t.id, t.name,\n (select min(c.id)\n from tables ttt, columns ccc \n where ttt.id = ccc.table_id\n and ttt.id = t.id\n group by ttt.id) as minid\n from tables t, columns c\n where t.id ="..., length=211) at sql_parse.cc:5738 lex = (LEX *) 0x8ef81f0 _db_func_ = 0x887da20 "\210Zn\b" _db_file_ = 0x8233c3c "\203Ä ¡ÔA\210\b\205Àt/\203ì\bh\fxj\bhÌ\006" _db_level_ = 1130644248 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" ---Type to continue, or q to quit--- #17 0x08233cbb in dispatch_command (command=COM_QUERY, thd=0x8ef81b0, packet=0x8f0fd69 "", packet_length=212) at sql_parse.cc:1745 packet_end = 0x8f17e9b "" net = (NET *) 0x8ef89b4 _db_func_ = 0x4
_db_file_ = 0x0 error = false _db_level_ = 16777216 _db_framep_ = (char **) 0x8ef92a4 #18 0x08235058 in do_command (thd=0x8ef81b0) at sql_parse.cc:1531 packet = 0x8f0fd68 "\001" old_timeout = 30 packet_length = 212 net = (NET *) 0x8ef89b4 command = COM_QUERY _db_func_ = 0x43644378 "XDdCdT#\b°\201ï\b\001" _db_file_ = 0x8ef93c0 "è\235ñ\b" _db_level_ = 150052328 _db_framep_ = (char **) 0x1010 #19 0x08235464 in handle_one_connection (arg=0x8ef81b0) at sql_parse.cc:1174 error = 0 net = (NET *) 0x8ef89b4 sctx = (Security_context *) 0x8ef9188 thd = (class THD *) 0x8ef81b0 launch_time = 0 set = {__val = {0 }} #20 0x40050297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #21 0x4018b37e in clone () from /lib/tls/libc.so.6 No symbol table info available. #22 0x43644bb0 in ?? () No symbol table info available. (gdb)