Debian Codegraph @

mysql-test/suite/galera_sr/t/galera_sr_rollback.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 #
5 # Test that ROLLBACK works correctly with streaming replication
6 #
7
8 --connection node_1
9 CREATE TABLE t1 (f1 INTEGER, f2 VARCHAR(10)) ENGINE=InnoDB;
10 SET SESSION wsrep_trx_fragment_size = 1;
11 SET AUTOCOMMIT=OFF;
12 START TRANSACTION;
13 INSERT INTO t1 VALUES (1, 'a');
14 INSERT INTO t1 VALUES (2, 'a');
15 INSERT INTO t1 VALUES (3, 'a');
16 INSERT INTO t1 VALUES (4, 'a');
17 INSERT INTO t1 VALUES (5, 'a');
18
19 --connection node_2
20 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
21 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1;
22 --source include/wait_condition.inc
23
24 --connection node_1
25 INSERT INTO t1 VALUES (11, 'b');
26 INSERT INTO t1 VALUES (12, 'b');
27 INSERT INTO t1 VALUES (13, 'b');
28 INSERT INTO t1 VALUES (14, 'b');
29 INSERT INTO t1 VALUES (15, 'b');
30
31 --connection node_2
32 --let $wait_condition = SELECT COUNT(*) >= 0 FROM t1;
33 --source include/wait_condition.inc
34
35 --connection node_1
36 ROLLBACK;
37
38 #
39 # After ROLLBACK, the table on node #2 should be empty
40 #
41
42 --connection node_2
43 --let $wait_condition = SELECT COUNT(*) = 0 FROM t1;
44 --source include/wait_condition.inc
45
46 #
47 # It should be possible to re-insert the values we just rolled back
48 #
49
50 --connection node_1
51 START TRANSACTION;
52 INSERT INTO t1 VALUES (1, 'a');
53 INSERT INTO t1 VALUES (2, 'a');
54 INSERT INTO t1 VALUES (3, 'a');
55 INSERT INTO t1 VALUES (4, 'a');
56 INSERT INTO t1 VALUES (5, 'a');
57
58 INSERT INTO t1 VALUES (11, 'b');
59 INSERT INTO t1 VALUES (12, 'b');
60 INSERT INTO t1 VALUES (13, 'b');
61 INSERT INTO t1 VALUES (14, 'b');
62 INSERT INTO t1 VALUES (15, 'b');
63
64 --connection node_2
65 --let $wait_condition = SELECT COUNT(*) >= 9 FROM t1;
66 --source include/wait_condition.inc
67
68 --connection node_1
69 COMMIT;
70
71 --connection node_2
72 --let $wait_condition = SELECT COUNT(*) >= 10 FROM t1;
73 --source include/wait_condition.inc
74
75 --connection node_1
76 DROP TABLE t1;