WordPress.org

Make WordPress Core

Opened 2 years ago

Closed 2 years ago

#41429 closed defect (bug) (wontfix)

Database repair fails if temp file already exists

Reported by: benjamincmarks Owned by:
Milestone: Priority: normal
Severity: normal Version:
Component: Database Keywords:
Focuses: Cc:
PR Number:

Description

See also: https://bugs.mysql.com/bug.php?id=87180

When attempting to repair a corrupted database file in wordpress, the wp_postmeta table could not be repaired. I sshed into the machine and ran myisamchk to repair the database table in question, getting a "temp file already exists error." Removing the temp file allowed the repair to complete successfully.

I'd expect the temp file to be deleted and a retry attempted before failure.

Change History (1)

#1 @pento
2 years ago

  • Milestone Awaiting Review deleted
  • Resolution set to wontfix
  • Status changed from new to closed
  • Version trunk deleted

Thank you for the bug report, @benjamincmarks!

It's not possible for WordPress to alter the TMD file - this is generated by the MySQL server, and has to be removed on the server.

If a repair fails, it can also be dangerous to remove the TMD file without backing it up, as there may be recoverable data in it.

WordPress' repair.php is only intended to do basic repair queries, anything more detailed must be done by hand.

Note: See TracTickets for help on using tickets.