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

pt-online-schema-change table cannot already have triggers

zoberzober EntrantInactive User Role Beginner
I'm trying to run pt-online-schema-change script and getting a "Table already has triggers" error, however I ran a SHOW TRIGGERS on the database and there are no triggers in the entire database. I'm running on a replication db.



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

    Could you please re run the program setting PTDEBUG=1?
    PTDEBUG=1 pt-online-schema-change ....

    and then paste the output here or in Jira? (
    It also would be helpful to know the toolkit version and MySQL version.

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.