Clean up option for pt-online-schema-change

Registered by Daniel Nichter on 2013-03-25

From bug 1158950:

I was running pt-online-schema-change and had to abort the process due to the server load. I did a ctrl-C.

root@HOSTNAME:~# pt-online-schema-change --execute --alter "modify column quantity decimal(10,2), modify column total decimal(10,2), modify column cost decimal(10,2), modify column card_quantity decimal(10,2), modify column card_total decimal(10,2)" D=xxxxxx,t=xxxxx --chunk-index PRIMARY --no-check-plan > xxxxx_out
# Exiting on SIGTERM.

When I went to run it again and got the following error

root@HOSTNAME:~# pt-online-schema-change --execute --alter "modify column quantity decimal(10,2), modify column total decimal(10,2), modify column cost decimal(10,2), modify column card_quantity decimal(10,2), modify column card_total decimal(10,2)" D=xxxxx,t=xxxxxxxxx--chunk-index PRIMARY --no-check-plan
The table `xxxxxxxx`.`xxxxxxxxxxxx` has triggers. This tool needs to create its own triggers, so the table cannot already have triggers.

Would it be possible in the future to have a flag to clean up the triggers from previous attempts?

Blueprint information

Status:
Not started
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
Accepted for 2.2
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.