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

Allow logging of plaintext InnoDB tables during startup

    XMLWordPrintable

Details

    Description

      When changing the encryption status of the server to remove encryption we see notification about the redo log:

      2018-08-16 10:42:12 0 [Note] InnoDB: Removing redo log encryption: 2*50331648 bytes; LSN=1643709
      

      However, we don't see any notification about any tables that have been marked as ENCRYPTED=NO whilst automatic and enforce encryption is set with innodb_encrypt_tables=FORCE.

      This could leave data in an unexpected state, particularly if reading part of the documentation that implies access could be prevented with FORCE (MDEV-16997).

      Perhaps due to the potential number of tables that could me marked to avoid encryption, logging of such information would best be performed via a configurable option so that it can be turned on/off as required.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              cezmunsta Ceri Williams
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.