| 1 |
## I. Reproduce race condition between authenticating session and listing |
| 2 |
# session: |
| 3 |
# 1. Create X Protocol session(X1) using "x_root" account and hang it while |
| 4 |
# authenticating (sync point: syncpoint_xpl_switch_to_user_execute, syncpoint_xpl_switch_to_user_enter) |
| 5 |
# 2. Create classic protocol session(C1) and list all session, |
| 6 |
# hang it at "x_root" row generation |
| 7 |
# 3. Ensure that X1, changes session user, after that wakeup C1 |
| 8 |
# 4. Show at C1, processlist results |
| 9 |
|
| 10 |
|
| 11 |
# |
| 12 |
# I.1 |
| 13 |
# Adding debug point 'syncpoint_xpl_switch_to_user_enter' to @@GLOBAL.debug |
| 14 |
# Adding debug point 'syncpoint_xpl_switch_to_user_execute' to @@GLOBAL.debug |
| 15 |
# Adding debug point 'test_fill_proc_with_x_root' to @@GLOBAL.debug |
| 16 |
SET SESSION DEBUG_SYNC="now WAIT_FOR reached_xpl_switch_to_user_enter"; |
| 17 |
SET SESSION DEBUG_SYNC="now SIGNAL continue_xpl_switch_to_user_enter"; |
| 18 |
SET SESSION DEBUG_SYNC="now WAIT_FOR reached_xpl_switch_to_user_execute"; |
| 19 |
SET SESSION DEBUG_SYNC="now SIGNAL continue_xpl_switch_to_user_execute"; |
| 20 |
|
| 21 |
# |
| 22 |
# I.2 |
| 23 |
SET SESSION DEBUG_SYNC="now WAIT_FOR reached_xpl_switch_to_user_enter"; |
| 24 |
SET SESSION DEBUG_SYNC="fill_proc_list_ended SIGNAL reached_sql_show"; |
| 25 |
SET SESSION DEBUG_SYNC="fill_proc_list_with_x_root SIGNAL reached_sql_show WAIT_FOR continue_sql_show"; |
| 26 |
SELECT IF(count(user),"Grater than zero", "None") as NoClients from information_schema.processlist order by user; |
| 27 |
|
| 28 |
# |
| 29 |
# I.3 |
| 30 |
SET SESSION DEBUG_SYNC="now WAIT_FOR reached_sql_show"; |
| 31 |
SET SESSION DEBUG_SYNC="now SIGNAL continue_xpl_switch_to_user_enter"; |
| 32 |
SET SESSION DEBUG_SYNC="now WAIT_FOR reached_xpl_switch_to_user_execute"; |
| 33 |
SET SESSION DEBUG_SYNC="now SIGNAL continue_sql_show"; |
| 34 |
|
| 35 |
# |
| 36 |
# I.4 |
| 37 |
NoClients |
| 38 |
Grater than zero |
| 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 'syncpoint_xpl_switch_to_user_enter' from @@GLOBAL.debug |
| 42 |
# Removing debug point 'syncpoint_xpl_switch_to_user_execute' from @@GLOBAL.debug |
| 43 |
# Removing debug point 'test_fill_proc_with_x_root' from @@GLOBAL.debug |
| 44 |
SET SESSION DEBUG_SYNC="now SIGNAL continue_xpl_switch_to_user_execute"; |
| 45 |
SET SESSION DEBUG_SYNC="RESET"; |