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

LP:881383 - Corrupt ARCHIVE tables failing to repair

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 5.1.67, 5.2.14, 5.3.12, 5.5.36, 10.0.9
    • 5.5(EOL)
    • None

    Description

      We regularly have corrupt ARCHIVE engine tables that fail to repair:
      ================================

      MariaDB [(none)]> database;
      Database changed
      MariaDB [database]> repair table table;
      +-----------------------------+--------+----------+----------+
      | Table                       | Op     | Msg_type | Msg_text |
      +-----------------------------+--------+----------+----------+
      | database.table | repair | error    | Corrupt  |
      +-----------------------------+--------+----------+----------+
      1 row in set (3.92 sec)
       
      MariaDB [database]>

      ================================

      I'm unsure what causes the corruption, but a repair shouldn't be failing I presume?

      I'll upload a copy of an example table to FTP.

      Attachments

        1. LPexportBug881383.xml
          10 kB
          Rasmus Johansson
        2. mdev678.test
          2 kB
          Elena Stepanova

        Activity

          People

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

            Dates

              Created:
              Updated:

              Git Integration

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