pt-online-schema-change's triggers fail with "DELETE command denied" on insert
0
votes
1
answer
255
views
We recently tried pt-online-schema-change to add a column to a table. It worked mostly as expected but one thing puzzles me: in case the account we use to do the migration doesn't have the DELETE permission, our application (which keeps running simultaneously) gets errors that say "DELETE command denied to user 'pt'@'localhost' for table '_xxx_new'" when the app is performing an **insert** on the *xxx* table.
My understanding is that the triggers are to do **inserts** to the destitation *_xxx_new* table when a new record is inserted in the source *xxx* table. How come it may fail with not having a DELETE permission??
Percona docs are pretty generic on this and no googling helped, so will be thankful for any ideas!
Asked by Dmitry Novoselov
(11 rep)
Mar 30, 2017, 03:27 PM
Last activity: Apr 4, 2022, 08:05 PM
Last activity: Apr 4, 2022, 08:05 PM