Hi Dave, ----- Original Message ----- From: <[EMAIL PROTECTED]> Sent: Thursday, March 04, 2004 7:43 AM Subject: Corrupt full text index
> >Description: > When updating a table with a fulltext index, the fulltext index becomes corrupted. The Error "ERROR 1034 at line 76: Incorrect key file for table: 'test'; try to repair it" is dislpayed. The error is not produced when there is no fulltext index. > >How-To-Repeat: > Download sql script from http://www.kirkpatrick.me.uk/bug.sql.tar.gz > I have replicated this on 4.1.1 on both Linux and Win32. The problem does not happen on 4.0 > > >Fix: > If you drop the fulltext index before the update and then receate it no error is produced. Like Sergei said, there's no problem in 4.1.2. There are a few full-text corruption bugs in 4.1.1: http://bugs.mysql.com/1977 http://bugs.mysql.com/2190 http://bugs.mysql.com/2417 And with multi-byte character sets: http://bugs.mysql.com/2033 http://bugs.mysql.com/2065 Hopefully any problems are ironed out in 4.1.2! :-) Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
