Debian Codegraph @

mysql-test/suite/rpl/r/rpl_deprecations.result

raw
1 include/master-slave.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 master]
6 [connection slave]
7 include/stop_slave.inc
8 SET @@global.master_info_repository="TABLE";
9 Warnings:
10 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
11 SET @@global.master_info_repository="FILE";
12 Warnings:
13 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
14 SET @@global.master_info_repository="TABLE";
15 Warnings:
16 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
17 SET @@global.relay_log_info_repository="TABLE";
18 Warnings:
19 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
20 SET @@global.relay_log_info_repository="FILE";
21 Warnings:
22 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
23 SET @@global.relay_log_info_repository="TABLE";
24 Warnings:
25 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
26 SELECT @@global.log_bin_use_v1_row_events;
27 @@global.log_bin_use_v1_row_events
28 0
29 Warnings:
30 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
31 SET @@global.log_bin_use_v1_row_events = TRUE;
32 Warnings:
33 Warning 1287 '@@log_bin_use_v1_row_events' is deprecated and will be removed in a future release.
34 SELECT @@global.relay_log_info_file;
35 @@global.relay_log_info_file
36 relay-log.info
37 Warnings:
38 Warning 1287 '@@relay_log_info_file' is deprecated and will be removed in a future release.
39 SELECT @@global.slave_rows_search_algorithms;
40 @@global.slave_rows_search_algorithms
41 SCAN_METHOD,SCAN_METHOD
42 Warnings:
43 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
44 SET GLOBAL binlog_transaction_dependency_tracking = COMMIT_ORDER;
45 Warnings:
46 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
47 SET @@global.transaction_write_set_extraction='XXHASH64';
48 Warnings:
49 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
50 SET @@global.transaction_write_set_extraction='MURMUR32';
51 Warnings:
52 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
53 SET @@session.transaction_write_set_extraction='XXHASH64';
54 Warnings:
55 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
56 SET @@session.transaction_write_set_extraction='MURMUR32';
57 Warnings:
58 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
59 SET GLOBAL replica_parallel_type='LOGICAL_CLOCK';
60 Warnings:
61 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
62 SET GLOBAL replica_parallel_type='DATABASE';
63 Warnings:
64 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
65 SET GLOBAL replica_parallel_workers=0;
66 Warnings:
67 Warning 1287 '0' is deprecated and will be removed in a future release. Please use 1 instead
68 SET GLOBAL replica_parallel_workers=1;
69 SET GLOBAL binlog_transaction_dependency_tracking=COMMIT_ORDER;
70 Warnings:
71 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
72 SET GLOBAL binlog_transaction_dependency_tracking=WRITESET;
73 Warnings:
74 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
75 SET GLOBAL binlog_transaction_dependency_tracking=WRITESET_SESSION;
76 Warnings:
77 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
78 include/suppress_messages.inc
79 # Connection 1 un-suppresses message <.* is deprecated and will be removed in a future release.*>.
80 # Connection 2 un-suppresses message <.* is deprecated and will be removed in a future release.*>.
81 include/suppress_messages.inc
82 # Connection 1 un-suppresses message <The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.>.
83 # Connection 2 un-suppresses message <The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.>.
84 include/suppress_messages.inc
85 # Connection 1 suppresses message <The syntax '--master-retry-count' is deprecated and will be removed in a future release.*>.
86 # Connection 2 suppresses message <The syntax '--master-retry-count' is deprecated and will be removed in a future release.*>.
87 include/suppress_messages.inc
88 # Connection 1 suppresses message <The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.>.
89 # Connection 2 suppresses message <The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.>.
90 include/save_error_log_position.inc
91 include/rpl_restart_server.inc [server_number=2]
92 include/assert_error_log.inc [server: 2, pattern: 'binlog_format' is deprecated and will be removed in a future release.
93 '--sync-relay-log-info' is deprecated and will be removed in a future release.
94 The syntax '--master-info-repository' is deprecated and will be removed in a future release.
95 The syntax '--master-info-file' is deprecated and will be removed in a future release.
96 The syntax '--log-bin-use-v1-row-events' is deprecated and will be removed in a future release.
97 The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
98 The syntax '--relay-log-info-file' is deprecated and will be removed in a future release.
99 The syntax '--slave-rows-search-algorithms' is deprecated and will be removed in a future release.
100 The syntax '--transaction-write-set-extraction' is deprecated and will be removed in a future release.
101 The syntax '--disconnect-slave-event-count' is deprecated and will be removed in a future release.
102 The syntax '--abort-slave-event-count' is deprecated and will be removed in a future release.
103 The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
104 The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.
105 The syntax '--binlog-transaction-dependency-tracking' is deprecated and will be removed in a future release.
106 ]
107 SET PERSIST_ONLY relay_log_info_repository='FILE';
108 Warnings:
109 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
110 SET PERSIST_ONLY master_info_repository='TABLE';
111 Warnings:
112 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
113 SET PERSIST_ONLY transaction_write_set_extraction='MURMUR32';
114 Warnings:
115 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
116 SET PERSIST_ONLY transaction_write_set_extraction='XXHASH64';
117 Warnings:
118 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
119 SET PERSIST_ONLY replica_parallel_type='DATABASE';
120 Warnings:
121 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
122 SET PERSIST_ONLY replica_parallel_type='LOGICAL_CLOCK';
123 Warnings:
124 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
125 SET PERSIST_ONLY binlog_transaction_dependency_tracking=WRITESET_SESSION;
126 Warnings:
127 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
128 SET PERSIST_ONLY binlog_transaction_dependency_tracking=COMMIT_ORDER;
129 Warnings:
130 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
131 SET PERSIST_ONLY binlog_transaction_dependency_tracking=WRITESET;
132 Warnings:
133 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
134 SET PERSIST_ONLY replica_parallel_workers=0;
135 SET PERSIST relay_log_info_repository='FILE';
136 Warnings:
137 Warning 1287 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
138 SET PERSIST master_info_repository='TABLE';
139 Warnings:
140 Warning 1287 '@@master_info_repository' is deprecated and will be removed in a future release.
141 SET PERSIST slave_rows_search_algorithms=TABLE_SCAN;
142 Warnings:
143 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
144 SET PERSIST binlog_transaction_dependency_tracking = COMMIT_ORDER;
145 Warnings:
146 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
147 SET PERSIST transaction_write_set_extraction='MURMUR32';
148 Warnings:
149 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
150 SET PERSIST transaction_write_set_extraction='XXHASH64';
151 Warnings:
152 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
153 SET PERSIST replica_parallel_type='DATABASE';
154 Warnings:
155 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
156 SET PERSIST replica_parallel_type='LOGICAL_CLOCK';
157 Warnings:
158 Warning 1287 '@@replica_parallel_type' is deprecated and will be removed in a future release.
159 SET PERSIST replica_parallel_workers=0;
160 Warnings:
161 Warning 1287 '0' is deprecated and will be removed in a future release. Please use 1 instead
162 SET PERSIST binlog_format=ROW;
163 Warnings:
164 Warning 1287 '@@binlog_format' is deprecated and will be removed in a future release.
165 SET PERSIST sync_relay_log_info=10005;
166 Warnings:
167 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
168 SET PERSIST binlog_transaction_dependency_tracking=WRITESET;
169 Warnings:
170 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
171 SET PERSIST binlog_transaction_dependency_tracking=WRITESET_SESSION;
172 Warnings:
173 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
174 SET PERSIST binlog_transaction_dependency_tracking=COMMIT_ORDER;
175 Warnings:
176 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
177 SET PERSIST_ONLY log_bin_use_v1_row_events = TRUE;
178 ERROR HY000: Variable 'log_bin_use_v1_row_events' is a non persistent variable
179 SET PERSIST_ONLY relay_log_info_file = "RLI_FILE";
180 ERROR HY000: Variable 'relay_log_info_file' is a non persistent read only variable
181 include/save_error_log_position.inc
182 include/rpl_restart_server.inc [server_number=2]
183 include/assert_error_log.inc [server: 2, pattern: 'binlog_format' is deprecated and will be removed in a future release.
184 The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
185 The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.
186 The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.
187 The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.
188 '@@relay_log_info_repository' is deprecated and will be removed in a future release.
189 '@@master_info_repository' is deprecated and will be removed in a future release.
190 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
191 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
192 '@@binlog_format' is deprecated and will be removed in a future release.
193 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
194 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
195 ]
196 include/suppress_messages.inc
197 # Connection 1 suppresses message <'binlog_format' is deprecated and will be removed in a future release.>.
198 # Connection 1 suppresses message <The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.>.
199 # Connection 2 suppresses message <'binlog_format' is deprecated and will be removed in a future release.>.
200 # Connection 2 suppresses message <The syntax '--replica-parallel-type' is deprecated and will be removed in a future release.>.
201 include/suppress_messages.inc
202 # Connection 1 suppresses message <The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.>.
203 # Connection 2 suppresses message <The syntax '--replica-parallel-workers=0' is deprecated and will be removed in a future release. Please use '--replica-parallel-workers=1' instead.>.
204 RESET PERSIST;
205 include/rpl_restart_server.inc [server_number=2]
206 include/start_slave.inc
207 [connection master]
208 include/rpl_reset.inc
209 include/rpl_end.inc