Debian Codegraph @

mysql-test/suite/perfschema/t/processlist_57.test

raw
1
2 --source include/no_protocol.inc
3 --source include/not_embedded.inc
4
5 call mtr.add_suppression("Optional native table 'performance_schema'.'processlist' has the wrong structure or is missing.");
6 call mtr.add_suppression("Column count of performance_schema.processlist is wrong. Expected 8, found 2. The table is probably corrupted");
7
8 --echo ##
9 --echo ## Verify fresh 5.7 instance
10 --echo ##
11
12 SELECT @@global.performance_schema_show_processlist;
13
14 SHOW CREATE TABLE performance_schema.processlist;
15
16 --echo ##
17 --echo ## Simulate old 5.7 instance
18 --echo ##
19
20 DROP TABLE performance_schema.processlist;
21
22 --error ER_NO_SUCH_TABLE
23 SHOW CREATE TABLE performance_schema.processlist;
24
25 let $restart_file= $MYSQLTEST_VARDIR/tmp/mysqld.1.expect;
26 --write_line wait $restart_file
27 --echo ##
28 --echo ## Server shutdown
29 --echo ##
30 --shutdown_server
31 --source include/wait_until_disconnected.inc
32 --echo ##
33 --echo ### Server restart
34 --echo ##
35 --exec echo "restart:">$restart_file
36 --enable_reconnect
37 --source include/wait_until_connected_again.inc
38
39 --echo ##
40 --echo ## Verify old 5.7 instance
41 --echo ##
42
43 SELECT @@global.performance_schema_show_processlist;
44
45 --error ER_NO_SUCH_TABLE
46 SHOW CREATE TABLE performance_schema.processlist;
47
48 --error ER_NO_SUCH_TABLE
49 SELECT * FROM performance_schema.processlist;
50
51 --replace_column 3 [HOST:PORT] 6 [TIME]
52 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
53
54 --replace_column 3 [HOST:PORT] 6 [TIME]
55 SHOW PROCESSLIST;
56
57 SET GLOBAL performance_schema_show_processlist = 'ON';
58
59 --error ER_NO_SUCH_TABLE
60 SELECT * FROM performance_schema.processlist;
61
62 --replace_column 3 [HOST:PORT] 6 [TIME]
63 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
64
65 --error ER_NO_SUCH_TABLE
66 SHOW PROCESSLIST;
67
68 --echo ##
69 --echo ## Perform broken upgrade (case 1)
70 --echo ##
71
72 CREATE TABLE performance_schema.processlist (a int, b int);
73
74 SHOW CREATE TABLE performance_schema.processlist;
75
76 SET GLOBAL performance_schema_show_processlist = 'OFF';
77
78 SELECT * FROM performance_schema.processlist;
79
80 --replace_column 3 [HOST:PORT] 6 [TIME]
81 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
82
83 --replace_column 3 [HOST:PORT] 6 [TIME]
84 SHOW PROCESSLIST;
85
86 SET GLOBAL performance_schema_show_processlist = 'ON';
87
88 SELECT * FROM performance_schema.processlist;
89
90 --replace_column 3 [HOST:PORT] 6 [TIME]
91 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
92
93 --error ER_BAD_FIELD_ERROR
94 SHOW PROCESSLIST;
95
96 --write_line wait $restart_file
97 --echo ##
98 --echo ## Server shutdown
99 --echo ##
100 --shutdown_server
101 --source include/wait_until_disconnected.inc
102 --echo ##
103 --echo ### Server restart
104 --echo ##
105 --exec echo "restart:">$restart_file
106 --enable_reconnect
107 --source include/wait_until_connected_again.inc
108
109 SHOW CREATE TABLE performance_schema.processlist;
110
111 SET GLOBAL performance_schema_show_processlist = 'OFF';
112
113 SELECT * FROM performance_schema.processlist;
114
115 --replace_column 3 [HOST:PORT] 6 [TIME]
116 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
117
118 --replace_column 3 [HOST:PORT] 6 [TIME]
119 SHOW PROCESSLIST;
120
121 SET GLOBAL performance_schema_show_processlist = 'ON';
122
123 SELECT * FROM performance_schema.processlist;
124
125 --replace_column 3 [HOST:PORT] 6 [TIME]
126 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
127
128 --error ER_BAD_FIELD_ERROR
129 SHOW PROCESSLIST;
130
131 --echo ##
132 --echo ## Perform broken upgrade (case 2)
133 --echo ##
134
135 DROP TABLE performance_schema.processlist;
136 CREATE TABLE performance_schema.processlist (
137 `ID` bigint(20) unsigned NOT NULL,
138 `USER` varchar(32) DEFAULT NULL,
139 `HOST` varchar(66) DEFAULT NULL,
140 `DB` varchar(64) DEFAULT NULL,
141 `COMMAND` varchar(16) DEFAULT NULL,
142 `TIME` bigint(20) DEFAULT NULL,
143 `STATE` varchar(64) DEFAULT NULL,
144 `INFO` longtext
145 );
146
147 SHOW CREATE TABLE performance_schema.processlist;
148
149 SET GLOBAL performance_schema_show_processlist = 'OFF';
150
151 SELECT * FROM performance_schema.processlist;
152
153 --replace_column 3 [HOST:PORT] 6 [TIME]
154 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
155
156 --replace_column 3 [HOST:PORT] 6 [TIME]
157 SHOW PROCESSLIST;
158
159 SET GLOBAL performance_schema_show_processlist = 'ON';
160
161 SELECT * FROM performance_schema.processlist;
162
163 --replace_column 3 [HOST:PORT] 6 [TIME]
164 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
165
166 # Works and returns no data, innodb table is empty.
167 SHOW PROCESSLIST;
168
169 --write_line wait $restart_file
170 --echo ##
171 --echo ## Server shutdown
172 --echo ##
173 --shutdown_server
174 --source include/wait_until_disconnected.inc
175 --echo ##
176 --echo ### Server restart
177 --echo ##
178 --exec echo "restart:">$restart_file
179 --enable_reconnect
180 --source include/wait_until_connected_again.inc
181
182 SHOW CREATE TABLE performance_schema.processlist;
183
184 SET GLOBAL performance_schema_show_processlist = 'OFF';
185
186 SELECT * FROM performance_schema.processlist;
187
188 --replace_column 3 [HOST:PORT] 6 [TIME]
189 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
190
191 --replace_column 3 [HOST:PORT] 6 [TIME]
192 SHOW PROCESSLIST;
193
194 SET GLOBAL performance_schema_show_processlist = 'ON';
195
196 SELECT * FROM performance_schema.processlist;
197
198 --replace_column 3 [HOST:PORT] 6 [TIME]
199 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
200
201 # Works and returns no data, innodb table is empty.
202 SHOW PROCESSLIST;
203
204 --echo ##
205 --echo ## Perform broken upgrade (case 3)
206 --echo ##
207
208 DROP TABLE performance_schema.processlist;
209 CREATE TABLE performance_schema.processlist
210 LIKE INFORMATION_SCHEMA.PROCESSLIST;
211
212 SHOW CREATE TABLE performance_schema.processlist;
213
214 SET GLOBAL performance_schema_show_processlist = 'OFF';
215
216 SELECT * FROM performance_schema.processlist;
217
218 --replace_column 3 [HOST:PORT] 6 [TIME]
219 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
220
221 --replace_column 3 [HOST:PORT] 6 [TIME]
222 SHOW PROCESSLIST;
223
224 SET GLOBAL performance_schema_show_processlist = 'ON';
225
226 SELECT * FROM performance_schema.processlist;
227
228 --replace_column 3 [HOST:PORT] 6 [TIME]
229 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
230
231 # Works and returns no data, innodb table is empty.
232 SHOW PROCESSLIST;
233
234 --write_line wait $restart_file
235 --echo ##
236 --echo ## Server shutdown
237 --echo ##
238 --shutdown_server
239 --source include/wait_until_disconnected.inc
240 --echo ##
241 --echo ### Server restart
242 --echo ##
243 --exec echo "restart:">$restart_file
244 --enable_reconnect
245 --source include/wait_until_connected_again.inc
246
247 SHOW CREATE TABLE performance_schema.processlist;
248
249 SET GLOBAL performance_schema_show_processlist = 'OFF';
250
251 SELECT * FROM performance_schema.processlist;
252
253 --replace_column 3 [HOST:PORT] 6 [TIME]
254 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
255
256 --replace_column 3 [HOST:PORT] 6 [TIME]
257 SHOW PROCESSLIST;
258
259 SET GLOBAL performance_schema_show_processlist = 'ON';
260
261 SELECT * FROM performance_schema.processlist;
262
263 --replace_column 3 [HOST:PORT] 6 [TIME]
264 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
265
266 # Works and returns no data, innodb table is empty.
267 SHOW PROCESSLIST;
268
269 --echo ##
270 --echo ## Perform correct upgrade
271 --echo ##
272
273 DROP TABLE performance_schema.processlist;
274 CREATE TABLE performance_schema.processlist (
275 `ID` bigint(20) unsigned NOT NULL,
276 `USER` varchar(32) DEFAULT NULL,
277 `HOST` varchar(66) DEFAULT NULL,
278 `DB` varchar(64) DEFAULT NULL,
279 `COMMAND` varchar(16) DEFAULT NULL,
280 `TIME` bigint(20) DEFAULT NULL,
281 `STATE` varchar(64) DEFAULT NULL,
282 `INFO` longtext
283 ) ENGINE = 'PERFORMANCE_SCHEMA';
284
285 SHOW CREATE TABLE performance_schema.processlist;
286
287 SET GLOBAL performance_schema_show_processlist = 'OFF';
288
289 --replace_column 3 [HOST:PORT] 6 [TIME]
290 SELECT * FROM performance_schema.processlist;
291
292 --replace_column 3 [HOST:PORT] 6 [TIME]
293 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
294
295 --replace_column 3 [HOST:PORT] 6 [TIME]
296 SHOW PROCESSLIST;
297
298 SET GLOBAL performance_schema_show_processlist = 'ON';
299
300 --replace_column 3 [HOST:PORT] 6 [TIME]
301 SELECT * FROM performance_schema.processlist;
302
303 --replace_column 3 [HOST:PORT] 6 [TIME]
304 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
305
306 --replace_column 3 [HOST:PORT] 6 [TIME]
307 SHOW PROCESSLIST;
308
309 --write_line wait $restart_file
310 --echo ##
311 --echo ## Server shutdown
312 --echo ##
313 --shutdown_server
314 --source include/wait_until_disconnected.inc
315 --echo ##
316 --echo ### Server restart
317 --echo ##
318 --exec echo "restart:">$restart_file
319 --enable_reconnect
320 --source include/wait_until_connected_again.inc
321
322 SHOW CREATE TABLE performance_schema.processlist;
323
324 SET GLOBAL performance_schema_show_processlist = 'OFF';
325
326 --replace_column 3 [HOST:PORT] 6 [TIME]
327 SELECT * FROM performance_schema.processlist;
328
329 --replace_column 3 [HOST:PORT] 6 [TIME]
330 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
331
332 --replace_column 3 [HOST:PORT] 6 [TIME]
333 SHOW PROCESSLIST;
334
335 SET GLOBAL performance_schema_show_processlist = 'ON';
336
337 --replace_column 3 [HOST:PORT] 6 [TIME]
338 SELECT * FROM performance_schema.processlist;
339
340 --replace_column 3 [HOST:PORT] 6 [TIME]
341 SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST;
342
343 --replace_column 3 [HOST:PORT] 6 [TIME]
344 SHOW PROCESSLIST;
345
346 # Cleanup
347
348 SET GLOBAL performance_schema_show_processlist = 'OFF';
349