blob: ffbdc3064554ab109df346827adf3bbe01123555 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
|
###############################################################################
# This file plays as a function/module for ddl_high_priority test
#
# Usage: set the following variables before including
#
# $use_sys_var: whether using sys_var or syntax to trigger high_priority
# value: 0/1
#
# $con_block: a blocking connection
# value: con1/con2/default
#
# $con_kill: a connection that will attempt to kill $con_blocking
# value: con1/con2/default
#
# $cmd: a regular command to evaluate (to use with sys var)
# value: sql command
#
# $high_priority_cmd: a high_priority command to evaluate
# value: sql command
#
# $should_kill: Expect the con_block to be killed or not
# value: 0/1
#
# $recreate_table: Should recreate the test table or not
# value: 0/1
#
# $throw_error: whether a command will throw lock_wait_timeout error.
# Note, optimize table catches all errors.
# value: 0/1
###############################################################################
##
## Print out the parameters of the test set
## (useful for debugging)
##
--echo
--echo ## Test parameters:
--echo ## use_sys_var = $use_sys_var
--echo ## con_block = $con_block
--echo ## con_kill = $con_kill
--echo ## cmd = $cmd
--echo ## high_priority_cmd = $high_priority_cmd
--echo ## should_kill = $should_kill
--echo ## recreate_table = $recreate_table
--echo ## throw_error = $throw_error
--echo
##
## Setup
##
connection default;
# create con1
connect (con1,localhost,test_user1,,test,,);
if ($recreate_table) {
# create t1
--disable_warnings
drop table if exists t1;
--enable_warnings
create table t1 (i int);
show create table t1;
insert into t1 values (1), (2), (3);
}
##
## Testing
##
--echo connection: $con_block
--connection $con_block
--eval $blocking_sql
--echo connection: $con_kill
--connection $con_kill
set lock_wait_timeout = 0.02;
set high_priority_lock_wait_timeout = 0.02;
describe t1;
--echo connection: default (for show processlist)
connection default;
--echo # both $con_block and $con_kill exist
--replace_column 1 <Id> 3 <Host> 5 <Command> 6 <Time> 7 <State> 8 <Info> 9 <RExam> 10 <RSent> 11 <TID>
show processlist;
--echo connection: $con_kill
--connection $con_kill
# command will fail without high_priority
if ($throw_error) {
--error ER_LOCK_WAIT_TIMEOUT
--eval $cmd
}
if (!$throw_error) {
--eval $cmd
}
if ($use_sys_var) {
set high_priority_ddl = 1;
select @@high_priority_ddl;
# non-supported command will timeout
--error ER_LOCK_WAIT_TIMEOUT
lock tables t1 write;
if (!$should_kill) {
# regular user ddl will fail regardless of high_priority_ddl being on
--error ER_LOCK_WAIT_TIMEOUT
--eval $cmd
}
if ($should_kill) {
--eval $cmd
}
# reset high_priority_ddl
set high_priority_ddl = 0;
}
if (!$use_sys_var) {
if (!$should_kill) {
# regular user ddl will fail regardless of high_priority being on
--error ER_LOCK_WAIT_TIMEOUT
--eval $high_priority_cmd
}
if ($should_kill) {
--eval $high_priority_cmd
}
}
--echo connection: default (for show processlist)
connection default;
--replace_column 1 <Id> 3 <Host> 5 <Command> 6 <Time> 7 <State> 8 <Info> 9 <RExam> 10 <RSent> 11 <TID>
show processlist;
disconnect con1;
|
