Debian Codegraph @

mysql-test/suite/galera/t/galera_flush_local.test

raw
1 #
2 # Test that various FLUSH LOCAL commands are replicated. Whenever possible, check the slave for the effects.
3 # PXC-391
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7 --source include/have_query_cache.inc
8
9 --disable_warnings
10 DROP TABLE IF EXISTS t1, t2, x1, x2;
11 --enable_warnings
12 #
13 # The following FLUSH LOCAL statements should *not* be replicated
14 #
15 --connection node_1
16 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
17 CREATE TABLE t1 (f1 INTEGER);
18 CREATE TABLE t2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER);
19 CREATE TABLE x1 (f1 INTEGER) ENGINE=MyISAM;
20 CREATE TABLE x2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=MyISAM;
21 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
22 INSERT INTO x1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
23 INSERT INTO t2 (f2) SELECT 1 FROM t1 AS a1, t1 AS a2, t1 AS a3, t1 AS a4;
24 INSERT INTO x2 (f2) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
25
26 --connection node_2
27 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
28 --connection node_1
29 FLUSH LOCAL DES_KEY_FILE;
30 FLUSH LOCAL HOSTS;
31 FLUSH LOCAL QUERY CACHE;
32 FLUSH LOCAL STATUS;
33 FLUSH LOCAL PRIVILEGES;
34 FLUSH LOCAL USER_RESOURCES;
35 FLUSH LOCAL TABLES;
36 FLUSH LOCAL TABLES t2;
37 FLUSH LOCAL ERROR LOGS;
38 FLUSH LOCAL SLOW LOGS;
39 FLUSH LOCAL GENERAL LOGS;
40 FLUSH LOCAL ENGINE LOGS;
41 FLUSH LOCAL RELAY LOGS;
42 FLUSH LOCAL CLIENT_STATISTICS;
43 FLUSH LOCAL INDEX_STATISTICS;
44 FLUSH LOCAL TABLE_STATISTICS;
45 FLUSH LOCAL USER_STATISTICS;
46 FLUSH LOCAL LOGS;
47 FLUSH LOCAL BINARY LOGS;
48 FLUSH LOCAL TABLES WITH READ LOCK;
49 UNLOCK TABLES;
50 FLUSH LOCAL TABLES t1 WITH READ LOCK;
51 UNLOCK TABLES;
52 FLUSH LOCAL TABLES t1 FOR EXPORT;
53 UNLOCK TABLES;
54 LOCK TABLES t1 WRITE;
55 FLUSH LOCAL TABLES t1;
56 UNLOCK TABLES;
57 LOCK TABLES t1 READ;
58 --error ER_TABLE_NOT_LOCKED_FOR_WRITE
59 FLUSH LOCAL TABLES t1;
60 UNLOCK TABLES;
61 FLUSH LOCAL TABLES t1;
62 ANALYZE LOCAL TABLE t1, t2;
63 OPTIMIZE LOCAL TABLE t1, t2;
64 REPAIR LOCAL TABLE x1, x2;
65 --connection node_2
66 --let $wsrep_last_committed_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
67 --disable_query_log
68 --eval SELECT $wsrep_last_committed_after = $wsrep_last_committed_before AS wsrep_last_committed_diff;
69 --enable_query_log
70
71 SELECT COUNT(*) AS EXPECT_10 FROM t1;
72 SELECT COUNT(*) AS EXPECT_10 FROM x1;
73 SELECT COUNT(*) AS EXPECT_10000 FROM t2;
74 SELECT COUNT(*) AS EXPECT_10 FROM x2;
75
76 --connection node_1
77 DROP TABLE t1, t2, x1, x2;
78 CREATE TABLE t1 (f1 INTEGER);
79 CREATE TABLE t2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER);
80 CREATE TABLE x1 (f1 INTEGER) ENGINE=MyISAM;
81 CREATE TABLE x2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=MyISAM;
82 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
83 INSERT INTO x1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
84 INSERT INTO t2 (f2) SELECT 1 FROM t1 AS a1, t1 AS a2, t1 AS a3, t1 AS a4;
85 INSERT INTO x2 (f2) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
86
87
88 --connection node_2
89 --let $wsrep_last_committed_before2 = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
90 --connection node_1
91 set wsrep_on=0;
92 FLUSH DES_KEY_FILE;
93 FLUSH HOSTS;
94 FLUSH QUERY CACHE;
95 FLUSH STATUS;
96 FLUSH PRIVILEGES;
97 FLUSH USER_RESOURCES;
98 FLUSH TABLES;
99 FLUSH TABLES t2;
100 FLUSH ERROR LOGS;
101 FLUSH SLOW LOGS;
102 FLUSH GENERAL LOGS;
103 FLUSH ENGINE LOGS;
104 FLUSH RELAY LOGS;
105 FLUSH CLIENT_STATISTICS;
106 FLUSH INDEX_STATISTICS;
107 FLUSH TABLE_STATISTICS;
108 FLUSH USER_STATISTICS;
109 FLUSH LOGS;
110 FLUSH BINARY LOGS;
111 FLUSH TABLES WITH READ LOCK;
112 UNLOCK TABLES;
113 FLUSH TABLES t1 WITH READ LOCK;
114 UNLOCK TABLES;
115 FLUSH TABLES t1 FOR EXPORT;
116 UNLOCK TABLES;
117 LOCK TABLES t1 WRITE;
118 FLUSH TABLES t1;
119 UNLOCK TABLES;
120 LOCK TABLES t1 READ;
121 --error ER_TABLE_NOT_LOCKED_FOR_WRITE
122 FLUSH TABLES t1;
123 UNLOCK TABLES;
124 FLUSH TABLES t1;
125 ANALYZE TABLE t1, t2;
126 OPTIMIZE TABLE t1, t2;
127 REPAIR TABLE x1, x2;
128 --connection node_2
129 --let $wsrep_last_committed_after2 = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
130 --disable_query_log
131 --eval SELECT $wsrep_last_committed_after2 = $wsrep_last_committed_before2 AS wsrep_last_committed_diff;
132 --eval SELECT $wsrep_last_committed_after2 = $wsrep_last_committed_before + 9 AS wsrep_last_committed_diff2;
133 --enable_query_log
134
135 SELECT COUNT(*) AS EXPECT_10 FROM t1;
136 SELECT COUNT(*) AS EXPECT_10 FROM x1;
137 SELECT COUNT(*) AS EXPECT_10000 FROM t2;
138 SELECT COUNT(*) AS EXPECT_10 FROM x2;
139
140 --connection node_1
141 set wsrep_on=1;
142 DROP TABLE t1, t2, x1, x2;
143
144 --disable_query_log
145 SET GLOBAL wsrep_mode = DEFAULT;
146 --enable_query_log