Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/GCF-582.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 connection node_1;
5 connection node_2;
6 connection node_3;
7 connection node_1;
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9 connection node_2;
10 connection node_1;
11 connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
12 connection node_1b;
13 SET SESSION wsrep_trx_fragment_size = 1;
14 SET AUTOCOMMIT=OFF;
15 START TRANSACTION;
16 INSERT INTO t1 VALUES (1);
17 INSERT INTO t1 VALUES (2);
18 INSERT INTO t1 VALUES (3);
19 INSERT INTO t1 VALUES (4);
20 INSERT INTO t1 VALUES (5);
21 connection node_2;
22 # restart
23 SELECT COUNT(*) FROM mysql.wsrep_streaming_log;
24 COUNT(*)
25 5
26 connection node_1;
27 SELECT COUNT(*) FROM mysql.wsrep_streaming_log;
28 COUNT(*)
29 5
30 COMMIT;
31 SELECT COUNT(*) FROM t1;
32 COUNT(*)
33 0
34 connection node_2;
35 SELECT COUNT(*) FROM t1;
36 COUNT(*)
37 0
38 DROP TABLE t1;
39 disconnect node_1b;