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.

Thanks

Comments

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

    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? (https://jira.percona.com)
    It also would be helpful to know the toolkit version and MySQL version.

    Regards
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.