Bug 648622

Summary:	InnoDB: Cannot delete/update rows with cascading foreign key constraints that exceed max depth of 250
Product:	[Fedora] Fedora	Reporter:	Harald Reindl <h.reindl>
Component:	mysql	Assignee:	Tom Lane <tgl>
Status:	CLOSED DUPLICATE	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	urgent	Docs Contact:
Priority:	low
Version:	13	CC:	hhorak, tgl
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	All
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-11-01 20:21:04 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:

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 ***