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

InnoDB (compressed table) exported tablespace results in corrupted indexes

Details

    Description

      I have table that passes mysqlcheck just fine. After exporting the tablespace, and importing it in another database, the table becomes corrupted.

      test.tableset
      		 
      Warning  : InnoDB: The B-tree of index PRIMARY is corrupted.
      		 
      Warning  : InnoDB: Index 'suffix' contains 5 entries, should be 18446744073709551615.
      		 
      error    : Corrupt

      After recreating a fresh table this doesn't occur so the ibd might very well be corrupt - but that would indicate another issue as the server does not seem hindered by this corruption while operating normally.

      I've attached the exported tablespace with the cfg; the structure of this table is: 

      CREATE TABLE `tableset` (
      		 
        `setid` int(11) unsigned NOT NULL AUTO_INCREMENT,
      		 
        `prefix` varchar(12) CHARACTER SET latin1 NOT NULL DEFAULT '',
      		 
        `frontend` enum('Y','N') CHARACTER SET latin1 NOT NULL DEFAULT 'N',
      		 
        `datestr` int(10) unsigned NOT NULL DEFAULT 0,
      		 
        `interval` enum('monthly','weekly') CHARACTER SET latin1 NOT NULL DEFAULT 'monthly',
      		 
        `version` tinyint(3) unsigned NOT NULL DEFAULT 0,
      		 
        `updatewindow` varchar(11) CHARACTER SET latin1 NOT NULL DEFAULT '',
      		 
        `source` enum('pcreeks','perceel','perceel-bag','adres-bag','adres-bag-onbebouwd','pcreeks-rws','pcreeks-convert','perceel-convert') CHARACTER SET latin1 NOT NULL,
      		 
        `deliverysource` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'none',
      		 
        `status` enum('empty','ready','match-id','disabled') CHARACTER SET latin1 NOT NULL DEFAULT 'ready',
      		 
        `symsearch_version` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
      		 
        `comments` varchar(30) CHARACTER SET latin1 NOT NULL DEFAULT '',
      		 
        PRIMARY KEY (`setid`),
      		 
        UNIQUE KEY `suffix` (`prefix`)
      		 
      ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci ROW_FORMAT=DYNAMIC `PAGE_COMPRESSED`=1;

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26131 SEGV in ha_innobase::discard_or_import_tablespace

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            sjon sjon created issue -
            sjon sjon made changes -
            Field Original Value New Value
            Description I have table that passes {{mysqlcheck}} just fine. After exporting the tablespace, and importing it in another database, the table becomes corrupted.

            {code}
            test.tableset
            Warning : InnoDB: The B-tree of index PRIMARY is corrupted.
            Warning : InnoDB: Index 'suffix' contains 5 entries, should be 18446744073709551615.
            error : Corrupt
            {code}

            After recreating a fresh table this doesn't occur so the ibd might very well be corrupt - but that would indicate another issue as the server does not seem hindered by this corruption while operating normally             		I have table that passes {{mysqlcheck}} just fine. After exporting the tablespace, and importing it in another database, the table becomes corrupted.

            {code}
            test.tableset
            Warning : InnoDB: The B-tree of index PRIMARY is corrupted.
            Warning : InnoDB: Index 'suffix' contains 5 entries, should be 18446744073709551615.
            error : Corrupt
            {code}

            After recreating a fresh table this doesn't occur so the ibd might very well be corrupt - but that would indicate another issue as the server does not seem hindered by this corruption while operating normally.

            I've attached the exported tablespace with the cfg; the structure of this table is:
            {code}
            CREATE TABLE `tableset` (
              `setid` int(11) unsigned NOT NULL AUTO_INCREMENT,
              `prefix` varchar(12) CHARACTER SET latin1 NOT NULL DEFAULT '',
              `frontend` enum('Y','N') CHARACTER SET latin1 NOT NULL DEFAULT 'N',
              `datestr` int(10) unsigned NOT NULL DEFAULT 0,
              `interval` enum('monthly','weekly') CHARACTER SET latin1 NOT NULL DEFAULT 'monthly',
              `version` tinyint(3) unsigned NOT NULL DEFAULT 0,
              `updatewindow` varchar(11) CHARACTER SET latin1 NOT NULL DEFAULT '',
              `source` enum('pcreeks','perceel','perceel-bag','adres-bag','adres-bag-onbebouwd','pcreeks-rws','pcreeks-convert','perceel-convert') CHARACTER SET latin1 NOT NULL,
              `deliverysource` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL DEFAULT 'none',
              `status` enum('empty','ready','match-id','disabled') CHARACTER SET latin1 NOT NULL DEFAULT 'ready',
              `symsearch_version` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
              `comments` varchar(30) CHARACTER SET latin1 NOT NULL DEFAULT '',
              PRIMARY KEY (`setid`),
              UNIQUE KEY `suffix` (`prefix`)
            ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci ROW_FORMAT=DYNAMIC `PAGE_COMPRESSED`=1;
            {code}
            marko Marko Mäkelä 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 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Fix Version/s 10.9 [ 26905 ]
            Affects Version/s 10.6 [ 24028 ]
            Assignee Thirunarayanan Balathandayuthapani [ thiru ]
            marko Marko Mäkelä made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.7 [ 24805 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.3 [ 22126 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.8 [ 26121 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.9 [ 26905 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.4 [ 22408 ]

            People

              thiru Thirunarayanan Balathandayuthapani
              sjon sjon
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.