| 1 |
# restart |
| 2 |
call mtr.add_suppression("Plugin mysqlx reported: '3.1: Unhandled message of type 12'"); |
| 3 |
call mtr.add_suppression("Plugin mysqlx reported: '4.1: Unhandled message of type 12'"); |
| 4 |
call mtr.add_suppression("Plugin mysqlx reported: '5.1: Unhandled message of type 12'"); |
| 5 |
RUN create user killsession@localhost identified by 'killsession' |
| 6 |
|
| 7 |
0 rows affected |
| 8 |
RUN select USER,COMMAND,STATE from information_schema.processlist order by ID desc |
| 9 |
USER COMMAND STATE |
| 10 |
x_root Query executing |
| 11 |
root Sleep |
| 12 |
event_scheduler Daemon Waiting on empty queue |
| 13 |
0 rows affected |
| 14 |
Mysqlx.Ok { |
| 15 |
msg: "bye!" |
| 16 |
} |
| 17 |
ok |
| 18 |
RUN select USER,COMMAND,STATE from information_schema.processlist order by ID desc |
| 19 |
USER COMMAND STATE |
| 20 |
killsession Query executing |
| 21 |
0 rows affected |
| 22 |
RUN kill $CONNECTION_ID |
| 23 |
While executing kill $CONNECTION_ID: |
| 24 |
Got expected error: You are not owner of thread $CONNECTION_ID (code 1095) |
| 25 |
RUN select USER,COMMAND,STATE from information_schema.processlist order by ID desc |
| 26 |
USER COMMAND STATE |
| 27 |
killsession Query executing |
| 28 |
0 rows affected |
| 29 |
Mysqlx.Ok { |
| 30 |
msg: "bye!" |
| 31 |
} |
| 32 |
ok |
| 33 |
# Syncing with status [ 'Mysqlx_sessions_closed' == 2 ] |
| 34 |
# Syncing with status [ 'Mysqlx_sessions' == 0 ] |
| 35 |
RUN select USER,COMMAND,STATE from information_schema.processlist order by ID desc |
| 36 |
USER COMMAND STATE |
| 37 |
x_root Query executing |
| 38 |
root Sleep |
| 39 |
event_scheduler Daemon Waiting on empty queue |
| 40 |
0 rows affected |
| 41 |
RUN kill 5126 |
| 42 |
While executing kill 5126: |
| 43 |
Got expected error: Unknown thread id: 5126 (code 1094) |
| 44 |
Mysqlx.Ok { |
| 45 |
msg: "bye!" |
| 46 |
} |
| 47 |
ok |
| 48 |
# Syncing with status [ 'Mysqlx_sessions_closed' == 3 ] |
| 49 |
# Syncing with status [ 'Mysqlx_sessions' == 0 ] |
| 50 |
RUN set @current := connection_id() |
| 51 |
|
| 52 |
0 rows affected |
| 53 |
RUN select USER,COMMAND,STATE from information_schema.processlist order by ID desc |
| 54 |
USER COMMAND STATE |
| 55 |
x_root Query executing |
| 56 |
x_root Sleep |
| 57 |
root Sleep |
| 58 |
event_scheduler Daemon Waiting on empty queue |
| 59 |
0 rows affected |
| 60 |
RUN kill CONNECTION_ID |
| 61 |
|
| 62 |
0 rows affected |
| 63 |
RUN kill @current |
| 64 |
While executing kill @current: |
| 65 |
Got expected error: Query execution was interrupted (code 1317) |
| 66 |
Application terminated with expected error: MySQL server has gone away (code 2006) |
| 67 |
ok |
| 68 |
# Syncing with status [ 'Mysqlx_sessions_fatal_error' == 1 ] |
| 69 |
# Syncing with status [ 'Mysqlx_sessions' == 0 ] |
| 70 |
select USER,COMMAND,STATE from information_schema.processlist order by ID desc; |
| 71 |
USER COMMAND STATE |
| 72 |
root Query executing |
| 73 |
event_scheduler Daemon Waiting on empty queue |
| 74 |
Warnings: |
| 75 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 76 |
RUN set @current := connection_id() |
| 77 |
|
| 78 |
0 rows affected |
| 79 |
RUN select USER,COMMAND,STATE from information_schema.processlist order by ID desc |
| 80 |
USER COMMAND STATE |
| 81 |
x_root Query executing |
| 82 |
root Sleep |
| 83 |
event_scheduler Daemon Waiting on empty queue |
| 84 |
0 rows affected |
| 85 |
RUN kill @current |
| 86 |
While executing kill @current: |
| 87 |
Got expected error: Query execution was interrupted (code 1317) |
| 88 |
Application terminated with expected error: MySQL server has gone away (code 2006) |
| 89 |
ok |
| 90 |
# Syncing with status [ 'Mysqlx_sessions_fatal_error' == 2 ] |
| 91 |
# Syncing with status [ 'Mysqlx_sessions' == 0 ] |
| 92 |
select USER,COMMAND,STATE from information_schema.processlist order by ID desc; |
| 93 |
USER COMMAND STATE |
| 94 |
root Query executing |
| 95 |
event_scheduler Daemon Waiting on empty queue |
| 96 |
Warnings: |
| 97 |
Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead |
| 98 |
show status like 'Mysqlx_sessions%'; |
| 99 |
Variable_name Value |
| 100 |
Mysqlx_sessions 0 |
| 101 |
Mysqlx_sessions_accepted 5 |
| 102 |
Mysqlx_sessions_closed 3 |
| 103 |
Mysqlx_sessions_fatal_error 2 |
| 104 |
Mysqlx_sessions_killed 0 |
| 105 |
Mysqlx_sessions_rejected 0 |
| 106 |
drop user killsession@localhost; |