Debian Codegraph @

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

raw
1 #
2 # Test multirow insert rollback with streaming replication
3 #
4
5 --source include/galera_cluster.inc
6
7
8 #
9 # Case 1: multirow insert results full rollback if a fragment
10 # managed to replicate
11 #
12 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
13
14 --connection node_1
15 SET SESSION wsrep_trx_fragment_size = 1;
16 START TRANSACTION;
17 # With fragment size 1 we expect full rollback
18 # because a fragment is already replicated.
19 # Therefore, expect ER_LOCK_DEADLOCK instead of ER_DUP_ENTRY
20 --error ER_LOCK_DEADLOCK
21 INSERT INTO t1 (f2) VALUES ('a'), ('b');
22 COMMIT;
23
24 SELECT COUNT(*) AS expect_0 FROM t1;
25
26 --connection node_2
27 SELECT COUNT(*) AS expect_0 FROM t1;
28
29 DROP TABLE t1;
30
31
32 #
33 # Case 2: error on multirow insert results in empty commit
34 #
35 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
36
37 --connection node_1
38 SET SESSION wsrep_trx_fragment_size = 1000;
39 START TRANSACTION;
40 --error ER_DUP_ENTRY
41 INSERT INTO t1 (f2) VALUES ('a'), ('b');
42 COMMIT;
43
44 SELECT COUNT(*) AS expect_0 FROM t1;
45
46 --connection node_2
47 SELECT COUNT(*) AS expect_0 FROM t1;
48
49 DROP TABLE t1;
50
51
52 #
53 # Case 3: error on multirow insert does not affect previous statements
54 #
55 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
56
57 --connection node_1
58 SET SESSION wsrep_trx_fragment_size = 1000;
59 START TRANSACTION;
60 INSERT INTO t1 VALUES (1, 'a');
61 INSERT INTO t1 VALUES (2, 'b');
62 --error ER_DUP_ENTRY
63 INSERT INTO t1 (f2) VALUES ('c'), ('d');
64 COMMIT;
65
66 --echo expect (1,'a'), (2, 'b')
67 SELECT * FROM t1;
68
69 --connection node_2
70 --echo expect (1,'a'), (2, 'b')
71 SELECT * FROM t1;
72
73 DROP TABLE t1;
74
75
76 #
77 # Case 4: error on autocommit multirow insert
78 #
79 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY DEFAULT 0, f2 char(12));
80
81 --connection node_1
82 SET SESSION wsrep_trx_fragment_size = 1;
83
84 --error ER_DUP_ENTRY
85 INSERT INTO t1 (f2) VALUES ('a'), ('b');
86 SELECT COUNT(*) AS expect_0 FROM t1;
87
88 --connection node_2
89 SELECT COUNT(*) AS expect_0 FROM t1;
90
91 --connection node_1
92 SET SESSION wsrep_trx_fragment_size = 1000;
93 --error ER_DUP_ENTRY
94 INSERT INTO t1 (f2) VALUES ('a'), ('b');
95 SELECT COUNT(*) AS expect_0 FROM t1;
96
97 --connection node_2
98 SELECT COUNT(*) AS expect_0 FROM t1;
99
100 DROP TABLE t1;
101
102
103 #
104 # Case 5: FK constraint violation on multirow insert results
105 # full rollback if a fragment has already replicated
106 #
107 --connection node_1
108 CREATE TABLE p(id int primary key, j int) ENGINE=InnoDB;
109 CREATE TABLE c(id int primary key, fk1 int) ENGINE=InnoDB;
110 ALTER TABLE c ADD FOREIGN KEY (fk1) references p(id);
111 INSERT INTO p VALUES(1, 0);
112
113 SET SESSION wsrep_trx_fragment_size=1;
114 START TRANSACTION;
115 INSERT INTO c VALUES (3,1);
116 --error ER_LOCK_DEADLOCK
117 INSERT INTO c VALUES (1,1), (2,2);
118 COMMIT;
119
120 SELECT * FROM p;
121 SELECT * FROM c;
122
123 --connection node_2
124 SELECT * FROM p;
125 SELECT * FROM c;
126
127 DROP TABLE c;
128 DROP TABLE p;
129
130
131 #
132 # Case 6: FK constraint violation on multirow insert results
133 # stmt rollback if no fragments have replicated
134 #
135 --connection node_1
136 CREATE TABLE p(id int primary key, j int) ENGINE=InnoDB;
137 CREATE TABLE c(id int primary key, fk1 int) ENGINE=InnoDB;
138 ALTER TABLE c ADD FOREIGN KEY (fk1) references p(id);
139 INSERT INTO p VALUES(1, 0);
140
141 SET SESSION wsrep_trx_fragment_size=1000;
142 START TRANSACTION;
143 INSERT INTO c VALUES (3,1);
144 --error ER_NO_REFERENCED_ROW_2
145 INSERT INTO c VALUES (1,1), (2,2);
146 COMMIT;
147
148 SELECT * FROM p;
149 SELECT * FROM c;
150
151 --connection node_2
152 SELECT * FROM p;
153 SELECT * FROM c;
154
155 DROP TABLE c;
156 DROP TABLE p;