Hi,
When i try to drop a foreign key using pt-online-schema-change, it says :
Error altering new table dbname
._tablename_new
: DBD::mysql::db do failed: Error on rename of ‘./dbname/_tablename_new’ to ‘./db/#sql2-678b-a31’ (errno: 152) at ./pt-online-schema-change line 5438
On analysis, found there is no FK with the specified name in the new table which pt-osc creates to alter. ( It adds a leading underscore to the FK names in the new table ). Is this the default behaviour of pt-osc for drop fk or am i missing some thing ? If this the default behaviour, what are the other possible ways to drop Fks using pt-osc ? please help.