Debian Codegraph @

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

raw
1 include/group_replication.inc
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 SET SQL_LOG_BIN=0;
9 CREATE TABLE test.gms_listener_example(log_message TEXT);
10 SET SQL_LOG_BIN=1;
11 [connection server2]
12 # Adding debug point 'register_gms_listener_example' to @@GLOBAL.debug
13 SET SQL_LOG_BIN=0;
14 CREATE TABLE test.gms_listener_example(log_message TEXT);
15 SET SQL_LOG_BIN=1;
16 ### Scenario 1: SERVER BOOTSTRAPS GROUP
17 ### Expected:
18 ### - Myself: 1 VIEW CHANGED, 2 STATE CHANGED
19 ### - Others: N/A
20 ##########################################################################
21 [connection server1]
22 include/start_and_bootstrap_group_replication.inc
23 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:1]
24 include/assert.inc [Assert that there are 2 notifications logged of type STATE %:1]
25 include/assert.inc [Assert that there are 3 notifications logged]
26 [Truncating gms_listener_example Table]
27 ### Scenario 2: MEMBER JOINS, but blocks recoverying
28 ### Expected:
29 ### - Myself: 1 VIEW CHANGED, 1 STATE CHANGED
30 ### - Others: 1 VIEW CHANGED, 1 STATE CHANGED
31 ##########################################################################
32 [connection server2]
33 SET @@GLOBAL.DEBUG='+d,recovery_thread_wait_before_finish';
34 include/start_group_replication.inc
35 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:2]
36 include/assert.inc [Assert that there are 1 notifications logged of type STATE %:2]
37 include/assert.inc [Assert that there are 2 notifications logged]
38 [Truncating gms_listener_example Table]
39 [connection server1]
40 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:2]
41 include/assert.inc [Assert that there are 1 notifications logged of type STATE %:2]
42 include/assert.inc [Assert that there are 2 notifications logged]
43 [Truncating gms_listener_example Table]
44 ### Scenario 3: MEMBER RECOVERS JOINS
45 ### Expected:
46 ### - Myself: 1 STATE CHANGED
47 ### - Others: 1 STATE CHANGED
48 ##########################################################################
49 [connection server2]
50 SET DEBUG_SYNC= "now WAIT_FOR signal.recovery_thread_wait_before_finish_reached";
51 SET @@GLOBAL.DEBUG='-d,recovery_thread_wait_before_finish';
52 SET DEBUG_SYNC= "now SIGNAL signal.recovery_end";
53 include/gr_wait_for_member_state.inc
54 include/assert.inc [Assert that there are 1 notifications logged of type STATE %:2]
55 include/assert.inc [Assert that there are 1 notifications logged]
56 [Truncating gms_listener_example Table]
57 [connection server1]
58 include/assert.inc [Assert that there are 1 notifications logged of type STATE %:2]
59 include/assert.inc [Assert that there are 1 notifications logged]
60 [Truncating gms_listener_example Table]
61 ### Scenario 4: SERVER LEAVES(ERROR), SERVER LEAVES(OFFLINE)
62 ### Expected:
63 ### - Myself (leaving): 1 VIEW CHANGED, 1 STATE CHANGED
64 ### - Others: 1 VIEW CHANGED
65 ##########################################################################
66 [connection server2]
67 SET SESSION sql_log_bin=0;
68 call mtr.add_suppression("Table 'tab1' already exists");
69 call mtr.add_suppression("The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group");
70 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
71 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
72 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped,*");
73 SET SESSION sql_log_bin=1;
74 SET SESSION sql_log_bin=0;
75 CREATE TABLE test.tab1 (a INT PRIMARY KEY);
76 SET SESSION sql_log_bin=1;
77 [connection server1]
78 CREATE TABLE test.tab1 (a INT PRIMARY KEY);
79 [connection server2]
80 include/gr_wait_for_member_state.inc
81 include/assert.inc [Assert that there are 1 notifications logged of type STATE %:%]
82 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:%]
83 include/assert.inc [Assert that there are 2 notifications logged]
84 [Truncating gms_listener_example Table]
85 [connection server1]
86 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:3]
87 include/assert.inc [Assert that there are 1 notifications logged]
88 [Truncating gms_listener_example Table]
89 [connection server2]
90 include/stop_group_replication.inc
91 include/gr_wait_for_member_state.inc
92 include/assert.inc [Assert that there are 1 notifications logged of type STATE %:%]
93 include/assert.inc [Assert that there are 1 notifications logged]
94 [Truncating gms_listener_example Table]
95 SET SESSION sql_log_bin=0;
96 DROP TABLE test.tab1;
97 SET SESSION sql_log_bin=1;
98 [connection server1]
99 include/stop_group_replication.inc
100 # Removing debug point 'register_gms_listener_example' from @@GLOBAL.debug
101 include/start_and_bootstrap_group_replication.inc
102 [connection server2]
103 # Removing debug point 'register_gms_listener_example' from @@GLOBAL.debug
104 SET DEBUG_SYNC= 'RESET';
105 include/start_group_replication.inc
106 DROP TABLE gms_listener_example;
107 DROP TABLE test.tab1;
108 include/rpl_sync.inc
109 include/group_replication_end.inc