Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

[ERROR] InnoDB: dict_load_foreigns() returned 38 for ALTER TABLE t1

Description

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:

 

 

  

Environment

None

AFFECTED CS IDs

277317

Attachments

1

Smart Checklist

Activity

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

Assignee

Reporter

Labels

Upstream Bug URL

Affects versions

Priority

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