[hibernate-issues] [JIRA] (HHH-15460) Review use case for disable_delayed_identity_inserts

Wilson Gee ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6305789... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzFlYjFlYzg4... ) / Task ( https://hibernate.atlassian.net/browse/HHH-15460?atlOrigin=eyJpIjoiNzFlYj... ) HHH-15460 ( https://hibernate.atlassian.net/browse/HHH-15460?atlOrigin=eyJpIjoiNzFlYj... ) Review use case for disable_delayed_identity_inserts ( https://hibernate.atlassian.net/browse/HHH-15460?atlOrigin=eyJpIjoiNzFlYj... ) Issue Type: Task Assignee: Unassigned Created: 23/Aug/2022 18:23 PM Priority: Minor Reporter: Wilson Gee ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6305789... ) We upgraded from 5.2.17.Final to 5.4.32.Final and discovered an issue with violation of foreign key constraints in MySQL InnoDB tables running 5.7.mysql_aurora.2.09.2. We discovered in the 5.4 Migration Guide ( https://github.com/hibernate/hibernate-orm/blob/5.4/migration-guide.adoc#... ) that we can revert the behavior introduced in 5.3 with the disable_delayed_identity_inserts property and that we should report our use case. An example of our logged error: 2022-02-11T21:10:11,699 severity=ERROR class=SqlExceptionHelper Cannot add or update a child row: a foreign key constraint fails (`profiles`.`profile_attributes`, CONSTRAINT `fk_type_namespace_user` FOREIGN KEY (`profile_type`, `namespace_id`, `namespace_user_id`) REFERENCES `profiles` (`profile_type`, `namespace_id`, `n) The table schemas in question (with extraneous details omitted): CREATE TABLE `profiles` ( `profile_type` tinyint(4) NOT NULL, `namespace_id` int(11) NOT NULL, `namespace_user_id` bigint(20) NOT NULL, ... PRIMARY KEY (`profile_type`,`namespace_id`,`namespace_user_id`), ... ) ENGINE=InnoDB DEFAULT CHARSET=utf8 CREATE TABLE `profile_attributes` ( `profile_type` tinyint(4) NOT NULL, `namespace_id` int(11) NOT NULL, `namespace_user_id` bigint(20) NOT NULL, ... PRIMARY KEY (`profile_type`,`namespace_id`,`namespace_user_id`), CONSTRAINT `fk_type_namespace_user` FOREIGN KEY (`profile_type`, `namespace_id`, `namespace_user_id`) REFERENCES `profiles` (`profile_type`, `namespace_id`, `namespace_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ( https://hibernate.atlassian.net/browse/HHH-15460#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15460#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100205- sha1:4a5192e )