ndb_restore When Using --include-* OR --exclude-* Fails With: "Failed to create foreign key ...: 721: Schema object with given name already exists" (Doc ID 1985417.1)

Last updated on OCTOBER 05, 2015

Applies to:

MySQL Cluster - Version 7.3 to 7.4 [Release 7.3 to 7.4]
Information in this document applies to any platform.

Symptoms

Start restore a database (NDB) from a NDB Backup:

ndb_restore -d -r -m --nodeid=1 --connect=192.168.79.41:1187,192.168.79.42:1187 --include-databases=test --rewrite-database=test,testrestore --verbose=20 --backupid=2 --backup_path=/nfsbackup/1/BACKUP/BACKUP-2
ERROR:
Failed to create foreign key fk_code_hierarchy parent lisuella.hierarchy.PK child lisuella.code.FK_code_hierarchy: 721: Schema object with given name already exists
Restore: Failed while closing tables FKs

NDBT_ProgramExit: 1 - Failed

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