Bug 648622 - InnoDB: Cannot delete/update rows with cascading foreign key constraints that exceed max depth of 250
Summary: InnoDB: Cannot delete/update rows with cascading foreign key constraints that...
Keywords:
Status: CLOSED DUPLICATE of bug 646569
Alias: None
Product: Fedora
Classification: Fedora
Component: mysql
Version: 13
Hardware: All
OS: All
low
urgent
Target Milestone: ---
Assignee: Tom Lane
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2010-11-01 19:14 UTC by Harald Reindl
Modified: 2013-07-03 03:33 UTC (History)
2 users (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2010-11-01 20:21:04 UTC
Type: ---
Embargoed:

Attachments (Terms of Use)

Description Harald Reindl 2010-11-01 19:14:04 UTC 
Description of problem:
InnoDB: Cannot delete/update rows with cascading foreign key 
constraints that exceed max depth of 250 while regular deletes


Version-Release number of selected component (if applicable):
5.1.51

How reproducible:
Delete orphan messages in dbmail, delte acoounts with mails in dbmail

Actual results:
Transaction is rolled back and database growing

Expected results:
Records are deleted

Additional info:
http://bugs.mysql.com/bug.php?id=57255

It would be glad if we get the patch in any form into fedoras mysql
I do not understand the upstream bugreport because http://dev.mysql.com/doc/refman/5.1/en/news-5-1-52.html (which is on no downloadserver) has a reference to this bug, but some minutes ago it is marked for 5.1.33
Comment 1 Tom Lane 2010-11-01 20:21:04 UTC 

*** This bug has been marked as a duplicate of bug 646569 ***
Note You need to log in before you can comment on or make changes to this bug.