Debian Codegraph @

mysql-test/suite/binlog/r/binlog_transaction_dependency_tracking_on_start.result

raw
1 #
2 # Test 1.a: Try starting server with TWSE=OFF and BTDT=COMMIT_ORDER. Expect SUCCESS.
3 #
4 # restart: --transaction_write_set_extraction=OFF --binlog_transaction_dependency_tracking=COMMIT_ORDER
5 include/assert.inc [transaction_write_set_extraction should be OFF]
6 include/assert.inc [binlog_transaction_dependency_tracking should be COMMIT_ORDER]
7 #
8 # Test 1.b: Try starting server with TWSE=OFF and BTDT=WRITESET. Expect FAILURE.
9 #
10 Occurrences of 'The transaction_write_set_extraction must be set to XXHASH64 or MURMUR32 when binlog_transaction_dependency_tracking is WRITESET or WRITESET_SESSION.' in the input file: 1
11 Occurrences of '\[ERROR\] \[[^]]*\] \[[^]]*\] Aborting' in the input file: 1
12 #
13 # Test 1.c: Try starting server with TWSE=OFF and BTDT=WRITESET_SESSION. Expect FAILURE.
14 #
15 Occurrences of 'The transaction_write_set_extraction must be set to XXHASH64 or MURMUR32 when binlog_transaction_dependency_tracking is WRITESET or WRITESET_SESSION.' in the input file: 1
16 Occurrences of '\[ERROR\] \[[^]]*\] \[[^]]*\] Aborting' in the input file: 1
17 #
18 # Test 1.d: Try starting server with TWSE=MURMUR32 and BTDT=COMMIT_ORDER. Expect SUCCESS.
19 #
20 # restart: --transaction_write_set_extraction=MURMUR32 --binlog_transaction_dependency_tracking=COMMIT_ORDER
21 include/assert.inc [transaction_write_set_extraction should be MURMUR32]
22 include/assert.inc [binlog_transaction_dependency_tracking should be COMMIT_ORDER]
23 #
24 # Test 1.e: Try starting server with TWSE=MURMUR32 and BTDT=WRITESET. Expect SUCCESS.
25 #
26 # restart: --transaction_write_set_extraction=MURMUR32 --binlog_transaction_dependency_tracking=WRITESET
27 include/assert.inc [transaction_write_set_extraction should be MURMUR32]
28 include/assert.inc [binlog_transaction_dependency_tracking should be WRITESET]
29 #
30 # Test 1.f: Try starting server with TWSE=MURMUR32 and BTDT=WRITESET_SESSION. Expect SUCCESS.
31 #
32 # restart: --transaction_write_set_extraction=MURMUR32 --binlog_transaction_dependency_tracking=WRITESET_SESSION
33 include/assert.inc [transaction_write_set_extraction should be MURMUR32]
34 include/assert.inc [binlog_transaction_dependency_tracking should be WRITESET_SESSION]
35 #
36 # Test 1.g: Try starting server with TWSE=XXHASH64 and BTDT=COMMIT_ORDER. Expect SUCCESS.
37 #
38 # restart: --transaction_write_set_extraction=XXHASH64 --binlog_transaction_dependency_tracking=COMMIT_ORDER
39 include/assert.inc [transaction_write_set_extraction should be XXHASH64]
40 include/assert.inc [binlog_transaction_dependency_tracking should be COMMIT_ORDER]
41 #
42 # Test 1.h: Try starting server with TWSE=XXHASH64 and BTDT=WRITESET. Expect SUCCESS
43 #
44 # restart: --transaction_write_set_extraction=XXHASH64 --binlog_transaction_dependency_tracking=WRITESET
45 include/assert.inc [transaction_write_set_extraction should be XXHASH64]
46 include/assert.inc [binlog_transaction_dependency_tracking should be WRITESET]
47 #
48 # Test 1.i: Try starting server with TWSE=XXHASH64 and BTDT=WRITESET_SESSION. Expect SUCCESS.
49 #
50 # restart: --transaction_write_set_extraction=XXHASH64 --binlog_transaction_dependency_tracking=WRITESET_SESSION
51 include/assert.inc [transaction_write_set_extraction should be XXHASH64]
52 include/assert.inc [binlog_transaction_dependency_tracking should be WRITESET_SESSION]
53 SET GLOBAL binlog_transaction_dependency_tracking= COMMIT_ORDER;
54 Warnings:
55 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
56 SET GLOBAL transaction_write_set_extraction= SAVED_TWSE;
57 Warnings:
58 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
59 SET GLOBAL binlog_transaction_dependency_tracking= COMMIT_ORDER;
60 Warnings:
61 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.