Debian Codegraph @

mysql-test/suite/group_replication/r/gr_view_change_uuid_recompute_intervals.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 # 1. Setup Group Replication on server 1 and 2 with view
9 # change uuid configured with an valid uuid
10 SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid;
11 SET GLOBAL group_replication_view_change_uuid = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa";
12 Warnings:
13 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
14 include/start_and_bootstrap_group_replication.inc
15 Warnings:
16 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
17 [connection server2]
18 SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid;
19 SET GLOBAL group_replication_view_change_uuid = "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa";
20 Warnings:
21 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
22 include/start_group_replication.inc
23 Warnings:
24 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
25
26 ############################################################
27 # 2. Create a table on server 1 that will add one
28 # transaction to the group
29 [connection server1]
30 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
31 include/rpl_sync.inc
32
33 ############################################################
34 # 3. Insert data into table on server 2 that will add one
35 # transaction to the group
36 [connection server2]
37 INSERT INTO t1 VALUES (0);
38 include/rpl_sync.inc
39
40 ############################################################
41 # 4. Remove and rejoin server 2, that will generate a new
42 # view and will recompute intervals
43 include/stop_group_replication.inc
44 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 2 transactions]
45 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 2 view changes]
46 include/start_group_replication.inc
47 Warnings:
48 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
49
50 ############################################################
51 # 5. Insert data into table on server 2 that will add one
52 # transaction to the group
53 INSERT INTO t1 VALUES (1);
54 include/rpl_sync.inc
55
56 ############################################################
57 # 6. Transactions are added to the correct intervals and
58 # views are logged with view uuid
59 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 transactions, two on first interval]
60 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 view changes]
61 [connection server1]
62 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 transactions, two on first interval]
63 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 view changes]
64
65 ############################################################
66 # 7. Stop server 2 and on server 1 set GTID_NEXT to next
67 # expected view uuid and execute a transaction.
68 # Start server 2
69 [connection server2]
70 include/stop_group_replication.inc
71 [connection server1]
72 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:4';;
73 INSERT INTO t1 VALUES (2);
74 [connection server2]
75 include/start_group_replication.inc
76 Warnings:
77 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
78
79 ############################################################
80 # 8. Assert the intervals were not used, the new view
81 # change is correctly logged and the transaction using
82 # the view uuid is also executed.
83 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 transactions, two on first interval]
84 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 4 view changes plus 1 transaction]
85 [connection server1]
86 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 3 transactions, two on first interval]
87 include/assert.inc [GTID_EXECUTED must contain GTID_EXECUTED 4 view changes plus 1 transaction]
88
89 ############################################################
90 # 9. Cleanup
91 SET GTID_NEXT= 'AUTOMATIC';
92 DROP TABLE t1;
93 include/stop_group_replication.inc
94 SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save;
95 Warnings:
96 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
97 [connection server2]
98 include/stop_group_replication.inc
99 SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save;
100 Warnings:
101 Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release.
102 include/group_replication_end.inc