Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

pt-table-checksum reports the error for warning code 4164

Description

Team,

Above, we can see that for warning code 4164, pt-table-checksum reports it as an error.

Due to the specific code line below, or SELECT, this warning code is generated.

Due to the above code line, “/*!99997*/", pt-table-checksum doesn’t complete successfully for the PXC 8.0.xx versions.

The same can be observed below where, ideally, this warning should be just reported, and pt-table-checksum should continue to run.

Here, we have two possible fixes to use with the pt-table-checksum :

Either add a space in “/*!99997 */" specific code line like below :

Or add the warning code 4164 under the %ignore_code list like below :

Environment

None

AFFECTED CS IDs

CS0050880

Activity

Show:

Aaditya Dubey December 25, 2024 at 1:56 PM

Hi

Thank you for the report.
It is verified as described.

How to Test:

  1. Deploy PXC 8.0.34 3 node cluster using dbdeployer by running the following command:

  2. Deploy PS 8.0.34 as a standalone node:

  3. Now run an inbuilt script from any node of PXC to make PS 8.0.34 as async replica:

  4. Now run the following command in all PXC nodes:

  5. Now create a small data set on any node of PXC:

  6. Now run pt-table-checksum:

Done

Details

Assignee

Reporter

Priority

Components

Affects versions

Fix versions

Needs QA

Yes

Smart Checklist

Created November 27, 2024 at 8:29 AM
Updated March 9, 2025 at 11:01 AM
Resolved January 14, 2025 at 3:26 PM
Configure