Debian Codegraph @

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

raw
1 ##########################################################################
2 # Test script to test RECOVERY of a crashed server in older release with
3 # table having INSTANT ADD columns.
4 ##########################################################################
5
6 --source include/not_valgrind.inc
7 --source include/have_lowercase0.inc
8
9 # ------------------------------------------------------------
10 # Tables created on earlier version with following
11 # ------------------------------------------------------------
12 # CREATE TABLE t1_redundant(id INT PRIMARY KEY, c1 CHAR(10), c2 CHAR(10)) ROW_FORMAT=REDUNDANT;
13 # INSERT INTO t1_redundant VALUES (1, "r1c1", "r1c2");
14 # Alter table t1_redundant add column c3 char(10), algorithm=instant;
15 # INSERT INTO t1_redundant VALUES (2, "r2c1", "r2c2", "r2c3");
16 #
17 # CREATE TABLE t1_compact(id INT PRIMARY KEY, c1 CHAR(10), c2 CHAR(10)) ROW_FORMAT=COMPACT;
18 # INSERT INTO t1_compact VALUES (1, "r1c1", "r1c2");
19 # Alter table t1_compact add column c3 char(10), algorithm=instant;
20 # INSERT INTO t1_compact VALUES (2, "r2c1", "r2c2", "r2c3");
21 #
22 # CREATE TABLE t1_dynamic(id INT PRIMARY KEY, c1 CHAR(10), c2 CHAR(10)) ROW_FORMAT=DYNAMIC;
23 # INSERT INTO t1_dynamic VALUES (1, "r1c1", "r1c2");
24 # Alter table t1_dynamic add column c3 char(10), algorithm=instant;
25 # INSERT INTO t1_dynamic VALUES (2, "r2c1", "r2c2", "r2c3");
26 #
27 # <STOP FLUSH>
28 #
29 # UPDATE t1_redundant SET c1="r0c0";
30 # UPDATE t1_redundant SET c3="r1c3" WHERE id=1;
31 # INSERT INTO t1_redundant VALUES (3, "r3c1", "r3c2", "r3c3");
32 # DELETE FROM t1_redundant WHERE id=2;
33 #
34 # UPDATE t1_compact SET c1="r0c0";
35 # UPDATE t1_compact SET c3="r1c3" WHERE id=1;
36 # INSERT INTO t1_compact VALUES (3, "r3c1", "r3c2", "r3c3");
37 # DELETE FROM t1_compact WHERE id=2;
38 #
39 # UPDATE t1_dynamic SET c1="r0c0";
40 # UPDATE t1_dynamic SET c3="r1c3" WHERE id=1;
41 # INSERT INTO t1_dynamic VALUES (3, "r3c1", "r3c2", "r3c3");
42 # DELETE FROM t1_dynamic WHERE id=2;
43 # ------------------------------------------------------------
44
45 --echo #########
46 --echo # SETUP #
47 --echo #########
48
49 --echo # Stop the running the server
50 --source include/shutdown_mysqld.inc
51
52 --echo # Copy and unzip the datadir.
53 --copy_file $MYSQLTEST_VARDIR/std_data/instant_ddl/crashed_datadir.zip $MYSQL_TMP_DIR/crashed_datadir.zip
54 --file_exists $MYSQL_TMP_DIR/crashed_datadir.zip
55 --exec unzip -qo $MYSQL_TMP_DIR/crashed_datadir.zip -d $MYSQL_TMP_DIR
56 let $DATADIR = $MYSQL_TMP_DIR/data;
57
58 --echo # Restart the server against the unzipped datadir
59 --replace_result $DATADIR DATADIR
60 --let $restart_parameters = restart: --datadir=$DATADIR --innodb-page-size=16k
61 --let $wait_counter=3000
62 --source include/start_mysqld.inc
63
64 --echo ##############################################
65 --echo # Test instant ADD COLUMN for REDUNDANT format
66 --echo ##############################################
67 let $row_format = redundant;
68 --source suite/innodb/include/instant_ddl_recovery_old.inc
69
70 --echo ############################################
71 --echo # Test instant ADD COLUMN for DYNAMIC format
72 --echo ############################################
73 let $row_format = dynamic;
74 --source suite/innodb/include/instant_ddl_recovery_old.inc
75
76 --echo ############################################
77 --echo # Test instant ADD COLUMN for COMPACT format
78 --echo ############################################
79 let $row_format = compact;
80 --source suite/innodb/include/instant_ddl_recovery_old.inc
81
82 --echo ###########
83 --echo # CLEANUP #
84 --echo ###########
85
86 --echo # Shutdown server
87 --source include/shutdown_mysqld.inc
88
89 --echo # Remove copied files
90 --file_exists $MYSQL_TMP_DIR/crashed_datadir.zip
91 --force-rmdir $MYSQL_TMP_DIR/data
92 --remove_file $MYSQL_TMP_DIR/crashed_datadir.zip
93
94 --echo # Restarting server to restore server state
95 let $restart_parameters =;
96 --source include/start_mysqld.inc