Hi! MySQL/InnoDB-4.1.2 is totally broken and useless if one has specified innodb_file_per_table in my.cnf on Unix!
In crash recovery, InnoDB scans the database directories under the datadir, and opens files in in the read-only mode. But the exclusive file lock that InnoDB uses on the files fails in this case! The result is that the crash recovery is NOT applied to those tables, and the tables become corrupt and inaccessible! My apologies for users, the fact that this bug got into 4.1 was due to improper testing. Heikki Innobase Oy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
