Debian Codegraph @

mysql-test/suite/group_replication/r/gr_applier_slave_commands.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 [connection server1]
7
8 # CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
9 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10 FOR CHANNEL "group_replication_applier";
10 ERROR HY000: CHANGE REPLICATION SOURCE with the given parameters cannot be performed on channel 'group_replication_applier'.
11
12 # CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
13 CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL "group_replication_applier";
14 ERROR HY000: CHANGE REPLICATION SOURCE with the given parameters cannot be performed on channel 'group_replication_applier'.
15
16 # CHANGE MASTER command is blocked for option `PRIVILEGE_CHECKS_USER` when GR is running
17 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER='user' FOR CHANNEL "group_replication_applier";
18 ERROR HY000: This operation cannot be performed while Group Replication is running; run STOP GROUP_REPLICATION first
19
20 # error when executing START SLAVE IO_THREAD FOR CHANNEL
21 START SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
22 ERROR HY000: START REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
23
24 # error when executing STOP SLAVE IO_THREAD FOR CHANNEL
25 STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
26 ERROR HY000: STOP REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
27
28 # error when executing START SLAVE IO_THREAD FOR CHANNEL with UNTIL option
29 START SLAVE IO_THREAD UNTIL SOURCE_LOG_FILE = 'server-binary-log.000001', SOURCE_LOG_POS = 781 FOR CHANNEL 'group_replication_applier';
30 ERROR HY000: START REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
31
32 # error when executing START SLAVE FOR CHANNEL
33 START SLAVE FOR CHANNEL 'group_replication_applier';
34 ERROR HY000: START REPLICA FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
35
36 # error when executing STOP SLAVE FOR CHANNEL
37 STOP SLAVE FOR CHANNEL 'group_replication_applier';
38 ERROR HY000: STOP REPLICA FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
39
40 # error when executing SHOW SLAVE STATUS FOR CHANNEL
41 SHOW SLAVE STATUS FOR CHANNEL 'group_replication_applier';
42 ERROR HY000: SHOW REPLICA STATUS cannot be performed on channel 'group_replication_applier'.
43
44 # START SLAVE SQL_THREAD command will not work for group_replication_applier
45 START REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
46 ERROR HY000: START REPLICA FOR CHANNEL while Group Replication is running cannot be performed on channel 'group_replication_applier'.
47
48 # STOP SLAVE SQL_THREAD command will not work for group_replication_applier
49 STOP REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
50 ERROR HY000: STOP REPLICA FOR CHANNEL while Group Replication is running cannot be performed on channel 'group_replication_applier'.
51 # START SLAVE SQL_THREAD with UNTIL option will not work for group_replication_applier
52 START SLAVE SQL_THREAD UNTIL SQL_BEFORE_GTIDS='11111111-1111-1111-1111-111111111111:1-23' FOR CHANNEL 'group_replication_applier';
53 ERROR HY000: START REPLICA FOR CHANNEL while Group Replication is running cannot be performed on channel 'group_replication_applier'.
54 # START SLAVE SQL_THREAD with UNTIL option will not work for group_replication_applier
55 START SLAVE SQL_THREAD UNTIL RELAY_LOG_FILE = 'server-relay-log-group_replication_applier.000002', RELAY_LOG_POS = 10000 FOR CHANNEL 'group_replication_applier';
56 ERROR HY000: START REPLICA FOR CHANNEL while Group Replication is running cannot be performed on channel 'group_replication_applier'.
57
58 # SHOW RELAYLOG EVENTS for channel will work for all channels
59 include/assert.inc [Relay log name should not be empty as the command successfully executed.]
60 [connection server1]
61 include/stop_group_replication.inc
62
63 # CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
64 CHANGE REPLICATION SOURCE TO SOURCE_HOST="localhost", SOURCE_PORT=10 FOR CHANNEL "group_replication_applier";
65 ERROR HY000: CHANGE REPLICATION SOURCE with the given parameters cannot be performed on channel 'group_replication_applier'.
66
67 # CHANGE MASTER command is blocked for other options than `PRIVILEGE_CHECKS_USER`.
68 CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL "group_replication_applier";
69 ERROR HY000: CHANGE REPLICATION SOURCE with the given parameters cannot be performed on channel 'group_replication_applier'.
70
71 # CHANGE MASTER command allows option `PRIVILEGE_CHECKS_USER` when GR is stopped
72 SET SESSION sql_log_bin= 0;
73 CREATE USER gr_applier_slave_user;
74 SET SESSION sql_log_bin= 1;
75 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER='gr_applier_slave_user' FOR CHANNEL "group_replication_applier";
76 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER=NULL FOR CHANNEL "group_replication_applier";
77 SET SESSION sql_log_bin= 0;
78 DROP USER gr_applier_slave_user;
79 SET SESSION sql_log_bin= 1;
80
81 # error when executing START SLAVE IO_THREAD FOR CHANNEL
82 START SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
83 ERROR HY000: START REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
84
85 # error when executing STOP SLAVE IO_THREAD FOR CHANNEL
86 STOP SLAVE IO_THREAD FOR CHANNEL 'group_replication_applier';
87 ERROR HY000: STOP REPLICA IO_THREAD FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
88
89 # error when executing START SLAVE FOR CHANNEL
90 START SLAVE FOR CHANNEL 'group_replication_applier';
91 ERROR HY000: START REPLICA FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
92
93 # error when executing STOP SLAVE FOR CHANNEL
94 STOP SLAVE FOR CHANNEL 'group_replication_applier';
95 ERROR HY000: STOP REPLICA FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
96
97 # error when executing SHOW SLAVE STATUS FOR CHANNEL
98 SHOW SLAVE STATUS FOR CHANNEL 'group_replication_applier';
99 ERROR HY000: SHOW REPLICA STATUS cannot be performed on channel 'group_replication_applier'.
100
101 # START SLAVE SQL_THREAD command will work for group_replication_applier
102 include/gr_start_applier_sql_thread.inc
103 START REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
104
105 # STOP SLAVE SQL_THREAD command will work for group_replication_applier
106 include/gr_stop_applier_sql_thread.inc
107 STOP REPLICA SQL_THREAD FOR CHANNEL "group_replication_applier";
108
109 # SHOW RELAYLOG EVENTS for channel will work for all channels
110 include/assert.inc [Relay log name should not be empty as the command successfully executed.]
111 [connection server1]
112 include/start_group_replication.inc
113 [connection server2]
114
115 # RESET SLAVE [ALL] command is blocked only when channel is running.
116 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
117 ERROR HY000: RESET REPLICA [ALL] FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
118 RESET SLAVE FOR CHANNEL "group_replication_applier";
119 ERROR HY000: RESET REPLICA [ALL] FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
120
121 # This is command should work without problem.
122 include/stop_group_replication.inc
123 RESET SLAVE FOR CHANNEL "group_replication_applier";
124 Warnings:
125 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
126 include/start_group_replication.inc
127
128 # This is command should work without problem.
129 include/stop_group_replication.inc
130 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
131 Warnings:
132 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
133 include/start_group_replication.inc
134 # RESET SLAVE should not be allowed when GR is ONLINE.
135 # So this command will fail.
136 RESET SLAVE FOR CHANNEL "group_replication_applier";
137 ERROR HY000: RESET REPLICA [ALL] FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
138 # RESET SLAVE ALL should not be allowed when GR is ONLINE.
139 # So this command will fail.
140 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
141 ERROR HY000: RESET REPLICA [ALL] FOR CHANNEL cannot be performed on channel 'group_replication_applier'.
142 # stop the channel and try reset slave for channel again. It should work.
143 include/stop_group_replication.inc
144 RESET SLAVE ALL FOR CHANNEL "group_replication_applier";
145 Warnings:
146 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
147 RESET SLAVE FOR CHANNEL "group_replication_applier";
148 ERROR HY000: Replica channel 'group_replication_applier' does not exist.
149 include/group_replication_end.inc