Debian Codegraph @

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

raw
1 # Test clone with concurrent DDL interrupted
2 --source include/have_innodb_max_16k.inc
3 --source include/have_debug_sync.inc
4 --source include/count_sessions.inc
5
6 --source ../include/encrypt_begin.inc
7
8 --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
9
10 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
11 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
12
13 SET GLOBAL innodb_ddl_threads = 1;
14 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
15
16 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
17 ENCRYPTION = 'Y';
18
19 CREATE UNDO TABLESPACE undo_02 ADD DATAFILE 'undo_02.ibu';
20
21 ALTER UNDO TABLESPACE undo_02 SET INACTIVE;
22
23 --let $inactive_undo_space = undo_02
24 --source include/wait_until_undo_space_is_empty.inc
25
26 SET DEBUG_SYNC = 'clone_state_transit_file_copy SIGNAL start_ddl WAIT_FOR resume_clone_file';
27 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_ddl_inplace WAIT_FOR resume_clone_page';
28 --source ../include/clone_command_send.inc
29
30 connect (con1,localhost,root,,);
31 --echo # In connection CON1
32
33 connect (con2,localhost,root,,);
34 --echo # In connection CON2
35
36 --echo # Waiting for clone to reach state transition
37 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
38 --echo # Wait finished
39
40 --echo # 1. CREATE TABLE
41 --let $ddl_stmt = CREATE TABLE t3(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
42 --source ../include/ddl_kill.inc
43
44 --echo # 2A. ALTER TABLE COPY
45 --let $ddl_stmt = ALTER TABLE t1 ADD INDEX col2_idx(col2), ALGORITHM = COPY
46 --source ../include/ddl_kill.inc
47
48 --echo # 2B. ALTER TABLE IN PLACE
49 --let $ddl_stmt = ALTER TABLE t1 ADD INDEX col2_idx(col2), ALGORITHM = INPLACE
50 --source ../include/ddl_kill.inc
51
52 --echo # 3. ALTER TABLE RENAME
53 --let $ddl_stmt = ALTER TABLE t1 RENAME t3
54 --source ../include/ddl_kill.inc
55
56 --echo # 4. TRUNCATE TABLE
57 --let $ddl_stmt = TRUNCATE TABLE t1
58 --source ../include/ddl_kill.inc
59
60 --echo # 5A. ALTER ENABLE Encryption
61 --let $ddl_stmt = ALTER TABLE t1 ENCRYPTION = "Y"
62 --source ../include/ddl_kill.inc
63
64 --echo # 5B. ALTER DISABLE ENCRYPTION
65 --let $ddl_stmt = ALTER TABLE t2 ENCRYPTION = "N"
66 --source ../include/ddl_kill.inc
67
68 --echo # 6. CREATE UNDO TABLESPACE
69 --let $ddl_stmt = CREATE UNDO TABLESPACE undo_01 ADD DATAFILE 'undo_01.ibu'
70 --source ../include/ddl_kill.inc
71
72 --echo # 7A. ENABLE REDO ENCRYPTION
73 --let $ddl_stmt = SET GLOBAL innodb_redo_log_encrypt = ON
74 --source ../include/ddl_kill.inc
75
76 --echo # 7B. ENABLE UNDO ENCRYPTION
77 --let $ddl_stmt = SET GLOBAL innodb_undo_log_encrypt = ON
78 --source ../include/ddl_kill.inc
79
80 SET DEBUG_SYNC = 'now SIGNAL resume_clone_file';
81
82 --echo # Waiting for clone to reach page copy state
83 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_inplace';
84 --echo # Wait finished
85
86 --echo # 8. ALTER TABLE INPLACE during PAGE COPY
87 --let $ddl_stmt = ALTER TABLE t1 ADD INDEX col2_idx(col2), ALGORITHM = INPLACE
88 --source ../include/ddl_kill.inc
89
90 SET DEBUG_SYNC = 'now SIGNAL resume_clone_page';
91
92 ## DROP commands deleted the file and sends notofication
93 ## to clone as post DDL action. By this time the DDL command
94 ## is already committed and KILL must be ignored.
95 --let $no_interrupt = 1
96
97 --echo # 9A. DROP TABLE
98 --let $ddl_stmt = DROP TABLE t1
99 --source ../include/ddl_kill.inc
100
101 --echo # 9B. DROP UNDO TABLESPACE
102 --let $ddl_stmt = DROP UNDO TABLESPACE undo_02
103 --source ../include/ddl_kill.inc
104
105 --let $no_interrupt =
106
107 --connection default
108
109 --echo # In connection default
110 --echo # Waiting for Clone to complete
111 --reap
112 --echo # Wait finished
113
114 --echo # Cleanup
115 DROP TABLE t2;
116
117 --disconnect con1
118 --disconnect con2
119 --source include/wait_until_count_sessions.inc
120
121 --force-rmdir $CLONE_DATADIR
122 SET DEBUG_SYNC = 'RESET';
123
124 --echo # Uninstall clone
125 UNINSTALL PLUGIN clone;
126
127 SET GLOBAL innodb_ddl_threads = default;
128 --source ../include/encrypt_end.inc