File: kill_query.inc

package info (click to toggle)
mysql-5.1 5.1.73-1%2Bdeb6u1
  • links: PTS, VCS
  • area: main
  • in suites: squeeze-lts
  • size: 197,132 kB
  • ctags: 93,377
  • sloc: cpp: 579,952; ansic: 429,462; perl: 49,053; sh: 21,692; pascal: 21,272; yacc: 12,801; makefile: 4,545; xml: 4,114; sql: 3,297; lex: 1,265; asm: 1,023
file content (68 lines) | stat: -rw-r--r-- 1,771 bytes parent folder | download | duplicates (19)
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
# ==== Purpose ====
#
# Kill a query in the master connection, and then try to reap the
# result of the killed query.
#
# ==== Usage ====
# 
# The following variables should be set before sourcing this file.
#
# $debug_lock: name of the debug user lock, if set, will release/lock
#              the specified debug lock accordingly, and before
#              sourcing this, connection 'master' should get the user
#              lock and run a query in another thread, which will
#              block before creating statement event.
#
# $connection_name: name of the connection that is waiting for the
#                   lock, this can not be 'master'
#
# $connection_id: id of the connection that is waiting for the lock
#
# Example:
# let $debug_lock=;
# connection master1;
# let $connection_name= master1;
# let $connection_id= `SELECT CONNECTION_ID()`;
# send CREATE TABLE t1;
# source kill_query.inc;
#
# let $debug_lock= "debug_lock.before_query_log_event";
# connection master;
# eval SELECT GET_LOCK($debug_lock, 10);
# connection master1;
# let $connection_name= master1;
# let $connection_id= `SELECT CONNECTION_ID()`;
# send CREATE TABLE t1;
# source kill_query.inc;


--echo source include/kill_query.inc;
disable_query_log;
disable_result_log;
connection master;

# kill the query that is waiting
eval kill query $connection_id;

if ($debug_lock)
{
  # release the lock to allow binlog continue
  eval SELECT RELEASE_LOCK($debug_lock);
}

# reap the result of the waiting query
connection $connection_name;
error 0, 1317, 1307, 1306, 1334, 1305, 1034;
reap;

connection master;

if ($debug_lock)
{
  # get lock again to make the next query wait
  eval SELECT GET_LOCK($debug_lock, 10);
}

connection $connection_name;
enable_query_log;
enable_result_log;