070129 19:35:26 InnoDB: Started; log sequence number 0 50379 [New Thread -1256375392 (LWP 8439)] 070129 19:35:26 [Note] /home/miguel/dbs/5.0/libexec/mysqld: ready for connections. Version: '5.0.36-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution [New Thread -1256576096 (LWP 8472)] [Thread -1256576096 (zombie) exited] [New Thread -1256576096 (LWP 8490)] [Thread -1256576096 (zombie) exited] [New Thread -1256576096 (LWP 8494)] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread -1256576096 (LWP 8494)] 0xb7e62375 in memcpy () from /lib/tls/i686/cmov/libc.so.6 (gdb) bt full #0 0xb7e62375 in memcpy () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. #1 0x083e061e in rec_convert_dtuple_to_rec (buf=0xb6c98078 "", index=0xb74a1d68, dtuple=0xb74a80a8) at rem0rec.c:974 rec = (rec_t *) 0xb6c98090 "\200" #2 0x083de98a in page_cur_insert_rec_low (cursor=0xb74a2b6c, tuple=0xb74a80a8, index=0xb74a1d68, rec=0x0, offsets=0x0, mtr=0xb519f7b8) at page0cur.c:920 insert_buf = (unsigned char *) 0x4
rec_size = 24 page = (unsigned char *) 0xb6c98000 "" last_insert = insert_rec = heap_no = 2 current_rec = (rec_t *) 0xb6c98063 "infimum" next_rec = owner_slot = owner_rec = n_owned = heap = (mem_heap_t *) 0x0 comp = 32768 #3 0x083decc7 in page_cur_tuple_insert (cursor=0xb74a2b6c, tuple=0xb74a80a8, index=0xb74a1d68, mtr=0xb519f7b8) at ./../include/page0cur.ic:188 No locals. #4 0x0839e687 in btr_cur_insert_if_possible (cursor=0xb74a2b68, tuple=0xb74a80a8, reorg=0xb519f21c, mtr=0xb519f7b8) at btr0cur.c:812 page_cursor = (page_cur_t *) 0xb74a2b6c page = (ib_page_t *) 0xb6c98000 "" rec = #5 0x083a1ec1 in btr_cur_pessimistic_update (flags=, cursor=0xb74a2b68, big_rec=0xb519f408, update=0xb74a2900, cmpl_info=0, thr=0xb74a2480, mtr=0xb519f7b8) at btr0cur.c:1914 big_rec_vec = (big_rec_t *) 0x0 dummy_big_rec = (big_rec_t *) 0xb519f238 index = (dict_index_t *) 0xb74a1d68 page = (ib_page_t *) 0xb6c98000 "" rec = (rec_t *) 0xb6c9807d "" page_cursor = (page_cur_t *) 0xb74a2b6c new_entry = (dtuple_t *) 0xb74a80a8 heap = (mem_heap_t *) 0xb74a8028 err = 10 optim_err = 1002 dummy_reorganized = 0 roll_ptr = {high = 4, low = 3412253} ---Type to continue, or q to quit--- trx = success = n_extents = 0 n_reserved = 3038376504 ext_vect = (ulint *) 0xb74a8148 n_ext_vect = 0 reserve_flag = offsets = (ulint *) 0xb74a8068 #6 0x0838d90b in row_upd_clust_rec (node=0xb74a2868, index=0xb74a1d68, thr=0xb74a2480, mtr=0xb519f7b8) at row0upd.c:1547 big_rec = (big_rec_t *) 0x0 pcur = (btr_pcur_t *) 0xb74a2b68 btr_cur = (btr_cur_t *) 0xb74a2b68 err = 45 #7 0x0838f12d in row_upd_step (thr=0xb74a2480) at row0upd.c:1787 node = (upd_node_t *) 0xb74a2868 sel_node = (sel_node_t *) 0x0 parent = (que_node_t *) 0xb74a2268 err = 3038377912 trx = (trx_t *) 0xb749e068 #8 0x08382b80 in row_update_cascade_for_mysql (thr=0xb74a2480, node=0xb74a2868, table=0xb74a3068) at row0mysql.c:1567 err = 4 trx = (trx_t *) 0xb749e068 #9 0x0837edb5 in row_ins_foreign_check_on_constraint (thr=0xb74a2480, foreign=0xb74a9468, pcur=0xb519fee8, entry=0xb74a3c78, mtr=0xb519ff5c) at row0ins.c:1070 node = (upd_node_t *) 0xb74a2268 cascade = (upd_node_t *) 0xb74a2868 table = (dict_table_t *) 0xb74a3068 index = (dict_index_t *) 0xb74a8e68 clust_index = (dict_index_t *) 0xb74a1d68 ref = upd_vec_heap = (mem_heap_t *) 0x0 rec = (rec_t *) 0xb74a2900 "" clust_rec = (rec_t *) 0xb6c9807d "" update = (upd_t *) 0xb74a2900 n_to_update = 3066675329 err = 10 i = 1 trx = (trx_t *) 0xb749e068 ---Type to continue, or q to quit--- tmp_heap = (mem_heap_t *) 0xb74a1e28 #10 0x0837f731 in row_ins_check_foreign_constraint (check_ref=0, foreign=0xb74a9468, table=0xb74a1668, entry=0xb74a3c78, thr=0xb74a2480) at row0ins.c:1398 page = upd_node = check_table = check_index = (dict_index_t *) 0xb74a8e68 n_fields_cmp = 2 rec = (rec_t *) 0xb6c9c07d "\200" pcur = {btr_cur = {index = 0xb74a8e68, page_cur = {rec = 0xb6c9c07d "\200"}, left_page = 0x0, thr = 0xb7f993f7, flag = 3, tree_height = 1, up_match = 1, up_bytes = 0, low_match = 0, low_bytes = 0, n_fields = 3066642553, n_bytes = 16384, fold = 3038379832, path_arr = 0x83e1305}, latch_mode = 1, old_stored = 908467085, old_rec = 0xb74a4e6d "\200", old_n_fields = 2, rel_pos = 1, block_when_stored = 0xb6c02a78, modify_clock = { high = 0, low = 2}, pos_state = 1997660512, search_mode = 2, trx_if_known = 0x0, mtr = 0x83db778, old_rec_buf = 0xb74a4e68 "", buf_size = 15} moved = cmp = 0 err = 10 i = mtr = {state = 6, memo = {heap = 0x0, used = 48, data = "7\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\001\000\000\000\000\000\000\0007\000\000\000\000\000\000\000\003\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000àÿ\031µx\001\032µt\001\032µ\017ÿ^\bq\001\000\000!«L\b¼\020I·\001\000\000\000\000\000\000\000\030\020À¶p@ɶ~@ɶ\000\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000àÿ\031µ±è>\bd\000\000\000\002\000\000\000\006\000\000\200\004\000\000\000\n\000\000\000÷\223ù·\b\000\032µ\003W>\b¼\020I·\000\000\000\000Ù\234ù·\220'À¶\220'À¶÷\223ù·H\000\032µÜ¯L\b\220'À¶ +\032µÙ\234ù·\000\000\000\000"..., base = {count = 3038380424, start = 0x83d8892, end = 0x0}, list = {prev = 0x0, next = 0xb51a0188}}, log = {heap = 0x0, used = 0, data = "\n\000\000\000¨\001\032µ[\026>\b~@ɶ\003\000\000\000\a\000\000\000\000\000\000\000¨\003\032µ¤\003\032µÈ\001\032µÒµ>\b(\bi\bn\bpÑH·x, 30, 3407897, 386334720, 3407874, 49385512, 704656384, 192912, 2420707380, 8177, 0 } offsets = (ulint *) 0xb519fd58 #11 0x0838d414 in row_upd_check_references_constraints (node=0xb74a2268, pcur=0xb51a046c, table=0xb74a1668, index=0xb74a3368, thr=0xb74a2480, mtr=0xb51a04dc) at row0upd.c:222 foreign = (dict_foreign_t *) 0xb74a9468 heap = (mem_heap_t *) 0xb74a3c28 entry = (dtuple_t *) 0xb74a3c78 ---Type to continue, or q to quit--- trx = (trx_t *) 0xb749e068 rec = (rec_t *) 0xb6c9407e "\200" err = 3066642558 got_s_lock = 1 #12 0x0838e166 in row_upd_sec_step (node=0xb74a2268, thr=0xb74a2480) at row0upd.c:1311 err = 10 #13 0x0838f180 in row_upd_step (thr=0xb74a2480) at row0upd.c:1850 node = (upd_node_t *) 0xb74a2268 sel_node = (sel_node_t *) 0x0 parent = (que_node_t *) 0xb74a2480 err = 10 trx = (trx_t *) 0xb749e068 #14 0x08385587 in row_update_for_mysql (mysql_rec=0x8c868c8 "ý\001", prebuilt=0xb749e668) at row0mysql.c:1395 savept = {least_undo_no = {high = 0, low = 0}} err = 3075072104 thr = (que_thr_t *) 0xb74a2480 was_lock_wait = 4 clust_index = node = (upd_node_t *) 0xb74a2268 table = trx = (trx_t *) 0xb749e068 #15 0x082c1897 in ha_innobase::delete_row (this=0x8c867a8, record=0x8c868c8 "ý\001") at ha_innodb.cc:3575 prebuilt = (row_prebuilt_t *) 0xb749e668 error = _db_func_ = 0x0 _db_file_ = 0x8c868c8 "ý\001" _db_level_ = 147351464 _db_framep_ = (char **) 0x82a9cf0 #16 0x08265d9b in mysql_delete (thd=0x8c51e10, table_list=0x8c8a7d8, conds=0x0, order=0x8c521e0, limit=18446744073709551615, options=0, reset_auto_increment=false) at sql_delete.cc:228 error = 0 table = (TABLE *) 0x8c86fd0 select = (SQL_SELECT *) 0x0 info = {table = 0x8c86fd0, file = 0x8c867a8, forms = 0xb51a12fc, read_record = 0x82a9c7e , thd = 0x8c51e10, select = 0x0, cache_records = 0, ref_length = 6, struct_length = 0, reclength = 0, rec_cache_size = 0, error_offset = 0, index = 0, ref_pos = 0x0, record = 0x8c868c8 "ý\001", rec_buf = 0x0, cache = 0x0, cache_pos = 0x0, cache_end = 0x0, read_positions = 0x0, io_cache = 0x0, print_error = true, ignore_not_found_rows = false} using_limit = false ---Type to continue, or q to quit--- transactional_table = safe_update = false const_cond = deleted = 0 usable_index = select_lex = (SELECT_LEX *) 0x8c520e8 _db_func_ = 0x7
_db_file_ = 0x8c8a760 "DELETE FROM a" _db_level_ = 147368328 _db_framep_ = (char **) 0x0 #17 0x081fb1a4 in mysql_execute_command (thd=0x8c51e10) at sql_parse.cc:3588 xs = res = need_start_waiting = true result = lex = (LEX *) 0x8c51e50 select_lex = (SELECT_LEX *) 0x8c520e8 first_table = (TABLE_LIST *) 0x8c8a7d8 all_tables = (TABLE_LIST *) 0x8c8a7d8 unit = (SELECT_LEX_UNIT *) 0x8c51eb4 _db_func_ = 0x0 _db_file_ = 0x0 _db_level_ = 0 _db_framep_ = (char **) 0x0 __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)" #18 0x081fbb53 in mysql_parse (thd=0x8c51e10, inBuf=0x8c8a760 "DELETE FROM a", length=13) at sql_parse.cc:5897 lex = (LEX *) 0x8c51e50 _db_func_ = 0xff0a0000
_db_file_ = 0xb51a2054 "÷\223ù·" _db_level_ = 147136016 _db_framep_ = (char **) 0x8c51e10 __PRETTY_FUNCTION__ = "void mysql_parse(THD*, char*, uint)" #19 0x081fc7f8 in dispatch_command (command=COM_QUERY, thd=0x8c51e10, packet=0x8c82701 "DELETE FROM a", packet_length=14) at sql_parse.cc:1774 packet_end = 0x8c8a76d "" net = (NET *) 0x8c52650 error = _db_func_ = 0x2040
_db_file_ = 0xb7f25458 "ðxÈ\bðxÈ\bXTò·XTò·`Tò·`Tò·hTò·hTò·pTò·pTò·xTò·xTò·\200Tò·\200Tò·\210Tò·\210Tò·\220Tò·\220Tò·\230Tò·\230Tò· Tò· Tò·¨Tò·¨Tò·°T---Type to continue, or q to quit--- ò·°Tò·¸Tò·¸Tò·ÀTò·ÀTò·ÈTò·ÈTò·ÐTò·ÐTò·ØTò·ØTò·àTò·àTò·èTò·èTò·ðTò·ðTò·øTò·øTò·" _db_level_ = 3086112092 _db_framep_ = (char **) 0x3 #20 0x081fdb26 in do_command (thd=0x8c51e10) at sql_parse.cc:1556 packet = 0x8c82700 "\003DELETE FROM a" old_timeout = 30 packet_length = 14 net = (NET *) 0x8c52650 command = COM_QUERY _db_func_ = 0x1000
_db_file_ = 0x2000
_db_level_ = 147140712 _db_framep_ = (char **) 0x81ca3df #21 0x081fe96d in handle_one_connection (arg=0x8c51e10) at sql_parse.cc:1187 error = net = (NET *) 0x8c52650 sctx = (Security_context *) 0x8c52e30 thd = (class THD *) 0x8c51e10 set = {__val = {0 }} #22 0xb7f97504 in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 No symbol table info available. #23 0xb7ec151e in clone () from /lib/tls/i686/cmov/libc.so.6 No symbol table info available. (gdb)