060821 12:32:37 [Note] /home/miguel/dbs/5.1/libexec/mysqld: ready for connections. Version: '5.1.12-beta-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread 1098415024 (LWP 26778)] 060821 12:32:37 [Note] SCHEDULER: Manager thread booting 060821 12:32:37 [Note] SCHEDULER: Loaded 0 events 060821 12:32:37 [Note] SCHEDULER: Suspending operations [New Thread 1115462576 (LWP 26780)] [New Thread 1115663280 (LWP 26781)] mysqld: field.cc:3470: virtual longlong Field_long::val_int(): Assertion `table->in_use == _current_thd()' failed. Program received signal SIGABRT, Aborted. [Switching to Thread 1115462576 (LWP 26780)] 0xffffe410 in __kernel_vsyscall () (gdb) bt full #0 0xffffe410 in __kernel_vsyscall () No symbol table info available. #1 0x400ea541 in raise () from /lib/tls/libc.so.6 No symbol table info available. #2 0x400ebdbb in abort () from /lib/tls/libc.so.6 No symbol table info available. #3 0x400e3925 in __assert_fail () from /lib/tls/libc.so.6 No symbol table info available. #4 0x08216891 in Field_long::val_int (this=0x8f3f958) at field.cc:3470 j = 140366159 __PRETTY_FUNCTION__ = "virtual longlong Field_long::val_int()" #5 0x081a15c7 in Item_field::val_int (this=0x8f4b058) at item.cc:1733 __PRETTY_FUNCTION__ = "virtual longlong Item_field::val_int()" #6 0x081cbaa0 in Item_func_set_user_var::check (this=0x8f4b138) at item_func.cc:3733 _db_func_ = 0x869fced "sql_set_variables" _db_file_ = 0x869fa96 "set_var.cc" _db_level_ = 10 _db_framep_ = (char **) 0x2 __PRETTY_FUNCTION__ = "bool Item_func_set_user_var::check()" #7 0x0824daf0 in set_var_user::check (this=0x8f4b510, thd=0x8f33b08) at set_var.cc:3470 No locals. #8 0x0824d4fd in sql_set_variables (thd=0x8f33b08, var_list=0x8f53a24) at set_var.cc:3329 _db_func_ = 0x86a1d41 "mysql_execute_command" _db_file_ = 0x86a1122 "sql_parse.cc" var = (set_var_base *) 0x8f4b510 error = 15944588 it = { = {list = 0x8f53a24, el = 0x8f4b518, prev = 0x0, current = 0x0}, } _db_level_ = 9 _db_framep_ = (char **) 0x0 #9 0x08262c87 in mysql_execute_command (thd=0x8f33b08) at sql_parse.cc:3683 lex_var_list = (List *) 0x8f53a24 res = false lex = (LEX *) 0x8f53500 _db_func_ = 0x87175b6 "sp_instr_stmt::execute" _db_file_ = 0x8716990 "sp_head.cc" _db_level_ = 8 _db_framep_ = (char **) 0x0 need_start_waiting = false result = 0 ---Type to continue, or q to quit--- select_lex = (SELECT_LEX *) 0x8f537a0 first_table = (TABLE_LIST *) 0x0 all_tables = (TABLE_LIST *) 0x0 unit = (SELECT_LEX_UNIT *) 0x8f53568 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #10 0x083fb795 in sp_instr_stmt::exec_core (this=0x8f4b520, thd=0x8f33b08, nextp=0x427c8154) at sp_head.cc:2529 res = 0 #11 0x083fb591 in sp_lex_keeper::reset_lex_and_exec_core (this=0x8f4b548, thd=0x8f33b08, nextp=0x427c8154, open_tables=false, instr=0x8f4b520) at sp_head.cc:2400 res = 0 __PRETTY_FUNCTION__ = "int sp_lex_keeper::reset_lex_and_exec_core(THD*, uint*, bool, sp_instr*)" #12 0x083ff2bf in sp_instr_stmt::execute (this=0x8f4b520, thd=0x8f33b08, nextp=0x427c8154) at sp_head.cc:2480 _db_func_ = 0x8716b8c "sp_head::execute" _db_file_ = 0x8716990 "sp_head.cc" query = 0x8f418d8 "INSERT DELAYED INTO t1 VALUES (1)" query_length = 33 res = 0 _db_level_ = 7 _db_framep_ = (char **) 0x427c8068 #13 0x083f924b in sp_head::execute (this=0x8f4ad38, thd=0x8f33b08) at sp_head.cc:1077 i = (sp_instr *) 0x8f4b520 hip = 1115455800 old_db_buf = "dbx\000\000p\223ñ\bÈ\200|B\206»]\b\026\000\000\000p\223ñ\bØ\200|B\206»]\b\000\000\000\000\000\000\000\000ø\200|B9Ò]\b kó\bp\223ñ\bø\200|BâÒ]\b" old_db = {str = 0x427c809f "dbx", length = 3} dbchanged = false err_status = false save_sql_mode = 0 execute_arena = {_vptr.Query_arena = 0x868f868, free_list = 0x0, mem_root = 0x427c80e0, is_backup_arena = false, state = INITIALIZED_FOR_SP} _db_func_ = 0x8716e6a "sp_head::execute_trigger" _db_file_ = 0x8716990 "sp_head.cc" _db_level_ = 6 old_lex = (LEX *) 0x8f33b48 old_change_list = { = {first = 0x8f34f90, last = {_vptr.ilink = 0x86908d0, prev = 0x8f34f8c, next = 0x0}}, } ctx = (sp_rcontext *) 0x8f50d58 save_abort_on_warning = false old_arena = (class Query_arena *) 0x8f33b14 ---Type to continue, or q to quit--- execute_mem_root = {free = 0x8f55ce8, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 8136, block_num = 5, first_block_usage = 0, error_handler = 0} _db_framep_ = (char **) 0x0 ip = 0 backup_arena = {_vptr.Query_arena = 0x868f868, free_list = 0x0, mem_root = 0x427c81e0, is_backup_arena = true, state = INITIALIZED_FOR_SP} old_query_id = 7 old_derived_tables = (TABLE *) 0x0 old_packet = {Ptr = 0x8f44928 "ûdef", str_length = 1, Alloced_length = 16384, alloced = true, str_charset = 0x88909e0} __PRETTY_FUNCTION__ = "bool sp_head::execute(THD*)" #14 0x083f9885 in sp_head::execute_trigger (this=0x8f4ad38, thd=0x8f33b08, db=0x8f369e8 "dbx", table=0x8f369ec "t1", grant_info=0x8f3fad0) at sp_head.cc:1317 nctx = (sp_rcontext *) 0x8f50d58 call_mem_root = {free = 0x8f50d48, used = 0x0, pre_alloc = 0x0, min_malloc = 32, block_size = 8136, block_num = 5, first_block_usage = 0, error_handler = 0x81faeca } call_arena = {_vptr.Query_arena = 0x868f868, free_list = 0x0, mem_root = 0x427c81e0, is_backup_arena = false, state = INITIALIZED_FOR_SP} _db_func_ = 0x86e6495 "mysql_insert" _db_file_ = 0x86e60f1 "sql_insert.cc" _db_level_ = 5 _db_framep_ = (char **) 0x16 octx = (sp_rcontext *) 0x0 err_status = false backup_arena = {_vptr.Query_arena = 0x868f868, free_list = 0x8f41b28, mem_root = 0x8f33b28, is_backup_arena = true, state = CONVENTIONAL_EXECUTION} #15 0x0840b60b in Table_triggers_list::process_triggers (this=0x8f3fa70, thd=0x8f33b08, event=TRG_EVENT_INSERT, time_type=TRG_ACTION_BEFORE, old_row_is_record1=true) at sql_trigger.cc:1538 statement_state = {options = 2147764736, first_successful_insert_id_in_prev_stmt = 0, first_successful_insert_id_in_cur_stmt = 0, insert_id_for_cur_row = 644458331086482336, auto_inc_interval_for_cur_row = {interval_min = 0, interval_values = 0, interval_max = 0, next = 0x0}, limit_found_rows = 1, cuted_fields = 0, sent_row_count = 0, examined_row_count = 0, client_capabilities = 239245, in_sub_stmt = 0, enable_slow_log = true, 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 *) 0x8f4ad38 #16 0x0829311b in fill_record_n_invoke_before_triggers (thd=0x8f33b08, ptr=0x8f4223c, values=@0x8f41b10, ignore_errors=false, triggers=0x8f3fa70, event=TRG_EVENT_INSERT) at sql_base.cc:6038 No locals. #17 0x082cb049 in mysql_insert (thd=0x8f33b08, table_list=0x8f41960, fields=@0x8f3403c, values_list=@0x8f34060, update_fields=@0x8f34054, update_values=@0x8f34048, duplic=DUP_ERROR, ignore=false) at sql_insert.cc:524 ---Type to continue, or q to quit--- counter = 1 lock_type = TL_WRITE_DELAYED log_on = true value_count = 1 info = {records = 0, deleted = 0, updated = 0, copied = 0, error_count = 0, handle_duplicates = DUP_ERROR, escape_char = 0, last_errno = 0, ignore = false, update_fields = 0x8f34054, update_values = 0x8f34048, view = 0x0} context = (Name_resolution_context *) 0x8f33e1c res = 0 joins_freed = false changed = 8 id = 4790850958252606868 its = { = {list = 0x8f34060, el = 0x8f41bb0, prev = 0x0, current = 0x0}, } values = (List_item *) 0x8f41b10 unused_conds = (class Item *) 0x0 _db_func_ = 0x86a1d41 "mysql_execute_command" _db_file_ = 0x86a1122 "sql_parse.cc" _db_level_ = 4 error = 0 table = (TABLE *) 0x8f41bb8 ctx_state = {save_table_list = 0x8f41960, save_first_name_resolution_table = 0x8f41960, save_next_name_resolution_table = 0x0, save_resolve_in_select_list = false, save_next_local = 0x0} transactional_table = 182 query = 0x8f418d8 "INSERT DELAYED INTO t1 VALUES (1)" _db_framep_ = (char **) 0x85dbb86 __PRETTY_FUNCTION__ = "bool mysql_insert(THD*, TABLE_LIST*, List&, List&, List&, List&, enum_duplicates, bool)" #18 0x08261df3 in mysql_execute_command (thd=0x8f33b08) at sql_parse.cc:3404 res = false lex = (LEX *) 0x8f33b48 _db_func_ = 0x86a2184 "mysql_parse" _db_file_ = 0x86a1122 "sql_parse.cc" _db_level_ = 3 _db_framep_ = (char **) 0x8f36ba0 need_start_waiting = true result = 0 select_lex = (SELECT_LEX *) 0x8f33de8 first_table = (TABLE_LIST *) 0x8f41960 all_tables = (TABLE_LIST *) 0x8f41960 unit = (SELECT_LEX_UNIT *) 0x8f33bb0 ---Type to continue, or q to quit--- __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #19 0x08267cb2 in mysql_parse (thd=0x8f33b08, inBuf=0x8f418d8 "INSERT DELAYED INTO t1 VALUES (1)", length=33) at sql_parse.cc:6087 lex = (LEX *) 0x8f33b48 _db_func_ = 0x86a21f3 "dispatch_command" _db_file_ = 0x86a1122 "sql_parse.cc" _db_level_ = 2 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" #20 0x082686b0 in dispatch_command (command=COM_QUERY, thd=0x8f33b08, packet=0x8f39879 "INSERT DELAYED INTO t1 VALUES (1)", packet_length=34) at sql_parse.cc:1830 packet_end = 0x8f418f9 "" net = (NET *) 0x8f34368 _db_func_ = 0x8764214 "?func" _db_file_ = 0x876421a "?file" error = false _db_level_ = 1 _db_framep_ = (char **) 0x4 #21 0x082699eb in do_command (thd=0x8f33b08) at sql_parse.cc:1614 packet = 0x8f39878 "\003INSERT DELAYED INTO t1 VALUES (1)" old_timeout = 30 packet_length = 34 net = (NET *) 0x8f34368 command = COM_QUERY _db_func_ = 0x8764214 "?func" _db_file_ = 0x876421a "?file" _db_level_ = 1 _db_framep_ = (char **) 0x1010 #22 0x08269ded in handle_one_connection (arg=0x8f33b08) at sql_parse.cc:1228 error = 0 net = (NET *) 0x8f34368 sctx = (Security_context *) 0x8f34b8c thd = (class THD *) 0x8f33b08 launch_time = 0 set = {__val = {0 }} #23 0x40047297 in start_thread () from /lib/tls/libpthread.so.0 No symbol table info available. #24 0x4018137e in clone () from /lib/tls/libc.so.6 No symbol table info available. #25 0x427c9bb0 in ?? () ---Type to continue, or q to quit--- No symbol table info available. (gdb)