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

Dump restore S3 partition table --no-data lead to unusable tables

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11
    • None
    • Storage Engine - S3
    • None

    Description

      mysqldump the structure of s3 partition tables give illegal mixed storage table as the main table is aria and partitions are S3

      Following such dump and restore probably break .par and .frm filles that make auto table discovered failure

      Note on minio the full dataset is still available in S3 while drop table should have destroyed the data

      Need to rm -rf all S3 buckets to recover a fully working database

      Flush tables did not help to recover the S3 tables when all data was still in S3 after restore of table definition

      Attachments

        Activity

          People

            Unassigned Unassigned
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.