Bug #2417 Corruption in table with fulltext index
Submitted: 15 Jan 2004 18:27 Modified: 18 Jan 2004 9:25
Reporter: jocelyn fournier (Silver Quality Contributor)
Status: Closed
Category:Server: MyISAM Severity:S2 (Serious)
Version:4.1.2 bk latest pull OS:Linux (Linux)
Assigned to: Sergei Golubchik Target Version:

[15 Jan 2004 18: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 9: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!