Debian Codegraph @

mysql-test/suite/group_replication/r/gr_primary_mode_group_operations_01.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 include/start_and_bootstrap_group_replication.inc
7
8 # 1. Execute a switch to multi primary mode, it must be a no op since the
9 # group is already on multi primary mode.
10 SELECT group_replication_switch_to_multi_primary_mode();
11 group_replication_switch_to_multi_primary_mode()
12 The group is already on multi-primary mode.
13 [connection server2]
14
15 # 2. Executing a mode change or primary election on an OFFLINE member
16 # must fail.
17 SELECT group_replication_set_as_primary("MEMBER1_UUID");
18 ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Member must be ONLINE and in the majority partition.
19 SELECT group_replication_switch_to_multi_primary_mode();
20 ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Member must be ONLINE and in the majority partition.
21 SELECT group_replication_switch_to_single_primary_mode();
22 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Member must be ONLINE and in the majority partition.
23 SELECT group_replication_switch_to_single_primary_mode("MEMBER1_UUID");
24 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Member must be ONLINE and in the majority partition.
25
26 # 3. Executing a mode change or primary election on a RECOVERING member
27 # must fail.
28 [connection server2]
29 SET @@GLOBAL.DEBUG='+d,recovery_thread_wait_before_finish';
30 include/start_group_replication.inc
31 SELECT group_replication_set_as_primary("MEMBER1_UUID");
32 ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Member must be ONLINE and in the majority partition.
33 SELECT group_replication_switch_to_multi_primary_mode();
34 ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Member must be ONLINE and in the majority partition.
35 SELECT group_replication_switch_to_single_primary_mode();
36 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Member must be ONLINE and in the majority partition.
37 SELECT group_replication_switch_to_single_primary_mode("MEMBER1_UUID");
38 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Member must be ONLINE and in the majority partition.
39
40 # 4. Allow recovery to complete.
41 [connection server2]
42 SET DEBUG_SYNC= "now WAIT_FOR signal.recovery_thread_wait_before_finish_reached";
43 SET @@GLOBAL.DEBUG='-d,recovery_thread_wait_before_finish';
44 SET DEBUG_SYNC= "now SIGNAL signal.recovery_end";
45 include/gr_wait_for_member_state.inc
46 SET DEBUG_SYNC= 'RESET';
47
48 # 5. Executing a mode change or primary election on an ERRORed member
49 # must fail.
50 CREATE TABLE test.t1 (a INT PRIMARY KEY);
51 set session sql_log_bin=0;
52 INSERT INTO test.t1 VALUES (1);
53 set session sql_log_bin=1;
54 include/rpl_sync.inc
55 [connection server1]
56 INSERT INTO test.t1 VALUES (1);
57 [connection server2]
58 include/gr_wait_for_member_state.inc
59 SELECT group_replication_set_as_primary("MEMBER1_UUID");
60 ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Member must be ONLINE and in the majority partition.
61 SELECT group_replication_switch_to_multi_primary_mode();
62 ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Member must be ONLINE and in the majority partition.
63 SELECT group_replication_switch_to_single_primary_mode();
64 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Member must be ONLINE and in the majority partition.
65 SELECT group_replication_switch_to_single_primary_mode("MEMBER1_UUID");
66 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Member must be ONLINE and in the majority partition.
67
68 # Rectify the cause of error and bring back member ONLINE.
69 include/stop_group_replication.inc
70 set session sql_log_bin=0;
71 TRUNCATE TABLE t1;
72 set session sql_log_bin=1;
73 include/start_group_replication.inc
74
75 # 6. Lock a table and try to execute a mode change. It must fail.
76 LOCK TABLE t1 WRITE;
77 SELECT group_replication_set_as_primary("MEMBER1_UUID");
78 ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Can't execute the given operation because you have active locked tables.
79 SELECT group_replication_switch_to_multi_primary_mode();
80 ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Can't execute the given operation because you have active locked tables.
81 SELECT group_replication_switch_to_single_primary_mode();
82 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Can't execute the given operation because you have active locked tables.
83 SELECT group_replication_switch_to_single_primary_mode("MEMBER1_UUID");
84 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Can't execute the given operation because you have active locked tables.
85 UNLOCK TABLES;
86 DROP TABLE t1;
87 include/rpl_sync.inc
88
89 # 7. Kill server1 to create a network partition on group.
90 [connection server1]
91 [connection server2]
92 include/gr_wait_for_member_state.inc
93
94 # 8. Executing a mode change or primary election on a network partition
95 # must fail.
96 SELECT group_replication_set_as_primary("MEMBER1_UUID");
97 ERROR HY000: Can't initialize function 'group_replication_set_as_primary'; Member must be ONLINE and in the majority partition.
98 SELECT group_replication_switch_to_multi_primary_mode();
99 ERROR HY000: Can't initialize function 'group_replication_switch_to_multi_primary_mode'; Member must be ONLINE and in the majority partition.
100 SELECT group_replication_switch_to_single_primary_mode();
101 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Member must be ONLINE and in the majority partition.
102 SELECT group_replication_switch_to_single_primary_mode("MEMBER1_UUID");
103 ERROR HY000: Can't initialize function 'group_replication_switch_to_single_primary_mode'; Member must be ONLINE and in the majority partition.
104
105 # 9. Cleanup.
106 [connection server_1]
107 include/rpl_reconnect.inc
108 [connection server2]
109 set session sql_log_bin=0;
110 call mtr.add_suppression("Timeout while waiting for the group communication engine to exit!");
111 call mtr.add_suppression("The member has failed to gracefully leave the group.");
112 call mtr.add_suppression("read failed");
113 call mtr.add_suppression("Could not execute Write_rows event on table test.t1");
114 call mtr.add_suppression("The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.");
115 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
116 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
117 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
118 call mtr.add_suppression("The replica coordinator and worker threads are stopped");
119 set session sql_log_bin=1;
120 include/group_replication_end.inc