[New Thread 1114618800 (LWP 546)] [New Thread 1114819504 (LWP 547)] /home/miguel/dbs/4.1/libexec/mysqld: ready for connections. Version: '4.1.23-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread 1129888688 (LWP 549)] mysqld: handler.h:321: int handler::ha_index_init(uint): Assertion `inited==NONE' failed. Program received signal SIGABRT, Aborted. [Switching to Thread 1129888688 (LWP 549)] 0xffffe410 in __kernel_vsyscall () (gdb) bt full #0 0xffffe410 in __kernel_vsyscall () No symbol table info available. #1 0x4021f541 in raise () from /lib/tls/libc.so.6 No symbol table info available. #2 0x40220dbb in abort () from /lib/tls/libc.so.6 No symbol table info available. #3 0x40218925 in __assert_fail () from /lib/tls/libc.so.6 No symbol table info available. #4 0x081e3f85 in QUICK_SELECT (this=0x8cae1b8, thd=0x8c79958, table=0x0, key_nr=0, no_alloc=false) at handler.h:321 No locals. #5 0x081e8f7c in SQL_SELECT::test_quick_select (this=0x8cb8f60, thd=0x8c79958, keys_to_use={map = 4}, prev_tables=0, limit=4294967295, force_quick_range=false) at opt_range.cc:2693 key = (SEL_ARG **) 0x8cbedd0 end = (SEL_ARG **) 0x8cbedd0 best_key = (SEL_ARG **) 0x8cbedcc old_root = (MEM_ROOT *) 0x8c7996c alloc = {free = 0x8cbed50, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 1992, block_num = 5, first_block_usage = 0, error_handler = 0x81449ba } tree = (SEL_TREE *) 0x8cbedc8 key_info = param = {thd = 0x8c79958, table = 0x8cafa38, key_parts = 0x8cbed60, key_parts_end = 0x8cbed74, key = {0x8cbed60, 0x5, 0x9999999a, 0x40019999, 0xa5a5a5a5, 0x8cb9044, 0x8c7996c, 0x8cbada8, 0x1, 0x8cbadb4, 0x8cbadb4, 0x0, 0x0, 0x401c0000, 0x20202020, 0x4, 0xa5a5a5a5, 0x435899a8, 0x8cb0048, 0x8cb0044, 0x14, 0x0, 0xa5a5a5a5, 0x2, 0x8c79958, 0x8cafa38, 0x8cbad40, 0x8cbad68, 0x8cbad40, 0x8cbad54, 0xa5a5a5a5 }, mem_root = 0x4358a838, prev_tables = 0, read_tables = 1, current_table = 2, baseflag = 73420185, keys = 1, max_key_part = 0, range_count = 1, real_keynr = {2, 2779096485 , 1129883816, 1, 0, 0, 0, 2, 0, 73420185, 2, 0, 1, 2, 4, 2779096485 }, min_key = "\002\000\000\000", '¥' , "./dhd8c4177d09f8b11f5.52725521 ", '\0' , "#\223%@", '\0' , "°»XCô/1@^1K\b\000\000\000\000¤ XC¢8#@À XC^1K\b", '\0' , "°»XC\020=#@\000\000\000\000\000\000\000\000t XCD XC", '\0' , " \037Ë\bX\231Ç\bT¡XC", '\0' , "ÿÿÿÿ\005\000\000\000Y1K\b\000\000\000\000D XC\002", '\0' ..., max_key = "\003", '\0' , "tMK\b\210¡XC¼rA\b\032\000\000\000\000\000\000\000\210¡XC¼[\026\b)MË\bØ\001Ë\b\032\000\000\000\036MB\b Vc\b\2007c\b8²XC\200/`\b`3`\bH¡Ç\bÈ¡XC `\026\bH¡Ç\bØ\001Ë\b\032\000\000\000\205æ\027@X\231Ç\bü¤XCØ¡XCÿ\226\025\b\001\000\000\000Ø\001Ë\b \000\000\000\200/`\bH¡Ç\b°'Ë\b\030¥XC5c\026\bH¡Ç\bØ\001Ë\b\032\000\000\000`3`\b\200/`\bü¤XCü¤XC\000\000\000\000\000\000\000\0000ñFC\030¢XCÙ\aA\b8"..., quick = 99, cond = 0x8cb2678} key_parts = (KEY_PART *) 0x8cbed74 idx = 1 scan_time = 2.2000000000000002 _db_func_ = 0x8cb2154 "" _db_file_ = 0x8c79958 "¨JF\bt¥`\bx¥`\b¸JF\bÐ\216Ë\bH\215Ë\bÈ\034Ë\bÈ\034Ë\b " _db_level_ = 1075308165 _db_framep_ = (char **) 0x4358a8c8 ---Type to continue, or q to quit--- #6 0x081a3a2f in test_if_quick_select (tab=0x8cb395c) at sql_select.cc:6627 No locals. #7 0x081a3cc9 in join_init_quick_read_record (tab=0x8cb395c) at sql_select.cc:6615 No locals. #8 0x081a894e in sub_select (join=0x8cb27c0, join_tab=0x8cb395c, end_of_records=false) at sql_select.cc:6195 not_exists_optimize = not_used_in_distinct = found_records = info = on_expr = (COND *) 0x0 select_cond = (COND *) 0x8cb8ed0 error = found = report_error = (my_bool *) 0x8c7a120 "" #9 0x081a8a39 in sub_select (join=0x8cb27c0, join_tab=0x8cb3818, end_of_records=false) at sql_select.cc:6221 not_exists_optimize = false not_used_in_distinct = false found_records = 0 info = (READ_RECORD *) 0x8cb383c on_expr = (COND *) 0x0 select_cond = (COND *) 0x8cb2258 error = found = true report_error = (my_bool *) 0x8c7a120 "" #10 0x081ae9fa in do_select (join=0x8cb27c0, fields=0x8c79aec, table=0x0, procedure=0x0) at sql_select.cc:6105 join_tab = (JOIN_TAB *) 0x8cb3818 end_select = (int (*)(JOIN *, st_join_table *, bool)) 0x81a3dde _db_func_ = 0x4358aa98 "تXCĦ\033\bÀ'Ë\b" _db_file_ = 0x82844a00 "" columns_list = (List *) 0x8c79aec error = _db_level_ = 147299052 _db_framep_ = (char **) 0x8c79a01 __PRETTY_FUNCTION__ = "int do_select(JOIN*, List*, TABLE*, Procedure*)" #11 0x081ba051 in JOIN::exec (this=0x8cb27c0) at sql_select.cc:1593 curr_table = end_table = _db_func_ = 0x8c79b70 "\2201Ë\b\001" ---Type to continue, or q to quit--- _db_file_ = 0x8cb27c0 "\0308Ë\b4¨XCH4Ë\b" _db_level_ = 136029786 _db_framep_ = (char **) 0x4358aad8 tmp_error = curr_join = (JOIN *) 0x8cb27c0 curr_fields_list = (List *) 0x8c79aec columns_list = curr_all_fields = (List *) 0x8cb30e8 curr_tmp_table = (TABLE *) 0x0 #12 0x081ba6c4 in mysql_select (thd=0x8c79958, rref_pointer_array=0x8c79b70, tables=0x8cb1e78, wild_num=0, fields=@0x8c79aec, conds=0x8cb2720, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2189707776, result=0x8cb27b0, unit=0x8c799a0, select_lex=0x8c79a80) at sql_select.cc:1716 err = free_join = true _db_func_ = 0x0 _db_file_ = 0x8
join = (JOIN *) 0x8cb27c0 _db_level_ = 147298668 _db_framep_ = (char **) 0x4358ab2c #13 0x081bab19 in handle_select (thd=0x8c79958, lex=0x8c79994, result=0x8cb27b0) at sql_select.cc:192 select_lex = (SELECT_LEX *) 0x8c79a80 _db_func_ = 0x0 _db_file_ = 0xc
res = _db_level_ = 1 _db_framep_ = (char **) 0x815f8db #14 0x081801a9 in mysql_execute_command (thd=0x8c79958) at sql_parse.cc:2133 result = (class select_result *) 0x8cb27b0 lex = (LEX *) 0x8c79994 select_lex = (SELECT_LEX *) 0x8c79a80 unit = (SELECT_LEX_UNIT *) 0x8c799a0 _db_func_ = 0x8c79958 "¨JF\bt¥`\bx¥`\b¸JF\bÐ\216Ë\bH\215Ë\bÈ\034Ë\bÈ\034Ë\b " _db_file_ = 0x8cb1cd8 "SELECT s.oxid FROM oxcategories v, oxcategories s WHERE s.oxrootid =\n'd8c4177d09f8b11f5.52725521' and v.oxrootid='d8c4177d09f8b11f5.52725521'\nand\n s.oxleft > v.oxleft AND s.oxleft < v.oxright" res = -1 tables = (TABLE_LIST *) 0x8cb1e78 _db_level_ = 191 _db_framep_ = (char **) 0x4358b098 ---Type to continue, or q to quit--- __PRETTY_FUNCTION__ = "void mysql_execute_command(THD*)" #15 0x08183d75 in mysql_parse (thd=0x8c79958, inBuf=0x8cb1cd8 "SELECT s.oxid FROM oxcategories v, oxcategories s WHERE s.oxrootid =\n'd8c4177d09f8b11f5.52725521' and v.oxrootid='d8c4177d09f8b11f5.52725521'\nand\n s.oxleft > v.oxleft AND s.oxleft < v.oxright", length=191) at sql_parse.cc:4374 lex = (LEX *) 0x8c79994 _db_func_ = 0x4358b258 "¨²XC\206T\030\b\003" _db_file_ = 0x8c79958 "¨JF\bt¥`\bx¥`\b¸JF\bÐ\216Ë\bH\215Ë\bÈ\034Ë\bÈ\034Ë\b " _db_level_ = 3 _db_framep_ = (char **) 0xc0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" #16 0x081844c2 in dispatch_command (command=COM_QUERY, thd=0x8c79958, packet=0x8ca9c79 "", packet_length=192) at sql_parse.cc:1530 packet_end = 0x8cb1d97 "" net = (NET *) 0x8c79eb8 _db_func_ = 0x4358b288 "\036" _db_file_ = 0x1
error = _db_level_ = 1129886324 _db_framep_ = (char **) 0x4358b278 #17 0x08185486 in do_command (thd=0x8c79958) at sql_parse.cc:1331 packet = 0x8ca9c78 "\001" old_timeout = 30 packet_length = 192 net = (NET *) 0x8c79eb8 command = COM_QUERY _db_func_ = 0x1000
_db_file_ = 0x2000
_db_level_ = 147303140 _db_framep_ = (char **) 0x815db2c #18 0x08186053 in handle_one_connection (arg=0x8c79958) at sql_parse.cc:1063 error = net = (NET *) 0x8c79eb8 thd = (class THD *) 0x8c79958 set = {__val = {0 }} #19 0x4017b297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #20 0x402b637e in clone () from /lib/tls/libc.so.6 No symbol table info available. #21 0x4358bbb0 in ?? () ---Type to continue, or q to quit--- No symbol table info available. (gdb)