how to resolve "InnoDB: Error (Duplicate key) writing word node to FTS auxiliary index table" in mysql

by Sandesh Naik   Last Updated January 13, 2018 03:06 AM

I am continuous getting above error in mysqld log. Please tell me what is this error about and how to solve it. I am using mysql 5.7 (not mariadb)

Tags : mysql innodb


Answers 1


A guess: A FULLTEXT index on that table is corrupted.

ALTER TABLE tablename ENGINE=InnoDB;

should rebuild the FT index, thereby fixing the problem.

If that is not sufficient, please provide SHOW CREATE TABLE; there may be some other clues there.

Rick James
Rick James
January 13, 2018 04:05 AM

Related Questions




getting innodb buffer usage

Updated August 24, 2018 15:06 PM

Why is MySQL not saving inserted data?

Updated March 26, 2015 07:23 AM

Mysql Deadlock on update query on same row

Updated April 14, 2015 20:02 PM