pt-table-checksum doesn't ignore tables for --replicate-check-only
Bug #1074179 reported by
John Ferlito
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
High
|
Brian Fraser |
Bug Description
I'm performing the following out of cron
pt-table-checksum master --replicate=
Then later I run
pt-table-checksum master --replicate=
I get the following output
Differences on slave-02
TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
bad_database.
I would expect there to be no output
Related branches
lp:~percona-toolkit-dev/percona-toolkit/fix-1074179-ptc-replicate-check-only-filters
- Daniel Nichter: Approve
-
Diff: 70 lines (+42/-0)2 files modifiedbin/pt-table-checksum (+25/-0)
t/pt-table-checksum/bugs.t (+17/-0)
lp:~percona-toolkit-dev/percona-toolkit/doc-patch-empty-replicate-table-1074179
- Daniel Nichter: Approve
-
Diff: 13 lines (+3/-0)1 file modifiedbin/pt-table-checksum (+3/-0)
Changed in percona-toolkit: | |
assignee: | nobody → Brian Fraser (fraserbn) |
Changed in percona-toolkit: | |
milestone: | none → 2.1.7 |
Changed in percona-toolkit: | |
milestone: | 2.1.7 → 2.1.8 |
Changed in percona-toolkit: | |
status: | In Progress → Fix Committed |
Changed in percona-toolkit: | |
importance: | Undecided → High |
summary: |
- pt-table-checksum does't ignore tables for --replicate-check-only + pt-table-checksum doesn't ignore tables for --replicate-check-only |
Changed in percona-toolkit: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
There might be two bugs here. The code block doing --replicate- check-only doesn't look at any of the filters, so that's one bug. The second bug is that since the table should have been ignored by the first run, it shouldn't exist for the second run, yet it seems to, so perhaps --ignore- tables- regex isn't working in general.