Not the answer you need?
Register and ask your own question!

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

sqcsqc EntrantLegacy User Role Novice
I'm modifying a float column to decimal using pt-online-schema-change.


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.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.