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
Last activity: Apr 12, 2024, 04:51 AM