2064 Commits

Author SHA1 Message Date
Sveta Smirnova
9f1e50cb58 PT-2340 - Support MySQL 8.4
- Changed replica_parallel_workers in configuration for 8.0 and 8.4 to o, because wiat_for_replicas is buggy for multi-threaded slaves (cherry picked from commit d9b0219d9e)
- Minor tests diagnostic and cleanup
2024-12-16 13:23:41 +03:00
Sveta Smirnova
44a2819055 PT-2340 - Support MySQL 8.4
- Added wait_for_replicas call into t/pt-table-checksum/pt-1616.t
- Added diagnostic output into t/pt-upgrade/run_time.t, t/pt-table-sync/issue_627.t
2024-12-03 16:25:58 +03:00
Henning Poettker
f8d736a89a Fixed flaky tests
The tests previously tested assertions against the replica after
executing changes in the source without waiting for the
replication to converge.
2024-11-14 22:58:42 +01:00
Sveta Smirnova
f57d63ab00 PT-2340 - Support MySQL 8.4
- Added sleep to t/lib/MasterSlave.t, so it does not fail on fast machines
- Disabled SSL tests on versions earlier than 8.0
2024-11-14 22:48:06 +03:00
Sveta Smirnova
3786d4e4ce PT-2340 - Support MySQL 8.4
- Added SSL to 8.4 tests
2024-11-14 03:20:43 +03:00
Sveta Smirnova
8b802722db PT-2340 - Support MySQL 8.4
- Adjusted tools and tests which fail due to fixed update-modules command
- Adjsted t/pt-table-checksum/basics.t test for 8.0
2024-11-13 21:23:39 +03:00
Sveta Smirnova
bb66ab0845 PT-2340 - Support MySQL 8.4
- Implemented functions get_replica_name and get_source_name in lib/MasterSlave.pm I did not implement similar functions in other places, because they set other variables as well, not only replica_name or source_name.
2024-11-13 02:04:39 +03:00
Sveta Smirnova
a1093ff12c PT-2340 - Support MySQL 8.4
- s/slave lag/replica lag/ in tests
- reverted rename of COM_REGISTER_SLAVE to COM_REGISTER_REPLICA, because the constant still named COM_REGISTER_SLAVE in 8.4
- removed some slave leftovers from pt-replica-find
2024-11-12 15:18:36 +03:00
Sveta Smirnova
fcb2d549b8 PT-2340 - Support MySQL 8.4
- Adjusted pt-variable-advisor, so it reflects current defaults
2024-10-04 19:02:07 +03:00
Sveta Smirnova
e4281dc6c2 PT-2340 - Support MySQL 8.4
- Adjusted t/pt-deadlock-logger/check_schema_exists.t so it makes sense
2024-10-04 18:32:39 +03:00
Sveta Smirnova
33086769a1 PT-2340 - Support MySQL 8.4
- Added test for replica lag check for pt-archiver
- Re-added deprecated slave- options
- Added tests for deprecation warnings and for legacy options for pt-archiver
- Removed practically not supported options --replica-user and --replica-password from pt-archiver, pt-kill, pt-query-digest
- Added legacy source/replica options (master/slave) variants and tests for pt-heartbeat, pt-online-schema-change, pt-replica-find, pt-replica-restart, pt-table-checksum, pt-table-sync
- Updated modules after lib/MasterSlave.pm change
2024-10-04 18:27:00 +03:00
Sveta Smirnova
1de149116a PT-2340 - Support MySQL 8.4
- Added tests for legacy style heartbeat and checksum tables
2024-09-20 15:47:21 +03:00
Sveta Smirnova
5d55904436 PT-2340 - Support MySQL 8.4
- Tests for the minimal SSL support
- Updated util/update-modules, so they don't skip tools with modules, not defined in lib
2024-09-18 15:28:45 +03:00
Sveta Smirnova
045b2fec9f PT-2340 - Support MySQL 8.4
- Adjusted test results, broken due to mysql.component table in PS
2024-09-06 16:10:36 +03:00
Sveta Smirnova
ea6bd77501 PT-2340 - Support MySQL 8.4
- Moved data collection for THP from lib/bash/report_system_info.sh to lib/bash/collect_system_info.sh, so pt-summary reports THP status on the machine where samples were collected, not on the machine where an engineer examines samples.
2024-09-06 13:08:45 +03:00
Sveta Smirnova
c3f327d53b PT-2340 - Support MySQL 8.4
- Updated tests for pt-variable-advisor and lib/VariableAdvisorRules
2024-09-05 16:45:45 +03:00
Sveta Smirnova
d03bd604a1 PT-2340 - Support MySQL 8.4
- Fixed typos
- Added tests for MyRocks and TokuDB clustered indexes into t/pt-duplicate-key-checker/clustered_keys.t
- Updated modules
2024-09-04 18:32:58 +03:00
Sveta Smirnova
2ca815650e PT-2340 - Support MySQL 8.4
- Created pt-replica-find. pt-slave-find kept as symbolic link
2024-08-28 00:41:11 +03:00
Sveta Smirnova
e3e352d1d6 PT-2340 - Support MySQL 8.4
- Fixed comparison operators for VersionCheck calls
2024-08-27 13:45:37 +03:00
Sveta Smirnova
8f87bad328 PT-2340 - Support MySQL 8.4
- Created pt-replica-restart. pt-slave-restart kept as symbolic link
2024-08-27 00:41:34 +03:00
Sveta Smirnova
1006101bb4 PT-2340 - Support MySQL 8.4
- Added deprecation warning to pt-slave-delay
- Re-enabled tests for pt-slave-delay to check the warning
- Disabled pt-slave-delay for MySQL 8.1+
2024-08-26 22:26:09 +03:00
Sveta Smirnova
194bb99ef9 PT-2340 - Support MySQL 8.4
- Fixed 5.7 tests
2024-08-25 04:36:37 +03:00
Sveta Smirnova
b332537481 PT-2340 - Support MySQL 8.4
- Fixed staff I broke for 8.0
2024-08-23 16:03:53 +03:00
Sveta Smirnova
a38bee6d60 PT-2340 - Support MySQL 8.4
- Updated modules and tests for pt-table-sync, pt-table-usage, pt-upgrade, pt-variable-advisor
2024-08-03 17:12:11 +03:00
Sveta Smirnova
d02355f89b PT-2340 - Support MySQL 8.4
- Updated modules and tests for pt-query-digest, pt-show-grants, pt-slave-delay, pt-slave-find, pt-slave-restart, pt-stalk, pt-summary, pt-table-checksum
2024-08-03 14:24:10 +03:00
Sveta Smirnova
76c1202cb5 PT-2340 - Support MySQL 8.4
- Updated modules and tests for pt-online-schema-change
- Removed typo from lib/MasterSlave.pm
2024-07-30 18:20:50 +03:00
Sveta Smirnova
5c999ca3e0 PT-2340 - Support MySQL 8.4
- Removed runtime.txt after discussion with Anastasia Alexandrova
- Added "use VersionParser" into tests in t/lib when needed
- Removed word master from tests for pt-archiver, pt-config-diff, pt-deadlock-logger, pt-duplicate-key-checker, pt-find, pt-fk-error-logger, pt-heartbeat, pt-index-usage, pt-ioprofile, pt-kill, pt-mysql-summary
- Removed word slave from tests for pt-archiver, pt-config-diff, pt-deadlock-logger, pt-duplicate-key-checker, pt-find, pt-fk-error-logger, pt-heartbeat, pt-index-usage, pt-ioprofile, pt-kill, pt-mysql-summary
- Updated modules for pt-archiver, pt-config-diff, pt-deadlock-logger, pt-duplicate-key-checker, pt-find, pt-fk-error-logger, pt-heartbeat, pt-index-usage, pt-ioprofile, pt-kill, pt-mysql-summary
- Changed mysql_ssl patch, so it is now short option s
- Added a check for existing zombies in t/pt-kill/execute_command.t
- Added bin/pt-galera-log-explainer to .gitignore
2024-07-27 01:59:52 +03:00
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
e2207ea232 PT-2340 - Support MySQL 8.4
- Removed offensive terminology from library files and their tests
- Removed unused sandbox/prove2junit.pl
- Added option mysql_ssl to DSN and possibility to have DSN of multiple letters
2024-07-25 19:03:33 +03:00
Sveta Smirnova
4612cb2b97 PT-2340 - Support MySQL 8.4
- Adjusted sandbox scripts, so they can start MySQL 8.4
- Added MySQL 8.4 configuration file
- Removed empty file sandbox/5.6
- Removed unused files sandbox/set-mysql, sandbox/slave_channels_t.sql, sandbox/jenkins-test
- Removed offensive terminology from the sandbox scripts wherever it is possible
2024-07-23 16:07:38 +03:00
Sveta Smirnova
f47c1d76b6 PR-839 - Update pt-mysql-summary
- Reversed condition, so default is transaction_isolation, not
  tx_isolation
- Removed extra variable: we have variable $version, defined before
- Fixed test cases
2024-07-16 19:02:40 +03:00
Sveta Smirnova
e8a09c62a3 Fixed wait_for_slaves in t/pt-table-sync/master_master.t, so it instructs master1 to wait when master2 is up-to-date 2024-06-07 22:12:44 +03:00
Sveta Smirnova
aaa258d209 Added master server restart in the cleanup for t/pt-online-schema-change/pt-2168-cancel.t test, so next test is not affected by not properly closed connections in 5.7 2024-06-07 22:12:44 +03:00
Sveta Smirnova
8dd0f28f64 Removed extra spaces in lsof output, so mysql_pid detection does not depend on lsof format 2024-06-07 22:12:44 +03:00
Sveta Smirnova
5e72127ebf Merge branch 'release-v3.6.0' of github.com:percona/percona-toolkit into release-v3.6.0 2024-06-07 22:12:44 +03:00
Sveta Smirnova
8aecd2bf09 Adjusted t/pt-table-checksum/samples/default-results-5.7.txt to skip unstable results 2024-06-07 22:12:23 +03:00
Sveta Smirnova
dd1e9aeac3 Adjusted t/pt-table-checksum/samples/default-results-5.7.txt to skip unstable results 2024-06-07 22:11:35 +03:00
Sveta Smirnova
1774b856be PT-2264 - pt-query-digest Pipeline process 11 (--output slowlog) caused an error: Wide character
- Skipped test for versions before 8.0
2024-05-30 03:48:14 +03:00
Sveta Smirnova
f8d2f59e62 PT-2119 - pt-osc aborts in 8.0.15 even if no FK exists
- Adjusted test case, so it is skipped on 5.7
2024-05-30 03:38:20 +03:00
Sveta Smirnova
a8258bf784 PR-471 - Support adding explain output for slow query in JSON report as well
- Removed paths from my laptop from tests
2024-05-25 15:04:11 +03:00
Sveta Smirnova
acc0d495d2 Typo in t/lib/bash/collect.t, causing test failure on Bookworm 2024-05-24 11:49:05 +03:00
Sveta Smirnova
a74cf58799 Merge pull request #686 from percona/pt-2247
Pt 2247
2024-05-21 17:30:08 +03:00
Sveta Smirnova
f3f4943d52 PT-2247 - pt-show-grants does not CREATE USER
- Removed option print_identified_with_as_hex, because it was already
  implemented in the PT-2190 fix
- Simplified patch
- Kept CREATE USER/ALTER USER sequence and extra DELETE from mysql.user
  table
- Added test case
2024-05-17 02:34:53 +03:00
Sveta Smirnova
32cfc53d9d PT-2154 - Fix tests for pt-table-sync
- Removed debug output from t/pt-table-sync/issue_920.t
- Removed debug output from t/pt-table-sync/issue_996.t
2024-05-16 02:30:49 +03:00
Sveta Smirnova
fdc0597e55 PT-2154 - Fix tests for pt-table-sync
- Removed diagnostic output from t/pt-table-sync/issue_996.t
- Corrected character set options in t/pt-table-sync/samples/pt-1205.sql
2024-05-16 02:04:40 +03:00
Sveta Smirnova
e2ca142baa PT-2154 - Fix tests for pt-table-sync
- Removed junk comment from t/pt-table-sync/pt-2309.t
- Re-enabled t/pt-table-sync/issue_96.t in 8.0+
- Re-enabled tests in t/pt-table-sync/pt-1256.t in 8.0.14+
- Re-enabled t/pt-table-sync/master_master.t in 8.0+
- Re-enabled t/pt-table-sync/lock_and_rename.t in 8.0+
- Re-enabled t/pt-table-sync/issue_965.t
- Added proper disable comments into t/pt-table-sync/issue_920.t and t/pt-table-sync/issue_996.t
2024-05-15 19:31:27 +03:00
Sveta Smirnova
75d534954a PT-2190 - pt-show-grants should use print_identified_with_as_hex
- Implemented the fix
- Added test case
2024-04-26 02:22:24 +03:00
Sveta Smirnova
6632ccc044 Merge branch '3.x' into PT-2309_pt-table-sync_hits_an_error_when_the_primary_key_is_uuid_binary 2024-04-18 13:16:19 +03:00
Sveta Smirnova
18d4fe9183 Merge pull request #797 from percona/PT-2327_pt-mysql-summary_fails_to_connect_if_password_has_a_single_quote_character
PT-2327 - pt-mysql-summary fails to connect if password has a single …
2024-04-18 13:15:11 +03:00