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
|
# Copyright (C) 2008-2009 Sun Microsystems, Inc. All rights reserved.
# Use is subject to license terms.
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; version 2 of the License.
#
# This program is distributed in the hope that it will be useful, but
# WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
# General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
# USA
package GenTest::Validator::DatabaseConsistency;
require Exporter;
@ISA = qw(GenTest::Validator GenTest);
use strict;
use DBI;
use GenTest;
use GenTest::Constants;
use GenTest::Result;
use GenTest::Validator;
my $tables;
my $dbh;
sub validate {
my ($validator, $executors, $results) = @_;
my $dsn = $executors->[0]->dsn();
foreach my $i (0..$#$results) {
if ($results->[$i]->status() == STATUS_TRANSACTION_ERROR) {
# say("Explicit rollback after query ".$results->[$i]->query());
$executors->[$i]->dbh()->do("ROLLBACK /* Explicit ROLLBACK after a ".$results->[$i]->errstr()." error. */ ");
}
}
$dbh = DBI->connect($dsn) if not defined $dbh;
$tables = $dbh->selectcol_arrayref("SHOW TABLES") if not defined $tables;
foreach my $table (@$tables) {
my ($average1, $average2, $count) = $dbh->selectrow_array("
SELECT
AVG(`col_int_key`) + AVG(`col_int`) AS average1,
(SUM(`col_int_key`) + SUM(`col_int`)) / COUNT(*) AS average2,
COUNT(*) AS count
FROM `$table`
");
if (($average1 eq '') && ($count eq '')) {
# Server probably crashed, the SELECT returned no data
return STATUS_UNKNOWN_ERROR;
}
if (($average1 ne '200.0000') || ($average2 ne '200.0000')) {
say("Bad average for table: $table; average1: $average1; average2: $average2; count: $count; affected_rows: ".$results->[0]->affectedRows()."; query: ".$results->[0]->query());
return STATUS_DATABASE_CORRUPTION;
}
}
return STATUS_OK;
}
1;
|