Debian Codegraph @

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

raw
1 ################################################################################
2 # This test verifies that the recovery is protected by the server super read
3 # mode when the a member auto joins a group during server start.
4 #
5 # Test:
6 # 0) The test requires two servers: M1 and M2.
7 # 1) Bootstrap start a group on M1. Add some data on M1. Start GR on M2.
8 # 2) Stop GR on M2 and then block applier thread on M1.
9 # 3) Restart M2 with auto start. Recovery is stuck as M1's applier is blocked.
10 # 4) Verify that while stuck in recovery, M2 does not accept queries.
11 # 5) Unblock recovery by resuming the applier thread on M1. Check all is fine.
12 # 6) Clean up.
13 ################################################################################
14
15 --source include/big_test.inc
16 --source include/have_debug_sync.inc
17 --let $group_replication_group_name= f68d2bd0-8964-11e5-a837-0800200c9a66
18 --source include/have_group_replication_plugin.inc
19 --source include/force_restart.inc
20 --let $rpl_skip_group_replication_start= 1
21 --source include/group_replication.inc
22
23 --echo #
24 --echo # Start the member 1 and 2 and add some data
25 --echo #
26
27 --connection server1
28
29 --source include/start_and_bootstrap_group_replication.inc
30
31 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
32 INSERT INTO t1 VALUES (1);
33
34 --connection server2
35
36 --source include/start_group_replication.inc
37 --source include/stop_group_replication.inc
38
39 --connection server1
40
41 --echo #
42 --echo # Block the applier on server 1 to block recovery on server 2
43 --echo #
44 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
45
46 --echo #
47 --echo # On server 2 restart the server. Group replication should start at boot
48 --echo #
49
50 --connection server2
51
52 --let $allow_rpl_inited=1
53 --let $_group_replication_local_address= `SELECT @@GLOBAL.group_replication_local_address`
54 --let $_group_replication_group_seeds= `SELECT @@GLOBAL.group_replication_group_seeds`
55 --let $restart_parameters=restart:--group_replication_local_address=$_group_replication_local_address --group_replication_group_seeds=$_group_replication_group_seeds --group_replication_start_on_boot=1 --group-replication-group-name=$group_replication_group_name
56 --replace_result $_group_replication_local_address GROUP_REPLICATION_LOCAL_ADDRESS $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS
57 --source include/restart_mysqld.inc
58
59 # renable connection
60 --let $rpl_connection_name= server_2
61 --source include/rpl_connection.inc
62 --enable_reconnect
63
64 --let $rpl_connection_name= server2
65 --source include/rpl_connection.inc
66 --enable_reconnect
67
68 --let $group_replication_member_state= RECOVERING
69 --source include/gr_wait_for_member_state.inc
70
71 --echo #
72 --echo # On server 2 after restart, recovery should be stuck
73 --echo # Query execution is not allowed
74 --echo #
75
76 --error ER_OPTION_PREVENTS_STATEMENT
77 INSERT INTO t1 VALUES (2);
78
79 --let $assert_text= On the recovered member, the table should exist and have 1 elements;
80 --let $assert_cond= [select count(*) from t1] = 1;
81 --source include/assert.inc
82
83
84 --echo #
85 --echo # Unblock recovery by resuming the applier on server 1
86 --echo #
87
88 --connection server1
89
90 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
91 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
92 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
93
94 --connection server2
95
96 --let $group_replication_member_state= ONLINE
97 --source include/gr_wait_for_member_state.inc
98
99 INSERT INTO t1 VALUES (2);
100
101 --connection server1
102
103 --let $wait_condition= SELECT count(*)=2 FROM t1;
104 --source include/wait_condition.inc
105
106 --echo #
107 --echo # Cleanup
108 --echo #
109
110 --connection server1
111 SET DEBUG_SYNC= 'RESET';
112
113 --connection server2
114
115 DROP TABLE t1;
116
117 --let $restart_parameters=
118
119 --source include/group_replication_end.inc