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

IMPORT TABLESPACE fails after instant DROP COLUMN

    XMLWordPrintable

    Details

      Description

      After the MDEV-18295 fix, IMPORT TABLESPACE will fail to import data files on which columns have been instantly reordered or dropped (MDEV-15562).

      The problem is demonstrated by this part of the test innodb.instant_alter_import:

      --echo # Import a data file that contains instant DROP COLUMN metadata
      		 
      alter table t2 drop x;
      		 
      alter table t1 drop x, force;
      		 
      alter table t1 discard tablespace;
      		 
       
      		 
      flush tables t2 for export;
      		 
      --move_file $MYSQLD_DATADIR/test/t2.cfg $MYSQLD_DATADIR/test/t1.cfg
      		 
      --copy_file $MYSQLD_DATADIR/test/t2.ibd $MYSQLD_DATADIR/test/t1.ibd
      		 
      unlock tables;
      		 
       
      		 
      --error ER_TABLE_SCHEMA_MISMATCH
      		 
      alter table t1 import tablespace;

      The IMPORT TABLESPACE code should read the metadata record and the metadata BLOB early, to augment the metadata. Because the pages have not been adjusted yet, the buffer pool will have to be bypassed while reading the pages.

        Attachments

          Issue Links

          blocks

          Task - A task that needs to be done. MDEV-18762 Support easy restore of partial backup

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23874 Crash in ALTER TABLE ... IMPORT TABLESPACE for the table after instant ALTER was used on it

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-24352 General error: 1808 Schema mismatch (Index field count XX doesn't match tablespace metadata file value YY)

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26847 improve encryption/compression check in ALTER TABLE IMPORT

          • Major - Major loss of function.
          • Open
          includes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26621 assertion failue "index->table->persistent_autoinc" in /storage/innobase/btr/btr0btr.cc during IMPORT

          • Major - Major loss of function.
          • Closed
          is caused by

          Task - A task that needs to be done. MDEV-15562 Instant DROP COLUMN or changing the order of columns

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25066 IMPORT TABLESPACE not possible if source table had column moved in INSTANT mode

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-20590 Introduce a file format constraint to ALTER TABLE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21549 IMPORT TABLESPACE fails to adjust all tablespace ID in root pages

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27272 Crash on EXPORT/IMPORT tablespace with column added in the middle

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-11658 Simpler, faster IMPORT of InnoDB tables

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18295 IMPORT TABLESPACE fails with instant-altered tables

          • Major - Major loss of function.
          • Closed

            Activity

              People

              Assignee:
              kevg Eugene Kosov (Inactive)
              Reporter:
              marko Marko Mäkelä
              Votes:
              6 Vote for this issue
              Watchers:
              11 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.