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