Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=3]
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 [connection server2]
8 [connection server3]
9 Starting GR on server 1
10 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-bbbb-aaaa-aaaa-aaaaaaaaaaaa'
11
12 0 rows affected
13 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=1
14
15 0 rows affected
16 RUN START GROUP_REPLICATION
17
18 0 rows affected
19 RUN SET GLOBAL GROUP_REPLICATION_BOOTSTRAP_GROUP=0
20
21 0 rows affected
22 Mysqlx.Ok {
23 msg: "bye!"
24 }
25 ok
26 Starting GR on server 2
27 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-bbbb-aaaa-aaaa-aaaaaaaaaaaa'
28
29 0 rows affected
30 RUN CHANGE REPLICATION SOURCE TO SOURCE_USER='root' FOR CHANNEL 'group_replication_recovery'
31
32 0 rows affected
33 RUN START GROUP_REPLICATION
34
35 0 rows affected
36 Mysqlx.Ok {
37 msg: "bye!"
38 }
39 ok
40 Starting GR on server 3
41 RUN SET GLOBAL GROUP_REPLICATION_GROUP_NAME = 'aaaaaaaa-bbbb-aaaa-aaaa-aaaaaaaaaaaa'
42
43 0 rows affected
44 RUN CHANGE REPLICATION SOURCE TO SOURCE_USER='root' FOR CHANNEL 'group_replication_recovery'
45
46 0 rows affected
47 RUN START GROUP_REPLICATION
48
49 0 rows affected
50 Mysqlx.Ok {
51 msg: "bye!"
52 }
53 ok
54 Waiting for GR members to come online.
55 name type
56 command ok
57
58 command ok
59 send Mysqlx.Crud.Insert {
60 collection {
61 name: "characters"
62 schema: "test"
63 }
64 data_model: DOCUMENT
65 row {
66 field {
67 type: OBJECT
68 object {
69 fld {
70 key: "House"
71 value {
72 type: LITERAL
73 literal {
74 type: V_OCTETS
75 v_octets {
76 value: "Stark"
77 }
78 }
79 }
80 }
81 fld {
82 key: "_id"
83 value {
84 type: LITERAL
85 literal {
86 type: V_OCTETS
87 v_octets {
88 value: "6c706242055ae611fd36b86b23c1b9b9"
89 }
90 }
91 }
92 }
93 fld {
94 key: "name"
95 value {
96 type: LITERAL
97 literal {
98 type: V_OCTETS
99 v_octets {
100 value: "John Snow"
101 }
102 }
103 }
104 }
105 }
106 }
107 }
108 }
109
110
111 1 rows affected
112 send Mysqlx.Crud.Insert {
113 collection {
114 name: "characters"
115 schema: "test"
116 }
117 data_model: DOCUMENT
118 row {
119 field {
120 type: OBJECT
121 object {
122 fld {
123 key: "House"
124 value {
125 type: LITERAL
126 literal {
127 type: V_OCTETS
128 v_octets {
129 value: "Stark"
130 }
131 }
132 }
133 }
134 fld {
135 key: "_id"
136 value {
137 type: LITERAL
138 literal {
139 type: V_OCTETS
140 v_octets {
141 value: "ac1fc3b0055ae611fd36b86b23c1b9b9"
142 }
143 }
144 }
145 }
146 fld {
147 key: "name"
148 value {
149 type: LITERAL
150 literal {
151 type: V_OCTETS
152 v_octets {
153 value: "Rob Stark"
154 }
155 }
156 }
157 }
158 }
159 }
160 }
161 row {
162 field {
163 type: OBJECT
164 object {
165 fld {
166 key: "House"
167 value {
168 type: LITERAL
169 literal {
170 type: V_OCTETS
171 v_octets {
172 value: "Stark"
173 }
174 }
175 }
176 }
177 fld {
178 key: "_id"
179 value {
180 type: LITERAL
181 literal {
182 type: V_OCTETS
183 v_octets {
184 value: "4261c3b0055ae611fd36b86b23c1b9b9"
185 }
186 }
187 }
188 }
189 fld {
190 key: "name"
191 value {
192 type: LITERAL
193 literal {
194 type: V_OCTETS
195 v_octets {
196 value: "Arya Stark"
197 }
198 }
199 }
200 }
201 }
202 }
203 }
204 row {
205 field {
206 type: OBJECT
207 object {
208 fld {
209 key: "House"
210 value {
211 type: LITERAL
212 literal {
213 type: V_OCTETS
214 v_octets {
215 value: "Stark"
216 }
217 }
218 }
219 }
220 fld {
221 key: "_id"
222 value {
223 type: LITERAL
224 literal {
225 type: V_OCTETS
226 v_octets {
227 value: "6e62c3b0055ae611fd36b86b23c1b9b9"
228 }
229 }
230 }
231 }
232 fld {
233 key: "name"
234 value {
235 type: LITERAL
236 literal {
237 type: V_OCTETS
238 v_octets {
239 value: "Brandon Stark"
240 }
241 }
242 }
243 }
244 }
245 }
246 }
247 }
248
249
250 3 rows affected
251 Records: 3 Duplicates: 0 Warnings: 0
252 send Mysqlx.Crud.Update {
253 collection {
254 name: "characters"
255 schema: "test"
256 }
257 data_model: DOCUMENT
258 criteria {
259 type: OPERATOR
260 operator {
261 name: "=="
262 param {
263 type: IDENT
264 identifier {
265 document_path {
266 type: MEMBER
267 value: "name"
268 }
269 }
270 }
271 param {
272 type: LITERAL
273 literal {
274 type: V_OCTETS
275 v_octets {
276 value: "John Snow"
277 }
278 }
279 }
280 }
281 }
282 operation {
283 source {
284 document_path {
285 type: MEMBER
286 value: "House"
287 }
288 }
289 operation: ITEM_SET
290 value {
291 type: LITERAL
292 literal {
293 type: V_STRING
294 v_string {
295 value: "Targaryen"
296 }
297 }
298 }
299 }
300 }
301
302
303 1 rows affected
304 Rows matched: 1 Changed: 1 Warnings: 0
305 send Mysqlx.Crud.Find {
306 collection {
307 name: "characters"
308 schema: "test"
309 }
310 data_model: DOCUMENT
311 }
312
313 doc
314 {"_id": "4261c3b0055ae611fd36b86b23c1b9b9", "name": "Arya Stark", "House": "Stark"}
315 {"_id": "6c706242055ae611fd36b86b23c1b9b9", "name": "John Snow", "House": "Targaryen"}
316 {"_id": "6e62c3b0055ae611fd36b86b23c1b9b9", "name": "Brandon Stark", "House": "Stark"}
317 {"_id": "ac1fc3b0055ae611fd36b86b23c1b9b9", "name": "Rob Stark", "House": "Stark"}
318 command ok
319 Mysqlx.Ok {
320 msg: "bye!"
321 }
322 ok
323 include/rpl_sync.inc
324 send Mysqlx.Crud.Update {
325 collection {
326 name: "characters"
327 schema: "test"
328 }
329 data_model: DOCUMENT
330 criteria {
331 type: OPERATOR
332 operator {
333 name: "&&"
334 param {
335 type: OPERATOR
336 operator {
337 name: "=="
338 param {
339 type: IDENT
340 identifier {
341 document_path {
342 type: MEMBER
343 value: "House"
344 }
345 }
346 }
347 param {
348 type: LITERAL
349 literal {
350 type: V_OCTETS
351 v_octets {
352 value: "Targaryen"
353 }
354 }
355 }
356 }
357 }
358 param {
359 type: OPERATOR
360 operator {
361 name: "=="
362 param {
363 type: IDENT
364 identifier {
365 document_path {
366 type: MEMBER
367 value: "name"
368 }
369 }
370 }
371 param {
372 type: LITERAL
373 literal {
374 type: V_OCTETS
375 v_octets {
376 value: "John Snow"
377 }
378 }
379 }
380 }
381 }
382 }
383 }
384 operation {
385 source {
386 document_path {
387 type: MEMBER
388 value: "House"
389 }
390 }
391 operation: ARRAY_APPEND
392 value {
393 type: LITERAL
394 literal {
395 type: V_STRING
396 v_string {
397 value: "Stark"
398 }
399 }
400 }
401 }
402 }
403
404
405 1 rows affected
406 Rows matched: 1 Changed: 1 Warnings: 0
407 send Mysqlx.Crud.Insert {
408 collection {
409 name: "characters"
410 schema: "test"
411 }
412 data_model: DOCUMENT
413 row {
414 field {
415 type: OBJECT
416 object {
417 fld {
418 key: "House"
419 value {
420 type: LITERAL
421 literal {
422 type: V_OCTETS
423 v_octets {
424 value: "Stark "
425 }
426 }
427 }
428 }
429 fld {
430 key: "_id"
431 value {
432 type: LITERAL
433 literal {
434 type: V_OCTETS
435 v_octets {
436 value: "1616f2480b5ae611c319b86b23c1b9b9"
437 }
438 }
439 }
440 }
441 fld {
442 key: "name"
443 value {
444 type: LITERAL
445 literal {
446 type: V_OCTETS
447 v_octets {
448 value: "Sansa Stark"
449 }
450 }
451 }
452 }
453 }
454 }
455 }
456 }
457
458
459 1 rows affected
460 send Mysqlx.Crud.Delete {
461 collection {
462 name: "characters"
463 schema: "test"
464 }
465 data_model: DOCUMENT
466 criteria {
467 type: OPERATOR
468 operator {
469 name: "like"
470 param {
471 type: IDENT
472 identifier {
473 document_path {
474 type: MEMBER
475 value: "name"
476 }
477 }
478 }
479 param {
480 type: LITERAL
481 literal {
482 type: V_OCTETS
483 v_octets {
484 value: "Robb%"
485 }
486 }
487 }
488 }
489 }
490 }
491
492
493 0 rows affected
494 send Mysqlx.Crud.Find {
495 collection {
496 name: "characters"
497 schema: "test"
498 }
499 data_model: DOCUMENT
500 }
501
502 doc
503 {"_id": "1616f2480b5ae611c319b86b23c1b9b9", "name": "Sansa Stark", "House": "Stark "}
504 {"_id": "4261c3b0055ae611fd36b86b23c1b9b9", "name": "Arya Stark", "House": "Stark"}
505 {"_id": "6c706242055ae611fd36b86b23c1b9b9", "name": "John Snow", "House": ["Targaryen", "Stark"]}
506 {"_id": "6e62c3b0055ae611fd36b86b23c1b9b9", "name": "Brandon Stark", "House": "Stark"}
507 {"_id": "ac1fc3b0055ae611fd36b86b23c1b9b9", "name": "Rob Stark", "House": "Stark"}
508 command ok
509 Mysqlx.Ok {
510 msg: "bye!"
511 }
512 ok
513 include/rpl_sync.inc
514 send Mysqlx.Crud.Insert {
515 collection {
516 name: "characters"
517 schema: "test"
518 }
519 data_model: DOCUMENT
520 row {
521 field {
522 type: OBJECT
523 object {
524 fld {
525 key: "House"
526 value {
527 type: LITERAL
528 literal {
529 type: V_OCTETS
530 v_octets {
531 value: "Stark"
532 }
533 }
534 }
535 }
536 fld {
537 key: "_id"
538 value {
539 type: LITERAL
540 literal {
541 type: V_OCTETS
542 v_octets {
543 value: "8cd5d2d90e5ae611e325b86b23c1b9b9"
544 }
545 }
546 }
547 }
548 fld {
549 key: "name"
550 value {
551 type: LITERAL
552 literal {
553 type: V_OCTETS
554 v_octets {
555 value: "Benjen Stark"
556 }
557 }
558 }
559 }
560 }
561 }
562 }
563 row {
564 field {
565 type: OBJECT
566 object {
567 fld {
568 key: "House"
569 value {
570 type: LITERAL
571 literal {
572 type: V_OCTETS
573 v_octets {
574 value: "Stark"
575 }
576 }
577 }
578 }
579 fld {
580 key: "_id"
581 value {
582 type: LITERAL
583 literal {
584 type: V_OCTETS
585 v_octets {
586 value: "b2d7d2d90e5ae611e325b86b23c1b9b9"
587 }
588 }
589 }
590 }
591 fld {
592 key: "name"
593 value {
594 type: LITERAL
595 literal {
596 type: V_OCTETS
597 v_octets {
598 value: "Ned Stark"
599 }
600 }
601 }
602 }
603 }
604 }
605 }
606 }
607
608
609 2 rows affected
610 Records: 2 Duplicates: 0 Warnings: 0
611 send Mysqlx.Crud.Update {
612 collection {
613 name: "characters"
614 schema: "test"
615 }
616 data_model: DOCUMENT
617 criteria {
618 type: OPERATOR
619 operator {
620 name: "=="
621 param {
622 type: IDENT
623 identifier {
624 document_path {
625 type: MEMBER
626 value: "name"
627 }
628 }
629 }
630 param {
631 type: LITERAL
632 literal {
633 type: V_OCTETS
634 v_octets {
635 value: "Arya Stark"
636 }
637 }
638 }
639 }
640 }
641 operation {
642 source {
643 document_path {
644 type: MEMBER
645 value: "name"
646 }
647 }
648 operation: ITEM_SET
649 value {
650 type: LITERAL
651 literal {
652 type: V_STRING
653 v_string {
654 value: "A girl has NoName"
655 }
656 }
657 }
658 }
659 }
660
661
662 1 rows affected
663 Rows matched: 1 Changed: 1 Warnings: 0
664 send Mysqlx.Crud.Delete {
665 collection {
666 name: "characters"
667 schema: "test"
668 }
669 data_model: DOCUMENT
670 limit {
671 row_count: 3
672 }
673 }
674
675
676 3 rows affected
677 send Mysqlx.Crud.Find {
678 collection {
679 name: "characters"
680 schema: "test"
681 }
682 data_model: DOCUMENT
683 }
684
685 doc
686 {"_id": "6e62c3b0055ae611fd36b86b23c1b9b9", "name": "Brandon Stark", "House": "Stark"}
687 {"_id": "8cd5d2d90e5ae611e325b86b23c1b9b9", "name": "Benjen Stark", "House": "Stark"}
688 {"_id": "ac1fc3b0055ae611fd36b86b23c1b9b9", "name": "Rob Stark", "House": "Stark"}
689 {"_id": "b2d7d2d90e5ae611e325b86b23c1b9b9", "name": "Ned Stark", "House": "Stark"}
690 command ok
691
692 command ok
693 Mysqlx.Ok {
694 msg: "bye!"
695 }
696 ok
697 include/rpl_sync.inc
698 Stopping GR on server 1
699 RUN STOP GROUP_REPLICATION;
700
701 0 rows affected
702 Mysqlx.Ok {
703 msg: "bye!"
704 }
705 ok
706 Stopping GR on server 2
707 RUN STOP GROUP_REPLICATION;
708
709 0 rows affected
710 Mysqlx.Ok {
711 msg: "bye!"
712 }
713 ok
714 Stopping GR on server 3
715 RUN STOP GROUP_REPLICATION;
716
717 0 rows affected
718 Mysqlx.Ok {
719 msg: "bye!"
720 }
721 ok
722 [connection server1]
723 include/gr_wait_for_member_state.inc
724 include/assert_and_disable_read_only.inc
725 [connection server2]
726 include/gr_wait_for_member_state.inc
727 include/assert_and_disable_read_only.inc
728 [connection server3]
729 include/gr_wait_for_member_state.inc
730 include/assert_and_disable_read_only.inc
731 include/group_replication_end.inc