When will Percona Toolkit 3.7.2 be available?

Polyglot Projects Percona Toolkit
1

When will Percona Toolkit 3.7.2 be available? I want the fix for Jira

2

Version 3.7.2 is in active development at the moment, but the release date is not yet known. Mentioned Jira is not fixed, so you will have to wait for the fix first, then for the release.

3

Thanks @svetasmirnova. Isn’t the simplest fix just to ignore the warning 1287, i.e.

# Completely ignore these error codes.
my %ignore_code = (
   # Error: 1592 SQLSTATE: HY000  (ER_BINLOG_UNSAFE_STATEMENT)
   # Message: Statement may not be safe to log in statement format.
   # Ignore this warning because we have purposely set statement-based
   # replication.
   1592 => 1,
   1300 => 1,
   1287 => 1,
);
4

Probably. I would investigate when will start working on the fix. I would appreciate if you add this suggestion to tje Jira ticket, so it is not lost.

5

I’ve updated the JIRA as @svetasmirnova requested.

6

Any news on when 3.7.2 is going out with this fix?

7

We have a very bad bug: https://perconadev.atlassian.net/browse/PT-2531 and its duplicates. I am working on the fix now. Once fixed, version 3.7.2 will be released.

Fix for https://perconadev.atlassian.net/browse/PT-2234, probably, already exists in the 3.x branch as part of MySQL 9.7 support. Could you please check with https://raw.githubusercontent.com/percona/percona-toolkit/refs/heads/3.x/bin/pt-table-checksum ?

8

I don’t see the fix in there, certainly not the one I suggested above. PT-2234 says the fix is in 3.7.2, but the version in the 3.x branch says 3.7.1-4.

9

This is not the fix you proposed. I added support for the SHA2 function. Probably you still will see the warning if you use MD5 though.

10

Doesn’t it still set a user variable in an expression, which will still give an error in 8.4?

11

I will check after I finish with https://perconadev.atlassian.net/browse/PT-2531