pt-table-checksum doesn't respect --chunk-size-limit
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Confirmed
|
Undecided
|
Unassigned |
Bug Description
I'm invoking pt-table-checksum 2.2.4 as follow:
pt-table-checksum --recursion-
I'm getting an error in one single table:
08-20T06:09:14 Skipping table production.Products because on the master it would be checksummed in one chunk but on these replicas it has too many rows:
170573 rows on slave1
189670 rows on slave2
154844 rows on slave3
189998 rows on slave4
189380 rows on slave5
188190 rows on slave6
The current chunk size limit is 150403 rows (chunk size=150403 * chunk size limit=1).
If I run SELECT COUNT(*) FROM production.Products it returns the same result for master and all replicas.
As I'm invoking pt-table-checksum with --chunk-
All servers are running 5.0.96-
tags: | added: chunking pt-table-checksum |
I'm also seeing this issue on PT 2.1.5.