Debian Codegraph @

mysql-test/suite/innodb_undo/t/undo_tablespace_encrypt.test

raw
1 ################################################################################
2 # Test script to test UNDO tablespace encryption setting to be displayed in
3 # INFORMATION_SCHEMA.INNODB_TABLESPACES.
4 ################################################################################
5
6 # Note:
7 # Due to encrypt options used below its not possible to return to clean
8 # state: create and use separate datadir for this test
9
10 --echo #
11 --echo # Bug #29492911 : ENABLING UNDO-TABLESPACE ENCRYPTION DOESN'T MARK TABLESPACE ENCRYPTION FLAG
12 --echo #
13
14 let $MYSQL_DATA_DIR = `select @@datadir`;
15
16 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
17
18 --let $INNODB_FILE_PER_TABLE= `SELECT @@innodb_file_per_table`
19 --let $PAGE_SIZE= `select @@innodb_page_size`
20 --let $LOG_SIZE= `select @@innodb_redo_log_capacity`
21
22 --let $MYSQL_ENC_DATADIR= $MYSQL_TMP_DIR/undo_tablespace_encrypt_dir
23 --mkdir $MYSQL_ENC_DATADIR
24
25 --let $BOOTSTRAP_LOG= $MYSQL_TMP_DIR/bootstrap_encrypt.log
26
27 --let $BOOTSTRAP_SQL= $MYSQL_TMP_DIR/boot.sql
28 --write_file $BOOTSTRAP_SQL
29 CREATE DATABASE test;
30 EOF
31
32 --source include/shutdown_mysqld.inc
33 --source include/wait_until_disconnected.inc
34
35 --let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --initialize-insecure --innodb_redo_log_capacity=$LOG_SIZE --innodb_page_size=$PAGE_SIZE --datadir=$MYSQL_ENC_DATADIR --init-file=$BOOTSTRAP_SQL --secure-file-priv="" >>$BOOTSTRAP_LOG 2>&1
36 --exec $NEW_CMD
37
38 --echo ###############################################################################
39 --echo # With keyring plugin and innodb_undo_log_encrypt=ON
40 --echo ###############################################################################
41 --let $restart_parameters="restart: --datadir=$MYSQL_ENC_DATADIR --log_error_verbosity=3 --early-plugin-load="keyring_file=$KEYRING_PLUGIN" $KEYRING_PLUGIN_OPT --keyring_file_data=$MYSQL_TMP_DIR/my_keyfile --innodb_undo_log_encrypt=ON --log-error=$MYSQLTEST_VARDIR/log/mysqld.1.err "
42 --source include/start_mysqld_no_echo.inc
43
44 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
45
46 --echo # Create a new UNDO tablespace. Should be created as ENCRYPTED.
47 CREATE UNDO TABLESPACE undo_3 ADD DATAFILE 'undo_3.ibu';
48 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
49
50 SET GLOBAL innodb_undo_log_encrypt=OFF;
51 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
52 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
53
54 --echo # Create a new UNDO tablespace. Should be created as UNENCRYPTED.
55 CREATE UNDO TABLESPACE undo_4 ADD DATAFILE 'undo_4.ibu';
56 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
57
58 SET GLOBAL innodb_undo_log_encrypt=ON;
59 SHOW VARIABLES LIKE "%innodb_undo_log_encrypt%";
60 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
61
62 --echo ###############################################################################
63 --echo # With keyring plugin and innodb_undo_log_encrypt=OFF
64 --echo ###############################################################################
65 --let $restart_parameters="restart: --datadir=$MYSQL_ENC_DATADIR --log_error_verbosity=3 --early-plugin-load="keyring_file=$KEYRING_PLUGIN" $KEYRING_PLUGIN_OPT --keyring_file_data=$MYSQL_TMP_DIR/my_keyfile --innodb_undo_log_encrypt=OFF --log-error=$MYSQLTEST_VARDIR/log/restart_1.err"
66 --source include/restart_mysqld_no_echo.inc
67
68 # Mark UNDO tablespace inactive so that it could be dropped.
69 ALTER UNDO TABLESPACE undo_3 set INACTIVE;
70 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
71 let $inactive_undo_space = undo_3;
72 source include/wait_until_undo_space_is_empty.inc;
73 DROP UNDO TABLESPACE undo_3;
74
75 # Mark UNDO tablespace inactive so that it could be dropped.
76 ALTER UNDO TABLESPACE undo_4 set INACTIVE;
77 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
78 let $inactive_undo_space = undo_4;
79 source include/wait_until_undo_space_is_empty.inc;
80 DROP UNDO TABLESPACE undo_4;
81
82 SELECT NAME, SPACE_TYPE, ENCRYPTION, STATE FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE SPACE_TYPE='Undo';
83
84 --echo # Reset to initial state
85 --let $restart_parameters="restart:"
86 --source include/restart_mysqld.inc
87
88 --remove_file $MYSQL_TMP_DIR/my_keyfile
89 --remove_file $BOOTSTRAP_LOG
90 --remove_file $BOOTSTRAP_SQL
91 --force-rmdir $MYSQL_ENC_DATADIR