Hi,
I am running a master and a slave. When I created a foreign key in
master, it looked like this:
CONSTRAINT `0_373` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
But on the slave it was like:
CONSTRAINT `0_451` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
The problem is, when I deleted this foreign key on master using command:
ALTER TABLE input DROP FOREIGN KEY 0_373
The slave produced an error:
ERROR: 1025 Error on rename of './new_atpress/input' to
'./new_atpress/#sql2-3a54-2' (errno: 140)
031203 13:27:30 Slave: Error 'Error on rename of './new_atpress/input'
to './new_atpress/#sql2-3a54-2' (errno: 140)' on query 'alter table
input drop foreign key 0_373'. Default database: 'new_atpress',
Error_code: 1025
031203 13:27:30 Error running query, slave SQL thread aborted. Fix the
problem, and restart the slave SQL thread with "SLAVE START". We stopped
at log 'borneo-bin.010' position 901130237
Versions:
MySQL 4.0.15
Linux 2.4.18
I guess this is because the constraint name difference of the foreign
keys. How do I fix this problem? Can I just manually drop the foreign
key on slave and skip this "alter table input drop foreign key 0_373"?
How to do it? Please help, and thank you very much.