My Oracle Support Banner

Point-In-Time Recovery (PITR) Or Replication Fails After Changes Made With foreign_key_checks = 0: "ERROR 1452 (23000) at line ...: Cannot add or update a child row: a foreign key constraint fails (Unknown error code)" (Doc ID 2163311.1)

Last updated on MARCH 24, 2019

Applies to:

MySQL Cluster - Version 7.3 and later
Information in this document applies to any platform.

Symptoms

When trying to perform a point-in-time recovery (PITR), replaying the binary log fails with:

 

A typical case where disabling foreign key checks is required is when restoring data from a mysqldump backup.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.