Ervin, the assertion in page0page.c line 450 means InnoDB could not move index records from a page to another page though it always checks that there should be enough space. I have not seen this assertion fail before.
Did mysqld print a srack trace to the .err log? Can you send me the whole error log? Please run CHECK TABLE on your tables and report what it says. If there is corruption, CHECK TABLE also prints diagnostics to the .err log. InnoDB should recover from a power failure without problems. The bug might also be that fsync() in your computer does not do what it should, and the data pages were not in reality flushed to disk. Do you use RAID, NFS, or anything exotic? Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query ----- Original Message ----- From: Ervin Gerke To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 2:00 PM Subject: InnoDB crash? Got this one after a power failure. My system is Redhat 7.3, kernel 2.4.18-18.7.x, MySQL-4.0.5a-beta-Max. Let me know if you need any more information. err.log reads: 021210 14:00:41 InnoDB: Started /usr/sbin/mysqld-max: ready for connections 021210 14:00:43 InnoDB: Assertion failure in thread 7176 in file page0page.c line 450 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16773120 read_buffer_size=131072 Number of processes running now: 1 mysqld-max process hanging, pid 4201 - killed 021210 14:00:43 mysqld restarted --------------------------------------------------------------------- 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