My Oracle Support Banner

AUTO_INCREMENT not correct after upgrading MySQL Server 5.7 to 8.0.16 or .17 (Doc ID 2575266.1)

Last updated on JULY 17, 2020

Applies to:

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

Symptoms

After upgrading MySQL 5.7 to 8.0.16 or 8.0.17, during Data Dictionary initialization the auto_increment value for some table is off by 1, which generates a duplicate key error when the first value is inserted.

 

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.