Debian Codegraph @

mysql-test/suite/binlog/t/binlog_transaction_dependency_tracking_on_start.test

raw
1 ################################################################################
2 # The testcase aims to test possible correct and incorrect settings of the
3 # following variables together during the start of the server:
4 # transaction_write_set_extraction (TWSE)
5 # binlog_transaction_dependency_tracking (BTDT)
6 #
7 # Test:
8 # 0. This test requires one server.
9 # 1. Try starting server with:
10 # a. TWSE=OFF and BTDT=COMMIT_ORDER. Expect SUCCESS.
11 # b. TWSE=OFF and BTDT=WRITESET. Expect FAILURE.
12 # c. TWSE=OFF and BTDT=WRITESET_SESSION. Expect FAILURE.
13 # d. TWSE=MURMUR32 and BTDT=COMMIT_ORDER. Expect SUCCESS.
14 # e. TWSE=MURMUR32 and BTDT=WRITESET. Expect SUCCESS.
15 # f. TWSE=MURMUR32 and BTDT=WRITESET_SESSION. Expect SUCCESS.
16 # g. TWSE=XXHASH64 and BTDT=COMMIT_ORDER. Expect SUCCESS.
17 # h. TWSE=XXHASH64 and BTDT=WRITESET. Expect SUCCESS
18 # i. TWSE=XXHASH64 and BTDT=WRITESET_SESSION. Expect SUCCESS.
19 #
20 # ==== References ====
21 # WL#9556: Writeset-based MTS dependency tracking on master
22 ################################################################################
23 --source include/big_test.inc
24 --source include/have_binlog_format_row.inc
25
26 --let $saved_binlog_transaction_dependency_tracking= `SELECT @@GLOBAL.binlog_transaction_dependency_tracking`
27 --let $saved_transaction_write_set_extraction= `SELECT @@GLOBAL.transaction_write_set_extraction`
28
29 --echo #
30 --echo # Test 1.a: Try starting server with TWSE=OFF and BTDT=COMMIT_ORDER. Expect SUCCESS.
31 --echo #
32 --let $restart_parameters="restart: --transaction_write_set_extraction=OFF --binlog_transaction_dependency_tracking=COMMIT_ORDER"
33 --source include/restart_mysqld.inc
34 --source include/wait_until_connected_again.inc
35 --let $assert_text= transaction_write_set_extraction should be OFF
36 --let $assert_cond= "[SELECT @@GLOBAL.transaction_write_set_extraction]" = "OFF"
37 --source include/assert.inc
38 --let $assert_text= binlog_transaction_dependency_tracking should be COMMIT_ORDER
39 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "COMMIT_ORDER"
40 --source include/assert.inc
41
42 --echo #
43 --echo # Test 1.b: Try starting server with TWSE=OFF and BTDT=WRITESET. Expect FAILURE.
44 --echo #
45 # Let server restart attempts write to the file $error_log.
46 --let $error_log= $MYSQLTEST_VARDIR/tmp/binlog_transaction_dependency_tracking.err
47 --source include/shutdown_mysqld.inc
48
49 let $mysqld=$MYSQLD_CMD --core-file --console > $error_log 2>&1 --transaction_write_set_extraction=OFF --binlog_transaction_dependency_tracking=WRITESET;
50
51 --error 1
52 --exec $mysqld
53 --let $grep_file=$error_log
54 --let $grep_pattern=The transaction_write_set_extraction must be set to XXHASH64 or MURMUR32 when binlog_transaction_dependency_tracking is WRITESET or WRITESET_SESSION.
55 --let $grep_output= print_count
56 --source include/grep_pattern.inc
57
58 # The server restart aborts
59 --let $grep_pattern= \[ERROR\] \[[^]]*\] \[[^]]*\] Aborting
60 --let $grep_output= print_count
61 --source include/grep_pattern.inc
62
63 --echo #
64 --echo # Test 1.c: Try starting server with TWSE=OFF and BTDT=WRITESET_SESSION. Expect FAILURE.
65 --echo #
66 let $mysqld=$MYSQLD_CMD --core-file --console > $error_log 2>&1 --transaction_write_set_extraction=OFF --binlog_transaction_dependency_tracking=WRITESET_SESSION;
67
68 --error 1
69 --exec $mysqld
70 --let $grep_file=$error_log
71 --let $grep_pattern=The transaction_write_set_extraction must be set to XXHASH64 or MURMUR32 when binlog_transaction_dependency_tracking is WRITESET or WRITESET_SESSION.
72 --let $grep_output= print_count
73 --source include/grep_pattern.inc
74
75 # The server restart aborts
76 --let $grep_pattern= \[ERROR\] \[[^]]*\] \[[^]]*\] Aborting
77 --let $grep_output= print_count
78 --source include/grep_pattern.inc
79
80 --echo #
81 --echo # Test 1.d: Try starting server with TWSE=MURMUR32 and BTDT=COMMIT_ORDER. Expect SUCCESS.
82 --echo #
83 --let $restart_parameters="restart: --transaction_write_set_extraction=MURMUR32 --binlog_transaction_dependency_tracking=COMMIT_ORDER"
84 --source include/start_mysqld.inc
85 --source include/wait_until_connected_again.inc
86 --let $assert_text= transaction_write_set_extraction should be MURMUR32
87 --let $assert_cond= "[SELECT @@GLOBAL.transaction_write_set_extraction]" = "MURMUR32"
88 --source include/assert.inc
89 --let $assert_text= binlog_transaction_dependency_tracking should be COMMIT_ORDER
90 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "COMMIT_ORDER"
91 --source include/assert.inc
92
93 --echo #
94 --echo # Test 1.e: Try starting server with TWSE=MURMUR32 and BTDT=WRITESET. Expect SUCCESS.
95 --echo #
96 --let $restart_parameters="restart: --transaction_write_set_extraction=MURMUR32 --binlog_transaction_dependency_tracking=WRITESET"
97 --source include/restart_mysqld.inc
98 --source include/wait_until_connected_again.inc
99 --let $assert_text= transaction_write_set_extraction should be MURMUR32
100 --let $assert_cond= "[SELECT @@GLOBAL.transaction_write_set_extraction]" = "MURMUR32"
101 --source include/assert.inc
102 --let $assert_text= binlog_transaction_dependency_tracking should be WRITESET
103 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "WRITESET"
104 --source include/assert.inc
105
106 --echo #
107 --echo # Test 1.f: Try starting server with TWSE=MURMUR32 and BTDT=WRITESET_SESSION. Expect SUCCESS.
108 --echo #
109 --let $restart_parameters="restart: --transaction_write_set_extraction=MURMUR32 --binlog_transaction_dependency_tracking=WRITESET_SESSION"
110 --source include/restart_mysqld.inc
111 --source include/wait_until_connected_again.inc
112 --let $assert_text= transaction_write_set_extraction should be MURMUR32
113 --let $assert_cond= "[SELECT @@GLOBAL.transaction_write_set_extraction]" = "MURMUR32"
114 --source include/assert.inc
115 --let $assert_text= binlog_transaction_dependency_tracking should be WRITESET_SESSION
116 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "WRITESET_SESSION"
117 --source include/assert.inc
118
119 --echo #
120 --echo # Test 1.g: Try starting server with TWSE=XXHASH64 and BTDT=COMMIT_ORDER. Expect SUCCESS.
121 --echo #
122 --let $restart_parameters="restart: --transaction_write_set_extraction=XXHASH64 --binlog_transaction_dependency_tracking=COMMIT_ORDER"
123 --source include/restart_mysqld.inc
124 --source include/wait_until_connected_again.inc
125 --let $assert_text= transaction_write_set_extraction should be XXHASH64
126 --let $assert_cond= "[SELECT @@GLOBAL.transaction_write_set_extraction]" = "XXHASH64"
127 --source include/assert.inc
128 --let $assert_text= binlog_transaction_dependency_tracking should be COMMIT_ORDER
129 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "COMMIT_ORDER"
130 --source include/assert.inc
131
132 --echo #
133 --echo # Test 1.h: Try starting server with TWSE=XXHASH64 and BTDT=WRITESET. Expect SUCCESS
134 --echo #
135 --let $restart_parameters="restart: --transaction_write_set_extraction=XXHASH64 --binlog_transaction_dependency_tracking=WRITESET"
136 --source include/restart_mysqld.inc
137 --source include/wait_until_connected_again.inc
138 --let $assert_text= transaction_write_set_extraction should be XXHASH64
139 --let $assert_cond= "[SELECT @@GLOBAL.transaction_write_set_extraction]" = "XXHASH64"
140 --source include/assert.inc
141 --let $assert_text= binlog_transaction_dependency_tracking should be WRITESET
142 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "WRITESET"
143 --source include/assert.inc
144
145 --echo #
146 --echo # Test 1.i: Try starting server with TWSE=XXHASH64 and BTDT=WRITESET_SESSION. Expect SUCCESS.
147 --echo #
148 --let $restart_parameters="restart: --transaction_write_set_extraction=XXHASH64 --binlog_transaction_dependency_tracking=WRITESET_SESSION"
149 --source include/restart_mysqld.inc
150 --source include/wait_until_connected_again.inc
151 --let $assert_text= transaction_write_set_extraction should be XXHASH64
152 --let $assert_cond= "[SELECT @@GLOBAL.transaction_write_set_extraction]" = "XXHASH64"
153 --source include/assert.inc
154 --let $assert_text= binlog_transaction_dependency_tracking should be WRITESET_SESSION
155 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "WRITESET_SESSION"
156 --source include/assert.inc
157
158 # Clean up
159 --let $restart_parameters=
160 --let $error_log=
161 --remove_file $MYSQLTEST_VARDIR/tmp/binlog_transaction_dependency_tracking.err
162 --eval SET GLOBAL binlog_transaction_dependency_tracking= COMMIT_ORDER
163 --replace_result $saved_transaction_write_set_extraction SAVED_TWSE
164 --eval SET GLOBAL transaction_write_set_extraction= $saved_transaction_write_set_extraction
165 --eval SET GLOBAL binlog_transaction_dependency_tracking= $saved_binlog_transaction_dependency_tracking