49 Commits

Author SHA1 Message Date
Sveta Smirnova
8cbb5a0c8f PT-2340 - Support MySQL 8.4
- Removed lib/Percona/Test.pm, lib/Safeguards.pm, t/lib/Safeguards.t, because they are not used anymore
- Removed word "slave" from lib
2024-07-26 13:31:22 +03:00
Sveta Smirnova
b9a5231c9b PT-2340 - Support MySQL 8.4
- Removed all unneeded occuriences of the word "master" in lib
2024-07-25 23:12:43 +03:00
Sveta Smirnova
325809e86f PT-2295 - Fix tests on distributions
- Added regular expressions that match MariaDB Connector/C syntax for
  errors 2006 (Server has gone away) and 2013 (Lost connection)
2024-02-01 22:10:32 +03:00
Viktor Szépe
2bd40d8c39 Remove trailing spaces (#665)
* Remove trailing spaces

* PR-665 -  Remove trailing spaces

- Updated not stable test t/pt-online-schema-change/preserve_triggers.t
- Updated utilities in bin directory

* PR-665 -  Remove trailing spaces

- Fixed typos

* PR-665 -  Remove trailing spaces

- Fixed typos

---------

Co-authored-by: Sveta Smirnova <sveta.smirnova@percona.com>
2023-09-06 01:15:12 +03:00
Sveta Smirnova
642253ce52 PT-2156 Fix tests for lib (#606)
* PT-2156 - Fix tests for lib

- Fixed tests broken for lib/TableParser.pm after fix for PT-1059
- Updated tests for lib/TableParser.pm that are broken due to SHOW CREATE TABLE output format change in 8.0
- Updated modules for all tools that use lib/TableParser.pm

* Revert "Fixed pt-archiver tests"

This reverts commit a3ab87b12e.

This commit wa needed, because removed code in sandbox/slave_channels.sql broked the test. Proper fix would be to do not remove channel names rather than chaging the test. So revertig it.

* PT-2156 - Fix tests for lib

- Updated test t/lib/TableChecksum.t so it reflects changes, introduced in the fix for PT-2016
- Updated test t/lib/RowChecksum.t so it reflects changes added to in the fix for PT-2138: UTF8 support
- Uncommented SQL in sandbox/slave_channels.sql that made t/lib/MasterSlave.t to fail
- Added check for undef into t/pt-archiver/archive_using_channels.t
- Updated lib/Cxn.pm so it uses $dbh->{Active} after issue with the ping() call, reported at https://github.com/perl5-dbi/DBD-mysql/issues/306

* PT-2156 - Fix tests for lib

- Impoved the fix for PT-2016, so it does not files with keys with USING keyword
- Added brackets to expression in lib/TableNibbler.pm, so it does not crap query wit many indexes with OR keyword
- Adjusted test t/lib/TableNibbler.t, so it reflects above chages
- Modified lib/Cxn.pm, so it has workaround for https://github.com/perl5-dbi/DBD-mysql/issues/306 , introduced in DBD::mysql 4.0.50
- Updated tests: added debugging code and cleanups
- Updated modules for tools
2023-03-27 14:18:26 +03:00
Carlos Salguero
636123bded WIP 2019-09-18 09:20:56 -03:00
Carlos Salguero
ad9767be5c PT-148 Fixed Use of uninitialized value in printf 2017-05-29 17:11:02 -03:00
frank-cizmich
f77e4b31e0 merged ptc-reconnect-slave-dbh-lp1042727 2015-09-08 15:33:37 -03:00
frank-cizmich
e7052c013b pt-archiver added flow control awareness for PXC 2015-08-20 10:30:46 -03:00
Daniel Nichter
df2dc82d11 Wait for replicas in wait_for_last_checksum(). Add 'Server shutdown in progress' to Cxn::lost_connection(). 2015-06-24 19:33:01 -07:00
Frank Cizmich
735cf10594 merged pt-table-checksum-compatibility-with-pxc-1399789 2015-01-20 13:55:31 -02:00
Frank Cizmich
72cbc38e6d merged pt-online-schema-change--doesnt-honor--ask-pass-1396868 2015-01-20 13:53:13 -02:00
Frank Cizmich
3b1aca8293 unique-id function for cluster nodes. added pxc5.6 config. modified pxc test 2015-01-14 18:08:07 -02:00
Frank Cizmich
b025c97fd7 used ReadKeyMini. Moved double password logic to Cxn. Removed {ask_pass} from Cxn 2015-01-12 19:20:15 -02:00
Frank Cizmich
01f8102623 ask-pass-being-ignored-1396868 2014-11-28 11:53:34 -02:00
Frank Cizmich
5d875e5f55 fixed PTDEBUG error on Cxn - 1394934 2014-11-21 12:12:05 -02:00
Frank Cizmich
cdc7596a32 minor style change 2014-11-05 20:21:51 -02:00
Frank Cizmich
f237f4a0df We now use wsrep_node_incoming_address as a more reliable way to detect cluster node duplicates - 1217466 2014-10-23 15:32:34 -02:00
Daniel Nichter
1f93caf67c Add dsn opt to Cxn::connect() to change dsn. Update Cxn in pt-agent. 2013-12-04 16:14:17 -08:00
Daniel Nichter
0736427bbf Megre pt-agent branch. 2013-06-16 23:23:11 -07:00
Brian Fraser
7d5da6e6f5 Rebased the branch to trunk 2013-04-12 12:58:10 -03:00
Brian Fraser
db0a29561c Fixes per Daniel's review 2013-04-09 10:21:15 -03:00
Daniel Nichter
24758caa4c Use /*!50038 @@hostname*/ in Cxn.pm. 2013-04-04 15:31:21 -06:00
Daniel Nichter
cf0342c69e Implement and test running queries for tasks. 2013-03-19 18:17:24 -06:00
Daniel Nichter
5ddfb95ca7 Fix lib/Cxn.pm that didn't merge correctly. Fix t/lib/OptionParser.t test failure. Update Cxn, OptionParser, and DSNParser in all tools. 2013-03-13 12:38:45 -06:00
Daniel Nichter
cb9fe1fac3 Implement all MySQL log parsers. Add report sections, and --report. 2013-02-20 18:20:55 -07:00
Daniel Nichter
feab2f0925 s/Percona Inc/Percona Ireland Ltd/g 2013-01-02 17:19:16 -07:00
Brian Fraser
7beb0b518e Reverted a few unnecessary changes 2012-11-08 17:47:00 -03:00
Brian Fraser
aa79c9df57 Moved the PXC-dealing parts of Cxn.pm into Percona::XtraDB::Cluster 2012-11-07 04:06:50 -03:00
Brian Fraser
5a9cc13d6f Fixes for the previous commit 2012-10-17 15:39:06 -03:00
Brian Fraser fraserb@gmail.com
1875066868 Fix and tests for 1062563 and 1063912: ptc+PXC bugs 2012-10-17 12:58:48 -03:00
Daniel Nichter
b2cb95940f Merge partial-fix-1063912-ptc-pxc-slaves/ -r403..405 2012-10-08 12:53:54 -06:00
Daniel Nichter
3ddd074b54 Merge 2.1 at r386. 2012-08-29 16:35:17 -06:00
Daniel Nichter
d016b170b3 Merge ptc-run-time 2012-08-24 15:27:11 -06:00
Brian Fraser
02c6421a25 Cxn.pm: Set NAME_lc by default 2012-07-22 23:37:39 -03:00
Daniel Nichter
22a4068bea Add --run-time to pt-table-checksum. Remove NAME_lc arg from Cxn and turn it on by default like it used to be and fix pt-kill accordingly. 2012-07-18 10:07:27 -06:00
Daniel Nichter
dab2e5c692 Add NAME_lc arg to Cxn to prevent it from being set. Use Cxn in pt-kill to retry lost connections. Add support for pt-kill DSN. 2012-07-12 13:52:52 -06:00
Daniel Nichter
d7099496ca Add Cxn::is_cluster_node(). Add /*!99997*/ to SELECT..INSERT if the master is a cluster ndoe. 2012-06-27 11:57:08 -06:00
Brian Fraser fraserb@gmail.com
e57b67f10e Cxn & pt-osc: Guard the cleanup tasks.
Does this twofold: By adding a __DIE__ hook to make sure they are
called, and by checking that the dbh is an actual database handle.
2012-06-05 16:24:32 -03:00
Brian Fraser fraserb@gmail.com
b007016215 lib/Cxn.pm: Silence a warning (in 5.14)
I think this warning actually happens everywhere, but because of
how it happens, it gets masked by older versions of Perl.

Basically, Cxn's DESTROY method checks if $self->{dbh}, and if true,
calls ->disconnect on that. However, during global destruction --
when DESTROY is called -- you have no assurances that DESTROY
will be called before the dbh was already reaped.

This commit makes sure that the $self->{dbh} we have inside DESTROY
is actually a reference.
2012-03-30 16:03:04 -03:00
Daniel Nichter
88304e69fb Replace MKDEBUG with PTDEBUG in modules. 2012-01-19 12:46:56 -07:00
Daniel Nichter
1d8da408fc Revert to r243 to undo pt-table-sync changes. 2011-12-22 12:06:25 -07:00
Daniel Nichter
457fa70668 Fix TableSyncer trace msg, implement --explain, fix locking/committing. Add aux dbh, dbh opts, and disconnect() to Cxn. 2011-12-21 21:12:03 -07:00
Daniel Nichter
c4db7c0633 Test and fix very small --chunk-time. Report immediately when a slave is stopped. Add short form -q for --quiet. Report very slow checksums once for each table. Use Cxn::name() instead of Cxn::dsn()->{n}; remove n from DSNParser; make cxn's name @@hostname by default, else stringified DSN parts. 2011-10-19 11:27:19 -06:00
Daniel Nichter
e08719ac4a Fix timestamp. Make DSNs inherit from master DSN. 2011-10-17 11:41:02 -06:00
Daniel Nichter
48fb4baa7c Use 'h=localhost' if no DSN or DSN options given. Remove unused DSN parts (D and t) and don't copy some parts. Move issue_947.t tests into standard_options.t and remove issue_947.t. 2011-10-14 07:59:43 -06:00
Daniel Nichter
b2f92391a7 Fatal error if slave dies. Make Cxn::connect() if dbh id dead. Sort slave lag properly and use Cxn instead of dbh in ReplicaLagWaiter. Check master cxn before keepalive. Sleep N+0.25 waiting for chunks. 2011-10-10 10:56:08 -06:00
Daniel Nichter
31256a9e49 Add set callback to Cxn, docu module, and only ask for pass once. 2011-10-07 10:35:28 -06:00
Daniel Nichter
e2e40488c5 Add Cxn.pm. Make MasterSlave, NibbleIterator, and ReplicaLagWaiter use Cxn. Rewrite, simplify Retry. 2011-10-06 12:47:35 -06:00