Batara,
thank you for the bug report. I have to fix this bug when I overhaul the
foreign key constraint naming conventions.
Yes, to fix the problem you can drop the foreign key constraint manually in
the slave.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - hot backup tool for InnoDB which also backs up MyISAM
tables
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: Batara Kesuma [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 03, 2003 6:41 AM
Subject: Drop foreign key replication problem
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]