Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3105

LP:819348 - myisam_recover fails to auto-repair all tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      We're running MariaDB with in my.cnf "myisam_recover = BACKUP_ALL,FORCE". We regularly have a crashed table on servers that fail to auto-repair:
      ===
      Aug 1 06:19:07 mx10 mysqld: 110801 6:19:07 [ERROR] mysqld: Table './database/test@002dtable' is marked as crashed and should be repaired
      Aug 1 06:19:07 mx10 mysqld: 110801 6:19:07 [Warning] Checking table: './database/test@002dtable'
      Aug 1 06:24:22 mx10 mysqld: 110801 6:24:22 [Warning] Recovering table: './database/test@002dtable'
      Aug 1 06:24:36 mx10 mysqld: 110801 6:24:36 [Note] Retrying repair of: './database/test@002dtable' with keycache
      Aug 1 06:24:36 mx10 mysqld: 110801 6:24:36 [ERROR] Couldn't repair table: mx_messages.test-table
      Aug 1 06:24:36 mx10 mysqld: 110801 6:24:36 [ERROR] mysqld: Table './database/test@002dtable' is marked as crashed and last (automatic?) repair failed
      ===

      We have no problems manually repairing the table with "REPAIR tablename". Log collection/a copy of such broken table has been reported some weeks ago already via the MariaDB FTP server and was picked up by Monty. Just never created an official ticket for it.

      Attachments

        Activity

          People

            monty Michael Widenius
            dreasvandonselaar Dreas van Donselaar (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.