Debian Codegraph @

mysql-test/suite/innodb_undo/r/undo_directory.result

raw
1 #
2 # Show the affect of using --innodb-undo-directory
3 #
4 # Stop the MTR default mysqld since it was started with no --innodb-undo-directory
5 #
6 # Initialize a temporary database that uses a separate undo directory.
7 #
8 # Directory listing of MYSQL_UNDO_DIR
9 undo_001
10 undo_002
11 #
12 # Start the DB server with the temp datadir and undo directory
13 #
14 # restart: --datadir=MYSQL_DATA_DIR --innodb-undo-directory=MYSQL_UNDO_DIR --innodb-page-size=PAGE_SIZE
15 #
16 # Create 2 undo tablespaces in the undo directory
17 #
18 CREATE UNDO TABLESPACE undo_003 ADD DATAFILE 'undo_003.ibu';
19 CREATE UNDO TABLESPACE undo_004 ADD DATAFILE 'MYSQL_UNDO_DIR/undo_004.ibu';
20 #
21 # The following filename is exactly like the original datafile so this error is caught by MySQL.
22 #
23 CREATE UNDO TABLESPACE undo_999 ADD DATAFILE 'undo_003.ibu';
24 ERROR HY000: Duplicate file name for tablespace 'undo_999'
25 SHOW WARNINGS;
26 Level Code Message
27 Error 3606 Duplicate file name for tablespace 'undo_999'
28 #
29 # The following filename is different from the original datafile so this error is caught by InnoDB.
30 #
31 CREATE UNDO TABLESPACE undo_999 ADD DATAFILE 'MYSQL_UNDO_DIR/undo_003.ibu';
32 ERROR HY000: The ADD DATAFILE filepath already exists.
33 SHOW WARNINGS;
34 Level Code Message
35 Error 3121 The ADD DATAFILE filepath already exists.
36 Error 1528 Failed to create UNDO TABLESPACE undo_999
37 Error 3121 Incorrect File Name 'MYSQL_UNDO_DIR/undo_003.ibu'.
38 #
39 # The following filename is different from the original datafile so this error is caught by InnoDB.
40 #
41 CREATE UNDO TABLESPACE undo_999 ADD DATAFILE 'undo_004.ibu';
42 ERROR HY000: The ADD DATAFILE filepath already exists.
43 SHOW WARNINGS;
44 Level Code Message
45 Error 3121 The ADD DATAFILE filepath already exists.
46 Error 1528 Failed to create UNDO TABLESPACE undo_999
47 Error 3121 Incorrect File Name 'undo_004.ibu'.
48 #
49 # The following filename is exactly like the original datafile so this error is caught by MySQL.
50 #
51 CREATE UNDO TABLESPACE undo_999 ADD DATAFILE 'MYSQL_UNDO_DIR/undo_004.ibu';
52 ERROR HY000: Duplicate file name for tablespace 'undo_999'
53 SHOW WARNINGS;
54 Level Code Message
55 Error 3606 Duplicate file name for tablespace 'undo_999'
56 undo_001
57 undo_002
58 undo_003.ibu
59 undo_004.ibu
60 #
61 # Cleanup
62 #
63 # restart: