`SET PERSIST ONLY innodb_sys_tablespace_encrypt`="ON" created an entry in the mysqld-auto.cnf and would cause a server restart to fail.

Description

It is noticed while testing https://perconadev.atlassian.net/browse/PS-3822#icft=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

Environment

None

Smart Checklist

Activity

Show:

mohit.joshi May 24, 2019 at 8:01 AM

Description fixed

Satya Bodapati May 24, 2019 at 7:55 AM

Please fix description.  innodb_parallel_dblwr_encrypt is not bootstrap only variable. It is global dynamic variable.

 

Done

Details

Assignee

Reporter

Time tracking

3h logged

Fix versions

Affects versions

Priority

Smart Checklist

Created May 24, 2019 at 6:38 AM
Updated March 6, 2024 at 12:07 PM
Resolved May 29, 2019 at 6:45 AM