Debian Codegraph @

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

raw
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