Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/galera_sr_kill_slave_after_apply.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 SET SESSION wsrep_trx_fragment_size = 1;
9 SET AUTOCOMMIT=OFF;
10 START TRANSACTION;
11 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
12 INSERT INTO t1 VALUES (1);
13 INSERT INTO t1 VALUES (2);
14 INSERT INTO t1 VALUES (3);
15 INSERT INTO t1 VALUES (4);
16 INSERT INTO t1 VALUES (5);
17 connection node_2;
18 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
19 Killing server ...
20 connection node_1;
21 INSERT INTO t1 VALUES (6);
22 INSERT INTO t1 VALUES (7);
23 INSERT INTO t1 VALUES (8);
24 INSERT INTO t1 VALUES (9);
25 INSERT INTO t1 VALUES (10);
26 connection node_2;
27 # restart
28 connection node_1;
29 INSERT INTO t1 VALUES (11);
30 INSERT INTO t1 VALUES (12);
31 INSERT INTO t1 VALUES (13);
32 INSERT INTO t1 VALUES (14);
33 INSERT INTO t1 VALUES (15);
34 connection node_2;
35 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
36 SELECT COUNT(*) = 15 FROM mysql.wsrep_streaming_log;
37 COUNT(*) = 15
38 1
39 connection node_1;
40 COMMIT;
41 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
42 COUNT(*) = 0
43 1
44 connection node_2;
45 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
46 SELECT COUNT(*) = 15 FROM t1;
47 COUNT(*) = 15
48 1
49 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
50 COUNT(*) = 0
51 1
52 DROP TABLE t1;
53 connection node_3;
54 CALL mtr.add_suppression("WSREP: Action message in non-primary configuration from member");