Debian Codegraph @

mysql-test/suite/group_replication/t/gr_applier_channel_reset.test

raw
1 ################################################################################
2 # This test proves Group replication does not delete group_replication_applier
3 # channel on start of group replication post reset master.
4 #
5 # Test:
6 # 0. The test requires two servers: M1 and M2.
7 # 1. Bootstrap M1.
8 # 2. Create user u1 on M2.
9 # Add PRIVILEGE_CHECKS_USER for u1 for GR applier channel.
10 # Reset master.
11 # 3. Start GR fails.
12 # Assert value of PRIVILEGE_CHECKS_USER is preserved.
13 # 4. Give privileges to u1.
14 # Start GR.
15 # Assert value of PRIVILEGE_CHECKS_USER is preserved.
16 # 5. Stop GR.
17 # Assert value of PRIVILEGE_CHECKS_USER is preserved.
18 # 6. Cleanup.
19 ################################################################################
20
21 --source include/have_group_replication_plugin.inc
22 --let $rpl_skip_group_replication_start= 1
23 --source include/group_replication.inc
24
25 --echo
26 --echo # 1. Bootstrap M1.
27 --echo
28 --source include/start_and_bootstrap_group_replication.inc
29
30 --echo
31 --echo # 2. Create user u1 on M2.
32 --echo # Add PRIVILEGE_CHECKS_USER for u1 for GR applier channel.
33 --echo # Reset master.
34 --echo
35 --let $rpl_connection_name= server2
36 --source include/rpl_connection.inc
37
38 SET SQL_LOG_BIN=0;
39 CREATE USER 'u1'@'localhost';
40 SET SQL_LOG_BIN=1;
41
42 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = 'u1'@'localhost' FOR CHANNEL "group_replication_applier";
43 CHANGE REPLICATION SOURCE TO PRIVILEGE_CHECKS_USER = 'root'@'localhost' FOR CHANNEL "group_replication_recovery";
44
45 RESET MASTER;
46
47 --echo
48 --echo # 3. Start GR fails.
49 --echo # Assert value of PRIVILEGE_CHECKS_USER is preserved.
50 --echo
51
52 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
53 --eval SET GLOBAL GROUP_REPLICATION_GROUP_NAME = "$group_replication_group_name"
54
55 # One of three things can happen:
56 # A. The applier fails after the join and the member leaves the group
57 # but the START GROUP_REPLICATION command does not fail
58 # B. The applier fails after initialization and sets the state to ERROR,
59 # making the group join fail that makes the START GROUP_REPLICATION
60 # command fail with a generic ER_GROUP_REPLICATION_CONFIGURATION.
61 # C. The applier fails and its initialization processes catches the error.
62 # During the start, it is known that the applier failed so the START
63 # GROUP_REPLICATION fails with: ER_GROUP_REPLICATION_APPLIER_INIT_ERROR
64 --error 0, ER_GROUP_REPLICATION_CONFIGURATION, ER_GROUP_REPLICATION_APPLIER_INIT_ERROR
65 START GROUP_REPLICATION;
66
67 --let $pcu_count = `SELECT COUNT(*) FROM performance_schema.replication_applier_configuration WHERE CHANNEL_NAME= "group_replication_applier" AND PRIVILEGE_CHECKS_USER = "'u1'@'localhost'"`
68 --let $assert_text= PRIVILEGE_CHECKS_USER has correct value for channel group_replication_applier
69 --let $assert_cond= $pcu_count = 1
70 --source include/assert.inc
71
72 --echo
73 --echo # 4. Give privileges to u1.
74 --echo # Start GR.
75 --echo # Assert value of PRIVILEGE_CHECKS_USER is preserved.
76 --echo
77 SET GLOBAL super_read_only= 0;
78 SET SQL_LOG_BIN=0;
79 GRANT REPLICATION_APPLIER, SYSTEM_VARIABLES_ADMIN ON *.* TO 'u1'@'localhost';
80 SET SQL_LOG_BIN=1;
81 --source include/start_group_replication.inc
82
83 --let $pcu_count = `SELECT COUNT(*) FROM performance_schema.replication_applier_configuration WHERE (CHANNEL_NAME= "group_replication_applier" AND PRIVILEGE_CHECKS_USER = "'u1'@'localhost'") OR (CHANNEL_NAME= "group_replication_recovery" AND PRIVILEGE_CHECKS_USER = "'root'@'localhost'")`
84 --let $assert_text= PRIVILEGE_CHECKS_USER has correct value for channel group_replication_applier and group_replication_recovery
85 --let $assert_cond= $pcu_count = 2
86 --source include/assert.inc
87
88 --echo
89 --echo # 5. Stop GR.
90 --echo # Assert value of PRIVILEGE_CHECKS_USER is preserved.
91 --echo
92 --source include/stop_group_replication.inc
93
94 --let $pcu_count = `SELECT COUNT(*) FROM performance_schema.replication_applier_configuration WHERE (CHANNEL_NAME= "group_replication_applier" AND PRIVILEGE_CHECKS_USER = "'u1'@'localhost'") OR (CHANNEL_NAME= "group_replication_recovery" AND PRIVILEGE_CHECKS_USER = "'root'@'localhost'")`
95 --let $assert_text= PRIVILEGE_CHECKS_USER has correct value for channel group_replication_applier and group_replication_recovery
96 --let $assert_cond= $pcu_count = 2
97 --source include/assert.inc
98
99 --echo
100 --echo # 6. Cleanup.
101 --echo
102 SET GLOBAL super_read_only= 0;
103 SET SQL_LOG_BIN=0;
104 DROP USER 'u1'@'localhost';
105 SET SQL_LOG_BIN=1;
106
107 SET SESSION sql_log_bin = 0;
108 call mtr.add_suppression(" Replica SQL for channel 'group_replication_applier': PRIVILEGE_CHECKS_USER for replication channel *");
109 call mtr.add_suppression("The applier thread execution was aborted. *");
110 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
111 call mtr.add_suppression("Unable to confirm whether the server has left the group or not. *");
112 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
113 call mtr.add_suppression("Unable to initialize the Group Replication applier module.");
114 call mtr.add_suppression("There was a previous plugin error while the member joined the group. The member will now exit the group.");
115 SET SESSION sql_log_bin = 1;
116
117 --source include/group_replication_end.inc