Debian Codegraph @

mysql-test/suite/group_replication/r/gr_notifications_single_primary.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 SET SQL_LOG_BIN=0;
9 CREATE TABLE test.gms_listener_example(log_message TEXT);
10 SET SQL_LOG_BIN=1;
11 SET GLOBAL group_replication_enforce_update_everywhere_checks= OFF;
12 SET GLOBAL group_replication_single_primary_mode= ON;
13 SET GLOBAL group_replication_force_members='';
14 [connection server2]
15 # Adding debug point 'register_gms_listener_example' to @@GLOBAL.debug
16 SET SQL_LOG_BIN=0;
17 CREATE TABLE test.gms_listener_example(log_message TEXT);
18 SET SQL_LOG_BIN=1;
19 SET GLOBAL group_replication_enforce_update_everywhere_checks= OFF;
20 SET GLOBAL group_replication_single_primary_mode= ON;
21 SET GLOBAL group_replication_force_members='';
22 [connection server3]
23 # Adding debug point 'register_gms_listener_example' to @@GLOBAL.debug
24 SET SQL_LOG_BIN=0;
25 CREATE TABLE test.gms_listener_example(log_message TEXT);
26 SET SQL_LOG_BIN=1;
27 SET GLOBAL group_replication_enforce_update_everywhere_checks= OFF;
28 SET GLOBAL group_replication_single_primary_mode= ON;
29 SET GLOBAL group_replication_force_members='';
30 ### Scenario 5: SERVER BOOTSTRAPS+RECOVERS+PRIMARY ELECTION
31 ### Expected:
32 ### - Myself: 1 VIEW CHANGE, 2 STATE CHANGED, 1 ROLE CHANGED
33 ### - Others: N/A
34 ##################################################################
35 [connection server1]
36 include/start_and_bootstrap_group_replication.inc
37 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:1]
38 include/assert.inc [Assert that there are 2 notifications logged of type STATE %:1]
39 include/assert.inc [Assert that there are 1 notifications logged of type ROLE %:1]
40 include/assert.inc [Assert that there are 4 notifications logged]
41 [Truncating gms_listener_example Table]
42 ### Scenario 6: PRIMARY LEAVES the GROUP
43 ### Expected:
44 ### - Myself (old primary): 1 VIEW CHANGED, 1 STATE CHANGED, 1 ROLE CHANGED
45 ### - Others (new primary): 1 VIEW CHANGED, 1 ROLE CHANGED
46 ### - Others (secondary): 1 VIEW CHANGED, 1 ROLE CHANGED
47 ##################################################################
48 [connection server2]
49 include/start_group_replication.inc
50 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:2]
51 include/assert.inc [Assert that there are 2 notifications logged of type STATE %:2]
52 include/assert.inc [Assert that there are 3 notifications logged]
53 [Truncating gms_listener_example Table]
54 [connection server3]
55 include/start_group_replication.inc
56 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:3]
57 include/assert.inc [Assert that there are 2 notifications logged of type STATE %:3]
58 include/assert.inc [Assert that there are 3 notifications logged]
59 [Truncating gms_listener_example Table]
60 [connection server1]
61 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %2]
62 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:3]
63 include/assert.inc [Assert that there are 2 notifications logged of type STATE %:2]
64 include/assert.inc [Assert that there are 2 notifications logged of type STATE %:3]
65 include/assert.inc [Assert that there are 6 notifications logged]
66 [Truncating gms_listener_example Table]
67 include/rpl_sync.inc
68 include/stop_group_replication.inc
69 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %: ]
70 include/assert.inc [Assert that there are 1 notifications logged of type STATE %: ]
71 include/assert.inc [Assert that there are 1 notifications logged of type ROLE %:%]
72 include/assert.inc [Assert that there are 3 notifications logged]
73 [Truncating gms_listener_example Table]
74 [connection server2]
75 include/rpl_gr_wait_for_number_of_members.inc
76 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:4]
77 include/assert.inc [Assert that there are 1 notifications logged of type ROLE %:4]
78 include/assert.inc [Assert that there are 2 notifications logged]
79 [Truncating gms_listener_example Table]
80 [connection server3]
81 include/rpl_gr_wait_for_number_of_members.inc
82 include/assert.inc [Assert that there are 1 notifications logged of type VIEW %:4]
83 include/assert.inc [Assert that there are 1 notifications logged of type ROLE %:4]
84 include/assert.inc [Assert that there are 2 notifications logged]
85 [Truncating gms_listener_example Table]
86 [connection server2]
87 include/stop_group_replication.inc
88 [connection server3]
89 include/stop_group_replication.inc
90 [connection server1]
91 # Removing debug point 'register_gms_listener_example' from @@GLOBAL.debug
92 include/start_and_bootstrap_group_replication.inc
93 [connection server2]
94 # Removing debug point 'register_gms_listener_example' from @@GLOBAL.debug
95 include/start_group_replication.inc
96 [connection server3]
97 # Removing debug point 'register_gms_listener_example' from @@GLOBAL.debug
98 include/start_group_replication.inc
99 [connection server1]
100 DROP TABLE gms_listener_example;
101 include/rpl_sync.inc
102 include/group_replication_end.inc