Shulou(Shulou.com)06/01 Report--

The system always fails to query mysql data because of a sudden power outage. Report the error of ERROR 1017 (HY000): Can't find file: 'tablename' (errno: 2).

If you use the normal operation of repairing the table to repair it, the query reports the same error and the repair table fails.

Take a closer look at the data file of this table and find a problem. Because this table is partitioned, it is found that individual partitions are different from others:

Tablename#P#temp#p20170919.MYD

Tablename#P#temp#p20170919.MYI

There is an extra "# temp" in the partition file, and after renaming it to a normal name, querying the table is normal. It is speculated that the program just lost power during the operation of the partition, resulting in an abnormal partition.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.