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

LP:588599 - ARCHIVE tables aren't discoverable after OPTIMIZE

    XMLWordPrintable

Details

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

    Description

      Description:
      OPTIMIZE TABLE on an ARCHIVE table rewrites the ARZ file.

      It does not copy the FRM stored in the ARZ across. So an ARCHIVE table that has been
      OPTIMIZEd cannot be discovered.

      How to repeat:
      CREATE TABLE t1 (a int) ENGINE=ARCHIVE;
      OPTIMIZE TABLE t1;
      rm t1.frm
      select * from t1;

      You can also verify with archive_reader

      Attachments

        Activity

          People

            monty Michael Widenius
            stewart Stewart Smith
            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.