My Oracle Support Banner

MySQL Shell Util.loadDump Produced "Duplicate Key Name" Error - MySQL Error 1061 (42000) (Doc ID 2921078.1)

Last updated on JANUARY 13, 2023

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

On : MySQL SHELL 8.0.31 version, Group Replication

Can't restore by loadDump with --deferTableIndexes=all option when the table is under these conditions.

- Has AUTO_INCREMENT column
- Has secondary index associates AUTO_INCREMENT column
- Has secondary index not-associates AUTO_INCREMENT column



Changes

 

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
Changes
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.