LP #1172133: pt-table-checksum Waits Indefinitely Checking for Max Chunk on Async PXC Node When Replication is not Properly Working

**Reported in Launchpad by Jervin R last update 03-05-2013 04:13:11

Say, I have an async master with PC nodes as slave, if I have log_slave_updates turned off on the PXC nodes, replication stream does not work properly - this is a user case error, however for due diligence it should warn or bail for PXC cases like when log_slave_updates is off or for some reason that waiting for max chunk on the PXC nodes is not possible.

Im not sure what else to look for, but here's what I see on debug mode:

1. pt_table_checksum:9551 8568 Checking slave diffs# pt_table_checksum:10533 8568 SELECT MAX(chunk) FROM `percona`.`checksums` WHERE db='test' AND tbl='audit' AND master_crc IS NOT NULL# pt_table_checksum:10550 8568 upxdbc01 max chunk: 1# pt_table_checksum:10550 8568 upxdbc02 max chunk: undef
2. pt_table_checksum:10550 8568 upxdbc03 max chunk: undef
3. pt_table_checksum:10583 8568 Sleep 0.25 waiting for chunks
4. pt_table_checksum:10550 8568 upxdbc01 max chunk: 1
5. pt_table_checksum:10550 8568 upxdbc02 max chunk: undef
6. pt_table_checksum:10550 8568 upxdbc03 max chunk: undef
7. pt_table_checksum:10583 8568 Sleep 0.5 waiting for chunks

This would go on and on.

[[email protected] msb_5_5_300]$ pt-table-checksum --version
pt-table-checksum 2.1.9