Percona pt-table-checksum output is in infinite loop "Waiting for the --replicate table to replicate" - Source

Revision: 72979
User: Muhammad Rashid
Date: 2018-10-08 13:29

We have following Multi master replication scenario. We are using Mariadb 10.1.34 and percona 3.0.11

Master: 
Name: db-master1-centralus-stg-vm (172.22.14.5)

Slave:  
Name: db-slave2-centralus-stg-vm (172.22.15.5)
Replica Connection name: label-db-master1-centralus-stg-vm (172.22.14.5)

SHOW SLAVE 'label-db-master1-centralus-stg-vm' STATUS\G on slave server is working fine.

On execution of following pt-table-checksum command on DB Master (db-master1-centralus-stg-vm)

pt-table-checksum --replicate=percona.checksums -uroot -pxxxxxxxx --ignore-databases mysql,percona --recursion-method=dsn=D=percona,t=dsns --no-check-binlog-format

Checking if all tables can be checksummed ...
Starting checksum ...
Waiting for the --replicate table to replicate to db-slave2-centralus-stg-vm...
Waiting for the --replicate table to replicate to db-slave2-centralus-stg-vm

In percona.dsns table have entry for db-slave2-centralus-stg-vm

The Above Waiting information is continue in infinite loop.

Look forward any support

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Percona pt-table-checksum output is in infinite loop "Waiting for the --replicate table to replicate" - Source

Products

Services

Pricing

Resources

About Us

Download MariaDB