Buy Percona ServicesBuy Now!

pt-online-schema-change : Suppress error and continue during ALTER TABLE MODIFY

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-online-schema-change : Suppress error and continue during ALTER TABLE MODIFY

    I'm modifying a float column to decimal using pt-online-schema-change.

    ALTER TABLE MODIFY <floatcol> DECIMAL(14,4)

    Note: Current <floatcol> dimensions is <floatcol> FLOAT(14,4), same as the new DECIMAL.

    At some point during the copy, the old and new values don't match. The tool stops with the warning/error (INSERT FAILED)..
    Can I tell percona to log or suppress warning, and continue? Sorta --nocheck for values? I have millions of rows and I don't want pt-online-schema-change to stop processing just because of one row mismatching.
    Last edited by sqc; 08-20-2019, 01:02 PM.
Working...
X