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

Mariabackup fails to copy encrypted InnoDB system tablespace if LSN>4G

Details

    Description

      When the InnoDB log sequence number exceeds 4,294,967,295, mariabackup --backup would wrongly detect the first page of the InnoDB system tablespace as corrupted.

      The first page is never encrypted. In the first page of the system tablespace, the field that was repurposed for the encryption key_version on other pages would contain the 32 most significant bits of the LSN at the latest InnoDB shutdown. If these bits are not 0, mariabackup --backup would fail with the following kind of output:

      181229 22:54:31 [01] Copying ibdata1 to /dev/shm/10.1/mysql-test/var/tmp/backup/ibdata1
      [01] mariabackup: Database page corruption detected at page 0, retrying...
      [01] mariabackup: Database page corruption detected at page 0, retrying...
      [01] mariabackup: Database page corruption detected at page 0, retrying...
      [01] mariabackup: Database page corruption detected at page 0, retrying...
      [01] mariabackup: Database page corruption detected at page 0, retrying...
      [01] mariabackup: Database page corruption detected at page 0, retrying...
      [01] mariabackup: Database page corruption detected at page 0, retrying...
      [01] mariabackup: Database page corruption detected at page 0, retrying...
      181229 22:54:32 >> log scanned up to (17596481013967)
      [01] mariabackup: Database page corruption detected at page 0, retrying...
      [01] mariabackup: Error: failed to read page after 10 retries. File ibdata1 seems to be corrupted.
      [01] mariabackup: Error: xtrabackup_copy_datafile() failed.
      [01] mariabackup: Error: failed to copy datafile.
      

      We must skip this test for the very first page of any file.

      Attachments

        Issue Links

          Activity

            marko Marko Mäkelä created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2018-12-29 21:31:35.0 2018-12-29 21:31:35.483
            marko Marko Mäkelä made changes -
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 91432 ] MariaDB v4 [ 155424 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 118441

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.