Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=4]
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 include/start_group_replication.inc
8 include/start_group_replication.inc
9 #######################################################################
10 # 1. Check the defaults of group_replication_auto_increment_increment,
11 # auto_increment_increment and auto_increment_offset.
12 #######################################################################
13 include/assert.inc [The default value of group_replication_auto_increment_increment for server2 should be 7]
14 include/assert.inc [The default value of auto_increment_increment for server2 should be 1]
15 include/assert.inc [The default value of auto_increment_offset for server2 should be 1]
16 #######################################################################
17 # 2. Check that the value of group_replication_auto_increment_increment
18 # can be set before GR start, but its effects on
19 # auto_increment_increment and auto_increment_offset do not happen.
20 #######################################################################
21 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 3;
22 include/assert.inc [The value of group_replication_auto_increment_increment is set to 3]
23 include/assert.inc [The value of auto_increment_increment is not affected]
24 include/assert.inc [The value of auto_increment_offset is not affected]
25 include/start_group_replication.inc
26 #########################################################################
27 # 3. Check that the effects of group_replication_auto_increment_increment
28 # on auto_increment_increment and auto_increment_offset happen on
29 # starting GR.
30 #########################################################################
31 include/assert.inc [The value of group_replication_auto_increment_increment is still 3]
32 include/assert.inc [The value of auto_increment_increment is set to 3]
33 include/assert.inc [The value of auto_increment_offset is set to 2]
34 ############################################################
35 # 4. When the number of members is bigger than
36 # the auto_increment_increment value, an error is logged.
37 ############################################################
38 Matching lines are:
39 DATE_TIME [ERROR] [Repl] Plugin group_replication reported: 'Group contains 4 members which is greater than group_replication_auto_increment_increment value of 3. This can lead to a higher transactional abort rate.'
40 Occurrences of 'Group contains 4 members which is greater than group_replication_auto_increment_increment value of 3. This can lead to a higher transactional abort rate.' in the input file: 1
41 ############################################################
42 # 5. When auto_increment_increment and auto_increment_offset
43 # not set to default value
44 # i.e. auto_increment_increment= 1
45 # auto_increment_offset= 1
46 # group_replication should not update their value.
47 ############################################################
48 include/stop_group_replication.inc
49 SET GLOBAL AUTO_INCREMENT_INCREMENT= 5;
50 SET GLOBAL AUTO_INCREMENT_OFFSET= 5;
51 include/start_group_replication.inc
52 include/assert.inc [The value of auto_increment_increment for server2 should be 5]
53 include/assert.inc [The value of auto_increment_offset for server2 should be 5]
54 include/stop_group_replication.inc
55 include/assert.inc [The value of auto_increment_increment for server2 should be 5]
56 include/assert.inc [The value of auto_increment_offset for server2 should be 5]
57 ############################################################
58 # 6. When auto_increment_increment and auto_increment_offset are equal
59 # to 1, then verify if plugin on start set auto_increment_increment
60 # variable equal to group_replication_auto_increment_increment value.
61 ############################################################
62 SET GLOBAL AUTO_INCREMENT_INCREMENT= 1;
63 SET GLOBAL AUTO_INCREMENT_OFFSET= 1;
64 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 4;
65 include/start_group_replication.inc
66 include/assert.inc [The value of auto_increment_increment for server2 should be 4]
67 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
68 ############################################################
69 # 7. When group_replication is stopped verify that plugin reset
70 # auto_increment_increment and auto_increment_offset values to 1.
71 ############################################################
72 include/stop_group_replication.inc
73 include/assert.inc [The value of auto_increment_increment for server2 should be 1]
74 include/assert.inc [The value of auto_increment_offset for server2 should be 1]
75 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 1;
76 ############################################################
77 # 8. Verify start/stop group_replication plugin doesn't affect
78 # setting auto_increment_increment from
79 # group_replication_auto_increment_increment value.
80 ############################################################
81 include/start_group_replication.inc
82 include/assert.inc [The value of auto_increment_increment for server2 should be 1]
83 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
84 include/stop_group_replication.inc
85 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 9;
86 include/start_group_replication.inc
87 include/assert.inc [The value of auto_increment_increment for server2 should be 9]
88 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
89 ############################################################
90 # 9. Verify server restart doesn't affect setting
91 # auto_increment_increment from
92 # group_replication_auto_increment_increment value.
93 ############################################################
94 include/stop_group_replication.inc
95 include/assert.inc [The value of auto_increment_increment for server2 should be 1]
96 include/assert.inc [The value of auto_increment_offset for server2 should be 1]
97 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 1;
98 include/start_group_replication.inc
99 include/assert.inc [The value of auto_increment_increment for server2 should be 1]
100 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
101 # restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS
102 include/rpl_reconnect.inc
103 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 9;
104 include/start_group_replication.inc
105 include/assert.inc [The value of auto_increment_increment for server2 should be 9]
106 include/assert.inc [The value of auto_increment_offset for server2 should be 2]
107 ############################################################
108 # 10. Verify group_replication_auto_increment_increment can't be set
109 # when group_replication plugin is running.
110 ############################################################
111 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 9;
112 ERROR HY000: The group group_replication_auto_increment_increment cannot be changed when Group Replication is running
113 ############################################################
114 # 11. Validate that when user tries to set invalid values a
115 # error is thrown.
116 ############################################################
117 include/stop_group_replication.inc
118 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= -1;
119 ERROR 42000: The value -1 is not within the range of accepted values for the option group_replication_auto_increment_increment. The value must be between 1 and 65535 inclusive.
120 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 65536;
121 ERROR 42000: The value 65536 is not within the range of accepted values for the option group_replication_auto_increment_increment. The value must be between 1 and 65535 inclusive.
122 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 0;
123 ERROR 42000: The value 0 is not within the range of accepted values for the option group_replication_auto_increment_increment. The value must be between 1 and 65535 inclusive.
124 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 'a';
125 ERROR 42000: Incorrect argument type to variable 'group_replication_auto_increment_increment'
126 ############################################################
127 # 12. clean up and reset auto_increment variables value
128 ############################################################
129 SET GLOBAL GROUP_REPLICATION_AUTO_INCREMENT_INCREMENT= 7;
130 include/group_replication_end.inc