(gdb) run Starting program: /home/miguel/dbs/5.0/libexec/mysqld [Thread debugging using libthread_db enabled] [New Thread -1208920384 (LWP 17949)] [New Thread -1220498544 (LWP 17954)] [New Thread -1230988400 (LWP 17955)] [New Thread -1241478256 (LWP 17956)] [New Thread -1251968112 (LWP 17957)] InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 070619 20:37:19 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 070619 20:37:19 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 070619 20:37:19 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... [New Thread -1262462064 (LWP 17963)] [New Thread -1272951920 (LWP 17964)] InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created [New Thread -1285559408 (LWP 17967)] 070619 20:37:20 InnoDB: Started; log sequence number 0 0 [New Thread -1304441968 (LWP 17969)] 070619 20:37:20 [Note] /home/miguel/dbs/5.0/libexec/mysqld: ready for connections. Version: '5.0.46-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread -1304642672 (LWP 18059)] mysqld: mi_search.c:495: _mi_prefix_search: Assertion `vseg < vseg_end' failed. Program received signal SIGABRT, Aborted. [Switching to Thread -1304642672 (LWP 18059)] 0x00937402 in __kernel_vsyscall () (gdb) bt full #0 0x00937402 in __kernel_vsyscall () No symbol table info available. #1 0x00138d40 in raise () from /lib/libc.so.6 No symbol table info available. #2 0x0013a591 in abort () from /lib/libc.so.6 No symbol table info available. #3 0x0013238b in __assert_fail () from /lib/libc.so.6 No symbol table info available. #4 0x0850e1f7 in _mi_prefix_search (info=0xa065dc0, keyinfo=0xa065bd8, page=0xa066149 '¥' ..., key=0xa066850 "\b\200", key_len=9, nextflag=97, ret_pos=0xb23c7794, buff=0xa066820 "\t\200", last_key=0xb23c779b "\b") at mi_search.c:495 vseg_end = (uchar *) 0xa066140 "\002en" left = 0 k = (uchar *) 0xa066859 "\037\002en" packed = 128 flag = 0 my_flag = 0 nod_flag = 0 length = 10 len = 9 matched = 9 cmplen = 8 kseg_len = 8 prefix_len = 8 suffix_len = 1 key_len_skip = 9 seg_len_pack = 1 key_len_left = 0 end = (uchar *) 0xa066149 '¥' ... kseg = (uchar *) 0xa066851 "\200" vseg = (uchar *) 0xa066140 "\002en" sort_order = (uchar *) 0x0 tt_buff = "ã8\t\200\000\000\000\000\000\000\000Ó\030\b\210r<²\000\000\000\000hr<²\234r<²\b.\037\b\000\000\000\000Èr<²u};\b\034\000\000\000\000\000\000\000\024\000\000\000\000\000\000\000Ày<²\004\000\000\000\t\000\000\000\000\000\000\000\t\000\000\000\000D\000\001\234r<² \000\000\000\001\000\000\000\002\000\000\000\003\000\000\000\004\000\000\000\005\000\000\000\006\000\000\000\a\000\000\000\b", '\0' , "hs<²ÁR \bN\t\000\000`s<²\\s<²Xs<²\000\000\000\000Xs<²Ts<²\000\000\000\000@¶\005\n°s<", '\0' , "\b.\037\b8s<²Wx"... t_buff = (uchar *) 0xb23c7244 "\t\200" saved_from = (uchar *) 0xa066133 "\037\002en" saved_to = (uchar *) 0xa066829 " \002en" saved_vseg = (uchar *) 0xa06613f " \002en" saved_length = 10 saved_prefix_len = 8 ---Type to continue, or q to quit--- length_pack = 1 _db_func_ = 0x0 _db_file_ = 0x6
_db_level_ = 32 _db_framep_ = (char **) 0x1 __PRETTY_FUNCTION__ = "_mi_prefix_search" #5 0x0852e32e in _mi_search_pos (info=0xa065dc0, keyinfo=0xa065bd8, key=0xa066850 "\b\200", key_len=9, nextflag=97, pos=1024) at mi_range.c:214 flag = 12252124 nod_flag = 0 keynr = 28 max_keynr = 0 after_key = 8 '\b' keypos = (uchar *) 0xa06613d "\210\001 \002en" buff = (uchar *) 0xa065ff0 "\001Y\t\200" offset = 7.8433957155093585e-314 _db_func_ = 0x8
_db_file_ = 0x8
_db_level_ = 2 _db_framep_ = (char **) 0x1 #6 0x0852e0b8 in _mi_record_pos (info=0xa065dc0, key=0xb23c7e34 "\200", key_len=9, search_flag=HA_READ_KEY_EXACT) at mi_range.c:181 inx = 0 nextflag = 1 keyinfo = (MI_KEYDEF *) 0xa065bd8 key_buff = (uchar *) 0xa066850 "\b\200" pos = 3.0744675446777848e-269 _db_func_ = 0x0 _db_file_ = 0x1
_db_level_ = 137416999 _db_framep_ = (char **) 0xa05b840 #7 0x0852dd27 in mi_records_in_range (info=0xa065dc0, inx=0, min_key=0xb23c79c0, max_key=0xb23c79b4) at mi_range.c:100 start_pos = 12843276528246356472 end_pos = 1 res = 589793304443123992 _db_func_ = 0xa05b840 "" _db_file_ = 0xa05b700 "\003" _db_level_ = 168146680 _db_framep_ = (char **) 0xa05b6f8 #8 0x0831c950 in ha_myisam::records_in_range (this=0xa05ee68, inx=0, min_key=0xb23c79c0, max_key=0xb23c79b4) at ha_myisam.cc:1899 No locals. #9 0x082fbaca in check_quick_keys (param=0xb23c7bf4, idx=0, key_tree=0xa05b840, min_key=0xb23c7e34 "\200", min_key_flag=0, max_key=0xb23c8d32 "\200", max_key_flag=0) at opt_range.cc:5967 ---Type to continue, or q to quit--- min_range = {key = 0xb23c7e34 "\200", length = 9, flag = HA_READ_KEY_EXACT} max_range = {key = 0xb23c8d32 "\200", length = 9, flag = HA_READ_AFTER_KEY} records = 0 tmp = 722184525890715648 tmp_min_flag = 0 tmp_max_flag = 0 keynr = 0 min_key_length = 9 max_key_length = 9 tmp_min_key = 0xb23c7e3d "" tmp_max_key = 0xb23c8d3b "" save_first_null_comp = 0 '\0' #10 0x082fe267 in check_quick_select (param=0xb23c7bf4, idx=0, tree=0xa05b840) at opt_range.cc:5768 records = 0 cpk_scan = false key = 0 _db_func_ = 0x0 _db_file_ = 0x0 _db_level_ = 0 _db_framep_ = (char **) 0xb700 key_alg = HA_KEY_ALG_UNDEF #11 0x08302511 in get_key_scans_params (param=0xb23c7bf4, tree=0xa05b700, index_read_must_be_used=false, read_time=10.416796874999999) at opt_range.cc:3456 keynr = 0 read_index_only = false cpu_cost = 4.9406564584124654e-324 found_records = 12843312242372228800 found_read_time = 2.2067241028742691e-260 idx = 0 key = (SEL_ARG **) 0xa05b704 end = (SEL_ARG **) 0xa05b708 key_to_read = (SEL_ARG **) 0x0 best_records = 0 read_plan = (TRP_RANGE *) 0x0 pk_is_clustered = false _db_func_ = 0x0 _db_file_ = 0x0 _db_level_ = 168162872 _db_framep_ = (char **) 0x3c9c3c #12 0x0830a320 in SQL_SELECT::test_quick_select (this=0xa060bb8, thd=0xa026380, keys_to_use={map = 1}, prev_tables=0, limit=18446744073709551615, force_quick_range=false) at opt_range.cc:2095 range_trp = (TRP_RANGE *) 0x8280fec ---Type to continue, or q to quit--- rori_trp = (TRP_ROR_INTERSECT *) 0xa027834 can_build_covering = false alloc = {free = 0xa05b6c0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 1992, block_num = 5, first_block_usage = 0, error_handler = 0x81e2756 } tree = (SEL_TREE *) 0xa05b700 key_info = (KEY *) 0xa05ee1c param = {thd = 0xa026380, table = 0xa05e610, key_parts = 0xa05b6d0, key_parts_end = 0xa05b6f8, key = {0xa05b6d0, 0xb23c7c24, 0x8700fa0, 0xb23c7e34, 0xb23c808c, 0x0, 0x80, 0x2e00000c, 0x7365742f, 0x2f74, 0x0 , 0x1, 0x800, 0x0, 0x400, 0x0, 0x800, 0x0, 0x400, 0x0, 0xb23c7f98, 0x8579102, 0xb23c8024, 0xb23c8028, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, mem_root = 0xb23c9c70, old_root = 0xa027834, prev_tables = 0, read_tables = 0, current_table = 1, baseflag = 341986713, max_key_part = 0, range_count = 1, keys = 1, real_keynr = {0, 7, 0, 0, 0, 2990309320, 139953176, 220, 2990308784, 2990308780, 2990308776, 2990308780, 2990308776, 2990308772, 2990308760, 2990308764, 2990308760, 2990308756, 139954301, 2990309956, 3, 2990309303, 2990308793, 3, 2990308797, 2990309403, 2990308790, 2990309956, 7, 168153552, 139954403, 2990309395, 2990317920, 168151208, 139947716, 2990309508, 2990314596, 7, 139947716, 2990309555, 2990310676, 7, 0, 2990314615, 2990309508, 2990308920, 139947633, 65, 2990308912, 2990308920, 168188096, 17301246, 2013332224, 1677766656, 33605632, 65536, 264, 0, 0, 0, 0, 0, 0, 0}, min_key = "\200\000\000\000\000\000\000\000 ", '\0' , "ÿÿÿÿÿÿÿÿ\000\000\000\000\000\000\000\000\035F", '\0' , "Ð[\006\np]\006\nx]\006\n", '\0' , "\001", '\0' , "ãhxFãhxF\000\000\000\000\000\000\000\000ÿ", '\0' , "È\000\000\000\000\000\000\000\000\004\000\000\000\000\000\000ÿÿÿÿÿÿ\000\000\000üÿÿÿÿÿ\003", '\0' , "ç\001\000\000\000\004\000\000(\177<²½:»", '\0' , "\004\000\000ñâº\000Ì\227±\t\001\004\000\000\000F\000\000\230\177<²dÐ?"..., max_key = "\200\000\000\000\000\000\000\000 \000\002en\000\000\000\000\001°\210\001\006\002en\000\000\000\000\002\034\210\001\t\002en\000\000\000\000\002£\b\000\000ÿÿÿÿ\000\000\000\002\006\000\000\000\000\000\000\000\000\000\000\003\030\210\001\f\002en\000\000\000\000\003\\\210\001\r\002en\000\000\000\000\003¤\210\001\016\002en\000\000\000\000\004", '\0' , "p\210\001\020\002en\000\000\000\000\004Ð\210\001\021\002en\000\000\000\000\0054\210\001\022\002en\000\000\000\000\005¨\210\001\023\002en\000\000\000\000\000\001\210\001\024\002en\000\000\000\000\006\224\210\001\025\002en\000\000\000\000\a\004\210\001\026\002en\000\000\000\000\at\210\001\030"..., quick = 255, cond = 0xa05f688, fields_bitmap_size = 1, needed_fields = {bitmap = 0xa05b6f8 "\036¥¥¥¥¥¥¥\003", bitmap_size = 1, mutex = 0x0}, tmp_covered_fields = {bitmap = 0x0, bitmap_size = 136930450, mutex = 0xa05efa8}, needed_reg = 0xa060ca0, imerge_cost_buff = 0xb23c9c94, imerge_cost_buff_size = 0, is_ror_scan = false, n_ranges = 1, first_null_comp = 0 '\0', alloced_sel_args = 0} key_parts = (KEY_PART *) 0xa05b6f8 best_trp = (TABLE_READ_PLAN *) 0x0 group_trp = (TRP_GROUP_MIN_MAX *) 0x0 best_read_time = 10.416796874999999 idx = 1 scan_time = 6.5999999999999996 _db_func_ = 0xa05b290 "" _db_file_ = 0xa05e610 "<ì\005\nhî\005\n" _db_level_ = 2990316748 _db_framep_ = (char **) 0xb23c9cd0 #13 0x08288798 in get_quick_record_count (thd=0xa026380, select=0xa060bb8, table=0xa05e610, keys=0xa060998, limit=18446744073709551615) at sql_select.cc:2291 error = 0 _db_func_ = 0x0 _db_file_ = 0xa060bb8 "" _db_level_ = 0 _db_framep_ = (char **) 0x0 #14 0x0829c413 in make_join_statistics (join=0xa05f800, tables=0x0, conds=0xa05f688, keyuse_array=0xa060520) at sql_select.cc:2688 ---Type to continue, or q to quit--- records = 0 select = (SQL_SELECT *) 0xa060bb8 error = 0 table = (TABLE *) 0xa05e610 i = 1 table_count = 1 const_count = 0 key = 0 found_const_table_map = 0 all_table_map = 1 found_ref = 0 refs = 0 const_ref = {map = 1} eq_part = {map = 1} table_vector = (TABLE **) 0xa060b68 stat = (JOIN_TAB *) 0xa0608f0 stat_end = (JOIN_TAB *) 0xa060a70 s = (JOIN_TAB *) 0xa0608f0 stat_ref = (JOIN_TAB **) 0xa060a70 keyuse = (KEYUSE *) 0xa05b290 start_keyuse = (KEYUSE *) 0xa05b260 outer_join = 0 sargables = (SARGABLE_PARAM *) 0xa060bac stat_vector = {0xa0608f0, 0x0, 0x8177fcd, 0xb23c9f50, 0x0, 0xb23c9e88, 0x81c5b95, 0xb23c9f50, 0x0, 0xb23c9e98, 0x81c5bb7, 0xb23c9f48, 0x0, 0xb23c9f88, 0x8295c56, 0xb23c9f48, 0x109, 0x0, 0xb23c9f0c, 0x10d, 0x0, 0x0, 0x8191ea9, 0x1, 0x0, 0x9ef8, 0xa05f688, 0x10d, 0x0, 0x109, 0x0, 0x1, 0x0, 0xa05f688, 0xa026380, 0xa027834, 0xa060850, 0xb23c9f08, 0x8177f5d, 0xa060850, 0xa0607c0, 0xb23c9f38, 0x1, 0x8835570, 0xb23c9f10, 0x0, 0xa040d70, 0xa060850, 0xa060850, 0xb23c9f68, 0x81848b3, 0xa05f638, 0xa060850, 0x1, 0x0, 0x1, 0x0, 0x0, 0x818da5e, 0xa05f601, 0x0, 0xb23c9fe8} _db_func_ = 0xa05f5a0 "¨\ab\b" _db_file_ = 0x828f912 "\204Àt?\213Eð\017¶@2\204Àt\031\213E\f\213" _db_level_ = 2990317544 _db_framep_ = (char **) 0xa026380 ref_changed = 0 #15 0x0829ed57 in JOIN::optimize (this=0xa05f800) at sql_select.cc:897 _db_func_ = 0xa05f3e0 "" _db_file_ = 0xa05f3e0 "" _db_level_ = 167932844 _db_framep_ = (char **) 0xa170 sel = (SELECT_LEX *) 0xa027318 #16 0x082a2214 in mysql_select (thd=0xa026380, rref_pointer_array=0xa02743c, tables=0xa05f3e0, wild_num=1, fields=@0xa0273ac, conds=0xa05f688, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2156153344, result=0xa05f7f0, unit=0xa0270e0, select_lex=0xa027318) at sql_select.cc:2234 err = false ---Type to continue, or q to quit--- free_join = true _db_func_ = 0xffffffff
_db_file_ = 0xffffffff
_db_level_ = 0 _db_framep_ = (char **) 0x0 join = (JOIN *) 0xa05f800 #17 0x082a65a6 in handle_select (thd=0xa026380, lex=0xa027088, result=0xa05f7f0, setup_tables_done_option=0) at sql_select.cc:255 unit = (SELECT_LEX_UNIT *) 0xa0270e0 res = 10 select_lex = (SELECT_LEX *) 0xa027318 _db_func_ = 0xa05f7f0 "h°d\b\200c\002\nàp\002\n" _db_file_ = 0x820d750 "\211Â\213E\b\211P\004ÉÃU\211å\203ì\b\213E\b\211\004$èõc" _db_level_ = 2990318296 _db_framep_ = (char **) 0x10 #18 0x0823c11e in mysql_execute_command (thd=0xa026380) at sql_parse.cc:2664 sel_result = (class select_result *) 0xa05f7f0 res = false need_start_waiting = false up_result = 0 lex = (LEX *) 0xa027088 select_lex = (SELECT_LEX *) 0xa027318 first_table = (TABLE_LIST *) 0xa05f3e0 all_tables = (TABLE_LIST *) 0xa05f3e0 unit = (SELECT_LEX_UNIT *) 0xa0270e0 _db_func_ = 0xe8
_db_file_ = 0x24a150 "xk\006\n°\f\004\nH\f\004\n°\f\004\n`\236\002\nÀ\236\002\np|\002\np|\002\np?\003\np?\003\np¡$" _db_level_ = 0 _db_framep_ = (char **) 0xa027834 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #19 0x082444d1 in mysql_parse (thd=0xa026380, inBuf=0xa05f298 "SELECT * FROM ACTIVITY_I18N WHERE ACTIVITY_ID = 32", length=50, found_semicolon=0xb23cb1d0) at sql_parse.cc:6068 lex = (LEX *) 0xa027088 lip = {m_thd = 0xa026380, yylineno = 1, yytoklen = 2, yylval = 0xb23ca364, ptr = 0xa05f2cb '\217' , "pU\203\bLs\002\n¨\ab\b", tok_start = 0xa05f2cb '\217' , "pU\203\bLs\002\n¨\ab\b", tok_end = 0xa05f2cb '\217' , "pU\203\bLs\002\n¨\ab\b", end_of_query = 0xa05f2ca "", tok_start_prev = 0xa05f2ca "", buf = 0xa05f298 "SELECT * FROM ACTIVITY_I18N WHERE ACTIVITY_ID = 32", next_state = MY_LEX_END, found_semicolon = 0x0, ignore_space = false, stmt_prepare_mode = false} err = 0 _db_func_ = 0x0 _db_file_ = 0xb23cacd8 "\210²<²Ìl$\b\200c\002\n\230ò\005\n2" _db_level_ = 0 _db_framep_ = (char **) 0x4dab __PRETTY_FUNCTION__ = "void mysql_parse(THD*, const char*, uint, const char**)" ---Type to continue, or q to quit--- #20 0x08246ccc in dispatch_command (command=COM_QUERY, thd=0xa026380, packet=0xa057239 "SELECT * FROM ACTIVITY_I18N WHERE ACTIVITY_ID = 32", packet_length=51) at sql_parse.cc:1812 packet_end = 0xa05f2ca "" format = 0x865b63f "%.*b" found_semicolon = 0x0 net = (NET *) 0xa0263e4 error = false _db_func_ = 0xb23cb260 "\200²<²|²<²x²<²|\2171\b\207\b" _db_file_ = 0xb23cb234 "" _db_level_ = 51 _db_framep_ = (char **) 0x2d9 #21 0x08248211 in do_command (thd=0xa026380) at sql_parse.cc:1586 packet = 0xa057238 "\003SELECT * FROM ACTIVITY_I18N WHERE ACTIVITY_ID = 32" packet_length = 51 net = (NET *) 0xa0263e4 command = COM_QUERY _db_func_ = 0x821109f "\213E\bÆ\200|\n" _db_file_ = 0xb23cb2c8 "äc\002\n\003" _db_level_ = 2990322380 _db_framep_ = (char **) 0xb23cb2d0 #22 0x082493ee in handle_one_connection (arg=0xa026380) at sql_parse.cc:1197 error = 0 net = (NET *) 0xa0263e4 sctx = (Security_context *) 0xa026bcc thd = (class THD *) 0xa026380 launch_time = 1 set = {__val = {0 }} #23 0x00bac3db in start_thread () from /lib/libpthread.so.0 No symbol table info available. #24 0x001dd26e in clone () from /lib/libc.so.6 No symbol table info available. (gdb)