Bug #2417 Corruption in table with fulltext index
Submitted: 15 Jan 2004 17:27 Modified: 18 Jan 2004 8:25
Reporter: jocelyn fournier (Silver Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.1.2 bk latest pull OS:Linux (Linux)
Assigned to: Sergei Golubchik CPU Architecture:Any

[15 Jan 2004 17:27] jocelyn fournier 
Description:
One of my table with a fulltext index regulary get corrupted, and at least I succeeded in doing a reproductible testcase :)

How to repeat:
Download ftp://support.mysql.com/pub/mysql/secret/fulltextbug.tar.gz

Then copy the config files in a database named 'Hardwarefr'.

CHECK TABLE config should not return any problem (note I'm using 4.1.2 with the fix for bug #2190 (table corruption with MySQL-4.1.x and fulltext index))

Now execute :

mysqlbinlog forum-bin.000019 | mysql -uroot -p -f

Now CHECK TABLE should return the following error :

mysql> CHECK TABLE config;
+-------------------+-------+----------+---------------------------------------------------+
| Table             | Op    | Msg_type | Msg_text                                          |
+-------------------+-------+----------+---------------------------------------------------+
| Hardwarefr.config | check | error    | Wrong pagepointer: 4294965409 at page: 4294965409 |
| Hardwarefr.config | check | error    | Corrupt                                           |
+-------------------+-------+----------+---------------------------------------------------+
2 rows in set (0.09 sec)

Regards,
  Jocelyn
[18 Jan 2004 8:25] Sergei Golubchik 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

fixed in 4.1.2, thanks!