Debian Codegraph @

mysql-test/suite/group_replication/r/gr_autorejoin_monitoring_test.result

raw
1 include/group_replication.inc [rpl_server_count=3]
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 # 0) The test requires three servers.
9 ####
10
11 [connection server1]
12 SET sql_log_bin = 0;
13 call mtr.add_suppression("Member was expelled from the group due to network failures, changing member status to ERROR.");
14 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
15 call mtr.add_suppression("\\[GCS\\] read failed");
16 call mtr.add_suppression("Started auto-rejoin procedure attempt*");
17 call mtr.add_suppression("Auto-rejoin procedure attempt*");
18 call mtr.add_suppression("Unable to confirm whether the server has left the group or not. Check performance_schema.replication_group_members to check group membership information.");
19 SET sql_log_bin = 1;
20 include/gr_autorejoin_monitoring.inc
21 SET @debug_saved = @@GLOBAL.DEBUG;
22 SET @@GLOBAL.DEBUG='+d,group_replication_rejoin_long_retry';
23 SET @@GLOBAL.DEBUG='+d,group_replication_fail_rejoin';
24 SET @@GLOBAL.DEBUG='+d,group_replication_stop_before_rejoin_loop';
25 SET @@GLOBAL.DEBUG='+d,group_replication_stop_before_rejoin';
26 include/start_and_bootstrap_group_replication.inc
27 [connection server2]
28 include/start_group_replication.inc
29 [connection server3]
30 include/start_group_replication.inc
31
32 ####
33 # 1) Provoke a member expel.
34 ####
35
36 [connection server1]
37 SET GLOBAL group_replication_autorejoin_tries = 3;
38 include/gr_expel_member_from_group.inc
39 SET SESSION sql_log_bin = 0;
40 CREATE TABLE pid_table(pid_no INT PRIMARY KEY);
41 LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
42 DROP TABLE pid_table;
43 SET SESSION sql_log_bin = 1;
44
45 ####
46 # 2) Verify that the auto-rejoin process is ongoing.
47 ####
48
49 SET DEBUG_SYNC = "now WAIT_FOR signal.autorejoin_entering_loop";
50 include/assert.inc [Auto-rejoin should be running]
51 SET DEBUG_SYNC = "now SIGNAL signal.autorejoin_enter_loop";
52 SET DEBUG_SYNC = "now WAIT_FOR signal.autorejoin_waiting";
53 include/assert.inc [Auto-rejoin should be running]
54 include/assert.inc [super_read_only should be enabled]
55
56 ####
57 # 2.1) Verify that we can see the number of retries being incremented
58 # until depleted.
59 ####
60
61 include/assert.inc [We should have attempted 1 rejoins]
62
63 ####
64 # 2.2) Verify that we can infer the time remaining until the next
65 # retry.
66 ####
67
68 include/assert.inc [Time remaining should be less than 5 mins]
69 SET DEBUG_SYNC = "now SIGNAL signal.autorejoin_continue";
70 SET DEBUG_SYNC = "now WAIT_FOR signal.autorejoin_waiting";
71 include/assert.inc [Auto-rejoin should be running]
72 include/assert.inc [super_read_only should be enabled]
73
74 ####
75 # 2.1) Verify that we can see the number of retries being incremented
76 # until depleted.
77 ####
78
79 include/assert.inc [We should have attempted 2 rejoins]
80
81 ####
82 # 2.2) Verify that we can infer the time remaining until the next
83 # retry.
84 ####
85
86 include/assert.inc [Time remaining should be less than 5 mins]
87 SET DEBUG_SYNC = "now SIGNAL signal.autorejoin_continue";
88 SET DEBUG_SYNC = "now WAIT_FOR signal.autorejoin_waiting";
89 include/assert.inc [Auto-rejoin should be running]
90 include/assert.inc [super_read_only should be enabled]
91
92 ####
93 # 2.1) Verify that we can see the number of retries being incremented
94 # until depleted.
95 ####
96
97 include/assert.inc [We should have attempted 3 rejoins]
98
99 ####
100 # 2.2) Verify that we can infer the time remaining until the next
101 # retry.
102 ####
103
104 include/assert.inc [Time remaining should be less than 5 mins]
105 SET DEBUG_SYNC = "now SIGNAL signal.autorejoin_continue";
106
107 ####
108 # 3) Verify that we see the timestamp of the last auto-rejoin process.
109 ####
110
111
112 ####
113 # 4) Verify that we can see the number of times the auto-rejoin process
114 # was run.
115 ####
116
117 include/assert.inc [There should only be one auto-rejoin process triggered]
118 SET @@GLOBAL.DEBUG='-d,group_replication_stop_before_rejoin';
119 SET @@GLOBAL.DEBUG='-d,group_replication_stop_before_rejoin_loop';
120 SET @@GLOBAL.DEBUG='-d,group_replication_stop_rejoin_long_retry';
121 include/stop_group_replication.inc
122 include/start_group_replication.inc
123
124 ####
125 # 5) Cleanup.
126 ####
127
128 SET @@GLOBAL.DEBUG = @debug_saved;
129 SET GLOBAL group_replication_autorejoin_tries = default;
130 include/gr_end_autorejoin_monitoring.inc
131 include/group_replication_end.inc