On May 25, 2005, at 10:06 AM, David Brewster wrote:

Here is the log dump :-

Thanks
David

050525 13:24:10  InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.15-Max'  socket: '/var/lib/mysql/mysql.sock'  port: 3306
050525 13:24:11  InnoDB: Assertion failure in thread 114696 in file
fsp0fsp.c line 3034
InnoDB: We intentionally generate a memory trap.

Well, InnoDB is crashing immediately on startup. Is that how it was crashing when you were using the corrupt table space? You can scan back in the log or look in the log for that data directory. If it's crashing the same way this table space might be corrupt also.

If it's a different cause, you might get lucky by upgrading InnoDB. The current 4.0 version is 4.0.24. I would _not_ upgrade to 4.1 until you fix this...you can't easily downgrade InnoDB that has gone to 4.1. If you do try upgrading to 4.0.24, I would work on a copy of this dataset (e.g. a copy of the backup which is now failing). You don't want to do any more damage.

Good luck,
Ware

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to