| 1 |
--echo # |
| 2 |
--echo # Show the affect of using --innodb-undo-directory |
| 3 |
--echo # |
| 4 |
|
| 5 |
let $MYSQLD_BASE_DIR = `select @@basedir`; |
| 6 |
let $INNODB_PAGE_SIZE = `select @@innodb_page_size`; |
| 7 |
|
| 8 |
--echo # Stop the MTR default mysqld since it was started with no --innodb-undo-directory |
| 9 |
--source include/shutdown_mysqld.inc |
| 10 |
|
| 11 |
--echo # |
| 12 |
--echo # Initialize a temporary database that uses a separate undo directory. |
| 13 |
--echo # |
| 14 |
--write_file $MYSQL_TMP_DIR/boot.sql |
| 15 |
CREATE DATABASE test; |
| 16 |
EOF |
| 17 |
|
| 18 |
let $MYSQl_DATA_DIR = $MYSQL_TMP_DIR/data; |
| 19 |
let $MYSQL_UNDO_DIR = $MYSQL_TMP_DIR/undo; |
| 20 |
--mkdir $MYSQL_UNDO_DIR |
| 21 |
|
| 22 |
let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --initialize-insecure --lc_messages_dir=$MYSQL_SHAREDIR --innodb-page-size=$INNODB_PAGE_SIZE --basedir=$MYSQLD_BASE_DIR --datadir=$MYSQL_DATA_DIR --innodb-undo-directory=$MYSQL_UNDO_DIR --init-file=$MYSQL_TMP_DIR/boot.sql --console </dev/null>>$MYSQL_TMP_DIR/bootstrap.log 2>&1; |
| 23 |
--exec $NEW_CMD |
| 24 |
|
| 25 |
--echo # Directory listing of MYSQL_UNDO_DIR |
| 26 |
--list_files $MYSQL_TMP_DIR/undo undo* |
| 27 |
|
| 28 |
--echo # |
| 29 |
--echo # Start the DB server with the temp datadir and undo directory |
| 30 |
--echo # |
| 31 |
# Wait for 300 seconds instead of the default 100 |
| 32 |
--let $wait_counter= 3000 |
| 33 |
--replace_result $MYSQL_DATA_DIR MYSQL_DATA_DIR $MYSQL_UNDO_DIR MYSQL_UNDO_DIR $INNODB_PAGE_SIZE PAGE_SIZE |
| 34 |
--let $restart_parameters="restart: --datadir=$MYSQL_DATA_DIR --innodb-undo-directory=$MYSQL_UNDO_DIR --innodb-page-size=$INNODB_PAGE_SIZE" |
| 35 |
--source include/start_mysqld.inc |
| 36 |
|
| 37 |
--echo # |
| 38 |
--echo # Create 2 undo tablespaces in the undo directory |
| 39 |
--echo # |
| 40 |
CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu'; |
| 41 |
|
| 42 |
--replace_result $MYSQL_UNDO_DIR MYSQL_UNDO_DIR |
| 43 |
eval CREATE UNDO TABLESPACE undo_004 ADD DATAFILE '$MYSQL_UNDO_DIR/undo_004.ibu'; |
| 44 |
|
| 45 |
--echo # |
| 46 |
--echo # The following filename is exactly like the original datafile so this error is caught by MySQL. |
| 47 |
--echo # |
| 48 |
--error ER_TABLESPACE_DUP_FILENAME |
| 49 |
CREATE UNDO TABLESPACE undo_999 ADD DATAFILE 'undo_003.ibu'; |
| 50 |
SHOW WARNINGS; |
| 51 |
|
| 52 |
--echo # |
| 53 |
--echo # The following filename is different from the original datafile so this error is caught by InnoDB. |
| 54 |
--echo # |
| 55 |
--replace_result $MYSQL_UNDO_DIR MYSQL_UNDO_DIR |
| 56 |
--error ER_WRONG_FILE_NAME |
| 57 |
eval CREATE UNDO TABLESPACE undo_999 ADD DATAFILE '$MYSQL_UNDO_DIR/undo_003.ibu'; |
| 58 |
--replace_result $MYSQL_UNDO_DIR MYSQL_UNDO_DIR |
| 59 |
SHOW WARNINGS; |
| 60 |
|
| 61 |
--echo # |
| 62 |
--echo # The following filename is different from the original datafile so this error is caught by InnoDB. |
| 63 |
--echo # |
| 64 |
--error ER_WRONG_FILE_NAME |
| 65 |
CREATE UNDO TABLESPACE undo_999 ADD DATAFILE 'undo_004.ibu'; |
| 66 |
SHOW WARNINGS; |
| 67 |
|
| 68 |
--echo # |
| 69 |
--echo # The following filename is exactly like the original datafile so this error is caught by MySQL. |
| 70 |
--echo # |
| 71 |
--replace_result $MYSQL_UNDO_DIR MYSQL_UNDO_DIR |
| 72 |
--error ER_TABLESPACE_DUP_FILENAME |
| 73 |
eval CREATE UNDO TABLESPACE undo_999 ADD DATAFILE '$MYSQL_UNDO_DIR/undo_004.ibu'; |
| 74 |
SHOW WARNINGS; |
| 75 |
|
| 76 |
--list_files $MYSQL_TMP_DIR/undo undo* |
| 77 |
|
| 78 |
--echo # |
| 79 |
--echo # Cleanup |
| 80 |
--echo # |
| 81 |
--let $restart_parameters= restart: |
| 82 |
--source include/restart_mysqld.inc |
| 83 |
|
| 84 |
--force-rmdir $MYSQL_UNDO_DIR |
| 85 |
--force-rmdir $MYSQL_DATA_DIR |
| 86 |
--remove_file $MYSQL_TMP_DIR/boot.sql |