Debian Codegraph @

mysql-test/suite/galera/include/galera_st_kill_slave.inc

raw
1 --echo Performing State Transfer on a server that has been killed and restarted
2
3 --connection node_1
4 CREATE TABLE t1 (id int not null primary key,f1 CHAR(255)) ENGINE=InnoDB;
5 SET AUTOCOMMIT=OFF;
6 START TRANSACTION;
7 INSERT INTO t1 VALUES (1,'node1_committed_before');
8 INSERT INTO t1 VALUES (2,'node1_committed_before');
9 INSERT INTO t1 VALUES (3,'node1_committed_before');
10 INSERT INTO t1 VALUES (4,'node1_committed_before');
11 INSERT INTO t1 VALUES (5,'node1_committed_before');
12 COMMIT;
13
14 --connection node_2
15 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE 'test/t1';
16 --source include/wait_condition.inc
17 SET AUTOCOMMIT=OFF;
18 START TRANSACTION;
19 INSERT INTO t1 VALUES (6,'node2_committed_before');
20 INSERT INTO t1 VALUES (7,'node2_committed_before');
21 INSERT INTO t1 VALUES (8,'node2_committed_before');
22 INSERT INTO t1 VALUES (9,'node2_committed_before');
23 INSERT INTO t1 VALUES (10,'node2_committed_before');
24 COMMIT;
25
26 --source include/kill_galera.inc
27
28 --connection node_1
29 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
30 --source include/wait_condition.inc
31
32 SET AUTOCOMMIT=OFF;
33 START TRANSACTION;
34 INSERT INTO t1 VALUES (11,'node1_committed_during');
35 INSERT INTO t1 VALUES (12,'node1_committed_during');
36 INSERT INTO t1 VALUES (13,'node1_committed_during');
37 INSERT INTO t1 VALUES (14,'node1_committed_during');
38 INSERT INTO t1 VALUES (15,'node1_committed_during');
39 COMMIT;
40
41 START TRANSACTION;
42 INSERT INTO t1 VALUES (16,'node1_to_be_committed_after');
43 INSERT INTO t1 VALUES (17,'node1_to_be_committed_after');
44 INSERT INTO t1 VALUES (18,'node1_to_be_committed_after');
45 INSERT INTO t1 VALUES (19,'node1_to_be_committed_after');
46 INSERT INTO t1 VALUES (20,'node1_to_be_committed_after');
47
48 --connect node_1a_galera_st_kill_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1
49 SET AUTOCOMMIT=OFF;
50 START TRANSACTION;
51 INSERT INTO t1 VALUES (21,'node1_to_be_rollbacked_after');
52 INSERT INTO t1 VALUES (22,'node1_to_be_rollbacked_after');
53 INSERT INTO t1 VALUES (23,'node1_to_be_rollbacked_after');
54 INSERT INTO t1 VALUES (24,'node1_to_be_rollbacked_after');
55 INSERT INTO t1 VALUES (25,'node1_to_be_rollbacked_after');
56
57 --connection node_2
58 --let $galera_wsrep_recover_server_id=2
59 --source suite/galera/include/galera_wsrep_recover.inc
60
61 --echo Starting server ...
62 --source include/start_mysqld.inc
63
64 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
65 --source include/wait_condition.inc
66
67 SET AUTOCOMMIT=OFF;
68 START TRANSACTION;
69 INSERT INTO t1 VALUES (26,'node2_committed_after');
70 INSERT INTO t1 VALUES (27,'node2_committed_after');
71 INSERT INTO t1 VALUES (28,'node2_committed_after');
72 INSERT INTO t1 VALUES (29,'node2_committed_after');
73 INSERT INTO t1 VALUES (30,'node2_committed_after');
74 COMMIT;
75
76 --connection node_1
77 INSERT INTO t1 VALUES (31,'node1_to_be_committed_after');
78 INSERT INTO t1 VALUES (32,'node1_to_be_committed_after');
79 INSERT INTO t1 VALUES (33,'node1_to_be_committed_after');
80 INSERT INTO t1 VALUES (34,'node1_to_be_committed_after');
81 INSERT INTO t1 VALUES (35,'node1_to_be_committed_after');
82 COMMIT;
83
84 SET AUTOCOMMIT=OFF;
85 START TRANSACTION;
86 INSERT INTO t1 VALUES (36,'node1_committed_after');
87 INSERT INTO t1 VALUES (37,'node1_committed_after');
88 INSERT INTO t1 VALUES (38,'node1_committed_after');
89 INSERT INTO t1 VALUES (39,'node1_committed_after');
90 INSERT INTO t1 VALUES (40,'node1_committed_after');
91 COMMIT;
92
93 --connection node_1a_galera_st_kill_slave
94 INSERT INTO t1 VALUES (41,'node1_to_be_rollbacked_after');
95 INSERT INTO t1 VALUES (42,'node1_to_be_rollbacked_after');
96 INSERT INTO t1 VALUES (43,'node1_to_be_rollbacked_after');
97 INSERT INTO t1 VALUES (45,'node1_to_be_rollbacked_after');
98 INSERT INTO t1 VALUES (46,'node1_to_be_rollbacked_after');
99 ROLLBACK;
100
101 --let $wait_condition = SELECT COUNT(*)=35 FROM t1
102 --source include/wait_condition.inc
103
104 SET AUTOCOMMIT=ON;
105 SET SESSION wsrep_sync_wait=15;
106 SELECT COUNT(*) AS EXPECT_35 FROM t1;
107 SELECT * FROM t1;
108 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
109 COMMIT;
110
111 --connection node_1
112 --let $wait_condition = SELECT COUNT(*)=35 FROM t1
113 --source include/wait_condition.inc
114
115 SET AUTOCOMMIT=ON;
116 SET SESSION wsrep_sync_wait=15;
117 SELECT COUNT(*) AS EXPECT_35 FROM t1;
118 SELECT * FROM t1;
119 SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
120 DROP TABLE t1;
121 COMMIT;