pt-online-schema-change error creating triggers
The error message shows a lock wait timeout.

This means you cannot lock the table.

There is always three triggers needed for pt-osc on the source table:


INSERT trigger
DELETE trigger
UPDATE trigger


The triggers are not create atomically. They are created one at a time.

If root@localhost has GRANT ALL PRIVILEGES on *.*, you should be able to create the trigger. It looks like the table must have very high read/write traffic.

You will have to clean up as follows:

Kill the pt-osc

Login to MySQL and run

USE master
DROP TABLE `_website_new`;
DROP TRIGGER pt_osc_master_website_ins;
DROP TRIGGER pt_osc_master_website_upd;
DROP TRIGGER pt_osc_master_website_del;


The, start pt-osc over again