Debian Codegraph @

mysql-test/suite/group_replication/t/gr_single_primary_async_after_gr_secondary.test

raw
1 #
2 # Test case to verify that asynchronous replication channel cannot be started
3 # on secondary, while group replication is running on single-primary mode.
4 #
5 # Test:
6 #
7 # 1. Start GR on server1 & 2.
8 # 2. Create new channel ch3_2: server2(slave), server3(master).
9 # 3. Add some data to server1 & 3.
10 # 4. Verify for following scenarios:
11 # 1. start slave and and verify for
12 # ER_GROUP_REPLICATION_CONFIGURATION error.
13 # 2. start slave io and verify for
14 # ER_GROUP_REPLICATION_CONFIGURATION error.
15 # 3. start slave sql and verify for
16 # ER_GROUP_REPLICATION_CONFIGURATION error.
17 # 6. Verify channel ch3_2 IO & SQL THREADS are OFF.
18 # 7. Verify data(t2 table) didn't replicated from server3 to server1 & 2.
19 # 8. Clean up.
20 #
21
22 --source include/big_test.inc
23 --source include/have_group_replication_plugin.inc
24 --let $rpl_skip_group_replication_start= 1
25 --let $rpl_server_count= 3
26 --let $rpl_group_replication_single_primary_mode=1
27 --source include/group_replication.inc
28
29 --echo
30 --echo # 1. Start GR on server1 & 2
31
32 # Boostrap start GR on server1 (Primary)
33 --let $rpl_connection_name= server1
34 --source include/rpl_connection.inc
35 --source include/start_and_bootstrap_group_replication.inc
36
37 # Start GR on server2 (Secondary)
38 --let $rpl_connection_name= server2
39 --source include/rpl_connection.inc
40 --source include/start_group_replication.inc
41
42 --echo
43 --echo # 2. Create new channel ch3_2: server2(slave), server3(master)
44 --let $rpl_connection_name= server2
45 --source include/rpl_connection.inc
46
47 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
48 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=$SERVER_MYPORT_3 for channel 'ch3_2'
49
50
51 --echo
52 --echo # 3. Add some data to server1 & 3
53
54 # server1: create table t1 and add data
55 --let $rpl_connection_name= server1
56 --source include/rpl_connection.inc
57 CREATE TABLE test.t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
58 INSERT INTO test.t1 VALUES (1);
59
60 # server3: create table t2 and add data
61 --let $rpl_connection_name= server3
62 --source include/rpl_connection.inc
63 CREATE TABLE test.t2 (c1 INT NOT NULL) ENGINE=InnoDB;
64 INSERT INTO test.t2 VALUES (1);
65
66
67 --echo
68 --echo # 4. Verify the error scenarios.
69
70 # variables for wait_for_slave_io_error.inc and wait_for_slave_sql_error.inc
71 --let $rpl_channel_name='ch3_2'
72
73 --let $slave_io_errno= convert_error(ER_REPLICA_FATAL_ERROR)
74 --let $show_slave_io_error= 0
75 --let $slave_io_error_replace= / at [0-9]*/ at XXX/
76
77 --let $slave_sql_errno= convert_error(ER_REPLICA_FATAL_ERROR)
78 --let $show_slave_sql_error= 0
79 --let $slave_sql_error_replace= / at [0-9]*/ at XXX/
80
81 --echo
82 --echo # 4.1 start slave and verify for error ER_REPLICA_FATAL_ERROR
83 --let $rpl_connection_name= server2
84 --source include/rpl_connection.inc
85
86 START SLAVE FOR CHANNEL 'ch3_2';
87 --source include/wait_for_slave_io_error.inc
88 --source include/wait_for_slave_sql_error.inc
89
90 --echo
91 --echo # 4.2 start slave io and verify for error ER_REPLICA_FATAL_ERROR
92 START SLAVE IO_THREAD FOR CHANNEL 'ch3_2';
93 --source include/wait_for_slave_io_error.inc
94
95 --echo
96 --echo # 4.3 start slave sql and verify for error ER_REPLICA_FATAL_ERROR
97 START SLAVE SQL_THREAD FOR CHANNEL 'ch3_2';
98 --source include/wait_for_slave_sql_error.inc
99
100 --let $rpl_channel_name=
101
102 --echo
103 --echo # 5. Verify occurrence of error message
104 --replace_regex /[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]T[0-9][0-9]:[0-9][0-9]:[0-9][0-9]\.[0-9][0-9][0-9][0-9][0-9][0-9][-+Z][0-9:]* *[0-9]* *\[/DATE_TIME [/
105
106 --let $grep_file= $MYSQLTEST_VARDIR/tmp/gr_secondary_scenario2.err
107 --let $grep_pattern= Can't start replica IO THREAD of channel 'ch3_2' when group replication is running with single-primary mode on a secondary member.
108 --let $grep_output= print_count
109 --source include/grep_pattern.inc
110
111 --let $grep_file= $MYSQLTEST_VARDIR/tmp/gr_secondary_scenario2.err
112 --let $grep_pattern= Can't start replica SQL THREAD of channel 'ch3_2' when group replication is running with single-primary mode on a secondary member.
113 --let $grep_output= print_count
114 --source include/grep_pattern.inc
115
116 --echo
117 --echo # 6. Verify channel ch3_2 IO & SQL THREAD is OFF
118 --let $assert_text= Verify channel ch3_2 IO_THREAD is OFF
119 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name = \'ch3_2\', SERVICE_STATE, 1]" = "OFF"
120 --source include/assert.inc
121
122 --let $assert_text= Verify channel ch3_2 SQL_THREAD is OFF
123 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_applier_status WHERE channel_name = \'ch3_2\', SERVICE_STATE, 1]" = "OFF"
124 --source include/assert.inc
125
126 --echo
127 --echo # 7. Verifying data(t2 table) didn't replicated from server3 to server1 & 2
128
129 # Wait for all servers to be in sync
130 --source include/rpl_sync.inc
131
132 --let $rpl_connection_name= server2
133 --source include/rpl_connection.inc
134 --let $assert_text= Verify only single table present i.e. t1
135 --let $assert_cond= "[SELECT count(table_name) COUNT FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = \'test\', COUNT, 1]" = "1"
136 --source include/assert.inc
137
138 --let $rpl_connection_name= server1
139 --source include/rpl_connection.inc
140 --let $assert_text= Verify only single table present i.e. t1
141 --let $assert_cond= "[SELECT count(table_name) COUNT FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = \'test\', COUNT, 1]" = "1"
142 --source include/assert.inc
143
144
145 --echo
146 --echo # 8. Clean Up
147
148 --let $rpl_connection_name= server2
149 --source include/rpl_connection.inc
150 RESET SLAVE ALL FOR CHANNEL 'ch3_2';
151
152 --let $rpl_connection_name= server1
153 --source include/rpl_connection.inc
154 DROP TABLE test.t1;
155
156 --let $rpl_connection_name= server3
157 --source include/rpl_connection.inc
158 DROP TABLE test.t2;
159
160 --source include/group_replication_end.inc