Debian Codegraph @

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

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