Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_ws_size.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 VARCHAR(254)) ENGINE=InnoDB;
5 CREATE TABLE ten (f1 INTEGER);
6 INSERT INTO ten VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
7 SET SESSION wsrep_trx_fragment_size = 512;
8 SET GLOBAL wsrep_provider_options='repl.max_ws_size=4096';
9 SET AUTOCOMMIT=OFF;
10 START TRANSACTION;
11 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
12 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
13 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
14 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
15 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
16 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
17 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
18 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
19 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
20 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1;
21 connection node_2;
22 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
23 connection node_1;
24 COMMIT;
25 connection node_2;
26 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
27 SELECT COUNT(*) = 100 FROM t1;
28 COUNT(*) = 100
29 1
30 DROP TABLE t1;
31 DROP TABLE ten;
32 connection node_1;
33 call mtr.add_suppression('WSREP: transaction size limit');
34 call mtr.add_suppression('WSREP: rbr write fail');
35 call mtr.add_suppression('WSREP: Maximum writeset size exceeded by ');
36 call mtr.add_suppression('WSREP: transaction size exceeded');