Debian Codegraph @

mysql-test/suite/rpl_gtid/t/rpl_server_version_line_topology.test

raw
1 #
2 # ==== Purpose ====
3 #
4 # In this test, we check that original_server_version and
5 # immediate_server_version are correctly generated and replicated in a
6 # server_1 (Master) -> server_2 -> server_3 topology.
7 #
8 # ==== Implementation ====
9 #
10 # Considering the above replication topology, we test two scenarios:
11 # Scenario 1: Force server_1 to write as its original_server_version the value
12 # 888888, synchronize all three servers and check that the value is replicated
13 # unchanged. Also force server_1 to write 888888 as its immediate_server_version
14 # to check that the value is written to its binlog but in server_2 and server_3
15 # their own server versions are written to the binlog
16 # Scenario 2: Execute a transaction in server_2, synchronize with server_3, and
17 # check that the value written to server_2's binlog is the expected one and that
18 # it is replicated correctly to server_3. Also check that their
19 # immediate_server_versions correspond to their own server version.
20 #
21 # ==== References ====
22 #
23 # WL#11879 replicate original server version
24
25
26 # test is binlog format agnostic
27 --source include/have_binlog_format_row.inc
28 --source include/have_debug.inc
29
30 # Establish the line topology.
31 --let $rpl_topology = 1->2, 2->3
32 --source include/rpl_init.inc
33
34 # transform server version in format AA.BB.CC[-suffix] into AABBCC
35 --write_file $MYSQL_TMP_DIR/get_numerical_server_version.inc
36 --let $server_version = `SELECT @@GLOBAL.version`
37 --let $major_version_number = `SELECT SUBSTRING_INDEX('$server_version', '.', 1)`
38 --let $mid_version_number = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('$server_version', '.', 2), '.', -1)`
39 --let $minor_version_number = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX('$server_version', '-', 1), '.', -1)`
40 --let $numerical_server_version = `SELECT $major_version_number * 10000 + $mid_version_number * 100 + $minor_version_number`
41 EOF
42
43 --let $rpl_connection_name = server_1
44 --source include/rpl_connection.inc
45
46 # Scenario 1:
47 # force server_1 to write 888888 as its original_server_version to check that
48 # the value is replicated unchanged
49 # force server_1 to write 888888 as its immediate_server_version to check that
50 # the value is written to its binlog but in server_2 and server_3 their own
51 # server versions are written to the binlog
52 --let $debug_point = fixed_server_version
53 --source include/add_debug_point.inc
54
55 --let $server_uuid = query_get_value(select @@global.server_uuid, @@global.server_uuid, 1)
56 --let $gtid = $server_uuid:1
57
58 CREATE TABLE t1 (a INT);
59 --source include/rpl_sync.inc
60
61 --let $rpl_connection_name = server_1
62 --source include/rpl_connection.inc
63 --source include/get_original_server_version.inc
64 --let $OSV_1 = $original_server_version
65 --source include/get_immediate_server_version.inc
66 --let $ISV_1 = $immediate_server_version
67
68 --let $rpl_connection_name = server_2
69 --source include/rpl_connection.inc
70 --source include/get_original_server_version.inc
71 --let $OSV_2 = $original_server_version
72 --source include/get_immediate_server_version.inc
73 --let $ISV_2 = $immediate_server_version
74 --source $MYSQL_TMP_DIR/get_numerical_server_version.inc
75 --let $numerical_server_version_2 = $numerical_server_version
76
77 --let $rpl_connection_name = server_3
78 --source include/rpl_connection.inc
79 --source include/get_original_server_version.inc
80 --let $OSV_3 = $original_server_version
81 --source include/get_immediate_server_version.inc
82 --let $ISV_3 = $immediate_server_version
83 --source $MYSQL_TMP_DIR/get_numerical_server_version.inc
84 --let $numerical_server_version_3 = $numerical_server_version
85
86 --let $assert_text = server_1 original_server_version must be 888888
87 --let $assert_cond = $OSV_1 = 888888
88 --source include/assert.inc
89
90 --let $assert_text = server_2 original_server_version must be equal to server_1
91 --let $assert_cond = $OSV_2 = $OSV_1
92 --source include/assert.inc
93
94 --let $assert_text = server_3 original_server_version must be equal to server_2
95 --let $assert_cond = $OSV_3 = $OSV_2
96 --source include/assert.inc
97
98 --let $assert_text = server_1 immediate_server_version must be 888888
99 --let $assert_cond = $ISV_1 = 888888
100 --source include/assert.inc
101
102 --let $assert_text = server_2 immediate_server_version must be equal its own server version
103 --let $assert_cond = $ISV_2 = $numerical_server_version_2
104 --source include/assert.inc
105
106 --let $assert_text = server_3 immediate_server_version must be equal its own server version
107 --let $assert_cond = $ISV_3 = $numerical_server_version_3
108 --source include/assert.inc
109
110 # Scenario 2:
111 # execute a transaction in server_2 to check that the correct value of
112 # original_server_version is generated and replicated Also check that their
113 # immediate_server_versions correspond to their own server version.
114 --let $rpl_connection_name = server_2
115 --source include/rpl_connection.inc
116
117 --let $server_uuid = query_get_value(select @@global.server_uuid, @@global.server_uuid, 1)
118 --let $gtid = $server_uuid:1
119
120 INSERT INTO t1 VALUES (1);
121
122 # sync server_3 with server_2
123 --let $rpl_channel_name =
124 --let $sync_slave_connection = server_3
125 --source include/sync_slave_sql_with_master.inc
126 --let $sync_slave_connection =
127
128 --let $rpl_connection_name = server_2
129 --source include/rpl_connection.inc
130 --source include/get_original_server_version.inc
131 --let $OSV_2 = $original_server_version
132 --source include/get_immediate_server_version.inc
133 --let $ISV_2 = $immediate_server_version
134
135 --let $rpl_connection_name = server_3
136 --source include/rpl_connection.inc
137 --source include/get_original_server_version.inc
138 --let $OSV_3 = $original_server_version
139 --source include/get_immediate_server_version.inc
140 --let $ISV_3 = $immediate_server_version
141
142 --let $assert_text = server_2 original_server_version must be equal its own server version
143 --let $assert_cond = $numerical_server_version_2 = $OSV_2
144 --source include/assert.inc
145
146 --let $assert_text = server_3 original_server_version must be equal to server_2
147 --let $assert_cond = $OSV_3 = $OSV_2
148 --source include/assert.inc
149
150 --let $assert_text = server_2 immediate_server_version must be equal its own server version
151 --let $assert_cond = $ISV_2 = $numerical_server_version_2
152 --source include/assert.inc
153
154 --let $assert_text = server_3 immediate_server_version must be equal its own server version
155 --let $assert_cond = $ISV_3 = $numerical_server_version_3
156 --source include/assert.inc
157
158 # cleanup
159 --let $rpl_connection_name= server_1
160 --source include/rpl_connection.inc
161 --let $debug_point = fixed_server_version
162 --source include/remove_debug_point.inc
163 DROP TABLE t1;
164 --source include/rpl_sync.inc
165 --source include/rpl_end.inc
166 --remove_file $MYSQL_TMP_DIR/get_numerical_server_version.inc