Debian Codegraph @

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

raw
1 # Test clone error conditions with incompatible features
2
3 --disable_query_log
4 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
5 LET $restart_parameters = restart:--innodb-directories=$MYSQL_TMP_DIR;
6 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
7 --source include/restart_mysqld.inc
8 --enable_query_log
9
10 --let $CLONE_DATADIR = $MYSQL_TMP_DIR/data_new
11 --let $MYSQLD_DATADIR= `select @@datadir;`
12
13 --let $ENCRYPT_DATADIR = $MYSQL_TMP_DIR/data_encrypt
14 --let $ENCRYPT_ERROR_FILE = $MYSQL_TMP_DIR/boot_encrypt_log
15
16 --let BOOTSTRAP_SQL=$MYSQL_TMP_DIR/boot.sql
17
18 --let $START_PAGE_SIZE= `select @@innodb_page_size`
19
20 --echo # create bootstrap file
21 write_file $BOOTSTRAP_SQL;
22 CREATE DATABASE test DEFAULT CHARACTER SET latin1;
23 EOF
24 --mkdir $ENCRYPT_DATADIR
25
26 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
27 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
28
29 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64));
30
31 INSERT INTO t1 VALUES(10, 'clone row 1');
32 INSERT INTO t1 VALUES(20, 'clone row 2');
33 INSERT INTO t1 VALUES(30, 'clone row 3');
34
35 --echo # 1. Check Privilege
36 --let $skip_donor_config = 1
37 CREATE SCHEMA testdb_clone;
38 CREATE USER 'user_clone'@'localhost' IDENTIFIED BY '123';
39 GRANT ALL ON testdb_clone.* TO 'user_clone'@'localhost';
40 GRANT SELECT ON performance_schema.* to 'user_clone'@'localhost';
41 SELECT USER, HOST, PRIV FROM mysql.global_grants
42 WHERE USER = 'user_clone' ORDER BY PRIV;
43
44 --echo # Connection without SYSTEM_VARIABLES_ADMIN privilege
45 --connect (con1,'localhost','user_clone','123',)
46 SELECT user();
47 if($remote_clone) {
48 --replace_result $HOST HOST $PORT PORT
49 --error ER_SPECIFIC_ACCESS_DENIED_ERROR
50 --eval SET GLOBAL clone_valid_donor_list = '$HOST:$PORT'
51 }
52
53 connection default;
54 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO 'user_clone'@'localhost';
55
56 --echo # Connection without BACKUP privilege
57 connection con1;
58 SELECT user();
59
60 USE testdb_clone;
61
62 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64));
63
64 INSERT INTO t1 VALUES(10, 'clone row 1');
65 INSERT INTO t1 VALUES(20, 'clone row 2');
66 INSERT INTO t1 VALUES(30, 'clone row 3');
67
68 SELECT * from t1 ORDER BY col1;
69
70 --let $clone_err = ER_SPECIFIC_ACCESS_DENIED_ERROR
71 --source ../include/clone_command.inc
72 --let $clone_err = 0
73
74 DROP TABLE t1;
75
76 connection default;
77
78 --echo # Grant backup privilege to clone user
79 GRANT BACKUP_ADMIN on *.* to 'user_clone'@'localhost';
80
81 SELECT USER, HOST, PRIV FROM mysql.global_grants
82 WHERE USER = 'user_clone' ORDER BY PRIV;
83
84 connection con1;
85
86 if($remote_clone) {
87 --let $clone_err = ER_CLONE_SYS_CONFIG
88 --source ../include/clone_command.inc
89 --let $clone_err = 0
90
91 connection default;
92
93 --echo # Valgrind failures for Bug 29717909 MEMORY LIFETIME OF VARIABLES BETWEEN CHECK AND UPDATE INCORRECTLY MANAGED
94 select @@clone_valid_donor_list;
95 set @blah = '127.0.0.1:8976';
96 SET GLOBAL clone_valid_donor_list = @blah;
97 select @@clone_valid_donor_list;
98 SET GLOBAL clone_valid_donor_list = default;
99 select @@clone_valid_donor_list;
100 SET GLOBAL clone_valid_donor_list = NULL;
101 select @@clone_valid_donor_list;
102
103 --echo # Error: space in clone_valid_donor_list
104 --replace_result $HOST HOST $PORT PORT
105 --error ER_CLONE_SYS_CONFIG
106 --eval SET GLOBAL clone_valid_donor_list = ' $HOST:$PORT'
107
108 --echo # Error: Non digit PORT in clone_valid_donor_list
109 --replace_result $HOST HOST $PORT PORT
110 --error ER_CLONE_SYS_CONFIG
111 --eval SET GLOBAL clone_valid_donor_list = '$HOST:A$PORT'
112
113 --echo # Error: Second entry has issue in clone_valid_donor_list
114 --replace_result $HOST HOST $PORT PORT
115 --error ER_CLONE_SYS_CONFIG
116 --eval SET GLOBAL clone_valid_donor_list = '$HOST:$PORT,$HOST:A$PORT'
117 --let $clone_err = 0
118
119 --echo # Successfully Add HOST and PORT to clone_valid_donor_list
120 --replace_result $HOST HOST $PORT PORT
121 --eval SET GLOBAL clone_valid_donor_list = '$HOST:$PORT'
122 connection con1;
123 }
124
125 --source ../include/clone_command.inc
126
127 --disconnect con1
128
129 connection default;
130
131 DROP SCHEMA testdb_clone;
132 DROP USER 'user_clone'@'localhost';
133 --force-rmdir $CLONE_DATADIR
134 --let $skip_donor_config = 0
135
136 --echo # 1A. Genaral Tablespace with absolute path
137
138 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
139 --eval CREATE TABLESPACE tbs1 ADD DATAFILE '$MYSQL_TMP_DIR/tbs1_data1.ibd'
140 CREATE TABLE t2(col1 INT PRIMARY KEY) TABLESPACE = tbs1;
141
142 --replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
143 --let $clone_err = ER_FILE_EXISTS_ERROR
144 --source ../include/clone_command.inc
145 --let $clone_err = 0
146 --force-rmdir $CLONE_DATADIR
147
148 DROP TABLE t2;
149 DROP TABLESPACE tbs1;
150
151 UNINSTALL PLUGIN clone;
152
153 --echo # 2. Encrypted Table
154 --source include/shutdown_mysqld.inc
155 --let clone_require_no_ssl = 1
156
157 --replace_result $MYSQLD MYSQLD $BOOTSTRAP_SQL BOOTSTRAP_SQL $ENCRYPT_DATADIR ENCRYPT_DATADIR $START_PAGE_SIZE PAGE_SIZE $ENCRYPT_ERROR_FILE ENCRYPT_ERROR_FILE
158 --let NEW_CMD = $MYSQLD --no-defaults --innodb_dedicated_server=OFF --initialize-insecure --init-file=$BOOTSTRAP_SQL --innodb_redo_log_capacity=10M --innodb_page_size=$START_PAGE_SIZE --datadir=$ENCRYPT_DATADIR > $ENCRYPT_ERROR_FILE 2>&1
159
160 --exec $NEW_CMD
161
162 --replace_result $KEYRING_PLUGIN KEYRING_PLUGIN $MYSQL_TMP_DIR MYSQL_TMP_DIR $ENCRYPT_DATADIR ENCRYPT_DATADIR
163 --let $restart_parameters=restart: --datadir=$ENCRYPT_DATADIR --early-plugin-load="keyring_file=$KEYRING_PLUGIN" --keyring_file_data=$MYSQL_TMP_DIR/mysecret_keyring
164 --source include/start_mysqld.inc
165
166 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
167 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
168
169 CREATE TABLE t1 (col1 INT PRIMARY KEY) ENCRYPTION="Y";
170
171 --let $clone_remote_err = ER_CLONE_DONOR
172 --source ../include/clone_command.inc
173 --let $clone_remote_err = 0
174
175 DROP TABLE t1;
176 --force-rmdir $CLONE_DATADIR
177
178 --echo # 2A. Enable Redo Encryption
179 --let clone_require_no_ssl = 1
180
181 SET GLOBAL innodb_redo_log_encrypt = ON;
182 SELECT @@global.innodb_redo_log_encrypt ;
183 SELECT @@global.innodb_undo_log_encrypt ;
184
185 --let $clone_remote_err = ER_CLONE_DONOR
186 --source ../include/clone_command.inc
187 --let $clone_remote_err = 0
188
189 SET GLOBAL innodb_redo_log_encrypt = OFF;
190 --force-rmdir $CLONE_DATADIR
191
192 --echo # 2B. Enable Undo Encryption
193
194 SET GLOBAL innodb_undo_log_encrypt = ON;
195 SELECT @@global.innodb_redo_log_encrypt ;
196 SELECT @@global.innodb_undo_log_encrypt ;
197
198 --let $clone_remote_err = ER_CLONE_DONOR
199 --source ../include/clone_command.inc
200 --let $clone_remote_err = 0
201
202 SET GLOBAL innodb_undo_log_encrypt = OFF;
203 --force-rmdir $CLONE_DATADIR
204
205 --echo # 3. Enable sql_require_primary_key
206
207 UNINSTALL PLUGIN clone;
208
209 SELECT @@sql_require_primary_key into @saved_sql_require_primary_key;
210 SET sql_require_primary_key = OFF;
211
212 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
213 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
214
215 UNINSTALL PLUGIN clone;
216
217 SET sql_require_primary_key = ON;
218
219 --replace_result $CLONE_PLUGIN CLONE_PLUGIN
220 --eval INSTALL PLUGIN clone SONAME '$CLONE_PLUGIN'
221
222 SET global sql_require_primary_key = @saved_sql_require_primary_key;
223
224 --echo #Cleanup
225
226 UNINSTALL PLUGIN clone;
227 UNINSTALL PLUGIN keyring_file;
228
229 let $restart_parameters = "restart:";
230 --source include/restart_mysqld.inc
231
232 DROP TABLE t1;
233
234 --force-rmdir $ENCRYPT_DATADIR
235 --remove_file $ENCRYPT_ERROR_FILE
236 --remove_file $BOOTSTRAP_SQL
237 --remove_file $MYSQL_TMP_DIR/mysecret_keyring