Debian Codegraph @

mysql-test/suite/group_replication/r/gr_reset_master.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 #Test a reset command before start.
7 RESET MASTER;
8 include/start_and_bootstrap_group_replication.inc
9 include/start_group_replication.inc
10 #Create a table and insert some data
11 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
12 include/sync_slave_sql_with_master.inc
13 INSERT INTO t1 VALUES (1);
14 INSERT INTO t1 VALUES (2);
15 include/sync_slave_sql_with_master.inc
16 INSERT INTO t1 VALUES (3);
17 include/sync_slave_sql_with_master.inc
18 #Both members must have the same GTID set
19 include/assert.inc [On member 2, all executed GTID should belong to the group]
20 include/assert.inc [On member 1, all executed GTID should belong to the group]
21 #Stop and reset both members
22 include/stop_group_replication.inc
23 RESET MASTER;
24 include/stop_group_replication.inc
25 RESET MASTER;
26 #Restart both members
27 include/start_and_bootstrap_group_replication.inc
28 include/start_group_replication.inc
29 #Both members must have an empty gtid set
30 include/assert.inc [On member 2, there should only 2 transactions from view changes]
31 include/assert.inc [On member 1, there should only 2 transactions from view changes]
32 #Insert some data to test that the group is still running
33 INSERT INTO t1 VALUES (4);
34 include/sync_slave_sql_with_master.inc
35 INSERT INTO t1 VALUES (5);
36 include/sync_slave_sql_with_master.inc
37 include/assert.inc [On member 2, the table should exist and have 5 elements]
38 include/assert.inc [On member 1, the table should exist and have 5 elements]
39 # Run RESET MASTER while Group Replication is running must fail
40 RESET MASTER;
41 ERROR HY000: RESET SOURCE is not allowed because Group Replication is running.
42 # Clean up
43 DROP TABLE t1;
44 include/group_replication_end.inc