Debian Codegraph @

mysql-test/suite/group_replication/r/gr_notifications_quorum.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 [connection server1]
7 # Adding debug point 'register_gms_listener_example' to @@GLOBAL.debug
8 [connection server2]
9 # Adding debug point 'register_gms_listener_example' to @@GLOBAL.debug
10 SET SQL_LOG_BIN=0;
11 CREATE TABLE test.gms_listener_example(log_message TEXT);
12 SET SQL_LOG_BIN=1;
13 [connection server3]
14 # Adding debug point 'register_gms_listener_example' to @@GLOBAL.debug
15 SET SQL_LOG_BIN=0;
16 CREATE TABLE test.gms_listener_example(log_message TEXT);
17 SET SQL_LOG_BIN=1;
18 ### Scenario 7: SERVER UNREACHABLE
19 ### Expected:
20 ### - Correct Servers: 1 STATE CHANGED (and eventually a VIEW CHANGED)
21 ### - Failed server: N/A
22 ##########################################################
23 [connection server1]
24 include/start_and_bootstrap_group_replication.inc
25 [connection server2]
26 include/start_group_replication.inc
27 [connection server3]
28 include/start_group_replication.inc
29 include/rpl_gr_wait_for_number_of_members.inc
30 [connection server2]
31 include/rpl_gr_wait_for_number_of_members.inc
32 [connection server1]
33 include/rpl_gr_wait_for_number_of_members.inc
34 TRUNCATE gms_listener_example;
35 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
36 include/rpl_sync.inc
37 [connection server_3]
38 [connection server3]
39 # Kill and restart
40 [connection server_3]
41 [connection server1]
42 include/rpl_gr_wait_for_number_of_members.inc
43 include/assert.inc [Assert that there are 1 notifications logged of type STATE %:3]
44 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:4]
45 include/assert.inc [Assert that there are 2 notifications logged]
46 [Truncating gms_listener_example Table]
47 ### Scenario 8: MAJORITY UNREACHABLE
48 ### Expected:
49 ### - Correct Servers: 1 QUORUM LOST, 1 STATE CHANGED
50 ### - Failed Servers: N/A
51 ##########################################################
52 [connection server_2]
53 [connection server2]
54 # Kill and restart
55 [connection server_2]
56 [connection server1]
57 include/gr_wait_for_member_state.inc
58 include/assert.inc [Assert that there are 1 notifications logged of type QUORUM LOST: %:4]
59 include/assert.inc [Assert that there are 1 notifications logged of type STATE %:4]
60 include/assert.inc [Assert that there are 2 notifications logged]
61 [Truncating gms_listener_example Table]
62 ### Scenario 9: MAJORITY UNREACHABLE + FORCE MEMBERS
63 ### Expected:
64 ### - Correct Servers: 1 VIEW CHANGED
65 ### - Failed Servers: N/A
66 ##########################################################
67 [connection server_1]
68 include/assert.inc [group_replication_force_members is correct]
69 include/rpl_gr_wait_for_number_of_members.inc
70 include/assert.inc [No more unreachable servers in the P_S table.]
71 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:5]
72 include/assert.inc [Assert that there are 1 notifications logged]
73 [Truncating gms_listener_example Table]
74 include/stop_group_replication.inc
75 ### Scenario 10: MAJORITY UNREACHABLE + STOP
76 ### Expected:
77 ### - Correct Servers: 1 VIEW CHANGED, 1 STATE CHANGED
78 ### - Failed Servers: N/A
79 ##########################################################
80 [connection server1]
81 include/start_and_bootstrap_group_replication.inc
82 [connection server2]
83 include/start_group_replication.inc
84 [connection server_2]
85 [connection server2]
86 # Kill and restart
87 [connection server_2]
88 [connection server1]
89 include/gr_wait_for_member_state.inc
90 include/stop_group_replication.inc
91 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %: ]
92 include/assert.inc [Assert that there are 1 notifications logged of type STATE %:%]
93 include/assert.inc [Assert that there are 2 notifications logged]
94 [Truncating gms_listener_example Table]
95 [connection server1]
96 # Removing debug point 'register_gms_listener_example' from @@GLOBAL.debug
97 include/start_and_bootstrap_group_replication.inc
98 [connection server2]
99 include/start_group_replication.inc
100 [connection server3]
101 include/start_group_replication.inc
102 [connection server1]
103 DROP TABLE gms_listener_example;
104 include/rpl_sync.inc
105 include/group_replication_end.inc