Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-6987

Modify to allow value of default_table_encryption to be changed only when encryption_threads are off

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.0.21-12
    • Component/s: None
    • Labels:
      None

      Description

      While creating PS-5635 : Intoduce crypt_schema 2 for better error checking in encryption threads I have added an assert that page has to be decrypted if there is no key available for this space in keyring. This is an extension of that PS-5635 only allows encrypted tables to be opened when there are all required encryption keys available in the keyring to decrypt this table. Test create_or_replace reveled that when default_table_encryption is changed multiple times and encryption threads are enabled and disabled - there can be a situation that some pages are left encrypted. I have verified that this problem occurs pre PS-5635, but was not visible due to lack of the assert.

        Attachments

          Activity

            People

            Assignee:
            robert.golebiowski Robert Golebiowski (Inactive)
            Reporter:
            robert.golebiowski Robert Golebiowski (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 1 week, 3 hours
                1w 3h

                  Smart Checklist