← Back to branch summary

~ubuntu-branches/ubuntu/vivid/drizzle/vivid-proposed

« back to all changes in this revision

Viewing changes to tests/randgen/lib/GenTest/Reporter/LockTableKiller.pm

  • Committer: Package Import Robot
  • Author(s): Tobias Frost
  • Date: 2013-08-22 20:18:31 UTC
  • mto: (20.1.1 sid)
  • mto: This revision was merged to the branch mainline in revision 21.
  • Revision ID: package-import@ubuntu.com-20130822201831-gn3ozsh7o7wmc5tk
Tags: upstream-7.2.3
Import upstream version 7.2.3

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/randgen/lib/GenTest/Reporter/LockTableKiller.pm
1
 
# Copyright (C) 2008-2009 Sun Microsystems, Inc. All rights reserved.
2
 
# Use is subject to license terms.
3
 
#
4
 
# This program is free software; you can redistribute it and/or modify
5
 
# it under the terms of the GNU General Public License as published by
6
 
# the Free Software Foundation; version 2 of the License.
7
 
#
8
 
# This program is distributed in the hope that it will be useful, but
9
 
# WITHOUT ANY WARRANTY; without even the implied warranty of
10
 
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
11
 
# General Public License for more details.
12
 
#
13
 
# You should have received a copy of the GNU General Public License
14
 
# along with this program; if not, write to the Free Software
15
 
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
16
 
# USA
17
 
 
18
 
package GenTest::Reporter::LockTableKiller;
19
 
 
20
 
require Exporter;
21
 
@ISA = qw(GenTest::Reporter);
22
 
 
23
 
use strict;
24
 
use DBI;
25
 
use GenTest;
26
 
use GenTest::Constants;
27
 
use GenTest::Reporter;
28
 
 
29
 
use constant PROCESSLIST_CONNECTION_ID          => 0;
30
 
use constant PROCESSLIST_PROCESS_TIME           => 5;
31
 
use constant PROCESSLIST_PROCESS_STATE          => 6;
32
 
use constant PROCESSLIST_PROCESS_INFO           => 7;
33
 
 
34
 
# Minimum lifetime of a LOCK TABLE before it is considered suspicious
35
 
use constant LOCK_LIFETIME_THRESHOLD            => 10;  # Seconds
36
 
 
37
 
sub monitor {
38
 
        my $reporter = shift;
39
 
 
40
 
        my $dsn = $reporter->dsn();
41
 
        my $dbh = DBI->connect($dsn);
42
 
 
43
 
        if (defined GenTest::Executor::MySQL::errorType($DBI::err)) {
44
 
                return GenTest::Executor::MySQL::errorType($DBI::err);
45
 
        } elsif (not defined $dbh) {
46
 
                return STATUS_UNKNOWN_ERROR;
47
 
        }
48
 
 
49
 
        my $processlist = $dbh->selectall_arrayref("SHOW FULL PROCESSLIST");
50
 
 
51
 
        foreach my $process (@$processlist) {
52
 
                if (
53
 
                        ($process->[PROCESSLIST_PROCESS_INFO] =~ m{LOCK\s+TABLE}sio) &&
54
 
                        ($process->[PROCESSLIST_PROCESS_TIME] > LOCK_LIFETIME_THRESHOLD) && 
55
 
                        ($process->[PROCESSLIST_PROCESS_STATE] eq 'Table lock')
56
 
                ) {
57
 
                        say("Stalled LOCK TABLE: ".$process->[PROCESSLIST_PROCESS_INFO].". Killing query.");
58
 
                        $dbh->do("KILL QUERY ".$process->[PROCESSLIST_CONNECTION_ID]);
59
 
                        return STATUS_OK;
60
 
                }
61
 
        }
62
 
 
63
 
        return STATUS_OK;
64
 
}
65
 
 
66
 
sub type {
67
 
        return REPORTER_TYPE_PERIODIC;
68
 
}
69
 
 
70
 
1;