Debian Codegraph @

mysql-test/suite/innodb/t/log_encrypt_6.test

raw
1 # Test tries restart after redo log encryption is enabled
2 # - Error :restart without keyring plugin
3 # - Pass :restart without keyring plugin and --innodb_force_recovery=6
4 # - Pass :remove redo files,restart without keyring plugin
5
6 --source include/no_valgrind_without_big.inc
7
8 --disable_query_log
9 #Suppress following messages from myslqd log
10 call mtr.add_suppression("keyring_file initialization failure. Please check if the keyring_file_data points to readable keyring file or keyring file can be created in the specified location. The keyring_file will stay unusable until correct path to the keyring file gets provided");
11 call mtr.add_suppression("Error while loading keyring content. The keyring might be malformed");
12 call mtr.add_suppression("\\[Error\\] .*MY-\\d+.* Encryption can't find sourcekey, please check the keyring is loaded.");
13 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Failed to find tablespace for table `\.\.*`\.`\.\.*` in the cache.");
14 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.");
15 call mtr.add_suppression (" New redo log files created");
16 --enable_query_log
17
18 let $old_innodb_file_per_table = `SELECT @@innodb_file_per_table`;
19 let $old_innodb_redo_log_encrypt = `SELECT @@innodb_redo_log_encrypt`;
20 let $START_PAGE_SIZE= `select @@innodb_page_size`;
21 let $LOG_CAPACITY= `select @@innodb_redo_log_capacity`;
22 let $MYSQLD_BASEDIR= `select @@basedir`;
23
24 --mkdir $MYSQL_TMP_DIR/log_encrypt_dir1
25
26 let $MYSQLD_DATADIR1 = $MYSQL_TMP_DIR/log_encrypt_dir1;
27
28 let BOOTSTRAP_SQL=$MYSQL_TMP_DIR/boot.sql;
29
30 --echo # create bootstrap file
31 write_file $BOOTSTRAP_SQL;
32 CREATE DATABASE test;
33 EOF
34 --echo # Stop the MTR default DB server
35 --source include/shutdown_mysqld.inc
36
37 let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --initialize-insecure --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_page_size=$START_PAGE_SIZE --basedir=$MYSQLD_BASEDIR --datadir=$MYSQLD_DATADIR1 --init-file=$BOOTSTRAP_SQL --secure-file-priv="" --innodb_redo_log_encrypt=ON --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --keyring_file_data=$MYSQL_TMP_DIR/my_key_redo4 $KEYRING_PLUGIN_OPT </dev/null>>$MYSQLTEST_VARDIR/tmp/bootstrap1.log 2>&1;
38
39 --echo # Run the bootstrap command of datadir1
40 --exec $NEW_CMD
41
42 --echo # Start the DB server with datadir1
43 --replace_result $MYSQL_TMP_DIR TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $MYSQLD_DATADIR1 DATADIR1 $START_PAGE_SIZE PAGE_SIZE $LOG_CAPACITY LOG_CAPACITY
44 --let $restart_parameters="restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" $KEYRING_PLUGIN_OPT --keyring_file_data=$MYSQL_TMP_DIR/my_key_redo4 --innodb_redo_log_encrypt=ON --datadir=$MYSQLD_DATADIR1 --innodb_page_size=$START_PAGE_SIZE --innodb_redo_log_capacity=$LOG_CAPACITY"
45 --replace_regex /\.dll/.so/
46 --source include/start_mysqld_no_echo.inc
47
48
49 --disable_warnings
50 DROP DATABASE IF EXISTS tde_db;
51 CREATE DATABASE tde_db;
52 USE tde_db;
53 --enable_warnings
54
55 # Install Plugin : Start server without --early-plugin-load.
56 # Explicitly run , INSTALL PLUGIN keyring_file SONAME 'keyring_file.so';
57 # and Set innodb_redo_log_encrypt = ON/OFF
58 # Expected result : Plugin should install without any error and it's should
59 # show in SHOW PLUGINS; Redo file encryption is enabled/disable for redo log.
60
61 SET GLOBAL innodb_redo_log_encrypt = 1;
62 SELECT @@global.innodb_redo_log_encrypt ;
63
64 SELECT @@global.innodb_redo_log_encrypt ;
65 CREATE TABLE tde_db.t1 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
66 INSERT INTO t1 (a, b) VALUES (1, REPEAT('a', 6*512*512));
67 SELECT a,LEFT(b,10) FROM tde_db.t1;
68 CREATE TABLE tde_db.t2 (a BIGINT PRIMARY KEY, b LONGBLOB)
69 ENCRYPTION='Y' ENGINE=InnoDB;
70 INSERT INTO t2 (a, b) VALUES (1, REPEAT('a', 6*512*512));
71 SELECT a,LEFT(b,10) FROM tde_db.t2;
72 SELECT @@global.innodb_redo_log_encrypt ;
73 CREATE TABLE tde_db.t3 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
74 INSERT INTO t3 (a, b) VALUES (1, REPEAT('a', 6*512*512));
75 SELECT a,LEFT(b,10) FROM tde_db.t3;
76 CREATE TABLE tde_db.t4 (a BIGINT PRIMARY KEY, b LONGBLOB)
77 ENCRYPTION='Y' ENGINE=InnoDB;
78 INSERT INTO t4 (a, b) VALUES (1, REPEAT('a', 6*512*512));
79 SELECT a,LEFT(b,10) FROM tde_db.t4;
80
81 SELECT @@global.innodb_redo_log_encrypt ;
82 CREATE TABLE tde_db.t5 (a BIGINT PRIMARY KEY, b LONGBLOB) ENGINE=InnoDB;
83 INSERT INTO t5 (a, b) VALUES (1, REPEAT('a', 6*512*512));
84 SELECT a,LEFT(b,10) FROM tde_db.t5;
85 CREATE TABLE tde_db.t6 (a BIGINT PRIMARY KEY, b LONGBLOB)
86 ENCRYPTION='Y' ENGINE=InnoDB;
87 INSERT INTO t6 (a, b) VALUES (1, REPEAT('a', 6*512*512));
88 SELECT a,LEFT(b,10) FROM tde_db.t6;
89
90 UNINSTALL PLUGIN keyring_file;
91 DROP DATABASE tde_db;
92
93 # shutdown server
94 --let $_server_id= `SELECT @@server_id`
95 --source include/shutdown_mysqld.inc
96
97 --echo # Try starting without keyring : Error
98 let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --innodb_page_size=$START_PAGE_SIZE --innodb_redo_log_capacity=$LOG_CAPACITY --basedir=$MYSQLD_BASEDIR --datadir=$MYSQLD_DATADIR1 --secure-file-priv="" --console </dev/null>>$MYSQL_TMP_DIR/wl9290.err 2>&1;
99 --error 1,42
100 --exec $NEW_CMD
101
102
103 --echo # Search for error message
104 let SEARCH_FILE= $MYSQL_TMP_DIR/wl9290.err;
105 let SEARCH_PATTERN= Redo log was encrypted, but keyring is not loaded;
106 --source include/search_pattern.inc
107 let SEARCH_PATTERN= Aborting;
108 --source include/search_pattern.inc
109
110
111
112 --echo # Restart without keyring plugin possible if redo files removed
113 --remove_files_wildcard $MYSQLD_DATADIR1/#innodb_redo #ib_redo*
114
115 --echo # Start the DB server with datadir1
116 --replace_result $MYSQL_TMP_DIR TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $MYSQLD_DATADIR1 DATADIR1 $START_PAGE_SIZE PAGE_SIZE $LOG_CAPACITY LOG_CAPACITY
117 --let $restart_parameters="restart: --datadir=$MYSQLD_DATADIR1 --innodb_page_size=$START_PAGE_SIZE --innodb_redo_log_capacity=$LOG_CAPACITY"
118 --replace_regex /\.dll/.so/
119 --source include/start_mysqld_no_echo.inc
120
121
122 # shutdown server
123 --let $_server_id= `SELECT @@server_id`
124 --source include/shutdown_mysqld.inc
125
126 --echo # Try starting without keyring and --innodb_force_recovery=SRV_FORCE_NO_LOG_REDO.
127 --echo # Start the DB server with datadir1
128 --replace_result $MYSQL_TMP_DIR TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $MYSQLD_DATADIR1 DATADIR1 $START_PAGE_SIZE PAGE_SIZE $LOG_CAPACITY LOG_CAPACITY
129 --let $restart_parameters="restart: --datadir=$MYSQLD_DATADIR1 --innodb_page_size=$START_PAGE_SIZE --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_force_recovery=6 --no-console --log-error=$MYSQL_TMP_DIR/wl9290_2.err "
130 --replace_regex /\.dll/.so/
131 --source include/start_mysqld_no_echo.inc
132 SELECT 1;
133
134 # shutdown server
135 --let $_server_id= `SELECT @@server_id`
136 --source include/shutdown_mysqld.inc
137
138 # restart the server with MTR default
139 --let $restart_parameters=
140 --source include/start_mysqld.inc
141
142 --remove_file $BOOTSTRAP_SQL
143 --remove_file $MYSQL_TMP_DIR/my_key_redo4
144 --remove_file $MYSQL_TMP_DIR/wl9290.err
145 --remove_file $MYSQL_TMP_DIR/wl9290_2.err
146
147 # Remove residue files
148 --force-rmdir $MYSQLD_DATADIR1
149 --remove_file $MYSQLTEST_VARDIR/tmp/bootstrap1.log