Debian Codegraph @

mysql-test/suite/rpl/t/rpl_mts_replica_preserve_commit_order_nobinlog.test

raw
1 # ==== Purpose ====
2 #
3 # Verifies that replica-preserve-commit-order works even for those cases
4 # where applier worker threads are not logging the changes to the
5 # replicas binary log.
6 #
7 # ==== Implementation ====
8 #
9 # 1. We start replica (server2) with the binary log turned off (--log-bin=OFF)
10 # and applier threads are not logging to its own binary log
11 # (--log-replica-updates=OFF). Replica also has replica_preserve_commit_order
12 # enabled and running with 2 applier workers.
13 #
14 # 2. On slave, we add the same first insert statement which will be applied on
15 # master in step 3, but we do not commit it, to take a lock on row and block
16 # slave sql thread when transaction are applied on master in setp 3.
17 #
18 # 3. The master generates some transactions which can be applied in parallel,
19 # by setting same commit parents for all the inserts.
20 #
21 # 4. On slave, we verify that all the other inserts are also blocked and waiting
22 # for first insert to commit i.e. applier threads are in stage 'Waiting for
23 # preceding transaction to commit' and their is no data in table except first
24 # insert.
25 #
26 # 5. On slave, we rollback the insert executed in step 2, and verify the
27 # transactions applied in step 3 are applied successfully.
28 #
29 # 6. Cleanup.
30
31 --source include/have_debug.inc
32 --source include/have_debug_sync.inc
33
34 --let $rpl_skip_start_slave = 1
35 --source include/master-slave.inc
36
37 --let $mts_replica_parallel_workers= 8
38 --let $mts_num_preceding_trans= 6
39 --let $mts_spco_start_statement = CREATE TABLE t1 (c1 INT PRIMARY KEY) ENGINE = InnoDB; CREATE TABLE t2 (c1 INT PRIMARY KEY) ENGINE = InnoDB;
40 --let $mts_spco_block_statement = BEGIN; INSERT INTO t1 VALUES (1);
41
42 --let $mts_spco_parallel_statement1 = BEGIN; INSERT INTO t1 VALUES (1); COMMIT; BEGIN; INSERT INTO t2 VALUES (2); COMMIT; BEGIN; INSERT INTO t2 VALUES (3); COMMIT; BEGIN; INSERT INTO t2 VALUES (4); COMMIT;
43 --let $mts_spco_parallel_statement2 = BEGIN; INSERT INTO t2 VALUES (5); COMMIT; BEGIN; INSERT INTO t2 VALUES (6); COMMIT; BEGIN; INSERT INTO t2 VALUES (7); COMMIT;
44
45 --let $mts_spco_assert_text1 = Verify table t1 is empty
46 --let $mts_spco_assert_cond1 = "[SELECT count(*) COUNT FROM t1, COUNT, 1]" = "0"
47
48 --let $mts_spco_assert_text2 = Verify table t2 is empty
49 --let $mts_spco_assert_cond2 = "[SELECT count(*) COUNT FROM t2, COUNT, 1]" = "0"
50
51 --let $mts_spco_rollback_statement = ROLLBACK;
52 --let $mts_spco_end_statement = DROP TABLE t1; DROP TABLE t2;
53 --let $mts_spco_cleanup_statement = 1
54
55 --source extra/rpl_tests/rpl_mts_replica_preserve_commit_order_nobinlog.inc