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

IMPORT TABLESPACE fails with column count or index count mismatch

Details

    Description

      When trying to import a table from a mariabackup taken from a 10.4.18 instance using mariabackup --prepare --export and ALTER TABLE ... IMPORT TABLESPACE I'm getting

      ERROR 1808 (HY000): Schema mismatch (Number of columns don't match, table has 9 columns but the tablespace meta-data file has 10 columns)

      when importing into 10.4.18 to 10.4.22; and for later versions, all the way up to 10.11

      ERROR 1808 (HY000): Schema mismatch (Number of indexes don't match, table has 5 indexes but the tablespace meta-data file has 6 indexes)

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35059 ALTER TABLE...IMPORT TABLESPACE with FULLTEXT SEARCH may corrupt the adaptive hash index

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          DOCSCOLLAB-851 Failed to load

          Activity

            Transition Time In Source Status Execution Times
            Julien Fritsch made transition -
            Open Closed
            		107d 4h 10m 1
            Hartmut Holzgraefe made transition -
            Closed Stalled
            		192d 3h 38m 1
            Thirunarayanan Balathandayuthapani made transition -
            Stalled In Progress
            		33d 15h 39m 2
            Thirunarayanan Balathandayuthapani made transition -
            In Progress In Review
            		21d 23h 42m 2
            Marko Mäkelä made transition -
            In Review Stalled
            		7d 5h 44m 2
            Thirunarayanan Balathandayuthapani made transition -
            Stalled In Testing
            		2d 23h 10m 1
            Matthias Leich made transition -
            In Testing Stalled
            		3d 22h 51m 1
            Thirunarayanan Balathandayuthapani made transition -
            Stalled Closed
            		1d 1h 36m 1

            People

              thiru Thirunarayanan Balathandayuthapani
              hholzgra Hartmut Holzgraefe
              Votes:
              1 Vote for this issue
              Watchers:
              9 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.