Cause of Corrupted Database

  • Resolved lcottingham

    (@lcottingham)


    6 years, 5 months ago

    Hi,

    After a bit of investigation, the devs determined that the tables ‘wp_WP_SEO_404_links’, ‘wp_WP_SEO_Cache’, ‘wp_WP_SEO_Redirection’ and wp_WP_SEO_Redirection_LOG.

    And example entry in the log is as follows:
    180530 16:23:13 [Warning] Checking table: ‘./sugarsku_cast/wp_WP_SEO_404_links’
    180530 16:30:02 [ERROR] mysqld: Table ‘./sugarsku_cast/wp_WP_SEO_Redirection_LOG’ is marked as crashed and should be repaired

    What this does, is when data is attempted to be written to it, crashes the entire database and corrupts the InnoDB engine. This breaks everything and crashes the MySQL service.

    As a result, we end up with this:
    Error: Unknown storage engine ‘InnoDB’ on all tables. WordPress repair has no effect.
    https://forums.cpanel.net/threads/error-unknown-storage-engine-innodb-error-corrupt.491341/

    The solution for me so far is to delete the InnoDB logs and restart the MySQL service. I have then had to disable/delete your plugin and delete the four tables associated. By deleting the logs, it allows me to restart the MySQL service with InnoDB – however, when data is written again it will crash the service again.

    Are you able to shine any light on this?
    Thanks,
    Luke

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Cause of Corrupted Database’ is closed to new replies.