Bug 646569

Summary:	Cascade Delete results in "Got error -1 from storage engine"
Product:	[Fedora] Fedora	Reporter:	Red Ochsenbein <red>
Component:	mysql	Assignee:	Tom Lane <tgl>
Status:	CLOSED ERRATA	QA Contact:	Fedora Extras Quality Assurance <extras-qa>
Severity:	urgent	Docs Contact:
Priority:	low
Version:	13	CC:	hhorak, h.reindl, tgl
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Linux
Whiteboard:
Fixed In Version:	mysql-5.1.52-1.fc13	Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-11-10 21:47:23 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 Red Ochsenbein 2010-10-25 17:39:53 UTC

Description of problem:
MySQL is reporting:
  ERROR 1030 (HY000): Got error -1 from storage engine

The error log is reporting:
  InnoDB: Cannot delete/update rows with cascading foreign key constraints that exceed
max depth of 250

Version-Release number of selected component (if applicable):
$ rpmquery mysql-server
mysql-server-5.1.51-2.fc13.i686


Additional info:
There is a bug filed for this in the MySQL Bugtracker.

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

Comment 1 Tom Lane 2010-11-01 20:21:04 UTC

*** Bug 648622 has been marked as a duplicate of this bug. ***

Comment 2 Fedora Update System 2010-11-02 03:45:11 UTC

mysql-5.1.52-1.fc14 has been submitted as an update for Fedora 14.
https://admin.fedoraproject.org/updates/mysql-5.1.52-1.fc14

Comment 3 Fedora Update System 2010-11-02 03:45:22 UTC

mysql-5.1.52-1.fc13 has been submitted as an update for Fedora 13.
https://admin.fedoraproject.org/updates/mysql-5.1.52-1.fc13

Comment 4 Fedora Update System 2010-11-02 22:12:57 UTC

mysql-5.1.52-1.fc13 has been pushed to the Fedora 13 testing repository.  If problems still persist, please make note of it in this bug report.
 If you want to test the update, you can install it with 
 su -c 'yum --enablerepo=updates-testing update mysql'.  You can provide feedback for this update here: https://admin.fedoraproject.org/updates/mysql-5.1.52-1.fc13

Comment 5 Fedora Update System 2010-11-10 21:47:16 UTC

mysql-5.1.52-1.fc14 has been pushed to the Fedora 14 stable repository.  If problems still persist, please make note of it in this bug report.

Comment 6 Fedora Update System 2010-11-10 21:47:49 UTC

mysql-5.1.52-1.fc13 has been pushed to the Fedora 13 stable repository.  If problems still persist, please make note of it in this bug report.