Sample Header Ad - 728x90

failed pt-online-schema-change left behind triggers. How to delete?

4 votes
3 answers
804 views
We had a failed pt-osc - the server ran out of disk space. And now the triggers are left behind
SHOW TRIGGERS;

pt_osc_xxx_production_orders_ins
pt_osc_xxx_production_orders_upd
pt_osc_xxx_production_orders_del
How can these be deleted? Doing a DROP TRIGGER seems to lock the table (it has 150 million rows) and looks like it will take some hours. We cannot use pt-osc on this table anymore because it fails with a Trigger already exists error. We are running on mysql Ver 8.0.32-24 for Linux on x86_64 (Percona Server (GPL), Release 24, Revision e5c6e9d2) under CentOS8 (if that makes any difference)
Asked by phil (153 rep)
Jun 22, 2023, 01:07 PM
Last activity: Apr 12, 2024, 04:51 AM