Debian Codegraph @

mysql-test/suite/group_replication/r/gr_perfschema.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 include/start_and_bootstrap_group_replication.inc
21 include/start_group_replication.inc
22 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_connection_configuration table']
23 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_connection_status table']
24 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_applier_configuration table']
25 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_applier_status table']
26 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
27 include/assert.inc ['There is a Group Replication applier channel on performance_schema.replication_applier_status_by_worker table']
28
29 ############################################################
30 # 3. Group Replication running channels sample output
31 # on common replication P_S tables.
32 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
33 INSERT INTO t1 VALUES (1);
34 include/rpl_sync.inc
35 #group_replication_recovery channel configuration
36 SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name LIKE "group_replication_recovery";
37 CHANNEL_NAME group_replication_recovery
38 HOST <NULL>
39 PORT 0
40 USER root
41 NETWORK_INTERFACE
42 AUTO_POSITION 1
43 SSL_ALLOWED NO
44 SSL_CA_FILE CA
45 SSL_CA_PATH
46 SSL_CERTIFICATE CERT
47 SSL_CIPHER
48 SSL_KEY KEY
49 SSL_VERIFY_SERVER_CERTIFICATE NO
50 SSL_CRL_FILE
51 SSL_CRL_PATH
52 CONNECTION_RETRY_INTERVAL 60
53 CONNECTION_RETRY_COUNT 1
54 HEARTBEAT_INTERVAL 30.000
55 TLS_VERSION TLSv1.2,TLSv1.3
56 PUBLIC_KEY_PATH
57 GET_PUBLIC_KEY NO
58 NETWORK_NAMESPACE
59 COMPRESSION_ALGORITHM uncompressed
60 ZSTD_COMPRESSION_LEVEL 3
61 TLS_CIPHERSUITES NULL
62 SOURCE_CONNECTION_AUTO_FAILOVER 0
63 GTID_ONLY 1
64 #group_replication_applier channel configuration
65 SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name LIKE "group_replication_applier";
66 CHANNEL_NAME group_replication_applier
67 HOST <NULL>
68 PORT 0
69 USER
70 NETWORK_INTERFACE
71 AUTO_POSITION 1
72 SSL_ALLOWED NO
73 SSL_CA_FILE
74 SSL_CA_PATH
75 SSL_CERTIFICATE
76 SSL_CIPHER
77 SSL_KEY
78 SSL_VERIFY_SERVER_CERTIFICATE NO
79 SSL_CRL_FILE
80 SSL_CRL_PATH
81 CONNECTION_RETRY_INTERVAL 60
82 CONNECTION_RETRY_COUNT 10
83 HEARTBEAT_INTERVAL 30.000
84 TLS_VERSION
85 PUBLIC_KEY_PATH
86 GET_PUBLIC_KEY NO
87 NETWORK_NAMESPACE
88 COMPRESSION_ALGORITHM uncompressed
89 ZSTD_COMPRESSION_LEVEL 3
90 TLS_CIPHERSUITES NULL
91 SOURCE_CONNECTION_AUTO_FAILOVER 0
92 GTID_ONLY 1
93
94 SELECT * FROM performance_schema.replication_connection_status WHERE channel_name = "group_replication_applier";
95 CHANNEL_NAME group_replication_applier
96 GROUP_NAME 8a94f357-aab4-11df-86ab-c80aa9429444
97 SOURCE_UUID 8a94f357-aab4-11df-86ab-c80aa9429444
98 THREAD_ID NULL
99 SERVICE_STATE ON
100 COUNT_RECEIVED_HEARTBEATS 0
101 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00.000000
102 RECEIVED_TRANSACTION_SET 8a94f357-aab4-11df-86ab-c80aa9429444:2-4
103 LAST_ERROR_NUMBER 0
104 LAST_ERROR_MESSAGE
105 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
106 LAST_QUEUED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429444:4
107 LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
108 LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
109 LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP [START_QUEUE_TIMESTAMP]
110 LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP [END_QUEUE_TIMESTAMP]
111 QUEUEING_TRANSACTION
112 QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
113 QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
114 QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000
115
116 SELECT * FROM performance_schema.replication_applier_configuration WHERE channel_name = "group_replication_applier";
117 CHANNEL_NAME group_replication_applier
118 DESIRED_DELAY 0
119 PRIVILEGE_CHECKS_USER NULL
120 REQUIRE_ROW_FORMAT YES
121 REQUIRE_TABLE_PRIMARY_KEY_CHECK STREAM
122 ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE OFF
123 ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE NULL
124
125 SELECT * FROM performance_schema.replication_applier_status WHERE channel_name = "group_replication_applier";
126 CHANNEL_NAME group_replication_applier
127 SERVICE_STATE ON
128 REMAINING_DELAY NULL
129 COUNT_TRANSACTIONS_RETRIES 0
130
131 SELECT * FROM performance_schema.replication_applier_status_by_coordinator WHERE channel_name = "group_replication_applier";
132 CHANNEL_NAME group_replication_applier
133 THREAD_ID [THREAD_ID]
134 SERVICE_STATE ON
135 LAST_ERROR_NUMBER 0
136 LAST_ERROR_MESSAGE
137 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
138 LAST_PROCESSED_TRANSACTION [LAST_PROCESSED_TRANSACTION]
139 LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
140 LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
141 LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP [START_BUFFER_TIMESTAMP]
142 LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP [END_BUFFER_TIMESTAMP]
143 PROCESSING_TRANSACTION
144 PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
145 PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
146 PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP 0000-00-00 00:00:00.000000
147
148 SELECT * FROM performance_schema.replication_applier_status_by_worker WHERE channel_name = "group_replication_applier";
149 CHANNEL_NAME group_replication_applier
150 WORKER_ID 1
151 THREAD_ID [THREAD_ID]
152 SERVICE_STATE ON
153 LAST_ERROR_NUMBER 0
154 LAST_ERROR_MESSAGE
155 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
156 LAST_APPLIED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429444:4
157 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
158 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
159 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
160 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
161 APPLYING_TRANSACTION
162 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
163 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
164 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
165 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
166 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
167 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
168 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
169 APPLYING_TRANSACTION_RETRIES_COUNT 0
170 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
171 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
172 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
173
174 ############################################################
175 # 4. Clean up data.
176 DROP TABLE t1;
177 include/rpl_sync.inc
178
179 ############################################################
180 # 5. Stop Group Replication, channels must continue to be
181 # present on common replication P_S tables.
182 include/stop_group_replication.inc
183 include/stop_group_replication.inc
184 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_connection_configuration table']
185 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_connection_status table']
186 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_applier_configuration table']
187 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_applier_status table']
188 include/assert.inc ['There is still no Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
189 include/assert.inc ['There is still a Group Replication applier channel on performance_schema.replication_applier_status_by_worker table']
190
191 ############################################################
192 # 6. Group Replication stopped channels sample output
193 # on common replication P_S tables.
194 #group_replication_recovery channel configuration
195 SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name LIKE "group_replication_recovery";
196 CHANNEL_NAME group_replication_recovery
197 HOST <NULL>
198 PORT 0
199 USER root
200 NETWORK_INTERFACE
201 AUTO_POSITION 1
202 SSL_ALLOWED NO
203 SSL_CA_FILE CA
204 SSL_CA_PATH
205 SSL_CERTIFICATE CERT
206 SSL_CIPHER
207 SSL_KEY KEY
208 SSL_VERIFY_SERVER_CERTIFICATE NO
209 SSL_CRL_FILE
210 SSL_CRL_PATH
211 CONNECTION_RETRY_INTERVAL 60
212 CONNECTION_RETRY_COUNT 1
213 HEARTBEAT_INTERVAL 30.000
214 TLS_VERSION TLSv1.2,TLSv1.3
215 PUBLIC_KEY_PATH
216 GET_PUBLIC_KEY NO
217 NETWORK_NAMESPACE
218 COMPRESSION_ALGORITHM uncompressed
219 ZSTD_COMPRESSION_LEVEL 3
220 TLS_CIPHERSUITES NULL
221 SOURCE_CONNECTION_AUTO_FAILOVER 0
222 GTID_ONLY 1
223 #group_replication_applier channel configuration
224 SELECT * FROM performance_schema.replication_connection_configuration WHERE channel_name LIKE "group_replication_applier";
225 CHANNEL_NAME group_replication_applier
226 HOST <NULL>
227 PORT 0
228 USER
229 NETWORK_INTERFACE
230 AUTO_POSITION 1
231 SSL_ALLOWED NO
232 SSL_CA_FILE
233 SSL_CA_PATH
234 SSL_CERTIFICATE
235 SSL_CIPHER
236 SSL_KEY
237 SSL_VERIFY_SERVER_CERTIFICATE NO
238 SSL_CRL_FILE
239 SSL_CRL_PATH
240 CONNECTION_RETRY_INTERVAL 60
241 CONNECTION_RETRY_COUNT 10
242 HEARTBEAT_INTERVAL 30.000
243 TLS_VERSION
244 PUBLIC_KEY_PATH
245 GET_PUBLIC_KEY NO
246 NETWORK_NAMESPACE
247 COMPRESSION_ALGORITHM uncompressed
248 ZSTD_COMPRESSION_LEVEL 3
249 TLS_CIPHERSUITES NULL
250 SOURCE_CONNECTION_AUTO_FAILOVER 0
251 GTID_ONLY 1
252
253 SELECT * FROM performance_schema.replication_connection_status WHERE channel_name = "group_replication_applier";
254 CHANNEL_NAME group_replication_applier
255 GROUP_NAME 8a94f357-aab4-11df-86ab-c80aa9429444
256 SOURCE_UUID 8a94f357-aab4-11df-86ab-c80aa9429444
257 THREAD_ID NULL
258 SERVICE_STATE OFF
259 COUNT_RECEIVED_HEARTBEATS 0
260 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00.000000
261 RECEIVED_TRANSACTION_SET 8a94f357-aab4-11df-86ab-c80aa9429444:2-5
262 LAST_ERROR_NUMBER 0
263 LAST_ERROR_MESSAGE
264 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
265 LAST_QUEUED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429444:5
266 LAST_QUEUED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
267 LAST_QUEUED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
268 LAST_QUEUED_TRANSACTION_START_QUEUE_TIMESTAMP [START_QUEUE_TIMESTAMP]
269 LAST_QUEUED_TRANSACTION_END_QUEUE_TIMESTAMP [END_QUEUE_TIMESTAMP]
270 QUEUEING_TRANSACTION
271 QUEUEING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
272 QUEUEING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
273 QUEUEING_TRANSACTION_START_QUEUE_TIMESTAMP 0000-00-00 00:00:00.000000
274
275 SELECT * FROM performance_schema.replication_applier_configuration WHERE channel_name = "group_replication_applier";
276 CHANNEL_NAME group_replication_applier
277 DESIRED_DELAY 0
278 PRIVILEGE_CHECKS_USER NULL
279 REQUIRE_ROW_FORMAT YES
280 REQUIRE_TABLE_PRIMARY_KEY_CHECK STREAM
281 ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE OFF
282 ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE NULL
283
284 SELECT * FROM performance_schema.replication_applier_status WHERE channel_name = "group_replication_applier";
285 CHANNEL_NAME group_replication_applier
286 SERVICE_STATE OFF
287 REMAINING_DELAY NULL
288 COUNT_TRANSACTIONS_RETRIES 0
289
290 SELECT * FROM performance_schema.replication_applier_status_by_coordinator WHERE channel_name = "group_replication_applier";
291 CHANNEL_NAME group_replication_applier
292 THREAD_ID [THREAD_ID]
293 SERVICE_STATE OFF
294 LAST_ERROR_NUMBER 0
295 LAST_ERROR_MESSAGE
296 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
297 LAST_PROCESSED_TRANSACTION [LAST_PROCESSED_TRANSACTION]
298 LAST_PROCESSED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
299 LAST_PROCESSED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
300 LAST_PROCESSED_TRANSACTION_START_BUFFER_TIMESTAMP [START_BUFFER_TIMESTAMP]
301 LAST_PROCESSED_TRANSACTION_END_BUFFER_TIMESTAMP [END_BUFFER_TIMESTAMP]
302 PROCESSING_TRANSACTION
303 PROCESSING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
304 PROCESSING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
305 PROCESSING_TRANSACTION_START_BUFFER_TIMESTAMP 0000-00-00 00:00:00.000000
306
307 SELECT * FROM performance_schema.replication_applier_status_by_worker WHERE channel_name = "group_replication_applier";
308 CHANNEL_NAME group_replication_applier
309 WORKER_ID 1
310 THREAD_ID NULL
311 SERVICE_STATE OFF
312 LAST_ERROR_NUMBER 0
313 LAST_ERROR_MESSAGE
314 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
315 LAST_APPLIED_TRANSACTION 8a94f357-aab4-11df-86ab-c80aa9429444:5
316 LAST_APPLIED_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP [ORIGINAL_COMMIT_TIMESTAMP]
317 LAST_APPLIED_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP [IMMEDIATE_COMMIT_TIMESTAMP]
318 LAST_APPLIED_TRANSACTION_START_APPLY_TIMESTAMP [START_APPLY_TIMESTAMP]
319 LAST_APPLIED_TRANSACTION_END_APPLY_TIMESTAMP [END_APPLY_TIMESTAMP]
320 APPLYING_TRANSACTION
321 APPLYING_TRANSACTION_ORIGINAL_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
322 APPLYING_TRANSACTION_IMMEDIATE_COMMIT_TIMESTAMP 0000-00-00 00:00:00.000000
323 APPLYING_TRANSACTION_START_APPLY_TIMESTAMP 0000-00-00 00:00:00.000000
324 LAST_APPLIED_TRANSACTION_RETRIES_COUNT 0
325 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
326 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
327 LAST_APPLIED_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
328 APPLYING_TRANSACTION_RETRIES_COUNT 0
329 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_NUMBER 0
330 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_MESSAGE
331 APPLYING_TRANSACTION_LAST_TRANSIENT_ERROR_TIMESTAMP 0000-00-00 00:00:00.000000
332
333 ############################################################
334 # 7. Group Replication channel must not be present on common
335 # replication P_S tables after a RESET ALL command.
336 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
337 Warnings:
338 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
339 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_configuration table']
340 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_connection_status table']
341 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_configuration table']
342 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status table']
343 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_coordinator table']
344 include/assert.inc ['There is no Group Replication applier channel on performance_schema.replication_applier_status_by_worker table']
345
346 ############################################################
347 # 8. Test end.
348 include/group_replication_end.inc