[MDEV-17430] Error message should correctly indicate corrupted foreign keys... Created: 2018-10-11  Updated: 2018-11-26

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Fix Version/s: None

Type: Task Priority: Trivial
Reporter: Juan Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: logging


 Description   

When a server has the index supporting a foreign key removed by disabling foreign key checks first, and is later re-started with foreign_key_checks=ON, attempting to read the table produces an error indicating the table does not exist:

MariaDB [t3]> select count(*) from s3;
ERROR 1932 (42S02): Table 't3.s3' doesn't exist in engine

and attempting to drop the database produces this error:

MariaDB [test]> drop database t3;
ERROR 1010 (HY000): Error dropping database (can't rmdir './t3', errno: 66 "Directory not empty")

Would it be possible for the errors to be more clearly indicative of the corruption in the table structure?


Generated at Thu Feb 08 08:36:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.