1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
|
--echo ########################################################################
--echo # ALTER TABLESPACE : Encrypted => Unencrypted #
--echo ########################################################################
--echo # Set process to crash at page 10
SET SESSION debug= '+d,alter_encrypt_tablespace_page_10';
--let $PLUGIN_DIR = `select @@plugin_dir`
SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
--echo # Unencrypt the tablespace. It will cause crash.
--source include/expect_crash.inc
--error 0,CR_SERVER_LOST,CR_SERVER_GONE_ERROR,ER_INTERNAL_ERROR
ALTER TABLESPACE encrypt_ts ENCRYPTION='N';
--echo # RESTART $rc : WITH KEYRING PLUGIN after crash and cause resume operation
--echo # to crash $crash_point_desc
let $NEW_CMD = $MYSQLD_CMD --plugin-dir=$PLUGIN_DIR --log-error=$MYSQLTEST_VARDIR/log/my_restart.err --datadir=$MYSQLD_DATADIR --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT --debug=+d,$crash_point;
--error 1,2,42,137
--exec $NEW_CMD
--inc $rc
# Following query should fail as server crashed during restart
--error CR_SERVER_GONE_ERROR,CR_SERVER_LOST
SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
--echo # Search the pattern in error log
--source $MYSQLTEST_VARDIR/tmp/unencryption_error_log.inc
--echo # RESTART $rc : Normal. In this restart resume operation should finish successfully
let $restart_parameters = restart: --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT --log-error=$MYSQLTEST_VARDIR/log/my_restart.err;
--source include/start_mysqld_no_echo.inc
--inc $rc
--echo # Wait for Encryption processing to finish in background thread
let $wait_condition = SELECT ENCRYPTION = 'N'
FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
WHERE NAME='encrypt_ts';
--source include/wait_condition.inc
--echo # Search the pattern in error log
--source $MYSQLTEST_VARDIR/tmp/unencryption_error_log.inc
--echo # RESTART $rc : WITHOUT KEYRING PLUGIN
let $restart_parameters = restart:;
--source include/restart_mysqld_no_echo.inc
--inc $rc
SELECT NAME, ENCRYPTION FROM INFORMATION_SCHEMA.INNODB_TABLESPACES WHERE NAME='encrypt_ts';
# We should be able to read t1 records even without keyring plugin as it should
# be unencrypted now.
SELECT * FROM t1 LIMIT 10;
|
