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

              Assignee:
              Unassigned
              Reporter:
              cezmunsta Ceri Williams
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: