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

pt-online-schema-change error: Error creating new table ... duplicate key

remko@paragin[email protected] EntrantInactive User Role Beginner
When using pt-online-schema-change 3.0.10 on a table that has previously been altered using the same tool, we get the "errno: 121 Duplicate key on write or update" error.
Googling & your bug tracker lead me to, but this issue is marked as fixed while it appears that it still exists.

I found an online blog-post detailing the issue and the fix, but I'm very uncomfortable with patching the software myself.

Is there any progress or news about the issue, or do I need to assume the tool works as intended and we need to find another workaround?


  • carlos.salguerocarlos.salguero Percona Toolkit Developer Percona Staff Role

    I re-opened the ticket to validate it.
    Thanks for the error report.
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.