pt-online-schema-change can silently drop rows

Reported by Rob Smith on 2013-09-15
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit
Undecided
Unassigned

Bug Description

When adding a unique index on a table with pt-online-schema-change, it silently drops rows that fail the unique constraint. There should be the option to check that the row counts are the same before swapping tables.

Yes, we should check to verify that the columns are unique before running, but there are times the tools insert non-unique rows while PTOSC is running, thus having a final check would be best.

tags: added: risk
Changed in percona-toolkit:
status: New → Triaged
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers