Debian Codegraph @

mysql-test/suite/innodb_undo/t/undo_directory.test

raw
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