Debian Codegraph @

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

raw
1 --source include/big_test.inc
2
3 --disable_query_log
4 call mtr.add_suppression("\\[Error\\] .*MY-\\d+.* Encryption can't find master key, please check the keyring plugin is loaded.");
5 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Can't set undo log tablespace to be encrypted.");
6 # See Bug #25446984: INNODB.UNDO_ENCRYPT_BOOTSTRAP HAS OCCASIONAL FAILURES ON PB2
7 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Can't rotate encryption on undo tablespace");
8 --enable_query_log
9
10 let $MYSQLD_BASEDIR= `select @@basedir`;
11 let $START_PAGE_SIZE= `select @@innodb_page_size`;
12 let $LOG_CAPACITY= `select @@innodb_redo_log_capacity`;
13
14 # Create path for ibdata* & undo* files both DBs
15 --mkdir $MYSQL_TMP_DIR/innodb_undo_data_dir
16 --mkdir $MYSQL_TMP_DIR/innodb_data_home_dir
17 --mkdir $MYSQL_TMP_DIR/datadir
18
19 # Set path for --datadir
20 let $MYSQLD_DATADIR = $MYSQL_TMP_DIR/datadir/data;
21
22 # Set path for undo* files.
23 let $MYSQLD_UNDO_DATADIR = $MYSQL_TMP_DIR/innodb_undo_data_dir;
24
25 # Set path for ibdata* files.
26 let $MYSQLD_HOME_DATA_DIR = $MYSQL_TMP_DIR/innodb_data_home_dir;
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
35 --echo # Stop the MTR default DB server
36 --source include/shutdown_mysqld.inc
37
38 # Test1: bootstrap with undo encryption but no keyring plugin, it should
39 # fail.
40
41 # Set the bootstrap parameters with undo log encryption enabled
42 let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --initialize-insecure --secure-file-priv="" --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_page_size=$START_PAGE_SIZE --innodb_data_home_dir=$MYSQLD_HOME_DATA_DIR --innodb_undo_directory=$MYSQLD_UNDO_DATADIR --basedir=$MYSQLD_BASEDIR --datadir=$MYSQLD_DATADIR --init-file=$BOOTSTRAP_SQL --innodb_undo_log_encrypt=ON </dev/null>>$MYSQLTEST_VARDIR/tmp/bootstrap.log 2>&1;
43
44 --echo # Run the bootstrap command with no keyring
45 --error 1,42
46 --exec $NEW_CMD
47
48 # Remove residue files
49 --force-rmdir $MYSQL_TMP_DIR/datadir
50 --force-rmdir $MYSQL_TMP_DIR/innodb_data_home_dir
51 --force-rmdir $MYSQL_TMP_DIR/innodb_undo_data_dir
52
53 # Create path for ibdata* & undo* files both DBs
54 --mkdir $MYSQL_TMP_DIR/innodb_undo_data_dir
55 --mkdir $MYSQL_TMP_DIR/innodb_data_home_dir
56 --mkdir $MYSQL_TMP_DIR/datadir
57
58 # Test2: bootstrap with undo encryption and with keyring plugin, it should
59 # success, then restart with no undo encryption.
60 let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --initialize-insecure --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_page_size=$START_PAGE_SIZE --innodb_data_home_dir=$MYSQLD_HOME_DATA_DIR --innodb_undo_directory=$MYSQLD_UNDO_DATADIR --basedir=$MYSQLD_BASEDIR --datadir=$MYSQLD_DATADIR --init-file=$BOOTSTRAP_SQL --innodb_undo_log_encrypt=ON --secure-file-priv="" --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --keyring_file_data=$MYSQL_TMP_DIR/my_key_undo5 $KEYRING_PLUGIN_OPT </dev/null>>$MYSQLTEST_VARDIR/tmp/bootstrap2.log 2>&1;
61
62 --echo # Run the bootstrap command with keyring
63 --exec $NEW_CMD
64
65 --echo # Search for particular string of encryption metadata, should success since it's encrypted.
66 let SEARCH_FILE= $MYSQLD_UNDO_DATADIR/undo_001;
67 let SEARCH_PATTERN= lCC;
68 --source include/search_pattern.inc
69
70 #--echo # Start the DB server with undo log encryption disabled, and no keyring plugin. It should fail.
71 #--replace_result $MYSQLD_HOME_DATA_DIR MYSQLD_HOME_DATA_DIR $MYSQLD_UNDO_DATADIR MYSQLD_UNDO_DATADIR $MYSQLD_DATADIR MYSQLD_DATADIR $START_PAGE_SIZE PAGE_SIZE $LOG_CAPACITY LOG_CAPACITY
72 #--let $restart_parameters="restart: --innodb_page_size=$START_PAGE_SIZE --innodb_redo_log_capacity=$LOG_CAPACITY --innodb_data_home_dir=$MYSQLD_HOME_DATA_DIR --innodb_undo_directory=$MYSQLD_UNDO_DATADIR --datadir=$MYSQLD_DATADIR"
73 #--echo # start server fail!!!!
74 #--error 0
75 #--source include/start_mysqld_no_echo.inc
76
77 --echo # Start the DB server with undo log encryption disabled and keyring plugin loaded. It should success.
78 --let $restart_parameters="restart: --early-plugin-load="keyring_file=$KEYRING_PLUGIN" $KEYRING_PLUGIN_OPT --keyring_file_data=$MYSQL_TMP_DIR/my_key_undo5 --innodb_data_home_dir=$MYSQLD_HOME_DATA_DIR --innodb_undo_directory=$MYSQLD_UNDO_DATADIR --datadir=$MYSQLD_DATADIR --innodb_page_size=$START_PAGE_SIZE --innodb_redo_log_capacity=$LOG_CAPACITY"
79 --replace_result $MYSQL_TMP_DIR TMP_DIR $KEYRING_PLUGIN_OPT --plugin-dir=KEYRING_PLUGIN_PATH $MYSQLD_HOME_DATA_DIR HOME_DIR $MYSQLD_UNDO_DATADIR UNDO_DATADIR $MYSQLD_DATADIR DATADIR $START_PAGE_SIZE PAGE_SIZE $LOG_CAPACITY LOG_CAPACITY
80 #--replace_regex /\.dll/.so/
81 --source include/start_mysqld_no_echo.inc
82
83 --replace_regex /\.dll/.so/
84 --error ER_UDF_EXISTS
85 eval INSTALL PLUGIN keyring_file SONAME '$KEYRING_PLUGIN';
86
87 SET GLOBAL innodb_undo_log_encrypt = ON;
88
89 CREATE TABLE tab1(c1 INT, c2 VARCHAR(30));
90 START TRANSACTION;
91 INSERT INTO tab1 VALUES (100,REPEAT('a',5)),(200,REPEAT('b',5));
92 SELECT * FROM tab1;
93 COMMIT;
94 SET GLOBAL innodb_undo_log_encrypt = OFF;
95 START TRANSACTION;
96 INSERT INTO tab1 VALUES (300,REPEAT('a',5)),(400,REPEAT('b',5));
97 COMMIT;
98 SELECT * FROM tab1;
99
100 --disable_warnings
101 UNINSTALL PLUGIN keyring_file;
102 --enable_warnings
103 # Cleanup
104 DROP TABLE tab1;
105
106 --source include/shutdown_mysqld.inc
107 # Search for particular string to confirm the encryption metadata is
108 # stored.
109 --sleep 2
110 let SEARCH_FILE= $MYSQLD_UNDO_DATADIR/undo_001;
111 let SEARCH_PATTERN= lCC;
112 --source include/search_pattern.inc
113
114 let SEARCH_FILE= $MYSQLD_UNDO_DATADIR/undo_002;
115 let SEARCH_PATTERN= lCC;
116 --source include/search_pattern.inc
117
118 # restart the server with MTR default
119 --let $restart_parameters=
120 --source include/start_mysqld_no_echo.inc
121 #--source include/restart_mysqld_no_echo.inc
122
123 --remove_file $BOOTSTRAP_SQL
124
125 # Remove residue files
126 --remove_file $MYSQLTEST_VARDIR/tmp/bootstrap.log
127 --remove_file $MYSQLTEST_VARDIR/tmp/bootstrap2.log
128 --remove_file $MYSQL_TMP_DIR/my_key_undo5
129 --force-rmdir $MYSQL_TMP_DIR/datadir
130 --force-rmdir $MYSQL_TMP_DIR/innodb_data_home_dir
131 --force-rmdir $MYSQL_TMP_DIR/innodb_undo_data_dir