Uploaded image for project: 'Percona XtraBackup'
  1. Percona XtraBackup
  2. PXB-1648

xtrabackup fails to open tablespace with error "Encryption information in datafile: <NAME.ibd> can't be decrypted"

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 2.4.12
    • Fix Version/s: 2.4.13, 8.0-2-alpha2
    • Component/s: None
    • Labels:
      None

      Description

      Statements like

      ALTER TABLE ENCRYPTION='y';
      ALTER TABLE COMPRESSION='lz4';
      ALTER TABLE ADD INDEX ...;
      

      are done by creating new table and copying all the contents from the source table to this new one.

      Table created in two steps:

      • table file is created, first page initialized and table flags are written (including encryption flag) using os_file_write which writes directly into the file, skipping redo log.
      • fil_set_encryption is called to store encryption information into the tablespace header. This call does not write into the file directly, instead information is updated in buffer pool and written to the redo log.

      Error happens when xtrabackup is trying to open the tablespace which has been created, but it's encryption information has not been flushed to the file yet.

      Fix will be to allow such tablespaces. Encryption info will be restored from the redo log during preapre.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                sergei.glushchenko Sergei Glushchenko
                Reporter:
                sergei.glushchenko Sergei Glushchenko
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 day
                  1d