Debian Codegraph @

mysql-test/suite/group_replication/r/gr_variables_default_values.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 SET @@GLOBAL.group_replication_ip_allowlist= "AUTOMATIC";
8 include/start_and_bootstrap_group_replication.inc
9 SET @@GLOBAL.group_replication_auto_increment_increment= default;
10 ERROR 42000: Variable 'group_replication_auto_increment_increment' can't be set to the value of 'DEFAULT'
11 SET @@GLOBAL.group_replication_compression_threshold= default;
12 ERROR 42000: Variable 'group_replication_compression_threshold' can't be set to the value of 'DEFAULT'
13 SET @@GLOBAL.group_replication_single_primary_mode= default;
14 ERROR 42000: Variable 'group_replication_single_primary_mode' can't be set to the value of 'DEFAULT'
15 SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= default;
16 ERROR 42000: Variable 'group_replication_enforce_update_everywhere_checks' can't be set to the value of 'DEFAULT'
17 SET @@GLOBAL.group_replication_group_name= default;
18 ERROR 42000: Variable 'group_replication_group_name' can't be set to the value of 'DEFAULT'
19 SET @@GLOBAL.group_replication_gtid_assignment_block_size= default;
20 ERROR 42000: Variable 'group_replication_gtid_assignment_block_size' can't be set to the value of 'DEFAULT'
21 SET @@GLOBAL.group_replication_ip_allowlist= default;
22 ERROR 42000: Variable 'group_replication_ip_allowlist' can't be set to the value of 'DEFAULT'
23 SET @@GLOBAL.group_replication_communication_max_message_size= default;
24 include/stop_group_replication.inc
25 # Take backup of group replication variables
26 #
27 # Test Unit#1
28 # Set global/session group replication variables to default.
29 # Curently there are 61 group replication variables.
30 #
31 include/assert.inc [There are 61 GR variables at present.]
32 SET @@GLOBAL.group_replication_auto_increment_increment= default;
33 ERROR 42000: Variable 'group_replication_auto_increment_increment' can't be set to the value of 'DEFAULT'
34 SET @@GLOBAL.group_replication_compression_threshold= default;
35 ERROR 42000: Variable 'group_replication_compression_threshold' can't be set to the value of 'DEFAULT'
36 SET @@GLOBAL.group_replication_single_primary_mode= default;
37 ERROR 42000: Variable 'group_replication_single_primary_mode' can't be set to the value of 'DEFAULT'
38 SET @@GLOBAL.group_replication_enforce_update_everywhere_checks= default;
39 ERROR 42000: Variable 'group_replication_enforce_update_everywhere_checks' can't be set to the value of 'DEFAULT'
40 SET @@GLOBAL.group_replication_group_name= default;
41 ERROR 42000: Variable 'group_replication_group_name' can't be set to the value of 'DEFAULT'
42 SET @@GLOBAL.group_replication_gtid_assignment_block_size= default;
43 ERROR 42000: Variable 'group_replication_gtid_assignment_block_size' can't be set to the value of 'DEFAULT'
44 SET @@GLOBAL.group_replication_ip_allowlist= default;
45 ERROR 42000: Variable 'group_replication_ip_allowlist' can't be set to the value of 'DEFAULT'
46 SET @@GLOBAL.group_replication_allow_local_lower_version_join= default;
47 SET @@GLOBAL.group_replication_bootstrap_group= default;
48 SET @@GLOBAL.group_replication_components_stop_timeout= default;
49 SET @@GLOBAL.group_replication_force_members= default;
50 SET @@GLOBAL.group_replication_local_address= default;
51 SET @@GLOBAL.group_replication_group_seeds= default;
52 SET @@GLOBAL.group_replication_poll_spin_loops= default;
53 SET @@GLOBAL.group_replication_recovery_complete_at= default;
54 SET @@GLOBAL.group_replication_recovery_reconnect_interval= default;
55 SET @@GLOBAL.group_replication_recovery_retry_count= default;
56 SET @@GLOBAL.group_replication_recovery_ssl_ca= default;
57 SET @@GLOBAL.group_replication_recovery_ssl_capath= default;
58 SET @@GLOBAL.group_replication_recovery_ssl_cert= default;
59 SET @@GLOBAL.group_replication_recovery_ssl_cipher= default;
60 SET @@GLOBAL.group_replication_recovery_ssl_crl= default;
61 SET @@GLOBAL.group_replication_recovery_ssl_crlpath= default;
62 SET @@GLOBAL.group_replication_recovery_ssl_key= default;
63 SET @@GLOBAL.group_replication_recovery_ssl_verify_server_cert= default;
64 SET @@GLOBAL.group_replication_recovery_use_ssl= default;
65 SET @@GLOBAL.group_replication_ssl_mode= default;
66 SET @@GLOBAL.group_replication_start_on_boot= default;
67 SET @@GLOBAL.group_replication_communication_debug_options= default;
68 SET @@GLOBAL.group_replication_transaction_size_limit= default;
69 SET @@GLOBAL.group_replication_unreachable_majority_timeout= default;
70 SET @@GLOBAL.group_replication_member_weight= default;
71 SET @@GLOBAL.group_replication_recovery_public_key_path= default;
72 SET @@GLOBAL.group_replication_recovery_get_public_key= default;
73 SET @@GLOBAL.group_replication_exit_state_action= default;
74 SET @@GLOBAL.group_replication_member_expel_timeout= default;
75 SET @@GLOBAL.group_replication_consistency= default;
76 SET @@GLOBAL.group_replication_communication_max_message_size= default;
77 SET @@GLOBAL.group_replication_autorejoin_tries= default;
78 SET @@GLOBAL.group_replication_message_cache_size= default;
79 SET @@GLOBAL.group_replication_recovery_compression_algorithms= default;
80 SET @@GLOBAL.group_replication_recovery_zstd_compression_level= default;
81 SET @@GLOBAL.group_replication_recovery_tls_version= default;
82 SET @@GLOBAL.group_replication_recovery_tls_ciphersuites= default;
83 SET @@GLOBAL.group_replication_advertise_recovery_endpoints = default;
84 SET @@GLOBAL.group_replication_view_change_uuid= default;
85 SET @@GLOBAL.group_replication_communication_stack = default;
86 SET @@GLOBAL.group_replication_paxos_single_leader = default;
87 SET @@SESSION.group_replication_consistency= default;
88 #
89 # Test Unit#2
90 # Verify default values of the group replication variables.
91 #
92 include/assert.inc [Default group_replication_allow_local_lower_version_join is OFF/0]
93 include/assert.inc [Default group_replication_auto_increment_increment is 7]
94 include/assert.inc [Default group_replication_bootstrap_group is OFF/0]
95 include/assert.inc [Default group_replication_components_stop_timeout is 300]
96 include/assert.inc [Default group_replication_compression_threshold is 1000000]
97 include/assert.inc [Default group_replication_force_members is ""(EMPTY)]
98 include/assert.inc [Default group_replication_ip_allowlist is AUTOMATIC]
99 include/assert.inc [Default group_replication_local_address is ""(EMPTY)]
100 include/assert.inc [Default group_replication_group_seeds is ""(EMPTY)]
101 include/assert.inc [Default group_replication_poll_spin_loops is 0]
102 include/assert.inc [Default group_replication_recovery_complete_at is TRANSACTIONS_APPLIED]
103 include/assert.inc [Default group_replication_recovery_reconnect_interval is 60]
104 include/assert.inc [Default group_replication_recovery_retry_count is 10]
105 include/assert.inc [Default group_replication_recovery_ssl_ca is ""(EMPTY)]
106 include/assert.inc [Default group_replication_recovery_ssl_capath is ""(EMPTY)]
107 include/assert.inc [Default group_replication_recovery_ssl_cert is ""(EMPTY)]
108 include/assert.inc [Default group_replication_recovery_ssl_cipher is ""(EMPTY)]
109 include/assert.inc [Default group_replication_recovery_ssl_crl is ""(EMPTY)]
110 include/assert.inc [Default group_replication_recovery_ssl_crlpath is ""(EMPTY)]
111 include/assert.inc [Default group_replication_recovery_ssl_key is ""(EMPTY)]
112 include/assert.inc [Default group_replication_recovery_ssl_verify_server_cert is OFF/0]
113 include/assert.inc [Default group_replication_recovery_use_ssl is OFF/0]
114 include/assert.inc [Default group_replication_ssl_mode is DISABLED]
115 include/assert.inc [Default group_replication_start_on_boot is ON/1]
116 include/assert.inc [Default group_replication_transaction_size_limit is 150000000]
117 include/assert.inc [Default group_replication_communication_debug_options is "GCS_DEBUG_NONE"]
118 include/assert.inc [Default group_replication_unreachable_majority_timeout is 0]
119 include/assert.inc [Default group_replication_member_weight is 50]
120 include/assert.inc [Default group_replication_recovery_public_key_path is ""(EMPTY)]
121 include/assert.inc [Default group_replication_recovery_get_public_key is OFF/0]
122 include/assert.inc [Default group_replication_exit_state_action is READ_ONLY]
123 include/assert.inc [Default group_replication_member_expel_timeout is 5]
124 include/assert.inc [Default group_replication_consistency is EVENTUAL]
125 include/assert.inc [Default group_replication_consistency is EVENTUAL]
126 include/assert.inc [Default group_replication_communication_max_message_size is 10485760]
127 include/assert.inc [Default group_replication_autorejoin_tries is 3]
128 include/assert.inc [Default group_replication_message_cache_size is 1073741824]
129 include/assert.inc [Default group_replication_recovery_compression_algorithms is "uncompressed"]
130 include/assert.inc [Default group_replication_recovery_zstd_compression_level is 3]
131 include/assert.inc [Default group_replication_recovery_tls_version is "TLSv1.2,TLSv1.3"]
132 include/assert.inc [Default group_replication_recovery_tls_ciphersuites is NULL]
133 include/assert.inc [Default group_replication_advertise_recovery_endpoints is "DEFAULT"]
134 include/assert.inc [Default group_replication_view_change_uuid is "AUTOMATIC"]
135 include/assert.inc [Default group_replication_communication_stack is XCom]
136 include/assert.inc [Default group_replication_paxos_single_leader is 0]
137 #
138 # Clean up
139 #
140 Warnings:
141 Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
142 Warnings:
143 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
144 include/group_replication_end.inc