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

    • Bug
    • Status: Done
    • Medium
    • Resolution: Fixed
    • 2.4.12
    • 8.0-2-alpha2, 2.4.13
    • None
    • 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.

      Attachments

        Activity

          People

            sergei.glushchenko Sergei Glushchenko (Inactive)
            sergei.glushchenko Sergei Glushchenko (Inactive)
            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

                Smart Checklist