Skip to:

Skip to Jira Navigation
Skip to Side Navigation
Skip to Main Content

pt-table-checksum is showing deadlock error with PXC-8.0

General

Escalation

General

Escalation

Description

Error Info

Testcase

Environment

None

Linked work items

is triggered by

Inconsistent behavior of SET SESSION binlog_format='STATEMENT';

relates to

LP #1263991: Session binlog_format cannot be changed to STATEMENT

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

Smart Checklist

Activity

Show:

Sveta Smirnova December 26, 2022 at 12:08 PM

This is because PXC 8.0 does not replicate events if binlog_format is STATEMENT. Actually it even dos not allow in 50% of time to set binary log format to STATEMENT:

Resize issue view side panel

Details

Assignee

Unassigned

Reporter

Ramesh Sivaraman(Deactivated)

Priority

High

Components

Fix versions

Smart Checklist

Created February 28, 2019 at 5:35 PM

Updated August 12, 2024 at 5:24 PM