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

innodb_sys_tablespace_encrypt must not be allowed to be persisted

    Details

      Description

      It is noticed while testing PS-3822, introduces a new bootstrap variable:
      1. innodb_sys_tablespace_encrypt

      This variable must be passed while initialising the data directory. If the data-dir is not initialised with this option, the default is OFF and if attempted to start the server with
      --innodb_sys_tablespace_encrypt=ON will return an error

      However, it is noticed that
      SET PERSIST_ONLY innodb_sys_tablespace_encrypt = ON;

      executed successfully without any error which is incorrect behaviour
      secondly, it creates an entry in mysqld-auto.cnf due to which during next  restart, the server refuses to come up

      mysql> set persist_only innodb_sys_tablespace_encrypt = ON;
      Query OK, 0 rows affected (0.01 sec)

      mysql> show global variables like 'innodb_sys_tablespace_encrypt';
      ------------------------------------+

      Variable_name Value

      ------------------------------------+

      innodb_sys_tablespace_encrypt OFF

      ------------------------------------+
      1 row in set (0.01 sec)

      2019-05-24T06:26:52.194734Z 1 [ERROR] [MY-011825] [InnoDB] The system tablespace is not encrypted but --innodb_sys_tablespace_encrypt is ON. This instance was not bootstrapped with --innodb_sys_tablespace_encrypt=ON. Disable this option and start server

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  satya.bodapati Satya Bodapati
                  Reporter:
                  mohit.joshi Mohit Joshi
                • 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 - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 3 hours
                    3h