| 1 |
--echo # |
| 2 |
--echo # bug#30209760 : ASSERTION FAILURE: SRV0START.CC:969:SUCCESS THREAD |
| 3 |
--echo # |
| 4 |
|
| 5 |
--source include/have_debug.inc |
| 6 |
|
| 7 |
--echo ######### |
| 8 |
--echo # SETUP # |
| 9 |
--echo ######### |
| 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 |
--echo # Create path for ibdata* & undo* files |
| 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 |
--echo # create bootstrap file |
| 29 |
let $BOOTSTRAP_SQL=$MYSQL_TMP_DIR/boot.sql; |
| 30 |
write_file $BOOTSTRAP_SQL; |
| 31 |
CREATE DATABASE test; |
| 32 |
EOF |
| 33 |
|
| 34 |
--echo # Stop the MTR default DB server |
| 35 |
--source include/shutdown_mysqld.inc |
| 36 |
|
| 37 |
--echo ######################################################################### |
| 38 |
--echo # INITIALIZE NEW SERVER |
| 39 |
--echo ######################################################################### |
| 40 |
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 --secure-file-priv=""; |
| 41 |
|
| 42 |
--echo # Server should be initialized successfully. |
| 43 |
--exec $NEW_CMD |
| 44 |
|
| 45 |
--echo ######################################################################### |
| 46 |
--echo # RESTART 2 : WITH KEYRING PLUGIN. |
| 47 |
--echo innodb_undo_log_encrypt=ON. |
| 48 |
--echo Crash server before purge thread could start. |
| 49 |
--echo ######################################################################### |
| 50 |
# Restart the server with undo_log_encrypt=ON and make sure it asserts before |
| 51 |
# Purge thread is started (i.e. before master thread could have started to |
| 52 |
# rotate default master key. At this time, |
| 53 |
# - UNDO tablespace would have been encrypted with default master key |
| 54 |
# - Header page for UNDO tablespace wouldn't have been flushed |
| 55 |
# - So encryption information is still in REDO Log. |
| 56 |
let $NEW_CMD = $MYSQLD --innodb_dedicated_server=OFF --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 --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT --innodb_undo_log_encrypt=ON --debug=d,crash_before_purge_thread; |
| 57 |
--error 1,2,42,137 |
| 58 |
--exec $NEW_CMD |
| 59 |
|
| 60 |
--echo ######################################################################### |
| 61 |
--echo # RESTART 3 : WITH KEYRING PLUGIN. |
| 62 |
--echo innodb_undo_log_encrypt=ON. |
| 63 |
--echo Skip rotating default master key in master thread |
| 64 |
--echo ######################################################################### |
| 65 |
# Here server would start and UNDO encryption key would be loaded in-mem |
| 66 |
# successfully after reading them from REDO Log during scan. |
| 67 |
# NOTE: without the fix |
| 68 |
# - the encryption information wouldn't be applied on page 0. |
| 69 |
# - And as we don't allow master thread to rotate default master key, UNDO |
| 70 |
# tablespace encryption information will be lost at next restart. |
| 71 |
let $restart_parameters = restart: --innodb_dedicated_server=OFF --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 --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT --innodb_undo_log_encrypt=ON --debug=d,skip_rotating_default_master_key; |
| 72 |
--source include/start_mysqld_no_echo.inc |
| 73 |
|
| 74 |
--echo ######################################################################### |
| 75 |
--echo # RESTART 4 : WITH KEYRING PLUGIN. |
| 76 |
--echo innodb_undo_log_encrypt=OFF. |
| 77 |
--echo ######################################################################### |
| 78 |
# During this restart, without the fix: |
| 79 |
# - Encryption information will be looked for on page 0. But as it wasn't |
| 80 |
# applied in previous start, it wouldn't be found thus ASSERT will be hit. |
| 81 |
let $restart_parameters = restart: --innodb_dedicated_server=OFF --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 --early-plugin-load=keyring_file=$KEYRING_PLUGIN --loose-keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring $KEYRING_PLUGIN_OPT --innodb_undo_log_encrypt=OFF; |
| 82 |
--source include/restart_mysqld_no_echo.inc |
| 83 |
|
| 84 |
--echo # Shutdown the running server |
| 85 |
SHUTDOWN; |
| 86 |
|
| 87 |
--echo ########### |
| 88 |
--echo # CLEANUP # |
| 89 |
--echo ########### |
| 90 |
--echo # Restart the server with MTR default |
| 91 |
--let $restart_parameters= |
| 92 |
--source include/start_mysqld_no_echo.inc |
| 93 |
#--source include/restart_mysqld_no_echo.inc |
| 94 |
|
| 95 |
# Remove residue files |
| 96 |
--remove_file $BOOTSTRAP_SQL |
| 97 |
--remove_file $MYSQL_TMP_DIR/mysecret_keyring |
| 98 |
--force-rmdir $MYSQL_TMP_DIR/datadir |
| 99 |
--force-rmdir $MYSQL_TMP_DIR/innodb_data_home_dir |
| 100 |
--force-rmdir $MYSQL_TMP_DIR/innodb_undo_data_dir |