Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/galera_sr_kill_master.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_2;
8 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
9 SET SESSION wsrep_trx_fragment_size = 1;
10 SET AUTOCOMMIT=OFF;
11 START TRANSACTION;
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_3;
18 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
19 connection node_2;
20 Killing server ...
21 connection node_3;
22 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
23 COUNT(*) = 0
24 1
25 INSERT INTO t1 VALUES (1);
26 connection node_2;
27 # restart
28 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
29 COUNT(*) = 0
30 1
31 SELECT COUNT(*) = 1 FROM t1;
32 COUNT(*) = 1
33 1
34 DROP TABLE t1;