Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_ws_size2.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 = 256;
8 SET GLOBAL wsrep_provider_options='repl.max_ws_size=128';
9 SET AUTOCOMMIT=OFF;
10 START TRANSACTION;
11 INSERT INTO t1 (f2) SELECT REPEAT('x', 254) FROM ten AS a1, ten AS a2;
12 Got one of the listed errors
13 connection node_2;
14 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15 SELECT COUNT(*) = 0 FROM t1;
16 COUNT(*) = 0
17 1
18 connection node_2;
19 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
20 SELECT COUNT(*) = 0 FROM t1;
21 COUNT(*) = 0
22 1
23 connection node_1;
24 DROP TABLE t1;
25 DROP TABLE ten;
26 call mtr.add_suppression('WSREP: SR rollback replication failure');
27 call mtr.add_suppression('WSREP: transaction size limit');
28 call mtr.add_suppression('WSREP: SR rbr write fail');
29 call mtr.add_suppression('WSREP: Maximum writeset size exceeded by ');
30 call mtr.add_suppression('WSREP: transaction size exceeded');
31 call mtr.add_suppression('WSREP: fragment replication failed: ');
32 call mtr.add_suppression('WSREP: post commit failed for SR rollback');
33 call mtr.add_suppression('WSREP: pre_commit for SR rollback returned 2, thd: ');
34 call mtr.add_suppression('WSREP: wsrep_rollback failed to send SR ROLLBACK for ');