Skip to:

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

pt-table-sync failing to sync data from Pxc to async environment and trigger errors "WSREP detected deadlock/conflict and aborted the transaction."

Description

Pt-table-checksum works fine; however, in the same environment/version, pt-table-sync fails to sync data from one of the sources [Pxc] to the Async replica.

Output:

 

pt-table-sync

 

a) --print

Output:

 

b) --execute

 

I tested in the latest version as well [3.6.0]; however, the results are the same.

Environment

AFFECTED CS IDs

CS0047230

Activity

Aaditya Dubey 
August 12, 2024 at 5:22 PM

Hi

Thank you for the report.
Verified as described.

Environment:

PXC Cluster 2 or 3 nodes:

Step1: 3 nodes cluster created like this:

single PS/PXC, which is a traditional ASYNC slave/replica node

Step2: Comment out the following variables in all PXC nodes:

Step3: Add the following variable in all PXC nodes:

step4: Restart PXC Nodes:

step5:Now make ps5.7.41 a replica to PXC Node:

Described Here:

step6: Now create the following table on any PXC node & set binlog_format as stmt:

step7: Check ps5.7.41 table must be replicated there.

step8: Delete few rows from ps5.7.41 replica:

step9: Now run the checksum command on the PXC node:

step10: Now run sync command with --print option:

step11: Now run the sync command:

Details

Assignee

Reporter

Priority

Components

Affects versions

Needs QA

Created June 20, 2024 at 12:34 PM
Updated August 12, 2024 at 5:24 PM