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

InnoDB (compressed table) exported tablespace results in corrupted indexes

    XMLWordPrintable

    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

            Activity

              People

              Assignee:
              thiru Thirunarayanan Balathandayuthapani
              Reporter:
              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.