Debian Codegraph @

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

raw
1 flush status;
2 TRUNCATE TABLE performance_schema.host_cache;
3 flush user_resources;
4 flush privileges;
5 select @@global.debug;
6 @@global.debug
7
8 select @@global.max_connect_errors;
9 @@global.max_connect_errors
10 100
11 select @@global.max_user_connections;
12 @@global.max_user_connections
13 0
14 select @@global.max_connections;
15 @@global.max_connections
16 151
17 select `User`, `Host` from mysql.`user` where `host` like '%\\%%';
18 User Host
19 select `User`, `Host` from mysql.`user` where `user` like '192.%';
20 User Host
21 select `User`, `Host` from mysql.`user` where `user` like '2001:%';
22 User Host
23 select `User`, `Host` from mysql.`user` where `user` like 'santa.claus.%';
24 User Host
25 select @@global.max_connections into @saved_max_connections;
26 create user 'quota'@'santa.claus.ipv4.example.com'
27 with max_connections_per_hour 3;
28 grant select on test.* to 'quota'@'santa.claus.ipv4.example.com';
29 grant usage on *.* to 'quota'@'santa.claus.ipv4.example.com';
30 select "Con1 is alive";
31 Con1 is alive
32 Con1 is alive
33 select current_user();
34 current_user()
35 root@localhost
36 set global debug= "+d,vio_peer_addr_fake_ipv4,getnameinfo_fake_ipv4,getaddrinfo_fake_good_ipv4";
37 select "Con2a is alive";
38 Con2a is alive
39 Con2a is alive
40 select current_user();
41 current_user()
42 [email protected]
43 "Dumping performance_schema.host_cache"
44 IP 192.0.2.4
45 HOST santa.claus.ipv4.example.com
46 HOST_VALIDATED YES
47 SUM_CONNECT_ERRORS 0
48 COUNT_HOST_BLOCKED_ERRORS 0
49 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
50 COUNT_NAMEINFO_PERMANENT_ERRORS 0
51 COUNT_FORMAT_ERRORS 0
52 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
53 COUNT_ADDRINFO_PERMANENT_ERRORS 0
54 COUNT_FCRDNS_ERRORS 0
55 COUNT_HOST_ACL_ERRORS 0
56 COUNT_NO_AUTH_PLUGIN_ERRORS 0
57 COUNT_AUTH_PLUGIN_ERRORS 0
58 COUNT_HANDSHAKE_ERRORS 0
59 COUNT_PROXY_USER_ERRORS 0
60 COUNT_PROXY_USER_ACL_ERRORS 0
61 COUNT_AUTHENTICATION_ERRORS 0
62 COUNT_SSL_ERRORS 0
63 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
64 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
65 COUNT_DEFAULT_DATABASE_ERRORS 0
66 COUNT_INIT_CONNECT_ERRORS 0
67 COUNT_LOCAL_ERRORS 0
68 COUNT_UNKNOWN_ERRORS 0
69 FIRST_ERROR_SEEN null
70 LAST_ERROR_SEEN null
71 select "Con2b is alive";
72 Con2b is alive
73 Con2b is alive
74 select current_user();
75 current_user()
76 [email protected]
77 "Dumping performance_schema.host_cache"
78 IP 192.0.2.4
79 HOST santa.claus.ipv4.example.com
80 HOST_VALIDATED YES
81 SUM_CONNECT_ERRORS 0
82 COUNT_HOST_BLOCKED_ERRORS 0
83 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
84 COUNT_NAMEINFO_PERMANENT_ERRORS 0
85 COUNT_FORMAT_ERRORS 0
86 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
87 COUNT_ADDRINFO_PERMANENT_ERRORS 0
88 COUNT_FCRDNS_ERRORS 0
89 COUNT_HOST_ACL_ERRORS 0
90 COUNT_NO_AUTH_PLUGIN_ERRORS 0
91 COUNT_AUTH_PLUGIN_ERRORS 0
92 COUNT_HANDSHAKE_ERRORS 0
93 COUNT_PROXY_USER_ERRORS 0
94 COUNT_PROXY_USER_ACL_ERRORS 0
95 COUNT_AUTHENTICATION_ERRORS 0
96 COUNT_SSL_ERRORS 0
97 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
98 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
99 COUNT_DEFAULT_DATABASE_ERRORS 0
100 COUNT_INIT_CONNECT_ERRORS 0
101 COUNT_LOCAL_ERRORS 0
102 COUNT_UNKNOWN_ERRORS 0
103 FIRST_ERROR_SEEN null
104 LAST_ERROR_SEEN null
105 select "Con2c is alive";
106 Con2c is alive
107 Con2c is alive
108 select current_user();
109 current_user()
110 [email protected]
111 "Dumping performance_schema.host_cache"
112 IP 192.0.2.4
113 HOST santa.claus.ipv4.example.com
114 HOST_VALIDATED YES
115 SUM_CONNECT_ERRORS 0
116 COUNT_HOST_BLOCKED_ERRORS 0
117 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
118 COUNT_NAMEINFO_PERMANENT_ERRORS 0
119 COUNT_FORMAT_ERRORS 0
120 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
121 COUNT_ADDRINFO_PERMANENT_ERRORS 0
122 COUNT_FCRDNS_ERRORS 0
123 COUNT_HOST_ACL_ERRORS 0
124 COUNT_NO_AUTH_PLUGIN_ERRORS 0
125 COUNT_AUTH_PLUGIN_ERRORS 0
126 COUNT_HANDSHAKE_ERRORS 0
127 COUNT_PROXY_USER_ERRORS 0
128 COUNT_PROXY_USER_ACL_ERRORS 0
129 COUNT_AUTHENTICATION_ERRORS 0
130 COUNT_SSL_ERRORS 0
131 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
132 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 0
133 COUNT_DEFAULT_DATABASE_ERRORS 0
134 COUNT_INIT_CONNECT_ERRORS 0
135 COUNT_LOCAL_ERRORS 0
136 COUNT_UNKNOWN_ERRORS 0
137 FIRST_ERROR_SEEN null
138 LAST_ERROR_SEEN null
139 ERROR 42000: User 'quota' has exceeded the 'max_connections_per_hour' resource (current value: 3)
140 "Dumping performance_schema.host_cache"
141 IP 192.0.2.4
142 HOST santa.claus.ipv4.example.com
143 HOST_VALIDATED YES
144 SUM_CONNECT_ERRORS 0
145 COUNT_HOST_BLOCKED_ERRORS 0
146 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
147 COUNT_NAMEINFO_PERMANENT_ERRORS 0
148 COUNT_FORMAT_ERRORS 0
149 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
150 COUNT_ADDRINFO_PERMANENT_ERRORS 0
151 COUNT_FCRDNS_ERRORS 0
152 COUNT_HOST_ACL_ERRORS 0
153 COUNT_NO_AUTH_PLUGIN_ERRORS 0
154 COUNT_AUTH_PLUGIN_ERRORS 0
155 COUNT_HANDSHAKE_ERRORS 0
156 COUNT_PROXY_USER_ERRORS 0
157 COUNT_PROXY_USER_ACL_ERRORS 0
158 COUNT_AUTHENTICATION_ERRORS 0
159 COUNT_SSL_ERRORS 0
160 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
161 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 1
162 COUNT_DEFAULT_DATABASE_ERRORS 0
163 COUNT_INIT_CONNECT_ERRORS 0
164 COUNT_LOCAL_ERRORS 0
165 COUNT_UNKNOWN_ERRORS 0
166 FIRST_ERROR_SEEN set
167 LAST_ERROR_SEEN set
168 ERROR 42000: User 'quota' has exceeded the 'max_connections_per_hour' resource (current value: 3)
169 "Dumping performance_schema.host_cache"
170 IP 192.0.2.4
171 HOST santa.claus.ipv4.example.com
172 HOST_VALIDATED YES
173 SUM_CONNECT_ERRORS 0
174 COUNT_HOST_BLOCKED_ERRORS 0
175 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
176 COUNT_NAMEINFO_PERMANENT_ERRORS 0
177 COUNT_FORMAT_ERRORS 0
178 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
179 COUNT_ADDRINFO_PERMANENT_ERRORS 0
180 COUNT_FCRDNS_ERRORS 0
181 COUNT_HOST_ACL_ERRORS 0
182 COUNT_NO_AUTH_PLUGIN_ERRORS 0
183 COUNT_AUTH_PLUGIN_ERRORS 0
184 COUNT_HANDSHAKE_ERRORS 0
185 COUNT_PROXY_USER_ERRORS 0
186 COUNT_PROXY_USER_ACL_ERRORS 0
187 COUNT_AUTHENTICATION_ERRORS 0
188 COUNT_SSL_ERRORS 0
189 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
190 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
191 COUNT_DEFAULT_DATABASE_ERRORS 0
192 COUNT_INIT_CONNECT_ERRORS 0
193 COUNT_LOCAL_ERRORS 0
194 COUNT_UNKNOWN_ERRORS 0
195 FIRST_ERROR_SEEN set
196 LAST_ERROR_SEEN set
197 alter user 'quota'@'santa.claus.ipv4.example.com'
198 with max_connections_per_hour 0;
199 alter user 'quota'@'santa.claus.ipv4.example.com'
200 with max_user_connections 3;
201 flush user_resources;
202 select "Con7 is alive";
203 Con7 is alive
204 Con7 is alive
205 select current_user();
206 current_user()
207 [email protected]
208 "Dumping performance_schema.host_cache"
209 IP 192.0.2.4
210 HOST santa.claus.ipv4.example.com
211 HOST_VALIDATED YES
212 SUM_CONNECT_ERRORS 0
213 COUNT_HOST_BLOCKED_ERRORS 0
214 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
215 COUNT_NAMEINFO_PERMANENT_ERRORS 0
216 COUNT_FORMAT_ERRORS 0
217 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
218 COUNT_ADDRINFO_PERMANENT_ERRORS 0
219 COUNT_FCRDNS_ERRORS 0
220 COUNT_HOST_ACL_ERRORS 0
221 COUNT_NO_AUTH_PLUGIN_ERRORS 0
222 COUNT_AUTH_PLUGIN_ERRORS 0
223 COUNT_HANDSHAKE_ERRORS 0
224 COUNT_PROXY_USER_ERRORS 0
225 COUNT_PROXY_USER_ACL_ERRORS 0
226 COUNT_AUTHENTICATION_ERRORS 0
227 COUNT_SSL_ERRORS 0
228 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
229 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
230 COUNT_DEFAULT_DATABASE_ERRORS 0
231 COUNT_INIT_CONNECT_ERRORS 0
232 COUNT_LOCAL_ERRORS 0
233 COUNT_UNKNOWN_ERRORS 0
234 FIRST_ERROR_SEEN set
235 LAST_ERROR_SEEN set
236 select "Con3b is alive";
237 Con3b is alive
238 Con3b is alive
239 select current_user();
240 current_user()
241 [email protected]
242 "Dumping performance_schema.host_cache"
243 IP 192.0.2.4
244 HOST santa.claus.ipv4.example.com
245 HOST_VALIDATED YES
246 SUM_CONNECT_ERRORS 0
247 COUNT_HOST_BLOCKED_ERRORS 0
248 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
249 COUNT_NAMEINFO_PERMANENT_ERRORS 0
250 COUNT_FORMAT_ERRORS 0
251 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
252 COUNT_ADDRINFO_PERMANENT_ERRORS 0
253 COUNT_FCRDNS_ERRORS 0
254 COUNT_HOST_ACL_ERRORS 0
255 COUNT_NO_AUTH_PLUGIN_ERRORS 0
256 COUNT_AUTH_PLUGIN_ERRORS 0
257 COUNT_HANDSHAKE_ERRORS 0
258 COUNT_PROXY_USER_ERRORS 0
259 COUNT_PROXY_USER_ACL_ERRORS 0
260 COUNT_AUTHENTICATION_ERRORS 0
261 COUNT_SSL_ERRORS 0
262 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
263 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
264 COUNT_DEFAULT_DATABASE_ERRORS 0
265 COUNT_INIT_CONNECT_ERRORS 0
266 COUNT_LOCAL_ERRORS 0
267 COUNT_UNKNOWN_ERRORS 0
268 FIRST_ERROR_SEEN set
269 LAST_ERROR_SEEN set
270 select "Con3c is alive";
271 Con3c is alive
272 Con3c is alive
273 select current_user();
274 current_user()
275 [email protected]
276 "Dumping performance_schema.host_cache"
277 IP 192.0.2.4
278 HOST santa.claus.ipv4.example.com
279 HOST_VALIDATED YES
280 SUM_CONNECT_ERRORS 0
281 COUNT_HOST_BLOCKED_ERRORS 0
282 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
283 COUNT_NAMEINFO_PERMANENT_ERRORS 0
284 COUNT_FORMAT_ERRORS 0
285 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
286 COUNT_ADDRINFO_PERMANENT_ERRORS 0
287 COUNT_FCRDNS_ERRORS 0
288 COUNT_HOST_ACL_ERRORS 0
289 COUNT_NO_AUTH_PLUGIN_ERRORS 0
290 COUNT_AUTH_PLUGIN_ERRORS 0
291 COUNT_HANDSHAKE_ERRORS 0
292 COUNT_PROXY_USER_ERRORS 0
293 COUNT_PROXY_USER_ACL_ERRORS 0
294 COUNT_AUTHENTICATION_ERRORS 0
295 COUNT_SSL_ERRORS 0
296 COUNT_MAX_USER_CONNECTIONS_ERRORS 0
297 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
298 COUNT_DEFAULT_DATABASE_ERRORS 0
299 COUNT_INIT_CONNECT_ERRORS 0
300 COUNT_LOCAL_ERRORS 0
301 COUNT_UNKNOWN_ERRORS 0
302 FIRST_ERROR_SEEN set
303 LAST_ERROR_SEEN set
304 ERROR 42000: User 'quota' has exceeded the 'max_user_connections' resource (current value: 3)
305 "Dumping performance_schema.host_cache"
306 IP 192.0.2.4
307 HOST santa.claus.ipv4.example.com
308 HOST_VALIDATED YES
309 SUM_CONNECT_ERRORS 0
310 COUNT_HOST_BLOCKED_ERRORS 0
311 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
312 COUNT_NAMEINFO_PERMANENT_ERRORS 0
313 COUNT_FORMAT_ERRORS 0
314 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
315 COUNT_ADDRINFO_PERMANENT_ERRORS 0
316 COUNT_FCRDNS_ERRORS 0
317 COUNT_HOST_ACL_ERRORS 0
318 COUNT_NO_AUTH_PLUGIN_ERRORS 0
319 COUNT_AUTH_PLUGIN_ERRORS 0
320 COUNT_HANDSHAKE_ERRORS 0
321 COUNT_PROXY_USER_ERRORS 0
322 COUNT_PROXY_USER_ACL_ERRORS 0
323 COUNT_AUTHENTICATION_ERRORS 0
324 COUNT_SSL_ERRORS 0
325 COUNT_MAX_USER_CONNECTIONS_ERRORS 1
326 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
327 COUNT_DEFAULT_DATABASE_ERRORS 0
328 COUNT_INIT_CONNECT_ERRORS 0
329 COUNT_LOCAL_ERRORS 0
330 COUNT_UNKNOWN_ERRORS 0
331 FIRST_ERROR_SEEN set
332 LAST_ERROR_SEEN set
333 ERROR 42000: User 'quota' has exceeded the 'max_user_connections' resource (current value: 3)
334 "Dumping performance_schema.host_cache"
335 IP 192.0.2.4
336 HOST santa.claus.ipv4.example.com
337 HOST_VALIDATED YES
338 SUM_CONNECT_ERRORS 0
339 COUNT_HOST_BLOCKED_ERRORS 0
340 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
341 COUNT_NAMEINFO_PERMANENT_ERRORS 0
342 COUNT_FORMAT_ERRORS 0
343 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
344 COUNT_ADDRINFO_PERMANENT_ERRORS 0
345 COUNT_FCRDNS_ERRORS 0
346 COUNT_HOST_ACL_ERRORS 0
347 COUNT_NO_AUTH_PLUGIN_ERRORS 0
348 COUNT_AUTH_PLUGIN_ERRORS 0
349 COUNT_HANDSHAKE_ERRORS 0
350 COUNT_PROXY_USER_ERRORS 0
351 COUNT_PROXY_USER_ACL_ERRORS 0
352 COUNT_AUTHENTICATION_ERRORS 0
353 COUNT_SSL_ERRORS 0
354 COUNT_MAX_USER_CONNECTIONS_ERRORS 2
355 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
356 COUNT_DEFAULT_DATABASE_ERRORS 0
357 COUNT_INIT_CONNECT_ERRORS 0
358 COUNT_LOCAL_ERRORS 0
359 COUNT_UNKNOWN_ERRORS 0
360 FIRST_ERROR_SEEN set
361 LAST_ERROR_SEEN set
362 alter user 'quota'@'santa.claus.ipv4.example.com'
363 with max_user_connections 0;
364 flush user_resources;
365 set global max_user_connections = 3;
366 select "Con4a is alive";
367 Con4a is alive
368 Con4a is alive
369 select current_user();
370 current_user()
371 [email protected]
372 "Dumping performance_schema.host_cache"
373 IP 192.0.2.4
374 HOST santa.claus.ipv4.example.com
375 HOST_VALIDATED YES
376 SUM_CONNECT_ERRORS 0
377 COUNT_HOST_BLOCKED_ERRORS 0
378 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
379 COUNT_NAMEINFO_PERMANENT_ERRORS 0
380 COUNT_FORMAT_ERRORS 0
381 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
382 COUNT_ADDRINFO_PERMANENT_ERRORS 0
383 COUNT_FCRDNS_ERRORS 0
384 COUNT_HOST_ACL_ERRORS 0
385 COUNT_NO_AUTH_PLUGIN_ERRORS 0
386 COUNT_AUTH_PLUGIN_ERRORS 0
387 COUNT_HANDSHAKE_ERRORS 0
388 COUNT_PROXY_USER_ERRORS 0
389 COUNT_PROXY_USER_ACL_ERRORS 0
390 COUNT_AUTHENTICATION_ERRORS 0
391 COUNT_SSL_ERRORS 0
392 COUNT_MAX_USER_CONNECTIONS_ERRORS 2
393 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
394 COUNT_DEFAULT_DATABASE_ERRORS 0
395 COUNT_INIT_CONNECT_ERRORS 0
396 COUNT_LOCAL_ERRORS 0
397 COUNT_UNKNOWN_ERRORS 0
398 FIRST_ERROR_SEEN set
399 LAST_ERROR_SEEN set
400 select "Con4b is alive";
401 Con4b is alive
402 Con4b is alive
403 select current_user();
404 current_user()
405 [email protected]
406 "Dumping performance_schema.host_cache"
407 IP 192.0.2.4
408 HOST santa.claus.ipv4.example.com
409 HOST_VALIDATED YES
410 SUM_CONNECT_ERRORS 0
411 COUNT_HOST_BLOCKED_ERRORS 0
412 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
413 COUNT_NAMEINFO_PERMANENT_ERRORS 0
414 COUNT_FORMAT_ERRORS 0
415 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
416 COUNT_ADDRINFO_PERMANENT_ERRORS 0
417 COUNT_FCRDNS_ERRORS 0
418 COUNT_HOST_ACL_ERRORS 0
419 COUNT_NO_AUTH_PLUGIN_ERRORS 0
420 COUNT_AUTH_PLUGIN_ERRORS 0
421 COUNT_HANDSHAKE_ERRORS 0
422 COUNT_PROXY_USER_ERRORS 0
423 COUNT_PROXY_USER_ACL_ERRORS 0
424 COUNT_AUTHENTICATION_ERRORS 0
425 COUNT_SSL_ERRORS 0
426 COUNT_MAX_USER_CONNECTIONS_ERRORS 2
427 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
428 COUNT_DEFAULT_DATABASE_ERRORS 0
429 COUNT_INIT_CONNECT_ERRORS 0
430 COUNT_LOCAL_ERRORS 0
431 COUNT_UNKNOWN_ERRORS 0
432 FIRST_ERROR_SEEN set
433 LAST_ERROR_SEEN set
434 select "Con4c is alive";
435 Con4c is alive
436 Con4c is alive
437 select current_user();
438 current_user()
439 [email protected]
440 "Dumping performance_schema.host_cache"
441 IP 192.0.2.4
442 HOST santa.claus.ipv4.example.com
443 HOST_VALIDATED YES
444 SUM_CONNECT_ERRORS 0
445 COUNT_HOST_BLOCKED_ERRORS 0
446 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
447 COUNT_NAMEINFO_PERMANENT_ERRORS 0
448 COUNT_FORMAT_ERRORS 0
449 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
450 COUNT_ADDRINFO_PERMANENT_ERRORS 0
451 COUNT_FCRDNS_ERRORS 0
452 COUNT_HOST_ACL_ERRORS 0
453 COUNT_NO_AUTH_PLUGIN_ERRORS 0
454 COUNT_AUTH_PLUGIN_ERRORS 0
455 COUNT_HANDSHAKE_ERRORS 0
456 COUNT_PROXY_USER_ERRORS 0
457 COUNT_PROXY_USER_ACL_ERRORS 0
458 COUNT_AUTHENTICATION_ERRORS 0
459 COUNT_SSL_ERRORS 0
460 COUNT_MAX_USER_CONNECTIONS_ERRORS 2
461 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
462 COUNT_DEFAULT_DATABASE_ERRORS 0
463 COUNT_INIT_CONNECT_ERRORS 0
464 COUNT_LOCAL_ERRORS 0
465 COUNT_UNKNOWN_ERRORS 0
466 FIRST_ERROR_SEEN set
467 LAST_ERROR_SEEN set
468 ERROR 42000: User quota already has more than 'max_user_connections' active connections
469 "Dumping performance_schema.host_cache"
470 IP 192.0.2.4
471 HOST santa.claus.ipv4.example.com
472 HOST_VALIDATED YES
473 SUM_CONNECT_ERRORS 0
474 COUNT_HOST_BLOCKED_ERRORS 0
475 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
476 COUNT_NAMEINFO_PERMANENT_ERRORS 0
477 COUNT_FORMAT_ERRORS 0
478 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
479 COUNT_ADDRINFO_PERMANENT_ERRORS 0
480 COUNT_FCRDNS_ERRORS 0
481 COUNT_HOST_ACL_ERRORS 0
482 COUNT_NO_AUTH_PLUGIN_ERRORS 0
483 COUNT_AUTH_PLUGIN_ERRORS 0
484 COUNT_HANDSHAKE_ERRORS 0
485 COUNT_PROXY_USER_ERRORS 0
486 COUNT_PROXY_USER_ACL_ERRORS 0
487 COUNT_AUTHENTICATION_ERRORS 0
488 COUNT_SSL_ERRORS 0
489 COUNT_MAX_USER_CONNECTIONS_ERRORS 3
490 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
491 COUNT_DEFAULT_DATABASE_ERRORS 0
492 COUNT_INIT_CONNECT_ERRORS 0
493 COUNT_LOCAL_ERRORS 0
494 COUNT_UNKNOWN_ERRORS 0
495 FIRST_ERROR_SEEN set
496 LAST_ERROR_SEEN set
497 ERROR 42000: User quota already has more than 'max_user_connections' active connections
498 "Dumping performance_schema.host_cache"
499 IP 192.0.2.4
500 HOST santa.claus.ipv4.example.com
501 HOST_VALIDATED YES
502 SUM_CONNECT_ERRORS 0
503 COUNT_HOST_BLOCKED_ERRORS 0
504 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
505 COUNT_NAMEINFO_PERMANENT_ERRORS 0
506 COUNT_FORMAT_ERRORS 0
507 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
508 COUNT_ADDRINFO_PERMANENT_ERRORS 0
509 COUNT_FCRDNS_ERRORS 0
510 COUNT_HOST_ACL_ERRORS 0
511 COUNT_NO_AUTH_PLUGIN_ERRORS 0
512 COUNT_AUTH_PLUGIN_ERRORS 0
513 COUNT_HANDSHAKE_ERRORS 0
514 COUNT_PROXY_USER_ERRORS 0
515 COUNT_PROXY_USER_ACL_ERRORS 0
516 COUNT_AUTHENTICATION_ERRORS 0
517 COUNT_SSL_ERRORS 0
518 COUNT_MAX_USER_CONNECTIONS_ERRORS 4
519 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
520 COUNT_DEFAULT_DATABASE_ERRORS 0
521 COUNT_INIT_CONNECT_ERRORS 0
522 COUNT_LOCAL_ERRORS 0
523 COUNT_UNKNOWN_ERRORS 0
524 FIRST_ERROR_SEEN set
525 LAST_ERROR_SEEN set
526 set global max_user_connections = 0;
527 set global max_connections = 3;
528 flush user_resources;
529 select "Con4a is alive";
530 Con4a is alive
531 Con4a is alive
532 select current_user();
533 current_user()
534 [email protected]
535 "Dumping performance_schema.host_cache"
536 IP 192.0.2.4
537 HOST santa.claus.ipv4.example.com
538 HOST_VALIDATED YES
539 SUM_CONNECT_ERRORS 0
540 COUNT_HOST_BLOCKED_ERRORS 0
541 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
542 COUNT_NAMEINFO_PERMANENT_ERRORS 0
543 COUNT_FORMAT_ERRORS 0
544 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
545 COUNT_ADDRINFO_PERMANENT_ERRORS 0
546 COUNT_FCRDNS_ERRORS 0
547 COUNT_HOST_ACL_ERRORS 0
548 COUNT_NO_AUTH_PLUGIN_ERRORS 0
549 COUNT_AUTH_PLUGIN_ERRORS 0
550 COUNT_HANDSHAKE_ERRORS 0
551 COUNT_PROXY_USER_ERRORS 0
552 COUNT_PROXY_USER_ACL_ERRORS 0
553 COUNT_AUTHENTICATION_ERRORS 0
554 COUNT_SSL_ERRORS 0
555 COUNT_MAX_USER_CONNECTIONS_ERRORS 4
556 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
557 COUNT_DEFAULT_DATABASE_ERRORS 0
558 COUNT_INIT_CONNECT_ERRORS 0
559 COUNT_LOCAL_ERRORS 0
560 COUNT_UNKNOWN_ERRORS 0
561 FIRST_ERROR_SEEN set
562 LAST_ERROR_SEEN set
563 select "Con5b is alive";
564 Con5b is alive
565 Con5b is alive
566 select current_user();
567 current_user()
568 [email protected]
569 "Dumping performance_schema.host_cache"
570 IP 192.0.2.4
571 HOST santa.claus.ipv4.example.com
572 HOST_VALIDATED YES
573 SUM_CONNECT_ERRORS 0
574 COUNT_HOST_BLOCKED_ERRORS 0
575 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
576 COUNT_NAMEINFO_PERMANENT_ERRORS 0
577 COUNT_FORMAT_ERRORS 0
578 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
579 COUNT_ADDRINFO_PERMANENT_ERRORS 0
580 COUNT_FCRDNS_ERRORS 0
581 COUNT_HOST_ACL_ERRORS 0
582 COUNT_NO_AUTH_PLUGIN_ERRORS 0
583 COUNT_AUTH_PLUGIN_ERRORS 0
584 COUNT_HANDSHAKE_ERRORS 0
585 COUNT_PROXY_USER_ERRORS 0
586 COUNT_PROXY_USER_ACL_ERRORS 0
587 COUNT_AUTHENTICATION_ERRORS 0
588 COUNT_SSL_ERRORS 0
589 COUNT_MAX_USER_CONNECTIONS_ERRORS 4
590 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
591 COUNT_DEFAULT_DATABASE_ERRORS 0
592 COUNT_INIT_CONNECT_ERRORS 0
593 COUNT_LOCAL_ERRORS 0
594 COUNT_UNKNOWN_ERRORS 0
595 FIRST_ERROR_SEEN set
596 LAST_ERROR_SEEN set
597 Got one of the listed errors
598 "Dumping performance_schema.host_cache"
599 IP 192.0.2.4
600 HOST santa.claus.ipv4.example.com
601 HOST_VALIDATED YES
602 SUM_CONNECT_ERRORS 0
603 COUNT_HOST_BLOCKED_ERRORS 0
604 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
605 COUNT_NAMEINFO_PERMANENT_ERRORS 0
606 COUNT_FORMAT_ERRORS 0
607 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
608 COUNT_ADDRINFO_PERMANENT_ERRORS 0
609 COUNT_FCRDNS_ERRORS 0
610 COUNT_HOST_ACL_ERRORS 0
611 COUNT_NO_AUTH_PLUGIN_ERRORS 0
612 COUNT_AUTH_PLUGIN_ERRORS 0
613 COUNT_HANDSHAKE_ERRORS 0
614 COUNT_PROXY_USER_ERRORS 0
615 COUNT_PROXY_USER_ACL_ERRORS 0
616 COUNT_AUTHENTICATION_ERRORS 0
617 COUNT_SSL_ERRORS 0
618 COUNT_MAX_USER_CONNECTIONS_ERRORS 4
619 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
620 COUNT_DEFAULT_DATABASE_ERRORS 0
621 COUNT_INIT_CONNECT_ERRORS 0
622 COUNT_LOCAL_ERRORS 0
623 COUNT_UNKNOWN_ERRORS 0
624 FIRST_ERROR_SEEN set
625 LAST_ERROR_SEEN set
626 Got one of the listed errors
627 "Dumping performance_schema.host_cache"
628 IP 192.0.2.4
629 HOST santa.claus.ipv4.example.com
630 HOST_VALIDATED YES
631 SUM_CONNECT_ERRORS 0
632 COUNT_HOST_BLOCKED_ERRORS 0
633 COUNT_NAMEINFO_TRANSIENT_ERRORS 0
634 COUNT_NAMEINFO_PERMANENT_ERRORS 0
635 COUNT_FORMAT_ERRORS 0
636 COUNT_ADDRINFO_TRANSIENT_ERRORS 0
637 COUNT_ADDRINFO_PERMANENT_ERRORS 0
638 COUNT_FCRDNS_ERRORS 0
639 COUNT_HOST_ACL_ERRORS 0
640 COUNT_NO_AUTH_PLUGIN_ERRORS 0
641 COUNT_AUTH_PLUGIN_ERRORS 0
642 COUNT_HANDSHAKE_ERRORS 0
643 COUNT_PROXY_USER_ERRORS 0
644 COUNT_PROXY_USER_ACL_ERRORS 0
645 COUNT_AUTHENTICATION_ERRORS 0
646 COUNT_SSL_ERRORS 0
647 COUNT_MAX_USER_CONNECTIONS_ERRORS 4
648 COUNT_MAX_USER_CONNECTIONS_PER_HOUR_ERRORS 2
649 COUNT_DEFAULT_DATABASE_ERRORS 0
650 COUNT_INIT_CONNECT_ERRORS 0
651 COUNT_LOCAL_ERRORS 0
652 COUNT_UNKNOWN_ERRORS 0
653 FIRST_ERROR_SEEN set
654 LAST_ERROR_SEEN set
655 set global max_connections = @saved_max_connections;
656 drop user 'quota'@'santa.claus.ipv4.example.com';
657 set global debug= default;