Debian Codegraph @

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

raw
1 include/have_replication_observers_example_plugin.inc
2 include/group_replication.inc
3 Warnings:
4 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
5 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.
6 [connection server1]
7
8 # 1. Load plugin replication observers example on server1
9 include/install_replication_observers_example.inc
10
11 # 2. Load plugin replication observers example on server2
12 [connection server2]
13 include/install_replication_observers_example.inc
14
15 # 3. Enable debug point that will put on hold the notification of recv
16 # messages
17 # Adding debug point 'group_replication_message_service_hold_messages' to @@GLOBAL.debug
18
19 # 4. Execute UDF that will transmit tag and message over GR send service
20 SELECT group_replication_service_message_send("tag", "Server2 sent a message");
21 group_replication_service_message_send("tag", "Server2 sent a message")
22 The tag and message was sent to the group.
23
24 # 5. On server 1 execute UDF that will transmit tag and message over GR
25 # send service
26 [connection server1]
27 SELECT group_replication_service_message_send("tag", "Server1 sent a message");
28 group_replication_service_message_send("tag", "Server1 sent a message")
29 The tag and message was sent to the group.
30
31 # 6. To decrease failure rate on assert_grep we do a transaction with
32 # AFTER consistency to add some rounds on GCS communication and stop GR on
33 # server1, which will make it wait for the delivery of new view, and
34 # that will happen only after delivery of service message. This will
35 # give some time to server to receive and write it to error log.
36 SET @@SESSION.group_replication_consistency= 'AFTER';
37 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
38 DROP TABLE test.t1;
39 include/stop_group_replication.inc
40
41 # 7. Assert server1 received both messages transmitted by GR delivery
42 # message service
43 include/assert_grep.inc [Server 1 received message from server 2.]
44 include/assert_grep.inc [Server 1 received message from itself.]
45
46 # 8. Assert server2 did not received any message transmitted by GR delivery
47 # message service due being held on debug point
48 [connection server2]
49 include/assert_grep.inc [Server 2 did not received any message.]
50
51 # 9. Assert server2 received view from server1 leaving the group
52 include/assert.inc [Server2 received view from server1 leaving the group]
53
54 # 10. Remove debug point and release hold of messages
55 # Removing debug point 'group_replication_message_service_hold_messages' from @@GLOBAL.debug
56 SET DEBUG_SYNC= "now SIGNAL signal.notification_continue";
57
58 # 11. Assert server2 received both messages transmitted by GR message
59 # delivery
60 include/assert_grep.inc [Server 2 received message from itself.]
61 include/assert_grep.inc [Server 2 received message from server 1.]
62
63 # 12. Cleanup
64 include/uninstall_replication_observers_example.inc
65 [connection server1]
66 include/start_group_replication.inc
67 include/uninstall_replication_observers_example.inc
68 include/group_replication_end.inc