Debian Codegraph @

mysql-test/suite/clone/r/remote_error_features.result

raw
1 # restart:--innodb-directories=MYSQL_TMP_DIR
2 # create bootstrap file
3 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
4 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64));
5 INSERT INTO t1 VALUES(10, 'clone row 1');
6 INSERT INTO t1 VALUES(20, 'clone row 2');
7 INSERT INTO t1 VALUES(30, 'clone row 3');
8 # 1. Check Privilege
9 CREATE SCHEMA testdb_clone;
10 CREATE USER 'user_clone'@'localhost' IDENTIFIED BY '123';
11 GRANT ALL ON testdb_clone.* TO 'user_clone'@'localhost';
12 GRANT SELECT ON performance_schema.* to 'user_clone'@'localhost';
13 SELECT USER, HOST, PRIV FROM mysql.global_grants
14 WHERE USER = 'user_clone' ORDER BY PRIV;
15 USER HOST PRIV
16 # Connection without SYSTEM_VARIABLES_ADMIN privilege
17 SELECT user();
18 user()
19 user_clone@localhost
20 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
21 ERROR 42000: Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation
22 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO 'user_clone'@'localhost';
23 # Connection without BACKUP privilege
24 SELECT user();
25 user()
26 user_clone@localhost
27 USE testdb_clone;
28 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64));
29 INSERT INTO t1 VALUES(10, 'clone row 1');
30 INSERT INTO t1 VALUES(20, 'clone row 2');
31 INSERT INTO t1 VALUES(30, 'clone row 3');
32 SELECT * from t1 ORDER BY col1;
33 col1 col2
34 10 clone row 1
35 20 clone row 2
36 30 clone row 3
37 SET GLOBAL clone_autotune_concurrency = OFF;
38 SET GLOBAL clone_max_concurrency = 8;
39 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
40 ERROR 42000: Access denied; you need (at least one of) the BACKUP_ADMIN privilege(s) for this operation
41 select ID, STATE, ERROR_NO from performance_schema.clone_status;
42 ID STATE ERROR_NO
43 select ID, STAGE, STATE from performance_schema.clone_progress;
44 ID STAGE STATE
45 DROP TABLE t1;
46 # Grant backup privilege to clone user
47 GRANT BACKUP_ADMIN on *.* to 'user_clone'@'localhost';
48 SELECT USER, HOST, PRIV FROM mysql.global_grants
49 WHERE USER = 'user_clone' ORDER BY PRIV;
50 USER HOST PRIV
51 user_clone localhost BACKUP_ADMIN
52 user_clone localhost SYSTEM_VARIABLES_ADMIN
53 SET GLOBAL clone_autotune_concurrency = OFF;
54 SET GLOBAL clone_max_concurrency = 8;
55 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
56 ERROR HY000: Clone system configuration: HOST:PORT is not found in clone_valid_donor_list:
57 select ID, STATE, ERROR_NO from performance_schema.clone_status;
58 ID STATE ERROR_NO
59 select ID, STAGE, STATE from performance_schema.clone_progress;
60 ID STAGE STATE
61 # Valgrind failures for Bug 29717909 MEMORY LIFETIME OF VARIABLES BETWEEN CHECK AND UPDATE INCORRECTLY MANAGED
62 select @@clone_valid_donor_list;
63 @@clone_valid_donor_list
64 NULL
65 set @blah = '127.0.0.1:8976';
66 SET GLOBAL clone_valid_donor_list = @blah;
67 select @@clone_valid_donor_list;
68 @@clone_valid_donor_list
69 127.0.0.1:8976
70 SET GLOBAL clone_valid_donor_list = default;
71 select @@clone_valid_donor_list;
72 @@clone_valid_donor_list
73 NULL
74 SET GLOBAL clone_valid_donor_list = NULL;
75 select @@clone_valid_donor_list;
76 @@clone_valid_donor_list
77 NULL
78 # Error: space in clone_valid_donor_list
79 SET GLOBAL clone_valid_donor_list = ' HOST:PORT';
80 ERROR HY000: Clone system configuration: Invalid Format. Please enter "<hostname1>:<port1>,..."' with no extra space
81 # Error: Non digit PORT in clone_valid_donor_list
82 SET GLOBAL clone_valid_donor_list = 'HOST:APORT';
83 ERROR HY000: Clone system configuration: Invalid Format. Please enter "<hostname1>:<port1>,..."' with no extra space
84 # Error: Second entry has issue in clone_valid_donor_list
85 SET GLOBAL clone_valid_donor_list = 'HOST:PORT,HOST:APORT';
86 ERROR HY000: Clone system configuration: Invalid Format. Please enter "<hostname1>:<port1>,..."' with no extra space
87 # Successfully Add HOST and PORT to clone_valid_donor_list
88 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
89 SET GLOBAL clone_autotune_concurrency = OFF;
90 SET GLOBAL clone_max_concurrency = 8;
91 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
92 select ID, STATE, ERROR_NO from performance_schema.clone_status;
93 ID STATE ERROR_NO
94 1 Completed 0
95 select ID, STAGE, STATE from performance_schema.clone_progress;
96 ID STAGE STATE
97 1 DROP DATA Completed
98 1 FILE COPY Completed
99 1 PAGE COPY Completed
100 1 REDO COPY Completed
101 1 FILE SYNC Completed
102 1 RESTART Not Started
103 1 RECOVERY Not Started
104 DROP SCHEMA testdb_clone;
105 DROP USER 'user_clone'@'localhost';
106 # 1A. Genaral Tablespace with absolute path
107 CREATE TABLESPACE tbs1 ADD DATAFILE 'MYSQL_TMP_DIR/tbs1_data1.ibd';
108 CREATE TABLE t2(col1 INT PRIMARY KEY) TABLESPACE = tbs1;
109 SET GLOBAL clone_autotune_concurrency = OFF;
110 SET GLOBAL clone_max_concurrency = 8;
111 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
112 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'MYSQL_TMP_DIR/data_new';
113 ERROR HY000: File 'MYSQL_TMP_DIR/tbs1_data1.ibd' already exists
114 select ID, STATE, ERROR_NO from performance_schema.clone_status;
115 ID STATE ERROR_NO
116 1 Failed 1086
117 select ID, STAGE, STATE from performance_schema.clone_progress;
118 ID STAGE STATE
119 1 DROP DATA Completed
120 1 FILE COPY Failed
121 1 PAGE COPY Not Started
122 1 REDO COPY Not Started
123 1 FILE SYNC Not Started
124 1 RESTART Not Started
125 1 RECOVERY Not Started
126 DROP TABLE t2;
127 DROP TABLESPACE tbs1;
128 UNINSTALL PLUGIN clone;
129 # 2. Encrypted Table
130 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
131 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
132 CREATE TABLE t1 (col1 INT PRIMARY KEY) ENCRYPTION="Y";
133 SET GLOBAL clone_autotune_concurrency = OFF;
134 SET GLOBAL clone_max_concurrency = 8;
135 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
136 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR' REQUIRE NO SSL;
137 ERROR HY000: Clone Donor Error: 3872 : Clone needs SSL connection for encrypted table..
138 select ID, STATE, ERROR_NO from performance_schema.clone_status;
139 ID STATE ERROR_NO
140 1 Failed 3862
141 select ID, STAGE, STATE from performance_schema.clone_progress;
142 ID STAGE STATE
143 1 DROP DATA Completed
144 1 FILE COPY Failed
145 1 PAGE COPY Not Started
146 1 REDO COPY Not Started
147 1 FILE SYNC Not Started
148 1 RESTART Not Started
149 1 RECOVERY Not Started
150 DROP TABLE t1;
151 # 2A. Enable Redo Encryption
152 SET GLOBAL innodb_redo_log_encrypt = ON;
153 SELECT @@global.innodb_redo_log_encrypt ;
154 @@global.innodb_redo_log_encrypt
155 1
156 SELECT @@global.innodb_undo_log_encrypt ;
157 @@global.innodb_undo_log_encrypt
158 0
159 SET GLOBAL clone_autotune_concurrency = OFF;
160 SET GLOBAL clone_max_concurrency = 8;
161 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
162 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR' REQUIRE NO SSL;
163 ERROR HY000: Clone Donor Error: 3872 : Clone needs SSL connection for encrypted table..
164 select ID, STATE, ERROR_NO from performance_schema.clone_status;
165 ID STATE ERROR_NO
166 1 Failed 3862
167 select ID, STAGE, STATE from performance_schema.clone_progress;
168 ID STAGE STATE
169 1 DROP DATA Completed
170 1 FILE COPY Failed
171 1 PAGE COPY Not Started
172 1 REDO COPY Not Started
173 1 FILE SYNC Not Started
174 1 RESTART Not Started
175 1 RECOVERY Not Started
176 SET GLOBAL innodb_redo_log_encrypt = OFF;
177 # 2B. Enable Undo Encryption
178 SET GLOBAL innodb_undo_log_encrypt = ON;
179 SELECT @@global.innodb_redo_log_encrypt ;
180 @@global.innodb_redo_log_encrypt
181 0
182 SELECT @@global.innodb_undo_log_encrypt ;
183 @@global.innodb_undo_log_encrypt
184 1
185 SET GLOBAL clone_autotune_concurrency = OFF;
186 SET GLOBAL clone_max_concurrency = 8;
187 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
188 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR' REQUIRE NO SSL;
189 ERROR HY000: Clone Donor Error: 3872 : Clone needs SSL connection for encrypted table..
190 select ID, STATE, ERROR_NO from performance_schema.clone_status;
191 ID STATE ERROR_NO
192 1 Failed 3862
193 select ID, STAGE, STATE from performance_schema.clone_progress;
194 ID STAGE STATE
195 1 DROP DATA Completed
196 1 FILE COPY Failed
197 1 PAGE COPY Not Started
198 1 REDO COPY Not Started
199 1 FILE SYNC Not Started
200 1 RESTART Not Started
201 1 RECOVERY Not Started
202 SET GLOBAL innodb_undo_log_encrypt = OFF;
203 # 3. Enable sql_require_primary_key
204 UNINSTALL PLUGIN clone;
205 SELECT @@sql_require_primary_key into @saved_sql_require_primary_key;
206 SET sql_require_primary_key = OFF;
207 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
208 UNINSTALL PLUGIN clone;
209 SET sql_require_primary_key = ON;
210 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
211 SET global sql_require_primary_key = @saved_sql_require_primary_key;
212 #Cleanup
213 UNINSTALL PLUGIN clone;
214 UNINSTALL PLUGIN keyring_file;
215 # restart:
216 DROP TABLE t1;