Debian Codegraph @

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

raw
1 ## I. Validate that X Plugin sends kill notice on IDLE connections
2 #
3 # Connect multiple clients, make the IDLE, and trigger kill, validate the notice
4 #
5 ## II. Validate that X Plugin sends kill notice on connections that process a query
6 #
7 # 1. A connection is waiting for lock
8 # 2. A connection is sleeping "SELECT SLEEP(A);"
9 #
10 ## III. Validate that X Plugin not sends kill notice on not authorized connections
11 #
12
13 CREATE TABLE test.client(session_id VARCHAR(32), client_id INT);
14
15 #
16 # I
17
18 #
19 # Creating sessions
20 connecting...
21 active session is now 'session_0'
22
23 1 rows affected
24 connecting...
25 active session is now 'session_1'
26
27 1 rows affected
28 connecting...
29 active session is now 'session_2'
30
31 1 rows affected
32 connecting...
33 active session is now 'session_3'
34
35 1 rows affected
36 connecting...
37 active session is now 'session_4'
38
39 1 rows affected
40 connecting...
41 active session is now 'session_5'
42
43 1 rows affected
44 connecting...
45 active session is now 'session_6'
46
47 1 rows affected
48 connecting...
49 active session is now 'session_7'
50
51 1 rows affected
52 connecting...
53 active session is now 'session_8'
54
55 1 rows affected
56 connecting...
57 active session is now 'session_9'
58
59 1 rows affected
60
61 #
62 # Killing sessions
63 switched to session default
64 kill session_0
65
66 command ok
67 kill session_1
68
69 command ok
70 kill session_2
71
72 command ok
73 kill session_3
74
75 command ok
76 kill session_4
77
78 command ok
79 kill session_5
80
81 command ok
82 kill session_6
83
84 command ok
85 kill session_7
86
87 command ok
88 kill session_8
89
90 command ok
91 kill session_9
92
93 command ok
94
95 #
96 # Reciving close notices
97 switched to session session_0
98 [ASSERT notice warning - ERROR, 3169]
99 Server disconnected
100 closing session session_0
101 switched to session default
102 switched to session session_1
103 [ASSERT notice warning - ERROR, 3169]
104 Server disconnected
105 closing session session_1
106 switched to session default
107 switched to session session_2
108 [ASSERT notice warning - ERROR, 3169]
109 Server disconnected
110 closing session session_2
111 switched to session default
112 switched to session session_3
113 [ASSERT notice warning - ERROR, 3169]
114 Server disconnected
115 closing session session_3
116 switched to session default
117 switched to session session_4
118 [ASSERT notice warning - ERROR, 3169]
119 Server disconnected
120 closing session session_4
121 switched to session default
122 switched to session session_5
123 [ASSERT notice warning - ERROR, 3169]
124 Server disconnected
125 closing session session_5
126 switched to session default
127 switched to session session_6
128 [ASSERT notice warning - ERROR, 3169]
129 Server disconnected
130 closing session session_6
131 switched to session default
132 switched to session session_7
133 [ASSERT notice warning - ERROR, 3169]
134 Server disconnected
135 closing session session_7
136 switched to session default
137 switched to session session_8
138 [ASSERT notice warning - ERROR, 3169]
139 Server disconnected
140 closing session session_8
141 switched to session default
142 switched to session session_9
143 [ASSERT notice warning - ERROR, 3169]
144 Server disconnected
145 closing session session_9
146 switched to session default
147 Mysqlx.Ok {
148 msg: "bye!"
149 }
150 ok
151
152 #
153 # II
154 RUN CREATE TABLE test.some_table(some_column INT)
155
156 0 rows affected
157 RUN CREATE PROCEDURE test.loop_in_sp()
158 BEGIN
159 REPEAT
160 SET @A=1;
161 UNTIL FALSE END REPEAT;
162 END
163
164
165 0 rows affected
166
167 #
168 # Creating sessions
169 connecting...
170 active session is now 'session_WRITE_LOCK'
171 RUN LOCK TABLE test.some_table WRITE
172
173 0 rows affected
174 connecting...
175 active session is now 'session_READ_LOCK'
176 RUN SELECT * FROM test.some_table
177 connecting...
178 active session is now 'session_SLEEP'
179 RUN SELECT SLEEP(10000)
180 connecting...
181 active session is now 'session_SP'
182 RUN CALL test.loop_in_sp()
183 switched to session default
184
185 #
186 # Killing sessions
187 switched to session default
188
189 command ok
190
191 command ok
192
193 command ok
194
195 command ok
196
197 #
198 # Reciving close notices
199 switched to session session_WRITE_LOCK
200 [ASSERT notice warning - ERROR, 3169]
201 Server disconnected
202 closing session session_WRITE_LOCK
203 switched to session default
204 switched to session session_READ_LOCK
205 Mysqlx.Error(code) = 1317
206 Server disconnected
207 closing session session_READ_LOCK
208 switched to session default
209 switched to session session_SLEEP
210 SLEEP(10000)
211 1
212 0 rows affected
213 [ASSERT notice warning - ERROR, 3169]
214 Server disconnected
215 closing session session_SLEEP
216 switched to session default
217 switched to session session_SP
218 Mysqlx.Error(code) = 1317
219 Server disconnected
220 closing session session_SP
221 switched to session default
222 Mysqlx.Ok {
223 msg: "bye!"
224 }
225 ok
226
227 #
228 # III
229
230 #
231 # Creating sessions
232 connecting...
233 active session is now 'session_noauth_0'
234 Mysqlx.Notice.Frame(type) = 5
235 switched to session default
236
237 1 rows affected
238 connecting...
239 active session is now 'session_noauth_1'
240 Mysqlx.Notice.Frame(type) = 5
241 switched to session default
242
243 1 rows affected
244 connecting...
245 active session is now 'session_noauth_2'
246 Mysqlx.Notice.Frame(type) = 5
247 switched to session default
248
249 1 rows affected
250 connecting...
251 active session is now 'session_noauth_3'
252 Mysqlx.Notice.Frame(type) = 5
253 switched to session default
254
255 1 rows affected
256 connecting...
257 active session is now 'session_noauth_4'
258 Mysqlx.Notice.Frame(type) = 5
259 switched to session default
260
261 1 rows affected
262 connecting...
263 active session is now 'session_noauth_5'
264 Mysqlx.Notice.Frame(type) = 5
265 switched to session default
266
267 1 rows affected
268 connecting...
269 active session is now 'session_noauth_6'
270 Mysqlx.Notice.Frame(type) = 5
271 switched to session default
272
273 1 rows affected
274 connecting...
275 active session is now 'session_noauth_7'
276 Mysqlx.Notice.Frame(type) = 5
277 switched to session default
278
279 1 rows affected
280 connecting...
281 active session is now 'session_noauth_8'
282 Mysqlx.Notice.Frame(type) = 5
283 switched to session default
284
285 1 rows affected
286 connecting...
287 active session is now 'session_noauth_9'
288 Mysqlx.Notice.Frame(type) = 5
289 switched to session default
290
291 1 rows affected
292
293 #
294 # Killing sessions
295 switched to session default
296 kill session_noauth_0
297
298 command ok
299 kill session_noauth_1
300
301 command ok
302 kill session_noauth_2
303
304 command ok
305 kill session_noauth_3
306
307 command ok
308 kill session_noauth_4
309
310 command ok
311 kill session_noauth_5
312
313 command ok
314 kill session_noauth_6
315
316 command ok
317 kill session_noauth_7
318
319 command ok
320 kill session_noauth_8
321
322 command ok
323 kill session_noauth_9
324
325 command ok
326
327 #
328 # Closing connection
329 switched to session session_noauth_0
330 # `recvunitldisc` command must report disconnection without any other messages
331 Server disconnected
332 closing session session_noauth_0
333 switched to session default
334 switched to session session_noauth_1
335 # `recvunitldisc` command must report disconnection without any other messages
336 Server disconnected
337 closing session session_noauth_1
338 switched to session default
339 switched to session session_noauth_2
340 # `recvunitldisc` command must report disconnection without any other messages
341 Server disconnected
342 closing session session_noauth_2
343 switched to session default
344 switched to session session_noauth_3
345 # `recvunitldisc` command must report disconnection without any other messages
346 Server disconnected
347 closing session session_noauth_3
348 switched to session default
349 switched to session session_noauth_4
350 # `recvunitldisc` command must report disconnection without any other messages
351 Server disconnected
352 closing session session_noauth_4
353 switched to session default
354 switched to session session_noauth_5
355 # `recvunitldisc` command must report disconnection without any other messages
356 Server disconnected
357 closing session session_noauth_5
358 switched to session default
359 switched to session session_noauth_6
360 # `recvunitldisc` command must report disconnection without any other messages
361 Server disconnected
362 closing session session_noauth_6
363 switched to session default
364 switched to session session_noauth_7
365 # `recvunitldisc` command must report disconnection without any other messages
366 Server disconnected
367 closing session session_noauth_7
368 switched to session default
369 switched to session session_noauth_8
370 # `recvunitldisc` command must report disconnection without any other messages
371 Server disconnected
372 closing session session_noauth_8
373 switched to session default
374 switched to session session_noauth_9
375 # `recvunitldisc` command must report disconnection without any other messages
376 Server disconnected
377 closing session session_noauth_9
378 switched to session default
379 Mysqlx.Ok {
380 msg: "bye!"
381 }
382 ok
383 DROP TABLE test.client;
384 DROP TABLE test.some_table;
385 DROP PROCEDURE test.loop_in_sp;