Debian Codegraph @

mysql-test/suite/clone/t/error_ddl_lock.test

raw
1 # Test clone error with concurrent DDL
2 --source include/have_debug_sync.inc
3 --source include/count_sessions.inc
4
5 --disable_query_log
6 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is disabled. All data could be lost in case of a server crash");
7 call mtr.add_suppression("\\[Warning\\] .*MY-\\d+.* InnoDB redo logging is enabled. Data is now safe and can be recovered in case of a server crash.");
8 --enable_query_log
9
10 connect (con1,localhost,root,,);
11 --echo # In connection CON1
12
13 --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
14 --let $CLONE_DATADIR2 = $MYSQL_TMP_DIR/data_new2
15 --let $MYSQLD_DATADIR= `select @@datadir;`
16
17 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
18 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
19 SHOW VARIABLES LIKE 'clone_ddl_timeout';
20 SHOW VARIABLES LIKE 'clone_block_ddl';
21
22 --echo # Set backup lock timeout to 1 sec
23 SET GLOBAL clone_block_ddl = true;
24 SET GLOBAL clone_ddl_timeout = 1;
25
26 SHOW VARIABLES LIKE 'clone_block_ddl';
27 SHOW VARIABLES LIKE 'clone_ddl_timeout';
28 SHOW VARIABLES LIKE "lock_wait_timeout";
29
30 connection default;
31 --echo # In connection DEFAULT
32
33 --echo # 1A. Clone while CREATE TABLE in progress
34 --let $ddl_text = CREATE TABLE t1 (col1 INT PRIMARY KEY)
35 --source ../include/ddl_lock_clone_wait.inc
36 SHOW CREATE TABLE t1;
37
38 --echo # 1B. CREATE TABLE while clone in progress
39 --let $ddl_text = CREATE TABLE t2 (col1 INT PRIMARY KEY)
40 --source ../include/ddl_lock_ddl_wait.inc
41
42 --echo # 1C. ALTER INSTANCE while clone in progress
43 --let $ddl_text = ALTER INSTANCE DISABLE INNODB REDO_LOG
44 --source ../include/ddl_lock_ddl_wait.inc
45 SHOW STATUS LIKE 'innodb_redo_log_enabled';
46
47 --echo # 1C. Clone while ALTER INSTANCE in progress
48 --let $ddl_text = ALTER INSTANCE DISABLE INNODB REDO_LOG
49 --source ../include/ddl_lock_clone_wait.inc
50 SHOW STATUS LIKE 'innodb_redo_log_enabled';
51 ALTER INSTANCE ENABLE INNODB REDO_LOG;
52
53 --echo # 2A. Clone while ALTER TABLE ADD COLUMN [COPY] in progress
54 INSERT INTO t1 values(10), (20), (30);
55 SELECT * FROM t1 ORDER BY col1;
56 --let $ddl_text = ALTER TABLE t1 ADD COLUMN col2 int, ALGORITHM=COPY
57 --source ../include/ddl_lock_clone_wait.inc
58 SHOW CREATE TABLE t1;
59 SELECT * FROM t1 ORDER BY col1;
60 UPDATE t1 SET col2 = col1 + 1000;
61
62 --echo # 2B. ALTER TABLE ADD COLUMN [COPY] while clone in progress
63 --let $ddl_text = ALTER TABLE t1 ADD COLUMN col3 int, ALGORITHM=COPY
64 --source ../include/ddl_lock_ddl_wait.inc
65
66 --echo # 2C. Clone while ALTER TABLE ADD COLUMN [INPLACE] in progress
67 SELECT * FROM t1 ORDER BY col1;
68 --let $ddl_text = ALTER TABLE t1 ADD COLUMN col3 int, ALGORITHM=INPLACE
69 --source ../include/ddl_lock_clone_wait.inc
70 SHOW CREATE TABLE t1;
71 SELECT * FROM t1 ORDER BY col1;
72 UPDATE t1 SET col3 = col2 + 1000;
73
74 --echo # 2D. ALTER TABLE ADD COLUMN [INPLACE] while clone in progress
75 --let $ddl_text = ALTER TABLE t1 ADD COLUMN col4 int, ALGORITHM=INPLACE
76 --source ../include/ddl_lock_ddl_wait.inc
77
78 --echo # 3A. Clone while ADD INDEX [COPY] in progress
79 SHOW CREATE TABLE t1;
80 --let $ddl_text = ALTER TABLE t1 ADD INDEX col2_idx(col2), ALGORITHM=COPY
81 --source ../include/ddl_lock_clone_wait.inc
82 SHOW CREATE TABLE t1;
83
84 --echo # 3B. ADD INDEX [COPY] while clone in progress
85 --let $ddl_text = ALTER TABLE t1 ADD INDEX col3_idx(col3), ALGORITHM=COPY
86 --source ../include/ddl_lock_ddl_wait.inc
87
88 --echo # 3C. Clone while ADD INDEX [INPLACE] in progress
89 SHOW CREATE TABLE t1;
90 --let $ddl_text = ALTER TABLE t1 ADD INDEX col3_idx(col3), ALGORITHM=INPLACE
91 --source ../include/ddl_lock_clone_wait.inc
92 SHOW CREATE TABLE t1;
93
94 --echo # 3D. ADD INDEX [INPLACE] while clone in progress
95 --let $ddl_text = ALTER TABLE t1 ADD INDEX col1_idx(col1), ALGORITHM=COPY
96 --source ../include/ddl_lock_ddl_wait.inc
97
98 --echo # 4A. DROP INDEX [COPY] while clone in progress
99 --let $ddl_text = ALTER TABLE t1 DROP INDEX col3_idx, ALGORITHM=COPY
100 --source ../include/ddl_lock_ddl_wait.inc
101
102 --echo # 4B. Clone while DROP INDEX [COPY] in progress
103 SHOW CREATE TABLE t1;
104 --let $ddl_text = ALTER TABLE t1 DROP INDEX col3_idx, ALGORITHM=COPY
105 --source ../include/ddl_lock_clone_wait.inc
106 SHOW CREATE TABLE t1;
107
108 --echo # 4C. DROP INDEX [INPLACE] while clone in progress
109 --let $ddl_text = ALTER TABLE t1 DROP INDEX col2_idx, ALGORITHM=INPLACE
110 --source ../include/ddl_lock_ddl_wait.inc
111
112 --echo # 4D. Clone while DROP INDEX [INPLACE] in progress
113 SHOW CREATE TABLE t1;
114 --let $ddl_text = ALTER TABLE t1 DROP INDEX col2_idx, ALGORITHM=INPLACE
115 --source ../include/ddl_lock_clone_wait.inc
116 SHOW CREATE TABLE t1;
117
118 --echo # 5A. TRUNCATE TABLE while clone in progress
119 --let $ddl_text = TRUNCATE TABLE t1
120 --source ../include/ddl_lock_ddl_wait.inc
121
122 --echo # 5B. Clone while TRUNCATE TABLE in progress
123 SELECT * FROM t1 ORDER BY col1;
124 --let $ddl_text = TRUNCATE TABLE t1
125 --source ../include/ddl_lock_clone_wait.inc
126 SELECT * FROM t1 ORDER BY col1;
127
128 --echo # 6A. DROP TABLE while clone in progress
129 --let $ddl_text = DROP TABLE t1
130 --source ../include/ddl_lock_ddl_wait.inc
131 SHOW CREATE TABLE t1;
132
133 --echo # 6B. Clone while DROP TABLE in progress
134 --let $ddl_text = DROP TABLE t1
135 --source ../include/ddl_lock_clone_wait.inc
136
137 --echo #Cleanup
138 disconnect con1;
139 SET DEBUG_SYNC = 'RESET';
140
141 UNINSTALL PLUGIN clone;
142 --source include/wait_until_count_sessions.inc