Debian Codegraph @

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

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 connection node_2;
5 connection node_2;
6 call mtr.add_suppression("WSREP: Failed to scan the last segment to the end\\. Last events may be missing\\. Last recovered event: ");
7 connection node_1;
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE = InnoDB;
9 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
10 connection node_1a;
11 SET AUTOCOMMIT=OFF;
12 SET SESSION wsrep_trx_fragment_size=1;
13 START TRANSACTION;
14 INSERT INTO t1 VALUES (11),(12),(13);
15 connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
16 connection node_1b;
17 SET AUTOCOMMIT=OFF;
18 SET SESSION wsrep_trx_fragment_size=1;
19 START TRANSACTION;
20 INSERT INTO t1 VALUES (21),(22),(23);
21 connection node_2;
22 connection node_1;
23 connection node_1a;
24 INSERT INTO t1 VALUES (14),(15),(16);
25 COMMIT;
26 connection node_2;
27 # restart
28 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
29 COUNT(*) > 0
30 1
31 SELECT COUNT(*) AS EXPECT_6 FROM t1 WHERE f1 IN (11,12,13,14,15,16);
32 EXPECT_6
33 6
34 connection node_1b;
35 INSERT INTO t1 VALUES (24),(25),(26);
36 COMMIT;
37 connection node_2;
38 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
39 EXPECT_0
40 0
41 SELECT COUNT(*) AS EXPECT_12 FROM t1;
42 EXPECT_12
43 12
44 connection node_1;
45 SELECT COUNT(*) AS EXPECT_0 FROM mysql.wsrep_streaming_log;
46 EXPECT_0
47 0
48 DROP TABLE t1;