Debian Codegraph @

mysql-test/suite/innodb/include/resume_test_unencryption.inc

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