Debian Codegraph @

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

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