MySQL Forums
Forum List  »  Full-Text Search

Repeating error during background table scan
Posted by: Johan De Meersman
Date: July 07, 2006 01:16AM

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 :-)

Options: ReplyQuote


Subject
Views
Written By
Posted
Repeating error during background table scan
3100
July 07, 2006 01:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.