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

Importing InnoDB table from 10.1 to 10.2 causes Schema mismatch (Expected FSP_SPACE_FLAGS=0x21, .ibd file contains 0x0

Details

    Description

      See attached test case that creates table and exports it, this should be run on 10.1 (attached also resulting t0.ibd). Second test case should be run on 10.2 to try import file created above but it fails. Note that final test case should test also row_format=compressed,
      encrypted and encrypted+compressed cases.

      set global innodb_file_format = 'Barracuda';
      		 
      set global innodb_file_per_table=ON;
      		 
      create table t0 (c1 int not null auto_increment primary key, b char(200)) engine=innodb;
      		 
      alter table t0 discard tablespace;
      		 
      alter table t0 import tablespace;
      		 
      encryption.jan2 'innodb'                 [ fail ]
      		 
              Test ended at 2018-01-24 11:19:34
      		 
       
      		 
      CURRENT_TEST: encryption.jan2
      		 
      mysqltest: At line 12: query 'alter table t0 import tablespace' failed: 1808: Schema mismatch (Expected FSP_SPACE_FLAGS=0x21, .ibd file contains 0x0.)

      Attachments

        1. jan2.test
          0.4 kB
        2. jan2.test
          0.3 kB
        3. t0.ibd
          96 kB

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15225 Can't import .ibd file with temporal type format differing from mysql56_temporal_format

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-18762 Support easy restore of partial backup

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20930 Document that SHOW CREATE TABLE on InnoDB tables only shows ROW_FORMAT when explicitly set

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-11658 Simpler, faster IMPORT of InnoDB tables

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16851 On schema mismatch in IMPORT TABLESPACE, display ROW_FORMAT in clear text

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-20974 Don't require .cfg files to import InnoDB tablespaces

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            jplindst Jan Lindström (Inactive) created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Ian Gilfillan [ greenman ]
            julien.fritsch Julien Fritsch made changes -
            Assignee Ian Gilfillan [ greenman ] Kenneth Dyer [ kennethdyer ]
            julien.fritsch Julien Fritsch made changes -
            Support case ID 25025 not-25025
            marko Marko Mäkelä made changes -
            jacob.moorman Jacob Moorman (Inactive) made changes -
            Assignee Kenneth Dyer [ kennethdyer ] Jacob Moorman [ jacob.moorman ]
            jacob.moorman Jacob Moorman (Inactive) made changes -
            Assignee Jacob Moorman [ jacob.moorman ] Geoff Montee [ geoffmontee ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            Assignee Geoff Montee [ geoffmontee ] Marko Mäkelä [ marko ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Eugene Kosov [ kevg ]
            valerii Valerii Kravchuk made changes -
            Assignee Eugene Kosov [ kevg ] Valerii Kravchuk [ valerii ]
            valerii Valerii Kravchuk made changes -
            Assignee Valerii Kravchuk [ valerii ] Eugene Kosov [ kevg ]
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            marko Marko Mäkelä made changes -
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s 10.4 [ 22408 ]
            Affects Version/s 10.5 [ 23123 ]
            Labels NRE_106_INNODB
            marko Marko Mäkelä made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Assignee Eugene Kosov [ kevg ] Marko Mäkelä [ marko ]
            Resolution Won't Fix [ 2 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 85108 ] MariaDB v4 [ 153635 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 156020

            People

              marko Marko Mäkelä
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.