Debian Codegraph @

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

raw
1
2 ############################################################
3 # 1. Setup a new group with four members.
4 # Four view_change transactions will be logged on member
5 # 4. All these transactions, when seen on member 4, will
6 # have indexes:
7 # server_id=4, last_committed=0, sequence_number=0
8 #
9 include/group_replication.inc [rpl_server_count=4]
10 Warnings:
11 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
12 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.
13 [connection server1]
14
15 # Execute some transactions on member 1, 2 and 3 that will
16 # be applied on member 4 through Group Replication applier.
17 #
18 [connection server1]
19 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
20 include/rpl_sync.inc
21 [connection server2]
22 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
23 INSERT INTO t1 VALUES (1);
24 SET GTID_NEXT= AUTOMATIC;
25 include/rpl_sync.inc
26 [connection server3]
27 INSERT INTO t1 VALUES (3);
28 [connection server1]
29 UPDATE t1 SET c1=2 WHERE c1=1;
30 include/rpl_sync.inc
31 [connection server1]
32 include/stop_group_replication.inc
33
34 # Dump Group Replication applier channel relay log and
35 # validate its indexes on member 4.
36 #
37 [connection server4]
38 Matching lines are:
39 #time# ##:##:## server id 4 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
40 #time# ##:##:## server id 4 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
41 #time# ##:##:## server id 4 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
42 #time# ##:##:## server id 4 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
43 #time# ##:##:## server id 1 end_log_pos ## GTID last_committed=1 sequence_number=2 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
44 #time# ##:##:## server id 2 end_log_pos ## GTID last_committed=2 sequence_number=3 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
45 #time# ##:##:## server id 3 end_log_pos ## GTID last_committed=2 sequence_number=4 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
46 #time# ##:##:## server id 1 end_log_pos ## GTID last_committed=3 sequence_number=5 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
47 Occurrences of 'last_committed' in the input file: 8
48 include/include/assert_logical_timestamps.inc [0 0;0 0;0 0;1 2;2 3;2 4;3 5]
49 Asserting all GTID transaction length information in 'server-relay-log-group_replication_applier.000002'
50 Inspected 7 transactions, all with correct transaction length.
51
52 ############################################################
53 # 2. Stop and start member 2 to force a relay log flush.
54 # Start member 1 again and execute another transactions
55 # on members 1 and 2.
56 # Purpose of the test: show that local transactions do
57 # not interfere with remote transactions, the ones that
58 # go through parallel applier.
59 #
60 [connection server2]
61 include/stop_group_replication.inc
62 include/start_group_replication.inc
63 [connection server1]
64 include/start_group_replication.inc
65 [connection server3]
66 INSERT INTO t1 VALUES (4);
67 include/rpl_sync.inc
68 [connection server2]
69 UPDATE t1 SET c1=5 WHERE c1=4;
70 include/rpl_sync.inc
71 [connection server1]
72 INSERT INTO t1 VALUES (6);
73 include/rpl_sync.inc
74 [connection server4]
75 UPDATE t1 SET c1=7 WHERE c1=6;
76 include/rpl_sync.inc
77
78 # Dump Group Replication applier channel relay log and
79 # validate its indexes on member 2.
80 #
81 [connection server2]
82 Matching lines are:
83 #time# ##:##:## server id 2 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
84 #time# ##:##:## server id 2 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
85 #time# ##:##:## server id 3 end_log_pos ## GTID last_committed=1 sequence_number=2 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
86 #time# ##:##:## server id 1 end_log_pos ## GTID last_committed=1 sequence_number=3 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
87 #time# ##:##:## server id 4 end_log_pos ## GTID last_committed=3 sequence_number=4 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
88 Occurrences of 'last_committed' in the input file: 5
89 include/include/assert_logical_timestamps.inc [0 0;1 2;1 3;3 4]
90 Asserting all GTID transaction length information in 'server-relay-log-group_replication_applier.000003'
91 Inspected 4 transactions, all with correct transaction length.
92
93 # Dump Group Replication applier channel relay log and
94 # validate its indexes on member 1.
95 #
96 [connection server1]
97 Matching lines are:
98 #time# ##:##:## server id 1 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
99 #time# ##:##:## server id 3 end_log_pos ## GTID last_committed=1 sequence_number=2 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
100 #time# ##:##:## server id 2 end_log_pos ## GTID last_committed=2 sequence_number=3 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
101 #time# ##:##:## server id 4 end_log_pos ## GTID last_committed=1 sequence_number=4 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
102 Occurrences of 'last_committed' in the input file: 4
103 include/include/assert_logical_timestamps.inc [0 0;1 2;2 3;1 4]
104 Asserting all GTID transaction length information in 'server-relay-log-group_replication_applier.000003'
105 Inspected 3 transactions, all with correct transaction length.
106
107 ############################################################
108 # 3. Wait for stable set propagation and certification info
109 # garbage collection on members 1 and 2.
110 [connection server1]
111 [connection server2]
112
113 # Execute some more transactions and assert that
114 # last_committed index was update with previous
115 # sequence_number, even when transactions do not
116 # depend on previous transactions.
117 [connection server1]
118 INSERT INTO t1 VALUES (8);
119 [connection server2]
120 INSERT INTO t1 VALUES (9);
121 include/rpl_sync.inc
122
123 # Dump Group Replication applier channel relay log and
124 # validate its indexes on member 2.
125 #
126 [connection server2]
127 Matching lines are:
128 #time# ##:##:## server id 2 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
129 #time# ##:##:## server id 2 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
130 #time# ##:##:## server id 3 end_log_pos ## GTID last_committed=1 sequence_number=2 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
131 #time# ##:##:## server id 1 end_log_pos ## GTID last_committed=1 sequence_number=3 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
132 #time# ##:##:## server id 4 end_log_pos ## GTID last_committed=3 sequence_number=4 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
133 #time# ##:##:## server id 1 end_log_pos ## GTID last_committed=4 sequence_number=5 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
134 Occurrences of 'last_committed' in the input file: 6
135 include/include/assert_logical_timestamps.inc [0 0;1 2;1 3;3 4;4 5]
136 Asserting all GTID transaction length information in 'server-relay-log-group_replication_applier.000003'
137 Inspected 5 transactions, all with correct transaction length.
138
139 # Dump Group Replication applier channel relay log and
140 # validate its indexes on member 1.
141 #
142 [connection server1]
143 Matching lines are:
144 #time# ##:##:## server id 1 end_log_pos ## GTID last_committed=0 sequence_number=0 rbr_only=no original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
145 #time# ##:##:## server id 3 end_log_pos ## GTID last_committed=1 sequence_number=2 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
146 #time# ##:##:## server id 2 end_log_pos ## GTID last_committed=2 sequence_number=3 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
147 #time# ##:##:## server id 4 end_log_pos ## GTID last_committed=1 sequence_number=4 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
148 #time# ##:##:## server id 2 end_log_pos ## GTID last_committed=4 sequence_number=5 rbr_only=yes original_committed_timestamp=##:##:## immediate_commit_timestamp=##:##:## transaction_length=#
149 Occurrences of 'last_committed' in the input file: 5
150 include/include/assert_logical_timestamps.inc [1 2;2 3;1 4;4 5]
151 Asserting all GTID transaction length information in 'server-relay-log-group_replication_applier.000003'
152 Inspected 4 transactions, all with correct transaction length.
153
154 ############################################################
155 # 4. Test cleanup.
156 DROP TABLE t1;
157 include/group_replication_end.inc