[ERROR] InnoDB: dict_load_foreigns() returned 38 for ALTER TABLE t1
General
Escalation
General
Escalation
Description
Environment
None
AFFECTED CS IDs
277317
Attachments
1
Smart Checklist
Activity
Show:
Julia Vural March 4, 2025 at 9:00 PM
It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.
Lalit Choudhary August 23, 2020 at 1:37 PM
It crashes when using a debug build.
Won't Do
Details
Details
Assignee
Unassigned
UnassignedReporter
Lalit ChoudharyLabels
Upstream Bug URL
Affects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created August 23, 2020 at 1:30 PM
Updated March 4, 2025 at 9:00 PM
Resolved March 4, 2025 at 9:00 PM
ALTER table failed with the following error for a table with a foreign key.
Reproduciable test case:
Percona server 5.6.49
After mysql restart accessing these tables will add the following warning in mysql log.
mysql log:
Percona Server 5.7.30:
5.7 also affected with different behavior.
Restart mysql service.
mysql error log: