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 08, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms