Debian Codegraph @

mysql-test/suite/group_replication/t/gr_parallel_applier_sequential_indexes.test

raw
1 #
2 # Check that Group Replication parallel applier parallelization
3 # indexes are correct according to WL#8440.
4 # All the transactions tested here, despite being committed by
5 # different members (no client commit order preservation) and not
6 # having dependencies from previous transactions, must have
7 # disjoint indexes, that is, must be applied sequentially.
8 # Cases:
9 # 1) DDL
10 # 2) Empty transactions
11 # 3) Management commands, like CREATE USER
12 #
13 --source include/big_test.inc
14 --source include/have_group_replication_plugin.inc
15
16 --echo
17 --echo ############################################################
18 --echo # 1. Setup a new group with four members.
19 --echo # Four view_change transactions will be logged on member
20 --echo # 4. All these transactions, when seen on member 4, will
21 --echo # have indexes:
22 --echo # server_id=4, last_committed=0, sequence_number=0
23 --echo #
24 --let $rpl_server_count= 4
25 --source include/group_replication.inc
26
27 --echo
28 --echo ############################################################
29 --echo # 2. Execute some transactions on member 1, 2 and 3 that will
30 --echo # be applied on member 4 through Group Replication applier.
31 --echo #
32 --let $rpl_connection_name= server1
33 --source include/rpl_connection.inc
34 # server_id=1, last_committed=4, sequence_number=5
35 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
36
37 --let $rpl_connection_name= server2
38 --source include/rpl_connection.inc
39 # server_id=2, last_committed=5, sequence_number=6
40 CREATE USER user@nohost1;
41
42 --let $rpl_connection_name= server3
43 --source include/rpl_connection.inc
44 # server_id=3, last_committed=6, sequence_number=7
45 SET GTID_NEXT= 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
46 BEGIN;
47 COMMIT;
48 SET GTID_NEXT= AUTOMATIC;
49
50 --let $rpl_connection_name= server1
51 --source include/rpl_connection.inc
52 # server_id=1, last_committed=7, sequence_number=8
53 DROP TABLE t1;
54
55 --let $rpl_connection_name= server2
56 --source include/rpl_connection.inc
57 # server_id=2, last_committed=8, sequence_number=9
58 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
59
60 --let $rpl_connection_name= server3
61 --source include/rpl_connection.inc
62 # server_id=3, last_committed=9, sequence_number=10
63 CREATE DATABASE db1;
64 --source include/rpl_sync.inc
65
66
67 --echo
68 --echo ############################################################
69 --echo # 3. Dump Group Replication applier channel relay log and
70 --echo # validate its indexes on member 4.
71 --echo #
72 --let $rpl_connection_name= server4
73 --source include/rpl_connection.inc
74
75 --let $dump_file=$MYSQLTEST_VARDIR/tmp/group_replication_parallel_applier_sequential_indexes.dump
76 --exec $MYSQL_BINLOG --force-if-open $server_4_datadir/server-relay-log-group_replication_applier.000002 > $dump_file
77 --let $grep_file= $dump_file
78 --let $grep_pattern= last_committed
79 --let $grep_output= print_each
80 --replace_regex /# at [0-9]*/# at #/ /#[0-9]+/#time#/ /[[:space:]]+[0-9]+:[0-9]+:[0-9]+/ ##:##:##/ /end_log_pos [0-9]+/end_log_pos ##/ /original_committed_timestamp=[0-9]*/original_committed_timestamp=##:##:##/ /immediate_commit_timestamp=[0-9]*/immediate_commit_timestamp=##:##:##/ /transaction_length=[0-9]*/transaction_length=#/
81 --source include/grep_pattern.inc
82 --remove_file $dump_file
83
84 --let $binlog_file= server-relay-log-group_replication_applier.000002
85 --let $logical_timestamps= 0 0;0 0;0 0;1 2;2 3;3 4;4 5;5 6;6 7
86 --source include/assert_logical_timestamps.inc
87 --let $is_relay_log= 1
88 --source include/assert_transaction_length.inc
89
90
91 --echo
92 --echo ############################################################
93 --echo # 4. Test cleanup.
94 DROP USER user@nohost1;
95 DROP TABLE t2;
96 DROP DATABASE db1;
97 --source include/group_replication_end.inc