Percona pt-table-checksum output is in infinite loop "Waiting for the --replicate table to replicate"
0
votes
1
answer
776
views
We have following Multi master replication scenario. We are using Mariadb 10.1.34 and percona 3.0.11
- Master: Name: db-master1 (192.168.14.5)
- Slave: Name: db-slave2 (192.168.15.5) Replica Connection name:
master1 (192.168.14.5)
SHOW SLAVE 'master1' STATUS\G
on slave server is working fine.
On execution of following pt-table-checksum
command on DB Master (db-master1)
pt-table-checksum --replicate=percona.checksums --ignore-databases mysql,Quotient h=localhost,u=checksum_user,p=checksum_password --recursion-method=dsn=D=percona,t=dsns --no-check-binlog-format
Checking if all tables can be checksummed ...
Starting checksum ...
Replica db-slave2 is stopped. Waiting.
Replica db-slave2 is stopped. Waiting.
On Master1-db, the percona.dsns table have entry for db-slave2
The Above Waiting information is continue in infinite loop.
Look forward any support
Asked by Muhammad Rashid
(21 rep)
Aug 25, 2018, 02:41 PM
Last activity: Jan 6, 2025, 04:10 AM
Last activity: Jan 6, 2025, 04:10 AM