Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_rep_error.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 Wrong schema for the table, too few pks
7 create table t1 (a int key, X int) engine ndb;
8 Warnings:
9 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Wrong number of primary key parts, expected 3
10 drop table t1;
11 Wrong schema for the table, incorrect pk
12 create table t1 (a int key, X int) engine ndb;
13 Warnings:
14 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Missing or wrong type for column 'server_id'
15 drop table t1;
16 Wrong schema for the table, binlog_type is signed
17 create table t1 (a int key, X int) engine ndb;
18 Warnings:
19 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Missing or wrong type for column 'binlog_type'
20 drop table t1;
21 Wrong schema for the table, conflict_fn is too long
22 create table t1 (a int key, X int) engine ndb;
23 Warnings:
24 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Missing or wrong type for column 'conflict_fn'
25 drop table t1;
26 Correct schema for the table but no conflict fn
27 insert into mysql.ndb_replication values ("test", "t1", 0, 7);
28 create table test.t1 (a int primary key) engine=ndb;
29 show warnings;
30 Level Code Message
31 drop table test.t1;
32 MySQLD error output for server 1.1 matching pattern %Binlog: logging%
33 relevant
34 [system] binlog: logging ./test/t1 (full,use_update)
35 delete from mysql.ndb_replication;
36 Check that NULL uses server defaults
37 show variables like 'ndb_log_update_as_write';
38 Variable_name Value
39 ndb_log_update_as_write ON
40 show variables like 'ndb_log_updated_only';
41 Variable_name Value
42 ndb_log_updated_only ON
43 insert into mysql.ndb_replication values ("test", "t1", 0, NULL);
44 create table test.t1 (a int primary key) engine=ndb;
45 show warnings;
46 Level Code Message
47 drop table test.t1;
48 MySQLD error output for server 1.1 matching pattern %Binlog: logging%
49 relevant
50 [system] binlog: logging ./test/t1 (updated,use_write)
51 Correct schema for the table but other errors
52 insert into mysql.ndb_replication values ("test", "t1", 0, NULL, "NDB$X(X)");
53 create table t1 (a int key, X int) engine ndb;
54 ERROR HY000: Error in parsing conflict function. Message: NDB$X(X), unknown conflict resolution function at 'NDB$X(X)'
55 show warnings;
56 Level Code Message
57 Error 1626 Error in parsing conflict function. Message: NDB$X(X), unknown conflict resolution function at 'NDB$X(X)'
58 Error 1031 Table storage engine for 't1' doesn't have this option
59 delete from mysql.ndb_replication;
60 insert into mysql.ndb_replication values ("test", "t1", 0, NULL, "NDB$MAX(X)");
61 create table t1 (a int key, X int) engine ndb;
62 ERROR HY000: Can't create table 't1' (use SHOW WARNINGS for more info).
63 show warnings;
64 Level Code Message
65 Warning 1626 Error in parsing conflict function. Message: Column 'X' has wrong datatype
66 Error 1005 Can't create table 't1' (use SHOW WARNINGS for more info).
67 delete from mysql.ndb_replication;
68 insert into mysql.ndb_replication values ("test", "t1", 0, NULL, "NDB$MAX()");
69 create table t1 (a int key, X int) engine ndb;
70 ERROR HY000: Error in parsing conflict function. Message: NDB$MAX(), missing function argument at ')'
71 show warnings;
72 Level Code Message
73 Error 1626 Error in parsing conflict function. Message: NDB$MAX(), missing function argument at ')'
74 Error 1031 Table storage engine for 't1' doesn't have this option
75 delete from mysql.ndb_replication;
76 insert into mysql.ndb_replication values ("test", "t1", 0, NULL, "NDB$MAX(X Y)");
77 create table t1 (a int key, X int) engine ndb;
78 ERROR HY000: Error in parsing conflict function. Message: NDB$MAX(X Y), missing ')' at 'Y)'
79 show warnings;
80 Level Code Message
81 Error 1626 Error in parsing conflict function. Message: NDB$MAX(X Y), missing ')' at 'Y)'
82 Error 1031 Table storage engine for 't1' doesn't have this option
83 delete from mysql.ndb_replication;
84 show variables like 'server_id';
85 Variable_name Value
86 server_id 1
87 create database europenorth;
88 create database europesouth;
89 create database usnorth;
90 create database ussouth;
91 Basic wildcard tests
92 Note that we put in bad conflict fn names so that the warnings generated
93 when the table create fails give an indication of which ndb_replication
94 table row was chosen.
95
96 Wild serverid
97 insert into mysql.ndb_replication values ("europenorth", "france", 1, NULL, "NDB$A()");
98 insert into mysql.ndb_replication values ("europenorth", "france", 0, NULL, "NDB$B()");
99 Should match specific entry (1) with algorithm A.
100 create table europenorth.france (a int primary key) engine=ndb;
101 ERROR HY000: Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
102 show warnings;
103 Level Code Message
104 Error 1626 Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
105 Error 1031 Table storage engine for 'france' doesn't have this option
106 delete from mysql.ndb_replication where server_id=1;
107 Should match generic entry (0) with algorthin B.
108 create table europenorth.france (a int primary key) engine=ndb;
109 ERROR HY000: Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
110 show warnings;
111 Level Code Message
112 Error 1626 Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
113 Error 1031 Table storage engine for 'france' doesn't have this option
114 delete from mysql.ndb_replication;
115 Wild table_name
116 insert into mysql.ndb_replication values ("europenorth", "fr_nce", 1, NULL, "NDB$A()");
117 insert into mysql.ndb_replication values ("europenorth", "%any", 1, NULL, "NDB$B()");
118 Should match specific entry (fr_nce) with algorithm A.
119 create table europenorth.france (a int primary key) engine=ndb;
120 ERROR HY000: Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
121 show warnings;
122 Level Code Message
123 Error 1626 Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
124 Error 1031 Table storage engine for 'france' doesn't have this option
125 Should match specific entry (%any) with algorithm B.
126 create table europenorth.germany (a int primary key) engine=ndb;
127 ERROR HY000: Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
128 show warnings;
129 Level Code Message
130 Error 1626 Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
131 Error 1031 Table storage engine for 'germany' doesn't have this option
132 Should match specific entry (%any) with algorithm B.
133 create table europenorth.romany (a int primary key) engine=ndb;
134 ERROR HY000: Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
135 show warnings;
136 Level Code Message
137 Error 1626 Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
138 Error 1031 Table storage engine for 'romany' doesn't have this option
139 No match, should be fine
140 create table europenorth.uk (a int primary key) engine=ndb;
141 show warnings;
142 Level Code Message
143 drop table europenorth.uk;
144 delete from mysql.ndb_replication;
145 Wild db
146 insert into mysql.ndb_replication values ("%north", "countries", 1, NULL, "NDB$A()");
147 insert into mysql.ndb_replication values ("%south", "countries", 1, NULL, "NDB$B()");
148 Should match north with A
149 create table europenorth.countries (a int primary key) engine=ndb;
150 ERROR HY000: Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
151 show warnings;
152 Level Code Message
153 Error 1626 Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
154 Error 1031 Table storage engine for 'countries' doesn't have this option
155 Should match north with A
156 create table usnorth.countries (a int primary key) engine=ndb;
157 ERROR HY000: Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
158 show warnings;
159 Level Code Message
160 Error 1626 Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
161 Error 1031 Table storage engine for 'countries' doesn't have this option
162 Should match south with B
163 create table europesouth.countries (a int primary key) engine=ndb;
164 ERROR HY000: Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
165 show warnings;
166 Level Code Message
167 Error 1626 Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
168 Error 1031 Table storage engine for 'countries' doesn't have this option
169 Should match south with B
170 create table ussouth.countries (a int primary key) engine=ndb;
171 ERROR HY000: Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
172 show warnings;
173 Level Code Message
174 Error 1626 Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
175 Error 1031 Table storage engine for 'countries' doesn't have this option
176 delete from mysql.ndb_replication;
177 Now test wildcard matching precedence
178 Wildcards match in the following precedence (highest->lowest)
179 Exact match
180 Wild serverid
181 Wild table_name
182 Wild serverid + wild table_name
183 Wild db
184 Wild db + wild serverid
185 Wild db + wild table_name
186 All wild
187
188 The 'wild serverid' is 0
189
190 Multiple matches at the same precedence are ambiguous and result
191 in an error.
192
193 Start with full set of potential matches, and chip away
194 insert into mysql.ndb_replication values ("europenorth", "netherlands", 1, NULL, "NDB$A()");
195 insert into mysql.ndb_replication values ("europenorth", "netherlands", 0, NULL, "NDB$B()");
196 insert into mysql.ndb_replication values ("europenorth", "%lands", 1, NULL, "NDB$C()");
197 insert into mysql.ndb_replication values ("europenorth", "nether%s", 1, NULL, "NDB$D()");
198 insert into mysql.ndb_replication values ("europenorth", "%lands", 0, NULL, "NDB$E()");
199 insert into mysql.ndb_replication values ("europenorth", "nether%s", 0, NULL, "NDB$F()");
200 insert into mysql.ndb_replication values ("Europe%", "netherlands", 1, NULL, "NDB$G()");
201 insert into mysql.ndb_replication values ("%North", "netherlands", 1, NULL, "NDB$H()");
202 insert into mysql.ndb_replication values ("Europe%", "netherlands", 0, NULL, "NDB$I()");
203 insert into mysql.ndb_replication values ("%North", "netherlands", 0, NULL, "NDB$J()");
204 insert into mysql.ndb_replication values ("Europe%", "%lands", 1, NULL, "NDB$K()");
205 insert into mysql.ndb_replication values ("%North", "nether%s", 1, NULL, "NDB$L()");
206 insert into mysql.ndb_replication values ("Europe%", "%lands", 0, NULL, "NDB$M()");
207 insert into mysql.ndb_replication values ("%North", "nether%s", 0, NULL, "NDB$N()");
208 Unique match (A)
209 create table europenorth.netherlands (a int primary key) engine=ndb;
210 ERROR HY000: Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
211 show warnings;
212 Level Code Message
213 Error 1626 Error in parsing conflict function. Message: NDB$A(), unknown conflict resolution function at 'NDB$A()'
214 Error 1031 Table storage engine for 'netherlands' doesn't have this option
215 delete from mysql.ndb_replication where db="europenorth" and table_name="netherlands" and server_id=1;
216 Unique match with wild serverid (B)
217 create table europenorth.netherlands (a int primary key) engine=ndb;
218 ERROR HY000: Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
219 show warnings;
220 Level Code Message
221 Error 1626 Error in parsing conflict function. Message: NDB$B(), unknown conflict resolution function at 'NDB$B()'
222 Error 1031 Table storage engine for 'netherlands' doesn't have this option
223 delete from mysql.ndb_replication where db="europenorth" and table_name="netherlands" and server_id=0;
224 Ambiguous wild table name
225 create table europenorth.netherlands (a int primary key) engine=ndb;
226 Warnings:
227 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
228 show warnings;
229 Level Code Message
230 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
231 drop table europenorth.netherlands;
232 delete from mysql.ndb_replication where db="europenorth" and table_name="%lands" and server_id=1;
233 Wild table name (D)
234 create table europenorth.netherlands (a int primary key) engine=ndb;
235 ERROR HY000: Error in parsing conflict function. Message: NDB$D(), unknown conflict resolution function at 'NDB$D()'
236 show warnings;
237 Level Code Message
238 Error 1626 Error in parsing conflict function. Message: NDB$D(), unknown conflict resolution function at 'NDB$D()'
239 Error 1031 Table storage engine for 'netherlands' doesn't have this option
240 delete from mysql.ndb_replication where db="europenorth" and table_name="nether%s" and server_id=1;
241 Ambiguous wild server id and table name
242 create table europenorth.netherlands (a int primary key) engine=ndb;
243 Warnings:
244 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
245 show warnings;
246 Level Code Message
247 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
248 drop table europenorth.netherlands;
249 delete from mysql.ndb_replication where db="europenorth" and table_name="nether%s" and server_id=0;
250 Wild server id and table name (E)
251 create table europenorth.netherlands (a int primary key) engine=ndb;
252 ERROR HY000: Error in parsing conflict function. Message: NDB$E(), unknown conflict resolution function at 'NDB$E()'
253 show warnings;
254 Level Code Message
255 Error 1626 Error in parsing conflict function. Message: NDB$E(), unknown conflict resolution function at 'NDB$E()'
256 Error 1031 Table storage engine for 'netherlands' doesn't have this option
257 delete from mysql.ndb_replication where db="europenorth" and table_name="%lands" and server_id=0;
258 Amiguous wild db
259 create table europenorth.netherlands (a int primary key) engine=ndb;
260 Warnings:
261 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
262 show warnings;
263 Level Code Message
264 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
265 drop table europenorth.netherlands;
266 delete from mysql.ndb_replication where db="Europe%" and table_name="netherlands" and server_id=1;
267 Wild db (H)
268 create table europenorth.netherlands (a int primary key) engine=ndb;
269 ERROR HY000: Error in parsing conflict function. Message: NDB$H(), unknown conflict resolution function at 'NDB$H()'
270 show warnings;
271 Level Code Message
272 Error 1626 Error in parsing conflict function. Message: NDB$H(), unknown conflict resolution function at 'NDB$H()'
273 Error 1031 Table storage engine for 'netherlands' doesn't have this option
274 delete from mysql.ndb_replication where db="%North" and table_name="netherlands" and server_id=1;
275 Ambiguous wild db + server_id
276 create table europenorth.netherlands (a int primary key) engine=ndb;
277 Warnings:
278 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
279 show warnings;
280 Level Code Message
281 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
282 drop table europenorth.netherlands;
283 delete from mysql.ndb_replication where db="Europe%" and table_name="netherlands" and server_id=0;
284 Wild db + server id (J)
285 create table europenorth.netherlands (a int primary key) engine=ndb;
286 ERROR HY000: Error in parsing conflict function. Message: NDB$J(), unknown conflict resolution function at 'NDB$J()'
287 show warnings;
288 Level Code Message
289 Error 1626 Error in parsing conflict function. Message: NDB$J(), unknown conflict resolution function at 'NDB$J()'
290 Error 1031 Table storage engine for 'netherlands' doesn't have this option
291 delete from mysql.ndb_replication where db="%North" and table_name="netherlands" and server_id=0;
292 Ambiguous wild db + table_name
293 create table europenorth.netherlands (a int primary key) engine=ndb;
294 Warnings:
295 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
296 show warnings;
297 Level Code Message
298 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
299 drop table europenorth.netherlands;
300 delete from mysql.ndb_replication where db="Europe%" and table_name="%lands" and server_id=1;
301 Wild db + table_name (L)
302 create table europenorth.netherlands (a int primary key) engine=ndb;
303 ERROR HY000: Error in parsing conflict function. Message: NDB$L(), unknown conflict resolution function at 'NDB$L()'
304 show warnings;
305 Level Code Message
306 Error 1626 Error in parsing conflict function. Message: NDB$L(), unknown conflict resolution function at 'NDB$L()'
307 Error 1031 Table storage engine for 'netherlands' doesn't have this option
308 delete from mysql.ndb_replication where db="%North" and table_name="nether%s" and server_id=1;
309 Ambiguous all wild
310 create table europenorth.netherlands (a int primary key) engine=ndb;
311 Warnings:
312 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
313 show warnings;
314 Level Code Message
315 Warning 1625 Bad schema for mysql.ndb_replication table. Message: Ambiguous matches in mysql.ndb_replication for europenorth.nethe
316 drop table europenorth.netherlands;
317 delete from mysql.ndb_replication where db="Europe%" and table_name="%lands" and server_id=0;
318 All wild (N)
319 create table europenorth.netherlands (a int primary key) engine=ndb;
320 ERROR HY000: Error in parsing conflict function. Message: NDB$N(), unknown conflict resolution function at 'NDB$N()'
321 show warnings;
322 Level Code Message
323 Error 1626 Error in parsing conflict function. Message: NDB$N(), unknown conflict resolution function at 'NDB$N()'
324 Error 1031 Table storage engine for 'netherlands' doesn't have this option
325 delete from mysql.ndb_replication;
326 drop database europenorth;
327 drop database europesouth;
328 drop database usnorth;
329 drop database ussouth;
330 include/rpl_end.inc