3403
MariaDBERRORNotableForeign KeysHIGH confidence
Cannot find table in foreign key cache
Production Risk
Medium — DDL fails; foreign key integrity may be at risk if cache is corrupted.
How to reproduce
trigger — this will error
trigger — this will error
ALTER TABLE child_table ADD FOREIGN KEY (pid) REFERENCES parent_table(id);
expected output
ERROR 3403 (HY000): Cannot find table in foreign key cache.
Fix
Check and refresh table metadata
Check and refresh table metadata
CHECK TABLE parent_table; ANALYZE TABLE parent_table; ALTER TABLE child_table ADD FOREIGN KEY (pid) REFERENCES parent_table(id);
Why this works
CHECK TABLE verifies the table structure and ANALYZE TABLE refreshes the optimizer statistics cache.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3403 ER_CANNOT_FIND_TABLE_IN_FOREIGN_KEY_CACHE
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev