Debian Codegraph @

mysql-test/suite/group_replication/r/gr_perfschema_parallel_applier.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 ############################################################
8 # 1. Before start Group Replication channels are not present
9 # on common replication P_S tables.
10 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_configuration table']
11 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_status table']
12 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_configuration table']
13 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status table']
14 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
15 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_worker table']
16
17 ############################################################
18 # 2. After start Group Replication channels are present
19 # on common replication P_S tables.
20 [connection server2]
21 include/start_and_bootstrap_group_replication.inc
22 [connection server1]
23 include/start_group_replication.inc
24 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_connection_configuration table']
25 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_connection_status table']
26 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_applier_configuration table']
27 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_applier_status table']
28 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
29 include/assert.inc ['There are four Group Replication applier channel workers on performance_schema.replication_applier_status_by_worker table']
30
31 ############################################################
32 # 3. Group Replication running channels sample output
33 # on common replication P_S tables.
34 [connection server2]
35 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
36 INSERT INTO t1 VALUES (1);
37 include/rpl_sync.inc
38 [connection server1]
39
40 SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name = "group_replication_applier";
41 CHANNEL_NAME group_replication_applier
42 HOST <NULL>
43 PORT 0
44 USER
45 NETWORK_INTERFACE
46 AUTO_POSITION 1
47 SSL_ALLOWED NO
48 SSL_CA_FILE
49 SSL_CA_PATH
50 SSL_CERTIFICATE
51 SSL_CIPHER
52 SSL_KEY
53 SSL_VERIFY_SERVER_CERTIFICATE NO
54 SSL_CRL_FILE
55 SSL_CRL_PATH
56 CONNECTION_RETRY_INTERVAL 60
57 CONNECTION_RETRY_COUNT 10
58 HEARTBEAT_INTERVAL 30.000
59 TLS_VERSION
60 PUBLIC_KEY_PATH
61 GET_PUBLIC_KEY NO
62 NETWORK_NAMESPACE
63 COMPRESSION_ALGORITHM uncompressed
64 ZSTD_COMPRESSION_LEVEL 3
65 TLS_CIPHERSUITES NULL
66 SOURCE_CONNECTION_AUTO_FAILOVER 0
67 GTID_ONLY 1
68
69 SELECT * FROM performance_schema.replication_connection_status WHERE channel_name = "group_replication_applier";
70 CHANNEL_NAME group_replication_applier
71 GROUP_NAME 8a94f357-aab4-11df-86ab-c80aa9429445
72 SOURCE_UUID 8a94f357-aab4-11df-86ab-c80aa9429445
73 THREAD_ID NULL
74 SERVICE_STATE ON
75 COUNT_RECEIVED_HEARTBEATS 0
76 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00.000000
77 RECEIVED_TRANSACTION_SET 8a94f357-aab4-11df-86ab-c80aa9429445:2-4
78 LAST_ERROR_NUMBER 0
79 LAST_ERROR_MESSAGE
80 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
81 LAST_QUEUED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429445:4
82 LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
83 LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
84 LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP [START_QUEUE_TIMESTAMP]
85 LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP [END_QUEUE_TIMESTAMP]
86 QUEUEING_TRANSACTION
87 QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
88 QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
89 QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000
90
91 SELECT * FROM performance_schema.replication_applier_configuration WHERE channel_name = "group_replication_applier";
92 CHANNEL_NAME group_replication_applier
93 DESIRED_DELAY 0
94 PRIVILEGE_CHECKS_USER NULL
95 REQUIRE_ROW_FORMAT YES
96 REQUIRE_TABLE_PRIMARY_KEY_CHECK STREAM
97 ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE OFF
98 ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE NULL
99
100 SELECT * FROM performance_schema.replication_applier_status WHERE channel_name = "group_replication_applier";
101 CHANNEL_NAME group_replication_applier
102 SERVICE_STATE ON
103 REMAINING_DELAY NULL
104 COUNT_TRANSACTIONS_RETRIES 0
105
106 SELECT * FROM performance_schema.replication_applier_status_by_coordinator WHERE channel_name = "group_replication_applier";
107 CHANNEL_NAME group_replication_applier
108 THREAD_ID [THREAD_ID]
109 SERVICE_STATE ON
110 LAST_ERROR_NUMBER 0
111 LAST_ERROR_MESSAGE
112 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
113 LAST_PROCESSED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429445:4
114 LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
115 LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
116 LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP [START_BUFFER_TIMESTAMP]
117 LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP [END_BUFFER_TIMESTAMP]
118 PROCESSING_TRANSACTION
119 PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
120 PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
121 PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP 0000-00-00 00:00:00.000000
122
123 SELECT * FROM performance_schema.replication_applier_status_by_worker WHERE channel_name = "group_replication_applier";
124 CHANNEL_NAME group_replication_applier
125 WORKER_ID 1
126 THREAD_ID [THREAD_ID]
127 SERVICE_STATE ON
128 LAST_ERROR_NUMBER 0
129 LAST_ERROR_MESSAGE
130 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
131 LAST_APPLIED_TRANSACTION [GTID]
132 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
133 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
134 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
135 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
136 APPLYING_TRANSACTION
137 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
138 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
139 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
140 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
141 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
142 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
143 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
144 APPLYING_TRANSACTION_RETRIES_COUNT 0
145 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
146 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
147 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
148 CHANNEL_NAME group_replication_applier
149 WORKER_ID 2
150 THREAD_ID [THREAD_ID]
151 SERVICE_STATE ON
152 LAST_ERROR_NUMBER 0
153 LAST_ERROR_MESSAGE
154 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
155 LAST_APPLIED_TRANSACTION [GTID]
156 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
157 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
158 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
159 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
160 APPLYING_TRANSACTION
161 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
162 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
163 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
164 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
165 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
166 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
167 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
168 APPLYING_TRANSACTION_RETRIES_COUNT 0
169 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
170 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
171 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
172 CHANNEL_NAME group_replication_applier
173 WORKER_ID 3
174 THREAD_ID [THREAD_ID]
175 SERVICE_STATE ON
176 LAST_ERROR_NUMBER 0
177 LAST_ERROR_MESSAGE
178 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
179 LAST_APPLIED_TRANSACTION [GTID]
180 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
181 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
182 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
183 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
184 APPLYING_TRANSACTION
185 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
186 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
187 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
188 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
189 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
190 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
191 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
192 APPLYING_TRANSACTION_RETRIES_COUNT 0
193 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
194 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
195 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
196 CHANNEL_NAME group_replication_applier
197 WORKER_ID 4
198 THREAD_ID [THREAD_ID]
199 SERVICE_STATE ON
200 LAST_ERROR_NUMBER 0
201 LAST_ERROR_MESSAGE
202 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
203 LAST_APPLIED_TRANSACTION [GTID]
204 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
205 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
206 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
207 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
208 APPLYING_TRANSACTION
209 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
210 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
211 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
212 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
213 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
214 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
215 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
216 APPLYING_TRANSACTION_RETRIES_COUNT 0
217 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
218 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
219 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
220
221 ############################################################
222 # 4. Clean up data.
223 [connection server2]
224 DROP TABLE t1;
225 include/rpl_sync.inc
226
227 ############################################################
228 # 5. Stop Group Replication, channels must continue to be
229 # present on common replication P_S tables.
230 [connection server2]
231 include/stop_group_replication.inc
232 [connection server1]
233 include/stop_group_replication.inc
234 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_connection_configuration table']
235 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_connection_status table']
236 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_applier_configuration table']
237 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_applier_status table']
238 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
239 include/assert.inc ['There are still four Group Replication applier channel workers on performance_schema.replication_applier_status_by_worker table']
240
241 ############################################################
242 # 6. Group Replication stopped channels sample output
243 # on common replication P_S tables.
244
245 SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name = "group_replication_applier";
246 CHANNEL_NAME group_replication_applier
247 HOST <NULL>
248 PORT 0
249 USER
250 NETWORK_INTERFACE
251 AUTO_POSITION 1
252 SSL_ALLOWED NO
253 SSL_CA_FILE
254 SSL_CA_PATH
255 SSL_CERTIFICATE
256 SSL_CIPHER
257 SSL_KEY
258 SSL_VERIFY_SERVER_CERTIFICATE NO
259 SSL_CRL_FILE
260 SSL_CRL_PATH
261 CONNECTION_RETRY_INTERVAL 60
262 CONNECTION_RETRY_COUNT 10
263 HEARTBEAT_INTERVAL 30.000
264 TLS_VERSION
265 PUBLIC_KEY_PATH
266 GET_PUBLIC_KEY NO
267 NETWORK_NAMESPACE
268 COMPRESSION_ALGORITHM uncompressed
269 ZSTD_COMPRESSION_LEVEL 3
270 TLS_CIPHERSUITES NULL
271 SOURCE_CONNECTION_AUTO_FAILOVER 0
272 GTID_ONLY 1
273
274 SELECT * FROM performance_schema.replication_connection_status WHERE channel_name = "group_replication_applier";
275 CHANNEL_NAME group_replication_applier
276 GROUP_NAME 8a94f357-aab4-11df-86ab-c80aa9429445
277 SOURCE_UUID 8a94f357-aab4-11df-86ab-c80aa9429445
278 THREAD_ID NULL
279 SERVICE_STATE OFF
280 COUNT_RECEIVED_HEARTBEATS 0
281 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00.000000
282 RECEIVED_TRANSACTION_SET 8a94f357-aab4-11df-86ab-c80aa9429445:2-5
283 LAST_ERROR_NUMBER 0
284 LAST_ERROR_MESSAGE
285 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
286 LAST_QUEUED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429445:5
287 LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
288 LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
289 LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP [START_QUEUE_TIMESTAMP]
290 LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP [END_QUEUE_TIMESTAMP]
291 QUEUEING_TRANSACTION
292 QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
293 QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
294 QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000
295
296 SELECT * FROM performance_schema.replication_applier_configuration WHERE channel_name = "group_replication_applier";
297 CHANNEL_NAME group_replication_applier
298 DESIRED_DELAY 0
299 PRIVILEGE_CHECKS_USER NULL
300 REQUIRE_ROW_FORMAT YES
301 REQUIRE_TABLE_PRIMARY_KEY_CHECK STREAM
302 ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE OFF
303 ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE NULL
304
305 SELECT * FROM performance_schema.replication_applier_status WHERE channel_name = "group_replication_applier";
306 CHANNEL_NAME group_replication_applier
307 SERVICE_STATE OFF
308 REMAINING_DELAY NULL
309 COUNT_TRANSACTIONS_RETRIES 0
310
311 SELECT * FROM performance_schema.replication_applier_status_by_coordinator WHERE channel_name = "group_replication_applier";
312 CHANNEL_NAME group_replication_applier
313 THREAD_ID NULL
314 SERVICE_STATE OFF
315 LAST_ERROR_NUMBER 0
316 LAST_ERROR_MESSAGE
317 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
318 LAST_PROCESSED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429445:5
319 LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
320 LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
321 LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP [START_BUFFER_TIMESTAMP]
322 LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP [END_BUFFER_TIMESTAMP]
323 PROCESSING_TRANSACTION
324 PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
325 PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
326 PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP 0000-00-00 00:00:00.000000
327
328 SELECT * FROM performance_schema.replication_applier_status_by_worker WHERE channel_name = "group_replication_applier";
329 CHANNEL_NAME group_replication_applier
330 WORKER_ID 1
331 THREAD_ID NULL
332 SERVICE_STATE OFF
333 LAST_ERROR_NUMBER 0
334 LAST_ERROR_MESSAGE
335 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
336 LAST_APPLIED_TRANSACTION [GTID]
337 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
338 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
339 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
340 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
341 APPLYING_TRANSACTION
342 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
343 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
344 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
345 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
346 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
347 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
348 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
349 APPLYING_TRANSACTION_RETRIES_COUNT 0
350 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
351 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
352 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
353 CHANNEL_NAME group_replication_applier
354 WORKER_ID 2
355 THREAD_ID NULL
356 SERVICE_STATE OFF
357 LAST_ERROR_NUMBER 0
358 LAST_ERROR_MESSAGE
359 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
360 LAST_APPLIED_TRANSACTION [GTID]
361 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
362 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
363 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
364 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
365 APPLYING_TRANSACTION
366 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
367 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
368 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
369 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
370 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
371 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
372 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
373 APPLYING_TRANSACTION_RETRIES_COUNT 0
374 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
375 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
376 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
377 CHANNEL_NAME group_replication_applier
378 WORKER_ID 3
379 THREAD_ID NULL
380 SERVICE_STATE OFF
381 LAST_ERROR_NUMBER 0
382 LAST_ERROR_MESSAGE
383 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
384 LAST_APPLIED_TRANSACTION [GTID]
385 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
386 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
387 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
388 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
389 APPLYING_TRANSACTION
390 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
391 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
392 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
393 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
394 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
395 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
396 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
397 APPLYING_TRANSACTION_RETRIES_COUNT 0
398 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
399 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
400 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
401 CHANNEL_NAME group_replication_applier
402 WORKER_ID 4
403 THREAD_ID NULL
404 SERVICE_STATE OFF
405 LAST_ERROR_NUMBER 0
406 LAST_ERROR_MESSAGE
407 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
408 LAST_APPLIED_TRANSACTION [GTID]
409 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
410 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
411 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
412 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
413 APPLYING_TRANSACTION
414 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
415 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
416 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
417 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
418 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
419 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
420 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
421 APPLYING_TRANSACTION_RETRIES_COUNT 0
422 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
423 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
424 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
425
426 ############################################################
427 # 7. Group Replication channel must not be present on common
428 # replication P_S tables after a RESET ALL command.
429 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
430 Warnings:
431 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
432 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_configuration table']
433 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_status table']
434 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_configuration table']
435 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status table']
436 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
437 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_worker table']
438
439 ############################################################
440 # 8. Test end.
441 include/group_replication_end.inc