MySQL Bugs: #5961: A long CASCADEs FOREIGN KEY operation in InnoDB can cause long semaphore wait

Bug #5961	A long CASCADEs FOREIGN KEY operation in InnoDB can cause long semaphore wait
Submitted:	7 Oct 2004 18:46	Modified:	30 Oct 2004 8:48
Reporter:	Heikki Tuuri	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: InnoDB storage engine	Severity:	S2 (Serious)
Version:	All	OS:
Assigned to:	Heikki Tuuri	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
See the synopsis.

Will probably be fixed in 4.0.22.

This bug was found by a user.

Regards,

Heikki

How to repeat:
Run such an operation, and in another thread CREATE TABLE.

Suggested fix:
Release the latch now and then, and after reacquiring check that the table(s) still exist.

Fixed in 4.0.22.