Debian Codegraph @

mysql-test/suite/perfschema/r/processlist_57.result

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