mirror of
https://github.com/percona/percona-toolkit.git
synced 2025-09-01 18:25:59 +00:00
a7efd8c94e
* PT-2138 - Fix tests for pt-table-checksum - Updated t/pt-table-checksum/samples/default-results-8.0.txt and t/pt-table-checksum/samples/static-chunk-size-results-8.0.txt to support latest MySQL 8.0 version. Tests are now incompatible with elder 8.0 releases. - Put fix for PT-136 into package RowChecksum - Added execution bit for pt-online-schema-change * PT-2138 - Fix tests for pt-table-checksum - Fixed percona_test.load_data, so it really tests if LOAD DATA LOCAL INFILE is enabled - Fixed option --[no]create-replicate-table, broken by commitc9836d5962* PT-2138 - Fix tests for pt-table-checksum - Enabled t/pt-table-checksum/error_handling.t for MySQL 8.0 - Fixed test t/pt-table-checksum/fnv_64.t and it's samples file t/pt-table-checksum/samples/fnv64-sakila-city.txt to reflect new function name convention and changes after62d84e5dba* PT-2138 - Fix tests for pt-table-checksum - Fixed t/pt-table-checksum/issue_1485195.t, so it checks only one table and isn't get broken when we add tables into percona_test database - Fixed typo in error output of bin/pt-table-checksum - Skipped issue_47.t in 8.0 until https://jira.percona.com/browse/PT-1805 is fixed * PT-2138 - Fix tests for pt-table-checksum - Disabled pt-131.t for 8.0, because it does not have the QUERY_RESPONSE_TIME plugins - Added SLOW_TESTS check to pt-1616.t - Updated pt-226.t to include the fix for PT-1766 - For replication_filters.t: excluded false positive expression for tests 10 and 11 and added sys schema to the list of checked databases for 8.0 - Changed get_slaves in lib/MasterSlave.pm, so it returns slave's parent, required for wait_for_slaves in pt-table-checksum to work properly with chained slaves * PT-2138 - Fix tests for pt-table-checksum - Modified pt-204.t to support 8.0 and diffs in system tables due to timestamps Moved the fix for PT-1616 into the proper place: lib/NibbleIterator.pm * PT-2138 - Fix tests for pt-table-checksum - pxc.t -added mysql.proxies_priv into ignore list, because its timestamp is different on node - pxc.t - removed FORK=pxc from statup options for slave (non-cluster) nodes - pxc.t - disabled wsrep replication with help of the variable wsrep_on: sql_log_bin doesn't disable wsrep replication anymore. See https://jira.percona.com/browse/PXC-3464 for details - Removed data.tar.gz from 5.7 sandbox configuration, because it has an outdated definition for Performance Schema - Disabled pxc.t for version 8.0 until PT-1699 is fixed - start-sandbox - removed the first line (ALTER USER) from the init file, because it was rewritten by the next echo command, and then repeated later. * PT-2138 - Fix tests for pt-table-checksum - Adopted issue_1485195.t and basics.t for MyRocks-enabled setup - replication_filters.t - added sys schema to the list of expected schemas for 5.7 and 8.0 - issue_1485195.t - added checks for the existence of mysql.plugin, func, and proxies_priv tables - added samples/pt-131-wipe.sql that uninstalls QRT plugin if it was earlier installed by this test -adjusted return code in pt-204.t, because expected differences in mysql.proxies_priv * Update lib/PerconaTest.pm removed diagnostic code Co-authored-by: Carlos Salguero <carlos.salguero@percona.com> Co-authored-by: Carlos Salguero <carlos.salguero@percona.com>
67 lines
2.2 KiB
Perl
Executable File
67 lines
2.2 KiB
Perl
Executable File
#!/usr/bin/env perl
|
|
|
|
# This program is copyright 2009-2011 Percona Inc.
|
|
# Feedback and improvements are welcome.
|
|
#
|
|
# THIS PROGRAM IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED
|
|
# WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
|
|
# MERCHANTIBILITY AND FITNESS FOR A PARTICULAR PURPOSE.
|
|
#
|
|
# 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; OR the Perl Artistic License. On UNIX and similar
|
|
# systems, you can issue `man perlgpl' or `man perlartistic' to read these
|
|
# licenses.
|
|
#
|
|
# 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., 59 Temple
|
|
# Place, Suite 330, Boston, MA 02111-1307 USA.
|
|
|
|
# This program is intended to be run after loading Sakila into our test
|
|
# database, when starting the "sandbox" MySQL instances. It will store the
|
|
# checksums of all of the mysql and sakila tables into a magical
|
|
# percona_test.checksums table on instance 12345. Afterwards, one can verify the
|
|
# integrity of all of these tables by running
|
|
# lib/Sandbox.pm::verify_test_data_integrity() which will checksum the master
|
|
# and all of the slaves, and make sure all are OK.
|
|
|
|
use strict;
|
|
use warnings FATAL => 'all';
|
|
use English qw(-no_match_vars);
|
|
use DBI;
|
|
|
|
my $dbh = DBI->connect(
|
|
'DBI:mysql:;host=127.0.0.1;port=12345;', 'msandbox', 'msandbox',
|
|
{
|
|
AutoCommit => 1,
|
|
RaiseError => 1,
|
|
PrintError => 1,
|
|
ShowErrorStatement => 1,
|
|
# mysql_local_infile => 1,
|
|
});
|
|
|
|
$dbh->do("CREATE TABLE IF NOT EXISTS percona_test.load_data (i int)");
|
|
|
|
`echo 1 > /tmp/load_data_test.$$`;
|
|
|
|
eval {
|
|
$dbh->do("LOAD DATA LOCAL INFILE '/tmp/load_data_test.$$' INTO TABLE percona_test.load_data");
|
|
};
|
|
|
|
if ( $EVAL_ERROR ) {
|
|
$dbh->do("INSERT INTO percona_test.load_data (i) VALUES (0)");
|
|
}
|
|
|
|
unlink "/tmp/load_data_test.$$";
|
|
|
|
my ($val) = $dbh->selectrow_array("SELECT i FROM percona_test.load_data");
|
|
|
|
if ( ($val || 0) == 1 ) {
|
|
print "LOAD DATA LOCAL INFILE is enabled\n";
|
|
}
|
|
else {
|
|
print "LOAD DATA LOCAL INFILE is disabled\n"
|
|
}
|
|
|
|
exit;
|