MySQL Forums
Forum List  »  InnoDB

Re: Foreign Key Error 121
Posted by: Nathan Alden
Date: September 17, 2007 05:54PM

I have managed to run into this problem using MySQL 5.1.21 for Windows. The steps I took were similar to the OP's. When testing my program I recreate databases many times. Somehow a foreign key (the first one to be created in my batch script) is orphaned in the ibdata1 file.

The problem may happen when, during execution of a batch, the batch fails, but only after the foreign key is created.

Options: ReplyQuote


Subject
Views
Written By
Posted
22668
April 07, 2006 08:35AM
6490
April 09, 2006 01:38PM
7544
April 10, 2006 05:52AM
4172
April 17, 2009 09:54AM
4532
April 10, 2006 07:06AM
4401
April 10, 2006 07:48AM
3858
April 10, 2006 06:06PM
5149
April 11, 2006 09:08AM
3793
April 11, 2006 02:49PM
Re: Foreign Key Error 121
3961
September 17, 2007 05:54PM
6269
September 26, 2007 09:55AM
3526
July 07, 2008 06:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.