Debian Codegraph @

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

raw
1 include/group_replication.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 server1]
6
7 ############################################################
8 # 01. Bootstrap the group on server1.
9 # Stop it making it to block just before leave the group.
10 [connection server_1]
11 CREATE TABLE t1 (c1 INT PRIMARY KEY);
12 include/start_and_bootstrap_group_replication.inc
13 SET @@GLOBAL.DEBUG= '+d,group_replication_hold_stop_before_leave_the_group';
14 STOP GROUP_REPLICATION;
15 [connection server1]
16
17 ############################################################
18 # 02. Execute transaction T1 with BEFORE consistency, it
19 # will not be allowed to execute since plugin is stopping,
20 # otherwise there may be a deadlock on the waiting conditions.
21 [connection server1]
22 SET @@SESSION.group_replication_consistency= 'BEFORE';
23 SELECT * FROM t1;
24 ERROR HY000: The Group Replication plugin is stopping, therefore new transactions are not allowed to start.
25
26 ############################################################
27 # 03. Execute transaction T1 with EVENTUAL consistency (and
28 # without any precedent AFTER transaction), it will be
29 # allowed to execute since there are nothing to wait for.
30 [connection server1]
31 SET @@SESSION.group_replication_consistency= 'EVENTUAL';
32 SELECT * FROM t1;
33 c1
34
35 ############################################################
36 # 04. Resume the plugin stop.
37 [connection server_1_1]
38 SET DEBUG_SYNC= "now SIGNAL signal.resume_stop_before_leave_the_group";
39 SET @@GLOBAL.DEBUG= '-d,group_replication_hold_stop_before_leave_the_group';
40 [connection server_1]
41 include/gr_wait_for_member_state.inc
42 include/assert_and_disable_read_only.inc
43
44 ############################################################
45 # 05. Clean up.
46 [connection server1]
47 SET @@SESSION.group_replication_consistency= DEFAULT;
48 DROP TABLE t1;
49 include/group_replication_end.inc