Debian Codegraph @

mysql-test/suite/auth_sec/include/acl_tables_locking_tests_big_debug_2.inc

raw
1 #
2 # Validate that FLUSH PRIVILEGES blocks concurrent ACL DDL
3 # for given isolation level
4 #
5 # Usage:
6 # --let $ISOLATION_LEVEL=<isolation level>
7 # --source ../include/acl_tables_locking_tests_big_debug_2.inc
8
9 --echo # -----------------------------------------------------------------------
10 --echo # Setup
11 --echo # Saving initial values
12 SET @global_start_value = @@global.transaction_isolation;
13 SELECT @global_start_value;
14 SET @session_start_value = @@session.transaction_isolation;
15 SELECT @session_start_value;
16
17 --echo # Setting transaction isolation to '$ISOLATION_LEVEL'
18 --eval SET GLOBAL transaction_isolation = '$ISOLATION_LEVEL'
19
20 --echo # -----------------------------------------------------------------------
21 --echo # Case 1: FLUSH PRIVILEGES + ACL DDLs
22
23 --echo # -------------------------------
24 --echo # Case 1.1: FLUSH PRIVILEGES + CREATE USER
25
26 --let $ATTEMPT_SQL=CREATE USER u1, u2
27 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
28 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
29 --let $EXECUTE_SQL=FLUSH PRIVILEGES
30 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
31 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
32 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
33 --let $EXECUTE_EXPECT_ERROR=0
34 --source acl_tables_locking_tests_big_debug_helper.inc
35
36 --echo # -------------------------------
37 --echo # Case 1.2: FLUSH PRIVILEGES + ALTER USER
38
39 --let $ATTEMPT_SQL=ALTER USER u1 IDENTIFIED BY 'abcd'
40 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
41 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
42 --let $EXECUTE_SQL=FLUSH PRIVILEGES
43 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
44 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
45 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
46 --let $EXECUTE_EXPECT_ERROR=0
47 --source acl_tables_locking_tests_big_debug_helper.inc
48
49 --echo # -------------------------------
50 --echo # Case 1.3: FLUSH PRIVILEGES + DROP USER
51
52 --let $ATTEMPT_SQL=DROP USER u1
53 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
54 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
55 --let $EXECUTE_SQL=FLUSH PRIVILEGES
56 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
57 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
58 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
59 --let $EXECUTE_EXPECT_ERROR=0
60 --source acl_tables_locking_tests_big_debug_helper.inc
61
62 --echo # -------------------------------
63 --echo # Case 1.4: FLUSH PRIVILEGES + RENAME USER
64
65 --let $ATTEMPT_SQL=RENAME USER u1 TO u2
66 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
67 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
68 --let $EXECUTE_SQL=FLUSH PRIVILEGES
69 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
70 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
71 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
72 --let $EXECUTE_EXPECT_ERROR=0
73 --source acl_tables_locking_tests_big_debug_helper.inc
74
75 --echo # -------------------------------
76 --echo # Case 1.5: FLUSH PRIVILEGES + CREATE ROLE
77
78 --let $ATTEMPT_SQL=CREATE ROLE r1
79 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
80 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
81 --let $EXECUTE_SQL=FLUSH PRIVILEGES
82 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
83 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
84 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
85 --let $EXECUTE_EXPECT_ERROR=0
86 --source acl_tables_locking_tests_big_debug_helper.inc
87
88 --echo # -------------------------------
89 --echo # Case 1.6: FLUSH PRIVILEGES + DROP ROLE
90
91 --let $ATTEMPT_SQL=DROP ROLE r1
92 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
93 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
94 --let $EXECUTE_SQL=FLUSH PRIVILEGES
95 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
96 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
97 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
98 --let $EXECUTE_EXPECT_ERROR=0
99 --source acl_tables_locking_tests_big_debug_helper.inc
100
101 --echo # -------------------------------
102 --echo # Case 1.7: FLUSH PRIVILEGES + GRANT privilege
103
104 --let $ATTEMPT_SQL=GRANT SELECT ON *.* TO u1
105 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
106 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
107 --let $EXECUTE_SQL=FLUSH PRIVILEGES
108 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
109 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
110 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
111 --let $EXECUTE_EXPECT_ERROR=0
112 --source acl_tables_locking_tests_big_debug_helper.inc
113
114 --echo # -------------------------------
115 --echo # Case 1.8: FLUSH PRIVILEGES + REVOKE privilege
116
117 --let $ATTEMPT_SQL=REVOKE SELECT ON *.* FROM u1
118 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
119 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
120 --let $EXECUTE_SQL=FLUSH PRIVILEGES
121 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
122 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
123 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
124 --let $EXECUTE_EXPECT_ERROR=0
125 --source acl_tables_locking_tests_big_debug_helper.inc
126
127 --echo # -------------------------------
128 --echo # Case 1.9: FLUSH PRIVILEGES + GRANT role
129
130 --let $ATTEMPT_SQL=GRANT r1 TO u1
131 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
132 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
133 --let $EXECUTE_SQL=FLUSH PRIVILEGES
134 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
135 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
136 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
137 --let $EXECUTE_EXPECT_ERROR=0
138 --source acl_tables_locking_tests_big_debug_helper.inc
139
140 --echo # -------------------------------
141 --echo # Case 1.10: FLUSH PRIVILEGES + REVOKE role
142
143 --let $ATTEMPT_SQL=REVOKE r1 FROM u1
144 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
145 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
146 --let $EXECUTE_SQL=FLUSH PRIVILEGES
147 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
148 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
149 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
150 --let $EXECUTE_EXPECT_ERROR=0
151 --source acl_tables_locking_tests_big_debug_helper.inc
152
153 --echo # -------------------------------
154 --echo # Case 1.11: FLUSH PRIVILEGES + SET PASSWORD
155
156 --let $ATTEMPT_SQL=SET PASSWORD FOR u1 = 'abcd'
157 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
158 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
159 --let $EXECUTE_SQL=FLUSH PRIVILEGES
160 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
161 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
162 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
163 --let $EXECUTE_EXPECT_ERROR=0
164 --source acl_tables_locking_tests_big_debug_helper.inc
165
166 --echo # -------------------------------
167 --echo # Case 1.12: FLUSH PRIVILEGES + SET DEFAULT ROLE
168
169 --let $ATTEMPT_SQL=SET DEFAULT ROLE r1 to u1
170 --let $ATTEMPT_DEBUG_SYNC=wl14084_acl_ddl_before_mdl_acquisition SIGNAL flush_now WAIT_FOR proceed_with_acl_ddl
171 --let $ATTEMPT_EXPECTED_ERROR_NUM=ER_LOCK_WAIT_TIMEOUT
172 --let $EXECUTE_SQL=FLUSH PRIVILEGES
173 --let $EXECUTE_DEBUG=wl14084_trigger_acl_ddl_timeout
174 --let $EXECUTE_DEBUG_SYNC_1=now WAIT_FOR flush_now
175 --let $EXECUTE_DEBUG_SYNC_2=wl14084_flush_privileges_after_table_locks SIGNAL proceed_with_acl_ddl
176 --let $EXECUTE_EXPECT_ERROR=0
177 --source acl_tables_locking_tests_big_debug_helper.inc
178
179 --echo # -----------------------------------------------------------------------
180 --echo # Cleanup
181 --echo # Restore initial values
182
183 --connection default
184 SET @@global.transaction_isolation = @global_start_value;
185 SELECT @@global.transaction_isolation;
186 SET @@session.transaction_isolation = @session_start_value;
187 SELECT @@session.transaction_isolation;