Debian Codegraph @

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

raw
1 ###############################################################################
2 # Validate that, with autocommit set to OFF on a secondary member,
3 # the `RESET REPLICA` command can be executed on this secondary group member
4 # after initiating a failover channel on server1.
5 #
6 # Test:
7 # 0. This test requires three servers:
8 # server1, server2: group
9 # server3: single server
10 # 1. Deploy a group in single-primary mode on server1 and
11 # server2
12 # 2. Set autocommit= OFF on server2
13 # 3. Configure a channel on server2 that replicates from
14 # server3
15 # 4. Start group replication on server2
16 # 5. Configure and start a failover channel on server1 that
17 # replicates from server3
18 # 6. Reset replica on server2
19 # 7. Clean up
20 #
21 # References:
22 # Bug#37173907 InnoDB ClusterSet Controlled Switchover Fail
23 ###############################################################################
24 --source include/big_test.inc
25 --source include/have_group_replication_plugin.inc
26 --let $rpl_skip_group_replication_start= 1
27 --let $rpl_server_count= 3
28 --source include/group_replication.inc
29
30
31 --echo
32 --echo ############################################################
33 --echo # 1. Deploy a group in single-primary mode on server1 and
34 --echo # server2
35 --let $rpl_connection_name= server1
36 --source include/rpl_connection.inc
37 --source include/start_and_bootstrap_group_replication.inc
38 --source include/gr_assert_primary_member.inc
39
40 --echo
41 --echo ############################################################
42 --echo # 2. Set autocommit OFF on server2
43 --let $rpl_connection_name= server2
44 --source include/rpl_connection.inc
45 let $sysvars_to_save = [
46 "GLOBAL.autocommit"
47 ];
48 --source include/save_sysvars.inc
49 SET @@GLOBAL.autocommit= 0;
50
51 --echo
52 --echo ############################################################
53 --echo # 3. Configure a channel on server2 that replicates from
54 --echo # server3
55 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
56 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=0, SOURCE_PORT=$SERVER_MYPORT_3, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1'
57
58 --echo
59 --echo ############################################################
60 --echo # 4. Start group replication on server2
61 --source include/start_group_replication.inc
62 --source include/gr_assert_secondary_member.inc
63
64 --echo
65 --echo ############################################################
66 --echo # 5. Configure and start a failover channel on server1 that
67 --echo # replicates from server3
68 --let $rpl_connection_name= server1
69 --source include/rpl_connection.inc
70 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
71 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=1, SOURCE_PORT=$SERVER_MYPORT_3, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1'
72
73 --echo
74 --echo ############################################################
75 --echo # 6. Reset replica on server2
76 --let $rpl_connection_name= server2
77 --source include/rpl_connection.inc
78 RESET REPLICA ALL FOR CHANNEL 'ch1';
79
80 --echo
81 --echo ############################################################
82 --echo # 7. Clean up.
83 --let $rpl_connection_name= server1
84 --source include/rpl_connection.inc
85 RESET REPLICA ALL FOR CHANNEL 'ch1';
86
87 --let $rpl_connection_name= server2
88 --source include/rpl_connection.inc
89 --source include/stop_group_replication.inc
90 --source include/restore_sysvars.inc
91
92 --let $rpl_connection_name= server1
93 --source include/rpl_connection.inc
94 --source include/stop_group_replication.inc
95
96 --source include/group_replication_end.inc