Sample Header Ad - 728x90

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