Debian Codegraph @

mysql-test/suite/galera/r/galera_flush_local.result

raw
1 connection node_2;
2 connection node_1;
3 DROP TABLE IF EXISTS t1, t2, x1, x2;
4 connection node_1;
5 SET GLOBAL wsrep_mode = REPLICATE_MYISAM;
6 CREATE TABLE t1 (f1 INTEGER);
7 CREATE TABLE t2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER);
8 CREATE TABLE x1 (f1 INTEGER) ENGINE=MyISAM;
9 CREATE TABLE x2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=MyISAM;
10 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
11 INSERT INTO x1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
12 INSERT INTO t2 (f2) SELECT 1 FROM t1 AS a1, t1 AS a2, t1 AS a3, t1 AS a4;
13 INSERT INTO x2 (f2) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
14 connection node_2;
15 connection node_1;
16 FLUSH LOCAL DES_KEY_FILE;
17 FLUSH LOCAL HOSTS;
18 FLUSH LOCAL QUERY CACHE;
19 FLUSH LOCAL STATUS;
20 FLUSH LOCAL PRIVILEGES;
21 FLUSH LOCAL USER_RESOURCES;
22 FLUSH LOCAL TABLES;
23 FLUSH LOCAL TABLES t2;
24 FLUSH LOCAL ERROR LOGS;
25 FLUSH LOCAL SLOW LOGS;
26 FLUSH LOCAL GENERAL LOGS;
27 FLUSH LOCAL ENGINE LOGS;
28 FLUSH LOCAL RELAY LOGS;
29 FLUSH LOCAL CLIENT_STATISTICS;
30 FLUSH LOCAL INDEX_STATISTICS;
31 FLUSH LOCAL TABLE_STATISTICS;
32 FLUSH LOCAL USER_STATISTICS;
33 FLUSH LOCAL LOGS;
34 FLUSH LOCAL BINARY LOGS;
35 FLUSH LOCAL TABLES WITH READ LOCK;
36 UNLOCK TABLES;
37 FLUSH LOCAL TABLES t1 WITH READ LOCK;
38 UNLOCK TABLES;
39 FLUSH LOCAL TABLES t1 FOR EXPORT;
40 UNLOCK TABLES;
41 LOCK TABLES t1 WRITE;
42 FLUSH LOCAL TABLES t1;
43 UNLOCK TABLES;
44 LOCK TABLES t1 READ;
45 FLUSH LOCAL TABLES t1;
46 ERROR HY000: Table 't1' was locked with a READ lock and can't be updated
47 UNLOCK TABLES;
48 FLUSH LOCAL TABLES t1;
49 ANALYZE LOCAL TABLE t1, t2;
50 Table Op Msg_type Msg_text
51 test.t1 analyze status Engine-independent statistics collected
52 test.t1 analyze status OK
53 test.t2 analyze status Engine-independent statistics collected
54 test.t2 analyze status OK
55 OPTIMIZE LOCAL TABLE t1, t2;
56 Table Op Msg_type Msg_text
57 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
58 test.t1 optimize status OK
59 test.t2 optimize note Table does not support optimize, doing recreate + analyze instead
60 test.t2 optimize status OK
61 REPAIR LOCAL TABLE x1, x2;
62 Table Op Msg_type Msg_text
63 test.x1 repair status OK
64 test.x2 repair status OK
65 connection node_2;
66 wsrep_last_committed_diff
67 1
68 SELECT COUNT(*) AS EXPECT_10 FROM t1;
69 EXPECT_10
70 10
71 SELECT COUNT(*) AS EXPECT_10 FROM x1;
72 EXPECT_10
73 10
74 SELECT COUNT(*) AS EXPECT_10000 FROM t2;
75 EXPECT_10000
76 10000
77 SELECT COUNT(*) AS EXPECT_10 FROM x2;
78 EXPECT_10
79 10
80 connection node_1;
81 DROP TABLE t1, t2, x1, x2;
82 CREATE TABLE t1 (f1 INTEGER);
83 CREATE TABLE t2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER);
84 CREATE TABLE x1 (f1 INTEGER) ENGINE=MyISAM;
85 CREATE TABLE x2 (f1 INT PRIMARY KEY AUTO_INCREMENT, f2 INTEGER) ENGINE=MyISAM;
86 INSERT INTO t1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
87 INSERT INTO x1 VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
88 INSERT INTO t2 (f2) SELECT 1 FROM t1 AS a1, t1 AS a2, t1 AS a3, t1 AS a4;
89 INSERT INTO x2 (f2) VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10);
90 connection node_2;
91 connection node_1;
92 set wsrep_on=0;
93 FLUSH DES_KEY_FILE;
94 FLUSH HOSTS;
95 FLUSH QUERY CACHE;
96 FLUSH STATUS;
97 FLUSH PRIVILEGES;
98 FLUSH USER_RESOURCES;
99 FLUSH TABLES;
100 FLUSH TABLES t2;
101 FLUSH ERROR LOGS;
102 FLUSH SLOW LOGS;
103 FLUSH GENERAL LOGS;
104 FLUSH ENGINE LOGS;
105 FLUSH RELAY LOGS;
106 FLUSH CLIENT_STATISTICS;
107 FLUSH INDEX_STATISTICS;
108 FLUSH TABLE_STATISTICS;
109 FLUSH USER_STATISTICS;
110 FLUSH LOGS;
111 FLUSH BINARY LOGS;
112 FLUSH TABLES WITH READ LOCK;
113 UNLOCK TABLES;
114 FLUSH TABLES t1 WITH READ LOCK;
115 UNLOCK TABLES;
116 FLUSH TABLES t1 FOR EXPORT;
117 UNLOCK TABLES;
118 LOCK TABLES t1 WRITE;
119 FLUSH TABLES t1;
120 UNLOCK TABLES;
121 LOCK TABLES t1 READ;
122 FLUSH TABLES t1;
123 ERROR HY000: Table 't1' was locked with a READ lock and can't be updated
124 UNLOCK TABLES;
125 FLUSH TABLES t1;
126 ANALYZE TABLE t1, t2;
127 Table Op Msg_type Msg_text
128 test.t1 analyze status Engine-independent statistics collected
129 test.t1 analyze status OK
130 test.t2 analyze status Engine-independent statistics collected
131 test.t2 analyze status OK
132 OPTIMIZE TABLE t1, t2;
133 Table Op Msg_type Msg_text
134 test.t1 optimize note Table does not support optimize, doing recreate + analyze instead
135 test.t1 optimize status OK
136 test.t2 optimize note Table does not support optimize, doing recreate + analyze instead
137 test.t2 optimize status OK
138 REPAIR TABLE x1, x2;
139 Table Op Msg_type Msg_text
140 test.x1 repair status OK
141 test.x2 repair status OK
142 connection node_2;
143 wsrep_last_committed_diff
144 1
145 wsrep_last_committed_diff2
146 1
147 SELECT COUNT(*) AS EXPECT_10 FROM t1;
148 EXPECT_10
149 10
150 SELECT COUNT(*) AS EXPECT_10 FROM x1;
151 EXPECT_10
152 10
153 SELECT COUNT(*) AS EXPECT_10000 FROM t2;
154 EXPECT_10000
155 10000
156 SELECT COUNT(*) AS EXPECT_10 FROM x2;
157 EXPECT_10
158 10
159 connection node_1;
160 set wsrep_on=1;
161 DROP TABLE t1, t2, x1, x2;