Michael, this is further evidence that the corruption last time was not a bug in the insert buffer, but this is general Linux table corruption. I already suggested that you should upgrade to Linux-2.4.20 or some other recent kernel.
Please send me the full .err log. If you can keep the old corrupt files, that is nice, but probably not needed. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, foreign keys, and a hot backup tool for MySQL sql query ........................ Subject: Heiki, InnoDB crash #2 (update) From: Michael T. Babcock Date: Mon, 24 Feb 2003 08:11:57 -0500 The patch got my server up and going again for a bit, but now it has died again after running for about 8 hours or so. InnoDB: Error: trying to access a stray pointer c22fbff8 InnoDB: buf pool start is at 413cc000, number of pages 1024 030223 19:14:31 InnoDB: Assertion failure in thread 66581 in file ../include/buf0buf.ic line 284 InnoDB: We intentionally generate a memory trap. Stack trace: 0x80cd61f handle_segfault__Fi + 379 0x40029532 _end + 935703418 0x82ae78f page_cur_search_with_match + 1807 0x821af59 btr_cur_search_to_nth_level + 2889 0x81e425e row_ins_index_entry_low + 182 0x81e49bf row_ins_index_entry + 59 0x81e4a5c row_ins_index_entry_step + 116 0x81e4d1d row_ins + 693 0x81e4e6a row_ins_step + 278 0x81e606d row_insert_for_mysql + 457 0x811ce6d write_row__11ha_innobasePc + 977 0x80f8df8 write_record__FP8st_tableP12st_copy_info + 484 0x80f86ef mysql_insert__FP3THDP13st_table_listRt4List1Z4ItemRt4List1Zt4List1Z4Item15en um_duplicates13thr_lock_type + 1043 0x80d4a4b mysql_execute_command__Fv + 5311 0x80d68e3 mysql_parse__FP3THDPcUi + 63 0x80d2bed do_command__FP3THD + 1181 0x80d21cb handle_one_connection__FPv + 563 And now that its running again, I'm going to be doing a full backup and then rebuild my data files for a full restore. Should I keep my original files for your reference/debugging? -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php