[New Thread 1098410928 (LWP 6120)] 060705 11:52:26 [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 6122)] mysqld: ha_myisam.cc:1173: virtual int ha_myisam::index_read(byte*, const byte*, uint, ha_rkey_function): Assertion `inited==INDEX' failed. Program received signal SIGABRT, Aborted. [Switching to Thread 1130646448 (LWP 6122)] 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 0x082f487f in ha_myisam::index_read (this=0x8f3d520, buf=0x8f3d610 "¥\001", key=0x8f14e58 "\001", key_len=16, find_flag=HA_READ_BEFORE_KEY) at ha_myisam.cc:1173 error = 1130639088 __PRETTY_FUNCTION__ = "virtual int ha_myisam::index_read(byte*, const byte*, uint, ha_rkey_function)" #5 0x082db9ff in QUICK_SELECT_DESC::get_next (this=0x8f155f8) at opt_range.cc:6696 result = 1130639096 _db_func_ = 0x86e1501 "rigcond" _db_file_ = 0x0 _db_level_ = 19321905 _db_framep_ = (char **) 0x43642f18 __PRETTY_FUNCTION__ = "virtual int QUICK_SELECT_DESC::get_next()" #6 0x082e60e8 in rr_quick (info=0x8f40a04) at records.cc:224 tmp = 149914032 #7 0x08278826 in join_init_read_record (tab=0x8f409c8) at sql_select.cc:10288 No locals. #8 0x082759aa in sub_select (join=0x8f3f198, join_tab=0x8f409c8, end_of_records=false) at sql_select.cc:9658 error = 0 rc = 150208024 report_error = (my_bool *) 0x8ef8c1c "" info = (READ_RECORD *) 0x8f40a04 #9 0x08275d07 in do_select (join=0x8f3f198, fields=0x8f183c8, table=0x0, procedure=0x0) at sql_select.cc:9422 join_tab = (JOIN_TAB *) 0x8f409c8 _db_func_ = 0xffffffff
_db_file_ = 0xffffffff
rc = 0 error = NESTED_LOOP_OK _db_level_ = 0 _db_framep_ = (char **) 0x170 #10 0x08288309 in JOIN::exec (this=0x8f3f198) at sql_select.cc:1738 _db_func_ = 0x86e15ce "JOIN::reinit" _db_file_ = 0x8266027 "\203Ä \213E\bÆ@)" ---Type to continue, or q to quit--- _db_level_ = 1130639544 _db_framep_ = (char **) 0x8f400f8 tmp_error = 1130639544 curr_join = (JOIN *) 0x8f3f198 curr_fields_list = (List *) 0x8f183c8 columns_list = (List *) 0x8f183c8 curr_all_fields = (List *) 0x8f3fed0 curr_tmp_table = (TABLE *) 0x0 __PRETTY_FUNCTION__ = "void JOIN::exec()" #11 0x081dde73 in subselect_single_select_engine::exec (this=0x8f191b8) at item_subselect.cc:1592 _db_func_ = 0x0 _db_file_ = 0x5
_db_level_ = 2 _db_framep_ = (char **) 0x7 save_where = 0x86e23dc "order clause" save_select = (SELECT_LEX *) 0x8ef847c #12 0x081d9ff3 in Item_subselect::exec (this=0x8f19128) at item_subselect.cc:199 res = 0 #13 0x081dacc1 in Item_singlerow_subselect::val_str (this=0x8f19128, str=0x8f1927c) at item_subselect.cc:479 No locals. #14 0x081af688 in Arg_comparator::compare_binary_string (this=0x8f19248) at item_cmpfunc.cc:573 res1 = (String *) 0x8f19268 res2 = (String *) 0x436431d8 #15 0x081bad36 in Arg_comparator::compare (this=0x8f19248) at item_cmpfunc.h:66 No locals. #16 0x081b0b36 in Item_func_eq::val_int (this=0x8f191d8) at item_cmpfunc.cc:940 value = 0 __PRETTY_FUNCTION__ = "virtual longlong Item_func_eq::val_int()" #17 0x082754c5 in evaluate_join_record (join=0x8f3e3a8, join_tab=0x8f400f8, error=0, report_error=0x8ef8c1c "") at sql_select.cc:9706 not_exists_optimize = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x8f191d8 #18 0x082759f4 in sub_select (join=0x8f3e3a8, join_tab=0x8f400f8, end_of_records=false) at sql_select.cc:9665 error = 0 rc = NESTED_LOOP_OK report_error = (my_bool *) 0x8ef8c1c "" info = (READ_RECORD *) 0x8f40134 #19 0x08275d07 in do_select (join=0x8f3e3a8, fields=0x8ef8504, table=0x0, procedure=0x0) at sql_select.cc:9422 ---Type to continue, or q to quit--- join_tab = (JOIN_TAB *) 0x8f400f8 _db_func_ = 0x8ef8504 "\020\177ñ\b\210\226ñ\b\006" _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 #20 0x08288309 in JOIN::exec (this=0x8f3e3a8) at sql_select.cc:1738 _db_func_ = 0x8f3f138 "Ü\212\207\b8ñó\b" _db_file_ = 0x0 _db_level_ = 149914748 _db_framep_ = (char **) 0x8f3e3a8 tmp_error = 0 curr_join = (JOIN *) 0x8f3e3a8 curr_fields_list = (List *) 0x8ef8504 columns_list = (List *) 0x8ef8504 curr_all_fields = (List *) 0x8f3f0e0 curr_tmp_table = (TABLE *) 0x0 __PRETTY_FUNCTION__ = "void JOIN::exec()" #21 0x082885f3 in mysql_select (thd=0x8ef81b0, rref_pointer_array=0x8ef85a0, tables=0x8f17f40, wild_num=1, fields=@0x8ef8504, conds=0x8f191d8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2156153344, result=0x8f19328, 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(\223ñ\b¸4dC´a#\b(\223ñ\b@\177ñ\bT\202ï\b(\223ñ\b°\201ï\b" join = (JOIN *) 0x8f3e3a8 _db_level_ = 788 _db_framep_ = (char **) 0x83540ba #22 0x082888ba in handle_select (thd=0x8ef81b0, lex=0x8ef81f0, result=0x8f19328, setup_tables_done_option=0) at sql_select.cc:250 unit = (SELECT_LEX_UNIT *) 0x8ef8254 select_lex = (SELECT_LEX *) 0x8ef847c _db_func_ = 0x8f19328 "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 **) 0x8f19328 #23 0x0822b712 in mysql_execute_command (thd=0x8ef81b0) at sql_parse.cc:2512 result = (class select_result *) 0x8f19328 ---Type to continue, or q to quit--- 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 **) 0x8f17e80 result = 0 select_lex = (SELECT_LEX *) 0x8ef847c first_table = (TABLE_LIST *) 0x8f17f40 all_tables = (TABLE_LIST *) 0x8f17f40 unit = (SELECT_LEX_UNIT *) 0x8ef8254 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #24 0x082332cf in mysql_parse (thd=0x8ef81b0, inBuf=0x8f17dc8 "SELECT * from t1,t2 WHERE t1.t1 = (SELECT t1.t1 FROM t1 WHERE t1.t1 < t2.t1 AND\nt1.i2=1 AND t2.i1=t1.i1 ORDER BY t1.t1 DESC LIMIT 1)", length=133) 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)" #25 0x08233cbb in dispatch_command (command=COM_QUERY, thd=0x8ef81b0, packet=0x8f0fd69 "", packet_length=134) at sql_parse.cc:1745 packet_end = 0x8f17e4d "" net = (NET *) 0x8ef89b4 _db_func_ = 0x4
_db_file_ = 0x0 error = false _db_level_ = 16777216 _db_framep_ = (char **) 0x8ef92a4 #26 0x08235058 in do_command (thd=0x8ef81b0) at sql_parse.cc:1531 packet = 0x8f0fd68 "\001" old_timeout = 30 packet_length = 134 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 ---Type to continue, or q to quit--- #27 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 }} #28 0x40050297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #29 0x4018b37e in clone () from /lib/tls/libc.so.6 No symbol table info available. #30 0x43644bb0 in ?? () No symbol table info available. (gdb)