Debian Codegraph @

mysql-test/suite/galera_sr/r/galera_sr_large_fragment.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 PRIMARY KEY AUTO_INCREMENT, f2 VARCHAR(512)) ENGINE=InnoDB;
6 SET SESSION wsrep_trx_fragment_size = 1024 * 1024 * 10;
7 SET AUTOCOMMIT=OFF;
8 START TRANSACTION;
9 INSERT INTO t1 (f2) SELECT REPEAT('x', 512) FROM ten AS a1, ten AS a2, ten AS a3, ten AS a4, ten AS a5;
10 connection node_2;
11 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
12 COUNT(*) > 0
13 1
14 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
15 SELECT COUNT(*) > 50000 FROM t1;
16 COUNT(*) > 50000
17 1
18 connection node_1;
19 ROLLBACK;
20 connection node_2;
21 SET SESSION wsrep_sync_wait = 0;
22 SET GLOBAL wsrep_provider_options = 'repl.causal_read_timeout=PT10M';
23 SET SESSION wsrep_sync_wait = 7;
24 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
25 COUNT(*) = 0
26 1
27 SELECT COUNT(*) = 0 FROM t1;
28 COUNT(*) = 0
29 1
30 COUNT(*) = 0
31 1
32 COUNT(*) = 0
33 1