060707 9:54:33 [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 5878)] [Thread 1130646448 (zombie) exited] [New Thread 1130646448 (LWP 5880)] [Thread 1130646448 (zombie) exited] [New Thread 1130646448 (LWP 5882)] mysqld: sql_base.cc:560: bool close_thread_table(THD*, TABLE**): Assertion `table->file->inited == handler::NONE' failed. Program received signal SIGABRT, Aborted. [Switching to Thread 1130646448 (LWP 5882)] 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 0x082532f3 in close_thread_table (thd=0x8ef81b0, table_ptr=0x8ef8990) at sql_base.cc:560 found_old_table = false _db_func_ = 0x8253482 "\203Ä \213E\b\213\200ì\a" _db_file_ = 0x43642cb8 "è,dCv\2338\b°\201ï\b" table = (TABLE *) 0x8f13dc8 _db_level_ = 0 _db_framep_ = (char **) 0x20 __PRETTY_FUNCTION__ = "bool close_thread_table(THD*, TABLE**)" #5 0x08253757 in close_thread_tables (thd=0x8ef81b0, lock_in_use=false, skip_derived=false) at sql_base.cc:523 found_old_table = false _db_func_ = 0x0 _db_file_ = 0x0 prelocked_mode = NON_PRELOCKED _db_level_ = 150243236 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "void close_thread_tables(THD*, bool, bool)" #6 0x08389b76 in sp_lex_keeper::reset_lex_and_exec_core (this=0x8f487a8, thd=0x8ef81b0, nextp=0x43642e4c, open_tables=true, instr=0x8f48780) at sp_head.cc:2193 res = 0 __PRETTY_FUNCTION__ = "int sp_lex_keeper::reset_lex_and_exec_core(THD*, uint*, bool, sp_instr*)" #7 0x0838a01e in sp_instr_set_trigger_field::execute (this=0x8f48780, thd=0x8ef81b0, nextp=0x43642e4c) at sp_head.cc:2390 _db_func_ = 0x8f48780 "(0p\bÐ\206ô\bT\203ô\b" _db_file_ = 0x8ef81b0 "èfi\b\210\231\207\b\214\231\207\büfi\b" _db_level_ = 137914963 _db_framep_ = (char **) 0x43642e98 #8 0x08386c5c in sp_head::execute (this=0x8f48340, thd=0x8ef81b0) at sp_head.cc:1068 i = (sp_instr *) 0x8f48780 hip = 1130638880 olddb = "\022\000\000\000É\001", '\0' , "ð?\001\000\000\000\000\000\000\000À\237v\b°\201ï\b\0005ñ\b¸\"ñ\b` ñ\b\002\000\000\000ø-dCÍï\\\b\fÏt\b¢Ît\bø-dC9ò\\\bÜ\000\000\000è-dCä-dCà-dCÿÿÿÿÿÿï\177\000\000\000\000øëð\b ëð\b\220/dC" dbchanged = false ---Type to continue, or q to quit--- err_status = false save_sql_mode = 0 execute_arena = {_vptr.Query_arena = 0x8696968, free_list = 0x0, mem_root = 0x43642dd8, is_backup_arena = false, state = INITIALIZED_FOR_SP} _db_func_ = 0x8696ee0 "THD::set_n_backup_active_arena" _db_file_ = 0x81fed21 "\203Ä \213E\020\212@\f%ÿ" _db_level_ = 1130639000 old_lex = (LEX *) 0x8ef81f0 old_change_list = { = {first = 0x8ef94e8, last = {_vptr.ilink = 0x8697380, prev = 0x8ef94e4, next = 0x0}}, } ctx = (sp_rcontext *) 0x8f0ebb0 save_abort_on_warning = false old_arena = (class Query_arena *) 0x8ef81bc execute_mem_root = {free = 0x0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 8136, block_num = 4, first_block_usage = 0, error_handler = 0} _db_framep_ = (char **) 0x0 ip = 1 backup_arena = {_vptr.Query_arena = 0x8696968, free_list = 0x0, mem_root = 0x43642f90, is_backup_arena = true, state = INITIALIZED_FOR_SP} old_query_id = 32 old_derived_tables = (TABLE *) 0x0 old_packet = {Ptr = 0x8f44310 "\003def", str_length = 56, Alloced_length = 16384, alloced = true, str_charset = 0x886f300} __PRETTY_FUNCTION__ = "bool sp_head::execute(THD*)" #9 0x083875cf in sp_head::execute_function (this=0x8f48340, thd=0x8ef81b0, argp=0x0, argcount=0, return_value_fld=0x0) at sp_head.cc:1341 octx = (sp_rcontext *) 0x0 err_status = false call_mem_root = {free = 0x8f0eba0, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 8136, block_num = 5, first_block_usage = 0, error_handler = 0x81d590e } _db_func_ = 0x8f0e860 "dbn" _db_file_ = 0x82c89e0 "\203Ä\020ÉÃ\220U\211å\203ì\b\213E\b\203À0\203ì\004ÿu\020ÿu\fPè®\0021" binlog_save_options = 2189445632 nctx = (sp_rcontext *) 0x8f0ebb0 binlog_buf = {Ptr = 0x43642f40 "\f", str_length = 80, Alloced_length = 80, alloced = false, str_charset = 0x886f300} _db_level_ = 1130639336 _db_framep_ = (char **) 0x0 arg_no = 0 buf = "\f\000t\001\000Ît\b\230/dC9ò\\\bÜ\000\000root\000dbn\000\200/dC \222\207\b\220\207ï\b\210/dCp7ñ\b\230\035ñ\bÐ\201ï\bØ/dC\214\206&\b\000\000\000\000¸\"ñ\b\000\000\000\000\000\000\000" call_arena = {_vptr.Query_arena = 0x8696968, free_list = 0x0, mem_root = 0x43642f90, is_backup_arena = false, ---Type to continue, or q to quit--- state = INITIALIZED_FOR_SP} backup_arena = {_vptr.Query_arena = 0x8696968, free_list = 0x8f130a8, mem_root = 0x8ef81d0, is_backup_arena = true, state = CONVENTIONAL_EXECUTION} need_binlog_call = false __PRETTY_FUNCTION__ = "bool sp_head::execute_function(THD*, Item**, uint, Field*)" #10 0x08398b15 in Table_triggers_list::process_triggers (this=0x8f0dfc8, thd=0x8ef81b0, event=TRG_EVENT_INSERT, time_type=TRG_ACTION_BEFORE, old_row_is_record1=true) at sql_trigger.cc:1518 statement_state = {options = 2189707776, last_insert_id = 0, next_insert_id = 0, current_insert_id = 11936128518282651045, limit_found_rows = 0, cuted_fields = 0, sent_row_count = 0, examined_row_count = 0, client_capabilities = 239245, in_sub_stmt = 0, enable_slow_log = true, insert_id_used = false, clear_next_insert_id = false, last_insert_id_used = false, no_send_ok = 0 '\0', savepoints = 0x0} save_ctx = (Security_context *) 0x0 err_status = false sp_trigger = (class sp_head *) 0x8f48340 #11 0x082599a1 in fill_record_n_invoke_before_triggers (thd=0x8ef81b0, ptr=0x8f0dea0, values=@0x8ef8504, ignore_errors=true, triggers=0x8f0dfc8, event=TRG_EVENT_INSERT) at sql_base.cc:5072 No locals. #12 0x082918bc in select_create::store_values (this=0x8f12230, values=@0x8ef8504) at sql_insert.cc:2645 No locals. #13 0x08290716 in select_insert::send_data (this=0x8f12230, values=@0x8ef8504) at sql_insert.cc:2297 _db_func_ = 0x86e2168 "end_send" _db_file_ = 0x8278dec "\203Ä \212EÔ\203ð\001\204À\017\204\022\004" _db_level_ = 1130639864 _db_framep_ = (char **) 0x0 error = false #14 0x08278ee0 in end_send (join=0x8f122b8, join_tab=0x8f138e0, end_of_records=false) at sql_select.cc:10471 error = 0 _db_func_ = 0x8f13dc8 "àCñ\b\210\fô\b" _db_file_ = 0x40053685 "\201Ãoi" _db_level_ = 1130639864 _db_framep_ = (char **) 0x8f40d68 #15 0x0827562a in evaluate_join_record (join=0x8f122b8, join_tab=0x8f13770, error=0, report_error=0x8ef8c1c "") at sql_select.cc:9774 rc = 150026096 found = true not_exists_optimize = false not_used_in_distinct = false found_records = 0 select_cond = (COND *) 0x0 #16 0x082759c4 in sub_select (join=0x8f122b8, join_tab=0x8f13770, end_of_records=false) at sql_select.cc:9659 ---Type to continue, or q to quit--- error = 0 rc = 150023992 report_error = (my_bool *) 0x8ef8c1c "" info = (READ_RECORD *) 0x8f137ac #17 0x08275d07 in do_select (join=0x8f122b8, fields=0x8ef8504, table=0x0, procedure=0x0) at sql_select.cc:9422 join_tab = (JOIN_TAB *) 0x8f13770 _db_func_ = 0x436432f0 "\234(n\b¸\"ñ\bÈ3dC\t\203(\b" _db_file_ = 0x8d6
rc = 0 error = NESTED_LOOP_OK _db_level_ = 136905858 _db_framep_ = (char **) 0x436432f8 #18 0x08288309 in JOIN::exec (this=0x8f122b8) at sql_select.cc:1738 _db_func_ = 0x8f13048 "Ü\212\207\bH0ñ\b" _db_file_ = 0x0 _db_level_ = 149914748 _db_framep_ = (char **) 0x8f122b8 tmp_error = 0 curr_join = (JOIN *) 0x8f122b8 curr_fields_list = (List *) 0x8ef8504 columns_list = (List *) 0x8ef8504 curr_all_fields = (List *) 0x8f12ff0 curr_tmp_table = (TABLE *) 0x0 __PRETTY_FUNCTION__ = "void JOIN::exec()" #19 0x082885f3 in mysql_select (thd=0x8ef81b0, rref_pointer_array=0x8ef85a0, tables=0x8f12088, wild_num=1, fields=@0x8ef8504, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2458143232, result=0x8f12230, unit=0x8ef8254, select_lex=0x8ef847c) at sql_select.cc:1902 err = false free_join = true _db_func_ = 0x43643448 "" _db_file_ = 0x869847d "lock.cc" join = (JOIN *) 0x8f122b8 _db_level_ = 1 _db_framep_ = (char **) 0x8187af4 #20 0x082888ba in handle_select (thd=0x8ef81b0, lex=0x8ef81f0, result=0x8f12230, setup_tables_done_option=0) at sql_select.cc:250 unit = (SELECT_LEX_UNIT *) 0x8ef8254 select_lex = (SELECT_LEX *) 0x8ef847c _db_func_ = 0x84
_db_file_ = 0x0 ---Type to continue, or q to quit--- res = 255 _db_level_ = 0 _db_framep_ = (char **) 0x0 #21 0x0822c579 in mysql_execute_command (thd=0x8ef81b0) at sql_parse.cc:2893 result = (class select_result *) 0x8f12230 link_to_local = true create_table = (TABLE_LIST *) 0x8f11e38 select_tables = (TABLE_LIST *) 0x8f12088 res = false lex = (LEX *) 0x8ef81f0 _db_func_ = 0x85e9689 "\203ì\bSPèÕi¸ÿ\203Ä\020\205ÀuA\213E\b\213P4\213E\b\213@0\213\rÌ\210\207\b\203ì\bRPÿu\020ÿu\fhL\001u\bQèF]¸ÿ\203Ä ¡Ì\210\207\b\203ì\fPè\225]¸ÿ\203Ä\020è\ra¸ÿ\213E\bÇ@<" _db_file_ = 0x8878adc "Ü\212\207\b" _db_level_ = 149914796 _db_framep_ = (char **) 0x8f11e08 result = 0 select_lex = (SELECT_LEX *) 0x8ef847c first_table = (TABLE_LIST *) 0x8f11e38 all_tables = (TABLE_LIST *) 0x8f11e38 unit = (SELECT_LEX_UNIT *) 0x8ef8254 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #22 0x082332cf in mysql_parse (thd=0x8ef81b0, inBuf=0x8f11da8 "CREATE TABLE IF NOT EXISTS t1 SELECT * FROM t2", length=46) 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)" #23 0x08233cbb in dispatch_command (command=COM_QUERY, thd=0x8ef81b0, packet=0x8f19d99 "CREATE TABLE IF NOT EXISTS t1 SELECT * FROM t2", packet_length=47) at sql_parse.cc:1745 packet_end = 0x8f11dd6 "" net = (NET *) 0x8ef89b4 _db_func_ = 0x4
_db_file_ = 0x0 error = false _db_level_ = 16777216 _db_framep_ = (char **) 0x8ef92a4 #24 0x08235058 in do_command (thd=0x8ef81b0) at sql_parse.cc:1531 ---Type to continue, or q to quit--- packet = 0x8f19d98 "\003CREATE TABLE IF NOT EXISTS t1 SELECT * FROM t2" old_timeout = 30 packet_length = 47 net = (NET *) 0x8ef89b4 command = COM_QUERY _db_func_ = 0x43644378 "XDdCdT#\b°\201ï\b\001" _db_file_ = 0x8ef93c0 "ÀÝñ\b" _db_level_ = 150068672 _db_framep_ = (char **) 0x1010 #25 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 }} #26 0x40050297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #27 0x4018b37e in clone () from /lib/tls/libc.so.6 No symbol table info available. #28 0x43644bb0 in ?? () No symbol table info available. (gdb)