Debian Codegraph @

mysql-test/suite/group_replication/r/gr_gno_exhausted.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 [connection server1]
7 SET SESSION sql_log_bin= 0;
8 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
9 call mtr.add_suppression("Impossible to generate Global Transaction Identifier: the integer component reached the maximal value. Restart the group with a new group_replication_group_name.");
10 call mtr.add_suppression("Error at event handling! Got error: 1");
11 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
12 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
13 call mtr.add_suppression("The member is leaving a group without being on one.");
14 call mtr.add_suppression("The member is already leaving or joining a group.");
15 call mtr.add_suppression("Unable to ensure the execution of group transactions received during recovery.");
16 call mtr.add_suppression("Fatal error during the incremental recovery process of Group Replication. The server will leave the group.");
17 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
18 call mtr.add_suppression("Skipping leave operation: member already left the group.");
19 call mtr.add_suppression("The integer component of the GTID number is high.");
20 SET SESSION sql_log_bin= 1;
21 [connection server2]
22 SET SESSION sql_log_bin= 0;
23 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
24 call mtr.add_suppression("Impossible to generate Global Transaction Identifier: the integer component reached the maximal value. Restart the group with a new group_replication_group_name.");
25 call mtr.add_suppression("Error at event handling! Got error: 1");
26 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
27 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
28 call mtr.add_suppression("All donors left. Aborting group replication incremental recovery.");
29 call mtr.add_suppression("Fatal error during the incremental recovery process of Group Replication. The server will leave the group.");
30 call mtr.add_suppression("The member is leaving a group without being on one.");
31 call mtr.add_suppression("The member is already leaving or joining a group.");
32 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
33 call mtr.add_suppression("Skipping leave operation: member already left the group.");
34 call mtr.add_suppression("The integer component of the GTID number is high.");
35 SET SESSION sql_log_bin= 1;
36
37 ############################################################
38 # 1. Validate that transactions are aborted on local member
39 # and remote members move to ERROR state when group GNOs
40 # are exhausted.
41 [connection server1]
42 SET GLOBAL GTID_PURGED= "c234f752-1ee4-11e6-adee-00212844d44e:1-9223372036854775804";
43 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775804]
44 include/start_and_bootstrap_group_replication.inc
45 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775805]
46 [connection server2]
47 SET GLOBAL GTID_PURGED= "c234f752-1ee4-11e6-adee-00212844d44e:1-9223372036854775804";
48 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775804]
49 include/start_group_replication.inc
50 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775806]
51 [connection server1]
52 INSERT INTO t1 VALUES (1);
53 ERROR 40000: Plugin instructed the server to rollback the current transaction.
54 [connection server2]
55 include/gr_wait_for_member_state.inc
56 include/stop_group_replication.inc
57 [connection server1]
58 include/stop_group_replication.inc
59
60 ############################################################
61 # 2. Validate that member start moves to ERROR state when
62 # group GNOs are exhausted.
63 RESET MASTER;
64 SET GLOBAL GTID_PURGED= "c234f752-1ee4-11e6-adee-00212844d44e:1-9223372036854775806";
65 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775806]
66 include/start_group_replication.inc
67 include/stop_group_replication.inc
68 ############################################################
69 # 3. Validate that member moves to ERROR state when group
70 # GNOs are exhausted on view change log.
71 [connection server1]
72 RESET MASTER;
73 SET GLOBAL GTID_PURGED= "c234f752-1ee4-11e6-adee-00212844d44e:1-9223372036854775805";
74 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775805]
75 include/start_and_bootstrap_group_replication.inc
76 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775806]
77 [connection server2]
78 RESET MASTER;
79 SET GLOBAL GTID_PURGED= "c234f752-1ee4-11e6-adee-00212844d44e:1-9223372036854775805";
80 include/assert.inc [GTID_EXECUTED must be UUID:1-9223372036854775805]
81 include/start_group_replication.inc
82 include/stop_group_replication.inc
83 [connection server1]
84 include/gr_wait_for_member_state.inc
85 include/stop_group_replication.inc
86
87 ############################################################
88 # 4. Clean up.
89 [connection server2]
90 RESET MASTER;
91 include/start_and_bootstrap_group_replication.inc
92 [connection server1]
93 RESET MASTER;
94 include/start_group_replication.inc
95 [connection server1]
96 SET SESSION sql_log_bin= 0;
97 DROP TABLE t1;
98 SET SESSION sql_log_bin= 1;
99 [connection server2]
100 SET SESSION sql_log_bin= 0;
101 DROP TABLE t1;
102 SET SESSION sql_log_bin= 1;
103 include/group_replication_end.inc