Debian Codegraph @

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

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