Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.13-4, Not 5.7.x
-
None
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
Attachments
Issue Links
- blocks
-
PS-3822 InnoDB system tablespace encryption
-
- Done
-