1
# Copyright (C) 2008-2009 Sun Microsystems, Inc. All rights reserved.
2
# Use is subject to license terms.
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.
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.
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
18
package GenTest::Validator::DatabaseConsistency;
21
@ISA = qw(GenTest::Validator GenTest);
27
use GenTest::Constants;
29
use GenTest::Validator;
35
my ($validator, $executors, $results) = @_;
36
my $dsn = $executors->[0]->dsn();
38
foreach my $i (0..$#$results) {
39
if ($results->[$i]->status() == STATUS_TRANSACTION_ERROR) {
40
# say("Explicit rollback after query ".$results->[$i]->query());
41
$executors->[$i]->dbh()->do("ROLLBACK /* Explicit ROLLBACK after a ".$results->[$i]->errstr()." error. */ ");
45
$dbh = DBI->connect($dsn) if not defined $dbh;
46
$tables = $dbh->selectcol_arrayref("SHOW TABLES") if not defined $tables;
48
foreach my $table (@$tables) {
49
my ($average1, $average2, $count) = $dbh->selectrow_array("
51
AVG(`col_int_key`) + AVG(`col_int`) AS average1,
52
(SUM(`col_int_key`) + SUM(`col_int`)) / COUNT(*) AS average2,
57
if (($average1 eq '') && ($count eq '')) {
58
# Server probably crashed, the SELECT returned no data
59
return STATUS_UNKNOWN_ERROR;
62
if (($average1 ne '200.0000') || ($average2 ne '200.0000')) {
63
say("Bad average for table: $table; average1: $average1; average2: $average2; count: $count; affected_rows: ".$results->[0]->affectedRows()."; query: ".$results->[0]->query());
64
return STATUS_DATABASE_CORRUPTION;