Debian Codegraph @

mysql-test/suite/group_replication/r/gr_message_service_disabled_send.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. Disable support to send service
12 # Adding debug point 'gr_message_service_disable_send' to @@GLOBAL.debug
13
14 # 3. Bootstrap group
15 include/start_and_bootstrap_group_replication.inc
16
17 # 4. Load plugin replication observers example on server2
18 [connection server2]
19 include/install_replication_observers_example.inc
20
21 # 5. Join server2 to the group
22 include/start_group_replication.inc
23
24 # 6. Execute UDF that will transmit tag and message over GR send service
25 SELECT group_replication_service_message_send("tag", "Server2 sent a message");
26 group_replication_service_message_send("tag", "Server2 sent a message")
27 The tag and message was sent to the group.
28
29 # 7. On server 1 execute UDF but message won't be sent, service is
30 # disabled
31 [connection server1]
32 SELECT group_replication_service_message_send("tag", "Server1 sent a message");
33 ERROR HY000: group_replication_service_message_send UDF failed; No send service to propagate message to a group.
34
35 # 8. To decrease failure rate on assert_grep we do a transaction with
36 # AFTER consistency to add some rounds on GCS communication and stop GR on
37 # server1, which will make it wait for the delivery of new view, and
38 # that will happen only after delivery of service message. This will
39 # give some time to server to receive and write it to error log.
40 SET @@SESSION.group_replication_consistency= 'AFTER';
41 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
42 DROP TABLE test.t1;
43 include/stop_group_replication.inc
44
45 # 9. Assert server1 only received message from server 2
46 include/assert_grep.inc [Server 1 received a message from server 2.]
47
48 # 10. Assert server2 received only message from itself
49 [connection server2]
50 include/assert_grep.inc [Server 2 received message from itself.]
51
52 # 11. Cleanup
53 include/uninstall_replication_observers_example.inc
54 [connection server1]
55 # Removing debug point 'gr_message_service_disable_send' from @@GLOBAL.debug
56 include/start_group_replication.inc
57 include/uninstall_replication_observers_example.inc
58 include/group_replication_end.inc