Debian Codegraph @

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

raw
1 ## I. Reproduce race condition between closing session and listing
2 # session (BUG#31490241):
3 # 1. Create X Protocol session(X1) using "x_root" account and hang it while closing
4 # (sync point: srv_session_close)
5 # 2. Create classic protocol session(C1) and list all session,
6 # hang it at "x_root" row generation while waking X1
7 # 3. Wait until the X1, is inside THD deregistration
8 # and wakeup C1
9 # 4. Show at C1, processlist results
10
11 # Adding debug point 'test_fill_proc_with_x_root' to @@GLOBAL.debug
12 SET DEBUG_SYNC= 'fill_proc_list_with_x_root SIGNAL listing_x_root WAIT_FOR continue_fill_proc';
13
14 #
15 # I.1 connect X1
16 RUN SET DEBUG_SYNC= 'srv_session_close WAIT_FOR listing_x_root'
17
18 0 rows affected
19 Mysqlx.Ok {
20 msg: "bye!"
21 }
22 ok
23
24 #
25 # I.2 Use C1 and list all sessions
26 SELECT user from information_schema.processlist order by user;
27
28 #
29 # I.3
30 SET DEBUG_SYNC= 'now SIGNAL continue_fill_proc';
31
32 #
33 # I.4
34 user
35 event_scheduler
36 root
37 root
38 x_root
39 Warnings:
40 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
41 # Removing debug point 'test_fill_proc_with_x_root' from @@GLOBAL.debug