[New Thread 1098410928 (LWP 28549)] 060712 17:19:36 [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 1130646448 (LWP 28576)] [Thread 1130646448 (zombie) exited] [New Thread 1130646448 (LWP 28578)] mysqld: table.cc:2796: virtual void Field_iterator_table_ref::next(): Assertion `table_ref' failed. Program received signal SIGABRT, Aborted. [Switching to Thread 1130646448 (LWP 28578)] 0xffffe410 in __kernel_vsyscall () (gdb) bt full #0 0xffffe410 in __kernel_vsyscall () No symbol table info available. #1 0x400f4541 in raise () from /lib/tls/libc.so.6 No symbol table info available. #2 0x400f5dbb in abort () from /lib/tls/libc.so.6 No symbol table info available. #3 0x400ed925 in __assert_fail () from /lib/tls/libc.so.6 No symbol table info available. #4 0x0825e69e in Field_iterator_table_ref::next (this=0x43643054) at table.cc:2796 __PRETTY_FUNCTION__ = "virtual void Field_iterator_table_ref::next()" #5 0x082511e2 in mark_common_columns (thd=0x8ee0808, table_ref_1=0x8f021d0, table_ref_2=0x8f03908, using_fields=0x0, found_using_fields=0x43643174) at sql_base.cc:3731 found = false field_name_1 = 0x8ee1e31 "id1" nj_col_2 = (Natural_join_column *) 0x0 arena = (class Query_arena *) 0x0 leaf_2 = (TABLE_LIST *) 0x0 _db_func_ = 0x0 _db_file_ = 0x1
_db_level_ = 1 _db_framep_ = (char **) 0x4364310c it_1 = { = { = {}, _vptr.Field_iterator = 0x86c8be8}, table_ref = 0x8f021d0, first_leaf = 0x8f021d0, last_leaf = 0x8f021d0, table_field_it = { = { = {}, _vptr.Field_iterator = 0x86c8b68}, ptr = 0x8ee1e10}, view_field_it = { = { = {}, _vptr.Field_iterator = 0x86c8b28}, ptr = 0x0, array_end = 0x0, view = 0x82519a3}, natural_join_it = { = { = {}, _vptr.Field_iterator = 0x86c8ba8}, column_ref_it = { = {list = 0x0, el = 0x0, prev = 0x0, current = 0x0}, }, cur_column_ref = 0x0}, field_it = 0x436430a8} it_2 = { = { = {}, _vptr.Field_iterator = 0x86c8be8}, table_ref = 0x0, first_leaf = 0x8f02570, last_leaf = 0x8f03208, table_field_it = { = { = {}, _vptr.Field_iterator = 0x86c8b68}, ptr = 0x8f00b0c}, view_field_it = { = { = {}, _vptr.Field_iterator = 0x86c8b28}, ptr = 0x0, array_end = 0x0, view = 0x436432e8}, natural_join_it = { = { = {}, _vptr.Field_iterator = 0x86c8ba8}, column_ref_it = { = {list = 0x8f03d80, el = 0x8862b1c, prev = 0x0, current = 0x0}, }, cur_column_ref = 0x0}, field_it = 0x4364307c} nj_col_1 = (Natural_join_column *) 0x8f0df40 backup = {_vptr.Query_arena = 0x867f4e8, free_list = 0x1, mem_root = 0x0, is_backup_arena = false, state = 143010588} result = true first_outer_loop = true ---Type to continue, or q to quit--- leaf_1 = (TABLE_LIST *) 0x8f021d0 __PRETTY_FUNCTION__ = "bool mark_common_columns(THD*, TABLE_LIST*, TABLE_LIST*, List*, uint*)" #6 0x08251b7f in store_top_level_join_columns (thd=0x8ee0808, table_ref=0x8f03af0, left_neighbor=0x0, right_neighbor=0x0) at sql_base.cc:4102 table_ref_2 = (TABLE_LIST *) 0x8f03908 using_fields = (List *) 0x0 operand_it = { = {list = 0x8f03c88, el = 0x8f03cc0, prev = 0x0, current = 0x0}, } table_ref_1 = (TABLE_LIST *) 0x8f021d0 found_using_fields = 0 arena = (class Query_arena *) 0x0 backup = {_vptr.Query_arena = 0x867f4e8, free_list = 0x8170d46, mem_root = 0x43643208, is_backup_arena = false, state = 1130640152} _db_func_ = 0x401e98a0 "" _db_file_ = 0x40132ea6 "\205À\211Çt;e\203=\f" result = true _db_level_ = 140320439 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "bool store_top_level_join_columns(THD*, TABLE_LIST*, TABLE_LIST*, TABLE_LIST*)" #7 0x08251d61 in setup_natural_join_row_types (thd=0x8ee0808, from_clause=0x8ee0bb4, context=0x8ee0b0c) at sql_base.cc:4203 table_ref_it = { = {list = 0x8ee0bb4, el = 0x8862b1c, prev = 0x0, current = 0x0}, } table_ref = (TABLE_LIST *) 0x8f03af0 left_neighbor = (TABLE_LIST *) 0x0 right_neighbor = (TABLE_LIST *) 0x0 __PRETTY_FUNCTION__ = "bool setup_natural_join_row_types(THD*, List*, Name_resolution_context*)" #8 0x08252329 in setup_tables (thd=0x8ee0808, context=0x8ee0b0c, from_clause=0x8ee0bb4, tables=0x8f021d0, conds=0x8f0dc6c, leaves=0x436432f4, select_insert=false) at sql_base.cc:4501 _db_func_ = 0x0 _db_file_ = 0x0 first_select_table = (TABLE_LIST *) 0x0 tablenr = 6 _db_level_ = 4294967295 _db_framep_ = (char **) 0xffffffff table_list = (TABLE_LIST *) 0x0 __PRETTY_FUNCTION__ = "bool setup_tables(THD*, Name_resolution_context*, List*, TABLE_LIST*, Item**, TABLE_LIST**, bool)" #9 0x082523af in setup_tables_and_check_access (thd=0x8ee0808, context=0x8ee0b0c, from_clause=0x8ee0bb4, tables=0x8f021d0, conds=0x8f0dc6c, leaves=0x8ee0bc8, select_insert=false, want_access=1) at sql_base.cc:4541 leaves_tmp = (TABLE_LIST *) 0x8f021d0 #10 0x0827b6a4 in JOIN::prepare (this=0x8f0cec0, rref_pointer_array=0x8ee0c00, tables_init=0x8f021d0, wild_num=1, conds_init=0x0, og_num=0, order_init=0x0, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x8ee0ad8, unit_arg=0x8ee08ac) at sql_select.cc:343 ---Type to continue, or q to quit--- _db_func_ = 0x1fc8
_db_file_ = 0x1fc8
_db_level_ = 0 _db_framep_ = (char **) 0x14 #11 0x08282698 in mysql_select (thd=0x8ee0808, rref_pointer_array=0x8ee0c00, tables=0x8f021d0, wild_num=1, fields=@0x8ee0b64, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2189707776, result=0x8f03d38, unit=0x8ee08ac, select_lex=0x8ee0ad8) at sql_select.cc:1919 err = 22 free_join = true _db_func_ = 0x43643438 "" _db_file_ = 0x4364347c "HB\037\b(\bî\b8=ð\b¨4dCØú\"\b8=ð\bÐ!ð\b¬\bî\b8=ð\b\b\bî\b" join = (JOIN *) 0x8f0cec0 _db_level_ = 788 _db_framep_ = (char **) 0x834f624 #12 0x08282a17 in handle_select (thd=0x8ee0808, lex=0x8ee0848, result=0x8f03d38, setup_tables_done_option=0) at sql_select.cc:254 unit = (SELECT_LEX_UNIT *) 0x8ee08ac select_lex = (SELECT_LEX *) 0x8ee0ad8 _db_func_ = 0x8f03d38 "èòg\b\b\bî\b\217\217\217\217" _db_file_ = 0x822fad8 "\203Ä\020ºèòg\b\213E\b\211\020\213E\bÇ@\f" res = 8 _db_level_ = 1130640552 _db_framep_ = (char **) 0x8f03d38 #13 0x08224e2b in mysql_execute_command (thd=0x8ee0808) at sql_parse.cc:2565 result = (class select_result *) 0x8f03d38 res = false lex = (LEX *) 0x8ee0848 _db_func_ = 0x8ee0b0c "" _db_file_ = 0x8f02110 "\034+\206\b\f\vî\bh8e\b" _db_level_ = 135717288 _db_framep_ = (char **) 0x43643ca8 need_start_waiting = false result = 0 select_lex = (SELECT_LEX *) 0x8ee0ad8 first_table = (TABLE_LIST *) 0x8f021d0 all_tables = (TABLE_LIST *) 0x8f021d0 unit = (SELECT_LEX_UNIT *) 0x8ee08ac __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #14 0x0822cb59 in mysql_parse (thd=0x8ee0808, inBuf=0x8f02040 "SELECT *\n\nFROM t1 NATURAL JOIN (\n \n t2 JOIN (\n \n t3 NATURAL JOIN t4,\n t5 NATURAL JOIN t6)\n ON (---Type to continue, or q to quit--- t3.id3 = t2.id3\n AND t5.id5 = t2.id5)\n)", length=155) at sql_parse.cc:5839 lex = (LEX *) 0x8ee0848 _db_func_ = 0x8867a80 "(#m\b" _db_file_ = 0x822d4c1 "\203Ä ¡\224Å\206\b\205Àt/\203ì\bhÌ\004i\bhÙ\006" _db_level_ = 1130644248 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" #15 0x0822d540 in dispatch_command (command=COM_QUERY, thd=0x8ee0808, packet=0x8ef9fe1 "SELECT *\n\nFROM t1 NATURAL JOIN (\n \n t2 JOIN (\n \n t3 NATURAL JOIN t4,\n t5 NATURAL JOIN t6)\n ON (t3.id3 = t2.id3\n AND t5.id5 = t2.id5)\n)", packet_length=156) at sql_parse.cc:1758 packet_end = 0x8f020db "" net = (NET *) 0x8ee1018 _db_func_ = 0x4
_db_file_ = 0x0 error = false _db_level_ = 16777216 _db_framep_ = (char **) 0x8ee190c #16 0x0822e8c0 in do_command (thd=0x8ee0808) at sql_parse.cc:1544 packet = 0x8ef9fe0 "\003SELECT *\n\nFROM t1 NATURAL JOIN (\n \n t2 JOIN (\n \n t3 NATURAL JOIN t4,\n t5 NATURAL JOIN t6)\n ON (t3.id3 = t2.id3\n AND t5.id5 = t2.id5)\n)" old_timeout = 30 packet_length = 156 net = (NET *) 0x8ee1018 command = COM_QUERY _db_func_ = 0x43644378 "XDdCÌì\"\b\b\bî\b\001" _db_file_ = 0x8ee1a28 "`@ð\b" _db_level_ = 149962848 _db_framep_ = (char **) 0x1010 #17 0x0822eccc in handle_one_connection (arg=0x8ee0808) at sql_parse.cc:1175 error = 0 net = (NET *) 0x8ee1018 sctx = (Security_context *) 0x8ee17f0 thd = (class THD *) 0x8ee0808 launch_time = 0 set = {__val = {0 }} #18 0x40050297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #19 0x4018b37e in clone () from /lib/tls/libc.so.6 No symbol table info available. ---Type to continue, or q to quit--- #20 0x43644bb0 in ?? () No symbol table info available. (gdb)