Repeating error during background table scan

[Johan De Meersman]

Hi,

For a while now, I've been getting these in the syslog:

---BEGIN PASTE---
Jul 6 20:08:53 hannibal mysqld[1405]: 060706 20:09:06 [ERROR] Number of rows changed from 0 to 6340
Jul 6 20:08:53 ba mysqld[6749]: 060706 20:09:06 [Note] Found 6340 of 0 rows when repairing './a51v2_cms_nl/CMS_FULLTEXTSEARCH'
Jul 6 20:08:53 hannibal mysqld[1405]: 060706 20:09:06 [Note] Found 6340 of 0 rows when repairing './a51v2_cms_nl/CMS_FULLTEXTSEARCH'
---END PASTE---


They seem to happen pretty much randomly - possibly whenever new data gets inserted. I already moved the table and created a new one, to no avail.

This is on MySQL 4.1.15. Table structure is as follows:

CREATE TABLE `CMS_FULLTEXTSEARCH` (
`TYPE` varchar(255) NOT NULL default '',
`ID` int(11) NOT NULL default '0',
`VALUE` text,
PRIMARY KEY (`TYPE`,`ID`),
FULLTEXT KEY `FULLTEXT` (`VALUE`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1


Thanks for any help :-)