Debian Codegraph @

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

raw
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;