pt-table-checksum does't work with multi source (mariadb)

Bug #1736081 reported by Naveen
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to https://jira.percona.com/projects/PT
New
Undecided
Unassigned

Bug Description

pt-checksum is getting to never ending loop in multi-source (channel based) replication :

A multi source replication in my environment

n1 -> n2 (created n1 as channel replication)
n2 -> n3
n1 -> n3 (n3 will replicate from both n1 and n2 channels)

 > Whenever without channel wise replication pt-checksum is working fine. (traditional replication/default replication works without any issues)

 > Once i enabled as channel wise(only n1, removed the n2 channel) replication (n1->n3) , the pt-checksum is not going through.
     Replica n3-VirtualBox is stopped. Waiting.
     Replica n3-VirtualBox is stopped. Waiting.
     Replica n3-VirtualBox is stopped. Waiting.
     Replica n3-VirtualBox is stopped. Waiting.

   from general log n1:
          Query SELECT 'pt-table-checksum keepalive'
          Query SELECT 'pt-table-checksum keepalive'

Naveen (naveen-mysql)
description: updated
summary: - pt-table-checksum does't work with multi source (mariadb
+ pt-table-checksum does't work with multi source (mariadb)
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1466

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.