Debian Codegraph @

mysql-test/suite/clone/r/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 GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO 'user_clone'@'localhost';
21 # Connection without BACKUP privilege
22 SELECT user();
23 user()
24 user_clone@localhost
25 USE testdb_clone;
26 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 char(64));
27 INSERT INTO t1 VALUES(10, 'clone row 1');
28 INSERT INTO t1 VALUES(20, 'clone row 2');
29 INSERT INTO t1 VALUES(30, 'clone row 3');
30 SELECT * from t1 ORDER BY col1;
31 col1 col2
32 10 clone row 1
33 20 clone row 2
34 30 clone row 3
35 SET GLOBAL clone_autotune_concurrency = OFF;
36 SET GLOBAL clone_max_concurrency = 8;
37 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
38 ERROR 42000: Access denied; you need (at least one of) the BACKUP_ADMIN privilege(s) for this operation
39 select ID, STATE, ERROR_NO from performance_schema.clone_status;
40 ID STATE ERROR_NO
41 select ID, STAGE, STATE from performance_schema.clone_progress;
42 ID STAGE STATE
43 DROP TABLE t1;
44 # Grant backup privilege to clone user
45 GRANT BACKUP_ADMIN on *.* to 'user_clone'@'localhost';
46 SELECT USER, HOST, PRIV FROM mysql.global_grants
47 WHERE USER = 'user_clone' ORDER BY PRIV;
48 USER HOST PRIV
49 user_clone localhost BACKUP_ADMIN
50 user_clone localhost SYSTEM_VARIABLES_ADMIN
51 SET GLOBAL clone_autotune_concurrency = OFF;
52 SET GLOBAL clone_max_concurrency = 8;
53 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
54 select ID, STATE, ERROR_NO from performance_schema.clone_status;
55 ID STATE ERROR_NO
56 1 Completed 0
57 select ID, STAGE, STATE from performance_schema.clone_progress;
58 ID STAGE STATE
59 1 DROP DATA Completed
60 1 FILE COPY Completed
61 1 PAGE COPY Completed
62 1 REDO COPY Completed
63 1 FILE SYNC Completed
64 1 RESTART Not Started
65 1 RECOVERY Not Started
66 DROP SCHEMA testdb_clone;
67 DROP USER 'user_clone'@'localhost';
68 # 1A. Genaral Tablespace with absolute path
69 CREATE TABLESPACE tbs1 ADD DATAFILE 'MYSQL_TMP_DIR/tbs1_data1.ibd';
70 CREATE TABLE t2(col1 INT PRIMARY KEY) TABLESPACE = tbs1;
71 SET GLOBAL clone_autotune_concurrency = OFF;
72 SET GLOBAL clone_max_concurrency = 8;
73 CLONE LOCAL DATA DIRECTORY = 'MYSQL_TMP_DIR/data_new';
74 ERROR HY000: File 'MYSQL_TMP_DIR/tbs1_data1.ibd' already exists
75 select ID, STATE, ERROR_NO from performance_schema.clone_status;
76 ID STATE ERROR_NO
77 1 Failed 1086
78 select ID, STAGE, STATE from performance_schema.clone_progress;
79 ID STAGE STATE
80 1 DROP DATA Completed
81 1 FILE COPY Failed
82 1 PAGE COPY Not Started
83 1 REDO COPY Not Started
84 1 FILE SYNC Not Started
85 1 RESTART Not Started
86 1 RECOVERY Not Started
87 DROP TABLE t2;
88 DROP TABLESPACE tbs1;
89 UNINSTALL PLUGIN clone;
90 # 2. Encrypted Table
91 # restart: --datadir=ENCRYPT_DATADIR --early-plugin-load=keyring_file=KEYRING_PLUGIN --keyring_file_data=MYSQL_TMP_DIR/mysecret_keyring
92 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
93 CREATE TABLE t1 (col1 INT PRIMARY KEY) ENCRYPTION="Y";
94 SET GLOBAL clone_autotune_concurrency = OFF;
95 SET GLOBAL clone_max_concurrency = 8;
96 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
97 select ID, STATE, ERROR_NO from performance_schema.clone_status;
98 ID STATE ERROR_NO
99 1 Completed 0
100 select ID, STAGE, STATE from performance_schema.clone_progress;
101 ID STAGE STATE
102 1 DROP DATA Completed
103 1 FILE COPY Completed
104 1 PAGE COPY Completed
105 1 REDO COPY Completed
106 1 FILE SYNC Completed
107 1 RESTART Not Started
108 1 RECOVERY Not Started
109 DROP TABLE t1;
110 # 2A. Enable Redo Encryption
111 SET GLOBAL innodb_redo_log_encrypt = ON;
112 SELECT @@global.innodb_redo_log_encrypt ;
113 @@global.innodb_redo_log_encrypt
114 1
115 SELECT @@global.innodb_undo_log_encrypt ;
116 @@global.innodb_undo_log_encrypt
117 0
118 SET GLOBAL clone_autotune_concurrency = OFF;
119 SET GLOBAL clone_max_concurrency = 8;
120 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
121 select ID, STATE, ERROR_NO from performance_schema.clone_status;
122 ID STATE ERROR_NO
123 1 Completed 0
124 select ID, STAGE, STATE from performance_schema.clone_progress;
125 ID STAGE STATE
126 1 DROP DATA Completed
127 1 FILE COPY Completed
128 1 PAGE COPY Completed
129 1 REDO COPY Completed
130 1 FILE SYNC Completed
131 1 RESTART Not Started
132 1 RECOVERY Not Started
133 SET GLOBAL innodb_redo_log_encrypt = OFF;
134 # 2B. Enable Undo Encryption
135 SET GLOBAL innodb_undo_log_encrypt = ON;
136 SELECT @@global.innodb_redo_log_encrypt ;
137 @@global.innodb_redo_log_encrypt
138 0
139 SELECT @@global.innodb_undo_log_encrypt ;
140 @@global.innodb_undo_log_encrypt
141 1
142 SET GLOBAL clone_autotune_concurrency = OFF;
143 SET GLOBAL clone_max_concurrency = 8;
144 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
145 select ID, STATE, ERROR_NO from performance_schema.clone_status;
146 ID STATE ERROR_NO
147 1 Completed 0
148 select ID, STAGE, STATE from performance_schema.clone_progress;
149 ID STAGE STATE
150 1 DROP DATA Completed
151 1 FILE COPY Completed
152 1 PAGE COPY Completed
153 1 REDO COPY Completed
154 1 FILE SYNC Completed
155 1 RESTART Not Started
156 1 RECOVERY Not Started
157 SET GLOBAL innodb_undo_log_encrypt = OFF;
158 # 3. Enable sql_require_primary_key
159 UNINSTALL PLUGIN clone;
160 SELECT @@sql_require_primary_key into @saved_sql_require_primary_key;
161 SET sql_require_primary_key = OFF;
162 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
163 UNINSTALL PLUGIN clone;
164 SET sql_require_primary_key = ON;
165 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
166 SET global sql_require_primary_key = @saved_sql_require_primary_key;
167 #Cleanup
168 UNINSTALL PLUGIN clone;
169 UNINSTALL PLUGIN keyring_file;
170 # restart:
171 DROP TABLE t1;