Debian Codegraph @

mysql-test/suite/galera/r/galera_var_max_ws_rows.result

raw
1 connection node_2;
2 connection node_1;
3 CREATE TABLE ten (f1 INTEGER) ENGINE=InnoDB;
4 INSERT INTO ten VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);
5 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 INTEGER) ENGINE=InnoDB;
6 SET GLOBAL wsrep_max_ws_rows = 4;
7 START TRANSACTION;
8 INSERT INTO t1 (f2) VALUES (1);
9 INSERT INTO t1 (f2) VALUES (2);
10 INSERT INTO t1 (f2) VALUES (3);
11 INSERT INTO t1 (f2) VALUES (4);
12 INSERT INTO t1 (f2) VALUES (5);
13 ERROR HY000: wsrep_max_ws_rows exceeded
14 COMMIT;
15 SELECT COUNT(*) = 0 FROM t1;
16 COUNT(*) = 0
17 1
18 START TRANSACTION;
19 INSERT INTO t1 (f2) VALUES (1);
20 INSERT INTO t1 (f2) VALUES (2);
21 INSERT INTO t1 (f2) VALUES (3);
22 INSERT INTO t1 (f2) VALUES (4);
23 UPDATE t1 SET f2 = 10 WHERE f2 = 4;
24 ERROR HY000: wsrep_max_ws_rows exceeded
25 COMMIT;
26 SELECT COUNT(*) = 0 FROM t1;
27 COUNT(*) = 0
28 1
29 START TRANSACTION;
30 INSERT INTO t1 (f2) VALUES (1);
31 INSERT INTO t1 (f2) VALUES (2);
32 INSERT INTO t1 (f2) VALUES (3);
33 INSERT INTO t1 (f2) VALUES (4);
34 DELETE FROM t1 WHERE f2 = 1;
35 ERROR HY000: wsrep_max_ws_rows exceeded
36 COMMIT;
37 SELECT COUNT(*) = 0 FROM t1;
38 COUNT(*) = 0
39 1
40 SET GLOBAL wsrep_max_ws_rows = 5;
41 INSERT INTO t1 (f2) VALUES (1),(2),(3),(4),(5);
42 SET GLOBAL wsrep_max_ws_rows = 4;
43 UPDATE t1 SET f2 = f2 + 10;
44 ERROR HY000: wsrep_max_ws_rows exceeded
45 SELECT COUNT(*) = 5 FROM t1;
46 COUNT(*) = 5
47 1
48 DELETE FROM t1 WHERE f2 < 10;
49 ERROR HY000: wsrep_max_ws_rows exceeded
50 SELECT COUNT(*) = 5 FROM t1;
51 COUNT(*) = 5
52 1
53 INSERT INTO t1 (f2) SELECT * FROM ten;
54 ERROR HY000: wsrep_max_ws_rows exceeded
55 SELECT COUNT(*) = 5 FROM t1;
56 COUNT(*) = 5
57 1
58 INSERT INTO t1 (f2) VALUES (10),(20),(30),(40),(50);
59 ERROR HY000: wsrep_max_ws_rows exceeded
60 SELECT COUNT(*) = 5 FROM t1;
61 COUNT(*) = 5
62 1
63 SET GLOBAL wsrep_max_ws_rows = 10;
64 DELETE FROM t1 WHERE f2 < 10;
65 SELECT COUNT(*) = 0 FROM t1;
66 COUNT(*) = 0
67 1
68 SET GLOBAL wsrep_max_ws_rows = 100;
69 SELECT COUNT(*) = 100 FROM t1;
70 COUNT(*) = 100
71 1
72 DELETE FROM t1 WHERE f2 < 101;
73 SELECT COUNT(*) = 0 FROM t1;
74 COUNT(*) = 0
75 1
76 SET GLOBAL wsrep_max_ws_rows = 9999;
77 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
78 ERROR HY000: wsrep_max_ws_rows exceeded
79 SET GLOBAL wsrep_max_ws_rows = 10000;
80 INSERT INTO t1 (f2) SELECT 1 FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4;
81 SET GLOBAL wsrep_max_ws_rows = 9999;
82 UPDATE t1 SET f2 = 2 WHERE f2 = 1;
83 ERROR HY000: wsrep_max_ws_rows exceeded
84 SET GLOBAL wsrep_max_ws_rows = 10000;
85 UPDATE t1 SET f2 = 2 WHERE f2 = 1;
86 SET GLOBAL wsrep_max_ws_rows = 9999;
87 DELETE FROM t1 WHERE f2 = 2;
88 ERROR HY000: wsrep_max_ws_rows exceeded
89 SET GLOBAL wsrep_max_ws_rows = 10000;
90 DELETE FROM t1 WHERE f2 = 2;
91 SELECT COUNT(*) = 0 FROM t1;
92 COUNT(*) = 0
93 1
94 SET AUTOCOMMIT = ON;
95 SET GLOBAL wsrep_max_ws_rows = 1;
96 START TRANSACTION;
97 INSERT INTO t1 (f2) VALUES (1);
98 INSERT INTO t1 (f2) VALUES (2);
99 ERROR HY000: wsrep_max_ws_rows exceeded
100 INSERT INTO t1 (f2) VALUES (1);
101 INSERT INTO t1 (f2) VALUES (2);
102 SET AUTOCOMMIT = OFF;
103 START TRANSACTION;
104 INSERT INTO t1 (f2) VALUES (1);
105 INSERT INTO t1 (f2) VALUES (2);
106 ERROR HY000: wsrep_max_ws_rows exceeded
107 INSERT INTO t1 (f2) VALUES (1);
108 INSERT INTO t1 (f2) VALUES (2);
109 ERROR HY000: wsrep_max_ws_rows exceeded
110 START TRANSACTION;
111 INSERT INTO t1 (f2) VALUES (1);
112 START TRANSACTION;
113 INSERT INTO t1 (f2) VALUES (1);
114 INSERT INTO t1 (f2) VALUES (2);
115 ERROR HY000: wsrep_max_ws_rows exceeded
116 DROP TABLE t1;
117 DROP TABLE ten;
118 #
119 # MDEV-11817: Altering a table with more rows than
120 # wsrep_max_ws_rows causes cluster to break when running
121 # Galera cluster in TOI mode
122 #
123 connection node_1;
124 CREATE TABLE t1(c1 INT)ENGINE = INNODB;
125 SET GLOBAL wsrep_max_ws_rows= DEFAULT;
126 INSERT INTO t1 VALUES(1);
127 INSERT INTO t1 SELECT * FROM t1;
128 COMMIT;
129 SET GLOBAL wsrep_max_ws_rows= 1;
130 ALTER TABLE t1 CHANGE COLUMN c1 c1 BIGINT;
131 connection node_2;
132 SHOW CREATE TABLE t1;
133 Table Create Table
134 t1 CREATE TABLE `t1` (
135 `c1` bigint(20) DEFAULT NULL
136 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
137 SELECT COUNT(*) FROM t1;
138 COUNT(*)
139 2
140 DROP TABLE t1;
141 connection node_1;
142 disconnect node_2;
143 disconnect node_1;