My Oracle Support Banner

DROP DATABASE Fails and InnoDB Asserts with "Failing assertion: !table->ibd_file_missing" After a Failed Foreign Key DDL (Doc ID 1643965.1)

Last updated on APRIL 15, 2020

Applies to:

MySQL Server - Version 5.6 to 5.7 [Release 5.6 to 5.7]
Information in this document applies to any platform.

Symptoms

On versions prior to 5.6.14 (or in version 5.7.1), MySQL crashes when doing DROP DATABASE on a database containing broken tables (missing *.ibd when required by FK).

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.