[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)