Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/t/galera_sr_kill_master.test

raw
1 #
2 # This test kills the master while a Streaming Replication transaction is in progress
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
9
10 # Save original auto_increment_offset values.
11 --let $node_1=node_1
12 --let $node_2=node_2
13 --let $node_3=node_3
14 --source ../galera/include/auto_increment_offset_save.inc
15
16 --connection node_2
17 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
18
19 SET SESSION wsrep_trx_fragment_size = 1;
20 SET AUTOCOMMIT=OFF;
21 START TRANSACTION;
22
23 INSERT INTO t1 VALUES (1);
24 INSERT INTO t1 VALUES (2);
25 INSERT INTO t1 VALUES (3);
26 INSERT INTO t1 VALUES (4);
27 INSERT INTO t1 VALUES (5);
28
29 --connection node_3
30 SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
31 --let $wait_condition = SELECT COUNT(*) > 0 FROM t1;
32 --source include/wait_condition.inc
33
34 --connection node_2
35 --source include/kill_galera.inc
36
37 --connection node_3
38 # We expect that uncommitted values are no longer present
39
40 --let $wait_condition = SELECT COUNT(*) = 0 FROM t1;
41 --source include/wait_condition.inc
42
43 --let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
44 --source include/wait_condition.inc
45
46 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
47
48 # and we can insert them again
49 INSERT INTO t1 VALUES (1);
50
51 --connection node_2
52 --source include/start_mysqld.inc
53
54 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
55 SELECT COUNT(*) = 1 FROM t1;
56
57 DROP TABLE t1;
58
59 --source ../galera/include/auto_increment_offset_restore.inc