Debian Codegraph @

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

raw
1 # 1. PLUGIN not loaded - clone local
2 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
3 ERROR HY000: Plugin 'clone' is not loaded
4 # 1A. PLUGIN not installed - Uninstall plugin
5 UNINSTALL PLUGIN clone;
6 ERROR 42000: PLUGIN clone does not exist
7 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
8 # 1B. PLUGIN already loaded - Install plugin
9 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
10 ERROR HY000: Function 'clone' already exists
11 # 1B-a. Incorrect PORT number for remote clone
12 SET GLOBAL clone_autotune_concurrency = OFF;
13 SET GLOBAL clone_max_concurrency = 8;
14 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
15 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
16 ERROR HY000: Clone Donor Error: Connect failed: 2003 : Can't connect to MySQL server on 'HOST:PORT' (socket errno).
17 select ID, STATE, ERROR_NO from performance_schema.clone_status;
18 ID STATE ERROR_NO
19 1 Failed 3862
20 select ID, STAGE, STATE from performance_schema.clone_progress;
21 ID STAGE STATE
22 # 1B-b. MAX_ALLOWED_PACKET size too low for remote clone
23 SET GLOBAL MAX_ALLOWED_PACKET = 512 * 1024;
24 SET GLOBAL clone_autotune_concurrency = OFF;
25 SET GLOBAL clone_max_concurrency = 8;
26 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
27 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
28 ERROR HY000: Clone Donor Error: 3957 : Clone needs max_allowed_packet value to be 2097152 or more. Current value is 524288.
29 select ID, STATE, ERROR_NO from performance_schema.clone_status;
30 ID STATE ERROR_NO
31 1 Failed 3862
32 select ID, STAGE, STATE from performance_schema.clone_progress;
33 ID STAGE STATE
34 # 1B-c. MAX_ALLOWED_PACKET 2M should pass
35 SET GLOBAL MAX_ALLOWED_PACKET = 2 * 1024 * 1024;
36 SET GLOBAL clone_autotune_concurrency = OFF;
37 SET GLOBAL clone_max_concurrency = 8;
38 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
39 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
40 select ID, STATE, ERROR_NO from performance_schema.clone_status;
41 ID STATE ERROR_NO
42 1 Completed 0
43 select ID, STAGE, STATE from performance_schema.clone_progress;
44 ID STAGE STATE
45 1 DROP DATA Completed
46 1 FILE COPY Completed
47 1 PAGE COPY Completed
48 1 REDO COPY Completed
49 1 FILE SYNC Completed
50 1 RESTART Not Started
51 1 RECOVERY Not Started
52 SET GLOBAL MAX_ALLOWED_PACKET = DEFAULT;
53 #1C. Clone data without error
54 SET GLOBAL clone_autotune_concurrency = OFF;
55 SET GLOBAL clone_max_concurrency = 8;
56 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
57 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
58 select ID, STATE, ERROR_NO from performance_schema.clone_status;
59 ID STATE ERROR_NO
60 1 Completed 0
61 select ID, STAGE, STATE from performance_schema.clone_progress;
62 ID STAGE STATE
63 1 DROP DATA Completed
64 1 FILE COPY Completed
65 1 PAGE COPY Completed
66 1 REDO COPY Completed
67 1 FILE SYNC Completed
68 1 RESTART Not Started
69 1 RECOVERY Not Started
70 # 2A. Incorrect PATH - Relative path
71 SET GLOBAL clone_autotune_concurrency = OFF;
72 SET GLOBAL clone_max_concurrency = 8;
73 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
74 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
75 ERROR HY000: Incorrect path value: 'CLONE_DATADIR'
76 select ID, STATE, ERROR_NO from performance_schema.clone_status;
77 ID STATE ERROR_NO
78 1 Completed 0
79 select ID, STAGE, STATE from performance_schema.clone_progress;
80 ID STAGE STATE
81 1 DROP DATA Completed
82 1 FILE COPY Completed
83 1 PAGE COPY Completed
84 1 REDO COPY Completed
85 1 FILE SYNC Completed
86 1 RESTART Not Started
87 1 RECOVERY Not Started
88 # 2B. Incorrect PATH - Too long
89 SET GLOBAL clone_autotune_concurrency = OFF;
90 SET GLOBAL clone_max_concurrency = 8;
91 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
92 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
93 ERROR HY000: The path specified for DATA DIRECTORY is too long.
94 select ID, STATE, ERROR_NO from performance_schema.clone_status;
95 ID STATE ERROR_NO
96 1 Completed 0
97 select ID, STAGE, STATE from performance_schema.clone_progress;
98 ID STAGE STATE
99 1 DROP DATA Completed
100 1 FILE COPY Completed
101 1 PAGE COPY Completed
102 1 REDO COPY Completed
103 1 FILE SYNC Completed
104 1 RESTART Not Started
105 1 RECOVERY Not Started
106 # 2C. Incorrect PATH - Within data directory
107 SET GLOBAL clone_autotune_concurrency = OFF;
108 SET GLOBAL clone_max_concurrency = 8;
109 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
110 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
111 ERROR HY000: Path is within the current data directory 'CLONE_DATADIR'
112 select ID, STATE, ERROR_NO from performance_schema.clone_status;
113 ID STATE ERROR_NO
114 1 Completed 0
115 select ID, STAGE, STATE from performance_schema.clone_progress;
116 ID STAGE STATE
117 1 DROP DATA Completed
118 1 FILE COPY Completed
119 1 PAGE COPY Completed
120 1 REDO COPY Completed
121 1 FILE SYNC Completed
122 1 RESTART Not Started
123 1 RECOVERY Not Started
124 # 2D. Incorrect PATH - data directory exists
125 SET GLOBAL clone_autotune_concurrency = OFF;
126 SET GLOBAL clone_max_concurrency = 8;
127 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
128 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
129 ERROR HY000: Can't create database 'CLONE_DATADIR'; database exists
130 select ID, STATE, ERROR_NO from performance_schema.clone_status;
131 ID STATE ERROR_NO
132 1 Completed 0
133 select ID, STAGE, STATE from performance_schema.clone_progress;
134 ID STAGE STATE
135 1 DROP DATA Completed
136 1 FILE COPY Completed
137 1 PAGE COPY Completed
138 1 REDO COPY Completed
139 1 FILE SYNC Completed
140 1 RESTART Not Started
141 1 RECOVERY Not Started
142 #Cleanup
143 UNINSTALL PLUGIN clone;