blob: 3af9bcde6f6e68ce87101d0b6b23b4e532e5a7bb (
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
|
#! /bin/sh
# $Id$
#
# Display environment's deadlocks based on "db_stat -Co" output.
t1=__a
t2=__b
trap 'rm -f $t1 $t2; exit 0' 0 1 2 3 13 15
if [ $# -ne 1 ]; then
echo "Usage: dd.sh [db_stat -Co output]"
exit 1
fi
if `egrep '\<WAIT\>.*\<page\>' $1 > /dev/null`; then
n=`egrep '\<WAIT\>.*\<page\>' $1 | wc -l | awk '{print $1}'`
echo "dd.sh: $1: $n page locks in a WAIT state."
else
echo "dd.sh: $1: No page locks in a WAIT state found."
exit 1
fi
# Print out list of node wait states, and output cycles in the graph.
egrep '\<WAIT\>.*\<page\>' $1 | awk '{print $1 " " $5 " " $7}' |
while read l f p; do
for i in `egrep "\<HELD\>.*\<$f\>.*\<page\>.*\<$p\>" $1 |
awk '{print $1}'`; do
echo "$l $i"
done
done | tsort > /dev/null 2>$t1
# Display the locks in a single cycle.
c=1
display_one() {
if [ -s $1 ]; then
echo "Deadlock #$c ============"
c=`expr $c + 1`
cat $1 | sort -n +6
:> $1
fi
}
# Display the locks in all of the cycles.
#
# Requires tsort output some text before each list of nodes in the cycle,
# and the actual node displayed on the line be the second (white-space)
# separated item on the line. For example:
#
# tsort: cycle in data
# tsort: 8000177f
# tsort: 80001792
# tsort: 80001774
# tsort: cycle in data
# tsort: 80001776
# tsort: 80001793
# tsort: cycle in data
# tsort: 8000176a
# tsort: 8000178a
#
# XXX
# Currently, db_stat doesn't display the implicit wait relationship between
# parent and child transactions, where the parent won't release a lock until
# the child commits/aborts. This means the deadlock where parent holds a
# lock, thread A waits on parent, child waits on thread A won't be shown.
if [ -s $t1 ]; then
:>$t2
while read a b; do
case $b in
[0-9]*)
egrep $b $1 >> $t2;;
*)
display_one $t2;;
esac
done < $t1
display_one $t2
else
echo 'No deadlocks found.'
fi
exit 0
|
