Debian Codegraph @

mysql-test/suite/galera_sr/t/GCF-572.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
5
6 #
7 # Test 1: statement rollback is not safe.
8 # Statement has already replicated some fragments
9 #
10 --connection node_1
11 SET SESSION wsrep_trx_fragment_size = 1;
12 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
13 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY);
14 INSERT INTO t2 VALUES (1),(2),(3);
15 ALTER TABLE t2 DROP PRIMARY KEY;
16 INSERT INTO t2 VALUES (1);
17
18 SET SESSION wsrep_trx_fragment_size = 1;
19 START TRANSACTION;
20
21 # The following INSERT .. SELECT inserts a duplicate key,
22 # ER_LOCK_DEADLOCK is the only possible outcome at this point.
23 # Notice that ER_DUP_ENTRY is NOT an option here because we were
24 # forced to rollback the whole transaction (not just the statement)
25 --error ER_LOCK_DEADLOCK
26 INSERT INTO t1 SELECT * FROM t2;
27 SELECT * FROM t1;
28
29 --connection node_2
30 SELECT * FROM t1;
31
32 --connection node_1
33 DROP TABLE t1;
34 DROP TABLE t2;
35
36 #
37 # Test 2: statement rollback is safe.
38 # Fragments were already replicated, not in the same statement
39 #
40 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT, f2 CHAR(10)) ENGINE=InnoDB;
41 --connection node_1
42 SET innodb_snapshot_isolation = OFF;
43 SET SESSION wsrep_trx_fragment_size = 1;
44 START TRANSACTION;
45 INSERT INTO t1 VALUES (1, 'node1');
46
47 --connection node_1a
48 INSERT INTO t1 VALUES (5, 'node2');
49
50 --connection node_1
51 # Only the statement is rolled back, expect ER_DUP_ENTRY
52 --error ER_DUP_ENTRY
53 INSERT INTO t1 VALUES (5, 'node1');
54
55 SELECT * FROM t1;
56
57 #
58 # Test 3: statement rollback is safe
59 # No fragments have been replicated
60 #
61 SET SESSION wsrep_trx_fragment_size = 10000;
62
63 START TRANSACTION;
64 INSERT INTO t1 VALUE (10, 'node1');
65
66 --connection node_1a
67 INSERT INTO t1 VALUES(15, 'node2');
68
69 --connection node_1
70 SELECT * FROM t1;
71 # This time, only the statement is rolled back and we expect ER_DUP_ENTRY.
72 --error ER_DUP_ENTRY
73 INSERT INTO t1 VALUES(15, 'node1');
74
75 COMMIT;
76 SELECT * FROM t1;
77
78 DROP TABLE t1;