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
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
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
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2024 Percona LLC. All rights reserved.