Bug #56785 | InnoDB: Cannot truncate table … because there is a foreign key check running | ||
---|---|---|---|
Submitted: | 15 Sep 2010 7:46 | Modified: | 10 Sep 2018 12:13 |
Reporter: | Marko Mäkelä | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S5 (Performance) |
Version: | 5.0, 5.1, 5.5 | OS: | Any |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | foreign key, innodb, mdl |
[15 Sep 2010 7:46]
Marko Mäkelä
[13 Oct 2010 16:13]
Konstantin Osipov
Marko, for the bug to get properly verified you need to provide an SQL test case. Thanks, -- kostja
[14 Nov 2010 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[10 Sep 2018 12:13]
Dyre Tjeldvoll
Posted by developer: dlenev: after wl#6049 there are MDLs on all tables involved in FKs bin.su: After new DD, InnoDB will not truncate table by row-be-row deletion. Only re-create an empty table. Closing.