Debian Codegraph @

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