| 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; |