1
SET DEBUG_SYNC= 'RESET';
2
DROP TABLE IF EXISTS t1;
3
SHOW VARIABLES LIKE 'DEBUG_SYNC';
5
debug_sync ON - current signal: ''
6
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 TIMEOUT 6 EXECUTE 2 HIT_LIMIT 3';
7
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 TIMEOUT 6 EXECUTE 2';
8
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 TIMEOUT 6 HIT_LIMIT 3';
9
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 TIMEOUT 6';
10
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 EXECUTE 2 HIT_LIMIT 3';
11
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 EXECUTE 2';
12
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 HIT_LIMIT 3';
13
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2';
14
SET DEBUG_SYNC='p0 SIGNAL s1 EXECUTE 2 HIT_LIMIT 3';
15
SET DEBUG_SYNC='p0 SIGNAL s1 EXECUTE 2';
16
SET DEBUG_SYNC='p0 SIGNAL s1 HIT_LIMIT 3';
17
SET DEBUG_SYNC='p0 SIGNAL s1';
18
SET DEBUG_SYNC='p0 WAIT_FOR s2 TIMEOUT 6 EXECUTE 2 HIT_LIMIT 3';
19
SET DEBUG_SYNC='p0 WAIT_FOR s2 TIMEOUT 6 EXECUTE 2';
20
SET DEBUG_SYNC='p0 WAIT_FOR s2 TIMEOUT 6 HIT_LIMIT 3';
21
SET DEBUG_SYNC='p0 WAIT_FOR s2 TIMEOUT 6';
22
SET DEBUG_SYNC='p0 WAIT_FOR s2 EXECUTE 2 HIT_LIMIT 3';
23
SET DEBUG_SYNC='p0 WAIT_FOR s2 EXECUTE 2';
24
SET DEBUG_SYNC='p0 WAIT_FOR s2 HIT_LIMIT 3';
25
SET DEBUG_SYNC='p0 WAIT_FOR s2';
26
SET DEBUG_SYNC='p0 HIT_LIMIT 3';
27
SET DEBUG_SYNC='p0 CLEAR';
28
SET DEBUG_SYNC='p0 TEST';
29
SET DEBUG_SYNC='RESET';
30
set debug_sync='p0 signal s1 wait_for s2 timeout 6 execute 2 hit_limit 3';
31
set debug_sync='p0 signal s1 wait_for s2 timeout 6 execute 2';
32
set debug_sync='p0 signal s1 wait_for s2 timeout 6 hit_limit 3';
33
set debug_sync='p0 signal s1 wait_for s2 timeout 6';
34
set debug_sync='p0 signal s1 wait_for s2 execute 2 hit_limit 3';
35
set debug_sync='p0 signal s1 wait_for s2 execute 2';
36
set debug_sync='p0 signal s1 wait_for s2 hit_limit 3';
37
set debug_sync='p0 signal s1 wait_for s2';
38
set debug_sync='p0 signal s1 execute 2 hit_limit 3';
39
set debug_sync='p0 signal s1 execute 2';
40
set debug_sync='p0 signal s1 hit_limit 3';
41
set debug_sync='p0 signal s1';
42
set debug_sync='p0 wait_for s2 timeout 6 execute 2 hit_limit 3';
43
set debug_sync='p0 wait_for s2 timeout 6 execute 2';
44
set debug_sync='p0 wait_for s2 timeout 6 hit_limit 3';
45
set debug_sync='p0 wait_for s2 timeout 6';
46
set debug_sync='p0 wait_for s2 execute 2 hit_limit 3';
47
set debug_sync='p0 wait_for s2 execute 2';
48
set debug_sync='p0 wait_for s2 hit_limit 3';
49
set debug_sync='p0 wait_for s2';
50
set debug_sync='p0 hit_limit 3';
51
set debug_sync='p0 clear';
52
set debug_sync='p0 test';
53
set debug_sync='reset';
54
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 TIMEOUT 6
55
EXECUTE 2 HIT_LIMIT 3';
57
ERROR 42000: Missing action after synchronization point name 'p0'
58
SET DEBUG_SYNC='p0 EXECUTE 2';
59
ERROR 42000: Missing action before EXECUTE
60
SET DEBUG_SYNC='p0 TIMEOUT 6 EXECUTE 2';
61
ERROR 42000: Illegal or out of order stuff: 'TIMEOUT'
62
SET DEBUG_SYNC='p0 TIMEOUT 6';
63
ERROR 42000: Illegal or out of order stuff: 'TIMEOUT'
64
SET DEBUG_SYNC='p0 WAIT_FOR s2 SIGNAL s1';
65
ERROR 42000: Illegal or out of order stuff: 'SIGNAL'
66
SET DEBUG_SYNC='p0 WAIT_FOR s2 SIGNAL s1 EXECUTE 2';
67
ERROR 42000: Illegal or out of order stuff: 'SIGNAL'
68
SET DEBUG_SYNC='p0 WAIT_FOR s2 SIGNAL s1 TIMEOUT 6 EXECUTE 2';
69
ERROR 42000: Illegal or out of order stuff: 'SIGNAL'
70
SET DEBUG_SYNC='p0 WAIT_FOR s2 SIGNAL s1 TIMEOUT 6';
71
ERROR 42000: Illegal or out of order stuff: 'SIGNAL'
72
SET DEBUG_SYNC='p0 WAIT_FOR s2 TIMEOUT 6 SIGNAL s1 EXECUTE 2';
73
ERROR 42000: Illegal or out of order stuff: 'SIGNAL'
74
SET DEBUG_SYNC='p0 WAIT_FOR s2 TIMEOUT 6 SIGNAL s1';
75
ERROR 42000: Illegal or out of order stuff: 'SIGNAL'
76
SET DEBUG_SYNC='p0 TIMEOUT 6 WAIT_FOR s2 EXECUTE 2';
77
ERROR 42000: Illegal or out of order stuff: 'TIMEOUT'
78
SET DEBUG_SYNC='p0 TIMEOUT 6 WAIT_FOR s2';
79
ERROR 42000: Illegal or out of order stuff: 'TIMEOUT'
80
SET DEBUG_SYNC='p0 SIGNAL s1 TIMEOUT 6 EXECUTE 2';
81
ERROR 42000: Illegal or out of order stuff: 'TIMEOUT'
82
SET DEBUG_SYNC='p0 SIGNAL s1 TIMEOUT 6';
83
ERROR 42000: Illegal or out of order stuff: 'TIMEOUT'
84
SET DEBUG_SYNC='p0 EXECUTE 2 SIGNAL s1 TIMEOUT 6';
85
ERROR 42000: Missing action before EXECUTE
86
SET DEBUG_SYNC='p0 TIMEOUT 6 SIGNAL s1';
87
ERROR 42000: Illegal or out of order stuff: 'TIMEOUT'
88
SET DEBUG_SYNC='p0 EXECUTE 2 TIMEOUT 6 SIGNAL s1';
89
ERROR 42000: Missing action before EXECUTE
90
SET DEBUG_SYNC='p0 CLEAR HIT_LIMIT 3';
91
ERROR 42000: Nothing must follow action CLEAR
92
SET DEBUG_SYNC='CLEAR';
93
ERROR 42000: Missing action after synchronization point name 'CLEAR'
94
SET DEBUG_SYNC='p0 CLEAR p0';
95
ERROR 42000: Nothing must follow action CLEAR
96
SET DEBUG_SYNC='TEST';
97
ERROR 42000: Missing action after synchronization point name 'TEST'
98
SET DEBUG_SYNC='p0 TEST p0';
99
ERROR 42000: Nothing must follow action TEST
100
SET DEBUG_SYNC='p0 RESET';
101
ERROR 42000: Illegal or out of order stuff: 'RESET'
102
SET DEBUG_SYNC='RESET p0';
103
ERROR 42000: Illegal or out of order stuff: 'p0'
104
SET DEBUG_SYNC='p0 RESET p0';
105
ERROR 42000: Illegal or out of order stuff: 'RESET'
106
SET DEBUG_SYNCx='p0 SIGNAL s1 WAIT_FOR s2 TIMEOUT 6 EXECUTE 2 HIT_LIMIT 3';
107
ERROR HY000: Unknown system variable 'DEBUG_SYNCx'
108
SET DEBUG_SYNC='p0 SIGNAx s1 WAIT_FOR s2 TIMEOUT 6 EXECUTE 2 HIT_LIMIT 3';
109
ERROR 42000: Illegal or out of order stuff: 'SIGNAx'
110
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOx s2 TIMEOUT 6 EXECUTE 2 HIT_LIMIT 3';
111
ERROR 42000: Illegal or out of order stuff: 'WAIT_FOx'
112
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 TIMEOUx 0 EXECUTE 2 HIT_LIMIT 3';
113
ERROR 42000: Illegal or out of order stuff: 'TIMEOUx'
114
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 TIMEOUT 6 EXECUTx 2 HIT_LIMIT 3';
115
ERROR 42000: Illegal or out of order stuff: 'EXECUTx'
116
SET DEBUG_SYNC='p0 SIGNAL s1 WAIT_FOR s2 TIMEOUT 6 EXECUTE 2 HIT_LIMIx 3';
117
ERROR 42000: Illegal or out of order stuff: 'HIT_LIMIx'
118
SET DEBUG_SYNC='p0 CLEARx';
119
ERROR 42000: Illegal or out of order stuff: 'CLEARx'
120
SET DEBUG_SYNC='p0 TESTx';
121
ERROR 42000: Illegal or out of order stuff: 'TESTx'
122
SET DEBUG_SYNC='RESETx';
123
ERROR 42000: Missing action after synchronization point name 'RESETx'
124
SET DEBUG_SYNC='p0 WAIT_FOR s2 TIMEOUT 0x6 EXECUTE 2 HIT_LIMIT 3';
125
ERROR 42000: Missing valid number after TIMEOUT
126
SET DEBUG_SYNC='p0 WAIT_FOR s2 TIMEOUT 6 EXECUTE 0x2 HIT_LIMIT 3';
127
ERROR 42000: Missing valid number after EXECUTE
128
SET DEBUG_SYNC='p0 WAIT_FOR s2 TIMEOUT 7 EXECUTE 2 HIT_LIMIT 0x3';
129
ERROR 42000: Missing valid number after HIT_LIMIT
131
ERROR 42000: Incorrect argument type to variable 'debug_sync'
132
SET GLOBAL DEBUG_SYNC= 'p0 CLEAR';
133
ERROR HY000: Variable 'debug_sync' is a SESSION variable and can't be used with SET GLOBAL
134
SET DEBUG_SYNC= 'now SIGNAL something';
135
SHOW VARIABLES LIKE 'DEBUG_SYNC';
137
debug_sync ON - current signal: 'something'
138
SET DEBUG_SYNC= 'now WAIT_FOR nothing TIMEOUT 0';
140
Warning 1720 debug sync point wait timed out
141
SET DEBUG_SYNC= 'now SIGNAL nothing';
142
SHOW VARIABLES LIKE 'DEBUG_SYNC';
144
debug_sync ON - current signal: 'nothing'
145
SET DEBUG_SYNC= 'now WAIT_FOR nothing TIMEOUT 0';
146
SET DEBUG_SYNC= 'now SIGNAL something EXECUTE 0';
147
SHOW VARIABLES LIKE 'DEBUG_SYNC';
149
debug_sync ON - current signal: 'nothing'
150
SET DEBUG_SYNC= 'now WAIT_FOR anotherthing TIMEOUT 0 EXECUTE 0';
151
SET DEBUG_SYNC= 'now HIT_LIMIT 1';
152
ERROR HY000: debug sync point hit limit reached
153
SET DEBUG_SYNC= 'RESET';
154
SHOW VARIABLES LIKE 'DEBUG_SYNC';
156
debug_sync ON - current signal: ''
157
SET DEBUG_SYNC= 'p1abcd SIGNAL s1 EXECUTE 2';
158
SET DEBUG_SYNC= 'p2abc SIGNAL s2 EXECUTE 2';
159
SET DEBUG_SYNC= 'p9abcdef SIGNAL s9 EXECUTE 2';
160
SET DEBUG_SYNC= 'p4a SIGNAL s4 EXECUTE 2';
161
SET DEBUG_SYNC= 'p5abcde SIGNAL s5 EXECUTE 2';
162
SET DEBUG_SYNC= 'p6ab SIGNAL s6 EXECUTE 2';
163
SET DEBUG_SYNC= 'p7 SIGNAL s7 EXECUTE 2';
164
SET DEBUG_SYNC= 'p8abcdef SIGNAL s8 EXECUTE 2';
165
SET DEBUG_SYNC= 'p3abcdef SIGNAL s3 EXECUTE 2';
166
SET DEBUG_SYNC= 'p4a TEST';
167
SHOW VARIABLES LIKE 'DEBUG_SYNC';
169
debug_sync ON - current signal: 's4'
170
SET DEBUG_SYNC= 'p1abcd TEST';
171
SHOW VARIABLES LIKE 'DEBUG_SYNC';
173
debug_sync ON - current signal: 's1'
174
SET DEBUG_SYNC= 'p7 TEST';
175
SHOW VARIABLES LIKE 'DEBUG_SYNC';
177
debug_sync ON - current signal: 's7'
178
SET DEBUG_SYNC= 'p9abcdef TEST';
179
SHOW VARIABLES LIKE 'DEBUG_SYNC';
181
debug_sync ON - current signal: 's9'
182
SET DEBUG_SYNC= 'p3abcdef TEST';
183
SHOW VARIABLES LIKE 'DEBUG_SYNC';
185
debug_sync ON - current signal: 's3'
186
SET DEBUG_SYNC= 'p1abcd CLEAR';
187
SET DEBUG_SYNC= 'p2abc CLEAR';
188
SET DEBUG_SYNC= 'p5abcde CLEAR';
189
SET DEBUG_SYNC= 'p6ab CLEAR';
190
SET DEBUG_SYNC= 'p8abcdef CLEAR';
191
SET DEBUG_SYNC= 'p9abcdef CLEAR';
192
SET DEBUG_SYNC= 'p3abcdef CLEAR';
193
SET DEBUG_SYNC= 'p4a CLEAR';
194
SET DEBUG_SYNC= 'p7 CLEAR';
195
SET DEBUG_SYNC= 'p1abcd TEST';
196
SHOW VARIABLES LIKE 'DEBUG_SYNC';
198
debug_sync ON - current signal: 's3'
199
SET DEBUG_SYNC= 'p7 TEST';
200
SHOW VARIABLES LIKE 'DEBUG_SYNC';
202
debug_sync ON - current signal: 's3'
203
SET DEBUG_SYNC= 'p9abcdef TEST';
204
SHOW VARIABLES LIKE 'DEBUG_SYNC';
206
debug_sync ON - current signal: 's3'
207
SET DEBUG_SYNC= 'RESET';
208
SHOW VARIABLES LIKE 'DEBUG_SYNC';
210
debug_sync ON - current signal: ''
211
CREATE USER mysqltest_1@localhost;
212
GRANT SUPER ON *.* TO mysqltest_1@localhost;
213
connection con1, mysqltest_1
214
SET DEBUG_SYNC= 'RESET';
216
DROP USER mysqltest_1@localhost;
217
CREATE USER mysqltest_2@localhost;
218
GRANT ALL ON *.* TO mysqltest_2@localhost;
219
REVOKE SUPER ON *.* FROM mysqltest_2@localhost;
220
connection con1, mysqltest_2
221
SET DEBUG_SYNC= 'RESET';
222
ERROR 42000: Access denied; you need the SUPER privilege for this operation
224
DROP USER mysqltest_2@localhost;
225
SET DEBUG_SYNC= 'RESET';
226
DROP TABLE IF EXISTS t1;
227
CREATE TABLE t1 (c1 INT);
229
SET DEBUG_SYNC= 'before_lock_tables_takes_lock
230
SIGNAL opened WAIT_FOR flushed';
231
INSERT INTO t1 VALUES(1);
233
SET DEBUG_SYNC= 'now WAIT_FOR opened';
234
SET DEBUG_SYNC= 'after_flush_unlock SIGNAL flushed';
239
SET DEBUG_SYNC= 'RESET';