Debian Codegraph @

mysql-test/suite/galera/t/galera_var_max_ws_rows.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
5 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
6
7 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
8
9 --let $wsrep_max_ws_rows_orig = `SELECT @@wsrep_max_ws_rows`
10 SET GLOBAL wsrep_max_ws_rows = 4;
11
12 # Test that wsrep_max_ws_rows is enforced with multi statement transactions
13
14 START TRANSACTION;
15 INSERT INTO t1 (f2) VALUES (1);
16 INSERT INTO t1 (f2) VALUES (2);
17 INSERT INTO t1 (f2) VALUES (3);
18 INSERT INTO t1 (f2) VALUES (4);
19 --error ER_ERROR_DURING_COMMIT
20 INSERT INTO t1 (f2) VALUES (5);
21 COMMIT;
22 SELECT COUNT(*) = 0 FROM t1;
23
24 START TRANSACTION;
25 INSERT INTO t1 (f2) VALUES (1);
26 INSERT INTO t1 (f2) VALUES (2);
27 INSERT INTO t1 (f2) VALUES (3);
28 INSERT INTO t1 (f2) VALUES (4);
29 --error ER_ERROR_DURING_COMMIT
30 UPDATE t1 SET f2 = 10 WHERE f2 = 4;
31 COMMIT;
32 SELECT COUNT(*) = 0 FROM t1;
33
34 START TRANSACTION;
35 INSERT INTO t1 (f2) VALUES (1);
36 INSERT INTO t1 (f2) VALUES (2);
37 INSERT INTO t1 (f2) VALUES (3);
38 INSERT INTO t1 (f2) VALUES (4);
39 --error ER_ERROR_DURING_COMMIT
40 DELETE FROM t1 WHERE f2 = 1;
41 COMMIT;
42 SELECT COUNT(*) = 0 FROM t1;
43
44
45 # Test that wsrep_max_ws_rows is enforced on sigle statements
46
47 SET GLOBAL wsrep_max_ws_rows = 5;
48 INSERT INTO t1 (f2) VALUES (1),(2),(3),(4),(5);
49 SET GLOBAL wsrep_max_ws_rows = 4;
50
51 --error ER_ERROR_DURING_COMMIT
52 UPDATE t1 SET f2 = f2 + 10;
53 SELECT COUNT(*) = 5 FROM t1;
54
55 --error ER_ERROR_DURING_COMMIT
56 DELETE FROM t1 WHERE f2 < 10;
57 SELECT COUNT(*) = 5 FROM t1;
58
59 --error ER_ERROR_DURING_COMMIT
60 INSERT INTO t1 (f2) SELECT * FROM ten;
61 SELECT COUNT(*) = 5 FROM t1;
62
63 --error ER_ERROR_DURING_COMMIT
64 INSERT INTO t1 (f2) VALUES (10),(20),(30),(40),(50);
65 SELECT COUNT(*) = 5 FROM t1;
66
67 # Fewer than wsrep_max_ws_rows is OK
68
69 SET GLOBAL wsrep_max_ws_rows = 10;
70 DELETE FROM t1 WHERE f2 < 10;
71 SELECT COUNT(*) = 0 FROM t1;
72
73 # Test a series of transactions
74
75 --disable_query_log
76 SET GLOBAL wsrep_max_ws_rows = 5;
77 let $i= 100;
78 while ($i)
79 {
80 START TRANSACTION;
81 --eval INSERT INTO t1 (f2) VALUES ($i);
82 COMMIT;
83 dec $i;
84 }
85 --enable_query_log
86 SET GLOBAL wsrep_max_ws_rows = 100;
87 SELECT COUNT(*) = 100 FROM t1;
88 DELETE FROM t1 WHERE f2 < 101;
89 SELECT COUNT(*) = 0 FROM t1;
90
91 # Test large statements
92
93 SET GLOBAL wsrep_max_ws_rows = 9999;
94 --error ER_ERROR_DURING_COMMIT
95 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
96 SET GLOBAL wsrep_max_ws_rows = 10000;
97 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
98
99 SET GLOBAL wsrep_max_ws_rows = 9999;
100 --error ER_ERROR_DURING_COMMIT
101 UPDATE t1 SET f2 = 2 WHERE f2 = 1;
102 SET GLOBAL wsrep_max_ws_rows = 10000;
103 UPDATE t1 SET f2 = 2 WHERE f2 = 1;
104
105 SET GLOBAL wsrep_max_ws_rows = 9999;
106 --error ER_ERROR_DURING_COMMIT
107 DELETE FROM t1 WHERE f2 = 2;
108 SET GLOBAL wsrep_max_ws_rows = 10000;
109 DELETE FROM t1 WHERE f2 = 2;
110
111 SELECT COUNT(*) = 0 FROM t1;
112
113
114 # Test that wsrep_max_ws_rows is reset when switching autocommit mode
115
116 SET AUTOCOMMIT = ON;
117 SET GLOBAL wsrep_max_ws_rows = 1;
118
119 START TRANSACTION;
120 INSERT INTO t1 (f2) VALUES (1);
121 --error ER_ERROR_DURING_COMMIT
122 INSERT INTO t1 (f2) VALUES (2);
123
124 INSERT INTO t1 (f2) VALUES (1);
125 INSERT INTO t1 (f2) VALUES (2);
126
127
128 SET AUTOCOMMIT = OFF;
129 START TRANSACTION;
130 INSERT INTO t1 (f2) VALUES (1);
131 --error ER_ERROR_DURING_COMMIT
132 INSERT INTO t1 (f2) VALUES (2);
133
134 INSERT INTO t1 (f2) VALUES (1);
135 --error ER_ERROR_DURING_COMMIT
136 INSERT INTO t1 (f2) VALUES (2);
137
138
139 # Test that wsrep_max_ws_rows is reset on implicit commits
140
141 START TRANSACTION;
142 INSERT INTO t1 (f2) VALUES (1);
143
144 START TRANSACTION;
145 INSERT INTO t1 (f2) VALUES (1);
146 --error ER_ERROR_DURING_COMMIT
147 INSERT INTO t1 (f2) VALUES (2);
148
149 DROP TABLE t1;
150 DROP TABLE ten;
151
152 --echo #
153 --echo # MDEV-11817: Altering a table with more rows than
154 --echo # wsrep_max_ws_rows causes cluster to break when running
155 --echo # Galera cluster in TOI mode
156 --echo #
157 --connection node_1
158 CREATE TABLE t1(c1 INT)ENGINE = INNODB;
159 SET GLOBAL wsrep_max_ws_rows= DEFAULT;
160 INSERT INTO t1 VALUES(1);
161 INSERT INTO t1 SELECT * FROM t1;
162 COMMIT;
163 SET GLOBAL wsrep_max_ws_rows= 1;
164 ALTER TABLE t1 CHANGE COLUMN c1 c1 BIGINT;
165
166 --connection node_2
167 SHOW CREATE TABLE t1;
168 SELECT COUNT(*) FROM t1;
169 DROP TABLE t1;
170
171 --connection node_1
172
173 --disable_query_log
174 --eval SET GLOBAL wsrep_max_ws_rows = $wsrep_max_ws_rows_orig
175 --enable_query_log
176
177 --source include/galera_end.inc