Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I used pt-online-schema-change but the process died in the middle.
The script makes a copy of the original table with the name followed by "_new".
Since the process died in the middle, the table "_new" wasn't deleted and when I try to delete it my application crashes.
It seems whenever I alter the original table this _new table is also changed so if it is not found it crashes.
I would like to know how can I remove this _new table.
Like many other solutions designed for an almost lockless schema change, pt-online-schema-change works by creating triggers on your table and creating a _new table. As stated in the documentation:
Any modifications to data in the original tables during the copy will be reflected in the new table, because the tool creates triggers on the original table to update the corresponding rows in the new table
If this utility crashed, you might have to do the cleanup yourself. This might include:
_mytable_new exists". However, when I view all the tables, this underscore-prepended table is nowhere to be found, and thus can't be deleted. Where do I find it?
Apr 19 at 20:10
triggerI was able to find them and kill them all.