Debian Codegraph @

mysql-test/suite/x/r/admin_xkill.result

raw
1 call mtr.add_suppression("Plugin mysqlx reported: 'Unhandled network error: Bad file descriptor'");
2 create user sslcon@localhost identified by 'sslcon';
3 grant all on *.* to sslcon@localhost;
4 RUN create user abc@localhost identified by 'abc',
5 xplugin@localhost identified by 'xplugin',
6 process@localhost identified by 'process',
7 expire@localhost identified by 'expire'
8
9 0 rows affected
10 RUN grant all on *.* to xplugin@localhost,
11 expire@localhost
12
13 0 rows affected
14 RUN grant process on *.* to process@localhost
15
16 0 rows affected
17 RUN alter user expire@localhost password expire
18
19 0 rows affected
20 RUN select sleep(1)
21 sleep(1)
22 0
23 0 rows affected
24 Test data
25 client_id user host sql_session
26 1 x_root localhost $SESSION
27 command ok
28 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
29 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
30 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
31 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
32 create and activate new session
33 connecting...
34 active session is now 'aux'
35 client_id user host
36 1 x_root localhost
37 2 x_root localhost
38 command ok
39 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 even with another new x_root session
40 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
41 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
42 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
43 switch back to default session
44 switched to session default
45 client_id user host
46 1 x_root localhost
47 2 x_root localhost
48 command ok
49 expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=0 with default x_root session where list_clients already executed
50 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
51 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2]
52 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
53 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
54 RUN [stmtadmin kill_client 2]
55
56 command ok
57 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
58 client_id user host
59 1 x_root localhost
60 command ok
61 expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 3 times and kill_client once
62 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
63 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 3]
64 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
65 create and activate new session abc
66 expect only abc user session id
67 connecting...
68 active session is now 'abc'
69 client_id user host
70 3 abc localhost
71 command ok
72 killing x_root user session with unprivileged user 'abc' which should be unsuccessful
73 RUN [stmtadmin kill_client 1]
74 Got expected error: You are not owner of thread (code 1095)
75 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=1 with session abc where list_clients and kill_client executed once
76 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
77 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
78 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
79 RUN select user(),current_user()
80 user() current_user()
81 abc@localhost abc@localhost
82 0 rows affected
83 RUN show grants
84 Grants for abc@localhost
85 GRANT USAGE ON *.* TO `abc`@`localhost`
86 0 rows affected
87 open another session of abc user and kill first session of abc user,which should be successful
88 connecting...
89 active session is now 'abc1'
90 client_id user host
91 3 abc localhost
92 4 abc localhost
93 command ok
94 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
95 RUN [stmtadmin kill_client 3]
96
97 command ok
98 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
99 client_id user host
100 4 abc localhost
101 command ok
102 expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with new session abc where list_clients executed twice and kill_client executed once
103 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
104 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2]
105 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
106 RUN select user(),current_user()
107 user() current_user()
108 abc@localhost abc@localhost
109 0 rows affected
110 RUN show grants
111 Grants for abc@localhost
112 GRANT USAGE ON *.* TO `abc`@`localhost`
113 0 rows affected
114 killing abc user session with its own session 'abc' which should be successful
115 expect right error instead of End of File
116 Server disconnected
117 closing session abc1
118 switched to session default
119 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
120 switch back to default session
121 switched to session default
122 client_id user host
123 1 x_root localhost
124 command ok
125 expect Mysqlx_stmt_list_clients=4 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 4 times and kill_client once
126 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
127 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 4]
128 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
129 RUN select user(),current_user()
130 user() current_user()
131 x_root@localhost x_root@localhost
132 0 rows affected
133 RUN show grants
134 Grants for x_root@localhost
135 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `x_root`@`localhost` WITH GRANT OPTION
136 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `x_root`@`localhost` WITH GRANT OPTION
137 0 rows affected
138 open process only privileged user seession and kill x_root user session,expect error "You are not owner of thread"
139 connecting...
140 active session is now 'process'
141 client_id user host
142 5 process localhost
143 command ok
144 RUN [stmtadmin kill_client 1]
145 Got expected error: You are not owner of thread (code 1095)
146 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
147 checking list of clients after x_root user session killed by xplugin user
148 client_id user host
149 5 process localhost
150 command ok
151 expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with process user where list_clients executed 2 times and kill_client once
152 RUN show status like 'Mysqlx_stmt%client%'
153 Variable_name Value
154 Mysqlx_stmt_kill_client 1
155 Mysqlx_stmt_list_clients 2
156 0 rows affected
157 RUN select user(),current_user()
158 user() current_user()
159 process@localhost process@localhost
160 0 rows affected
161 RUN show grants
162 Grants for process@localhost
163 GRANT PROCESS ON *.* TO `process`@`localhost`
164 0 rows affected
165 open privileged user seession and kill x_root user session,expect success
166 connecting...
167 active session is now 'xplugin'
168 client_id user host
169 1 x_root localhost
170 5 process localhost
171 6 xplugin localhost
172 command ok
173 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
174 RUN [stmtadmin kill_client 1]
175
176 command ok
177 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
178 checking list of clients after x_root user session killed by xplugin user
179 client_id user host
180 5 process localhost
181 6 xplugin localhost
182 command ok
183 expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with xplugin user where list_clients executed 2 times and kill_client once
184 RUN show status like 'Mysqlx_stmt%client%'
185 Variable_name Value
186 Mysqlx_stmt_kill_client 1
187 Mysqlx_stmt_list_clients 2
188 0 rows affected
189 RUN select user(),current_user()
190 user() current_user()
191 xplugin@localhost xplugin@localhost
192 0 rows affected
193 RUN show grants
194 Grants for xplugin@localhost
195 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `xplugin`@`localhost`
196 GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `xplugin`@`localhost`
197 0 rows affected
198 Cleanup
199 RUN drop schema if exists xtest
200
201 0 rows affected
202 closing session xplugin
203 Mysqlx.Ok {
204 msg: "bye!"
205 }
206 ok
207 client_id user host
208 7 x_root localhost
209 command ok
210 expect error while killing client with data type other than usinged int
211 try killing xprotocol session with valid sql_session id once xprotocol connetion opened with kill_client,expect error
212 RUN [stmtadmin kill_client 11]
213 Got expected error: Unknown MySQLx client id 11 (code 1094)
214 Got expected error: Invalid value for argument 'id' (code 5017)
215 Got expected error: Invalid value for argument 'id' (code 5017)
216 Got expected error: Invalid value for argument 'id' (code 5017)
217 Got expected error: Invalid value for argument 'id' (code 5017)
218 Got expected error: Invalid value for argument 'id' (code 5017)
219 Got expected error: Invalid value for argument 'id' (code 5017)
220 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=11 with x_root user even though kill_client returns errors
221 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 7]
222 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
223 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
224 Mysqlx.Ok {
225 msg: "bye!"
226 }
227 ok
228 NOTICE: Account password expired
229 expect error if list_clients and kill_client executed from password expired user session
230 RUN show processlist
231 While executing show processlist:
232 Got expected error: You must reset your password using ALTER USER statement before executing this statement. (code 1820)
233 Got expected error: You must reset your password using ALTER USER statement before executing this statement. (code 1820)
234 RUN [stmtadmin kill_client 8]
235 Got expected error: You must reset your password using ALTER USER statement before executing this statement. (code 1820)
236 Mysqlx.Ok {
237 msg: "bye!"
238 }
239 ok
240 checking list_clients and kill_client with mixed case, expect success as these commands are case insensitive
241 client_id user host
242 9 x_root localhost
243 command ok
244 Got expected error: Unknown MySQLx client id 998 (code 1094)
245 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=1 with x_root user when these commads executed with mixed case
246 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
247 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
248 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
249 Mysqlx.Ok {
250 msg: "bye!"
251 }
252 ok
253 checking list_clients and kill_client with default 50 connections, expect success for both list and kill
254 RUN set @@global.mysqlx_max_connections=60
255
256 0 rows affected
257 RUN create user xconnection1@localhost identified by 'xconnection1',
258 xconnection2@localhost identified by 'xconnection2',
259 xconnection3@localhost identified by 'xconnection3',
260 xconnection4@localhost identified by 'xconnection4',
261 xconnection5@localhost identified by 'xconnection5',
262 xconnection6@localhost identified by 'xconnection6',
263 xconnection7@localhost identified by 'xconnection7',
264 xconnection8@localhost identified by 'xconnection8',
265 xconnection9@localhost identified by 'xconnection9',
266 xconnection10@localhost identified by 'xconnection10',
267 xconnection11@localhost identified by 'xconnection11',
268 xconnection12@localhost identified by 'xconnection12',
269 xconnection13@localhost identified by 'xconnection13',
270 xconnection14@localhost identified by 'xconnection14',
271 xconnection15@localhost identified by 'xconnection15',
272 xconnection16@localhost identified by 'xconnection16',
273 xconnection17@localhost identified by 'xconnection17',
274 xconnection18@localhost identified by 'xconnection18',
275 xconnection19@localhost identified by 'xconnection19',
276 xconnection20@localhost identified by 'xconnection20',
277 xconnection21@localhost identified by 'xconnection21',
278 xconnection22@localhost identified by 'xconnection22',
279 xconnection23@localhost identified by 'xconnection23',
280 xconnection24@localhost identified by 'xconnection24',
281 xconnection25@localhost identified by 'xconnection25',
282 xconnection26@localhost identified by 'xconnection26',
283 xconnection27@localhost identified by 'xconnection27',
284 xconnection28@localhost identified by 'xconnection28',
285 xconnection29@localhost identified by 'xconnection29',
286 xconnection30@localhost identified by 'xconnection30',
287 xconnection31@localhost identified by 'xconnection31',
288 xconnection32@localhost identified by 'xconnection32',
289 xconnection33@localhost identified by 'xconnection33',
290 xconnection34@localhost identified by 'xconnection34',
291 xconnection35@localhost identified by 'xconnection35',
292 xconnection36@localhost identified by 'xconnection36',
293 xconnection37@localhost identified by 'xconnection37',
294 xconnection38@localhost identified by 'xconnection38',
295 xconnection39@localhost identified by 'xconnection39',
296 xconnection40@localhost identified by 'xconnection40',
297 xconnection41@localhost identified by 'xconnection41',
298 xconnection42@localhost identified by 'xconnection42',
299 xconnection43@localhost identified by 'xconnection43',
300 xconnection44@localhost identified by 'xconnection44',
301 xconnection45@localhost identified by 'xconnection45',
302 xconnection46@localhost identified by 'xconnection46',
303 xconnection47@localhost identified by 'xconnection47',
304 xconnection48@localhost identified by 'xconnection48',
305 xconnection49@localhost identified by 'xconnection49',
306 xconnection50@localhost identified by 'xconnection50'
307
308 0 rows affected
309 Test data
310 client_id user host sql_session
311 10 x_root localhost $SESSION
312 command ok
313 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
314 RUN show status like 'Mysqlx_stmt%client%'
315 Variable_name Value
316 Mysqlx_stmt_kill_client 0
317 Mysqlx_stmt_list_clients 1
318 0 rows affected
319 create and activate new session xconnection1
320 connecting...
321 active session is now 'xconnection1'
322 connecting...
323 active session is now 'xconnection2'
324 connecting...
325 active session is now 'xconnection3'
326 connecting...
327 active session is now 'xconnection4'
328 connecting...
329 active session is now 'xconnection5'
330 connecting...
331 active session is now 'xconnection6'
332 connecting...
333 active session is now 'xconnection7'
334 connecting...
335 active session is now 'xconnection8'
336 connecting...
337 active session is now 'xconnection9'
338 connecting...
339 active session is now 'xconnection10'
340 connecting...
341 active session is now 'xconnection11'
342 connecting...
343 active session is now 'xconnection12'
344 connecting...
345 active session is now 'xconnection13'
346 connecting...
347 active session is now 'xconnection14'
348 connecting...
349 active session is now 'xconnection15'
350 connecting...
351 active session is now 'xconnection16'
352 connecting...
353 active session is now 'xconnection17'
354 connecting...
355 active session is now 'xconnection18'
356 connecting...
357 active session is now 'xconnection19'
358 connecting...
359 active session is now 'xconnection20'
360 connecting...
361 active session is now 'xconnection21'
362 connecting...
363 active session is now 'xconnection22'
364 connecting...
365 active session is now 'xconnection23'
366 connecting...
367 active session is now 'xconnection24'
368 connecting...
369 active session is now 'xconnection25'
370 connecting...
371 active session is now 'xconnection26'
372 connecting...
373 active session is now 'xconnection27'
374 connecting...
375 active session is now 'xconnection28'
376 connecting...
377 active session is now 'xconnection29'
378 connecting...
379 active session is now 'xconnection30'
380 connecting...
381 active session is now 'xconnection31'
382 connecting...
383 active session is now 'xconnection32'
384 connecting...
385 active session is now 'xconnection33'
386 connecting...
387 active session is now 'xconnection34'
388 connecting...
389 active session is now 'xconnection35'
390 connecting...
391 active session is now 'xconnection36'
392 connecting...
393 active session is now 'xconnection37'
394 connecting...
395 active session is now 'xconnection38'
396 connecting...
397 active session is now 'xconnection39'
398 connecting...
399 active session is now 'xconnection40'
400 connecting...
401 active session is now 'xconnection41'
402 connecting...
403 active session is now 'xconnection42'
404 connecting...
405 active session is now 'xconnection43'
406 connecting...
407 active session is now 'xconnection44'
408 connecting...
409 active session is now 'xconnection45'
410 connecting...
411 active session is now 'xconnection46'
412 connecting...
413 active session is now 'xconnection47'
414 connecting...
415 active session is now 'xconnection48'
416 connecting...
417 active session is now 'xconnection49'
418 connecting...
419 active session is now 'xconnection50'
420 client_id user host
421 60 xconnection50 localhost
422 command ok
423 switched to session default
424 list all connected clients
425 client_id user host
426 10 x_root localhost
427 11 xconnection1 localhost
428 12 xconnection2 localhost
429 13 xconnection3 localhost
430 14 xconnection4 localhost
431 15 xconnection5 localhost
432 16 xconnection6 localhost
433 17 xconnection7 localhost
434 18 xconnection8 localhost
435 19 xconnection9 localhost
436 20 xconnection10 localhost
437 21 xconnection11 localhost
438 22 xconnection12 localhost
439 23 xconnection13 localhost
440 24 xconnection14 localhost
441 25 xconnection15 localhost
442 26 xconnection16 localhost
443 27 xconnection17 localhost
444 28 xconnection18 localhost
445 29 xconnection19 localhost
446 30 xconnection20 localhost
447 31 xconnection21 localhost
448 32 xconnection22 localhost
449 33 xconnection23 localhost
450 34 xconnection24 localhost
451 35 xconnection25 localhost
452 36 xconnection26 localhost
453 37 xconnection27 localhost
454 38 xconnection28 localhost
455 39 xconnection29 localhost
456 40 xconnection30 localhost
457 41 xconnection31 localhost
458 42 xconnection32 localhost
459 43 xconnection33 localhost
460 44 xconnection34 localhost
461 45 xconnection35 localhost
462 46 xconnection36 localhost
463 47 xconnection37 localhost
464 48 xconnection38 localhost
465 49 xconnection39 localhost
466 50 xconnection40 localhost
467 51 xconnection41 localhost
468 52 xconnection42 localhost
469 53 xconnection43 localhost
470 54 xconnection44 localhost
471 55 xconnection45 localhost
472 56 xconnection46 localhost
473 57 xconnection47 localhost
474 58 xconnection48 localhost
475 59 xconnection49 localhost
476 60 xconnection50 localhost
477 command ok
478 expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=0
479 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
480 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2]
481 Verify [Global status variable "Mysqlx_sessions" needs to have a value of 51]
482 killing all newly connected clients except x_root,one by one
483 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
484 RUN [stmtadmin kill_client 11]
485
486 command ok
487 switched to session xconnection1
488 [ASSERT notice warning - ERROR, 3169]
489 Server disconnected
490 closing session xconnection1
491 switched to session default
492 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
493 RUN [stmtadmin kill_client 12]
494
495 command ok
496 switched to session xconnection2
497 [ASSERT notice warning - ERROR, 3169]
498 Server disconnected
499 closing session xconnection2
500 switched to session default
501 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
502 RUN [stmtadmin kill_client 13]
503
504 command ok
505 switched to session xconnection3
506 [ASSERT notice warning - ERROR, 3169]
507 Server disconnected
508 closing session xconnection3
509 switched to session default
510 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
511 RUN [stmtadmin kill_client 14]
512
513 command ok
514 switched to session xconnection4
515 [ASSERT notice warning - ERROR, 3169]
516 Server disconnected
517 closing session xconnection4
518 switched to session default
519 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
520 RUN [stmtadmin kill_client 15]
521
522 command ok
523 switched to session xconnection5
524 [ASSERT notice warning - ERROR, 3169]
525 Server disconnected
526 closing session xconnection5
527 switched to session default
528 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
529 RUN [stmtadmin kill_client 16]
530
531 command ok
532 switched to session xconnection6
533 [ASSERT notice warning - ERROR, 3169]
534 Server disconnected
535 closing session xconnection6
536 switched to session default
537 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
538 RUN [stmtadmin kill_client 17]
539
540 command ok
541 switched to session xconnection7
542 [ASSERT notice warning - ERROR, 3169]
543 Server disconnected
544 closing session xconnection7
545 switched to session default
546 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
547 RUN [stmtadmin kill_client 18]
548
549 command ok
550 switched to session xconnection8
551 [ASSERT notice warning - ERROR, 3169]
552 Server disconnected
553 closing session xconnection8
554 switched to session default
555 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
556 RUN [stmtadmin kill_client 19]
557
558 command ok
559 switched to session xconnection9
560 [ASSERT notice warning - ERROR, 3169]
561 Server disconnected
562 closing session xconnection9
563 switched to session default
564 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
565 RUN [stmtadmin kill_client 20]
566
567 command ok
568 switched to session xconnection10
569 [ASSERT notice warning - ERROR, 3169]
570 Server disconnected
571 closing session xconnection10
572 switched to session default
573 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
574 RUN [stmtadmin kill_client 21]
575
576 command ok
577 switched to session xconnection11
578 [ASSERT notice warning - ERROR, 3169]
579 Server disconnected
580 closing session xconnection11
581 switched to session default
582 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
583 RUN [stmtadmin kill_client 22]
584
585 command ok
586 switched to session xconnection12
587 [ASSERT notice warning - ERROR, 3169]
588 Server disconnected
589 closing session xconnection12
590 switched to session default
591 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
592 RUN [stmtadmin kill_client 23]
593
594 command ok
595 switched to session xconnection13
596 [ASSERT notice warning - ERROR, 3169]
597 Server disconnected
598 closing session xconnection13
599 switched to session default
600 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
601 RUN [stmtadmin kill_client 24]
602
603 command ok
604 switched to session xconnection14
605 [ASSERT notice warning - ERROR, 3169]
606 Server disconnected
607 closing session xconnection14
608 switched to session default
609 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
610 RUN [stmtadmin kill_client 25]
611
612 command ok
613 switched to session xconnection15
614 [ASSERT notice warning - ERROR, 3169]
615 Server disconnected
616 closing session xconnection15
617 switched to session default
618 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
619 RUN [stmtadmin kill_client 26]
620
621 command ok
622 switched to session xconnection16
623 [ASSERT notice warning - ERROR, 3169]
624 Server disconnected
625 closing session xconnection16
626 switched to session default
627 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
628 RUN [stmtadmin kill_client 27]
629
630 command ok
631 switched to session xconnection17
632 [ASSERT notice warning - ERROR, 3169]
633 Server disconnected
634 closing session xconnection17
635 switched to session default
636 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
637 RUN [stmtadmin kill_client 28]
638
639 command ok
640 switched to session xconnection18
641 [ASSERT notice warning - ERROR, 3169]
642 Server disconnected
643 closing session xconnection18
644 switched to session default
645 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
646 RUN [stmtadmin kill_client 29]
647
648 command ok
649 switched to session xconnection19
650 [ASSERT notice warning - ERROR, 3169]
651 Server disconnected
652 closing session xconnection19
653 switched to session default
654 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
655 RUN [stmtadmin kill_client 30]
656
657 command ok
658 switched to session xconnection20
659 [ASSERT notice warning - ERROR, 3169]
660 Server disconnected
661 closing session xconnection20
662 switched to session default
663 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
664 RUN [stmtadmin kill_client 31]
665
666 command ok
667 switched to session xconnection21
668 [ASSERT notice warning - ERROR, 3169]
669 Server disconnected
670 closing session xconnection21
671 switched to session default
672 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
673 RUN [stmtadmin kill_client 32]
674
675 command ok
676 switched to session xconnection22
677 [ASSERT notice warning - ERROR, 3169]
678 Server disconnected
679 closing session xconnection22
680 switched to session default
681 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
682 RUN [stmtadmin kill_client 33]
683
684 command ok
685 switched to session xconnection23
686 [ASSERT notice warning - ERROR, 3169]
687 Server disconnected
688 closing session xconnection23
689 switched to session default
690 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
691 RUN [stmtadmin kill_client 34]
692
693 command ok
694 switched to session xconnection24
695 [ASSERT notice warning - ERROR, 3169]
696 Server disconnected
697 closing session xconnection24
698 switched to session default
699 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
700 RUN [stmtadmin kill_client 35]
701
702 command ok
703 switched to session xconnection25
704 [ASSERT notice warning - ERROR, 3169]
705 Server disconnected
706 closing session xconnection25
707 switched to session default
708 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
709 RUN [stmtadmin kill_client 36]
710
711 command ok
712 switched to session xconnection26
713 [ASSERT notice warning - ERROR, 3169]
714 Server disconnected
715 closing session xconnection26
716 switched to session default
717 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
718 RUN [stmtadmin kill_client 37]
719
720 command ok
721 switched to session xconnection27
722 [ASSERT notice warning - ERROR, 3169]
723 Server disconnected
724 closing session xconnection27
725 switched to session default
726 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
727 RUN [stmtadmin kill_client 38]
728
729 command ok
730 switched to session xconnection28
731 [ASSERT notice warning - ERROR, 3169]
732 Server disconnected
733 closing session xconnection28
734 switched to session default
735 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
736 RUN [stmtadmin kill_client 39]
737
738 command ok
739 switched to session xconnection29
740 [ASSERT notice warning - ERROR, 3169]
741 Server disconnected
742 closing session xconnection29
743 switched to session default
744 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
745 RUN [stmtadmin kill_client 40]
746
747 command ok
748 switched to session xconnection30
749 [ASSERT notice warning - ERROR, 3169]
750 Server disconnected
751 closing session xconnection30
752 switched to session default
753 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
754 RUN [stmtadmin kill_client 41]
755
756 command ok
757 switched to session xconnection31
758 [ASSERT notice warning - ERROR, 3169]
759 Server disconnected
760 closing session xconnection31
761 switched to session default
762 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
763 RUN [stmtadmin kill_client 42]
764
765 command ok
766 switched to session xconnection32
767 [ASSERT notice warning - ERROR, 3169]
768 Server disconnected
769 closing session xconnection32
770 switched to session default
771 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
772 RUN [stmtadmin kill_client 43]
773
774 command ok
775 switched to session xconnection33
776 [ASSERT notice warning - ERROR, 3169]
777 Server disconnected
778 closing session xconnection33
779 switched to session default
780 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
781 RUN [stmtadmin kill_client 44]
782
783 command ok
784 switched to session xconnection34
785 [ASSERT notice warning - ERROR, 3169]
786 Server disconnected
787 closing session xconnection34
788 switched to session default
789 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
790 RUN [stmtadmin kill_client 45]
791
792 command ok
793 switched to session xconnection35
794 [ASSERT notice warning - ERROR, 3169]
795 Server disconnected
796 closing session xconnection35
797 switched to session default
798 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
799 RUN [stmtadmin kill_client 46]
800
801 command ok
802 switched to session xconnection36
803 [ASSERT notice warning - ERROR, 3169]
804 Server disconnected
805 closing session xconnection36
806 switched to session default
807 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
808 RUN [stmtadmin kill_client 47]
809
810 command ok
811 switched to session xconnection37
812 [ASSERT notice warning - ERROR, 3169]
813 Server disconnected
814 closing session xconnection37
815 switched to session default
816 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
817 RUN [stmtadmin kill_client 48]
818
819 command ok
820 switched to session xconnection38
821 [ASSERT notice warning - ERROR, 3169]
822 Server disconnected
823 closing session xconnection38
824 switched to session default
825 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
826 RUN [stmtadmin kill_client 49]
827
828 command ok
829 switched to session xconnection39
830 [ASSERT notice warning - ERROR, 3169]
831 Server disconnected
832 closing session xconnection39
833 switched to session default
834 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
835 RUN [stmtadmin kill_client 50]
836
837 command ok
838 switched to session xconnection40
839 [ASSERT notice warning - ERROR, 3169]
840 Server disconnected
841 closing session xconnection40
842 switched to session default
843 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
844 RUN [stmtadmin kill_client 51]
845
846 command ok
847 switched to session xconnection41
848 [ASSERT notice warning - ERROR, 3169]
849 Server disconnected
850 closing session xconnection41
851 switched to session default
852 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
853 RUN [stmtadmin kill_client 52]
854
855 command ok
856 switched to session xconnection42
857 [ASSERT notice warning - ERROR, 3169]
858 Server disconnected
859 closing session xconnection42
860 switched to session default
861 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
862 RUN [stmtadmin kill_client 53]
863
864 command ok
865 switched to session xconnection43
866 [ASSERT notice warning - ERROR, 3169]
867 Server disconnected
868 closing session xconnection43
869 switched to session default
870 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
871 RUN [stmtadmin kill_client 54]
872
873 command ok
874 switched to session xconnection44
875 [ASSERT notice warning - ERROR, 3169]
876 Server disconnected
877 closing session xconnection44
878 switched to session default
879 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
880 RUN [stmtadmin kill_client 55]
881
882 command ok
883 switched to session xconnection45
884 [ASSERT notice warning - ERROR, 3169]
885 Server disconnected
886 closing session xconnection45
887 switched to session default
888 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
889 RUN [stmtadmin kill_client 56]
890
891 command ok
892 switched to session xconnection46
893 [ASSERT notice warning - ERROR, 3169]
894 Server disconnected
895 closing session xconnection46
896 switched to session default
897 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
898 RUN [stmtadmin kill_client 57]
899
900 command ok
901 switched to session xconnection47
902 [ASSERT notice warning - ERROR, 3169]
903 Server disconnected
904 closing session xconnection47
905 switched to session default
906 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
907 RUN [stmtadmin kill_client 58]
908
909 command ok
910 switched to session xconnection48
911 [ASSERT notice warning - ERROR, 3169]
912 Server disconnected
913 closing session xconnection48
914 switched to session default
915 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
916 RUN [stmtadmin kill_client 59]
917
918 command ok
919 switched to session xconnection49
920 [ASSERT notice warning - ERROR, 3169]
921 Server disconnected
922 closing session xconnection49
923 switched to session default
924 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
925 RUN [stmtadmin kill_client 60]
926
927 command ok
928 switched to session xconnection50
929 [ASSERT notice warning - ERROR, 3169]
930 Server disconnected
931 closing session xconnection50
932 switched to session default
933 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
934 client_id user host
935 10 x_root localhost
936 command ok
937 expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=50
938 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 50]
939 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 3]
940 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
941 Verify [Status variable "Mysqlx_sessions_accepted" needs to have a value of 60]
942 Verify [Status variable "Mysqlx_sessions_closed" needs to have a value of 59]
943 Verify [Status variable "Mysqlx_sessions_fatal_error" needs to have a value of 0]
944 Verify [Status variable "Mysqlx_sessions_killed" needs to have a value of 54]
945 Verify [Status variable "Mysqlx_sessions_rejected" needs to have a value of 0]
946 RUN drop user xconnection1@localhost,
947 xconnection2@localhost,
948 xconnection3@localhost,
949 xconnection4@localhost,
950 xconnection5@localhost,
951 xconnection6@localhost,
952 xconnection7@localhost,
953 xconnection8@localhost,
954 xconnection9@localhost,
955 xconnection10@localhost,
956 xconnection11@localhost,
957 xconnection12@localhost,
958 xconnection13@localhost,
959 xconnection14@localhost,
960 xconnection15@localhost,
961 xconnection16@localhost,
962 xconnection17@localhost,
963 xconnection18@localhost,
964 xconnection19@localhost,
965 xconnection20@localhost,
966 xconnection21@localhost,
967 xconnection22@localhost,
968 xconnection23@localhost,
969 xconnection24@localhost,
970 xconnection25@localhost,
971 xconnection26@localhost,
972 xconnection27@localhost,
973 xconnection28@localhost,
974 xconnection29@localhost,
975 xconnection30@localhost,
976 xconnection31@localhost,
977 xconnection32@localhost,
978 xconnection33@localhost,
979 xconnection34@localhost,
980 xconnection35@localhost,
981 xconnection36@localhost,
982 xconnection37@localhost,
983 xconnection38@localhost,
984 xconnection39@localhost,
985 xconnection40@localhost,
986 xconnection41@localhost,
987 xconnection42@localhost,
988 xconnection43@localhost,
989 xconnection44@localhost,
990 xconnection45@localhost,
991 xconnection46@localhost,
992 xconnection47@localhost,
993 xconnection48@localhost,
994 xconnection49@localhost,
995 xconnection50@localhost
996
997 0 rows affected
998 Mysqlx.Ok {
999 msg: "bye!"
1000 }
1001 ok
1002 execute list_clients,kill_client with sql namespace,expect error
1003 change result file once error messages are fixed
1004 send Mysqlx.Sql.StmtExecute {
1005 stmt: "list_clients"
1006 namespace: "sql"
1007 }
1008
1009 expect Mysqlx.Sql.StmtExecuteOk
1010 Got expected error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'list_clients' at line 1 (code 1064)
1011 send Mysqlx.Sql.StmtExecute {
1012 stmt: "kill_client"
1013 args {
1014 type: SCALAR
1015 scalar {
1016 type: V_UINT
1017 v_unsigned_int: 11
1018 }
1019 }
1020 namespace: "sql"
1021 }
1022
1023 expect Mysqlx.Sql.StmtExecuteOk
1024 Got expected error: Too many arguments (code 5015)
1025 send Mysqlx.Sql.StmtExecute {
1026 stmt: "kill_client"
1027 args {
1028 type: SCALAR
1029 scalar {
1030 type: V_UINT
1031 v_unsigned_int: 11
1032 }
1033 }
1034 namespace: ""
1035 }
1036
1037 expect Mysqlx.Sql.StmtExecuteOk
1038 Got expected error: Unknown namespace (code 5162)
1039 send Mysqlx.Sql.StmtExecute {
1040 stmt: "kill_client"
1041 args {
1042 type: SCALAR
1043 scalar {
1044 type: V_UINT
1045 v_unsigned_int: 11
1046 }
1047 }
1048 namespace: "invalid"
1049 }
1050
1051 expect Mysqlx.Sql.StmtExecuteOk
1052 Got expected error: Unknown namespace invalid (code 5162)
1053 expect Mysqlx_stmt_list_clients=0 and Mysqlx_stmt_kill_client=0 as these are not executed on right namespace
1054 in main, line 62:ERROR: Undefined macro Assert_status_variable
1055 in main, line 63:ERROR: Undefined macro Assert_status_variable
1056 in main, line 64:ERROR: Undefined macro Assert_status_variable
1057 Mysqlx.Ok {
1058 msg: "bye!"
1059 }
1060 ok
1061 open xconnection with ssl and kill,expect success
1062 RUN create user con1@localhost identified by 'con1',
1063 con2@localhost identified by 'con2'
1064
1065 0 rows affected
1066 RUN set @@global.mysqlx_max_connections=3
1067
1068 0 rows affected
1069 Test data
1070 client_id user host
1071 62 sslcon localhost
1072 command ok
1073 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
1074 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
1075 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
1076 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
1077 create and activate new session con1
1078 connecting...
1079 active session is now 'con1'
1080 client_id user host
1081 63 con1 localhost
1082 command ok
1083 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
1084 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
1085 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
1086 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1087 open 3rd xprotocol connection where 2 sessions already opened
1088 connecting...
1089 active session is now 'con2'
1090 expect Mysqlx_stmt_list_clients=0 and Mysqlx_stmt_kill_client=0
1091 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
1092 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 0]
1093 Verify [Status variable "Mysqlx_sessions" needs to have a value of 3]
1094 switched to session default
1095 client_id user host
1096 62 sslcon localhost
1097 63 con1 localhost
1098 64 con2 localhost
1099 command ok
1100 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
1101 RUN [stmtadmin kill_client 63]
1102
1103 command ok
1104 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
1105 RUN [stmtadmin kill_client 64]
1106
1107 command ok
1108 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
1109 client_id user host
1110 62 sslcon localhost
1111 command ok
1112 expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=2
1113 RUN drop user con1@localhost,
1114 con2@localhost
1115
1116 0 rows affected
1117 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 2]
1118 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 3]
1119 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
1120 Mysqlx.Ok {
1121 msg: "bye!"
1122 }
1123 ok
1124 open xconnection with ssl x_root user kill,expect success
1125 RUN create user con1@localhost identified by 'con1',
1126 con2@localhost identified by 'con2'
1127
1128 0 rows affected
1129 RUN set @@global.mysqlx_max_connections=3
1130
1131 0 rows affected
1132 Test data
1133 client_id user host
1134 65 x_root localhost
1135 command ok
1136 create and activate new session con1
1137 connecting...
1138 active session is now 'con1 con1 con1'
1139 client_id user host
1140 65 x_root localhost
1141 66 x_root localhost
1142 command ok
1143 open 3rd xprotocol connection where 2 sessions already opened
1144 connecting...
1145 active session is now 'con2 con2 con2'
1146 switched to session default
1147 client_id user host
1148 65 x_root localhost
1149 66 x_root localhost
1150 67 x_root localhost
1151 command ok
1152 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
1153 RUN [stmtadmin kill_client 66]
1154
1155 command ok
1156 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
1157 RUN [stmtadmin kill_client 67]
1158
1159 command ok
1160 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
1161 client_id user host
1162 65 x_root localhost
1163 command ok
1164 RUN drop user con1@localhost,
1165 con2@localhost
1166
1167 0 rows affected
1168 Mysqlx.Ok {
1169 msg: "bye!"
1170 }
1171 ok
1172 show status like 'Mysqlx_stmt%client%';
1173 Variable_name Value
1174 Mysqlx_stmt_kill_client 68
1175 Mysqlx_stmt_list_clients 26
1176 # restart:
1177 drop user abc@localhost,
1178 xplugin@localhost,
1179 process@localhost,
1180 expire@localhost;
1181 set @@global.mysqlx_max_connections=100;
1182 show status like 'Mysqlx_stmt%client%';
1183 Variable_name Value
1184 Mysqlx_stmt_kill_client 0
1185 Mysqlx_stmt_list_clients 0
1186 select sleep(0.5);
1187 sleep(0.5)
1188 0
1189 RUN create user abc@localhost identified by 'abc',
1190 xplugin@localhost identified by 'xplugin',
1191 process@localhost identified by 'process',
1192 expire@localhost identified by 'expire'
1193
1194 0 rows affected
1195 RUN grant all on *.* to xplugin@localhost,
1196 expire@localhost
1197
1198 0 rows affected
1199 RUN grant process on *.* to process@localhost
1200
1201 0 rows affected
1202 RUN alter user expire@localhost password expire
1203
1204 0 rows affected
1205 Test data
1206 client_id user host
1207 1 x_root localhost
1208 command ok
1209 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0
1210 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
1211 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
1212 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
1213 create and activate new session
1214 connecting...
1215 active session is now 'aux'
1216 client_id user host
1217 1 x_root localhost
1218 2 x_root localhost
1219 command ok
1220 expect Mysqlx_stmt_list_clients=1 and Mysqlx_stmt_kill_client=0 even with another new x_root session
1221 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
1222 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
1223 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1224 switch back to default session
1225 switched to session default
1226 client_id user host
1227 1 x_root localhost
1228 2 x_root localhost
1229 command ok
1230 expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=0 with default x_root session where list_clients already executed
1231 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 0]
1232 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2]
1233 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1234 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
1235 RUN [stmtadmin kill_client 2]
1236
1237 command ok
1238 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
1239 client_id user host
1240 1 x_root localhost
1241 command ok
1242 expect Mysqlx_stmt_list_clients=3 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 3 times and kill_client once
1243 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
1244 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 3]
1245 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
1246 create and activate new session abc
1247 expect only abc user session id
1248 connecting...
1249 active session is now 'abc'
1250 client_id user host
1251 3 abc localhost
1252 command ok
1253 killing x_root user session with unprivileged user 'abc' which should be unsuccessful
1254 RUN [stmtadmin kill_client 1]
1255 Got expected error: You are not owner of thread (code 1095)
1256 expect ERROR: SELECT command denied to user 'abc'@'localhost' for table 'session_status' (code 1142) for show status command
1257 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
1258 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 1]
1259 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1260 open another session of abc user and kill first session of abc user,which should be successful
1261 connecting...
1262 active session is now 'abc1'
1263 client_id user host
1264 3 abc localhost
1265 4 abc localhost
1266 command ok
1267 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
1268 RUN [stmtadmin kill_client 3]
1269
1270 command ok
1271 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1272 client_id user host
1273 4 abc localhost
1274 command ok
1275 expect ERROR: SELECT command denied to user 'abc'@'localhost' for table 'session_status' (code 1142) for show status command
1276 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
1277 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2]
1278 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1279 killing abc user session with its own session 'abc' which should be successful
1280 expect right error instead of End of File
1281 switch back to default session
1282 Server disconnected
1283 closing session abc1
1284 switched to session default
1285 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
1286 client_id user host
1287 1 x_root localhost
1288 command ok
1289 expect Mysqlx_stmt_list_clients=4 and Mysqlx_stmt_kill_client=1 with default x_root session where list_clients executed 4 times and kill_client once
1290 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
1291 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 4]
1292 Verify [Status variable "Mysqlx_sessions" needs to have a value of 1]
1293 open process only privileged user seession and kill x_root user session,expect error "You are not owner of thread"
1294 connecting...
1295 active session is now 'process'
1296 client_id user host
1297 5 process localhost
1298 command ok
1299 RUN [stmtadmin kill_client 1]
1300 Got expected error: You are not owner of thread (code 1095)
1301 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1302 checking list of clients after x_root user session killed by xplugin user
1303 client_id user host
1304 5 process localhost
1305 command ok
1306 expect ERROR: SELECT command denied to user 'process'@'localhost' for table 'session_status' (code 1142) for show command
1307 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
1308 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2]
1309 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1310 open privileged user seession and kill x_root user session,expect success
1311 connecting...
1312 active session is now 'xplugin'
1313 client_id user host
1314 1 x_root localhost
1315 5 process localhost
1316 6 xplugin localhost
1317 command ok
1318 WAIT [count(*) information_schema.PROCESSLIST == 1 - only current process can be active]
1319 RUN [stmtadmin kill_client 1]
1320
1321 command ok
1322 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1323 checking list of clients after x_root user session killed by xplugin user
1324 client_id user host
1325 5 process localhost
1326 6 xplugin localhost
1327 command ok
1328 expect Mysqlx_stmt_list_clients=2 and Mysqlx_stmt_kill_client=1 with xplugin user where list_clients executed 2 times and kill_client once
1329 Verify [Status variable "Mysqlx_stmt_kill_client" needs to have a value of 1]
1330 Verify [Status variable "Mysqlx_stmt_list_clients" needs to have a value of 2]
1331 Verify [Status variable "Mysqlx_sessions" needs to have a value of 2]
1332 Cleanup
1333 RUN drop schema if exists xtest
1334
1335 0 rows affected
1336 closing session xplugin
1337 Mysqlx.Ok {
1338 msg: "bye!"
1339 }
1340 ok
1341 show status like 'Mysqlx_stmt%client%';
1342 Variable_name Value
1343 Mysqlx_stmt_kill_client 6
1344 Mysqlx_stmt_list_clients 12
1345 drop user abc@localhost,
1346 xplugin@localhost,
1347 process@localhost,
1348 expire@localhost,
1349 sslcon@localhost;